An authorization model for temporal and derived data: securing information portals
ACM Transactions on Information and System Security (TISSEC)
Lineage Tracing for General Data Warehouse Transformations
Proceedings of the 27th International Conference on Very Large Data Bases
Lineage tracing for general data warehouse transformations
The VLDB Journal — The International Journal on Very Large Data Bases
| Hi-index | 0.00 |
Large database systems (e.g., federations, warehouses) are multi-layer — i.e., a combination of base databases and (virtual or physical) view databases1. Smaller systems use views for layers that hide detailed physical and conceptual structures. We argue that most databases would be more effective if they were more user-centered — i.e., if they allowed users, administrators, and application developers to work mostly within their native view. To do so, we need first class views — views that support most of the metadata and operations available on source tables.First class views could also make multi-tier object architectures (based on objects in multiple tiers of servers) easier to build and maintain. The views modularize code for data services (e.g., query, security) and for coordinating changes with neighboring tiers. When data in each tier is derived declaratively, one can generate some of these methods semi-automatically.Much of the functionality required to support first class views can be generated semi-automatically, if the derivations between layers are declarative (e.g., SQL, rather than Java). We present a framework where propagation rules can be defined, allowing the flexible and incremental specification of view semantics, even by non-programmers. Finally, we describe research areas opened up by this approach.