The IBM data warehouse architecture
Communications of the ACM
Data Warehousing: Dealing with the Growing Pains
ICDE '97 Proceedings of the Thirteenth International Conference on Data Engineering
Active Storage for Large-Scale Data Mining and Multimedia
VLDB '98 Proceedings of the 24rd International Conference on Very Large Data Bases
Active Storage Hierarchy, Database Systems and Applications - Socratic Exegesis
VLDB '99 Proceedings of the 25th International Conference on Very Large Data Bases
VLDB '88 Proceedings of the 14th International Conference on Very Large Data Bases
Exegesis of DBC/1012 and P-90 - Industrial Supercomputer Database Machines
PARLE '92 Proceedings of the 4th International PARLE Conference on Parallel Architectures and Languages Europe
StorHouse.com - The Data Management Service Provider
MSS '01 Proceedings of the Eighteenth IEEE Symposium on Mass Storage Systems and Technologies
Optimized Management of Large-Scale Data Sets Stored on Tertiary Storage Systems
IEEE Distributed Systems Online
Decision support queries on a tape-resident data warehouse
Information Systems
Hi-index | 0.00 |
This paper describes the StorHouse/Relational Manager (RM) database system that uses and exploits an active storage hierarchy. By active storage hierarchy, we mean that StorHouse/RM executes SQL queries directly against data stored on all hierarchical storage (i.e. disk, optical, and tape) without post processing a file or a DBA having to manage a data set. We describe and analyze StorHouse/RM features and internals. We also describe how StorHouse/RM differs from traditional HSM (Hierarchical Storage Management) systems. For commercial applications we describe an evolution to the Data Warehouse concept, called Atomic Data Store, whereby atomic data is stored in the database system. Atomic data is defined as storing all the historic data values and executing queries against them. We also describe a Hub-and-Spoke Data Warehouse architecture, which is used to feed or fuel data into Data Marts.Furthermore, we provide analysis how StorHouse/RM can be federated with DB2, Oracle and Microsoft SQL Server 7 (SS7) and thus provide these databases an active storage hierarchy (i.e. tape). We then show two federated data modeling techniques (a) logical horizontal partitioning (LHP) of tuples and (b) logical vertical partitioning (LVP) of columns to demonstrate our database extension capabilities. We conclude with a TPC-like performance analysis of data stored on tape and disk.