Learn More
This docuinent specifies a temporal extension to the SQL-92 language standard. The language is designated TSQLZ. The document is organized as follows. The next section indicates the starting point of the design, the SQL92 language. Section 4 lists the desired features on which the TSQL2 Language Design Committee reached consensus. Section 5 presents the(More)
The need for aupporttng trme varying :njormation in databa8e8 has been recogntzed for qurte some trme Many authors have propoeed numerous scheme8 to satrujy this need by tncorporatrng one or two trme attrrbutes in the database. Unfortunately, there has been conju8;on concermng the terminology and definition of theae trme attribute8 Thrs paper propoae8 a new(More)
This tutorial presents the primary constructs of the consensus temporal query language TSQL2 via a media planning scenario. Media planning is a series of decisions involved in the delivery of a promotional message via mass media. We will follow the planning of a particular advertising campaign. We introduce the scenario by identifying the marketing(More)
Various types of computer systems are used behind the scenes in many parts of the telecommunications network to ensure its efficient and trouble-free operation. These systems are large, complex, and expensive real-time computer systems that are mission critical, and contains a database engine as a critical component. These systems share some of common(More)
  • Ilsoo Ahn
  • 1986 IEEE Second International Conference on Data…
  • 1986
There are several issues to be investigated for implementation of database management systems with temporal support. Examples are the types of databases in terms of temporal support, handling of ever-growing storage size, use of optical disks, representation of temporal versions into physical storage, and efficient access methods for both temporal and(More)
A prototype of a temporal database management system was built by extending Ingres. It supports the temporal query language TQuel, a superset of Quel, handling four types of database static, rollback, historical and temporal. A benchmark set of queries was run to study the performance of the prototype on the four types of databases. We analyze the results(More)
In a multiuser database environment, multiple simultaneous transactions may update the same data. Transactions executing simultaneously must produce meaningful and consistent results. In multiuser database environment conflicts are common. If conflicting situations are not dealt properly then it can harm the database. To minimize the concurrency problem the(More)