Database:
Coherent collection of data records is called database.
Explaining what is Database in simple words to a layman:
Database is like an almirah with different compartments with specific labels on each one of them. Whenever you want to take out or put in something, you first search the compartment and then take out or put in required things from/to the compartments.
Database Management System (DBMS):
The software that allows the users to insert, update and delete records is called database management system. It is a program that allows us to work on large data without any problems.
Uses of DBMS:
· As a backend in traditional database applications(i.e., in Bank accounting, maintain student data in universities, ticket reservation systems, movie data bases)
· As a backend for large web sites and frequently used in web services.
Some of the database systems available in the market:
· Database systems from big commercial database vendors
§ Oracle from oracle corporation
§ DB2 from IBM
§ SQL Server from Microsoft
§ Sybase
· Open source or Free database systems
§ PostGreSQL
§ MySql
§ Predator
What is Database Management:
Doing operations like insertion, deletion and updation is called managing the database.
Types of database based on the storage:
In general data can be stored in three deferent ways they are
· In the form of tree structure
· In the form of tables(Relations)
· In the form of objects
The databases that use the tree format storage are called hierarchical database management systems.
The databases that use the table format storage are called relational database management systems (RDBMS).
The databases that use the object type format storage are called object oriented database management systems (ODBMS).
Types of database based on distribution:
If the data is stored at a single computer site then it is called centralized database.
If the database and DBMS software are distributed over many sites then the database system is called distributed database system.
If the database system uses the same DBMS software at multiple sites then the database system is called homogeneous database system.
