Rational Data Collection Service vocabulary -- Draft

Licensed Materials (See http://jazz.net/ns/license.html) - Property of IBM.
© Copyright IBM Corporation 2012. All Rights Reserved.
U.S. Government Users Restricted Rights: Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.

The namespace URI for this vocabulary is:

http://jazz.net/ns/dcs#

This page lists the RDF classes, properties, and individuals that make up the Data Collection Service vocabulary. Following W3C best practices, this information is available as HTML (this page) and as RDF.

More details on how this page was generated and other related material can be found in the wiki article Publishing RDF Vocabularies on jazz.net.

Description:

Data Collection Service

See Also:

Classes in this vocabulary:

BaseResourceGroup, DimensionTableMap, FactTableMap, MapGroup, ODSTableMap, TableInfo

Properties in this vocabulary:

baseXPath, column, dbTransform, defaultSyntax, deliveryKey, deliveryType, dependency, enabled, filter, filterAction, filterType, filterValue, linkDeletion, localTransform, lookupCondition, lookupKey, lookupNotMatch, name, needLock, oracleSyntax, predicateColumnLookup, predicateName, relativeURL, resourceInfo, schemaName, sqlServerSyntax, surrogateKey, tableInfo, tableName, xPath

BaseResourceGroup

http://jazz.net/ns/dcs#BaseResourceGroup

A BaseResourceGroup refers to a specific class or type of source that can provide a set of web resources. For example RTC would constitute a base resource group .

baseXPath

http://jazz.net/ns/dcs#baseXPath

This represents the root XML path of the REST service XML document that is returned.

column

http://jazz.net/ns/dcs#column

Column name of a database table. Used in the mapping specification to indicate which column an XML attribute of a particular XML resource is being mapped to. In the case of the database DDL specification, it simply indicates the name of a column in a particular table.

dbTransform

http://jazz.net/ns/dcs#dbTransform

Specifies in an map the transformation a value is suppose to undergo before being stored into the target table and column.

defaultSyntax

http://jazz.net/ns/dcs#defaultSyntax

Specifies the default value, action, transformation, sql statement in a mapping.

deliveryKey

http://jazz.net/ns/dcs#deliveryKey

This represents the column(s) to use during the data collection when delivering data to a table, to identify if a particular record exists or not in the target table. Essentially the natural key of a record.

deliveryType

http://jazz.net/ns/dcs#deliveryType

Defines how to handle the data delivery to the target database, i.e. update records, append to the table etc.

dependency

http://jazz.net/ns/dcs#dependency

Identifies a dependency between two map groups. This information is used to determine the data dependencies that exist between two map groups. This information can be used to determine a map group processing order.

DimensionTableMap

http://jazz.net/ns/dcs#DimensionTableMap

A DimensionTableMap contains information about one or more resources to collect data from to eventually store in a data mart dimension database table. It contains the information regarding the source data, what to extract, how to transform and in which column to store the information for the selected resources.

enabled

http://jazz.net/ns/dcs#enabled

Specifies whether a specific map group is enabled for collection when the collection jobs runs. Valid values are true or false

FactTableMap

http://jazz.net/ns/dcs#FactTableMap

A FactTableMap contains information about one or more resources to collect data from to eventually store in a data mart fact database table. It contains the information regarding the source data, what to extract, how to transform and in which column to store the information for the selected resources.

filter

http://jazz.net/ns/dcs#filter

Specifies filter criteria either for incoming data or data being stored in the target table.

filterAction

http://jazz.net/ns/dcs#filterAction

Within a filter specification, specifies if the filter is to include the data meeting the criteria or exclude the data meeting the criteria.

filterType

http://jazz.net/ns/dcs#filterType

Specifies whether the filtering applies to the incoming data or to the data being stored to a target table.

filterValue

http://jazz.net/ns/dcs#filterValue

The filter criteria to apply to the data

linkDeletion

http://jazz.net/ns/dcs#linkDeletion

localTransform

http://jazz.net/ns/dcs#localTransform

Specifies the invocation of a DCS function to transform data. Local implies the function is an implementation in DCS and the data is transformed in the DCS engine.

lookupCondition

http://jazz.net/ns/dcs#lookupCondition

In a mapping specification that defines a lookup, this property specifies a logical operator to use when specifying to lookup data in a target table. Limited to AND and OR.

lookupKey

http://jazz.net/ns/dcs#lookupKey

In a mapping specification that defines a lookup, this property specifies what constitutes the key column(s) to use to compare values in a table in order to find a matching record stored in another table.

lookupNotMatch

http://jazz.net/ns/dcs#lookupNotMatch

In a mapping specification that defines a lookup, this property specifies how to handle the case when a record match is not found.

MapGroup

http://jazz.net/ns/dcs#MapGroup

A MapGroup refers to a set of ODSTableMap,FactTableMap or DimensionTableMap instances mapping specifications grouped together with the intent to process the data as one unit of collection cycle. For example we could define a MapGroup called RTC Workitem that groups together all of the ODSTableMap mapping specifications for collecting work item data from RTC.

name

http://jazz.net/ns/dcs#name

Logical name of an XML attribute in the mapping definition. The name could be identical to the actual xml attribute name or different.

needLock

http://jazz.net/ns/dcs#needLock

ODSTableMap

http://jazz.net/ns/dcs#ODSTableMap

An ODSTableMap contains information about one or more resources to collect data from to eventually store in a Operational Data Store (ODS) database table. It contains the information regarding the source data, what to extract, how to transform and in which column to store the information for the selected resources.

oracleSyntax

http://jazz.net/ns/dcs#oracleSyntax

Specifies a value, action, transformation, sql statement in a mapping specific to Oracle

predicateColumnLookup

http://jazz.net/ns/dcs#predicateColumnLookup

In a lookup specification, identifies which predicate and parent table column name to use as a key to match records.

predicateName

http://jazz.net/ns/dcs#predicateName

In a lookup specification, identifies the predicate name used as a key to match records.

relativeURL

http://jazz.net/ns/dcs#relativeURL

Relative URL to the REST service server URL to use to retrieve the actual XML data for a particular resource

resourceInfo

http://jazz.net/ns/dcs#resourceInfo

Provides information regarding XML resources, or database resources. Information provided include the base resource group, the relative URL and the X path in the case of an XML based resource or an SQL query in the case of a database resource.

schemaName

http://jazz.net/ns/dcs#schemaName

Identifies the table schema of the table in the target database specified in the mapping.

sqlServerSyntax

http://jazz.net/ns/dcs#sqlServerSyntax

Specifies a value, action, transformation, sql statement in a mapping specific to SQLServer

surrogateKey

http://jazz.net/ns/dcs#surrogateKey

Specifies which column in the target table acts as the surrogate key for the table for which DCS needs to generate a value.

TableInfo

http://jazz.net/ns/dcs#TableInfo

A TableInfo refers to a database table specification. It contains physical table meta data in the database.

tableInfo

http://jazz.net/ns/dcs#tableInfo

Used in the specification to enclose information regarding a physical table in the target database.

tableName

http://jazz.net/ns/dcs#tableName

Identifies the tables physical name in the mapping specification.

xPath

http://jazz.net/ns/dcs#xPath

Excluding the root XPath of a particular XML document, this represents the XML path of an element in an XML document. The root XML path (baseXPath) is prepended eventually to this path at runtime to get the entire XML path of an element.