Brief Report on the Advanced Use of Prolog for Data Warehouses
Data warehouses have demonstrated their applicability in numerous application fields such as agriculture, the environment and health. This paper proposes a general framework for defining a data warehouse and its aggregations using logic programming. The objective is to show that data managers can ea...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
MDPI AG
2022-11-01
|
| Series: | Applied Sciences |
| Subjects: | |
| Online Access: | https://www.mdpi.com/2076-3417/12/21/11223 |
| _version_ | 1797469110860251136 |
|---|---|
| author | François Pinet |
| author_facet | François Pinet |
| author_sort | François Pinet |
| collection | DOAJ |
| description | Data warehouses have demonstrated their applicability in numerous application fields such as agriculture, the environment and health. This paper proposes a general framework for defining a data warehouse and its aggregations using logic programming. The objective is to show that data managers can easily express, in Prolog, traditional data warehouse queries and combine data aggregation operations with other advanced Prolog features. It is shown that this language provides advanced features to aggregate information in an in-memory database. This paper targets data managers; it shows them the direct writing of data warehouse queries in Prolog using an easily understandable syntax. The queries are not necessarily in an optimal form from a processing point of view, but a data manager can easily use or write them. |
| first_indexed | 2024-03-09T19:16:48Z |
| format | Article |
| id | doaj.art-1aed593c43834e328df941ff48e9b1ba |
| institution | Directory Open Access Journal |
| issn | 2076-3417 |
| language | English |
| last_indexed | 2024-03-09T19:16:48Z |
| publishDate | 2022-11-01 |
| publisher | MDPI AG |
| record_format | Article |
| series | Applied Sciences |
| spelling | doaj.art-1aed593c43834e328df941ff48e9b1ba2023-11-24T03:40:02ZengMDPI AGApplied Sciences2076-34172022-11-0112211122310.3390/app122111223Brief Report on the Advanced Use of Prolog for Data WarehousesFrançois Pinet0INRAE, UR TSCF, Université Clermont Auvergne, 63178 Aubière, FranceData warehouses have demonstrated their applicability in numerous application fields such as agriculture, the environment and health. This paper proposes a general framework for defining a data warehouse and its aggregations using logic programming. The objective is to show that data managers can easily express, in Prolog, traditional data warehouse queries and combine data aggregation operations with other advanced Prolog features. It is shown that this language provides advanced features to aggregate information in an in-memory database. This paper targets data managers; it shows them the direct writing of data warehouse queries in Prolog using an easily understandable syntax. The queries are not necessarily in an optimal form from a processing point of view, but a data manager can easily use or write them.https://www.mdpi.com/2076-3417/12/21/11223data warehouseprologdata aggregation |
| spellingShingle | François Pinet Brief Report on the Advanced Use of Prolog for Data Warehouses Applied Sciences data warehouse prolog data aggregation |
| title | Brief Report on the Advanced Use of Prolog for Data Warehouses |
| title_full | Brief Report on the Advanced Use of Prolog for Data Warehouses |
| title_fullStr | Brief Report on the Advanced Use of Prolog for Data Warehouses |
| title_full_unstemmed | Brief Report on the Advanced Use of Prolog for Data Warehouses |
| title_short | Brief Report on the Advanced Use of Prolog for Data Warehouses |
| title_sort | brief report on the advanced use of prolog for data warehouses |
| topic | data warehouse prolog data aggregation |
| url | https://www.mdpi.com/2076-3417/12/21/11223 |
| work_keys_str_mv | AT francoispinet briefreportontheadvanceduseofprologfordatawarehouses |