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.

Contents

Limitations of the Current Demo

  • 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.
  • The SQL Parser accepted a limited syntax with explicit aliases specified, and no aggregates
  • The interface still has some glitch and session management issue (reset cookies in the browser and reload).

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