A database is a program specially designed for storing and recalling data effectively. Databases are often a major component of a larger application as most programs store and interpret information of some type. Because of this, major databases provides easier programming language integration, such as for example MySQL integrating to C, C++, Java, Ocaml and Ruby, PostgreSQL to C, C++, Python etc.
Flat file Edit
The flat file database is the most simple method of storing data, but is inefficient if data needs to be changed. It is a text file, where one row represents one unit of data, and where entries within each row are delimited either by spacing or by a character. It is not normally indexed.
One of the most effective usages of flat-files is for a write-only log. In all other cases, you should consider using any other database system.
Relational databases Edit
Relational databases are the predominate type of database that is in use today. It stores all its information in tables, where a table is a set of rows and each row contains data of specific types determined by the columns of the table. For example a table named beer is defined to store
- the name of the beer, stored as 32 unicode chars,
- the land of origin, stored as 16 unicode chars,
- the alcohol percentage, stored as float
- the brewery, stored as 48 unicode chars
so that a few table rows might look like:
name | land | percent | brewery --------------------+----------+---------+----------------------- Boddington Pub Ale | UK | 4.7 | Inbev UK Lim. Sarek 5.2 | Sweden | 5.2 | Carlsberg Falcon Export 5.2 | Sweden | 5.2 | Carlsberg
Object-oriented databases Edit
Schema-less databases Edit
See Also Edit
External Links Edit
- Database on Wikipedia