Advanced Query Processing

Advanced Query Processing
Author: Barbara Catania
Publisher: Springer Science & Business Media
Total Pages: 355
Release: 2012-07-28
Genre: Technology & Engineering
ISBN: 3642283233

This research book presents key developments, directions, and challenges concerning advanced query processing for both traditional and non-traditional data. A special emphasis is devoted to approximation and adaptivity issues as well as to the integration of heterogeneous data sources. The book will prove useful as a reference book for senior undergraduate or graduate courses on advanced data management issues, which have a special focus on query processing and data integration. It is aimed for technologists, managers, and developers who want to know more about emerging trends in advanced query processing.

Scalable Processing of Spatial-Keyword Queries

Scalable Processing of Spatial-Keyword Queries
Author: Ahmed R. Mahmood
Publisher: Springer Nature
Total Pages: 98
Release: 2022-05-31
Genre: Computers
ISBN: 3031018672

Text data that is associated with location data has become ubiquitous. A tweet is an example of this type of data, where the text in a tweet is associated with the location where the tweet has been issued. We use the term spatial-keyword data to refer to this type of data. Spatial-keyword data is being generated at massive scale. Almost all online transactions have an associated spatial trace. The spatial trace is derived from GPS coordinates, IP addresses, or cell-phone-tower locations. Hundreds of millions or even billions of spatial-keyword objects are being generated daily. Spatial-keyword data has numerous applications that require efficient processing and management of massive amounts of spatial-keyword data. This book starts by overviewing some important applications of spatial-keyword data, and demonstrates the scale at which spatial-keyword data is being generated. Then, it formalizes and classifies the various types of queries that execute over spatial-keyword data. Next, it discusses important and desirable properties of spatial-keyword query languages that are needed to express queries over spatial-keyword data. As will be illustrated, existing spatial-keyword query languages vary in the types of spatial-keyword queries that they can support. There are many systems that process spatial-keyword queries. Systems differ from each other in various aspects, e.g., whether the system is batch-oriented or stream-based, and whether the system is centralized or distributed. Moreover, spatial-keyword systems vary in the types of queries that they support. Finally, systems vary in the types of indexing techniques that they adopt. This book provides an overview of the main spatial-keyword data-management systems (SKDMSs), and classifies them according to their features. Moreover, the book describes the main approaches adopted when indexing spatial-keyword data in the centralized and distributed settings. Several case studies of {SKDMSs} are presented along with the applications and query types that these {SKDMSs} are targeted for and the indexing techniques they utilize for processing their queries. Optimizing the performance and the query processing of {SKDMSs} still has many research challenges and open problems. The book concludes with a discussion about several important and open research-problems in the domain of scalable spatial-keyword processing.

Continuous Spatial Query Processing in Mobile Information Systems

Continuous Spatial Query Processing in Mobile Information Systems
Author: Shauli Sarmin Sumi
Publisher:
Total Pages:
Release: 2017
Genre:
ISBN:

Nowadays, many mobile applications provide location-based services that allow users to access location-related information from anywhere, whenever they desire. A moving user can issue queries to access information about moving or static objects. Continuous spatial query processing systems are used for this type of application. We propose two query processing strategies for location based services. The objectives of our strategies are to reduce: (1) the server workload, (2) the data transmission cost and (3) the query response time, for location-based services while providing an answer for a continuous region query. We compare our first strategy with a brute-force strategy and found that our strategy can significantly reduce the server workload and data transmission cost over the brute-force method. We compare our improved strategy with the original strategy and brute-force strategy. The experimental results show that the improved strategy achieves lower query response time than the original and brute-force strategy.

Qualitative Spatial and Temporal Reasoning

Qualitative Spatial and Temporal Reasoning
Author: Gérard Ligozat
Publisher: John Wiley & Sons
Total Pages: 417
Release: 2013-05-21
Genre: Computers
ISBN: 1118601564

Starting with an updated description of Allen's calculus, the book proceeds with a description of the main qualitative calculi which have been developed over the last two decades. It describes the connection of complexity issues to geometric properties. Models of the formalisms are described using the algebraic notion of weak representations of the associated algebras. The book also includes a presentation of fuzzy extensions of qualitative calculi, and a description of the study of complexity in terms of clones of operations.

Advanced Query Processing on Spatial Networks

Advanced Query Processing on Spatial Networks
Author: MAN-LUNG. YIU
Publisher:
Total Pages:
Release: 2017-01-27
Genre:
ISBN: 9781361418345

This dissertation, "Advanced Query Processing on Spatial Networks" by Man-lung, Yiu, 姚文龍, was obtained from The University of Hong Kong (Pokfulam, Hong Kong) and is being sold pursuant to Creative Commons: Attribution 3.0 Hong Kong License. The content of this dissertation has not been altered in any way. We have altered the formatting in order to facilitate the ease of printing and reading of the dissertation. All rights not granted by the above license are retained by the author. Abstract: Abstract of thesis entitled "Advanced Query Processing on Spatial Networks" Submitted by Man Lung Yiu for the degree of Doctor of Philosophy at the University of Hong Kong in February 2006 Recent advances in GPS and mobile communication technologies have al- lowedapplicationstoemergethatcanaccessandexploitlocationinformation about (moving) objects on road networks. Location-based services enable car drivers to search for facilities such as restaurants, shops, and car-parks close to their route. Logistic services monitor the status of delivery vehi- cles and ensure the timely delivery of goods. In this class of applications, both the accessibility and location of objects (e.g., vehicles and facilities) are constrained by the underlying network. The actual distance between two objects is defined by their shortest path distance on the network rather than their Euclidean distance. These network constraints significantly increase the complexity of retrieving spatial query results. Thus, query processing on spatial networks (i.e., road networks) has received considerable attention from database researchers in recent years. In this thesis, we identify three interesting problems and study their eval- uation in the context of spatial networks: (i) aggregate nearest neighbor (ANN) query, (ii) reverse nearest neighbor (RNN) query, and (iii) cluster- ing. Our findings for (i) and (ii) provide meaningful results for end-users, while our results for (iii) provide effective data exploration tools for data analysts. Aggregate nearest neighbor (ANN) queries are generalized from the nearest neighbor problem, allowing a group of mobile users to express individual preferences for reaching the best overall facility (e.g., a restau- rant). Reverse nearest neighbor (RNN) queries are relevant to applications in decision support and resource allocation, enabling users to retrieve data objects locationally influenced by a query object. Clustering can be applied to discover dense collections of data objects, indicating regions of special interest. The process of computing results for these problems on spatial networks is complicated by the shortest path definition of the distance between two ob- jects. Naive evaluation methods may lead to numerous expensive network distance computations, and may not scale well for large networks and large datasets. Our main research objective is the design of appropriate opti- mization techniques for the proposed problems, that incur low I/O cost ofaccessing the spatial network. We also investigate several variants of these problems in order to expand the application scope of our proposed techniques. Variants of ANN queries include aggregate center queries and weighted queries. RNN queries have bichromatic and continuous variants. Clustering is also applicable with sev- eral grouping criteria. An abstract of exactly 388 words Signed Man Lung Yiu DOI: 10.5353/th_b3627936 Subjects: Nearest neighbor analysis (Statistics) Database management Cluster analysis

Continuous Spatial Query Processing Over Clustered Data Set

Continuous Spatial Query Processing Over Clustered Data Set
Author: Farzin Keykavoosamand
Publisher:
Total Pages:
Release: 2018
Genre:
ISBN:

There exists an increasing usage rate of location-based information from mobile devices, which requires new query processing strategies. One such strategy is a moving (continuous) region query in which a moving user continuously sends queries to a central server to obtain data or information. In this thesis, we introduce two strategies to process a spatial moving query over clustered data sets. Both strategies utilize a validity region approach on the client in order to minimize the number of queries that are sent to the server. We explore the use of a two-dimensional indexing strategy, as well as the use of Expectation Maximization (EM) and k-means clustering. Our experiments show that both strategies outperform a Baseline strategy where all queries are sent to the server, with respect to data transmission, response time, and workload costs.