Principles of Database Query Processing for Advanced Applications (The Morgan Kaufmann Series in Data Management Systems) - Hardcover

Yu, Clement T.; Meng, Weiyi

Hardcover

ISBN 10: 1558604340 ISBN 13: 9781558604346

Publisher: Morgan Kaufmann, 1997

Synopsis

The aim of query processing is to find information in one or more databases and deliver it to the user quickly and efficiently. Traditional techniques work well for databases with standard, single-site relational structures, but databases containing more complex and diverse types of data demand new query processing and optimization techniques.

Most real-world data is not well structured. Today's databases typically contain much non-structured data such as text, images, video, and audio, often distributed across computer networks. In this complex milieu
(typified by the world wide Web), efficient and accurate query processing becomes quite challenging.

Principles of Database Query Processing for Advanced Applications teaches the basic concepts and techniques of query processing and optimization for a variety of data forms and database systems, whether structured or unstructured.

* This is the only reference work that covers query processing and optimization techniques for structured and unstructured data, written with the non-expert in mind, with a minimum of mathematical details.
* This book teaches query processing techniques for multimedia, object-oriented, deductive, parallel, and distributed databases, as well as heterogeneous multidatabase systems, fuzzy relational databases, and
techniques for different types of unstructured data.
* Each chapter contains examples, tables and figures, class exercises, and a detailed bibliography.

About this title

Review

Fortunately, most developers and end users never have to think about how database queries actually work. For those who want to know what happens under the hood, Principles of Database Query Processing for Advanced Applications provides a textbook-style guide to an important area of database theory--how queries work in a variety of databases, and the strategies and algorithms used to optimize them.

The book starts out on familiar ground, outlining the basics of relational databases, such as SQL and query optimization. After providing this foundation, the book quickly ventures into more cutting-edge turf, escorting readers through the emerging world of object-oriented databases (a much richer field, where the rules of optimization are not yet agreed upon). The guide delves into other areas where developers are likely to have to adopt a do-it-yourself approach to database design, including distributed database systems; multi-database systems, where data from several databases needs to be joined as efficiently as possible; and parallel-processing systems, where queries can be processed in parallel.

Subsequent chapters cover fuzzy logic queries and searching strategies that work with text and image databases. Each chapter provides exercises for the reader, making this a good textbook for students or professionals who need an authoritative source on the theory of database design.

About the Author

Clement Yu holds a Ph.D. in Computer Science from Cornell University, and is currently a professor in the Department of Electrical Engineering and Computer Science at the University of Illinois, Chicago. He served as chairman of the ACM Special Interest Group on Information Retrieval, as an advisory committee member to the National Science Foundation, and as general chair/program committee chair to several database/information retrieval conferences and workshops. He has consulted for System Development Corporation (now Unisys) on distributed query processing, for MCC and Unisql on query processing in heterogeneous database systems, worked on a fuzzy database system project for Omron Corporation. He is a member of Linden Technology which applies associative memory for advanced database applications. Dr. Yu is an associate editor/on the editorial board of IEEE Transactions on Knowledge and Data Engineering, the Journal of Distributed and Parallel Databases and the International Journal of Software Engineering and Knowledge Engineering. His research interests include database management, information retrieval for multimedia, and applications to medicine.

Weiyi Meng holds a Ph.D. from the University of Illinois, Chicago, and is an Assistant Professor in the Department of Computer Science at the State University of New York, Binghamton. His research interests include heterogeneous database systems, query processing, Internet-based information retrieval, view maintenance and fuzzy databases. He has published in many well-established journals and conference proceedings.

Edition details

• Publisher: Morgan Kaufmann
• Publication date: 1997
• ISBN 10: 1558604340
• ISBN 13: 9781558604346
• Binding: Hardcover
• Language: English
• Edition number: 1
• Number of pages: 512