Denormalization strategies for data retrieval from data warehouses

Shin, Seung Kyoon; Sanders, G. Lawrence

doi:10.1016/j.dss.2004.12.004

Cited by 42 publications

(10 citation statements)

References 22 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Our model can be seen as a denormalised star schema having both facts and dimensions in the same table. Denormalisation is commonly used in data warehousing [33] but in this study the model is used only as an abstract formalism: our results are not bound to any particular implementation technique. A similar model is used, for example, by Malvestudo et al [20].…”

Section: Relational Olap Modelmentioning

confidence: 93%

Detecting summarizability in OLAP

Niemi¹,

Niinimäki²,

Thanisch

et al. 2014

Data & Knowledge Engineering

View full text Add to dashboard Cite

Section: Relational Olap Modelmentioning

confidence: 93%

Detecting summarizability in OLAP

Niemi¹,

Niinimäki²,

Thanisch

et al. 2014

Data & Knowledge Engineering

View full text Add to dashboard Cite

“…Then the generic workflow to construct data accessing engines is presented. Third, we review the typical key/value data models and propose some data model designation principles for IMDG, in which de-normalization technique [16,17] is used to improve query performance. Finally, the algorithm to support join query is presented.…”

Section: Architecture and Methodologymentioning

confidence: 99%

Constructing a data accessing layer for in-memory data grid

Wang

et al. 2012

Proceedings of the Fourth Asia-Pacific Symposium on Internetware

View full text Add to dashboard Cite

In-memory data grid (IMDG) is a novel data processing middleware for Internetware. It provides higher scalability and performance compared with traditional rational database. However, because the data stored in IMDG must follow the key/value data model, new challenges have been proposed. One important aspect is that IMDG does not support standard data accessing languages such as JPA and SQL, and application developers must design their programs according to the peculiarities of an IMDG product. This results in complex and error-prone code, especially for the programmers who have no deep understanding of IMDG. In this paper, we propose a data accessing reference architecture for IMDG and a methodology to design and implement its data accessing layer. In this methodology, data accessing engine construction, data model designation and join operation supporting are presented. Moreover, following this methodology, we develop and implement a JPA compatible data accessing engine for Hazelcast as a case study, which proves the feasibility of our approach.

show abstract

“…Both require spreadsheet data to be represented in a tabular format, with headers present in the first row. They do not support relationships between data entities, or in other words, they require the data to be denormalized [7], [8].…”

Section: A Examples Of Query Systemsmentioning

confidence: 99%

Querying model-driven spreadsheets

Cunha

Fernandes

Mendes

et al. 2013

2013 IEEE Symposium on Visual Languages and Human Centric Computing

View full text Add to dashboard Cite

Spreadsheets are being used with many different purposes that range from toy applications to complete information systems. In any of these cases, they are often used as data repositories that can grow significantly. As the amount of data grows, it also becomes more difficult to extract concrete information out of them.This paper focuses on the problem of spreadsheet querying. In particular, we propose an expressive and composable technique where intuitive queries can be defined. Our approach builds on a model-driven spreadsheet development environment, and queries are expressed referencing entities in the model of a spreadsheet instead of in its actual data. Finally, the system that we have implemented relies on Google's query function for spreadsheets.

show abstract

Denormalization strategies for data retrieval from data warehouses

Cited by 42 publications

References 22 publications

Detecting summarizability in OLAP

Detecting summarizability in OLAP

Constructing a data accessing layer for in-memory data grid

Querying model-driven spreadsheets

Contact Info

Product

Resources

About