Filters








78 Hits in 3.7 sec

O-O, what's happening to DB2?

M. Carey, D. Chamberlin, D. Doole, S. Rielau, N. Mattos, S. Narayanan, B. Vance, R. Swagerman
1999 Proceedings of the 1999 ACM SIGMOD international conference on Management of data - SIGMOD '99  
The features to be described include support for structured types, object references, and hierarchies of typed tables and views.  ...  In this presentation, we will describe a collection of new object-relational features that have been added to IBM's DB2 Universal Database (UDB) system.  ...  In September 1998, IBM released Version 5.2 of DB2 UDB.  ... 
doi:10.1145/304182.304234 dblp:conf/sigmod/CareyCNVDRSM99 fatcat:o76ounnsfbc5fg2qzi3ty6a2du

O-O, what's happening to DB2?

M. Carey, D. Chamberlin, D. Doole, S. Rielau, N. Mattos, S. Narayanan, B. Vance, R. Swagerman
1999 SIGMOD record  
The features to be described include support for structured types, object references, and hierarchies of typed tables and views.  ...  In this presentation, we will describe a collection of new object-relational features that have been added to IBM's DB2 Universal Database (UDB) system.  ...  In September 1998, IBM released Version 5.2 of DB2 UDB.  ... 
doi:10.1145/304181.304234 fatcat:y7gfndyusjcxbe2cjireyh3xuu

The IBM data warehouse architecture

Charles Bontempo, George Zagelow
1998 Communications of the ACM  
UDB and DB2 for AS/400) • Integrated replication function (DB2 UDB and DB2 for AS/400) 3.  ...  DB2 UDB provides this support in the form of large objects, user-defined types, userdefined functions, and relational extenders. Strong typing is enforced.  ... 
doi:10.1145/285070.285078 fatcat:fkchxz5jqvbqvaglae2dqbidve

DB2 Design AdvisorIntegrated Automatic Physical Database Design [chapter]

D ZILIO, J RAO, S LIGHTSTONE, G LOHMAN, A STORM, C GARCIAARELLANO, S FADDEN
2004 Proceedings 2004 VLDB Conference  
The DB2 Design Advisor in IBM® DB2® Universal Database™ (DB2 UDB) Version 8.2 for Linux®, UNIX® and Windows® is a tool that, for a given workload, automatically recommends physical design features that  ...  are any subset of indexes, materialized query tables (also called materialized views), shared-nothing database partitionings, and multidimensional clustering of tables.  ...  and materialized views (called materialized query tables in DB2 UDB), but also partitioning and multi-dimensional clustering of tables.  ... 
doi:10.1016/b978-012088469-8/50095-4 fatcat:eavxpmnxgjb3hlhwbyrrxexmq4

Generic On-Line Discovery of Quantitative Models for Service Level Management [chapter]

Yixin Diao, Frank Eskesen, Steven Froehlich, Joseph L. Hellerstein, Alexander Keller, Lisa F. Spainhower, Maheswaran Surendra
2003 Integrated Network Management VIII  
We apply the prototype to on-line estimation of response times for DB2 Universal Database under a TPC-W workload.  ...  Unfortunately, constructing quantitative models requires specialized skills that are in short supply.  ...  To aid in this discussion, we use a running example in which DB2 UDB is the resource, Element Data are obtained from the DB2 performance monitor, and the response variable is response time (as measured  ... 
doi:10.1007/978-0-387-35674-7_23 fatcat:kqv74qqbifdcrkjbadu6hxpgbq

Characteristics of production database workloads and the TPC benchmarks

W. W. Hsu, A. J. Smith, H. C. Young
2001 IBM Systems Journal  
In general, the two TPC benchmarks complement one another in reflecting the characteristics of the production workloads, but some aspects of real workloads are still not represented by either of the benchmarks  ...  In this paper, we examine the characteristics of the production database workloads of ten of the world's largest corporations, and we also compare them to TPC-C and TPC-D.  ...  In particular, the authors would like to thank Jyh-Herng Chow, Alex Hazlitt, Eric Louie, Amit Somani, and Surrendra Verma for their guidance in designing the trace facility and in setting up the TPC benchmarks  ... 
doi:10.1147/sj.403.0781 fatcat:g5mlj6f7pncnxahhc7d5blsmee

Cost-based optimization in DB2 XML

A. Balmin, T. Eliaz, J. Hornibrook, L. Lim, G. M. Lohman, D. Simmen, M. Wang, C. Zhang
2006 IBM Systems Journal  
DB2 XML is a hybrid database system that combines the relational capabilities of DB2 Universal Databasee (UDB) with comprehensive native XML support.  ...  DB2 XML augments DB2t UDB with a native XML store, XML indexes, and query processing capabilities for both XQuery and SQL/XML that are integrated with those of SQL.  ...  ACKNOWLEDGMENT We would like to thank the entire DB2 XML team for their support of this work.  ... 
doi:10.1147/sj.452.0299 fatcat:ac232lw4z5bnjibsqfjua55xv4

Xml Data Mediation and Collaboration: A Proposed Comprehensive Architecture and Query Requirements for Using Xml to Mediate Heterogeneous Data Sources and Targets

Paul Benjamin Lowry
2005 Social Science Research Network  
phases; consistent query language regardless of data source; returns all data results in XML format; provides different views of data according to different application needs; improves Internet spidering  ...  Because significant gaps exist in all the reviewed XML data mediation approaches, a more comprehensive framework is presented.  ...  Another similarly straightforward approach is the storage of XML documents on a DB2 database that has been extended with DB2 UDB XML Extender, for storage, and DB2 UDB Net.Data for access [23] .  ... 
doi:10.2139/ssrn.666172 fatcat:sl63whmxrbgdxgyzw3n4hohrpa

Multidimensional Performance Management

David Wiese
2009 Zenodo  
In order to maximize efficiency of an information management platform and to assist in decision making, the collection, storage and analysis of performance-relevant data has become of fundamental importance  ...  Leveraging OLAP techniques, in contrast to traditional static reporting, this is supposed to be accomplished within moderate amount of time and little processing complexity.  ...  Multidimensional structures within IBM DB2 Fortunately, the DB2 architecture already provides a comprehensive set of object hierarchies as depicted in Figure 4 .  ... 
doi:10.5281/zenodo.1078729 fatcat:lsp43m352fetrpov5gw27kigpq

DB2 goes hybrid: Integrating native XML and XQuery with relational data and SQL

K. Beyer, R. Cochrane, M. Hvizdos, V. Josifovski, J. Kleewein, G. Lapis, G. Lohman, R. Lyle, M. Nicola, F. Ozcan, H. Pirahesh, N. Seemann (+6 others)
2006 IBM Systems Journal  
We describe the new XML components in DB2 UDB and show how XML processing leverages much of the infrastructure which is used for relational data. Ó  ...  This paper presents the overall architecture and design aspects of native XML support in DB2 UDB and its integration with the relational data-flow engine.  ...  He has over seven years of experience supporting, maintaining, and enhancing DB2 application interfaces and has contributed to numerous editions of the IBM DB2 UDB Family Fundamentals and Application Development  ... 
doi:10.1147/sj.452.0271 fatcat:wppk2sdeq5d2rhbwfwc6lf4niu

An Alternative Relational OLAP Modeling Approach [chapter]

Andreas Bauer, Wolfgang Hümmer, Wolfgang Lehner
2000 Lecture Notes in Computer Science  
be observed in implementing the multidimensional view of data.  ...  , we replace each dimension table of a star/snowflake schema by a set of views directly reflecting the classification hierarchy.  ...  IBM DB2/UDB V6.1 database system.  ... 
doi:10.1007/3-540-44466-1_19 fatcat:cu223b7hwrceboekrfwhfhrr2a

Automated design of multidimensional clustering tables for relational databases [chapter]

Sam S. Lightstone, Bishwaranjan Bhattacharjee
2004 Proceedings 2004 VLDB Conference  
The model has been implemented in the IBM® DB2 UDB for Linux®, UNIX® and Windows® Version 8.2 release.  ...  An industrial implementation of this technique for the DB2® Universal Database™ (DB2 UDB) product, called multidimensional clustering (MDC), which co-exists with other classical forms of data storage and  ...  Background DB2 UDB V8.1 MDC implementation In the MDC implementation in DB2 UDB V8.1 proposed by Padmanabhan et al.  ... 
doi:10.1016/b978-012088469-8.50102-9 dblp:conf/vldb/LightstoneB04 fatcat:acfe4zdcoba2napxj54wjvrtgy

Automated design of multidimensional clustering tables for relational databases [chapter]

S LIGHTSTONE, B BHATTACHARJEE
2004 Proceedings 2004 VLDB Conference  
The model has been implemented in the IBM® DB2 UDB for Linux®, UNIX® and Windows® Version 8.2 release.  ...  An industrial implementation of this technique for the DB2® Universal Database™ (DB2 UDB) product, called multidimensional clustering (MDC), which co-exists with other classical forms of data storage and  ...  Background DB2 UDB V8.1 MDC implementation In the MDC implementation in DB2 UDB V8.1 proposed by Padmanabhan et al.  ... 
doi:10.1016/b978-012088469-8/50102-9 fatcat:fqqvycrrlzgjnkm5wg4bq4j2eq

IBM's Enterprise Server for Java

I. F. Brackenbury, D. F. Ferguson, K. D. Gottschalk, R. A. Storey
1998 IBM Systems Journal  
A database; the default here is IBM’s DB2 UDB. 3.  ...  A high-performance static SOL API, this API is preferred for serious high-performance access to existing relational databases such as IBM’s DB2 Universal Database* (UDB). JMS: Java Message Service.  ... 
doi:10.1147/sj.373.0323 fatcat:z3bfvi7zx5cfvihjsm3omb77ge

An Approach to Enabling Spatial OLAP by Aggregating on Spatial Hierarchy [chapter]

Long Zhang, Ying Li, Fangyan Rao, Xiulan Yu, Ying Chen, Dong Liu
2003 Lecture Notes in Computer Science  
In this paper, we propose a novel approach to enabling spatial OLAP by aggregating on the spatial hierarchy.  ...  A spatial index mechanism is employed to derive the spatial hierarchy for pre-aggregation and materialization, which in turn are leveraged by the OLAP system to efficiently answer spatial OLAP queries.  ...  DB2 UDB and Spatial Extender were used as the database server to support storing spatial objects. Our system runs on a desktop machine with Pentium III 750M CPU and 512M memory.  ... 
doi:10.1007/978-3-540-45228-7_5 fatcat:3s67y7dhhnd7hg4hqmfpvrrskm
« Previous Showing results 1 — 15 out of 78 results