6.893 Architecture of Database Systems
Term Project
Interactive Demonstration
Here, I present a simple interactive demonstration for the project. The queries are
run off my machine, clementi.mit.edu, running PostgreSQL 7.1.3.
Results of Query:
Query:
CAUTION: Please be reminded the the valid range of WSTD is from
(1887,1) to (2001,173).
If you exceed this range, POSTGRES will return an error! The following are the tests that I used:
- Same_year (WSTD-1, WSTD-2)
- Same_day_of_week (WSTD-1, WSTD-2)
- Distance (WSTD-1, WSTD-2)
- Mon (WSTD), Tues (WSTD),
Wed (WTD), Thu (WSTD),
Fri (WSTD)
- DJIA (WSTD)
- Get_Date (WSTD)
- Greater_than (WSTD-1, WSTD-2)
- Less_than (WSTD-1, WSTD-2)
- Greater_Equal (WSTD-1, WSTD-2)
- Less_Equal (WSTD-1, WSTD-2)
- Equals (WSTD-1, WSTD-2)
- Complex Query 1
- Complex Query 2
- Complex Query 3
- Complex Query 4
- Complex Query 5
- B-Tree/Optimizer Query 1
- B-Tree/Optimizer Query 2
Please click on any of the above tests to run them. Alternatively, you can type in your own query or
modify the above and see what it does. Unfortunately, EXPLAIN does not return any results so you cannot
really see the results for the B-Tree Optimizer with this demo.