Nature

1
Nature Applications of Spatial and Temporal
Databases

• What are Spatial and Temporal data?
• Spatial data, ex- geographic space surface of
  the earth
• Man-made space layout of VLSI design
• Temporal data, ex- scheduling application
  airline, car, hotel reservations, scientific
  applications weather monitoring
• Spatio-temporal data Geometry changes over time

2
Characteristics

• Query Processing
• Implementation Architecture
• Data mining
• Data modeling
• Indexing

3
Query Processing

• Spatial Query Points, lines, rectangle
• Example
• Spatial Selection All the post offices no more
  than 40kms from London
• SELECT p.name FROM post p Where dist (p.center,
  London.center) lt 40 and p.popbgt50k
•  
• Spatial join For each river pass through UK,
  find all cities within less than 50 kms
• SELECT c.cname FROM rivers r, cities c WHERE
  r.route intersects UK.area and dist (r.route,
  c.area) lt 50KM

4
Query Processing (Cont.)

• Temporal Query
• Temporal queries can be expressed in
  conventional query language such as SQL, but with
  great difficulty
• More recent language TSQL2
• Extension to SQL-92

5
Data Mining

• Data mining is a process of extracting knowledge
  from large amount of data for useful purpose.
• Spatial and temporal dataming
• Ex- Peano Count Tree

6
Architecture Implementation

• Complex Architecture representing objects with
  spatial extensions and attributes values that
  change over time.
• 3 Types of Architecture Layered, Monolithic,
  Dual layer
• Frame work

Spatial tools
Standard DBMS
7
Applications

• Defense -change of battlefield
• Medical sector-X-ray images, MR-Images
• Business-Accounting
• Government
• Research
• DBMS IBM Informix, Oracle Spatial DBMS, StorNext

8
Summary

• Extension of current spatial database system.
• Still Research based
• Any Questions?

9
Credits

• Many thanks to Andy Jones and the report
  appraiser.