Merged indexes are B-trees that contain multiple traditional indexes and interleave their records based on a common sort order. In relational databases, merged indexes implement “master-detail clustering” of related records, e.g., orders and order details. Thus, merged indexes shift de-normalization from the logical level of tables and rows to the physical level of indexes and records, which is...

Previous authors have shown how to build FM-indexes efficiently in external memory, but querying them efficiently remains an open problem. Searching näıvely for a pattern P requires Θ(|P |) random access. In this paper we show how, by storing a few small auxiliary tables, we can access data only in the order in which they appear on disk, which should be faster. An FM-index [4] is a compressed r...

This report describes the results of a set of experiments conducted with AIMS (Assisted Indexing at Mississippi State), a system that aids human document analysts in the assignment of indexes to physical chemistry journal articles. We defined four different experiments using four different combinations of portions of an article (such as the title and the abstract) to determine which portions of...

One of the fundamental tasks that data warehouse (DW) administrator needs to perform during the physical design is to select the right indexes to speed up her/his queries. Two categories of indexes are available and supported by the main DBMS vendors: (i) indexes defined on a single table and (ii) indexes defined on multiple tables such as join indexes, bitmap join indexes, etc. Selecting relev...