What is DBMs or Database management system?
Stands for "Database Management System." In short, a DBMS is a database program. Technically speaking, it is a software system that uses a standard method of cataloguing, retrieving, and running queries on data. The DBMS manages incoming data, organizes it, and provides ways for the data to be modified or extracted by users or other programs. Some DBMS examples, Microsoft Access, SQL Server, FileMaker, Oracle, RDBMS, dBase, Clipper, and FoxPro. Since there are so many database management systems available, it is important for there to be a way for them to communicate with each other. For this reason, most database software comes with an Open Database Connectivity (ODBC) driver that allows the database to integrate with other databases. For example, common SQL statements such as SELECT and INSERT are translated from a program's proprietary syntax into a syntax other databases can understand.
Uses of DBMs
.Banking: For customer information, accounts loans and banking transactions.
2.Airlines: For reservations and schedule information. Airlines were among the first to use database in a geographically disturbed manner-terminals situated around the world accessed the central database system through phone lines and other data networks.
3.Universities: For student information, course registrations and grades.
4.Credit card transactions: For purchases on credit cards and generation of monthly statements.
5.Telecommunications: For keeping records of calls made, generating monthly bills, maintaining balances on prepaid calling cards and storing information about the communication networks.
6.Finance: For storing information about holdings, sales and purchase of financial instruments such as stocks and bonds.
7.Sales: For customer, product and purchase information.
8.Manufacturing: For management of supply chain and for tracking production of items in factories, inventories of items in warehouses/stores and orders for items.
9.Human Resources: For information about employees, salaries, payroll taxes and benefits and for generation of paychecks.
10.Web based services:For taking web users feedback,responses,resource sharing etc. Types of Database Management Systems
DBMSs come in many shapes and sizes. For a few hundred dollars, you can purchase a DBMS for your desktop computer. For larger computer systems, much more expensive DBMSs are required. Many mainframe-based DBMSs are leased by organizations. DBMSs of this scale are highly sophisticated and would be extremely expensive to develop from scratch. Therefore, it is cheaper for an organization to lease such a DBMS program than to develop it. Since there are a variety of DBMSs available, you should know some of the basic features, as well as strengths and weaknesses, of the major types. After reading this lesson, you should be able to:
* Compare and contrast the structure of different database management systems. * Define hierarchical databases.
* Define network databases.
* Define relational databases.
* Define object-oriented databases.
Types of DBMS: Hierarchical Databases
There are four structural types of database management systems: hierarchical, network, relational, and object-oriented.
Hierarchical Databases (DBMS), commonly used on mainframe computers, have been around for a long time. It is one of the oldest methods of organizing and storing data, and it is still used by some organizations for making travel reservations. A hierarchical database is organized in pyramid fashion, like the branches of a tree extending downwards. Related fields or records are grouped together so that there are higher-level records and lower-level records, just like the parents in a family tree sit above the subordinated children. Based on this analogy, the parent record at the top of the pyramid is called the root record. A child record always has only one parent record...