Felipe Cariño

Exegesis of DBC/1012 and P-90 - Industrial Supercomputer Database Machines

This paper describes the DBC/1012s architecture, its broadcast sort/merge Ynet interconnection network, its data distribution and access strategies, its parallel execution schemes and intra-query parallelism, its method for handling linear system growth, and an optical technology solution that replaces microfiche. Also described are the hierarchical data storage needs of most large industrial and governmental concerns and why certain applications can now be implemented for the first time. Various industry case studies are examined on the important issues of how they use multimedia parallel database systems to satisfy complex decision support analysis. Finally, we present a brief analysis of P-90, our next generation parallel database computer system. In particular, we discuss the performance enhancement gains provided by introducing multiprocessing at the board level, the expected benefits of RAID5 disk arrays, and a new bidirectional, multistage, high bandwidth, pointtopoint interconnection network.

Optimizer and parallel engine extensions for handling expensive methods based on large objects

Object-relational database systems allow users to define new types and functions. This typing extension allows structural semantics to be applied to new data types (non-SQL92 data types). However, defining new, large, complex objects within a tuple is not always practical. Practicality alone requires that large object data structures be used. This implies that predicate evaluation can be performed on tuple columns that are physically stored outside of a tuples physical record. This out-of-line storage mechanism is commonly used today for column values that are physically large (implemented with a large object descriptor in the tuple pointing to a large object data structure). This type of predicate-based evaluation presents new optimizer and run-time challenges to the database system on clustered and massively parallel processor shared-nothing architectures.

StorHouse metanoia - new applications for database, storage & data warehousing

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.