Patent
Data query method and device
Zhang Gan
- 16 Jul 2019
TL;DR: In this article, the authors proposed a data query method and device that comprises: acquiring a query request, establishing at least one plan tree according to the query request; determining the cost of each plan tree, according to a preset network transmission weight coefficient, an I/O weight coefficient and a CPU calculation weight coefficient.
read more
Abstract: The embodiment of the invention provides a data query method and device The method comprises: acquiring a query request; establishing at least one plan tree according to the query request; determining the cost of each plan tree according to a preset network transmission weight coefficient, an I/O weight coefficient and a CPU calculation weight coefficient; and querying data according to the plantree with the lowest cost By applying the embodiment of the invention, the data query efficiency is improved
read more
Chat with Paper
AI Agents for this Paper
Find similar papers on Google Scholar, PubMed and Arxiv
Write a critical review of this paper
Analyze citations of this paper to find unaddressed research gaps
References
Patent
Lossless data compression and real-time decompression
Prabhat Mishra,Seok-Won Seong,Kanad Basu,Weixun Wang,Xiaoke Qin,Chetan Murthy +5 more
- 05 Nov 2008
TL;DR: In this paper, a dictionary is built based upon the set of maximum values in the frequency distribution and a bit mask savings which is a number of bits reduced using each of the multiple bit masks.
110
Patent
Autonomic recommendation and placement of materialized query tables for load distribution
Wen-Syan Li,Daniele Costante Zilio +1 more
- 26 Jan 2006
TL;DR: In this article, a system and method of evaluating queries in distributed databases with MQTs is proposed, where the query execution efficiency comprises observed response time at a front-end database and associated costs comprising computational central processing unit costs, input/output costs, and network communication costs.
27
Patent
Distributed space data enquiring and optimizing method under gridding calculation environment
Chuanjie Xie,Gaohuan Liu +1 more
- 15 Apr 2009
TL;DR: In this article, a distributed spatial data query optimization method in a grid computing environment is applicable to the grid computing environments and comprises the following steps: (1) analyzing user queries to form a spatial join operation diagram of two or more spatial data grid services; (2) generating an estimation cost matrix of a spatial joins operation which possibly exist among the spatial data Grid services according to the spatial join operator diagram; (3) adopting a progressive query optimization approach to update the cost matrix orderly; and (4) selecting a more preferable spatial join operations according to a formation rule of the spatial
13
Patent
One-pass join size estimation with correlated sampling
David Vengerov,Mohamed Zait,Sunil P. Chakkappen,Andre Menck +3 more
- 29 Jun 2015
TL;DR: In this paper, the system receives a query of a plurality of tables under a join condition on an attribute and determines a uniform mapping that maps a domain of the attribute into a set of numbers, where the domain includes all attribute values taken by the attribute in the tables.
12
Cost-based Query Optimization for XPath
TL;DR: This article focuses on the issue of how to determine the execution order for a given XPath expression according to the cost models, and a heuristic-based dynamic programming approach is proposed to determined the optimal execution tree.