Facebook Pixel Code

Improving the Performance of Database Management Systems

This is a preview of the 8-page document
Read full text

Therefore, it is evident that indexing is a very useful tool used to fine-tune the databases. Nevertheless, it should be done very judiciously or else it can also backfire. Also, other factors such as the I/O, disk space, etc. should be checked importantly prior to making any changes since indexing can increase the load on the system. According to Rob and Coronel (8-35), the following are the key players that are involved in the database management system environment: • Database System Administrators are those professionals who look after the general operations in the database system. • Data Architects or Database Designers are those professionals who create the overall design of the database structure. • Database Application Administrators are those professionals who manage the overall function of the database management system and ascertain appropriate use of the database. • Database System Analysts and Programmers are those experts who create application programs and employ them into the database system. • End-Users are those persons who actually use the applications that retrieve information from the database.

Most of the organizations follow the above-mentioned structure of database experts.

Generally, the database designers are responsible for the database logical model that includes table relationships, table structures, etc. whereas the physical implementation of the logical model is in the hands of the database administrator, commonly called DBA.   System DBA’ s are responsible for the general features of the database environment such as hardware upgrades, physical implementation, partitioning, memory, etc. whereas the application DBA’ s are much closer to the database application developers. Further in this study, we will highlight the role of the DBA’ s in SQL optimization.   • Every database project should have at least one DBA formally assigned to it.   • Application Database Administrators work closely with the application developers. • Application Database Administrators also possess good functional knowledge about the database applications.   • Key responsibilities of the Application Database Administrator include a review of SQL code, guidance, and testing.  

This is a preview of the 8-page document
Open full text
Close ✕
Tracy Smith Editor&Proofreader
Expert in: Information Technology, Agriculture, Engineering and Construction
Hire an Editor
Matt Hamilton Writer
Expert in: Information Technology, Military, Technology
Hire a Writer
preview essay on Improving the Performance of Database Management Systems
x
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
WE CAN HELP TO FIND AN ESSAYDidn't find an essay?

Please type your essay title, choose your document type, enter your email and we send you essay samples

Contact Us