Construction of Drug Company Data System using Multidimensional Database Insertion

Abstract

A multidimensional database is a data warehouse that supports basically the efficient execution of complex business decision queries. Every response can be significantly improved by storing an appropriate set of Appear views of the data. These views are selected from the multidimensions whose elements represent the solution space of the problem. Techniques discussed in this paper can be implemented using relational database technology. The approach is also capable of exploiting multidimensional query processing, Techniques like aggregation, this yields a practical solution with low computational overhead,In this paper. Techniqueswe propose multidimensional databases. Dimensions, dimension hierarchies and cubes are formally introduced , furthermore; we provide a mapping of the multidimensional model to the relational model and to multidimensional arrays.the results shows much progressing speed of data insertion , decision capability , and cost reduction as well comparing with traditional data insertion.