A Kdd Process to Retrieve and Aggregate Data from Relational Databases

Relational databases are a standard for representing data models. SQL is the most widely used language for querying such databases. Consequently, in many research domains, scientists extract data from relational databases, compute them and do statistical treatments. But they have to deal with the complexity of relational databases models. In addition, it takes a long time for the scientists to manually retrieve and compute data. That's why we propose a system which automatically does. It contains the following layers: parameterizable extraction of data, automatic process of SQL queries, data aggregation, statistical parameters computation, writing the results to tables and final data processing by the scientist, thanks to a statistical analysis software. A use case on the research on a soil quality index from a large relational database will be presented.