Extended SQL Aggregation for Database Transformation

Provided by: IJCTT-International Journal of Computer Trends and Technology
Topic: Data Management
Format: PDF
Product life cycles to prepare a normalized data set from relational database for analysis require significant efforts and it is time consuming task. The main reason is that, in general the database grows with many tables and views that must be joined, aggregated and transformed in order to build the required data set. As result, most of the SQL queries are written independently multiple times and in disorganize manner, which create problems in database evolution and software maintenance. To address this issue, the authors propose simple methods to generate SQL code to return aggregated columns in a horizontal tabular layout, where every row corresponds to an observation, instance or point (possibly varying over time) and every column is associated to a one variable or dimension.

Find By Topic