This Article 
 Bibliographic References 
 Add to: 
APPROXIMATE: A Query Processor that Produces Monotonically Improving Approximate Answers
December 1993 (vol. 5 no. 6)
pp. 1056-1068

APPROXIMATE, a query processor that makes approximate answers available if part of the database is unavailable, or if there is not enough time to produce an exact answer, is described. The processor implements approximate query processing, and the accuracy of the approximate result produced improves monotonically with the amount of data retrieved to produce the result. The monotone query processing algorithm of APPROXIMATE works within a standard relational algebra framework. APPROXIMATE maintains semantic information for approximate query processing at an underlying level, and can be implemented on a relational database system with little change to the relational architecture. It is shown how APPROXIMATE is implemented to make effective use of the semantic support. The additional overhead required by APPROXIMATE is described.

[1] K. J. Lin, S. Natarajan, J. W. S. Liu, and T. Krauskopf, "Concord: A system of imprecise computations," inProc. COMPSAC '87, Tokyo, Japan, Oct. 1987, pp. 75-81.
[2] J. W. S. Liu, K. J. Lin, and S. Natarajan, "Scheduling Real-Time Periodic Jobs using Imprecise Results," inProc. IEEE Real-Time Syst. Symp., San Jose, CA, Dec. 1987.
[3] J. Y. Chung, J. W. S. Liu, and K. J. Lin, "Scheduling periodic jobs that allow imprecise results,"IEEE Trans. Comput., vol. 39, pp. 1156-1174, Sept. 1990.
[4] K. P. Smith and J. W. S. Liu, "Monotonically improving approximate answers to relational algebra queries," inProc. COMPSAC '89, Orlando, FL, Sept. 1989.
[5] S. B. Davidson and A. Watters, "Partial computation in real-time database systems," inProc. 5th Workshop Real-Time Software, Operat. Syst., May 1988, pp. 117-121.
[6] G. Ozsoyoglu, Z. M. Ozsoyoglu, and W.-C. Hou, "Research in time-and error-constrained database query processing," inProc. Workshop Real-Time Operat. Syst., Software, Charlottesville, VA, May 1990.
[7] A. Motro, "VAGUE: A user interface to relational database that permits vague queries,"ACM Trans. Office Inform. Syst., vol. 6, pp. 187-214, July 1988.
[8] A. Motro, "Using integrity constraints to provide intensional answers to relational queries," inProc. 15th Int. Conf. Very Large Databases, Amsterdam, The Netherlands, 1989, pp. 237-246.
[9] J. D. Ullman,Database and Knowledge-base Systems. Rockville, MD: Computer Science Press, 1988.
[10] K.C. Liu and R. Sunderraman, "On representing indefinite and maybe information in relational databases," inProc. Fourth Int. Conf. Data Eng., Los Angeles, CA, Feb. 1988, pp. 250-257.
[11] R. Hull and R. King, "Semantics database modeling: Survey, applications, and research issues,"Comput. Surveys, vol. 19, no. 3, pp. 201-260, Sept. 1987.
[12] W. Kimet al., "Integrating an object-oriented programming system with a database system," in [56], pp. 142-152.
[13] A. Goldberg and D. Robson,Smalltalk80: The Language and Its Implementation. Reading, MA: Addison-Wesley, May 1983.
[14] J. Peckham and F. Maryanski, "Semantic data models,"ACM Comput. Surveys. pp. 153-189, Sept. 1988.
[15] H. H. Pang, H. J. Lu, and B. C. Ooi, "An efficient semantic query optimization algorithm," inProc. Data Eng. Conf., IEEE, 1991.
[16] S. Vrbsky and J. W. S. Liu, "Producing Approximate Answers to Set-Valued and Single-Valued Queries," inProc. 1st Int. Conf. Informat. Knowledge Management, Nov. 1992, pp. 405-412.

Index Terms:
APPROXIMATE; query processor; monotonically improving approximate answers; approximate query processing; monotone query processing algorithm; standard relational algebra framework; semantic information; relational database system; class hierarchy; imprecise computation; partial-order relation; query tree; query processing; relational algebra; relational databases; trees (mathematics)
S.V. Vrbsky, J.W.S. Liu, "APPROXIMATE: A Query Processor that Produces Monotonically Improving Approximate Answers," IEEE Transactions on Knowledge and Data Engineering, vol. 5, no. 6, pp. 1056-1068, Dec. 1993, doi:10.1109/69.250091
Usage of this product signifies your acceptance of the Terms of Use.