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.
Terms & Condition
Submission -
Author can submit the manuscript through our online submission process or email us at the designated email id in contact details.
The other mode of submission not accepted than online and email.
Before submission please read the submission guidelines.
NN Publication accepts only article submitted in pdf/doc/docx/rtf file format. Another format except given file formats will no be considered .
Author will be responsible for the error mistakes in the submission files. The minor changes can be done without any cost after publication. But for major changes NN Publication may charges you the editing charges.
Publication (Online) -
The online publication is scheduled on last date of every month, but it can be delayed by 24 to 48 hours due to editorial process if huge number of articles comes to publish in single issue.
Automatic notificatation email will be sent to the all users on publication of an issue, so its author’s duty to check their email inbox or SPAM folder to get this notification.
After publication of article author can not withdraw their article.
If editor’s found any issue after publication of article then the NN Publication have the authority to remove the article from online website.
No refund will be provided after online publication of article.
Publication (Print) -
The print copy publication are sent as per the author’s request after 2 weeks of online publication of that issue.
NN Publication will ship the article by India Post and provide the consignment number on dispatch of print copy.
NN Publication follows all the guidelines of delivery provided by IndiaPost and hence not responsible for delay in delivery due to any kind of reasons.
Refund of hard copy will not be provided after dispatch or print of the journal.
NN Publication will be responsible for raise a complain if there is any issue occurs in delivery, but still will not be responsible for providing the refund.
NN Publication will be responsible to resend the print copy only and only if the print copy is lost or print copy is damaged in delivery / or there is delay more than 6 months.
According to India Post the delivery should be completed with in 1-3 weeks after dispatch of articles.
Privacy Policy-
NN Publicationl uses the email ids of authors and editors and readers for sending editorial or publication notification only, we do not reveal or sell the email ids to any other website or company.
