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.
Please type your essay title, choose your document type, enter your email and we send you essay samples