This paper discusses the problem of minimizing the response time for a given database workload by a proper choice of indexes. The main objective of our contribution is to illustrate the database queries as a group and search for good indexes for the group instead of an individual query. We present queries block relation conditions for applying the concept of grouped queries index selection. In three experimental tests we provide measurements on the quality of the recommended approach.
Applied Computer Science Volume 8, Number 2, 2012
INDEXES SELECTION FOR BLOCKS OF RELATED SQL QUERIES
ANALISYS OF VARIABILITY OF THE FAMILY OF PACKAGES AND THE VERSATILE PACKAGING MACHINE DESIGN
The article provides design and engineering analysis of groups of packages. The relationship between the functional units of packaging machines and related groups designs packages is traced. The method for calculation of the versatility rate of the packaging machine depending on its structure is offered.
LOCAL CRM APPLICATION FOR BILLBOARD ADVERTISING COMPANY
The article presents development process of dedicated application that supports Customer Relationship Management. The software receiver is a small advertising company, whose main service is renting billboards. Implementation of CRM system inclines to further expansion of the application Transfer of implemented system into area of Cloud Computing is considered.
A GALERKIN APPROXIMATION METHOD INCLUDING SPACE DIMENSIONAL REDUCTION - APPLIED FOR SOLUTION
A multivariate data fitting procedure, based on the Galerkin minimization method, is studied in this paper. The main idea of the developed approach consists in projecting the set of data points from the original, higherdimensional space, onto a line section. Then, the approximation problem is solved in the resulting one-dimensional space. The elaborated recipe can be designed so that it is computationally more efficient than the schemes based on the least squares minimization. The performance of the method is studied by comparison with the least squares and the moving least squares procedures in a number of examples, including the solution of the heat diffusion equation.
MATHEMATICAL MODEL OF IDENTIFICATION AND AUTOMATION THE PROCESS OF SHAFT MACHINING IN ELASTICDEFORMABLE CONDITION
The specification of the low rigidity parts machining process is consider by introducing suitable equations of constrains, which describe additional elastic deformations in one of equations describing the force controlling influence. This paper introduces general and detailed mathematical models of the DS of turning the longitudinal, low rigidity shafts. Research results and examples of their approximation were introduced. Some method of synthesis and examples structure of regulator P were shown for one detailed model of DS under received approximated operational transmittance of DS. The way of controlling the accuracy of shafts turning in the elastic deformable condition and controlling system was described.