A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2006; you can also visit the original URL.
The file type is application/pdf.
Filters
DB2 Parallel Edition
1995
IBM Systems Journal
Preserved Fulltext
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
2003
IBM Systems Journal
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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
2002
Proceedings of the 2002 ACM SIGMOD international conference on Management of data - SIGMOD '02
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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
2002
Proceedings of the 2002 ACM SIGMOD international conference on Management of data - SIGMOD '02
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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
2020
Datenbank-Spektrum
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2021; you can also visit the original URL.
The file type is application/pdf.
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
1995
IBM Systems Journal
Preserved Fulltext
The Internet Archive has digitized a microfilm copy of this work. It may be possible to borrow a copy for reading.
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
1994
IBM Systems Journal
Preserved Fulltext
The Internet Archive has digitized a microfilm copy of this work. It may be possible to borrow a copy for reading.
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
2002
IBM Systems Journal
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2005; you can also visit the original URL.
The file type is application/pdf.
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
2011
Annals of the University of Oradea: Economic Science
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2020; you can also visit the original URL.
The file type is application/pdf.
, 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]
2004
Proceedings 2004 VLDB Conference
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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
2006
IBM Systems Journal
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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
1988
IBM Systems Journal
Preserved Fulltext
The Internet Archive has digitized a microfilm copy of this work. It may be possible to borrow a copy for reading.
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
1984
IBM Systems Journal
Preserved Fulltext
The Internet Archive has digitized a microfilm copy of this work. It may be possible to borrow a copy for reading.
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
1996
SIGMOD record
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2017; you can also visit the original URL.
The file type is application/pdf.
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
2016
Proceedings of the VLDB Endowment
Preserved Fulltext
A copy of this work was available on the public web and has been preserved in the Wayback Machine. The capture dates from 2019; you can also visit the original URL.
The file type is application/pdf.
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