CASPIAN JOURNAL
MANAGEMENT AND HIGH TECHNOLOGIES
THE USE OF SET THEORY FOR THE DATA MANAGEMENT OF THE INPUT RELATIONAL DATABASE
 |
Read | Melikov Alexey V. THE USE OF SET THEORY FOR THE DATA MANAGEMENT OF THE INPUT RELATIONAL DATABASE // Caspian journal : management and high technologies. — 2011. — №4. — pp. 16-22. |
Melikov Alexey V. - Master in Engineering and Technology, Penza State University, 40 Krasnaya str., Penza, 440026, Russia, MelikovAlexey@mail.ru.
In this investigation consideration of data organization for the input relational database of information questionnaire system is given. The data organization of the relational database is necessary for its further transferring to the multidimensional data analysis system. The data should be organized into the required structure that would meet the requirements of the analyzed data storage. Set theory is used for the data organization into the required structure. The data is considered as separate sets that are operated in order to acquire the final data set. After final data set acquisition from the input relational data base the data needs to be organized according to the multidimensional data model readings. Data organization for a particular dimension is performed in a collection of sets, whose elements are all possible subsets of the selected set, which is determined by the level of detail. This organization is necessary for the further data analysis, depending on the level of detail; the informational analysis may be performed in the ways that were not provided by the original programmer. In addition, the hierarchies in the dimensions of the data model described are needed to both perform the data analysis operations and structure the headings of the user’s view. In case we use the theory of sets to organize the data into the desired structure, the time needed for formation of the scheme of a new multidimensional data model will be reduced.
Key words: informational questionnaire system,relational data base,multidimensional data analysis,data aggregation,level of detail,set theory,set operation