SISQL: schema-independent database querying (on and off the Web)

Finding information in diverse sources, in particular on the World-Wide Web is highly relevant these days. As more and more Web sites are administered by database systems, and as information on and off the Web increasingly comes out of a database, it is crucial to be able to search databases when wo...

Full description

Saved in:
Bibliographic Details
Main Authors: Masermann, U., Vossen, G.
Format: Conference Proceeding
Language:English
Subjects:
Algebra
Database languages
Database systems
Dictionaries
Dynamic programming
HTML
Information retrieval
Programming profession
Relational databases
Writing
Online Access:Request full text
Tags: Add Tag
No Tags, Be the first to tag this record!
cited_by
cites
container_end_page 64
container_issue
container_start_page 55
container_title
container_volume
creator Masermann, U.
Vossen, G.
description Finding information in diverse sources, in particular on the World-Wide Web is highly relevant these days. As more and more Web sites are administered by database systems, and as information on and off the Web increasingly comes out of a database, it is crucial to be able to search databases when working with the Web. This paper introduces a novel query language which renders it possible to formulate queries to databases in the absence of schema-knowledge. The proposed language Schema-Independent SQL (SISQL) takes parameterized SQL queries as input and dynamically generates correct SQL statements for collections of underlying schemata. SISQL is based on the Reflective Relational Algebra as a "processing engine,", which has been proposed in recent years for overcoming the limitations of classical algebra w.r.t. the treatment of procedural data.
doi_str_mv 10.1109/IDEAS.2000.880562
format conference_proceeding
fullrecord <record><control><sourceid>ieee_6IE</sourceid><recordid>TN_cdi_ieee_primary_880562</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><ieee_id>880562</ieee_id><sourcerecordid>880562</sourcerecordid><originalsourceid>FETCH-LOGICAL-i104t-fd8c656902fee334a7ca9bd05b521ecd64f634e21eb5e3239a05996fe7a2d283</originalsourceid><addsrcrecordid>eNotj1FLwzAUhQMiqNt-gD7lUR9ab5ImTXxybNMVCiId-DhumxtXcdls68P-vYX5cs4HBz44jN0KSIUA91gsV_MqlQCQWgvayAt2A7lxGnLrxBWb9f3XOILWVli4Zs9VUb2XT7xvdrTHpI2ejjRGHLjHAWvsif_8Undq4ye_P0SO0fNDCHzYEf-g-mHKLgN-9zT77wnbvKw2i3VSvr0Wi3mZtAKyIQneNkYbBzIQKZVh3qCrPehaS0GNN1kwKqORa01KKoegnTOBcpReWjVhd2dtS0TbY9fusTttzxfVH5IKRfw</addsrcrecordid><sourcetype>Publisher</sourcetype><iscdi>true</iscdi><recordtype>conference_proceeding</recordtype></control><display><type>conference_proceeding</type><title>SISQL: schema-independent database querying (on and off the Web)</title><source>IEEE Electronic Library (IEL) Conference Proceedings</source><creator>Masermann, U. ; Vossen, G.</creator><creatorcontrib>Masermann, U. ; Vossen, G.</creatorcontrib><description>Finding information in diverse sources, in particular on the World-Wide Web is highly relevant these days. As more and more Web sites are administered by database systems, and as information on and off the Web increasingly comes out of a database, it is crucial to be able to search databases when working with the Web. This paper introduces a novel query language which renders it possible to formulate queries to databases in the absence of schema-knowledge. The proposed language Schema-Independent SQL (SISQL) takes parameterized SQL queries as input and dynamically generates correct SQL statements for collections of underlying schemata. SISQL is based on the Reflective Relational Algebra as a "processing engine,", which has been proposed in recent years for overcoming the limitations of classical algebra w.r.t. the treatment of procedural data.</description><identifier>ISBN: 0769507891</identifier><identifier>ISBN: 9780769507897</identifier><identifier>DOI: 10.1109/IDEAS.2000.880562</identifier><language>eng</language><publisher>IEEE</publisher><subject>Algebra ; Database languages ; Database systems ; Dictionaries ; Dynamic programming ; HTML ; Information retrieval ; Programming profession ; Relational databases ; Writing</subject><ispartof>Proceedings 2000 International Database Engineering and Applications Symposium (Cat. No.PR00789), 2000, p.55-64</ispartof><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://ieeexplore.ieee.org/document/880562$$EHTML$$P50$$Gieee$$H</linktohtml><link.rule.ids>309,310,778,782,787,788,2054,4038,4039,27908,54903</link.rule.ids><linktorsrc>$$Uhttps://ieeexplore.ieee.org/document/880562$$EView_record_in_IEEE$$FView_record_in_$$GIEEE</linktorsrc></links><search><creatorcontrib>Masermann, U.</creatorcontrib><creatorcontrib>Vossen, G.</creatorcontrib><title>SISQL: schema-independent database querying (on and off the Web)</title><title>Proceedings 2000 International Database Engineering and Applications Symposium (Cat. No.PR00789)</title><addtitle>IDEAS</addtitle><description>Finding information in diverse sources, in particular on the World-Wide Web is highly relevant these days. As more and more Web sites are administered by database systems, and as information on and off the Web increasingly comes out of a database, it is crucial to be able to search databases when working with the Web. This paper introduces a novel query language which renders it possible to formulate queries to databases in the absence of schema-knowledge. The proposed language Schema-Independent SQL (SISQL) takes parameterized SQL queries as input and dynamically generates correct SQL statements for collections of underlying schemata. SISQL is based on the Reflective Relational Algebra as a "processing engine,", which has been proposed in recent years for overcoming the limitations of classical algebra w.r.t. the treatment of procedural data.</description><subject>Algebra</subject><subject>Database languages</subject><subject>Database systems</subject><subject>Dictionaries</subject><subject>Dynamic programming</subject><subject>HTML</subject><subject>Information retrieval</subject><subject>Programming profession</subject><subject>Relational databases</subject><subject>Writing</subject><isbn>0769507891</isbn><isbn>9780769507897</isbn><fulltext>true</fulltext><rsrctype>conference_proceeding</rsrctype><creationdate>2000</creationdate><recordtype>conference_proceeding</recordtype><sourceid>6IE</sourceid><recordid>eNotj1FLwzAUhQMiqNt-gD7lUR9ab5ImTXxybNMVCiId-DhumxtXcdls68P-vYX5cs4HBz44jN0KSIUA91gsV_MqlQCQWgvayAt2A7lxGnLrxBWb9f3XOILWVli4Zs9VUb2XT7xvdrTHpI2ejjRGHLjHAWvsif_8Undq4ye_P0SO0fNDCHzYEf-g-mHKLgN-9zT77wnbvKw2i3VSvr0Wi3mZtAKyIQneNkYbBzIQKZVh3qCrPehaS0GNN1kwKqORa01KKoegnTOBcpReWjVhd2dtS0TbY9fusTttzxfVH5IKRfw</recordid><startdate>2000</startdate><enddate>2000</enddate><creator>Masermann, U.</creator><creator>Vossen, G.</creator><general>IEEE</general><scope>6IE</scope><scope>6IL</scope><scope>CBEJK</scope><scope>RIE</scope><scope>RIL</scope></search><sort><creationdate>2000</creationdate><title>SISQL: schema-independent database querying (on and off the Web)</title><author>Masermann, U. ; Vossen, G.</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-i104t-fd8c656902fee334a7ca9bd05b521ecd64f634e21eb5e3239a05996fe7a2d283</frbrgroupid><rsrctype>conference_proceedings</rsrctype><prefilter>conference_proceedings</prefilter><language>eng</language><creationdate>2000</creationdate><topic>Algebra</topic><topic>Database languages</topic><topic>Database systems</topic><topic>Dictionaries</topic><topic>Dynamic programming</topic><topic>HTML</topic><topic>Information retrieval</topic><topic>Programming profession</topic><topic>Relational databases</topic><topic>Writing</topic><toplevel>online_resources</toplevel><creatorcontrib>Masermann, U.</creatorcontrib><creatorcontrib>Vossen, G.</creatorcontrib><collection>IEEE Electronic Library (IEL) Conference Proceedings</collection><collection>IEEE Proceedings Order Plan All Online (POP All Online) 1998-present by volume</collection><collection>IEEE Xplore All Conference Proceedings</collection><collection>IEEE Xplore</collection><collection>IEEE Proceedings Order Plans (POP All) 1998-Present</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Masermann, U.</au><au>Vossen, G.</au><format>book</format><genre>proceeding</genre><ristype>CONF</ristype><atitle>SISQL: schema-independent database querying (on and off the Web)</atitle><btitle>Proceedings 2000 International Database Engineering and Applications Symposium (Cat. No.PR00789)</btitle><stitle>IDEAS</stitle><date>2000</date><risdate>2000</risdate><spage>55</spage><epage>64</epage><pages>55-64</pages><isbn>0769507891</isbn><isbn>9780769507897</isbn><abstract>Finding information in diverse sources, in particular on the World-Wide Web is highly relevant these days. As more and more Web sites are administered by database systems, and as information on and off the Web increasingly comes out of a database, it is crucial to be able to search databases when working with the Web. This paper introduces a novel query language which renders it possible to formulate queries to databases in the absence of schema-knowledge. The proposed language Schema-Independent SQL (SISQL) takes parameterized SQL queries as input and dynamically generates correct SQL statements for collections of underlying schemata. SISQL is based on the Reflective Relational Algebra as a "processing engine,", which has been proposed in recent years for overcoming the limitations of classical algebra w.r.t. the treatment of procedural data.</abstract><pub>IEEE</pub><doi>10.1109/IDEAS.2000.880562</doi><tpages>10</tpages></addata></record>
fulltext fulltext_linktorsrc
identifier ISBN: 0769507891
ispartof Proceedings 2000 International Database Engineering and Applications Symposium (Cat. No.PR00789), 2000, p.55-64
issn
language eng
recordid cdi_ieee_primary_880562
source IEEE Electronic Library (IEL) Conference Proceedings
subjects Algebra
Database languages
Database systems
Dictionaries
Dynamic programming
HTML
Information retrieval
Programming profession
Relational databases
Writing
title SISQL: schema-independent database querying (on and off the Web)
url http://sfxeu10.hosted.exlibrisgroup.com/loughborough?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-16T15%3A20%3A02IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-ieee_6IE&rft_val_fmt=info:ofi/fmt:kev:mtx:book&rft.genre=proceeding&rft.atitle=SISQL:%20schema-independent%20database%20querying%20(on%20and%20off%20the%20Web)&rft.btitle=Proceedings%202000%20International%20Database%20Engineering%20and%20Applications%20Symposium%20(Cat.%20No.PR00789)&rft.au=Masermann,%20U.&rft.date=2000&rft.spage=55&rft.epage=64&rft.pages=55-64&rft.isbn=0769507891&rft.isbn_list=9780769507897&rft_id=info:doi/10.1109/IDEAS.2000.880562&rft_dat=%3Cieee_6IE%3E880562%3C/ieee_6IE%3E%3Cgrp_id%3Ecdi_FETCH-LOGICAL-i104t-fd8c656902fee334a7ca9bd05b521ecd64f634e21eb5e3239a05996fe7a2d283%3C/grp_id%3E%3Coa%3E%3C/oa%3E%3Curl%3E%3C/url%3E&rft_id=info:oai/&rft_id=info:pmid/&rft_ieee_id=880562&rfr_iscdi=true