Database management system (DBMS)

A DBMS is a set of software programs that controls the organization, storage, management, and retrieval of data.

A database is a collection of permanently stored data used by an application or enterprise. A database contains logically related data, which means that the database was created to represent the real-world.

Relational databases are solidly founded on Set Theory and are based on the Relational Model, which is a set of principles for relational databases formalized by Dr. E.F. Codd in the late 1960s.

• Oracle Database
• DB2
• SQL Server

The databases were born to insert into.

• Relational Database - IBM System R

Multidimensional databases, generally smaller and minder scalable than relational databases, offer sophisticated analytic capabilities. By integrating data from a relational database in an Multidimensional database, you can leverage the scalability of the relational database with the analytic power of the multidimensional database.

• The Multidimensional Database
  • Oracle Olap
  • Oracle Hyperion - Essbase

• Excel
• OpenOffice

• Datawarehouse - Physical database installation guideline

• Database - Stored procedures

• ODBC - Open Database Connectivity
• Database - Java Database Connectivity
• Database - Call level interface (CLI)

• Database - ACID
• Database - Lock
• Database - Replication
• Application - Concurrency
• Database - Query Optimizer (Query Optimization)
• Database - Transaction