Dbms
DBMs
2013
3/14/2013
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
2013
3/14/2013
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