Topics: Database, Relational model, SQL Pages: 13 (4139 words) Published: April 19, 2014
One of the technology terms that most people have become accustomed to hearing either at work or while surfing the Internet is the database. The database used to be an extremely technical term, however with the rise of computer systems and information technology throughout our culture, the database has become a household term. A database is a structured collection of records or data that is stored in a computer system. In order for a database to be truly functional, it must not only store large amounts of records well, but be accessed easily. In addition, new information and changes should also be fairly easy to input. In order to have a highly efficient database system, a program that manages the queries and information stored on the system must be incorporated. This is usually referred to as DBMS or a Database Management System. Besides these features, all databases that are created should be built with high data integrity and the ability to recover data if hardware fails. Types of Databases

There are several common types of databases. Each type of database has its own data model (how the data is structured). They include Flat Model, Hierarchical Model, Relational Model, and Network Model. The Flat Model Database

A flat database is a simple database system in which each database is represented as a single table in which all of the records are stored as single rows of data, which are separated by de limiters such as tabs or commas. The table is usually stored and physically represented as a simple text file. 

Because of the limitations of flat databases, they are not unsuitable for most software applications in which there are a need to represent and store complex business relationships. However, some application developers still use flat files in order to reduce the cost and complexity of integrating a relational database.  Unlike relational databases, flat databases cannot represent complex relationships between entities. They also have no way of enforcing constraints between data. For instance in an application used by a commercial bank, it is a good idea to ensure that, at the time of creation, a new account must be linked to an existing customer. In a relational database this is easily enforced using the concept of foreign keys to ensure that customer IDs are filled in while creating an account, and also that said customer IDs already exist in another table. This is not possible with flat databases, which means that such a constraint has to be enforced by other means, such a through application code logic.

Another limitation of flat databases vis-a-vis relational databases is the former's lack of query and indexing capability. SQL queries cannot be written in flat databases because the data is not relational, and indexes cannot be created because the data is all lumped together in one table. Data in a flat database is typically only readable by and useful to the software application associated with the database.

Flat databases are, or should only be, created for small, simple databases that will never grow large enough for the limitations outlined above to really become a problem. Some real-life examples of flat databases are contact lists in a mobile phone and the storage of a high-scores list in a simple video game. In such cases, there would be little point and no justifiable expense in integrating a complex relational database engine into the computing platform because a simple flat database will do nicely. The Hierarchical Model Database

The hierarchical model database resembles a tree like structure, such as how Microsoft Windows organizes folders and files. In a hierarchical model database, each upward link is nested in order to keep data organized in a particular order on a same level list. A hierarchical database is a design that uses a one-to-many relationship for data elements. Hierarchical database models use a tree structure that links a number of disparate elements to one "owner,"...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Project Scenario for Database System Essay
  • Database Essay
  • Essay about History of Database Technology
  • Essay about Database
  • Database Technology Essay
  • Database Essay
  • database Essay
  • Database Essay

Become a StudyMode Member

Sign Up - It's Free