SQL extension for interval data

IXSQL, an extension to SQL, is proposed for the management of interval data. IXSQL is syntactically and semantically upwards consistent with SQL2. Its specification has been based both on theoretical results and actual user requirements for the management of temporal data, a special case of interval...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:IEEE transactions on knowledge and data engineering 1997-05, Vol.9 (3), p.480-499
Hauptverfasser: Lorentzos, N.A., Mitsopoulos, Y.G.
Format: Artikel
Sprache:eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
container_end_page 499
container_issue 3
container_start_page 480
container_title IEEE transactions on knowledge and data engineering
container_volume 9
creator Lorentzos, N.A.
Mitsopoulos, Y.G.
description IXSQL, an extension to SQL, is proposed for the management of interval data. IXSQL is syntactically and semantically upwards consistent with SQL2. Its specification has been based both on theoretical results and actual user requirements for the management of temporal data, a special case of interval data. Design decisions and implementation issues are also discussed.
doi_str_mv 10.1109/69.599935
format Article
fullrecord <record><control><sourceid>proquest_RIE</sourceid><recordid>TN_cdi_crossref_primary_10_1109_69_599935</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><ieee_id>599935</ieee_id><sourcerecordid>28566368</sourcerecordid><originalsourceid>FETCH-LOGICAL-c337t-4b8f8b5394528d4e45bb18699314917cd703c845d6aa47388d079141f5f818aa3</originalsourceid><addsrcrecordid>eNqFkE1LxDAQhoMouK4evHqxBxE8dM00X5OjLH5BQUQ9hzRNoNJt16Qr7r-30mWvnmZgnvdheAk5B7oAoPpW6oXQWjNxQGYgBOYFaDgcd8oh54yrY3KS0ielFBXCjFy-vZaZ_xl8l5q-y0Ifs6YbfPy2bVbbwZ6So2Db5M92c04-Hu7fl095-fL4vLwrc8eYGnJeYcBKMM1FgTX3XFQVoBwfAa5BuVpR5pCLWlrLFUOsqdLAIYiAgNayObmevOvYf218GsyqSc63re18v0mm0LLgGsX_IAopmcQRvJlAF_uUog9mHZuVjVsD1Px1ZaQ2U1cje7WT2uRsG6LtXJP2gUJxpEKO2MWENd77_XXn-AWNdm1U</addsrcrecordid><sourcetype>Aggregation Database</sourcetype><iscdi>true</iscdi><recordtype>article</recordtype><pqid>28566368</pqid></control><display><type>article</type><title>SQL extension for interval data</title><source>IEEE Electronic Library (IEL)</source><creator>Lorentzos, N.A. ; Mitsopoulos, Y.G.</creator><creatorcontrib>Lorentzos, N.A. ; Mitsopoulos, Y.G.</creatorcontrib><description>IXSQL, an extension to SQL, is proposed for the management of interval data. IXSQL is syntactically and semantically upwards consistent with SQL2. Its specification has been based both on theoretical results and actual user requirements for the management of temporal data, a special case of interval data. Design decisions and implementation issues are also discussed.</description><identifier>ISSN: 1041-4347</identifier><identifier>EISSN: 1558-2191</identifier><identifier>DOI: 10.1109/69.599935</identifier><identifier>CODEN: ITKEEH</identifier><language>eng</language><publisher>New York, NY: IEEE</publisher><subject>Algebra ; Applied sciences ; Artificial intelligence ; Computer science; control theory; systems ; Database languages ; Database systems ; Drugs ; Exact sciences and technology ; Learning and adaptive systems ; Programming languages ; Relational databases ; Software ; Software engineering ; Temperature distribution ; Terminology ; Voltage</subject><ispartof>IEEE transactions on knowledge and data engineering, 1997-05, Vol.9 (3), p.480-499</ispartof><rights>1997 INIST-CNRS</rights><lds50>peer_reviewed</lds50><woscitedreferencessubscribed>false</woscitedreferencessubscribed><citedby>FETCH-LOGICAL-c337t-4b8f8b5394528d4e45bb18699314917cd703c845d6aa47388d079141f5f818aa3</citedby><cites>FETCH-LOGICAL-c337t-4b8f8b5394528d4e45bb18699314917cd703c845d6aa47388d079141f5f818aa3</cites></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://ieeexplore.ieee.org/document/599935$$EHTML$$P50$$Gieee$$H</linktohtml><link.rule.ids>314,780,784,796,27923,27924,54757</link.rule.ids><linktorsrc>$$Uhttps://ieeexplore.ieee.org/document/599935$$EView_record_in_IEEE$$FView_record_in_$$GIEEE</linktorsrc><backlink>$$Uhttp://pascal-francis.inist.fr/vibad/index.php?action=getRecordDetail&amp;idt=2748056$$DView record in Pascal Francis$$Hfree_for_read</backlink></links><search><creatorcontrib>Lorentzos, N.A.</creatorcontrib><creatorcontrib>Mitsopoulos, Y.G.</creatorcontrib><title>SQL extension for interval data</title><title>IEEE transactions on knowledge and data engineering</title><addtitle>TKDE</addtitle><description>IXSQL, an extension to SQL, is proposed for the management of interval data. IXSQL is syntactically and semantically upwards consistent with SQL2. Its specification has been based both on theoretical results and actual user requirements for the management of temporal data, a special case of interval data. Design decisions and implementation issues are also discussed.</description><subject>Algebra</subject><subject>Applied sciences</subject><subject>Artificial intelligence</subject><subject>Computer science; control theory; systems</subject><subject>Database languages</subject><subject>Database systems</subject><subject>Drugs</subject><subject>Exact sciences and technology</subject><subject>Learning and adaptive systems</subject><subject>Programming languages</subject><subject>Relational databases</subject><subject>Software</subject><subject>Software engineering</subject><subject>Temperature distribution</subject><subject>Terminology</subject><subject>Voltage</subject><issn>1041-4347</issn><issn>1558-2191</issn><fulltext>true</fulltext><rsrctype>article</rsrctype><creationdate>1997</creationdate><recordtype>article</recordtype><recordid>eNqFkE1LxDAQhoMouK4evHqxBxE8dM00X5OjLH5BQUQ9hzRNoNJt16Qr7r-30mWvnmZgnvdheAk5B7oAoPpW6oXQWjNxQGYgBOYFaDgcd8oh54yrY3KS0ielFBXCjFy-vZaZ_xl8l5q-y0Ifs6YbfPy2bVbbwZ6So2Db5M92c04-Hu7fl095-fL4vLwrc8eYGnJeYcBKMM1FgTX3XFQVoBwfAa5BuVpR5pCLWlrLFUOsqdLAIYiAgNayObmevOvYf218GsyqSc63re18v0mm0LLgGsX_IAopmcQRvJlAF_uUog9mHZuVjVsD1Px1ZaQ2U1cje7WT2uRsG6LtXJP2gUJxpEKO2MWENd77_XXn-AWNdm1U</recordid><startdate>19970501</startdate><enddate>19970501</enddate><creator>Lorentzos, N.A.</creator><creator>Mitsopoulos, Y.G.</creator><general>IEEE</general><general>IEEE Computer Society</general><scope>IQODW</scope><scope>AAYXX</scope><scope>CITATION</scope><scope>7SC</scope><scope>8FD</scope><scope>JQ2</scope><scope>L7M</scope><scope>L~C</scope><scope>L~D</scope><scope>7TB</scope><scope>FR3</scope></search><sort><creationdate>19970501</creationdate><title>SQL extension for interval data</title><author>Lorentzos, N.A. ; Mitsopoulos, Y.G.</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-c337t-4b8f8b5394528d4e45bb18699314917cd703c845d6aa47388d079141f5f818aa3</frbrgroupid><rsrctype>articles</rsrctype><prefilter>articles</prefilter><language>eng</language><creationdate>1997</creationdate><topic>Algebra</topic><topic>Applied sciences</topic><topic>Artificial intelligence</topic><topic>Computer science; control theory; systems</topic><topic>Database languages</topic><topic>Database systems</topic><topic>Drugs</topic><topic>Exact sciences and technology</topic><topic>Learning and adaptive systems</topic><topic>Programming languages</topic><topic>Relational databases</topic><topic>Software</topic><topic>Software engineering</topic><topic>Temperature distribution</topic><topic>Terminology</topic><topic>Voltage</topic><toplevel>peer_reviewed</toplevel><toplevel>online_resources</toplevel><creatorcontrib>Lorentzos, N.A.</creatorcontrib><creatorcontrib>Mitsopoulos, Y.G.</creatorcontrib><collection>Pascal-Francis</collection><collection>CrossRef</collection><collection>Computer and Information Systems Abstracts</collection><collection>Technology Research Database</collection><collection>ProQuest Computer Science Collection</collection><collection>Advanced Technologies Database with Aerospace</collection><collection>Computer and Information Systems Abstracts – Academic</collection><collection>Computer and Information Systems Abstracts Professional</collection><collection>Mechanical &amp; Transportation Engineering Abstracts</collection><collection>Engineering Research Database</collection><jtitle>IEEE transactions on knowledge and data engineering</jtitle></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Lorentzos, N.A.</au><au>Mitsopoulos, Y.G.</au><format>journal</format><genre>article</genre><ristype>JOUR</ristype><atitle>SQL extension for interval data</atitle><jtitle>IEEE transactions on knowledge and data engineering</jtitle><stitle>TKDE</stitle><date>1997-05-01</date><risdate>1997</risdate><volume>9</volume><issue>3</issue><spage>480</spage><epage>499</epage><pages>480-499</pages><issn>1041-4347</issn><eissn>1558-2191</eissn><coden>ITKEEH</coden><abstract>IXSQL, an extension to SQL, is proposed for the management of interval data. IXSQL is syntactically and semantically upwards consistent with SQL2. Its specification has been based both on theoretical results and actual user requirements for the management of temporal data, a special case of interval data. Design decisions and implementation issues are also discussed.</abstract><cop>New York, NY</cop><pub>IEEE</pub><doi>10.1109/69.599935</doi><tpages>20</tpages></addata></record>
fulltext fulltext_linktorsrc
identifier ISSN: 1041-4347
ispartof IEEE transactions on knowledge and data engineering, 1997-05, Vol.9 (3), p.480-499
issn 1041-4347
1558-2191
language eng
recordid cdi_crossref_primary_10_1109_69_599935
source IEEE Electronic Library (IEL)
subjects Algebra
Applied sciences
Artificial intelligence
Computer science
control theory
systems
Database languages
Database systems
Drugs
Exact sciences and technology
Learning and adaptive systems
Programming languages
Relational databases
Software
Software engineering
Temperature distribution
Terminology
Voltage
title SQL extension for interval data
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-09T07%3A21%3A03IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-proquest_RIE&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.genre=article&rft.atitle=SQL%20extension%20for%20interval%20data&rft.jtitle=IEEE%20transactions%20on%20knowledge%20and%20data%20engineering&rft.au=Lorentzos,%20N.A.&rft.date=1997-05-01&rft.volume=9&rft.issue=3&rft.spage=480&rft.epage=499&rft.pages=480-499&rft.issn=1041-4347&rft.eissn=1558-2191&rft.coden=ITKEEH&rft_id=info:doi/10.1109/69.599935&rft_dat=%3Cproquest_RIE%3E28566368%3C/proquest_RIE%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_pqid=28566368&rft_id=info:pmid/&rft_ieee_id=599935&rfr_iscdi=true