Repository logo

Infoscience

  • English
  • French
Log In
Logo EPFL, École polytechnique fédérale de Lausanne

Infoscience

  • English
  • French
Log In
  1. Home
  2. Academic and Research Output
  3. Conferences, Workshops, Symposiums, and Seminars
  4. Efficient query processing on unstructured tetrahedral meshes
 
conference paper

Efficient query processing on unstructured tetrahedral meshes

Papadomanolakis, Stratos
•
Ailamaki, Anastassia  
•
López, Julio C.
Show more
2006
Proceedings of the ACM SIGMOD
International Conference on Management of Data (SIGMOD)

Modern scientific applications consume massive volumes of data produced by computer simulations. Such applications require new data management capabilities in order to scale to terabyte-scale data volumes [32, 10]. The most common way to discretize the application domain is to decompose it into pyramids, forming an unstructured tetrahedral mesh. Modern simulations generate meshes of high resolution and precision, to be queried by a visualization or analysis tool. Tetrahedral meshes are extremely flexible and therefore vital to accurately model complex geometries, but also are difficult to index. To reduce query execution time, applications either use only subsets of the data or rely on different (less flexible) structures, thereby trading accuracy for speed. This paper presents efficient indexing techniques for generic spatial queries on tetrahedral meshes. Because the prevailing multidimensional indexing techniques attempt to approximate the tetrahedra using simpler shapes (rectangles) query performance deteriorates significantly as a function of the mesh’s geometric complexity. We develop Directed Local Search (DLS), an efficient indexing algorithm based on mesh topology information that is practically insensitive to the geometric properties of meshes. We show how DLS can be easily and efficiently implemented within modern database systems without requiring new exotic index structures and complex preprocessing. Finally, we present a new data layout approach for tetrahedral mesh datasets that provides better performance compared to the traditional space filling curves. In our PostgreSQL implementation DLS reduces the number of disk page accesses and the query execution time each by 25% up to a factor of 4.

  • Details
  • Metrics
Type
conference paper
DOI
10.1145/1142473.1142535
Author(s)
Papadomanolakis, Stratos
Ailamaki, Anastassia  
López, Julio C.
Tu, Tiankai
O'Hallaron, David R.
Heber, Gerd
Date Issued

2006

Published in
Proceedings of the ACM SIGMOD
Start page

551

End page

562

Editorial or Peer reviewed

REVIEWED

Written at

EPFL

EPFL units
LABOS  
DIAS  
Event nameEvent placeEvent date
International Conference on Management of Data (SIGMOD)

Chicago, Illinois, USA

June 27-29, 2006

Available on Infoscience
October 10, 2007
Use this identifier to reference this record
https://infoscience.epfl.ch/handle/20.500.14299/12807
Logo EPFL, École polytechnique fédérale de Lausanne
  • Contact
  • infoscience@epfl.ch

  • Follow us on Facebook
  • Follow us on Instagram
  • Follow us on LinkedIn
  • Follow us on X
  • Follow us on Youtube
AccessibilityLegal noticePrivacy policyCookie settingsEnd User AgreementGet helpFeedback

Infoscience is a service managed and provided by the Library and IT Services of EPFL. © EPFL, tous droits réservés