Online Analytical Processing (OLAP)
DOI:
https://doi.org/10.53555/nncse.v1i3.520Keywords:
ONLINE ANALYTICAL, PROCESSING (OLAP)Abstract
This paper is basically accustomed define On-Line Analytical method (OLAP), WHO uses it and why, and to review the key choices required for OLAP code. On-Line Analytical method (OLAP) could also be a category of code technology that allows analysts, managers and executives to appreciate insight into info through fast, consistent, interactive access to an honest reasonably gettable views of {data of information} that has been transformed from data to mirror spatiality of the enterprise as understood by the user. whereas OLAP systems have the ability to answer "who?" and "what?" queries, it's their ability to answer "what if?" and "why?" that sets them except info Warehouses. OLAP applications span a variety of structure functions. Finance departments use OLAP for applications like budgeting, activity-based accountancy (allocations), cash performance analysis, and cash modelling. Sales analysis and prognostication square measure a pair of the OLAP applications found in sales departments. Among totally different applications, promoting departments use OLAP for analysis, sales prognostication, promotions analysis, consumer analysis, and market/customer segmentation. Typical manufacturing OLAP applications embody production coming up with and defect analysis. Although OLAP applications square measure found in wide divergent sensible areas, all of them want the following key choices like 3-D views of information, Calculation –intensive capabilities and Time Intelligence.
References
Luca Cabibbo and Riccardo Torlone. From a Procedural to a Visual Query Language for OLAP. In Proceedings of 10th International Conference on Scientific and Statistical Database Management (SSDBM’98), pages 74-83. IEEE Computer Society Press, 1998.
Edgar F. Codd, S. B. Codd, and C. T. Salley. Providing OLAP to user-analysts: An IT mandate. Technical report, E. F. Cod & Associates, 1993.
Marc Gyssens and Laks V. S. Lakshmanan. A Foundation for Multi-dimensional Databases. In Proceedings of 23rd International Conference on Very Large Data Bases (VLDB’97), pages 106-115. Morgan Kaufmann, 1997.
Jiawei Han. OLAP Mining: Integration of OLAP with Data Mining. In IFIP TC2/WG2.6 Seventh Conference on Database Semantics (DS-7), volume 124 of IFIP Conference Proceedings, pages 3-20. Chapman&Hall, 1997.
Microsoft. Multidimensional Expressions (MDX) Reference. Available at http://msdn2.microsoft.com/enus/ library/ms145506.aspx, 2007. SQL Server books online.
Nigel Pendse. The OLAP Report - What is OLAP? Available at http://www.olapreport.com/fasmi.html, 2007.Business Application Research Center.
Torsten Priebe and Günther Pernul. Towards OLAP Security Design - Survey and Research Issues. In Third ACM International Workshop on Data Warehousing and OLAP (DOLAP 2000), pages 33-40. ACM, 2000.
Erhard Rahm, Toralf Kirsten, and Jorg Lange. The GeWare data warehouse platform for the analysis of
molecular-biological and clinical data. Journal of Integrative Bioinformatics, 1(4):47, 2007.
Oscar Romero and Alberto Abelló. Automating Multidimensional Design from Ontologies. In Proceedings of the ACM International Workshop on Data Warehousing and OLAP (DOLAP’07), pages 1-8.ACM, 2007.
Oscar Romero and Alberto Abelló. On the Need of a Reference Algebra for OLAP. In Proceedings of the International Conference on Data Warehousing and Knowledge Discovery (DaWaK’07), volume 4654, pages 99-110. Springer (LNCS), 2007.
Downloads
Published
Issue
Section
License
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
You are free to:
- Share — copy and redistribute the material in any medium or format for any purpose, even commercially.
- Adapt — remix, transform, and build upon the material for any purpose, even commercially.
- The licensor cannot revoke these freedoms as long as you follow the license terms.
Under the following terms:
- Attribution — You must give appropriate credit , provide a link to the license, and indicate if changes were made . You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
- No additional restrictions — You may not apply legal terms or technological measures that legally restrict others from doing anything the license permits.
Notices:
You do not have to comply with the license for elements of the material in the public domain or where your use is permitted by an applicable exception or limitation .
No warranties are given. The license may not give you all of the permissions necessary for your intended use. For example, other rights such as publicity, privacy, or moral rights may limit how you use the material.
