R-tree Index Optimization

R-tree Index Optimization

Author: D. M. Gavrila

Publisher:

Published: 1994

Total Pages: 20

ISBN-13:

DOWNLOAD EBOOK

Abstract: "The optimization of spatial indexing is an increasingly important issue considering the fact that spatial databases, in such diverse areas as geographical, CAD/CAM and image applications, are growing rapidly in size and often contain on the order of millions of items or more. This necessitates the storage of the index on disk, which has the potential of slowing down the access time significantly. In this paper, we discuss ways of minimizing the disk access frequency by grouping together data items which are close to one another in the spatial domain ('packing'). The data structure which we seek to optimize here is the R- tree for a given set of data objects. Existing methods of building an R- tree index based on space-filling curves (Peano, Hilbert) are computationally cheap, but they do not preserve spatial locality well, in particular when dealing with higher-dimensional data of non-zero extent. On the other hand, existing methods of packing based on all dimensions of the data, such as the several proposed dynamic R-tree insertion algorithms, do not take advantage of the fact that all the data objects are known beforehand. Furthermore, they are essentially serial in nature. In this paper, we regard packing as an optimization problem and propose an iterative method of finding a close-to-optimal solution to the packing of a given set of spatial objects in D dimensions. The method achieves a high degree of parallelism by constructing the R-tree bottom-up. In experiments on data of various dimensionalities and distributions, we have found that the proposed method can significantly improve on the packing performance of the R* insertion algorithm and the Hilbert curve. It is shown that the improvements increase with the skewness of the data and, in some cases, can even amount to an order of magnitude in terms of decreased response time."


R-Trees: Theory and Applications

R-Trees: Theory and Applications

Author: Yannis Manolopoulos

Publisher: Springer Science & Business Media

Published: 2010-09-08

Total Pages: 194

ISBN-13: 1846282934

DOWNLOAD EBOOK

Space support in databases poses new challenges in every part of a database management system & the capability of spatial support in the physical layer is considered very important. This has led to the design of spatial access methods to enable the effective & efficient management of spatial objects. R-trees have a simplicity of structure & together with their resemblance to the B-tree, allow developers to incorporate them easily into existing database management systems for the support of spatial query processing. This book provides an extensive survey of the R-tree evolution, studying the applicability of the structure & its variations to efficient query processing, accurate proposed cost models, & implementation issues like concurrency control and parallelism. Written for database researchers, designers & programmers as well as graduate students, this comprehensive monograph will be a welcome addition to the field.


Modern B-Tree Techniques

Modern B-Tree Techniques

Author: Goetz Graefe

Publisher: Now Publishers Inc

Published: 2011

Total Pages: 216

ISBN-13: 1601984820

DOWNLOAD EBOOK

Invented about 40 years ago and called ubiquitous less than 10 years later, B-tree indexes have been used in a wide variety of computing systems from handheld devices to mainframes and server farms. Over the years, many techniques have been added to the basic design in order to improve efficiency or to add functionality. Examples include separation of updates to structure or contents, utility operations such as non-logged yet transactional index creation, and robust query processing such as graceful degradation during index-to-index navigation. Modern B-Tree Techniques reviews the basics of B-trees and of B-tree indexes in databases, transactional techniques and query processing techniques related to B-trees, B-tree utilities essential for database operations, and many optimizations and improvements. It is intended both as a tutorial and as a reference, enabling researchers to compare index innovations with advanced B-tree techniques and enabling professionals to select features, functions, and tradeoffs most appropriate for their data management challenges.


An R-tree Index Using the STL Style

An R-tree Index Using the STL Style

Author: Ming An Zhong

Publisher:

Published: 2004

Total Pages: 0

ISBN-13:

DOWNLOAD EBOOK

Indexes are critical for performance of database systems. Trees are effective indexes that handle both single-dimensional and multi-dimensional data. The R-tree is a commonly used multi-dimensional tree index for the spatial data and geographic information system (GIS). By using design pattern and following the C++ STL style, the R-tree index structure in this thesis is designed and implemented using generic programming techniques. The components are designed to be the STL style containers so that they have a uniform and clear interface and can be used like a standard container. The R-tree structure can adapt to different data types, user-defined key types, and support user-defined queries.


Database and Expert Systems Applications

Database and Expert Systems Applications

Author: Vladimir Marik

Publisher: Springer Science & Business Media

Published: 2003-08-21

Total Pages: 963

ISBN-13: 3540408061

DOWNLOAD EBOOK

This book constitutes the refereed proceedings of the 14th International Conference on Database and Expert Systems Applcations, DEXA 2003, held in Prague, Czech Republic, in September 2003. The 91 revised full papers presented together with an invited paper and a position paper were carefully reviewed and selected from 236 submissions. The papers are organized in topical sections on XML, data modeling, spatial database systems, mobile computing, transactions, bioinformatics, information retrieval, multimedia databases, Web applications, ontologies, object-oriented databases, query optimization, workflow systems, knowledge engineering, and security.


Database and Expert Systems Applications

Database and Expert Systems Applications

Author: Stephane Bressan

Publisher: Springer Science & Business Media

Published: 2006-08-29

Total Pages: 977

ISBN-13: 3540378715

DOWNLOAD EBOOK

This book constitutes the refereed proceedings of the 17th International Conference on Database and Expert Systems Applications, DEXA 2006. The book presents 90 revised full papers together with 1 invited paper. The papers are organized in topical sections on XML, data and information, data mining and data warehouses, database applications, WWW, bioinformatics, process automation and workflow, knowledge management and expert systems, database theory, query processing, and privacy and security.


PostgreSQL Essential Reference

PostgreSQL Essential Reference

Author: Barry Stinson

Publisher: Sams Publishing

Published: 2001

Total Pages: 406

ISBN-13: 9780735711211

DOWNLOAD EBOOK

A hands-on solution provider to PostgreSQL. Expert advice by a highly respected author within the PostgreSQL user community, this book provides detailed, useable information in the popular Essential Reference format. Includes tables within each chapter that organize the material both alphabetically and by task so that readers will have two options for finding the information.


Computational Science - ICCS 2007

Computational Science - ICCS 2007

Author: Yong Shi

Publisher: Springer Science & Business Media

Published: 2007-05-18

Total Pages: 1310

ISBN-13: 3540725830

DOWNLOAD EBOOK

Annotation The four-volume set LNCS 4487-4490 constitutes the refereed proceedings of the 7th International Conference on Computational Science, ICCS 2007, held in Beijing, China in May 2007. More than 2400 submissions were made to the main conference and its 35 topical workshops. The 80 revised full papers and 11 revised short papers of the main track were carefully reviewed and selected from 360 submissions and are presented together with 624 accepted workshop papers in four volumes. According to the ICCS 2007 theme "Advancing Science and Society through Computation" the papers cover a large volume of topics in computational science and related areas, from multiscale physics, to wireless networks, and from graph theory to tools for program development. The papers are arranged in topical sections on efficient data management, parallel monte carlo algorithms, simulation of multiphysics multiscale systems, dynamic data driven application systems, computer graphics and geometric modeling, computer algebra systems, computational chemistry, computational approaches and techniques in bioinformatics, computational finance and business intelligence, geocomputation, high-level parallel programming, networks theory and applications, collective intelligence for semantic and knowledge grid, collaborative and cooperative environments, tools for program development and analysis in CS, intelligent agents in computing systems, CS in software engineering, computational linguistics in HCI, internet computing in science and engineering, workflow systems in e-science, graph theoretic algorithms and applications in cs, teaching CS, high performance data mining, mining text, semi-structured, Web, or multimedia data, computational methods in energy economics, risk analysis, advances in computational geomechanics and geophysics, meta-synthesis and complex systems, scientific computing in electronics engineering, wireless and mobile systems, high performance networked media and services, evolution toward next generation internet, real time systems and adaptive applications, evolutionary algorithms and evolvable systems.


Web and Wireless Geographical Information Systems

Web and Wireless Geographical Information Systems

Author: Christophe Claramunt

Publisher: Springer

Published: 2005-05-03

Total Pages: 265

ISBN-13: 3540319646

DOWNLOAD EBOOK

The main topic of the W2GIS workshop is theoretical and technical issues of Web and wireless geographical information systems. This workshop followed the successful 2001, 2002 and 2003 editions, held in Kyoto, Singapore and Rome, respectively. The 2004 edition was held in Goyang, Korea.


Database and Expert Systems Applications

Database and Expert Systems Applications

Author: Qiming Chen

Publisher: Springer

Published: 2015-08-10

Total Pages: 542

ISBN-13: 3319228528

DOWNLOAD EBOOK

This two volume set LNCS 9261 and LNCS 9262 constitutes the refereed proceedings of the 26th International Conference on Database and Expert Systems Applications, DEXA 2015, held in Valencia, Spain, September 1-4, 2015. The 40 revised full papers presented together with 32 short papers, and 2 keynote talks, were carefully reviewed and selected from 125 submissions. The papers discuss a range of topics including: temporal, spatial and high dimensional databases; semantic Web and ontologies; modeling, linked open data; NoSQLm NewSQL, data integration; uncertain data and inconsistency tolerance; database system architecture; data mining, query processing and optimization; indexing and decision support systems; modeling, extraction, social networks; knowledge management and consistency; mobility, privacy and security; data streams, Web services; distributed, parallel and cloud databases; information retrieval; XML and semi-structured data; data partitioning, indexing; data mining, applications; WWW and databases; data management algorithms. These volumes also include accepted papers of the 8th International Conference on Data Management in Cloud, Grid and P2P Systems, Globe 2015, held in Valencia, Spain, September 2, 2015. The 8 full papers presented were carefully reviewed and selected from 13 submissions. The papers discuss a range of topics including: MapReduce framework: load balancing, optimization and classification; security, data privacy and consistency; query rewriting and streaming.