| Description |
Download File |
| CWM Java Interfaces: This zip file contains a
complete set of Java interfaces for CWM 1.0, based on the Java Metadata
Interface 1.0 (JMI
/ JSR-40) specification. These are the same Java interfaces used
in code samples in the book. Note that these interfaces are dependent
on the JMI 1.0 interfaces, which can be downloaded from this location. |
CWM_v1.0_Interfaces.zip |
| CWM Metastore VB Demo: This zip file contains
the VB demo script that populates the CWM Metastore repository with
sample meta data (from pages 544-552 of the CWM Developers Guide). |
CWM_Metastore_Demo.zip |
| CWM Metastore Creation Script: This zip file contains
the complete creation source script for the CWM Metastore. It is written
in Microsoft’s T-SQL language for Microsoft SQL Server 2000. When
the script is executed by SQL Server’s Query Analyzer program, an
empty instance of the CWM Metastore will be created. |
CWMMetastoreCreationScript.zip |
| Accessing Multivalued Attributes: This example T-SQL script
shows how to retrieve multi-valued attributes of the Machine class
in the SoftwareDeployment package. It appears on page 465 and references
data in Figure 8.13 |
AccessingMultivaluedAttributesOfMachine.sql |
| Enforcing Column Ownership: The T-SQL example script shows
one way that an ClassifierFeature association’s Create procedure might
be modified to enforce the fact that the features contained by a relational
Table must be instances of the Column class. The technique used here
is for illustration only; it is not implemented in the complete CWM
Metastore definition script described above. The script appears on
page 527 of the book. |
EnforcingColumnOwnership.sql |
| Find a Data Source: Finding the location of a data source
is a key task in CWM. This script shows how the Metastore’s procedures
can be used to accomplish this task. The script is appears on pages
512 and 513 |
FindingADataSource.sql |
| Retrieve Kind of Instance: The GetKind procedure exercised
in this T-SQL script returns a text string containing the name of
the CWM class in which an instance was created. That is, the CWM class
whose Create procedure placed the instance in the Metastore. The procedure
is defined on the Element class and can be called from any level within
the CWM class hierarchy. The script is found in the discussion of
ClassMap services on page 540. |
RetrieveKindOfInstance.sql |
| Multivalued Attributes: From page 464, this script illustrates
retrieval of the values of a multi-valued attribute. It differs from
the ”Accessing Multivalued Attributes” script above in that it uses
the Get procedure rather than the GetCursor procedure. |
MultivaluedAttributes.sql |
| Returning Identity Sets: The following T-SQL script illustrates
the use of the GetCursor_Relational_TableOwningTrigger_trigger procedure
to return sets of identity values, using the example data from Figure
8.29. The script appears on page 508 of the text. |
ReturningIdentitySets.sql |
| Simple Attribute: To illustrate usage of simple attribute
procedures, this T-SQL fragment sets the length column of the collationName.
It is from page 459 and references data from Figure 8.11. |
SimpleAttribute.sql |
| Using GetCursor Procedures: This script illustrates use of
GetCursor procedures that return a T-SQL server-side cursor allowing
individual instances in a result set to be independently manipulated
within a T-SQL script. The script also shows that inherited attributes
are returned by all forms of Get procedures. The example is from page
476 and 477. |
UsingGetCursorProcedures.sql |
| Validate Dimension Deployment: The Validate_DimensionDeployment
script from pages 530 and 531 demonstrates how a T-SQL script might
be used to validate the contents of a CWM Metastore. The script is
provided to illustrate a particular point described in the text and
does not appear in the Metastore creation script described at the
top of this page. |
ValidateDimensionDeployment.sql |
| Create Data for Figure 8_21: This T-SQL script loads a simple
database schema into the Metastore, creating the instances shown in
Figure 8.21. The script appears on page 485 of the text. |
CreateFigure8_21Data.sql |
| Create Data for Figure 8_9: This T-SQL fragment illustrates
how stored procedures can be used to create the example data shown
in Figure 8.9 representing how class-based types are stored. The Create_Core_Attribute
procedure automatically creates the instance of Expression required
to implement the initialValue attribute and places its _ID value into
the initialValue_ID column of the attribute’s row in the Core_Attribute
table. The script can be found on page 452. |
CreateFigure8_9Data.sql |
