Igor Wojnicki


This paper regards the Jelly View technology, which provides a new, practical methodology for knowledge decomposition, storage, and retrieval within Relational Database Management Systems (RDBMS). Intensional Knowledge clauses (rules) are decomposed and stored in the RDBMS founding reusable components. The results of the rule-based processing are visible as regular views, accessible through SQL. From the end-user point of view the processing capability becomes unlimited (arbitrarily complex queries can be constructed using Intensional Knowledge), while the most external queries are expressed with standard SQL. The RDBMS functionality becomes extended toward that of the Deductive Databases


RDBMS; Prolog; Intensional Knowledge; Deductive Database; Recursive Queries

Full Text:



Codd E. F.: A relational model of data for large shared data banks. CACM, 13 (6), 1970, p. 377–387

Connolly T., Begg C., Strachan A.: Database Systems, A practical approach to Design. 2nd ed., Implementation, and Management. Addison-Wesley, 1999.

Covington M. A., Nute D., Vellino A.: Prolog programming in depth. PrenticeHall, 1997.

Derr M. A., Morishita S., Phipps G.: The glue-nail deductive database system: Design, implementation, and evaluation. VLDB Journal, 3 (2), 1994, p. 123–160

Elmasri R., Navathe S. B.: Fundamentals of Database Systems. Addison Wesley, 2000.

Garcia-Molina H., Ullman J. D., Widom J.: Database Systems, the complete book. Prentice Hall, 2002.

Srini Venigalla Netsetgo. Expanding recursive opportunities with sql udfs in db2 v 7.2. Technical report, International Business Machines Corporation, 2002.

Nilsson U., Małuszynski J.: Logic, Programming and Prolog. John Wiley & Sons, 1990.

Ramakrishnan R., Srivastava D., Sudarshan S., Seshadri P.: The CORAL deductive system. VLDB Journal: Very Large Data Bases, 3 (2), 1994, p. 161–210

Ullman J. D.: Principles of Database and Knowledge-Base Systems. Computer Science Press, 1988.

Ullman J. D., Widom J.: A first course in Database systems. Prentice-Hall, 1997.

Vaghani J., Ramamohanarao K., Kemp D. B., Somogyi Z., Stuckey P. J., Leask T. S., Harland J.: The aditi deductive database system. Technical report, University of Melbourne, 1994.

Vlahavas I., Bassiliades N.: Parallel Object-Oriented, and Active Knowledge Base Systems. Kluwer Academic Publishers, 1998.

Wojnicki I.: A Rule-based Inference Engine Extending Knowledge Processing Capabilities of Relational Database Management Systems. (Ph.D. Thesis), AGH University of Science and Technology, 2004. A copy is availbale upon request from the author:

Wojnicki I., Janikow C. Z.: Extending data processing capabilities of relational database management systems. In Arabnia H. R., Joshua R., Mun Y. (Eds), International Conference on Artificial Intelligence, v. I, p. 388-393, Las Vegas, Nevada, USA, CSREA Press, 2003

Wojnicki I., Ligeza A.: An inference engine for rdbms. In 6th International Conference on Soft Computing and Distributed Processing, Rzeszów, Poland, 2002



  • There are currently no refbacks.