Home Forums Official Forum- Navsingh Advanced Databases Database management systems (DBMS)

This topic contains 1 reply, has 1 voice, and was last updated by  Sambo 2 years, 9 months ago.

  • Author
  • #3035 Reply


    Database management systems (DBMS) are computer software applications that interact with the user, other applications, and the database itself to capture and analyze data. A general-purpose DBMS is designed to allow the definition, creation, querying, update, and administration of databases. Well-known DBMSs include MySQL, PostgreSQL, Microsoft SQL Server, Oracle, Sybase and IBM DB2. A database is not generally portable across different DBMSs, but different DBMS can interoperate by using standards such as SQL and ODBC or JDBC to allow a single application to work with more than one DBMS. Database management systems are often classified according to the database model that they support; the most popular database systems since the 1980s have all supported the relational model as represented by the SQL language. Sometimes a DBMS is loosely referred to as a ‘database’

  • #3036 Reply


    Application areas of DBMS

    1. Banking: For customer information, accounts, and loans, and banking transactions.

    2. Airlines: For reservations and schedule information. Airlines were among the first to use databases in a geographically distributed 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. Telecommunication: 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 purchases 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.

Reply To: Database management systems (DBMS)
Your information: