Analytical view of business data

ABSTRACT

This paper describes a logical extension to Microsoft Business Framework (MBF) called Analytical View (AV). AV consists of three components: Model Service for design time, Business Intelligence Entity (BIE) for programming model, and IntellDrill for runtime navigation between OLTP and OLAP data sources. AV feature-set fulfills enterprise application requirements for Analysis and Decision Support, complementing the transactional feature-set currently provided by MBF. Model Service automatically transforms an "object oriented model (transactional view)" to a "multi-dimensional model (analytical view)" without the traditional Extraction/Transformation/Loading (ETL) overhead and complexity. It infers dimensionality from the object layer where richer metadata is stored, eliminating the "guesswork" that a traditional data warehousing process requires when going through physical database schema. BI Entities are classes code-generated by Model Service. As an intrinsic part of the framework, BI Entities enable a consistent object oriented way of programming model with strong types and rich semantics for OLAP, similar to what MBF object persistence technology does for OLTP data. More importantly, data contained in BI Entities have a higher degree of "application awareness," such as the integrated application level security and customizability. IntelliDrill links together all the information islands in MBF using metadata. Because of the automatic transformation from transactional view to analytical view enabled by Model Service, we have the ability to understand natively what kind of drill-ability an object would have, thus making information navigation in MBF fully discover-able with built-in ontology.

REFERENCES

• 1: Microsoft Business Framework (http:// microsoft.sitestream.com/PDC2003/DAT/DAT340_files/ Botto_files/DAT340_Brookins.ppt)
• 2: UMD Resource Page (http://www.omg.org/uml/)
• 3: Ralph Kimball , Margy Ross, The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, John Wiley & Sons, Inc., New York, NY, 2002
• 4: Business Intelligence and Data Warehousing in SQL Server Yukon (<http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/next/DWSQLSY.asp>)
• 5: Microsoft Analysis Service (http://www.microsoft.com/sql/evaluation/bi/bianalysis.asp)
• 6: Alejandra Garrido and Gustavo Rossi, A Framework for Extending Object-Oriented Applications with Hypermedia Functionality (http://www.cs.colorado.edu/~kena/classes/7818/f99/framework.pdf).

INDEX TERMS

Primary Classification:
  H. Information Systems
  H.2 DATABASE MANAGEMENT
      H.2.8 Database applications

Additional Classification:
  D. Software
  D.1 PROGRAMMING TECHNIQUES
      D.1.5 Object-oriented Programming

  H. Information Systems
  H.1 MODELS AND PRINCIPLES

General Terms:
Design

Keywords:
OLAP, OLTP, analytics, application framework, business intelligence, entity persistence, information retrieval and navigation, object-oriented