A New Data Warehouse Approach Using Graph

Zekri, Manel; Marsit, Imen; Adellatif, Abdelaziz

doi:10.1109/icebe.2011.22

Cited by 10 publications

(3 citation statements)

References 6 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…This is the classical approach used since 70-es in the area of physical design tuning. Nowadays, it is the mainstream approach used almost in every industrial database [7,8,10,47,60] and in a majority of academic studies. -A kind of heuristic strategy which will guide the search behavior of a system.…”

Section: The Design Of a Self-managed Distributed Column-store Systemmentioning

confidence: 99%

“…One of the first such tools was REDWAR [59] tool for database analysis. Later, there was AutoAdmin [18] tool for index recommendation, DB2 advisor [49,57,60,61] (index, materialized view, partitions, allocation), Oracle Advisor [23,25] (index, materialized view, partitioning support), various advisors for Microsoft's products [5,6,8,14,47] (variety of physical structures), PostgreSQL [10,26,44], Ingres [56]. This stage started in the end of 80-es and continues up to this day.…”

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

New Trends in Databases and Information Systems

2015

Communications in Computer and Information Science

View full text Add to dashboard Cite

Abstract. Extract-Transform-Load (ET L) is a crucial phase in Data Warehouse (DW) design life-cycle that copes with many issues: data provenance, data heterogeneity, process automation, data refreshment, execution time, etc. Ontologies and Semantic Web technologies have been largely used in the ET L phase. Ontologies are a buzzword used by many research communities such as: Databases, Artificial Intelligence (AI), Natural Language Processing (NLP), where each community has its type of ontologies: conceptual canonical ontologies (for databases), conceptual non-canonical ontologies (for AI), and linguistic ontologies (for NLP). In ET L approaches, these three types of ontologies are considered. However, these studies do not consider the types of the used ontologies which usually affect the quality of the managed data. We propose in this paper a semantic ET L approach which considers both canonical and non-canonical layers. To evaluate the effectiveness of our approach, experiments are conducted using Oracle semantic databases referencing LUBM benchmark ontology.

show abstract

Section: The Design Of a Self-managed Distributed Column-store Systemmentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

New Trends in Databases and Information Systems

2015

Communications in Computer and Information Science

View full text Add to dashboard Cite

show abstract

“…Zekri (et al) [43] introduces a semi-automatic approach for the design of multidimensional diagrams. Conceptual Data Model (CDM) is first translated into the multivariate pattern, and then refined with user requirements.…”

Section: A Review Of Data Warehouse Design Automationmentioning

confidence: 99%

A direct approach to physical Data Vault design

Krneta

Jovanovic

Marjanovic³

2014

COMSIS J

View full text Add to dashboard Cite

The paper presents a novel agile approach to large scale design of enterprise data warehouses based on a Data Vault model. An original, simple and direct algorithm is defined for the incremental design of physical Data Vault type enterprise data warehouses, using source data meta-model and rules, and used in developing a prototype case tool for Data Vault design. This approach solves primary requirements for a system of record, that is, preservation of all source information, and fully addresses flexibility and scalability expectations. Our approach benefits from Data Vault dependencies minimizations and rapid loads opportunities enabling greatly simplified ETL transformations in a way not possible with traditional (i.e. non data vault based) data warehouse designs. The approach is illustrated using a realistic example from the healthcare domain.

show abstract