Theatre & Films Productions

Database Systems

A student acquires a quarter of knowledge from…

Goody good morning! Have been heavily busy with Database systems these days. To my great pleasant surprise, I finally found a good book in the UoM library and the book is NEW (has been added to the QA 76 section on 2 Feb) and I am the first borrower of the book 😀 :

A preview is available on Google Books and here are the Supporting material for the Third edition. Happy Reading :)!

Well, another major update in uni student life is that now we have a new Bookshop at UoM. The company is Edition le Printemps Ltd. who is mainly located at 4 Club Road Vacoas. Welcome to UoM Reduit Campus ELP!

A brief visit at the bookshop revealed that it has a good stock of interesting Management books including this one which I was so eager to buy on eBay! Another chat with the ELP guys there suggested that they need the books list from respective departments from the university in order to place them on the shelves here. To my knowledge, lecturers make book requests at the UoM library. The latter then equip themselves with copies of the book (just like Database Management Systems book). Its maybe the books are really expensive (between Rs. 600 and Rs. 1500) that they know students will not be able to afford them in the bookshop. That’s why we, students always seek for the low price edition, at least I do buy books of the low price ed. (< Rs. 600).

Well that’s Uni student life! We  search for eBooks (free pdf version of the book), download the book slides, check for preview in Google Book Search and thankful to India for publishing the Low Price Ed. of the book! Another option is to lend the book from the respective lecturer, do photocopy and return in time with a big Thank You Smile 😀 Obviously we also Share book content/slides with classmates.

To end with, here is a quote I read somewhere:

A student acquires a quarter of his knowledge from his/her lecturer, another quarter from his/her own intelligence, another quarter from  friends, and the last quarter, in course of time, from experience”

True isn’t?

Oracle Database Foundations

An Oracle server consists of both a database and an instance. In Oracle terminology, database refers to only the physical files on disk. These are the files that store the data itself, the database state information in the control file, and the changes made to the data in the redo log files.

The term instance refers to the Oracle processes and memory structures that reside in the server’s memory and access an Oracle database on disk. One of the reasons for separating the concepts of a database and an instance is that a database may be shared by two or more different Oracle instances as part of an Oracle configuration that enhances the scalability, performance, and reliability of the Oracle server.

Database –The collection of all physical files on disk that are associated with a single Oracle instance.

It’s also important to differentiate between the logical and physical structures of the database. The logical structures represent components such as tables—what you normally see from a user’s point of view. The physical structures are the underlying storage methods on disk—the physical files that compose the database.

Instance -The collection of memory structures and Oracle background processes that operates against an Oracle database.


A logical grouping of database objects, usually to facilitate security, performance, or the availability of data base objects such as tables and indexes. A table space is composed of one or more data files on disk.

Once the Oracle software is installed on a server, you can create one or more database instances using a single copy of the Oracle software. The Database Configuration Assistant (DBCA) is Oracle’s GUI tool for creating, modifying, and deleting databases.

For the Microsoft Windows platform, each Oracle instance requires at least 256MB of memory, plus 8GB of disk space for a fairly complete installation of Oracle Enterprise Edition. Oracle strongly recommends at least 512MB of memory. The amount of disk space needed for the datafiles depends on the application’s data needs, but one of Oracle’s starter databases uses approximately 1.5GB of disk space.

PostgreSQL installation


“PostgreSQL is an Open Source object-relational database management system (ORDBMS).  As with many other open-source programs, PostgreSQL is not controlled by any single company, but relies on a global community of developers and companies to develop it.”- Wikipedia. Below is my first screencast on how to install the database on a PC running Windows XP. It is divided into 3 parts.