PrismDemo

From Schema Evolution
Jump to: navigation, search

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 Test

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
Personal tools