Title :
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
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;
Conference_Titel :
Data Mining and Intelligent Computing (ICDMIC), 2014 International Conference on
Conference_Location :
New Delhi
Print_ISBN :
978-1-4799-4675-4
DOI :
10.1109/ICDMIC.2014.6954227
