论文标题

关系数据库的直通还是标的系统方法

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

论文作者

Shah, Sareen

论文摘要

归一化的关系数据库是存储数据的常见方法,但是提取可用的不规范数据以进行消耗,通常需要直接访问源数据或由数据库管理员创建适当的视图或表格。因此,最终用户的探索和使用以这种方式存储的数据的能力受到限制。此处介绍的是一种在运行时执行关系数据库的自动构规化的方法,而无需访问源数据或数据库管理员的持续干预。此外,此方法不需要对数据库本身进行重组,因此可以灵活地将其作为已经存在的数据库顶部的图层应用。

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.

扫码加入交流群

加入微信交流群

微信交流群二维码

扫码加入学术交流群,获取更多资源