Polynomial-time implication problems for unary inclusion dependencies
Journal of the ACM (JACM)
Description logics for conceptual data modeling
Logics for databases and information systems
The entity-relationship model—toward a unified view of data
ACM Transactions on Database Systems (TODS) - Special issue: papers from the international conference on very large data bases: September 22–24, 1975, Framingham, MA
Designing data marts for data warehouses
ACM Transactions on Software Engineering and Methodology (TOSEM)
Foundations of Databases: The Logical Level
Foundations of Databases: The Logical Level
The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom
IJCAR '01 Proceedings of the First International Joint Conference on Automated Reasoning
Discovery of Constraints from Data for Information System Reverse Engineering
ASWEC '97 Proceedings of the Australian Software Engineering Conference
The complexity of relational query languages (Extended Abstract)
STOC '82 Proceedings of the fourteenth annual ACM symposium on Theory of computing
The description logic handbook: theory, implementation, and applications
The description logic handbook: theory, implementation, and applications
Goal-oriented requirement analysis for data warehouse design
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
Database dependency discovery: a machine learning approach
AI Communications
Tractable Reasoning and Efficient Query Answering in Description Logics: The DL-Lite Family
Journal of Automated Reasoning
Automating multidimensional design from ontologies
Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
On Keys and Functional Dependencies as First-Class Citizens in Description Logics
Journal of Automated Reasoning
AAAI'05 Proceedings of the 20th national conference on Artificial intelligence - Volume 4
Identification constraints and functional dependencies in description logics
IJCAI'01 Proceedings of the 17th international joint conference on Artificial intelligence - Volume 1
On the interaction between inverse features and path-functional dependencies in description logics
IJCAI'05 Proceedings of the 19th international joint conference on Artificial intelligence
Reasoning on UML class diagrams
Artificial Intelligence
Journal on data semantics X
Automatic validation of requirements to support multidimensional design
Data & Knowledge Engineering
A framework for multidimensional design of data warehouses from ontologies
Data & Knowledge Engineering
Using ontologies to discover fact IDs
DOLAP '10 Proceedings of the ACM 13th international workshop on Data warehousing and OLAP
Inferring aggregation hierarchies for integration of data marts
DEXA'10 Proceedings of the 21st international conference on Database and expert systems applications: Part II
Ontologies and functional dependencies for data integration and reconciliation
ER'11 Proceedings of the 30th international conference on Advances in conceptual modeling: recent developments and new directions
The role of class dependencies in designing ontology-based databases
OTM'11 Proceedings of the 2011th Confederated international conference on On the move to meaningful internet systems
Building data warehouses with semantic web data
Decision Support Systems
Semantics and usage statistics for multi-dimensional query expansion
DASFAA'12 Proceedings of the 17th international conference on Database Systems for Advanced Applications - Volume Part II
ORE: an iterative approach to the design and evolution of multi-dimensional schemas
Proceedings of the fifteenth international workshop on Data warehousing and OLAP
Hi-index | 0.00 |
Nowadays, it is widely accepted that the data warehouse design task should be largely automated. Furthermore, the data warehouse conceptual schema must be structured according to the multidimensional model and as a consequence, the most common way to automatically look for subjects and dimensions of analysis is by discovering functional dependencies (as dimensions functionally depend on the fact) over the data sources. Most advanced methods for automating the design of the data warehouse carry out this process from relational OLTP systems, assuming that a RDBMS is the most common kind of data source we may find, and taking as starting point a relational schema. In contrast, in our approach we propose to rely instead on a conceptual representation of the domain of interest formalized through a domain ontology expressed in the DL-Lite Description Logic. We propose an algorithm to discover functional dependencies from the domain ontology that exploits the inference capabilities of DL-Lite, thus fully taking into account the semantics of the domain. We also provide an evaluation of our approach in a real-world scenario.