Nick Kline
Microsoft
Network
Latest external collaboration on country level. Dive into details by clicking on the dots.
Publication
Featured researches published by Nick Kline.
international conference on management of data | 1994
Richard T. Snodgrass; Ilsoo Ahn; Gadi Ariav; Don S. Batory; James Clifford; Curtis E. Dyreson; Ramez Elmasri; Fabio Grandi; Christian S. Jensen; Wolfgang Käfer; Nick Kline; Krishna G. Kulkarni; T. Y. Cliff Leung; Nikos A. Lorentzos; John F. Roddick; Arie Segev; Michael D. Soo; Suryanarayana M. Sripada
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 major concepts underlying TSQL2. Compatibility with SQL-92 is the topic of Section 6. Section 7 briefly discusses how the language can be implemented. Subsequent sections specify the syntax of the language extensions.
international conference on data engineering | 1995
Nick Kline; Richard T. Snodgrass
Aggregate computation, such as selecting the minimum attribute value of a relation, is expensive, especially in a temporal database. We describe the basic techniques behind computing aggregates in conventional databases and show that these techniques are not efficient when applied to temporal databases. We examine the problem of computing constant intervals (intervals of time for which the aggregate value is constant) used for temporal grouping. We introduce two new algorithms for computing temporal aggregates: the aggregation tree and the k-ordered aggregation tree. An empirical comparison demonstrates that the choice of algorithm depends in part on the amount of memory available, the number of tuples in the underlying relation, and the degree to which the tuples are ordered. This study shows that the simplest strategy is to first sort the underlying relation, then apply the k-ordered aggregation tree algorithm with k=1.<<ETX>>
international conference on management of data | 1994
Richard T. Snodgrass; Ilsoo Ahn; Gad Ariav; Don S. Batory; James Clifford; Curtis E. Dyreson; Ramez Elmasri; Fabio Grandi; Christian S. Jensen; Wolfgang Käfer; Nick Kline; Krishna G. Kulkarni; T. Y. Cliff Leung; Nikos A. Lorentzos; John F. Roddick; Arie Segev; Michael D. Soo; Suryanarayana M. Sripada
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 objective. The media plan involves placing commercials, and is recorded in a temporal database. The media plan must then be evaluated; we show how TSQL2 can be used to derive information from the stored data. We then give examples that illustrate storing and querying indeterminate information, comparing multiple versions of the media plan, accommodating changes to the schema, and vacuuming a temporal database of old data.
The TSQL2 Temporal Query Language | 1995
Richard T. Snodgrass; Christian S. Jensen; Curtis E. Dyreson; Wolfgang Käfer; Nick Kline; John F. Roddick
This chapter expresses the schema and some of the queries of the extensive consensus test suite for temporal relational query languages [Jensen 1993]. The test suite is not related to performance issues, but has a semantic focus and is intended to be an aid in evaluating the user-friendliness of temporal query languages. An attempt is made to express the schema and queries in TSQL2 in a convenient and natural fashion, as an informal evaluation of that language’s user-friendliness.
The TSQL2 Temporal Query Language | 1995
Michael D. Soo; Nick Kline; Richard T. Snodgrass
This chapter will consider compatibility of TSQL2 and SQL-92. Some of the changes in TSQL2 provide more functionality, while others provide space savings, reducing the amount of storage required for time, tamps Through the use of a predefined, default calendar, SQL92, full upward compatibility with SQL-92 is ensured.
international conference on management of data | 1994
Curtis E. Dyreson; Fabio Grandi; Wolfgang Käfer; Nick Kline; Nikos A. Lorentzos; Yannis Mitsopoulos; Angelo Montanari; Daniel Nonen; Elisa Peressi; Barbara Pernici; John F. Roddick; Nandlal L. Sarda; Maria Rita Scalas; Arie Segev; Richard T. Snodgrass; Mike D. Soo; Abdullah Uz Tansel; Paolo Tiberio; Gio Wiederhold
Lecture Notes in Computer Science | 1998
Christian S. Jensen; Curtis E. Dyreson; Michael H. Böhlen; James Clifford; Ramez Elmasri; Shashi K. Gadia; Fabio Grandi; Pat Hayes; Sushil Jajodia; Wolfgang Käfer; Nick Kline; Nikos A. Lorentzos; Yannis Mitsopoulos; Angelo Montanari; Daniel Nonen; Elisa Peressi; Barbara Pernici; John F. Roddick; Nandlal L. Sarda; Maria Rita Scalas; Arie Segev; Richard T. Snodgrass; Mike D. Soo; Abdullah Uz Tansel; Paolo Tiberio; Gio Wiederhold
international conference on management of data | 1993
Nick Kline
Software - Practice and Experience | 2007
Bedirhan Urgun; Curtis E. Dyreson; Richard T. Snodgrass; Jessica K. Miller; Nick Kline; Michael D. Soo; Christian S. Jensen
international conference on management of data | 1994
Richard T. Snodgrass; Ilsoo Ahn; Gad Ariav; Don S. Batory; James Clifford; Curtis E. Dyreson; Ramez Elmasri; Fabio Grandi; Christian S. Jensen; Wolfgang Käfer; Nick Kline; Krishna G. Kulkarni; T. Y. Cliff Leung; Nikos A. Lorentzos; John F. Roddick; Arie Segev; Michael D. Soo; Suryanarayana M. Sripada