earticle

영어

Functional indexes are an important tool for database tuning, often not appreciated by programmers and system administrators. In practice, a programmer can only advise the deployment team such such indexes. Only a few very expensive systems have tools for the analysis of performance and automatic creation of functional indexes. The authors decided to provide the ability to define `functional indexes at the stage of application development by supplying the appropriate API in object-relational mapping level, and implemented it as an extension for Hibernate. The interfaces proposed by the authors were developed with the functional indexes generator for selected DBMS: PostgreSQL, Oracle and IBM DB2. In addition, to facilitate the work of programmers, HQL query analysis algorithms detecting the usefulness of functional indexes in queries have been developed.