Browse Prior Art Database

PROSQL: A PROLOG PROGRAMMING INTERFACE WITH SQL/DS

IP.com Disclosure Number: IPCOM000148494D
Original Publication Date: 1984-May-25
Included in the Prior Art Database: 2007-Mar-30
Document File: 30 page(s) / 1M

Publishing Venue

Software Patent Institute

Related People

Chang, C.L.: AUTHOR [+3]

Abstract

RJ 4314 (47142) 5/25/84 Computer Science Research Report REI?\D!NG ROOM COMPUTER SCIENCE DEP.ARTt~GEt4~~ YALE UNIVERSI7'V PROSQL: A PROLOG PROGRLPPIISG INTERFACE WITH SQL/DS C. L. Chang A. Walker IBM Research Laboratory San Jose, CA 95193 This report has been submitted for publication outside of IBM and will probably be copyrighted if accepted for publication. It has ben issued as a Research Reoorr for early disseminarion of its contents. In view of the transfer of copyright to the outside publisher, its distribution outside of ISM prior to publication should be limited to Deer communications aild specific requests. After outside publication, requests should be filled only by reprints or legaliy obtained copies of the article (e.g., payment of rovalties). Resea~ch Oivisi~n IBM 'forktown Heights, New York San Jose, California Zurich, Switreriand Copies may be reqdested from:1EM Thomas J. Witson Research Center 0istribu:ion Services Post Office 80x 2i 8Yorktown He~gnts. New York 1 a598

This text was extracted from a PDF file.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 11% of the total text.

Page 1 of 30

RJ 4314 (47142) 5/25/84
Computer Science

Research Report

       REI?\D!NG ROOM COMPUTER SCIENCE DEP.ARTt~GEt4~~

YALE UNIVERSI7'V

PROSQL: A PROLOG PROGRLPPIISG INTERFACE WITH SQL/DS

C. L. Chang
A. Walker

IBM Research Laboratory San Jose, CA 95193

This report has been submitted for publication outside of IBM and will probably be copyrighted if accepted for publication. It has ben issued as a Research Reoorr for early disseminarion of its contents. In view of the transfer of copyright to the outside publisher, its distribution outside of ISM prior to publication should be limited to Deer communications aild specific requests. After outside publication, requests should be filled only by reprints or legaliy obtained copies of the article (e.g., payment of rovalties).

Resea~ch Oivisi~n

IBM 'forktown Heights, New York San Jose, California * Zurich, Switreriand

[This page contains 1 picture or other non-text object]

Page 2 of 30

Copies may be reqdested from:
1EM Thomas J. Witson Research Center 0istribu:ion Services
Post Office 80x 2i 8
Yorktown He~gnts. New York 1
a598

[This page contains 1 picture or other non-text object]

Page 3 of 30

RJ 4314 (47142) 5/25/54 Computer Science

PROSQL: A PROLOG PROGRA31!IINC; ISTEEFACE WITH SQL/DS

C. L.. Chang
A. Walker

IBM Research Laboratory

San Jose, Ca 95193

ABSTRACT: SQL/DS (SQL/Data System) is an IBPl relational data base system. It has the full functions of a data management system, including access paths (e.g., indexing), query optimization, data sharing, recovery, concurrency control and protection, and so on. It supports efficient retrieval from a large data base in secondary storage.

PROLOG is a language suitable for constructing knowledge based systems. A PROLOG program consists of facts, (i.
e assertions ) , and rules. A fact in PROLOG can be used to represect a tuple in a relational data base; A rule can be used to specify a vie;^ in a relatiocal data Sdse, or to represent knowledge about how to use the facts.

Used as a query language, PROLOG is formally as powerful as an application program running over a SQL/DS data base. However, existing versions of PROLOG do not nave the full data management functio~~s
of SQL/DS. Since re-implementing these functions in PROLOG would be expe~sivo, this paper w i l l describe an approach of coupling PROLOG to SQL/DS. This gives a user the advantages of both PROLOG and SQL/DS. The coupling consists of a method of calling SQL statements from PROLOG. It is flesible, because it allows eicher loose coupling or tight coupling between PROLOG and SQL/DS . We call our incerf ace PROSQL.

[This page contains 1 picture or other non-text object]

Page 4 of 30

[This page contains 1 picture or other non-text object]

Page 5 of 30

PAGE 1

1. INTRODUCTION

PROLOG [Battani and tleloni 1373, Colmerauer et al. 1373, Kowalcki 1979, Roberts 1977, Roussel 1975, Socia 1381, l...