Filters








468 Hits in 3.7 sec

DB2 Parallel Edition

C. K. Baru, G. Fecteau, A. Goyal, H. Hsiao, A. Jhingran, S. Padmanabhan, G. P. Copeland, W. G. Wilson
1995 IBM Systems Journal  
This paper describes the DB2@ Parallel Edition product that evolved from a prototype developed at IBM Research in Hawthorne, New York, and now is being jointly developed with the IBM Toronto laboratory-L  ...  These and other projects addressed important issues such as parallel algorithms for execution of important database operations, query optimization technique^,^,^ data placement,'@'3 and database performance  ...  DB2 Parallel Edition run time In order to execute a query plan or a DDL statement in parallel, DB2/6000 run-time mechanisms had to be augmented considerably.  ... 
doi:10.1147/sj.342.0292 fatcat:3mso35ij6bd6jk3sgrbashfrme

Usability and design considerations for an autonomic relational database management system

R. Telford, R. Horman, S. Lightstone, N. Markov, S. O'Connell, G. Lohman
2003 IBM Systems Journal  
This paper examines the ease-of-use ramifications of autonomic computing in the context of relational databases in general, and of the IBM ® DB2 ® Universal Database TM Version 8.1 autonomic computing  ...  system in particular.  ...  He subsequently joined IBM at the Toronto Lab, where he began working on the parallel database system, DB2 Parallel Edition. Recently, Mr.  ... 
doi:10.1147/sj.424.0568 fatcat:jbllg6et4rfkxnbegmwn7qzmia

Automating physical database design in a parallel database

Jun Rao, Chun Zhang, Nimrod Megiddo, Guy Lohman
2002 Proceedings of the 2002 ACM SIGMOD international conference on Management of data - SIGMOD '02  
Physical database design is important for query performance in a shared-nothing parallel database system, in which data is horizontally partitioned among multiple independent nodes.  ...  Our approach uses the query optimizer itself both to recommend candidate partitions for each table that will bene t each query in the workload, and to evaluate various combinations of these candidates.  ...  DB2 Parallel Database System: DB2 is based on a shared-nothing architecture. A collection of processors nodes are used to execute queries in parallel.  ... 
doi:10.1145/564691.564757 dblp:conf/sigmod/RaoZML02 fatcat:hopeashzdnbv7nbxordwqkszky

Automating physical database design in a parallel database

Jun Rao, Chun Zhang, Nimrod Megiddo, Guy Lohman
2002 Proceedings of the 2002 ACM SIGMOD international conference on Management of data - SIGMOD '02  
Physical database design is important for query performance in a shared-nothing parallel database system, in which data is horizontally partitioned among multiple independent nodes.  ...  Our approach uses the query optimizer itself both to recommend candidate partitions for each table that will bene t each query in the workload, and to evaluate various combinations of these candidates.  ...  DB2 Parallel Database System: DB2 is based on a shared-nothing architecture. A collection of processors nodes are used to execute queries in parallel.  ... 
doi:10.1145/564756.564757 fatcat:bqwpdp4iqfayhab3zxk75oxnfa

From Blackboard to Green Screen

Torsten Grust
2020 Datenbank-Spektrum  
AbstractWe report on the conversion of two advanced database courses from their classical in-lecture-hall setup into an all-digital remote format that was delivered via YouTube.  ...  This new focus on the live interaction with the underlying database systems, led us (1) to adopt the idea of SQL probe queries that are specifically crafted to reveal database internals and (2) a study  ...  The summer semester of 2020 was special in many ways and I do sincerely thank the three of them for being a dependable team.  ... 
doi:10.1007/s13222-020-00362-8 pmid:33390876 pmcid:PMC7770500 fatcat:gqfa55qgujadfladjurogefcle

Preface

Gene F. Hoffnagle
1995 IBM Systems Journal  
In this paper, Baru et al. describe DB2* Parallel Edition, the DB2 product that answers this requirement, executing all vital functions in parallel.  ...  The architecture and execu- tion model of DB2 Parallel Edition provide pro- cessor and disk storage scalability, large database capacity, query optimization, execution time op- timization, favorable transaction  ... 
doi:10.1147/sj.342.0144 fatcat:o52yve5ckjczbnws27zazdoifq

Decision support at Lands' End—An evolution

G. G. Bustamente, K. Sorenson
1994 IBM Systems Journal  
The operational complexity of managing all three would have required ad- ditional staffing. . lO parallelism in DB2 Version 3.1 was expected to significantly reduce the elapsed time of que- ries.  ...  Understanding what type of information was available and how to apply it was seen as key to maintaining optimal DB2 performance.  ... 
doi:10.1147/sj.332.0228 fatcat:v7kcx5oyvndi5mrrhnlr55ta44

Data integration through database federation

L. M. Haas, E. T. Lin, M. A. Roth
2002 IBM Systems Journal  
They can then be immediately used in DB2 queries. • Optimization.  ...  Last but not least, DB2 database federation technology optimizes queries for performance. Relational queries are nonprocedural.  ...  As a researcher and member of the Garlic project at IBM's Almaden Research Center, she contributed key advances in heterogeneous data integration techniques and federated query optimization and led efforts  ... 
doi:10.1147/sj.414.0578 fatcat:vkbmerkifjeqninxxuse57xram

MODELS AND SOLUTIONS FOR THE IMPLEMENTATION OF DISTRIBUTED SYSTEMS

Tarca Naiana, Vatuiu Teodora, Ghencea Adrian
2011 Annals of the University of Oradea: Economic Science  
, in line with Europe 2020, launched by the European Council in June 2010.  ...  Functionalities of such a system are difficult to understand, and they add to the non-functional requirements such as the use in practice, performance, cost, durability and security.  ...  -IBM DB2 Parallel Edition IBM developed its system of relational database management, DB2/6000, in a parallel multiprocessor architecture with hardware ranging from local networks and systems to single  ... 
doaj:334a7a0a88b34122950f076ad0c73eaf fatcat:jcyhfh3kzjfnvcnfdxpvqnayl4

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.  ...  Query Patroller [16] is a powerful query management tool included in DB2 Data Warehouse Enterprise Edition.  ... 
doi:10.1016/b978-012088469-8/50095-4 fatcat:eavxpmnxgjb3hlhwbyrrxexmq4

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

OS/2 EE Database Manager overview and technical highlights

P. Y. Chang, W. W. Myre
1988 IBM Systems Journal  
The interactive end-user tool included in the Os/2 EE Database Manager, called the OS/2 EE Query Man- ager, provides data entry, edit, query, report, and customized application support.  ...  It was developed in parallel with the IBM OS/2 operating system and has been opti- mized for the os/2 environment.  ... 
doi:10.1147/sj.272.0105 fatcat:szilw2uvffaghp7xjuyqwzdp4y

An overview of three relational data base products

S. Kahn
1984 IBM Systems Journal  
The task-oriented library of publications for DB2 was developed in parallel with the code.  ...  Other important results were obtained in query optimization, concur- rency control, authorization mechanisms, and tech- niques for dynamically changing the structure of stored data, i.e., adding columns  ... 
doi:10.1147/sj.232.0100 fatcat:tvdzoqpcjfgvlaxsxjhwd2e3h4

Open issues in parallel query optimization

Waqar Hasan, Daniela Florescu, Patrick Valduriez
1996 SIGMOD record  
We provide an overview of query processing in parallel database systems and discuss several open issues in the optimization of queries for parallel machines.  ...  Given a SQL query, parallel query optimization has the goal of finding a parallel plan that delivers the query result in minimal time.  ...  [26] , Oracle 7.3/Parallel Query Option [29] and IBM DB2/MVS [28] .  ... 
doi:10.1145/234889.234894 fatcat:kbvsxwxmxnhetg5adb47hx6bna

Operational analytics data management systems

Alexander Böhm, Jens Dittrich, Niloy Mukherjee, Ippokratis Pandis, Rajkumar Sen
2016 Proceedings of the VLDB Endowment  
for the Oracle database query optimizer, and Senior Staff Engineer at Sybase Inc. where he architected the Distributed Object Lock Manager and Metadata Manager for Sybase ASE Cluster Edition.  ...  optimization and distributed query processing.  ... 
doi:10.14778/3007263.3007319 fatcat:njsofcfmhjcxpgxvzolzogc53u
« Previous Showing results 1 — 15 out of 468 results