In the Data Project Explorer, you can work locally with
data objects.
The Data Project Explorer displays the following projects:
- Data design projects
- Data design projects are used for database design and information
integration. Use this type of project to develop physical data models,
logical data models, domain models, glossary models, XSD models, and
scripts.
- Use physical data models based on reverse engineering from a relational
database to create an Optim™ logical
data model. Physical data models can be used to generate DDL statements
that can be deployed to a database server.
- Use an Optim logical data
model, which is a logical data model that includes a data access plan.
A data access plan includes policies for selecting and masking data.
Logical data models are not specific to a database that describes
things about which an organization wants to collect data, and the
relationships among these things. You can generate physical data models
or UML models from logical data models.
- Use service requests to define a data management service.
- Use Optim interoperability
models to define and process Optim requests
for Optim and Optim for z/OS®.
- Use domain models to describe an organization's allowed atomic
domain types and their constraints. You can specify atomic domains
as data types for physical and logical data models. Atomic domains
can also be specified as an integrated part of a logical data model.
- Use glossary models to validate a data model for naming standard
compliance, or to determine naming conventions.
- Data development projects
- Data development projects are used for containing an Optim directory and database application development.
This type of project is associated with a single connection in the
Data Source Explorer. Use data development projects to perform the
following tasks:
- You can import and manage Optim directories.
- You can develop, test, and deploy stored procedures and user-defined
functions.
- If the target server supports XML, you can develop XML files and
artifacts for XML applications.
- You can also develop and test SQL queries.
- You can develop and deploy Web services that access data by using
SQL scripts or stored procedures.
Using the Data Project Explorer, you can also perform the following
tasks:
- Analyze the impact and dependency of data objects
- Analyze a data model to ensure model integrity
- Compare two data objects
- Generate DDL for data objects or data models
- Drag and drop or copy database objects from the Data Source Explorer
or from within the Data Project Explorer
- Share projects using a source control system