List of laboratory exercises

Chapter 3: Query Languages

• Basic SQL :
  • SQL script for creating country, city and river tables ( Oracle , mySQL ),
  • SQL script for queries 1 thru' 9 ,
• Basic SQL Laboratory :
  • Exercises ,
  • Sample setup and demonstration using ( Oracle , MySQL ,
  )
• Spatial SQL :
  • Sample spatial queries and datasets using Postgres/PostGIS ,
  • User guide of PostGIS ,

Chapter 4: Spatial Storage and Indexing :

• R-trees : coming soon.

Chapter 6: Spatial Networks :

• Network queries : coming soon.

Chapter 8:

• SQL and Datawarehouses: Oracle based

We would like to acknowledge the contribution of Vania Bogorny in postgres/postgis based spatial queries and David McKoskey in porting the labs to the MySQL DBMS. We would also like to acknowledge the contributions from teaching assistants, namely Jin Soung Yoo, in refining and testing the lab exercises in the Oracle DBMS environment.