Question

Both database management systems (DBMS) and operating systems (OS) provide access to files and implement optimizations for file data access. A DBMS provides significantly better performance for data in databases. How does the DBMS do this? What information does it use? How does it optimize access? Provide some examples

Answer 1

Database management systems (DBMS) and operating systems (OS):

• In database management systems is accessing maximum of data stored   in files. Performing index tables very frequently database access is very fast. In database management systems by increasing database buffers cache database performance increased.

• Since database data files are scanning to multiple drives in server will increase performance. Suppose in oracle table space are created in “d “drive and  “e” drive with multiple attachment  data file performance increase.

• Purging old data from database and re-indexing will increase performance of the database. Restarting database quit often monthly once also increase database.