SQL extension for interval data

被引：48

作者：

Lorentzos, NA

Mitsopoulos, YG

机构：

[1] Informatics Laboratory, Agricultural University of Athens, GR 11855 Athens

来源：

IEEE TRANSACTIONS ON KNOWLEDGE AND DATA ENGINEERING | 1997年 / 9卷 / 03期

关键词：

data model; interval data; query language; spatial data; temporal data;

D O I：

10.1109/69.599935

中图分类号：

TP18 [人工智能理论];

学科分类号：

081104 ; 0812 ; 0835 ; 1405 ;

摘要：

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.

引用

页码：480 / 499

页数：20

共 32 条

[1]

Al-Taha K. K., 1993, SIGMOD Record, V22, P59, DOI 10.1145/156883.156892

[2] A TEMPORALLY ORIENTED DATA MODEL [J].

ARIAV, G .

ACM TRANSACTIONS ON DATABASE SYSTEMS, 1986, 11 (04) :499-527

[3]

Cannan S. J., 1993, SQL STANDARD HDB

[4] ON COMPLETENESS OF HISTORICAL RELATIONAL QUERY LANGUAGES [J].

CLIFFORD, J ;

CROKER, A ;

TUZHILIN, A .

ACM TRANSACTIONS ON DATABASE SYSTEMS, 1994, 19 (01) :64-116

[5]

CLIFFORD J, 1987, 3RD P INT C DAT ENG, P528

[6]

CODD EF, 1970, COMMUN ACM, V13, P377, DOI 10.1145/357980.358007

[7]

DADAM P, 1986, P ACM SIGMOD 86 INT

[8]

Dyreson C., 1994, SIGMOD REC, V23, P52

[9] A HOMOGENEOUS RELATIONAL MODEL AND QUERY LANGUAGES FOR TEMPORAL DATABASES [J].

GADIA, SK .

ACM TRANSACTIONS ON DATABASE SYSTEMS, 1988, 13 (04) :418-448

[10]

GADIA SK, 1993, P INT WORKSH INFR TE

← 1 2 3 4 →