dbms queries







The TEXTURE benchmark: measuring performance of text queries on a relational DBMS
free download

We introduce a benchmark called TEXTURE (TEXT Under RElations) to measure the relative strengths and weaknesses of combining text processing with a relational workload in an RDBMS. While the well-known TREC benchmarks focus on quality, we focus on

QBE-like Queries and Multimedia Extensions in a Nested Relational DBMS
free download

We introduce ESCHER, a prototype database system based on the extended non-first- normal-form data model. The nested table approach is the paradigm for the graphical interface which allows browsing, editing and querying the database. Interaction is achieved

Running SPARQL-Fulltext Queries Inside a Relational DBMS
free download

Running SPARQL-Fulltext Queries Inside a Relational DBMS Arunav Mishra Sairam Gurajada and Martin Theobald1 Max Planck Institute for Informatics, Saarbrücken, Germany Abstract. We describe the indexing, ranking, and query processing techniques we implemented

Optimizing SQL Recursive Queries in a Column DBMS
free download

ABSTRACT PENDING: Graphs represent a major challenge on big data analytics, for which there are many systems and prototypes, most of them not based on relational database management systems (DBMSs). Graph problems require substantially different algorithms

Heuristic Optimization of SPARQL queries over Column-Store DBMS
free download

During the last decade we have witnessed a tremendous increase in the amount of semantic data available on the Web in almost every field of human activity. More and more corporate, governmental, or even user-generated datasets break the walls of private management

Object-relational DBMS -the next wave
free download

In this paper we present a classification of the applications that require DBMS technology and show where Relational DBMSs, Object-oriented DBMSs and Object-Relational DBMSs fit. Our purpose is to indicate the kinds of problems each kind of DBMS solves. As will be

Monet: A next-generation DBMS kernel for query-intensive applications
free download

3.11 Monet Goals 21 3.22 Relational Performance Problems 22 3.2. 11 Problem 1: Column- Access to Row-Storage 23 3.2. 22 Problem 2: Commodity Hardware Has Changed 24 3.33 Monet Architecture 27 3.3. 11 idea 1: provide DBMS back-end functionality 27 3.3. 22 idea 2

Alert: An Architecture for Transforming a Passive DBMS into an Active DBMS .
free download

Page 1. Alert: An Architecture for Transforming a Passive DBMS into an Active DBMS Ulf Schreier, Hamid Pirasesh, Rakesh Agrawal, C. Mohan IBM Almaden Research Center Page 2. Alert Idea Does not build an Active DMBS from scratch Extends a Passive DBMS into an Active DMBS

Query optimization in a heterogeneous dbms
free download

We propose a query optimization strategy for heterogeneous DBMSs that extends the traditional optimizer strategy widely used in commercial DBMSs to allow execution of queries over both known (ie, proprietary) DBMSs and foreign vendor DBMSs that conform to

The Global Memory Management in Client Server DBMS Architectures
free download

Earlier performance studies of client-server database systems have investigated algorithms for caching locks and data at client workstations to reduce latency and offload the server. These studies have been restricted to algorithms in which database pages that were not in This paper describes the VoltDB DBMS as it exists in mid 2013. The focus is on design decisions, especially in concurrency control and high availability, as well as on the application areas where the system has found acceptance. Run-time performance numbers

Using q-grams in a DBMS for approximate string processing
free download

String data is ubiquitous, and its management has taken on particular importance in the past few years. Approximate queries are very important on string data. This is due, for example, to the prevalence of typographical errors in data, and multiple conventions for recording

Tamino-a DBMS designed for XML
free download

Tamino is Sofware AGs XML database management system. In contrast to solutions of other DBMS vendors, Tamino is not just another layer on top of a database system designed to support the relational or an objectoriented data model. Rather, Tamino has been completely

DBMS research at a crossroads: The vienna update
free download

On April 2 1993 a panel discussion was held at the IEEE International Conference on Data Engineering in Vienna, Austria, at which five members of the data base research community discussed future research topics in the DBMS area. This paper summarizes the discussion

Cooperative scans: dynamic bandwidth sharing in a DBMS
free download

This paper analyzes the performance of concurrent (index) scan operations in both record (NSM/PAX) and column (DSM) disk storage models and shows that existing scheduling policies do not fully exploit data-sharing opportunities and therefore result in poor disk

Implementing High Level Active Rules on Top of a Relational DBMS .
free download

Active database systems have rules (usually called triggers), consisting of an event that causes a condition to be evaluated, and if true, results in the execution of a predefined action. However, existing trigger languages have a few drawbacks. First, the proposed

Supporting RFID-based item tracking applications in Oracle DBMS using a bitmap datatype
free download

Abstract Radio Frequency Identification (RFID) based item-level tracking holds the promise of revolutionizing supply-chain, retail store, and asset management applications. However, the high volume of data generated by item-level tracking poses challenges to the

CryptDB: A practical encrypted relational DBMS
free download

CryptDB is a DBMS that provides provable and practical privacy in the face of a compromised database server or curious database administrators. CryptDB works by executing SQL queries over encrypted data. At its core are three novel ideas: an SQL-aware

L/mrp: A buffer management strategy for interactive continuous data flows in a multimedia dbms
free download

Multimedia applications demand specific support from database management systems due to the characteristics of multimedia data and their interactive usage. This includes integrated support for high-volume and time-dependent (continuous) data types like audio and video

Future directions in DBMS research
free download

Abstract On February 4- 198 the International Computer Science Institute sponsored a two day workshop at which 16 senior members of the data base research community discussed future research topics in the DBMS area. This paper summarizes the discussion

A framework for supporting dbms -like indexes in the cloud
free download

To support Database as a service (DaaS) in the cloud, the database system is expected to provide similar functionalities as in centralized DBMS such as efficient processing of ad hoc queries. The system must therefore support DBMS -like indexes, possibly a few indexes for

Toward a General Spatial Data Model for an Object-Oriented DBMS .
free download

This paper describes the development of a general spatial data model for PROBE, a knowledge-oriented DBMS being developed at CCA [DAYA8 DAYASG]. The data model, called PDM, is an extension to the Daplex functional data model [SHIPII, FOX84]. The paper

Incorporating 3D geo-objects into a 2D geo- DBMS
free download

GISs are changing from static modeling in 2D to dynamic modeling in multi-dimensions. Yet, it will take a long time until the world has been defined within a full three-or four-dimensional approach. Besides that, a 2D approach still suffices in many cases and be also the most

SECONDO: An extensible DBMS architecture and prototype
free download

We describe SECONDO, an extensible DBMS platform suitable for building research prototypes and for teaching architecture and implementation of database systems. It does not have a fixed data model, but is open for implementation of new models. SECONDO

Visualisation and editing of 3D objects organised in a DBMS
free download

The developments in DBMSs are quite significant in the last several years. Mainstream DBMSs (Oracle, IBM DB Informix, Ingres) have already implemented spatial data types and spatial operators similar to the OpenGIS Consortium Simple Features Specification for

- -

FREE IEEE PAPER