COMPARATIVE ANALYSIS OF OLAP-SYSTEMS BUILDING METHODS USING MS SQL SERVER AND ORACLE
Journal Title: Наукові праці. Серія "Комп’ютерні технології" - Year 2016, Vol 283, Issue 271
Abstract
The article is considering some problems, related to big data amounts storing and processing, expounding data warehouses conception and methodology of future accounting creation with using of on-line analytical processing data analysis technologies (OLAP). Also, it is determined role and place of OLAP technologies in information management systems, such is Enterprise Resource Planning System (ERP), as a standard tool of business intelligence. Authors are arguing actuality of OLAP technologies using, which is predefined by orientation to possibility of data warehouse unregulated queries processing. It is marked, that OLAP technologies implementation demands an additional resources, such as investments to the expensive software and increasing educational level of their employees. That is why comparative analysis of program services (modules), which now are presented on the market of program tools, is actual. The analysis of OLAP-cubes creation methods and technologies was made. Authors also have done general review of OLAP-systems architecture, OLAP tools categories, multidimensional data model and OLAP-technologies implementation in MS SQL Server. There were considered an existing approaches of data analysis units realization and usage by different multidimensional databases manufacturers, such as Microsoft, SAP, Oracle, SAS Institute, Microstrategy and so on. It was analyzed methods and OLAP-technologies in Oracle Database 11g, EssBase and their components. The comparative analysis of OLAP methods and tasks was made, including database management systems SQL Server and Oracle. As a result, it was given a set of recommendations for using one or another database management system, depending on input conditions.
Authors and Affiliations
M. Fisun, A. Yuhatov
Keywords
Related Articles
- EP ID EP226018
- DOI -
- Views 105
- Downloads 0
DISTRIBUTED DATABASE STRUCTURE DESIGN BASED ON SQL-QUERY PARSING
In measures of research, the specificity of operational records associated with the transition from local to distributed database was discussed. This trend is motivated by the presence of different accounting types, by e...
ALGORITHMS FOR OPERATIONS ON PROJECTION-MATRICES OF ( ) CnM
The rapid development of integrated systems of computer mathematics for PCs affected most intellectual sphere of human activity – especially solving complex mathematical and scientific-technical problems, problems of fie...
THE GEOMETRIC IMAGE OF THE DISEASE IN N-DIMENSIONAL SPACE
It is considered the way of patients’ medical visual health monitoring by the sensor, which summarizes the data from various another sensors. The system warns the transition of one of the parameters a certain limit, as w...
APPLICATION OF MACHINE LEARNING METHODS IN DRILLING AUTOMATION TASKS
Most modern drilling machines are not able to drill composite materials (CM) automatically with preservation a drill against breakages. The proposed effective learning algorithm is able to manage com-plex hardware device...
DEVELOPMENT OF LOW-COST MULTIMEDIA LEARNING CLASS
The new approach to the development of multimedia learning class in university is proposed. It allows implementing class based on devices with low computation abilities, which means decreasing total cost of the class. De...