Scaled Normalization
Home
Schema:
Scale:
Constraint Set: (X -> Y (beta) or X (beta) for keys) =
->
Add Constraint
Load For Demonstration
Constraint Type:
Functional Dependencies
Keys
Schema Size:
Scale Size:
Number of Functional Dependencies:
Generate Randomized Input
Attribute Set/Functional Dependency/Key:
Scale Index:
Algorithm:
BCNF Decomposition
3NF Decomposition
Canonical Cover
Possbilistic Canonical Cover
All Minimal Keys
Projection
Attribute Set Closure
Certainty Inference
Generate Randomized Input
Syntactic FD Set Closure
Implication
Possibilistic Armstrong Table
© 2013 University of Auckland v0.9949
(Optimized for Firefox and IE > 9)
Output
Done
View Input Data
Back
Load File
Load File
Instructions on Use
Previous
Next
Enter Input Data
Ok
Instructions on Use
You need to first set up a schema, a certainty scale and a set of constraints. This can be done in a number of ways. 1. You can add the schema, the scale and the constraint set manually using the fields provided. The schema field and left hand/right hand sides of each constraint expect a comma-delineated list of attributes. The scale field expects a comma-delineated list of strings. 2. You can click on the Load File button and load a schema/scale/constraint set document into the program. The file must be of a required format. The first line must be a comma separated list of attributes, the second line must be a comma separated list of strings, the third line if not empty must be a comma separated list of strings. Any subsequent lines must consist of individual constraints of the form X -> Y (
) if functional dependencies and X (
) if keys. The file must not end with more than one carriage return sequence. 3. You can enter the data directly in the raw by clicking on Enter Input Directly. The format is the same as above for option 2. 4. You can click on the Generate Randomized Input button. Optionally you can explicitly set the schema size, number of functional dependencies and scale size. Next you select an algorithm to run using this data. Select from the main algorithms drop-down - in some cases there are sub-options. In most cases you are now required to specify a scale index or beta value. (In fact if you leave the scale index blank then the algorithms will act as for the classical model). Using the Constraint Set Window: -------------------------------- Ensure that you have first selected the constraint set window by clicking in it. Then press the following keys as follows: 'c' - clear the list 'd' - delete the current selected entry 'i' - brings up a screen allowing direct raw entry of data 'l' - brings up a dialog for loading in a file of data 'v' - view the data in format ready for direct entry
Future Use - Page Two
To be filled
Future Use - Page Three
To be filled
Version 1 - Standard
Version 2 - Tsao/Fischer
Version 3 - Augmented Tsao/Fischer
Version 1 - Expanded
Version 2 - Unique LHS
Version 1 - Expanded
Version 2 - Unique LHS
Version 1 - Expanded
Version 2 - Unique LHS
Version 1 - Standard
Version 1 - Standard