StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Commercial OLAP Tools Functions And Limitation - Essay Example

Cite this document
Summary
This essay "Commercial OLAP Tools Functions And Limitation" is about handling multidimensional data sets. To form a multidimensional array, the OLAP system must receive source data from other systems…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER91.4% of users find it useful

Extract of sample "Commercial OLAP Tools Functions And Limitation"

mmerсiаl ОLАР tооls functions and limitation Name Institution Course Tutor Date Multidimensional OLAP It is the implemented operation in the multidimensional data. It advances the OLAP operations to the MDBMS. It is efficiently suited to store, manage, and analyse the multidimensional information (Mühlbauer, Rödiger, Reiser, Kemper, & Neumann, 2013, 499). There are proprietary techniques applied in the MDBMS. The MDBMS and its applicants see the stored information as a 3-dimensional cube or the data cube. The MOLAP databases are faster compared to the relational OLAP competitors (Connolly, & Begg, 2015, 12). The data cubes are kept in memory known as the Cube Cache. Its schema is the user data cubes and for there to be some additional dimensions, there has to be regeneration of the data cube. It has very high resources and is faster in the case of small and medium data sets (Moussa, & Badir, 2013, 246). The MOLAP implements the multidimensional view through the storage of data in a unique multidimensional data structure. Example of the vendor using this OLAP server is Oracle Corporation. It is accessibility is limited to the pre-defined dimensions. Its scalability and flexibility are low. The fact that it supports the predictive analysis operations like forecasts, what-if-scenarios, and models makes MOLAP to be optimized in the performance of a single-row computations. For the developers to manage to develop SQL, they have to understand the MOLAP language, which accustoms them. The amount of data that the OLAP server can handle limits its functioning since computations are only conducted the moment a cube is built, thus limiting the inclusion of large amount of data in a specific cube. Only the summary level data can be incorporated in the particular cube. Relational OLAP It is the advanced RDBMS containing the multidimensional data mapping to the standard relational conducts. This is a hybrid approach to the resolution whereby the aggregated summations are kept in a multidimensional database. On the other hand, the detail information is stores in the rational database. This marks the balance occurring between the performance of the MOLAP model and the data efficiency of the ROLAP model. The OLAP offers functionality through the use of rational databases, as well as the relational query equipments to keep and examine the multidimensional data (Connolly, & Begg, 2015, 14). The OLAP also builds on the present relational technologies and stand for extension to the entire companies that applied the already applied RDBMS. There is the multidimensional data schema shore up in the RDBMS. Ultimately, the data available language and question performance are optimized for the multidimensional information (Mühlbauer, Rödiger, Reiser, Kemper, & Neumann, 2013, 500). There is provision of prop up for all the large databases. The ROLAP uses the star schema and it is possible to add some more dimensions. Its size ranges from medium to large and architecture depends with the server or the client. Accessibility to the OLAP is through the support of ad-hoc request (Moussa, & Badir, 2013, 248). It has high scalability, flexibility, and resources, thus improving its speed and making it good for use with some small data sets. In the ROLAP server, the data is kept in tables in connection to the database or the advances relational databases. The ROLAP vendor is the RDBMS for the management of the warehouse data, as well as aggregations applying a star schema. Among the vendors using the OLAP serve are; Microstrategy. Applix, and Business objects (Shioi, & Hatano, 2016, 167). It limitation is that it is direct to the cells. There is also limited SQL functionalities because of relying on the generation of SQL statements to the query in the connection to the database. The SQL statements fail to meet all the needs, thus making the ROLAP technologies to be traditionally restricted by the operations of the SQL. Hybrid OLAP HOLAP technologies are applied in leveraging cube technology for enhance performance. It enables the mode designers to make choices associated with the appropriate portion of the information that will be kept in the MOLAP and the data to be stored in the ROLAP. The database tends to divide data within the rational, as well as specialized storage (Mühlbauer, Rödiger, Reiser, Kemper, & Neumann, 2013, 500). The HOLAP database normally applies a relational table to keep the larger amounts of detailed data. It also applies some specialized storage to acquire at least various aspects of the minor amounts of more aggregate or the less-detailed information (Connolly, & Begg, 2015, 54). HOLAP operates through addressing the shortcomings of the ROLAP and MOLAP through the combination of the two OLAPs capacities (Moussa, & Badir, 2013, 250). Ultimately, the HOLAP techniques are able to use the relational data sources and the pre-calculated cubes. It is possible for the OLAP to perform complex calculations and they have to be pre-generated during the moment the cube is generated. It is possible to handle large amounts of data. It also offers the necessary support to the predictive analysis operation including the forecasts, models and the what-if-events (Shioi, & Hatano, 2016, 167). It manages to leverage functionalities intrinsic in the relational database and is possible to continue applying the present technology. In the vertical partitioning, the HOLAP keeps the aggregations of the MOLAP for the quick query conduct, and more composed data in the ROLAP to positively predict time of processing a cube (Connolly, & Begg, 2015, 55). In the horizontal partitioning model, the HOLAP manages to store some amounts of data, normally the most current one in the MOLAP for speedy query performance, and the past or traditional data in the ROLAP. Additionally, vendors can store a number of dices in MOLAP and the rest in the ROLAP, controlling the actuality that in the major cuboid, it will be possible to have crowded and barely distributed sub-regions. Holos was the initial product in the provision of HOLAP, although this technology tend to be accessible in the rest of the commercial products like Oracle database OLAP option, SAP AG BI Accelerator, Microsoft Analysis Services, and Microstrategy. From the fact that HOLAP model tends to combine the MOLAP and ROLAP technology, it gains from the enormous scalability from the ROLAP and the quicker computation of the MOLAP. A good example is whereby HOLAP server permits bulky volumes of detail information to be kept in a relational database and on the hand, the aggregations are stored in a different MOLAP store (Moussa, & Badir, 2013, 254). The HOLAP a choice to materialized opinions for the generation and storage of the aggregated data. The hybrid OLAP serve acquire great support from the Microsoft SQL Server 7.0 OLAP Services. The vendors using this server include; SAP AG, Infor, Sartesis (SAP), and Cognos. Desktop OLAP This is the OLAP with the capacity to communicate with DESKTOP and is based on the fact that the server is able to download a certain section of the OLAP model from a different source or database. It operates with the specific set of data locally, or even in the desktop (Shioi, & Hatano, 2016, 167). It is easier for one to deploy the DOLAP because it contains a cheaper price although it is associated with some limited functionality when compared with the rest of the OLAP applications (Mühlbauer, Rödiger, Reiser, Kemper, & Neumann, 2013, 501). It is a single-tier and this enables it to download small hypercube from a major point from a data warehouse or from a data mart. The DOLAP performs multidimensional analyses especially the moment it is disconnected from its source (Connolly, & Begg, 2015, 57). The cubes have some summarized information, which is prearranged in a fixed structure of the proportions. The OLAP stores its data in client-based files and provides the necessary support to the multidimensional processing through the client multi-dimensional engine. The server is rational for some efficiently understood and recurring analysis questions during the reporting process (Mühlbauer, Rödiger, Reiser, Kemper, & Neumann, 2013, 502). The user of this server is possible to manipulate and pivot the data locally through the returned result data set that is kept on the desktop, thus becoming user friendly. It enhances efficient query performance through the collection, aggregation, and calculation of data prior to the conduct of analysis. The DOLAP requires only minor extracts of data to be held by the client’s machines. The distribution is conducted in advance and the creation practices conducted as per the demand through the Web. The OLAP data is kept on the desk or in the RAM, whereby various DOLAP products enable only read accessibility (Moussa, & Badir, 2013, 253). Most of the vendors of the DOLAP use the power of the desktop PC to conduct their functions. Its administration is normally performed using the central server or the processing routine that makes the data ready in the cubes and enables the data sets to be available for all the users. It is applicable in the mobile applicants who do not manage to unite to the data warehouse regularly (Connolly, & Begg, 2015, 58). The thin client machines are majorly in use for the server architecture and in the traditional web. The examples of the vendors in the DOLAP include Brio, Oracle, Cognos, Crystal Decisions, Business Objects, and Hummingbird. The data sets in the server are restricted by the boundaries distinct by the applicant without the accessibility to the granular data. It has low functionality and its data capacity is minimal. There has to be appropriate security control for the DOLAP environment to be efficient for functionality. This requires the limitation of information that is kept in every cube (Shioi, & Hatano, 2016, 169). There is also the reduction of the power used in the deployment and maintenance of the DOLAP tools. Reference Connolly, T. M., & Begg, C. E. 2015. Database systems. A practical approach to design implementation and management. global ed. Retrieved from; http://www.palinfonet.com/download/software2/database%20systems.pdf Moussa, R., & Badir, H. 2013. Data Warehouse Systems in the Cloud: Rise to the Benchmarking Challenge. IJ Comput. Appl., 20(4), 245-254. Mühlbauer, T., Rödiger, W., Reiser, A., Kemper, A., & Neumann, T. 2013. ScyPer: A Hybrid OLTP&OLAP Distributed Main Memory Database System for Scalable Real-Time Analytics. In BTW (pp. 499-502). Shioi, T., & Hatano, K. 2016. Rule-and Cost-Based Optimization of OLAP Workloads on Distributed RDBMS with Column-Oriented Storage Function. In Future Internet of Things and Cloud Workshops (FiCloudW), IEEE International Conference on (pp. 165-170). IEEE. Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(Commercial OLAP Tools Functions And Limitation Essay Example | Topics and Well Written Essays - 1500 words, n.d.)
Commercial OLAP Tools Functions And Limitation Essay Example | Topics and Well Written Essays - 1500 words. https://studentshare.org/information-technology/2055677-commrcial-olap-tools-functions-and-limitation
(Commercial OLAP Tools Functions And Limitation Essay Example | Topics and Well Written Essays - 1500 Words)
Commercial OLAP Tools Functions And Limitation Essay Example | Topics and Well Written Essays - 1500 Words. https://studentshare.org/information-technology/2055677-commrcial-olap-tools-functions-and-limitation.
“Commercial OLAP Tools Functions And Limitation Essay Example | Topics and Well Written Essays - 1500 Words”. https://studentshare.org/information-technology/2055677-commrcial-olap-tools-functions-and-limitation.
  • Cited: 0 times

CHECK THESE SAMPLES OF Commercial OLAP Tools Functions And Limitation

Impact of Data Warehousing and OLAP Models on Management Accounting

This dissertation "Impact of Data Warehousing and olap Models on Management Accounting" intends to analyze the impact of the olap and data warehouses on the management accountant in an organization.... hellip; The research question has been chosen to be  “What are the impacts of the Data Warehousing and olap Models on Management Accounting?... To analyze this question, qualitative data in the form of a questionnaire were collected from specific participants who are directly involved in such olap....
65 Pages (16250 words) Dissertation

Data Warehouse Design and Implementation

In this scenario, data warehousing offers effective tools for maintenance, storage and retrieval of data.... Introduction A data warehouse is normally recognized as an integrated and time-varying set of information and data that is basically used for strategic decision making through olap (online analytical processing) methods....
9 Pages (2250 words) Research Proposal

Systems and Operations Management of Airbus

CockpitAirbus used similar cockpit layout, procedures and handling characteristics at A380 with those of A320 and A340 families, which include overall cockpit layout (screens and controls arrangement, dark cockpit, color coding), flight envelope protection, side sticks, non-back-driven thrust levers and FMS 2nd generation as FMS functions baseline....
14 Pages (3500 words) Assignment

E-Books in Todays World and Their Future

Printed books have a long history behind them, but it was not until Johannes Gutenberg's invented his printing press that books became widely spread.... In the 19th century, creation of the industrial techniques of paper manufacturing negatively affected the quality and longevity of printed books....
14 Pages (3500 words) Essay

Research paper in Information technology articals

Information Technology is a rapid growing subject that undergoes upgradation and innovation from time to time.... Hence it is essential… This research paper delves deep into three latest reports in the field of virtualization, networking and security in operating system. ... ... he article nder research reports about the new version of Microsoft's sleek and strong server operating system which is enhanced in options by virtualization, networking and security....
5 Pages (1250 words) Essay

Web Based Library System Management with Business Intelligence

The author of the current research paper "Web-Based Library System Management with Business Intelligence" mentions that today is a digital age or rather now the age is of World Wide Web and what would be more useful to bring online then the information centres of institutes.... hellip; Libraries are integral and important part of any organisation and in this age of information, it has become important to design them in a way that they are lesser intricate, more user-friendly, accommodate a vast collection of books and journals and can be accessed from anywhere despite the long distance....
45 Pages (11250 words) Research Paper

Critical Appraisal of Software Tools in a Commercial Environment

This research paper "Critical Appraisal of Software tools in a Commercial Environment" focuses on identifying the benefits and issues of using management software tools in business decision making.... The use of software tools has benefited businesses in carrying out activities easily.... hellip; This particular study focuses on the implementation of management software tools in the business process along with understanding the benefits that are derived from the same....
13 Pages (3250 words) Research Paper

Oracle Database Management System and the Object Oriented Data Model Overview

14 Pages (3500 words) Coursework
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us