Developing time-oriented database applications in SQL

著者

• Snodgrass, Richard T.

書誌事項

Developing time-oriented database applications in SQL

Richard T. Snodgrass

Morgan Kaufmann Publishers, [1999], c2000

注記

Includes bibliographical references

内容説明・目次

内容説明

Showing professional SQL programmers how to effectively develop applications that involve time-oriented data and queries, this book covers such areas as: how to best record temporal data in tables using the SQL types; how to define appropriate integrity restraints; how to correctly update temporal tables using interactive and embedded SQL; and how to write a wide range of interactive and embedded SQL queries involving temporal tables. Sample queries include time-slice queries, different kinds of temporal joins, temporal coalescing, temporal aggregates, temporal unions, differences, and intersections. In addition, the choice of appropriate storage structures and indices is covered. The accompanying CD-ROM includes all the SQL statements and embedded host code in the book, along with data from actual applications. The package provides real-life extended case studies which gradually introduce concepts and techniques.

「Nielsen BookData」 より

詳細情報

• NII書誌ID(NCID): BA42465365
• ISBN:
  • 1558604367
• LCCN: 99014298
• 出版国コード: us
• タイトル言語コード: eng
• 本文言語コード: eng
• 出版地: San Francisco, Calif.
• ページ数/冊数: xxiii, 504 p.
• 大きさ: 24 cm
• 付属資料: 1 cd-rom
• 分類:
  • LCC : QA76.73.S67
  • DC21 : 005.75/6
• 件名:
  • LCSH : SQL (Computer program language)
  • LCSH : Database design