A Systematic Method for On-The-Fly Denormalization of Relational Databases

09/30/2020
by   Sareen Shah, et al.
0

Normalized relational databases are a common method for storing data, but pulling out usable denormalized data for consumption generally requires either direct access to the source data or creation of an appropriate view or table by a database administrator. End-users are thus limited in their ability to explore and use data that is stored in this manner. Presented here is a method for performing automated denormalization of relational databases at run-time, without requiring access to source data or ongoing intervention by a database administrator. Furthermore, this method does not require a restructure of the database itself and so it can be flexibly applied as a layer on top of already existing databases.

READ FULL TEXT

page 1

page 2

page 3

page 4

research
05/18/2021

Discovering the Information that is lost in our Databases – Why bother storing data if you can't find the information?

We are surrounded by an ever increasing amount of data that is stored in...
research
09/24/2019

A Rule-Based Relational XML Access Control Model in the Presence of Authorization Conflicts

There is considerable amount of sensitive XML data stored in relational ...
research
05/25/2015

VeinPLUS: A Transillumination and Reflection-based Hand Vein Database

This paper gives a short summary of work related to the creation of a de...
research
07/27/2023

Mitigating Cross-Database Differences for Learning Unified HRTF Representation

Individualized head-related transfer functions (HRTFs) are crucial for a...
research
05/24/2023

Towards Foundation Models for Relational Databases [Vision Paper]

Tabular representation learning has recently gained a lot of attention. ...
research
10/04/2017

A Comparative Analysis of Materialized Views Selection and Concurrency Control Mechanisms in NoSQL Databases

Increasing resource demands require relational databases to scale. While...
research
05/15/2020

Referencing Sources of Molecular Spectroscopic Data in the Era of Data Science: Application to the HITRAN and AMBDAS Databases

The application described has been designed to create bibliographic entr...

Please sign up or login with your details

Forgot password? Click here to reset