A Framework for Building Logical Schema and Query Decomposition in Data Warehouse Federations

Kern, Rafał; Ryk, Krzysztof; Nguyên, Ngoc Thanh

doi:10.1007/978-3-642-23935-9_60

Cited by 11 publications

(6 citation statements)

References 7 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Warehouses federation according to Sheth and Larson [9], and that appears in [7] and [4], is a set of data warehouses that are heterogeneous, autonomous and dispersed. Every component can continue its local operations and at the same time participate in federation.…”

Section: Related Workmentioning

confidence: 99%

“…There are no many studies on the data warehouse federation, however, R. Kern, K. Ryk, and Ngoc Thanh Nguyen, proposed a framework for building logical schema and query decomposition in data warehouse federations [7], they developed an algorithm to integrate component schemas into one global logical federation schema.…”

Section: Related Workmentioning

confidence: 99%

“…this set of warehouses is what we call " a data warehouse federation". Federated data warehouses are different than distributed Data warehouses, in order that distributed data warehouses can refer different subjects and there is a strict rule in data distribution (horizontal, vertical...) which make it easy to integrate the query results by using join or sum operations [7].…”

Section: Introductionmentioning

confidence: 99%

See 2 more Smart Citations

Semantic Technologies Applying to Data Warehouses Federation

Mouhni

Elkalay

2014

JETWI

View full text Add to dashboard Cite

Business intelligence is based on the existence of main components including : data warehouses .The data warehouse is a specialized database which main task is to provide quick access to data in analysis objective. But in some cases it is necessary to use a set of data warehouses to provide a complete information. This structure is what we call federation, and even if the components are physically separated, they are logically seen as a single component. Generally, these items are heterogeneous which make it difficult to create the logical federation schema ,and the execution of user queries a complicated mission. In this paper, we will fill this gap by proposing a model for logical federation schema creation based on ontology, in order to treat different schema types (star , snow flack) including the treatment of hierarchies dimension too.

show abstract

Section: Related Workmentioning

confidence: 99%

Section: Related Workmentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

See 1 more Smart Citation

Semantic Technologies Applying to Data Warehouses Federation

Mouhni

Elkalay

2014

JETWI

View full text Add to dashboard Cite

show abstract

“…A measure such as score achieved during a game by a child can be calculated from a multidimensional model version of the data warehouse called the data cube (Ezeife, 2001). Existing schema integration approaches (Kern et al, 2011), (Fan and Poulovassilis, 2004), (Rahm and Bernstein, 2001) process some common steps during schema integration. The first step in integrating schemas (e.g., integrating schema1(Cust, C#, CName, First-Name, LastName) and schema2(Customer, CustID, Company, Contact, Phone)) is to identify and characterize these inter-schema relationships between the multiple data source schemas to be integrated.…”

Section: Data Warehouse Schema Integration Approachesmentioning

confidence: 99%

Automatic Updating of Computer Games Data Warehouse for Cognition Identification

Ezeife

Whent²,

Martinović

et al. 2014

Proceedings of the 6th International Conference on Computer Supported Education

View full text Add to dashboard Cite

This paper describes the algorithms (called OTEP DW auto) for automatically updating the integrated games data warehouse and cognitive profile data sources for purposes of identifying child's cognitive skill level. The techniques described in this paper represent an extension to the data integration engine adopted by an online product called "Thriver" developed by OTEP Inc. (Online Training & Evaluation Portal). OTEP focuses on using the Internet, natural playing environment for online computer games to give parents and care-givers automated opportunity to screen and follow their children's cognitive development. Current data integration efforts of the system when new games (such as speech games) are added or new cognitive skills matrix are added would require manual re-coding of the system which is a costly and time-consuming process. The cognitive skills matrix maps cognitive skills level of games player such as "basic reading level is good" to their games performance in comparison to the norms of other players. The proposed OTEP DW auto is capable of building the OTEP data warehouse schema automatically, thus seamlessly extracting, cleaning and propagating data from various data sources. It also provides a dynamic GUI-based interface for answering tens of frequently asked cognition-related questions.

show abstract

“…Unfortunately, this new model has fallen short of its promise, for several reasons according to [5]. To solve this challenge, the cloud-based Federated Fata warehousing Application (FDWA) framework, including global data warehouse and its virtual linked data marts in the clouds, has been introduced in [12,18].…”

Section: Introductionmentioning

confidence: 99%

Semantic Cubing Platform enabling Interoperability Analysis among Cloud-based Linked Data Cubes

Nguyễn

Ngo

2014

Proceedings of the 16th International Conference on Information Integration and Web-Based Applications &Amp; Services

View full text Add to dashboard Cite

In current data marketplace, multidimensional data cubes become isolated bits of information in lack of a comprehensive semantic relationship among their datasets. To facilitate the exploration and discovery possible semantic heterogeneity among linked data cubes, Semantic Cubing Platform has been studied. First, linked data marts and their data cubes have been specified by using the Federated Data warehousing Application (FDWA) framework and the Collective Cubing platform, which have been introduced in our previous literatures. Hereafter, Metacube Services have been proposed as a middle-layer to enable interoperability analysis among linked data cubes.

show abstract

A Framework for Building Logical Schema and Query Decomposition in Data Warehouse Federations

Cited by 11 publications

References 7 publications

Semantic Technologies Applying to Data Warehouses Federation

Semantic Technologies Applying to Data Warehouses Federation

Automatic Updating of Computer Games Data Warehouse for Cognition Identification

Semantic Cubing Platform enabling Interoperability Analysis among Cloud-based Linked Data Cubes

Contact Info

Product

Resources

About