iserc.ie - Software Engineering Research Information

Wednesday, October 18th, 2017

Databases


"Only wimps use tape backup: _real_ men just upload their important stuff on ftp, and let the rest of the world mirror it" - Linus Torvalds


Databases are used to store information in a computer system. The main target is to let computer programs have random access on records of data, to synchronize the data for several programs and handling access.

There are the following main implementation types of Databases:

  • Relational Databases: A Relational Database is consisting of relations (tables with fields and relations between them), conforming to the relational model.
  • Flat File Databases: A File in the file system consisting of records, usually with a fixed file format.
  • Deductive Databases: Deductive Databases are storing rules and facts, and can make deductions basing on them.
  • Dimensional Databases: Extending the Tables of the Relational Databases with one or more additional dimensions (f.i. Time, Region).
  • Hierarchical Databases: Organizes Data into a tree structure. Information is represented as parent/child relationships.
  • Object oriented Databases: Information is represented as objects as they are used in Object-Oriented Programming. Data is encapsulated with functions, messages and so on.
  • Temporal Databases: Temporal Databases are a DBMS with additional time information stored for the data.