Data Project Explorer

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: