In the Data Project Explorer, you can work locally with data objects.
The Data Project Explorer displays the following projects:
- Data
design projects, which are used for database design and information integration.
This type of project stores physical data models, logical
data models, domain models, glossary
models, XSD
models, and scripts.
- Data
development projects, which store DB2® stored procedures and user-defined functions, Derby stored procedures, and
SQL statements.
- DB2 Change Management
projects, which are containers for storing the resources that you will use
to plan, analyze, archive, and make changes to your databases. The resources
that you will use to make database changes include models and scripts.
Using the Data Project Explorer, you can also:
- Create
a physical data model, which can be used to generate DDL statements that can
be deployed to a database server.
- Create
a logical data model. A logical data model is a model that is not specific
to a database that describes things about which an organization wants to collect
data, and the relationships among these things.
- Create
a domain model, which describes an organization's allowed atomic domain types
and their constraints.
- Create
a glossary model, which is used to validate a data model for naming standard
compliance, or to determine naming.
- Analyze
the impact and dependency of data objects
- Analyze
a data model to ensure model integrity
- Transform
logical data models into physical data models
- Compare two data
objects
- Generate DDL for data
objects or data models
- Drag and drop
or copy database objects from the Database Explorer or from within the Data
Project Explorer
- Create DB2 stored
procedures and user-defined functions, and Derby stored procedures
- Deploy
stored procedures or user-defined functions to a database that is either local
or remote
- Share projects using a source control system.
- Rename
or delete logical data objects.
- Create SQL statements
using the SQL builder or
the SQL editor