Posted on August 28th, 2007 by
There are basically two types of databases
1) flat-file
2) relational
The usage and the aptness is dependent on the type of data and the quantity of data which is to be processed and how frequently it will be brought to use.
Flat-File
The simple data can be stored in this type; they are perfect for a little bit of […]
Filed under: Databases, General | No Comments »
Posted on August 25th, 2007 by
To keep related data together, the best way to set up an organized database is by setting up multiple tables. For e.g. in a news site, we keep news with news separated from authors, blogs separated from news. It is easy because then it is easy and quicker for the database to locate the related […]
Filed under: Databases | No Comments »
Posted on August 22nd, 2007 by
The speeding up of retrieval of the data in a database is the work of a database index. They help in organizing and thus easing up the work of the database, thus speeding up the process of retrieval as the data is mainly put into simple organized indexes, the load on the server is also […]
Filed under: Databases | No Comments »
Posted on August 19th, 2007 by
If you plan to have comments on the news articles, then they will need a separate indexing of who the author is, what is his contact, whether he is a member or not and so on and so forth. Whether you want only existing authors to be able to make comment or you want to […]
Filed under: Databases | No Comments »
Posted on August 16th, 2007 by
Introduction
Databases are omnipresent everywhere, many a times without us realizing their presence. Take the example of a telephone directory, it is also a database, but we rarely realize it, it stores numbers, grids, addresses, names. Databases are convenient in a way that they allow us to quickly search the information and also are great […]
Filed under: Databases | No Comments »