The Computer Revolution/Software/Database

From Wikibooks, the open-content textbooks collection

Jump to: navigation, search

reserved for group 4

[edit] Database management system

The Database management system (DBMS)is a collection of interrelated data together with a set of programs to access the data, also called database system, or simply database. A major purpose of a database system is to provide users with an abstract view of the data.That is, the system hides certain details of how the data are stored and maintained. Thereby, data can be stored in complex data structures that permit efficient retrieval, yet users see a simplified and easy-to-use view of the data. The lowest level of abstraction, the physical level, describes how the data are actually stored and details the data structures. The next-higher level of abstraction, the logical level, describes what data are stored, and what relationships exist among those data. The highest level of abstraction, the view level, describes parts of the database that are relevant to each user; application programs used to access a database form part of the view level. [[1]]

Free DBMS software

~Berkeley DB

~MySQL

~mSQL

~Firebird

~PostgreSQL

~SAP DB

~Xindice

~Apache Derby

~SQLite

~HSQLDB

[edit] Database External

[edit] Database Internal