Extensible Grouping and Aggregation for Data Reconciliation

New applications from the areas of analytical data processing and data integration require powerful features to condense and reconcile available data. Object-relational and other data management systems available today provide only limited concepts to deal with these requirements. The general concept of grouping and aggregation appears to be a fitting paradigm for a number of the mentioned issues, but in its common form of equality based groups and restricted aggregate functions a number of problems remain unsolved. Various extensions to this concept have been introduced over the last years, especially regarding user-defined functions for aggregation and derivation of grouping properties. We propose generic interfaces for user-defined grouping and aggregation as part of a SQL extension, allowing for more complex functions, for instance integration of data mining algorithms. Furthermore, we discuss high-level language primitives for common applications and illustrate the approach by int...

• Type: Conference
• Year: 2001
• Where: EFDBS
• Authors: Eike Schallehn, Kai-Uwe Sattler, Gunter Saake
• Keywords: Analytical Data Processing, Data Management Systems, EFDBS 2001, Information Technology, User-defined Grouping