Filters








11,749 Hits in 3.8 sec

ProSQL: A Prototyping Tool for SQL Temporal Language Extensions [chapter]

James Green, Roger Johnson
2003 Lecture Notes in Computer Science  
extensions to the basic relational database.  ...  This paper describes ProSQL, a novel prototyping tool to support the development of extensions to SQL.  ...  As an extension to SQL can be derived from a uni-sorted or multi-sorted relational model or incorporate ATS a relation can have a number of properties including implicit temporal attributes and be in NFNF  ... 
doi:10.1007/3-540-45073-4_15 fatcat:whyiliu2zzgpjj3mmbptxfhujm

Abstract Versus Concrete Temporal Query Languages [chapter]

Jan Chomicki, David Toman
2016 Encyclopedia of Database Systems  
The additional features reflect the way dependencies of data on time are captured by and represented in the underlying temporal data model.  ...  Plain SQL, however, does not seem to provide adequate support for temporal applications. Example.  ...  the more TRC-like temporal extensions of SQL, to more FOTL-like temporal relational algebras (e.g., the conjunction in temporal logic directly corresponds to a temporal join in a temporal relational algebra  ... 
doi:10.1007/978-1-4899-7993-3_1559-2 fatcat:p7isrdz435gvhmjfnonm2n7evi

Bridging relational database history and the web

Fusheng Wang, Xin Zhou, Carlo Zaniolo
2006 Proceedings of the eighth ACM international workshop on Web information and data management - WIDM '06  
Past research on temporal databases revealed the difficulty of achieving satisfactory solutions using flat relational tables and SQL.  ...  of their ability to support temporal information and queries, and make it easy to publish database history to the Web.  ...  for temporally grouped data models, which have been advocated as the most natural and effective representations of temporal information [3] , and (ii) unlike SQL, XQuery [4] is natively extensible and  ... 
doi:10.1145/1183550.1183554 dblp:conf/widm/WangZZ06 fatcat:swufaimfrferxaspcqzdam4bpa

Temporal statement modifiers

Michael H. Böhlen, Christian S. Jensen, Richard T. Snodgrass
2000 ACM Transactions on Database Systems  
In this article we advocate a different approach to articulating a set of requirements, or desiderata, that directly imply the syntactic structure and core semantics of a temporal extension of an (arbitrary  ...  operators. a list of ten items with incompatibilities in SQL-89 and SQL-92, with the keyword being one item.  ...  Renato Busatto contributed to the formalization of interval preservation, bitemporal negation, and the proof of Theorem 5.1. Robert Marti took part in early work on statement modifiers.  ... 
doi:10.1145/377674.377665 fatcat:hjrdbdfgpvclfakt47ombmp7pq

Database Technology for Processing Temporal Data (Invited Paper)

Michael H. Böhlen, Anton Dignös, Johann Gamper, Christian S. Jensen, Michael Wagner
2018 International Symposium/Workshop on Temporal Representation and Reasoning  
The SQL:2011 standard introduced some temporal features, and commercial database management systems have started to offer temporal functionalities in a step-by-step manner.  ...  Despite the ubiquity of temporal data and considerable research on processing such data, database systems largely remain designed for processing the current state of some modeled reality.  ...  representation and the point-based conceptual model.  ... 
doi:10.4230/lipics.time.2018.2 dblp:conf/time/BohlenDGJ18 fatcat:j3kfsfijijfi7o6wpsytjbnw7u

Efficient Temporal Coalescing Query Support in Relational Database Systems [chapter]

Xin Zhou, Fusheng Wang, Carlo Zaniolo
2006 Lecture Notes in Computer Science  
We provide an SQL:2003-based query algorithm and a native relational user defined aggregates (UDA) approach -both approaches only require a single scan of the database.  ...  These new findings demonstrate that the current RDBMSs are mature enough to directly support efficient temporal queries, and provide a new paradigm for temporal database research and implementation.  ...  This query could be expressed using TSQL2 (Temporal SQL), which is an extension of the standard relational query language (SQL) enhanced with temporal features and predicates to manipulate temporal databases  ... 
doi:10.1007/11827405_66 fatcat:v2dvdcco3rbj7pmpm5uewiejlm

SQL/SE

John F. Roddick
1992 SIGMOD record  
The incorporation of a knowledge of time within database systems allows for temporally related information to be modelled more naturally and consistently.  ...  This paper presents SQL/SE, an SQL extension capable of handling schema evolution in relational database systems.  ...  The ANSI and ISO standards committees have proposed an extension to the SQL standard to provide for limited temporal support 17.  ... 
doi:10.1145/140979.140985 fatcat:2ewzcla3svhlxmnnizw7hxl52m

Point-based temporal extensions of SQL and their efficient implementation [chapter]

David Toman
1998 Lecture Notes in Computer Science  
The more practical of these are often based on (often ad-hoc) extensions of existing relational languages, e.g., TQUEL [17] and various temporal extensions of SQL: TSQL2 [18], ATSQL2 [5], and SQL/Wemporal  ...  This chapter introduces a new approach to temporal extensions of SQL.  ...  In all three cases we show that SQL/TP is a natural syntactic extension of SQL over 6 We use the same names for both the abstract and concrete relations.  ... 
doi:10.1007/bfb0053704 fatcat:ycv4x5unwza3fpxygyrlnkadzu

TIP

Jun Yang, Huacheng C. Ying, Jennifer Widom
2000 SIGMOD record  
To address the needs of applications requiring rich temporal data and queries, we have built TIP (Temporal Information Processor), a temporal extension to the Informix database system based on its DataBlade  ...  Our TIP DataBlade extends Informix with a rich set of datatypes and routines that facilitate temporal modeling and querying.  ...  We chose to implement TIP in an extensible relational DBMS instead, because relational technology and SQL are better suited to the temporal data warehousing application we plan to build using TIP [9,  ... 
doi:10.1145/335191.336578 fatcat:oklckwoo3vcsfcmrwb43pfs4qu

TIP

Jun Yang, Huacheng C. Ying, Jennifer Widom
2000 Proceedings of the 2000 ACM SIGMOD international conference on Management of data - SIGMOD '00  
To address the needs of applications requiring rich temporal data and queries, we have built TIP (Temporal Information Processor), a temporal extension to the Informix database system based on its DataBlade  ...  Our TIP DataBlade extends Informix with a rich set of datatypes and routines that facilitate temporal modeling and querying.  ...  We chose to implement TIP in an extensible relational DBMS instead, because relational technology and SQL are better suited to the temporal data warehousing application we plan to build using TIP [9,  ... 
doi:10.1145/342009.336578 dblp:conf/sigmod/YangYW00 fatcat:pnxqydquzjarpemld3ksw55rnq

Layered Temporal DBMS's—Concepts and Techniques

Kristian Torp, Christian S. Jensen, Michael Böhlen
1997 Database Systems for Advanced Applications '97  
Temporal extensions of SQL offer substantial benefits over SQL when managing time-varying data. The topic of this paper is the effective implementation of temporally extended SQL's.  ...  In contrast, this paper explores the concepts and techniques involved in implementing a temporally enhanced SQL while maximally reusing the facilities of an existing SQL implementation.  ...  , Research and Development, as a Networks Activity of the Training and Mobility of Researchers Programme, contract no.  ... 
doi:10.1142/9789812819536_0039 fatcat:njk42bxbdnchjpgevgxmghjz3y

Temporal Information Management Using XML [chapter]

Fusheng Wang, Xin Zhou, Carlo Zaniolo
2004 Lecture Notes in Computer Science  
By contrast, the flat relational tables of traditional DBMSs are not well-suited for temporally grouped representations [8] ; moreover, significant extensions are required to support temporal information  ...  in SQL and, in the past, they were poorly received by SQL standard committees.  ... 
doi:10.1007/978-3-540-30464-7_72 fatcat:ee7kmss6mneffa6ho6jqchmkty

A Problem Oriented Approach to Data Mining in Distributed Spatio-temporal Database [chapter]

Zhou Huang, Yu Fang, Xia Peng, Bin Chen, Xuetong Xie
2007 Lecture Notes in Computer Science  
The system is based on data model of sequent snapshot and accomplished through spatio-temporal extension on PostgreSQL.  ...  Various spatio-temporal analyses and mining queries could be carried out in the system through simple SQL statements.  ...  Acknowledgments This research was supported by the following grants from the NSFC Project (40501052) and the Survey and Mapping Foundation in 2005.  ... 
doi:10.1007/978-3-540-72588-6_111 fatcat:i6at7xoufjf33oweghwn67wiom

Report on the 1995 international workshop on temporal databases

Arie Segev, Christian S. Jensen, Richard Thomas Snodgrass
1995 SIGMOD record  
This paper provides an overview of the 1995 International Workshop on Temporal Databases. It summarizes the technical papers and related discussions, and three panels: \Wither TSQL3?"  ...  , \Temporal Data Management in Financial Applications," and \Temporal Data Management Infrastructure & Beyond."  ...  Acknowledgements We thank Mario Nascimento for supplying notes taken during the workshop. Together with our own notes and the proceedings, these notes were helpful in writing this report.  ... 
doi:10.1145/219713.219754 fatcat:drkmgtjsdbgcxeecrnrxurn4fq

An extended SQL for temporal data management in clinical decision-support systems

A K Das, S W Tu, G P Purcell, M A Musen
1992 Proceedings. Symposium on Computer Applications in Medical Care  
We show that our temporal extension to SQL meets the temporal data-management needs of protocol-directed decision support.  ...  We extend the standard relational data model in three ways to support these querying requirements.  ...  This work has been supported in part by grant HS06330 from the Agency for Health Care Policy and Research and by grants LM05208 and LM07033 from the National Library of Medicine. Dr.  ... 
pmid:1482853 pmcid:PMC2248091 fatcat:m5yfjb477radlidosi73tdv6u4
« Previous Showing results 1 — 15 out of 11,749 results