1 / 39

Temporal Database Management: Querying and Modeling Data

Explore temporal databases, subqueries, aggregates, classical user model, multihomogeneity, and querying errors with TempSQL. Learn about static and snapshot data and querying spatio-temporal data with spatial representation.

elisaw
Download Presentation

Temporal Database Management: Querying and Modeling Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Temporal Database Chap 2: A Prelude to Parametric Data

  2. Fig 2.1 The personnel database

  3. Fig 2.2 Snapshot of management at now

  4. Fig 2.3 The management

  5. TempSQL

  6. TempSQL

  7. The Select Statement

  8. The Select Statement

  9. The Select Statement

  10. 2.2.14 Subqueries

  11. 2.2.15 Aggregates

  12. 2.2.16 The Classical User

  13. 2.2.17 Multihomogeneity

  14. 2.3 Comparison with Interval Timestamping

  15. 2.3 Comparison with Interval Timestamping

  16. 2.3 Comparison with Interval Timestamping

  17. 2.3 Comparison with Interval Timestamping

  18. 2.3 Comparison with Interval Timestamping

  19. 2.4 Static Data, Snapshot Data, and Upward Compatibility

  20. 2.4 Static Data, Snapshot Data, and Upward Compatibility

  21. 2.4.1 Users

  22. 2.5.1 A Transaction Log

  23. 2.5.3 Querying the Model

  24. 2.5.3 Querying the Model

  25. 2.5.3 Querying the Model

  26. 2.6 A Model for Querying Errors

  27. 2.6 A Model for Querying Errors

  28. 2.6 A Model for Querying Errors

  29. 2.6 A Model for Querying Errors

  30. 2.6.1 Querying for Errors

  31. 2.7 A Model for Querying Incomplete Information Figure 2.15(a) shows a bitemporal SALARY value. When the future is of no concern to us, this can be represented more compactly as shown in Figure 2.15(b).

  32. 2.7.1 Partial Temporal Elements

  33. 2.7.1 Partial Temporal Elements

  34. 2.7.2 Attributes

  35. 2.7.3 Tuples and Relations

  36. 2.8 A Model for Querying Spatio-temporal Data Below is an example of a spatial-temporal database arising in agriculture. It consists Of the following for relations. Their spatial representation is shown in Figure 2.18, andtheir relational representation is shown in Figure 2.19.

  37. 2.8 A Model for Querying Spatio-temporal Data

  38. 2.8 A Model for Querying Spatio-temporal Data

  39. 2.8 A Model for Querying Spatio-temporal Data

More Related