For the music database retrieval, the researchers extract the features, such as melodies, rhythms and chords, from the music data and develop indices to support the quick music search. Several reports have pointed out that these features can be transformed and represented in the forms of music feature strings or numeric values such that string indexing or numeric indexing is created, respective...

It is desirable to store text data in a database so that the basic functions are provided by the underlying database management system (DBMS). However, most DBMSs use English-like semantics as the query language for data manipulation. Although they can be localized to users' preferred languages, text processing under database systems are still far short of support for handling ideographic chara...

This study provides an experimental performance evaluation on population-based queries of NoSQL databases storing archetype-based Electronic Health Record (EHR) data. There are few published studies regarding the performance of persistence mechanisms for systems that use multilevel modelling approaches, especially when the focus is on population-based queries. A healthcare dataset with 4.2 mill...

Ideally, realizing the best physical design for the current and all subsequent workloads would impact neither performance nor storage usage. In reality, workloads and datasets can change dramatically over time and index creation impacts the performance of concurrent user and system activity. We propose a framework that evaluates the key premise of adaptive indexing — a new indexing paradigm whe...

The constant flux of data and queries alike has been pushing the boundaries of data analysis systems. The increasing size of raw data files has made data loading an expensive operation that delays the data-to-insight time. Hence, recent in-situ query processing systems operate directly over raw data, alleviating the loading cost. At the same time, analytical workloads have increasing number of ...

In this paper we discuss indexing methods for On-Line Analytical Processing (OLAP) databases. We start with a survey of existing indexing methods and discuss their advantages and shortcomings. We then propose extensions to conventional multidimensional indexing methods to make them more suitable for indexing OLAP data. We compare and contrast R-trees with bit-mapped indices which is the most po...

Real estate market prosperity is crucial to a nation’s economy as well as people’s livelihood, especially for the emerging economy. In China, the real estate market has been overheated since the reform of urban housing system in 1998. Due to the price diversity and region variations, the traditional real estate indicators released by the government became insufficient in explaining local real e...

BACKGROUND We would expect information on adverse drug reactions in randomised clinical trials to be easily retrievable from specific searches of electronic databases. However, complete retrieval of such information may not be straightforward, for two reasons. First, not all clinical drug trials provide data on the frequency of adverse effects. Secondly, not all electronic records of trials inc...

We present an initial analysis of the National Library of Medicine's (NLM) Gene Indexing initiative. Gene Indexing occurs at the time of indexing for all 4600 journals and over 500,000 articles added to PubMed/MEDLINE each year. Gene Indexing links articles about the basic biology of a gene or protein within eight model organisms to a specific record in the NLM's LocusLink database of gene prod...

In modern universal database management systems (DBMSs) userdefined data types along with extensible indexing structures try to bridge the gap between standard data-independent DBMS implementations and the requirement of specialized access methods for efficient domain-specific data retrieval, maintenance, and storage. However, these approaches often suffer from restricting the degree of freedom...