Operational Reporting Using Navigational SQL

Ad-hoc analytics on top of OLTP data provides direct business value in that business users can directly interact with the system to gather information for decision-making. From a business user perspective, SQL requires - for a schema that is never changed - deep schema knowledge in order to express...

Full description

Saved in:
Bibliographic Details
Main Authors: Grund, M., Krueger, J., Schaffner, J., Schapranow, M., Bog, A.
Format: Conference Proceeding
Language:English
Subjects:
Database languages
Decision making
Domain specific languages
Engines
Information analysis
Material storage
Navigation
Object oriented databases
Relational databases
Spatial databases
Online Access:Request full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:Ad-hoc analytics on top of OLTP data provides direct business value in that business users can directly interact with the system to gather information for decision-making. From a business user perspective, SQL requires - for a schema that is never changed - deep schema knowledge in order to express navigation along join paths even for simple queries. In this paper we introduce navigational SQL, a language that provides constructs specifically tailored for data retrieval in the context of operational reporting, such as a navigation operator that has explicit knowledge about join paths in a particular schema and gives the user an "application level view" of the tables. We motivate NSQL using examples from operational reporting and outline its benefits over materialized views and domain specific languages, which could also be used to address the issues with SQL described above fully or in part.
DOI:10.1109/AMIGE.2008.ECP.35