A thorough presentation of query processing techniques in a broad range of database systems for advanced applications. Provides the most effective query processing techniques and ways to optimize the information retrieval process. Intended for database systems designers creating advanced applications.

This book is an anthology of the results of research and development in database query processing during the past decade. The relational model of data provided tremendous impetus for research into query processing. Since a relational query does not specify access paths to the stored data, the database management system (DBMS) must provide an intelligent query-processing subsystem which will evaluate a number of potentially efficient strategies for processing the query and select the one that optimizes a given performance measure. The degree of sophistication of this subsystem, often called the optimizer, critically affects the performance of the DBMS. Research into query processing thus started has taken off in several directions during the past decade. The emergence of research into distributed databases has enormously complicated the tasks of the optimizer. In a distributed environment, the database may be partitioned into horizontal or vertical fragments of relations. Replicas of the fragments may be stored in different sites of a network and even migrate to other sites. The measure of performance of a query in a distributed system must include the communication cost between sites. To minimize communication costs for-queries involving multiple relations across multiple sites, optimizers may also have to consider semi-join techniques.

The 9th International Conference on Database Systems for Advanced Applications (DASFAA 2004) was held during March 17-19, 2004 on the beautiful Jeju island of Korea. The DASFAA conference provides an international forum for technical discussions among researchers, developers, and users of database - stems from academia, business, and industry. The main focus of DASFAA is on research in database theory, development of advanced DBMS technologies, and their advanced applications. A premier database conference in the Asia/Pacific region, DASFAA has been held every two years, and in many countries in the region. To promote the area further and to answer the needs of many participants, the steering committee decided to hold the conference annually. DASFAA 2004 was the first such annual conference. The conference was organized by the Special Interest Group on Databases (SIGDB) of the Korea Information Science Society and the Advanced Information Technology Research Center (AITrc) at KAIST - an engineering research center of excellence (ERC) supported by the Korea Science and Engineering Foundation (KOSEF). We had a number of sponsors who made generous contributions to make the conference successful. They are Oracle Korea, Samsung SDS, Korea Telecom Data, Inc., the United States Air Force Office of Scientific Research, the Asian Office of Aerospace Research & Development, the Army Research Office-Far East, and the Korea Advanced Institute of Science and Technology (KAIST).

This guide documents SQL: 1999Us advanced features in the same practical, "programmercentric" way that the first volume documented the language's basic features. This is no mere representation of the standard, but rather authoritative guidance on making an application conform to it, both formally and effectively.

The chapters of this book provide an excellent snapshot of current research and development activities in the area of query processing and optimization. They supply potential answers to many questions that have been raised for new types of database systems and at the same time reflect the variety of the different approaches taken. The book acts both as a reference for the state of the art in query processing for the "next generation" of database systems, and as a good starting point for anybody interested in understanding the challenging questions in the area. Furthermore, the book will help the reader to gain an in-depth understanding of why efficient query processing is needed for future database systems.

SQL: 1999 is the best way to make the leap from SQL-92 to SQL:1999, but it is much more than just a simple bridge between the two. The latest from celebrated SQL experts Jim Melton and Alan Simon, SQL:1999 is a comprehensive, eminently practical account of SQL's latest incarnation and a potent distillation of the details required to put it to work. Written to accommodate both novice and experienced SQL users, SQL:1999 focuses on the language's capabilities, from the basic to the advanced, and the ways that real applications take advantage of them. Throughout, the authors illustrate features and techniques with clear and often entertaining references to their own custom database. Gives authoritative coverage from an expert team that includes the editor of the SQL-92 and SQL:1999 standards. Provides a general introduction to SQL that helps you understand its constituent parts, history, and place in the realm of computer languages. Explains SQL:1999's more sophisticated features, including advanced value expressions, predicates, advanced SQL query expressions, and support for active databases. Explores key issues for programmers linking applications to SQL databases. Provides guidance on troubleshooting, internationalization, and changes anticipated in the next version of SQL. Contains appendices devoted to database design, a complete SQL:1999 example, the standardization process, and more.

Research and development surrounding the use of data queries is receiving increased attention from computer scientists and data specialists alike. Through the use of query technology, large volumes of data in databases can be retrieved, and information systems built based on databases can support problem solving and decision making across industries. The Handbook of Research on Innovative Database Query Processing Techniques focuses on the growing topic of database query processing methods, technologies, and applications. Aimed at providing an all-inclusive reference source of technologies and practices in advanced database query systems, this book investigates various techniques, including database and XML queries, spatiotemporal data queries, big data queries, metadata queries, and applications of database query systems. This comprehensive handbook is a necessary resource for students, IT professionals, data analysts, and academicians interested in uncovering the latest methods for using queries as a means to extract information from databases. This all-inclusive handbook includes the latest research on topics pertaining to information retrieval, data extraction, data management, design and development of database queries, and database and XM queries.

This book constitutes the refereed proceedings of the First International Conference on High-Performance Computing and Communications, HPCC 2005, held in Sorrento, Italy in September 2005. The 76 revised full papers and 44 revised short papers presented were carefully reviewed and selected from 273 submissions. The papers are organized in topical sections on network protocols, routing, and algorithms; languages and compilers for HPC; parallel and distributed system architectures; embedded systems; parallel and distributed algorithms, wireless and mobile computing, Web services and Internet computing; peer-to-peer computing, grid and cluster computing, reliability, fault-tolerance, and security; performance evaluation and measurement; tools and environments for software development; distributed systems and applications; high performance scientific and engineering computing; database applications and data mining; HPSRF; pervasive computing and communications; and LMS.

This text covers basic database concepts to provide a conceptual understanding of data and databases necessary for database design and development.

Principles of Transaction Processing is a comprehensive guide to developing applications, designing systems, and evaluating engineering products. The book provides detailed discussions of the internal workings of transaction processing systems, and it discusses how these systems work and how best to utilize them. It covers the architecture of Web Application Servers and transactional communication paradigms.The book is divided into 11 chapters, which cover the following: Overview of transaction processing application and system structureSoftware abstractions found in transaction processing systemsArchitecture of multitier applications and the functions of transactional middleware and database serversQueued transaction processing and its internals, with IBM's Websphere MQ and Oracle's Stream AQ as examplesBusiness process management and its mechanismsDescription of the two-phase locking function, B-tree locking and multigranularity locking used in SQL database systems and nested transaction lockingSystem recovery and its failuresTwo-phase commit protocolComparison between the tradeoffs of replicating servers versus replication resourcesTransactional middleware products and standardsFuture trends, such as cloud computing platforms, composing scalable systems using distributed computing components, the use of flash storage to replace disks and data streams from sensor devices as a source of transaction requests. The text meets the needs of systems professionals, such as IT application programmers who construct TP applications, application analysts, and product developers. The book will also be invaluable to students and novices in application programming. - Complete revision of the classic "non mathematical" transaction processing reference for systems professionals - Updated to focus on the needs of transaction processing via the Internet-- the main focus of business data processing investments, via web application servers, SOA, and important new TP standards - Retains the practical, non-mathematical, but thorough conceptual basis of the first edition