Tuesday, July 23, 2013

What is Database management and DBMS?

Database Management entails managing the speed and efficiency with which a database supplies answers to end user queries. Database Management tools help database administrators maintain smooth, rapid, uninterrupted access to shared databases. Database management tools can help database administrators keep vital business data protected and available to end users and applications.




 Database management involves the monitoring, administration, and maintenance of the databases and database groups in your enterprise. Enterprise Manager is the premier tool for managing your database environment.

With Enterprise Manager, you receive:
  • A complete set of integrated features for managing Oracle Databases.

  • Unparalleled scalability that lets you manage a single database or thousands of instances.

  • An intuitive management product that leads the industry in ease of deployment and use.


    What is DBMS ?

     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 cataloging, 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 include MySQL, PostgreSQL, 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.

No comments:

Post a Comment