Difference between revisions of "PrismDemo"
From Schema Evolution
(New page: The on-line Demo of Prism is available at http://yellowstone.cs.ucla.edu:8180/Prism . Please notice that this software is currently under development, and not officially released yet. The...) |
(→Suggested Run) |
||
| Line 5: | Line 5: | ||
== Suggested Run == | == Suggested Run == | ||
| − | Configuration: | + | === Configuration: === |
* Select the Configuration Tab | * Select the Configuration Tab | ||
* Click Load Schema, leaving the configuration parameters to the default (MediaWiki Schema 48) | * Click Load Schema, leaving the configuration parameters to the default (MediaWiki Schema 48) | ||
| − | SMO-Design: | + | === SMO-Design: === |
* Select SMO-Design Tab | * Select SMO-Design Tab | ||
* Try to input the following SMO: '''DECOMPOSE TABLE objectcache INTO ob1(keyname, value), ob2(keyname,exptime);''' | * Try to input the following SMO: '''DECOMPOSE TABLE objectcache INTO ob1(keyname, value), ob2(keyname,exptime);''' | ||
| Line 19: | Line 19: | ||
* Add the following SMO: '''DROP TABLE b2''' | * Add the following SMO: '''DROP TABLE b2''' | ||
| − | Inverse-Design: | + | ===Inverse-Design:=== |
| + | |||
* Select Inverse-Design Tab | * Select Inverse-Design Tab | ||
* Observe the inverses computed by the system | * Observe the inverses computed by the system | ||
| Line 27: | Line 28: | ||
* Visualize schema supported at version 48:0 | * Visualize schema supported at version 48:0 | ||
| − | Validation: | + | ===Validation:=== |
| + | |||
* Select Validation Tab | * Select Validation Tab | ||
* The DEDs forward and backward are shown (scroll to skip initial type and schema definitions) | * The DEDs forward and backward are shown (scroll to skip initial type and schema definitions) | ||
* Input the query '''SELECT o.exptime,o.keyname,o.value FROM objectcache o''' | * Input the query '''SELECT o.exptime,o.keyname,o.value FROM objectcache o''' | ||
| − | Deployment: | + | ===Deployment:=== |
| + | |||
* Select Deployment Tab | * Select Deployment Tab | ||
* Observe SQL views (scroll to objectcache table) | * Observe SQL views (scroll to objectcache table) | ||
* Observe SQL data migration script | * Observe SQL data migration script | ||
Revision as of 22:50, 8 May 2008
The on-line Demo of Prism is available at http://yellowstone.cs.ucla.edu:8180/Prism . Please notice that this software is currently under development, and not officially released yet. The default schema you will be testing doesn't contains any integrity constraints, thus some of the System optimizations are not accessible at the moment.
Contents |
Suggested Run
Configuration:
- Select the Configuration Tab
- Click Load Schema, leaving the configuration parameters to the default (MediaWiki Schema 48)
SMO-Design:
- Select SMO-Design Tab
- Try to input the following SMO: DECOMPOSE TABLE objectcache INTO ob1(keyname, value), ob2(keyname,exptime);
- Add the smo to the working set
- Click on Show Resulting Schema to visualize the resulting schema
- Add the following SMO: COPY TABLE blobs INTO b2
- Add the following SMO: DROP TABLE archive (notice the various feedback on information preservation and redundancy)
- Add the following SMO: DROP TABLE blobs
- Add the following SMO: DROP TABLE b2
Inverse-Design:
- Select Inverse-Design Tab
- Observe the inverses computed by the system
- On the right hand-side the system computes query "support" (there are 3 queries at the moment in the system), click on the buttons to see failing query
- Click on "show supported schema buttons" to see the supported schema.
- Edit SMO 48:4-48:3 and substitute it with a NOP
- Visualize schema supported at version 48:0
Validation:
- Select Validation Tab
- The DEDs forward and backward are shown (scroll to skip initial type and schema definitions)
- Input the query SELECT o.exptime,o.keyname,o.value FROM objectcache o
Deployment:
- Select Deployment Tab
- Observe SQL views (scroll to objectcache table)
- Observe SQL data migration script
