1 AIT Asian Institute of Technology

An incremental constraint-based query optimization

AuthorNguyen Duc Quang
Call NumberAIT Thesis no. CS-92-17
Subject(s)Information storage and retrieval systems

NoteA thesis submitted in partial fulfillment of the requirements for degree of Master of Science, School of Engineering and Technology
PublisherAsian Institute of Technology
AbstractA spatial database contains objects of different shapes and are normally retrievable by range queries. However, to provide a query language suitable for human beings one tends to allow the users to specify the queries in form as closest to the problem domain as possible, so the gap between the query language and the low level range searching is very wide. Helm, Marriott and Odersky have presented an query optimization technique to bridge this gap. In their technique, they introduced a novel idea of using Boolean algebra in constraint-based query for spatial database application. With their system, one needs to know all constraints before processing the query. In other word, all queries must be present before the optimization to take place. In this thesis, an incremental algorithm is proposed. We define an alternative approach to find the non-recursive form of Helm's et a l. algorithm. Then, we develop three new incremental algorithms on this non-recursive form. In addition, we found an algorithm to transform any system of Boolean constraints in to normal form. We have also implemented both Helm's et al. and our algorithms successfully using Mathematica programming language. An incremental algorithm allows cases where not all constraints are present. As such it could perhaps be used as constraint solver for a constraint logic programming with Boolean algebra.
Year1992
TypeThesis
SchoolSchool of Engineering and Technology (SET)
DepartmentDepartment of Information and Communications Technologies (DICT)
Academic Program/FoSComputer Science (CS)
Chairperson(s)Kanchana Kanchanasut;
Examination Committee(s)Huynh Ngoc Phien ;Sadananda, Ramakoti;
Scholarship Donor(s)Government of Australia;
DegreeThesis (M.Sc.) - Asian Institute of Technology, 1992


Usage Metrics
View Detail0
Read PDF0
Download PDF0