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 126
- Downloads 0
METHOD OF PLACING THE DETECTORS OF WIRE-WIRELESS FIRE ALARM SYSTEM INSIDE THE BUILDING
The article considers the developed method of placing fire detectors inside a building to build efficient wire-wireless fire alarms. The analysis of technical problems arising during the construction of a fire network is...
THE ESTABLISHMENT OF A REGISTRATION SYSTEM THE EFFECT OF DEFLECTION OF THE FLUID FLOW
In result of the conducted researches it is proposed the creation of a system monitoring the occurrence of the Coanda effect to reduce accidents and improve the system dynamic positioning semi-submersible drilling rigs....
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...
DIGITAL CERTIFICATES FORMOBILE PHONE OWNERS
Every cell phone owner’s written a number of important information on it that is hard to restore. An important task is to find the lost phones. This article discusses the mobile devices with the Android operating system...
INVESTIGATION OF METHODS OF PREVENTING THE DISCLOSURE OF AN IP-ADDRESS WITHAN ACTIVE VPN-CONNECTION
For secure operation on the Internet, you can use different types of connection. One type of such connections is VPN connections. It allows you to tunnel all incoming/outgoing traffic, encrypt it. However, when the VPN c...