Searching for related objects in relational databases
Xiaoxin Yin, Jiawei Han, Jiong Yang · 2005
To discover knowledge or retrieve information from a relational database, a user often needs to find objects related to certain source objects. There are two main challenges in building an e#ective object search system: the huge amount of objects in the database and the large number of di#erent relationships between objects. In this paper we introduce Ross, an e#cient and accurate relational object search system. Ross accepts complex queries that enable users to specify the relationships among objects. To measure the relationships of join paths, Ross considers the di#erent semantics of di#erent joins, and combines both selectivity and lengths of join paths to measure their strengths. A novel approach is used to find the best join paths between relations, which converts the database schema into a graph, so that the shortest paths in the graph correspond to best join paths in the database. Ross uses a stream-based system architecture to handle complex queries containing logical operators, which can find the most related objects upon users' requests. Comprehensive experiments are conducted to show the high scalability and e#ectiveness of Ross.