Keyword search in databases
By: Jeffrey Xu Yu, Lu Qin, and Lijun Chang
Contributors: Lu, Qin; Chang, Lijun
Series: Synthesis lectures on data management -- # 1
Publisher: Morgan & Claypool Publishers
Published: 2010
Place of publication: San Rafael, Calif. (1537 Fourth Street, San Rafael, CA 94901 USA)
Language: eng
Format: [electronic resource] /
Number of pages: 143
ISBN-13: 9781608451968; 9781608451951
Subjects: Keyword searching; Database searching
Other titles: Synthesis digital library of engineering and computer science.
Description: It has become highly desirable to provide users with flexible ways to query/search information over databases as simple as keyword search like Google search. This book surveys the recent developments on keyword search over databases, and focuses on finding structural information among objects in a database using a set of keywords. Such structural information to be returned can be either trees or subgraphs representing how the objects, that contain the required keywords, are interconnected in a relational database or in an XML database. The structural keyword search is completely different from finding documents that contain all the user-given keywords. The former focuses on the interconnected object structures, whereas the latter focuses on the object content.

The book is organized as follows. In Chapter 1, we highlight the main research issues on the structural keyword search in different contexts. In Chapter 2, we focus on supporting structural keyword search in a relational database management system using the SQL query language. We concentrate on how to generate a set of SQL queries that can find all the structural information among records in a relational database completely, and how to evaluate the generated set of SQL queries efficiently. In Chapter 3,we discuss graph algorithms for structural keyword search by treating an entire relational database as a large data graph. In Chapter 4, we discuss structural keyword search in a large tree-structuredXMLdatabase. In Chapter 5,we highlight several interesting research issues regarding keyword search on databases. The book can be used as either an extended survey for people who are interested in the structural keyword search or a reference book for a postgraduate course on the related topics.
Notes: Part of: Synthesis digital library of engineering and computer science.

Title from PDF t.p. (viewed on January 11, 2010).

Series from website.

Includes bibliographical references (133-141).

Abstract freely available; full-text restricted to subscribers or individual document purchasers.

Also available in print.

Mode of access: World Wide Web.

System requirements: Adobe Acrobat reader.
Table of contents: title: Preface; title: 1. Introduction; title: 2. Schema-based keyword search on relational databases: 2.1. Introduction; 2.2. Candidate network generation; 2.3. Candidate network evaluation; 2.4. Other keyword search semantics; title: 3. Graph-based keyword search: 3.1. Graph model and problem definition; 3.2. Polynomial delay and Dijkstra�s algorithm; 3.3. Steiner tree-based keyword search; 3.4. Distinct root-based keyword search; 3.5. Subgraph-based keyword search; title: 4. Keyword search in XML databases: 4.1. XML and problem definition; 4.2. SLCA-based semantics; 4.3. Identify meaningful return information; 4.4. ELCA-based semantics; 4.5. Other approaches; title: 5. Other topics for keyword search on databases: 5.1. Keyword search across databases; 5.2. Keyword search on spatial databases; 5.3. Variations of keyword search on databases; title: Bibliography; title: Authors' biographies.