Abstract
Over the past ten to fifteen years, Business Intelligence applications have become increasingly important and visible components of enterprize computing environments. While relational database management systems often form the backbone of the BI software stack, the unique modeling and processing requirements of BI applications often make for a relatively awkward fit with RDBMS platforms in general, and their SQL query interfaces in particular. In this paper, we present a new framework for BI/OLAP applications that directly exploits a domain specific conceptual data model. In turn, the new paradigm allows us to support native, client-side OOP querying without the need to embed an intermediate, non-OOP language such as SQL or MDX. A pre-processor essentially translates standard OOP source code into a query grammar developed specifically for BI analysis. The end result is a query facility that is far more intuitive to use, as well as being more amenable to contemporary code development tools. We provide numerous examples to illustrate the flexibility and convenience of the new framework.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
XML for Analysis Specification v1.1. (2002), http://www.xmla.org/index.htm
CWM, Common Warehouse Metamodel (2003), http://www.cwmforum.org/
JSR-69 JavaTM OLAP Interface (JOLAP), JSR-69 (JOLAP) Expert Group (2003), http://jcp.org/aboutJava/communityprocess/first/jsr069/index.html
JSR 243: Java Data Objects 2.0 - An Extension to the JDO specification (2008), http://java.sun.com/products/jdo/
HaskellDB (2010), http://www.haskell.org/haskellDB/
JavaCC, the Java Compiler Compiler (2010), https://javacc.dev.java.net/
Ruby programming language (2010), http://www.ruby-lang.org/en/
Agrawal, R., Gupta, A., Sarawagi, S.: Modeling multidimensional databases. In: International Conference on Data Engineering (ICDE), Washington, DC, USA, pp. 232–243. IEEE Computer Society, Los Alamitos (1997)
Akinde, M.O., Bohlen, M.H.: Efficient computation of subqueries in complex OLAP. In: International Conference on Data Engineering (ICDE), pp. 163–174 (2003)
Bauer, C., King, G.: Java Persistence with Hibernate. Manning Publications Co., Greenwich (2006)
Blakeley, J.A., Rao, V., Kunen, I., Prout, A., Henaire, M., Kleinerman, C.: .NET database programmability and extensibility in Microsoft SQL Server. In: ACM SIGMOD International Conference on Management of Data, pp. 1087–1098. ACM, New York (2008)
Cook, W.R., Rai, S.: Safe query objects: statically typed objects as remotely executable queries. In: International Conference on Software Engineering (ICSE), pp. 97–106 (2005)
Cunningham, C., Graefe, G., Galindo-Legaria, C.A.: PIVOT and UNPIVOT: Optimization and execution strategies in an RDBMS. In: International Conference on Very Large Data Bases (VLDB), pp. 998–1009 (2004)
Dittrich, J.-P., Kossmann, D., Kreutz, A.: Bridging the gap between OLAP and SQL. In: International Conference on Very Large Data Bases (VLDB), pp. 1031–1042 (2005)
Gray, J., Bosworth, A., Layman, A., Pirahesh, H.: Data Cube: A relational aggregation operator generalizing group-by, cross-tab, and sub-total. In: International Conference on Data Engineering (ICDE), Washington, DC, USA, pp. 152–159. IEEE Computer Society, Los Alamitos (1996)
Gyssens, M., Lakshmanan, L.V.S.: A foundation for multi-dimensional databases. In: International Conference on Very Large Data Bases (VLDB), pp. 106–115. Morgan Kaufmann Publishers Inc., San Francisco (1997)
Malinowski, E., Zimanyi, E.: Hierarchies in a multidimensional model: From conceptual modeling to logical representation. Data Knowl. Eng. 59(2), 348–377 (2006)
Melton, J.: Advanced SQL 1999: Understanding Object-Relational, and Other Advanced Features. Elsevier Science Inc., New York (2002)
Morfonios, K., Ioannidis, Y.: CURE for cubes: cubing using a ROLAP engine. In: International Conference on Very Large Data Bases (VLDB), pp. 379–390. VLDB Endowment (2006)
Romero, O., Abelló, A.: On the need of a reference algebra for OLAP. In: Song, I.-Y., Eder, J., Nguyen, T.M. (eds.) DaWaK 2007. LNCS, vol. 4654, pp. 99–110. Springer, Heidelberg (2007)
Sismanis, Y., Deligiannakis, A., Kotidis, Y., Roussopoulos, N.: Hierarchical dwarfs for the rollup cube. In: International Workshop on Data Warehousing and OLAP (DOLAP), pp. 17–24. ACM, New York (2003)
Stonebraker, M., Madden, S., Abadi, D.J., Harizopoulos, S., Hachem, N., Helland, P.: The end of an architectural era (it’s time for a complete rewrite). In: International Conference on Very Large Data Bases (VLDB), pp. 1150–1160 (2007)
Whitehorn, M., Zare, R., Pasumansky, M.: Fast Track to MDX. Springer, New York (2005)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2010 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Eavis, T., Tabbara, H., Taleb, A. (2010). The NOX Framework: Native Language Queries for Business Intelligence Applications. In: Bach Pedersen, T., Mohania, M.K., Tjoa, A.M. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2010. Lecture Notes in Computer Science, vol 6263. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-15105-7_14
Download citation
DOI: https://doi.org/10.1007/978-3-642-15105-7_14
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-15104-0
Online ISBN: 978-3-642-15105-7
eBook Packages: Computer ScienceComputer Science (R0)