A proposed method for handling queries of mixed workloads in databases

Author

Diksha ; Jain, S.K.

Author_Institution

Dept. of Comput. Eng., Nat. Inst. of Technol., Kurukshetra, India

fYear

2014

fDate

5-6 Sept. 2014

Firstpage

1

Lastpage

5

Abstract

Various real time workloads that run on very large databases contain both short transaction processing queries and long running queries. The long running queries are complex, require more resources and may take hours to complete (mostly OLAP queries). These long running queries may degrade the performance of quick response queries by making them wait longer in the queue. These queries in the real world scenario are a well known problem in both traditional databases and main memory databases. In this paper, we present a solution to organize the queries of mixed workloads in traditional databases.

Keywords

data mining; database management systems; query processing; OLAP queries; large databases; long running queries; memory databases; mixed workloads; query handling; quick response queries; short transaction processing queries; Algorithm design and analysis; Communities; Databases; Image edge detection; Maintenance engineering; Partitioning algorithms; Schedules; Graph Partitioning; Mixed workload; OLAP; OLTP; Serializability; View Maintenance;

fLanguage

English

Publisher

ieee

Conference_Titel

Data Mining and Intelligent Computing (ICDMIC), 2014 International Conference on

Conference_Location

New Delhi

Print_ISBN

978-1-4799-4675-4

Type

conf

DOI

10.1109/ICDMIC.2014.6954227

Filename

6954227