Title :
A database optimization method based on program business logic adjustment
Author :
Lixia Liu ; Xiaohua Qiu
Author_Institution :
Dept. of Inf. Eng., Eng. Univ. of CAPF, Xi´an, China
Abstract :
Most system developers pay little attention to program business logic might impact on system performance in the database adjustment and optimization process. Based on summary of database optimization manners, they are divided into five levels according to optimization objects. The concept of logical optimization of program business was brought out. It is indicated that the method can produce significant optimization effect similar to other methods. A practical example was given to illustrate optimal design method on program business logic in accordance with database. The operation result also proves that the proposed method can improve program performance significantly.
Keywords :
database management systems; logic programming; database adjustment; database optimization method; logical optimization; optimal design method; program business logic adjustment; program performance improvement; system development; system performance; Business; Indexes; Optimization methods; System performance; Tuning; business logic optimization; database optimization; tuning level;
Conference_Titel :
Progress in Informatics and Computing (PIC), 2014 International Conference on
Conference_Location :
Shanghai
Print_ISBN :
978-1-4799-2033-4
DOI :
10.1109/PIC.2014.6972370