Modeling Multidimensional Databases
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Total
ICDE '96 Proceedings of the Twelfth International Conference on Data Engineering
A Foundation for Multi-dimensional Databases
VLDB '97 Proceedings of the 23rd International Conference on Very Large Data Bases
Advanced SQL 1999: Understanding Object-Relational, and Other Advanced Features
Advanced SQL 1999: Understanding Object-Relational, and Other Advanced Features
Hierarchical dwarfs for the rollup cube
DOLAP '03 Proceedings of the 6th ACM international workshop on Data warehousing and OLAP
Safe query objects: statically typed objects as remotely executable queries
Proceedings of the 27th international conference on Software engineering
Bridging the gap between OLAP and SQL
VLDB '05 Proceedings of the 31st international conference on Very large data bases
Fast Track to MDX
CURE for cubes: cubing using a ROLAP engine
VLDB '06 Proceedings of the 32nd international conference on Very large data bases
Java Persistence with Hibernate
Java Persistence with Hibernate
Hierarchies in a multidimensional model: from conceptual modeling to logical representation
Data & Knowledge Engineering - Special issue: WIDM 2004
PIVOT and UNPIVOT: optimization and execution strategies in an RDBMS
VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
The end of an architectural era: (it's time for a complete rewrite)
VLDB '07 Proceedings of the 33rd international conference on Very large data bases
.NET database programmability and extensibility in microsoft SQL server
Proceedings of the 2008 ACM SIGMOD international conference on Management of data
Ruby Programming
On the need of a reference algebra for OLAP
DaWaK'07 Proceedings of the 9th international conference on Data Warehousing and Knowledge Discovery
The NOX OLAP query model: from algebra to execution
DaWaK'11 Proceedings of the 13th international conference on Data warehousing and knowledge discovery
| Hi-index | 0.00 |
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.