Codes & Concepts

Database

 A database is an organized collection of data or information which is stored in such a way that anyone can retrieve that data/information quickly and effectively. Database is a repository to store valuable data or information. 

To access the information stored in a database, we need a database management system i.e. DBMS. This is a collection of programs that enables you to create, select, and organize and administration of a database. It is software which is designed to achieve all the possible operations on a database.

Different types of database:

Hierarchical Databases: It is one of the oldest methods of organizing and storing data . It is commonly used on mainframe computers. A hierarchical database is organized in hierarchal structure, like the branches of a tree.

Network databases: It is almost similar to hierarchical databases as data is stored in hierarchical structure with few key differences.. Instead of looking like an upside-down tree, a network database looks more looks like interconnected network of records. This is also primarily used for mainframe systems.

Relational databases:, Most extensively used methodology in database world to store data and information. In this design, relationship between data files is relational, not hierarchical. Relational databases connect data of different files/blocks by using common data elements like a key field.

Data in relational databases is the form of tables, having a key field that uniquely identifies each row. Relational databases are more flexible than any other database type.. In relational databases, tables or files filled with data are called tuples designates a row or record, and columns are referred to as attributes or fields.

Object-oriented databases: It showed a significant advance over other database technology. It is primarily used for storing and managing Multimedia content. Object-oriented databases use small, reusable chunks of software called objects. The objects themselves are stored in the object-oriented database. Each object consists of two elements: 1) Actual data and 2) Instructions, called methods to provide information for what to do with the data.

Most popular Database these days are:

There are several other vendors also who provides enterprise Database solution but major market is captured by databases mentioned above.