Developing Time-Oriented Database Applications in SQL

Be the first to write a review

Overview

Whether you're a database designer, programmer, analyst, or manager, you've probably encountered some of the challenges-and experienced some of the frustrations-associated with time-varying data. Where do you turn to fix the problem and see that it doesn't happen again? In Developing Time-Oriented Database Applications in SQL, a leading SQL researcher teaches you effective techniques for designing and building database applications that must integrate past and current data. Written to meet a pervasive, enduring ...
See more details below
Available through our Marketplace sellers.
See All Options
Other sellers (Other Format)
  • All (6) from $64.79   
  • Used (6) from $0.0   
Close
Sort by
Page 1 of 1
Showing 1 – 5 of 6
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$64.79
RVG Sales
Seller since Tue Oct 07 09:42:47 EDT 2014

Feedback rating:

(1)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

Good
1558604367 MISSING CD. This is a paperback book with moderate shelf-wear, rubbing, creasing and bumping to cover. Spine is tight and square. Interior pages contain sporadic ... underlining, note taking, and/or highlighting in pen, pencil, or highlighter. There are stains/smudges on one or more edges of the book. The front cover is curled from the book being read. There is a section or more with curled, bent, or creased pages. Book is in stock and ready to ship same or next business day. Select Expedited shipping and receive your book within 3-5 business days. Buy with confidence! Please leave feedback after your purchase so that others will know that we are a reliable seller! Thank you! Read more Show Less

Ships from: Redmond, WA

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$64.79
HPB-Dallas
Seller since Tue Aug 05 20:14:18 EDT 2014

Feedback rating:

(19)

Condition: Good
1999 Paperback Good 018 Item may show signs of shelf wear. Pages may include limited notes and highlighting. Includes supplemental or companion materials if applicable. Access ... codes may or may not work. Connecting readers since 1972. Customer service is our top priority. Read more Show Less

Ships from: Dallas, TX

Usually ships in 1-2 business days

  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
$118.00
Better World Books UK
Seller since Fri Jan 01 01:01:01 EST 2010

Feedback rating:

(77)

Condition: Good
Good Ships from the UK. Former Library book. Shows some signs of wear, and may have some markings on the inside. Your purchase also supports literacy charities. *****PLEASE ... NOTE: This item is shipping from an authorized seller in Europe. In the event that a return is necessary, you will be able to return your item within the US. To learn more about our European sellers and policies see the BookQuest FAQ section***** Read more Show Less

Ships from: Dunfermline, United Kingdom

Usually ships in 1-2 business days

  • •Canadian
  • •Standard, 48 States
  • •Standard (AK, HI)
$136.99
SUPER BOOKS
Seller since Tue Oct 07 09:42:27 EDT 2014

Feedback rating:

(55)

Condition: Good
Buy with Confidence. Excellent Customer Support. We ship from multiple US locations. No CD, DVD or Access Code Included.

Ships from: Fort Mill, SC

Usually ships in 1-2 business days

  • •Standard, 48 States
$154.39
Books Revisited
Seller since Tue Oct 07 09:35:53 EDT 2014

Feedback rating:

(294)

Condition: Good
Possible retired library copy, some have markings or writing. May or may not include accessories such as CD or access codes.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
Page 1 of 1
Showing 1 – 5 of 6
Close
Sort by
Sending request ...

More About This Book

Overview

Whether you're a database designer, programmer, analyst, or manager, you've probably encountered some of the challenges-and experienced some of the frustrations-associated with time-varying data. Where do you turn to fix the problem and see that it doesn't happen again? In Developing Time-Oriented Database Applications in SQL, a leading SQL researcher teaches you effective techniques for designing and building database applications that must integrate past and current data. Written to meet a pervasive, enduring need, this book will be indispensible if you happen to be part of the flurry of activity leading up to Y2K.

The enclosed CD-ROM contains all of the code fragments-implemented for Oracle8 Server, IBM DB2 Universal Database, Microsoft SQL Server, and other systems-and evaluation copies of the programs discussed in the book.

Features

  • Offers incisive advice on recording temporal data using SQL data types, defining appropriate integrity constraints, updating temporal tables, and querying temporal tables with interactive and embedded SQL.
  • Provides case studies detailing real-world problems and solutions in areas such as event data, state-based data, partitioned data, and audit logs.
  • Contains over 400 code fragments with detailed explanations.

"...covers the techniques, tools, & issues of time-oriented SQL applications...provides real-life extended case studies ...the CD-ROM includes all of the SQL statements & embedded host codes in the book."

Read More Show Less

What People Are Saying

Jim Gray
Jim Gray, Microsoft Research, From the foreword

I highly recommend this book to anyone interested in temporal data-either designing and building databases that record information over time, or just understanding the concepts that underlie representing temporal information... an excellent job of organizing and summarizing this important area.
Jim Melton
Jim Melton, Oracle Corporation, From the foreword

A long time in the making, not only because the subject matter can seem overwhelmingly complex if not presented carefully, but also because of the great number of examples that Snodgrass has taken from real application systems and translated into standard SQL...
Read More Show Less

Product Details

  • ISBN-13: 9781558604360
  • Publisher: Elsevier Science & Technology Books
  • Publication date: 7/12/1999
  • Series: Morgan Kaufmann Series in Data Management Systems
  • Edition description: BOOK & CD
  • Edition number: 1
  • Pages: 544
  • Product dimensions: 7.33 (w) x 9.17 (h) x 1.03 (d)

Table of Contents

Foreword
Foreword
Preface
1 Introduction 1
2 Fundamental Concepts 11
3 Instants and Intervals 25
4 Periods 89
5 Defining State Tables 111
6 Querying State Tables 143
7 Modifying State Tables 177
8 Retaining a Tracking Log 219
9 Transaction-Time State Tables 253
10 Bitemporal Tables 277
11 Temporal Database Design 343
12 Language Directions 401
13 Prospects 469
Glossary 471
Bibliography 479
Author Index 485
Subject Index 487
About the Author 502
About the CD-ROM 503
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)