Introduction to HOPEX Data Architecture
The Scope Covered by HOPEX Data Architecture
Three Modeling Levels
Data Category
Design Workflow
Definition of Responsibilities
Analysis reports
Connecting to HOPEX Data Architecture
HOPEX Data Architecture Profiles
Business Roles of HOPEX Data Architecture
The HOPEX Information Architecture desktop
HOPEX Data Architecture Home Page
Scope Indicators
Displaying the working environment of an enterprise
Creating an enterprise and its working environment
Business Glossary
Introduction to the Creation of a Business Ontology
Vocabulary Management Process
Analysis and organization of business concepts
Concept realization
Consulting the Business Glossary
Searching for Terms in the Business Glossary
Prerequisite
Scope of the Search
Starting the Search
Search filters
Result filters
Displaying the Details of a Term
Standard characteristics
Advanced characteristics
Generating a Glossary
Launching a Glossary Report
Using the Glossary in a Multilingual Context
Defining Business Information
Objects Used
Concept and Term
Links Between Concepts
Definition links
Dependency links
Concept Properties
Concept Instances: Individuals
The Life Cycle of a Concept or Individual
Concept life cycle
Individual life cycle
Periods
Classifying Concepts and the Concept Type Notion
The Concept View
Dictionary Element Realization
Presentation of Concept Modeling Diagrams
The Concept Domain Diagram
Concept Structure Diagram
Concept Type Structure Diagram
State Concept State Structure Diagram
Individual Structure Diagram
The concept life cycle structure diagram
Business Dictionary
The Elements of a Business Dictionary
Accessing the elements of a business dictionary
Importing business information
Work Business Dictionary
Creating a Business Dictionary
Initializing a Business Dictionary Using Logical or Physical Data
Initializing a Business Dictionary Using Logical Data
Initializing a Business Dictionary Using Physical Data
Initializing a Business Dictionary from physical metadata
Initializing a Business Dictionary when Creating Logical or Physical Data
Displaying the Realization Chart
Concept Domain Map
Creating a Concept Domain Map
The Components of a Concept Domain Map
Example of a Concept Domain Map
Reports Available on a Concept Domain Map
Concept Domain
Creating a Concept Domain
Creating the Structure Diagram for a Concept Domain
Building Concept Diagrams
Creating a concept diagram of a concept domain
The components of a concept diagram
Overview of links between objects
Graphic appearance of diagram objects
Defining the Components of a Concept Domain
The components of a concept domain
Defining the access mode to the components (CRUD)
Concept
Accessing the List of Concepts
Creating Concepts
Concepts and Terms
Synonyms
Connecting an existing term to a concept
Accessing the list of terms
Creating terms in multiple languages
Hypernyms and Hyponyms
Renaming Concepts
Concept Properties
Overview
Characteristics
Components
Relationships
Use of Data
Rules and Regulations
Data Quality
Reports
Workflows
Concept Components
Accessing Concept Components
Creating a Concept Component from a Diagram
Describing Concept Power Components
Describing a Computed Concept Component
Concept Properties
Creating a Concept Property
Creating a Concept Property
Connecting a concept property to a concept
Connecting two concept properties
Creating a Computed Concept property
Concept Inheritances
Accessing Concept Inheritances
Creating a Concept Inheritance from a Concept Diagram
Defining Inheritance of a Concept Component
Creating a Concept Component Substitution
Concept structure diagram
Individuals
Accessing Concept Individuals
Creating an Individual
Individual Properties
Creating an Individual Classification
Creating a Dictionary Entity Component
Individual Structure Diagram
Concept or Individual States
Describing State Concepts
Accessing the state concepts list
Creating a state concept from a business dictionary
State concept properties
Describing Event Concepts
Accessing the event concept list
Creating an event concept from a business dictionary
Event concept properties
Connecting an event concept to its concept
State Concept Structure Diagram
Describing Individual States and Events
Accessing the individual state and event list
Creating an Individual state from a concept domain
Individual state properties
Creating an Individual event from a concept domain
Connecting an individual event to an individual
Concept life cycle structure diagram
Creating a concept life cycle
Creating a concept life cycle structure diagram
Adding a concept life cycle event
Creating a concept life cycle transition
Using periods
Concept Type
Accessing the Concept Types List
Creating a New Concept Type
Concept Type Properties
Describing Concept Type Components
Accessing concept type components
Creating a concept type component from a concept domain
Describing Concept Type Variations
Accessing concept type variations
Creating a concept type variation from a concept domain
The Concept Type Structure Diagram
Concept View
Creating a Concept View
Defining the Concept View Content
Displaying objects in the view
Adding a source object to the concept view
Adding a component to the concept view
The View Report
Calculation Rule on Concepts
Associating a Calculation Rule with a Business Object
Calculation Rule on a Concept Property
Example
Creating the calculation rule
Defining rule input and output objects
Calculation Rule on a Concept
Connecting the Business Concepts to the Logical and Physical architecture
Realization of Concept
Defining the Object that Realizes a Concept
Defining the Concept Realized by a Class
Using Realization Matrices
Realization Levels
Creating a Realization Matrix
Data and Database Design
Modeling Data dictionaries
Logical Data Modeling Options
Formalisms
Notations
Overview of Logical Data
Data Dictionary
Data Domain Map
Logical Data Domain
Logical Data View
Data Model
Example
Data Dictionary
Elements of a Data Dictionary
Accessing the elements of a data dictionary
Importing logical data
Data Domain Map
Creating a Data Domain Map
Components of a Data Domain Map
Data Domains and Logical Data Domains
Creating a Data Domain
The Data Domain Diagram
Example of diagram
Creating the diagram of a data domain
Adding an object to the diagram
Adding a Component to the Data Domain
Defining the access mode to the components (CRUD)
Logical Data View
Creating a Logical Data View
Creating a data view (from a list of views)
Creating a data view directly from an object
Displaying Source Objects in the Data View
Defining the Data View Components
Embedded component
Referenced component
Using a view in another view
Class Diagram
Creating a Package
Creating a Class Diagram
Datatypes
Data Type Packages
Creating a New Datatype Package
Creating a datatype
Referencing Datatype Packages
Assigning Types to Attributes
Data Model
Summary of Concepts
Data Model
Data diagram
Building a Data Model
Prerequisite
Creating a Data Model
Creating a Data Diagram
Entities
Creating an entity
Attributes
Creating attributes
Inherited attributes
Associations
Creating an Association
Defining association roles (ends)
Multiplicities
Aggregation
Composition
Reflexive Associations
“N-ary” Association
Constraints
Normalization Rules
First Normal Form
Second Normal Form
Third Normal Form
Generalizations
What is a generalization?
Multiple sub-entities
Multiple inheritance
Creating a generalization
Discriminator
Entity Identifier
Identification by an attribute
Data Model Mapping
Functional Objectives
Running the mapping editor
Creating a mapping
Deleting a mapping
Mapping details
Example of mapping between data models
IDEF1X Notation
About Data Modeling with IDEF1X
Summary of Concepts (IDEF1X)
Creating a Data Model (IDEF1X)
Prerequisite
Creating a Data Model
Data Diagram (IDEF1X)
Entities (IDEF1X)
Creating an entity
Attributes
Associations (IDEF1X)
Mandatory identifying relationship
Mandatory non-identifying relationship
Mandatory Non-Identifying Relationship
non-specific relationship
Associative entity
Defining Association Roles
Multiplicities
Categorization Relationships (Generalizations) - (IDEF1X)
What is a Categorization (Generalization)?
Creating a Categorization
Multiple Categories
Multiple Category Clusters
Complete Categorization
Discriminator
I.E. Notation
About Data Modeling with I.E.
Summary of Concepts (I.E.)
Creating a Data Model (I.E)
Prerequisite
Creating a Data Model
Data Diagram (I.E.)
Entities (I.E.)
Creating an entity
Attributes
Associations (I.E)
Overview
Associations and their Multiplicities
Sub-types (I.E)
What is sub-type?
Multiple Subtypes
Advantages of sub-types
Multiple inheritance
Creating a sub-type
Merise Notation
About Data Modeling (Merise)
Summary of Concepts (Merise)
Creating a Data Model (Merise)
Prerequisite
Creating a Data Model
Data Diagram (Merise)
The entities (Merise)
Creating an entity
The associations (Merise)
Examples of associations
Reflexive relationships
"n-ary" relationships
Participations or cardinalities
Creating an Association (Relationship)
Attributes (Information) - Merise
Properties
Identifier
Creating Attributes
Normalization Rules (Merise)
First Normal Form
Second Normal Form
Third Normal Form
Refining Data Model Specification (Merise)
Ordering Attributes
Attribute Description
Participations or cardinalities
Sub-typing (Merise)
What is sub-type?
Modeling Databases
Logical Formalism and Synchronization
Logical Formalism and Synchronization
Database
Creating Databases
Database Properties
Associating a Package with a Database
Importing a DBMS Version
Relational Domain Map and Relational Domains
Relational Domain Map
Creating a relational domain map
Components of a relational domain map
Relational Domain
Creating a relational domain
Relational Domain Diagram
Relational Diagram
Creating the Relational Diagram
Creating objects in the diagram
Configuring display of relational diagrams
Database Components
Database Tables
Creating a table
Deleting a table
Table Columns
Viewing columns
Creating a column
Deleting a column
Modifying Keys and Indexes
Creating a Key
Primary key
Foreign key
Creating an Index
Adding a Column to a Key or Index
Primary and foreign keys
Specifying Primary Keys
Specifying Foreign Keys
Column Primary Key of Two Tables
Column Primary Key of Three Tables
Data Types and Column Datatypes
Attribute Datatypes
Determining Column Datatypes from Attribute Types
Pivot Types
Connecting a Datatype to a Pivot Type
Connecting a Datatype to a Pivot Type in UML Notation
Mappings Between Pivot Types and Datatypes
Example of correspondence between pivot types and Oracle 8 datatypes
Creating New Datatypes
Creating Datatypes - Example for Oracle 10
Creating Datatypes - Example for SQL Server 7
Database Modeling Rules
Synchronizing logical and physical models
Synchronization Display Options
Synchronization Display Options
"Logical to Physical" Synchronization Rules
Logical to Physical Synchronization: the Entities (or Classes)
General rule
Sub-entity
Abstract entity
Realized entity
Logical to Physical Synchronization: the Associations
Constraint associations (multiplicities: 0,1 or 1,1)
Constraint associations (multiplicities: 0,1 and 0,1)
Deadlocks
Non-constraint association
Association class
Logical to Physical Synchronization: the Parts (UML)
Example 1: None / *
Example 2: Aggregation / *
Example 3: Composition / 0..1
From the Logical Model to the Physical Model
Running Synchronization (Logical > Physical)
Step 1: Selecting the source objects to be synchronized
Step 2: Synchronization options
Step 3: Protecting objects
Step 4: Validating results
Using Options (Logical > Physical)
Take account of optimizations
Take account of deletions
Possible option combinations
Protecting Objects
Frozen mode
Realized mode
Synchronization Results: Correspondences
Mapping characteristics
Reduced Synchronization (Logical to physical mode)
Reduced Synchronization Source Objects (Logical > Physical)
Running from a data model
Running from a data model entity
Running on an entity outside context
Reduced Synchronization Strategies (Logical > Physical)
Impact of synchronized object on other objects
Impact of other objects on synchronized object
All impacts
Running Reduced Synchronization (Logical > Physical)
Reduced synchronization options
Running Synchronization After Modifications
Synchronization after Modification of the Data Diagram
Newly created entities, associations, and attributes in the data diagram
Entities, associations, or attributes deleted from the data diagram
Modified attribute characteristics
Modified name of an attribute, entity, or association
Modified maximum multiplicity of an association
Modified association links
Synchronization after Modifications to the Physical Diagram
Deleted table or column
Created objects
Modified characteristics of objects created by synchronization
Modified order
From the Physical Model to the Logical Model
"Physical to Logical" Synchronization Rules
Running Synchronization (Physical > Logical)
Step 1: Selecting objects to be synchronized
Step 2: Synchronization options
Step 3: Protecting objects
Step 4: Validating results
Reduced synchronization
"Physical to Logical" Synchronization Results
Owner data model
Data diagrams
Mappings
Configuring Synchronization
Preparing Synchronization
Creation Options
On a database
On the DBMS
Configuring Name Generation
Naming rules
Modifying a naming rule
Entering the SQL mask
Configuring PK column names (implicit identifier)
Diagram Synchronization
Case of Diagram Update at Synchronization
After source diagram modification
After target diagram modification
After modification of both diagrams
No modification detected
Particular case: an entity mapping with two tables
Model Mapping
The Database Editor
Run the editor on a database
Creating a Logical/Physical Mapping Tree
Creating a Mapping
Deleting a mapping
Mapping Details
Mapping Properties
Mapping Report
Object status
Saving display of editor indicators
Mapping Source
Mapping Drawing
Denormalizing logical and physical models
Denormalization Principles
Denormalization: consistency of models
Transferring mappings
Deleting source objects
Synchronization and Denormalization
Combining denormalization and synchronization options
Denormalization: Use Case
Logical Denormalization
Running Logical Denormalization
Logical denormalization example
Logical Denormalization Wizards
Transform association to entity
Transform entity to association
Transform generalization to association
Transform association to generalization
Vertical partition of an entity
Horizontal partition of an entity
Merging of entities
Merging of ascending entities
Merging of descending entities
Copy/paste of attributes
Physical Denormalization
Running Physical Denormalization
Physical denormalization example
List of Physical Denormalization Wizards
Vertical partition of a table
Horizontal partition of a table
Merging of tables
Transform foreign key to table
Transform table to foreign key
Copy/paste of columns
Generating SQL scripts
Running SQL Generation
Prerequisite
SQL Generation Objects
Start the generation wizard
Incremental Generation
Incremental Generation Objects
Running Incremental Generation
Generation options
Start the generation wizard
Configuring SQL generation
Configuring the DBMS Version
Supported DBMS versions
Modifying DBMS version properties
Configuring Database Generation
Prefixing Object Names
Inheritance
DBMSs concerned
Supported Syntax
CREATE TABLE Instruction
Managing NOT NULL
PRIMARY KEY clause
FOREIGN KEY clause
UNIQUE clause
CREATE INDEX Instruction (Oracle, Sybase, SQL Server)
Definition of an index
Processing and generating SQL commands
CREATE VIEW Clause
Defining Database Views
Creating Database Views
Add a table or a column to a view
SQL Definition
View joints
User mode
Fields
Defining a Data Group
Defining Triggers for a Database
Creating Triggers
Trigger triggering
References
Repository Integrity
Using Stored Procedures
Adding Physical Properties to Database Objects
Target DBMSs
Creating Physical Properties
Objects containing physical parameters
Creating a new clause
Connecting a clause
Naming clauses
Physical Model Customization Example
Generating the SQL File
Reverse engineer tables
Running Reverse Engineering
Recognizing Datatypes by ODBC
Datatype Recognition Problems
Physical Properties Reverse Engineering
Default Values
Eliminating Redundant and Transverse Values
Specific Cases
Physical properties of tablespaces
Clusters Reverse Engineering
Extracting Database Schema Description from Data Sources
Required Data Source Configuration
Downloading HOPEX Data Source Extractor
Starting Data Extraction
Extraction Report File
Extraction Results File
Customizing ODBC Extraction
Using the Odwdbex.ini file and customized queries
Using ODBC standard APIs
Select Clause Formats
Primary Keys
Foreign Keys
Indexes
Columns
Pivot Types and Datatypes Correspondence Tables
DB2 Version 9 For OS
MySQL 5.0
Oracle 11
PostgreSQL9.3
SQL ANSI/ISO 9075:1992
SQL Server 2008
Teradata Database
Data Analysis Reports
Accessing Reports
Description Reports
The View Report
Glossary Report (Advanced)
Data Domain Map
Data Domain Dependencies
Word Cloud Reports
Amount of Information in Information Areas
Extent of the Description of the Information
Use of Information in Data Area
Data Usage Reports
Use of information held by a container
Use of information in an domain
Use of information of an information map
Use of information
Use of information of the domains of a container
Policies Reports
Regulatory Framework Report
Rules Report
Report DataSets
Creating a Report DataSets
Example of a Report Dataset
Data Validation Workflow
Validation workflow steps
Generating a workflow report
Data Import and Export
Importing Business Data from an Excel File
Downloading the Excel File Template
Content of the Excel Template
Term Sheet
Concept Sheet
Synonym Sheet
Component sheet
State Concept sheet
Importing Logical Data from an Excel File
Downloading the Excel File Template
Content of the Excel Template
Data Dictionary sheet
Data Type sheet
Data Type Component sheet
Class sheet
Attribute sheet
Relationship sheet
Generalization sheet
Importing Data Assessments
Import Example
Content of the Excel Template
Downloading the Excel Template
Importing an Excel File of Data Assessments
Introduction to HOPEX Data Architecture
The Scope Covered by HOPEX Data Architecture
Connecting to HOPEX Data Architecture
The HOPEX Information Architecture desktop
Business Glossary
Introduction to the Creation of a Business Ontology
Consulting the Business Glossary
Searching for Terms in the Business Glossary
Generating a Glossary
Defining Business Information
Objects Used
Presentation of Concept Modeling Diagrams
Business Dictionary
Initializing a Business Dictionary Using Logical or Physical Data
Concept Domain Map
Concept Domain
Building Concept Diagrams
Defining the Components of a Concept Domain
Concept
Concept Properties
Concept Components
Concept Properties
Concept Inheritances
Concept structure diagram
Individuals
Concept or Individual States
Describing State Concepts
Describing Event Concepts
State Concept Structure Diagram
Describing Individual States and Events
Concept life cycle structure diagram
Using periods
Concept Type
Accessing the Concept Types List
Creating a New Concept Type
Concept Type Properties
Describing Concept Type Components
Describing Concept Type Variations
The Concept Type Structure Diagram
Concept View
Calculation Rule on Concepts
Associating a Calculation Rule with a Business Object
Connecting the Business Concepts to the Logical and Physical architecture
Realization of Concept
Using Realization Matrices
Data and Database Design
Modeling Data dictionaries
Logical Data Modeling Options
Overview of Logical Data
Data Dictionary
Data Domain Map
Data Domains and Logical Data Domains
Logical Data View
Class Diagram
Datatypes
Data Model
Building a Data Model
Entities
Attributes
Associations
Reflexive Associations
“N-ary” Association
Constraints
Normalization Rules
Generalizations
Entity Identifier
Data Model Mapping
IDEF1X Notation
About Data Modeling with IDEF1X
Summary of Concepts (IDEF1X)
Creating a Data Model (IDEF1X)
Entities (IDEF1X)
Associations (IDEF1X)
Categorization Relationships (Generalizations) - (IDEF1X)
I.E. Notation
About Data Modeling with I.E.
Summary of Concepts (I.E.)
Creating a Data Model (I.E)
Entities (I.E.)
Associations (I.E)
Sub-types (I.E)
Merise Notation
About Data Modeling (Merise)
Summary of Concepts (Merise)
Creating a Data Model (Merise)
The entities (Merise)
The associations (Merise)
Attributes (Information) - Merise
Normalization Rules (Merise)
Refining Data Model Specification (Merise)
Sub-typing (Merise)
Modeling Databases
Logical Formalism and Synchronization
Database
Relational Domain Map and Relational Domains
Relational Domain
Relational Diagram
Database Components
Database Tables
Table Columns
Modifying Keys and Indexes
Creating a Key
Creating an Index
Adding a Column to a Key or Index
Primary and foreign keys
Data Types and Column Datatypes
Mappings Between Pivot Types and Datatypes
Creating New Datatypes
Database Modeling Rules
Synchronizing logical and physical models
"Logical to Physical" Synchronization Rules
Logical to Physical Synchronization: the Associations
Logical to Physical Synchronization: the Parts (UML)
From the Logical Model to the Physical Model
Running Synchronization (Logical > Physical)
Using Options (Logical > Physical)
Protecting Objects
Synchronization Results: Correspondences
Reduced Synchronization (Logical to physical mode)
Reduced Synchronization Source Objects (Logical > Physical)
Reduced Synchronization Strategies (Logical > Physical)
Running Reduced Synchronization (Logical > Physical)
Running Synchronization After Modifications
Synchronization after Modification of the Data Diagram
Synchronization after Modifications to the Physical Diagram
From the Physical Model to the Logical Model
"Physical to Logical" Synchronization Rules
Running Synchronization (Physical > Logical)
"Physical to Logical" Synchronization Results
Configuring Synchronization
Preparing Synchronization
Creation Options
Configuring Name Generation
Diagram Synchronization
Model Mapping
The Database Editor
Mapping Details
Denormalizing logical and physical models
Denormalization Principles
Denormalization: consistency of models
Synchronization and Denormalization
Denormalization: Use Case
Logical Denormalization
Physical Denormalization
Generating SQL scripts
Running SQL Generation
Prerequisite
SQL Generation Objects
Start the generation wizard
Incremental Generation
Configuring SQL generation
Configuring the DBMS Version
Configuring Database Generation
Prefixing Object Names
Supported Syntax
CREATE TABLE Instruction
CREATE INDEX Instruction (Oracle, Sybase, SQL Server)
Defining Database Views
Defining a Data Group
Defining Triggers for a Database
Using Stored Procedures
Adding Physical Properties to Database Objects
Reverse engineer tables
Running Reverse Engineering
Recognizing Datatypes by ODBC
Physical Properties Reverse Engineering
Extracting Database Schema Description from Data Sources
Pivot Types and Datatypes Correspondence Tables
DB2 Version 9 For OS
MySQL 5.0
Oracle 11
PostgreSQL9.3
SQL ANSI/ISO 9075:1992
SQL Server 2008
Teradata Database
Data Analysis Reports
Data Validation Workflow
Data Import and Export
Importing Business Data from an Excel File
Importing Logical Data from an Excel File
Importing Data Assessments
DATA - Data Architecture
:
Introduction to HOPEX Data Architecture
DATA - Data Architecture
:
Introduction to HOPEX Data Architecture
:
The Scope Covered by HOPEX Data Architecture
DATA - Data Architecture
:
Introduction to HOPEX Data Architecture
:
The Scope Covered by HOPEX Data Architecture
:
Three Modeling Levels
DATA - Data Architecture
:
Introduction to HOPEX Data Architecture
:
The Scope Covered by HOPEX Data Architecture
:
Data Category
DATA - Data Architecture
:
Introduction to HOPEX Data Architecture
:
The Scope Covered by HOPEX Data Architecture
:
Design Workflow
DATA - Data Architecture
:
Introduction to HOPEX Data Architecture
:
The Scope Covered by HOPEX Data Architecture
:
Definition of Responsibilities
DATA - Data Architecture
:
Introduction to HOPEX Data Architecture
:
The Scope Covered by HOPEX Data Architecture
:
Analysis reports
DATA - Data Architecture
:
Introduction to HOPEX Data Architecture
:
Connecting to HOPEX Data Architecture
DATA - Data Architecture
:
Introduction to HOPEX Data Architecture
:
Connecting to HOPEX Data Architecture
:
HOPEX Data Architecture Profiles
DATA - Data Architecture
:
Introduction to HOPEX Data Architecture
:
Connecting to HOPEX Data Architecture
:
Business Roles of HOPEX Data Architecture
DATA - Data Architecture
:
Introduction to HOPEX Data Architecture
:
The HOPEX Information Architecture desktop
DATA - Data Architecture
:
Introduction to HOPEX Data Architecture
:
The HOPEX Information Architecture desktop
:
HOPEX Data Architecture Home Page
DATA - Data Architecture
:
Introduction to HOPEX Data Architecture
:
The HOPEX Information Architecture desktop
:
HOPEX Data Architecture Home Page
:
Scope Indicators
DATA - Data Architecture
:
Introduction to HOPEX Data Architecture
:
The HOPEX Information Architecture desktop
:
Displaying the working environment of an enterprise
DATA - Data Architecture
:
Introduction to HOPEX Data Architecture
:
The HOPEX Information Architecture desktop
:
Displaying the working environment of an enterprise
:
Creating an enterprise and its working environment
DATA - Data Architecture
:
Business Glossary
DATA - Data Architecture
:
Business Glossary
:
Introduction to the Creation of a Business Ontology
DATA - Data Architecture
:
Business Glossary
:
Introduction to the Creation of a Business Ontology
:
Vocabulary Management Process
DATA - Data Architecture
:
Business Glossary
:
Introduction to the Creation of a Business Ontology
:
Vocabulary Management Process
:
Analysis and organization of business concepts
DATA - Data Architecture
:
Business Glossary
:
Introduction to the Creation of a Business Ontology
:
Vocabulary Management Process
:
Concept realization
DATA - Data Architecture
:
Business Glossary
:
Consulting the Business Glossary
DATA - Data Architecture
:
Business Glossary
:
Consulting the Business Glossary
:
Searching for Terms in the Business Glossary
DATA - Data Architecture
:
Business Glossary
:
Consulting the Business Glossary
:
Searching for Terms in the Business Glossary
:
Prerequisite
DATA - Data Architecture
:
Business Glossary
:
Consulting the Business Glossary
:
Searching for Terms in the Business Glossary
:
Scope of the Search
DATA - Data Architecture
:
Business Glossary
:
Consulting the Business Glossary
:
Searching for Terms in the Business Glossary
:
Starting the Search
DATA - Data Architecture
:
Business Glossary
:
Consulting the Business Glossary
:
Searching for Terms in the Business Glossary
:
Starting the Search
:
Search filters
DATA - Data Architecture
:
Business Glossary
:
Consulting the Business Glossary
:
Searching for Terms in the Business Glossary
:
Starting the Search
:
Result filters
DATA - Data Architecture
:
Business Glossary
:
Consulting the Business Glossary
:
Searching for Terms in the Business Glossary
:
Displaying the Details of a Term
DATA - Data Architecture
:
Business Glossary
:
Consulting the Business Glossary
:
Searching for Terms in the Business Glossary
:
Displaying the Details of a Term
:
Standard characteristics
DATA - Data Architecture
:
Business Glossary
:
Consulting the Business Glossary
:
Searching for Terms in the Business Glossary
:
Displaying the Details of a Term
:
Advanced characteristics
DATA - Data Architecture
:
Business Glossary
:
Consulting the Business Glossary
:
Generating a Glossary
DATA - Data Architecture
:
Business Glossary
:
Consulting the Business Glossary
:
Generating a Glossary
:
Launching a Glossary Report
DATA - Data Architecture
:
Business Glossary
:
Consulting the Business Glossary
:
Generating a Glossary
:
Using the Glossary in a Multilingual Context
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Objects Used
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Objects Used
:
Concept and Term
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Objects Used
:
Links Between Concepts
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Objects Used
:
Links Between Concepts
:
Definition links
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Objects Used
:
Links Between Concepts
:
Dependency links
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Objects Used
:
Concept Properties
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Objects Used
:
Concept Instances: Individuals
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Objects Used
:
The Life Cycle of a Concept or Individual
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Objects Used
:
The Life Cycle of a Concept or Individual
:
Concept life cycle
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Objects Used
:
The Life Cycle of a Concept or Individual
:
Individual life cycle
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Objects Used
:
Periods
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Objects Used
:
Classifying Concepts and the Concept Type Notion
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Objects Used
:
The Concept View
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Objects Used
:
Dictionary Element Realization
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Presentation of Concept Modeling Diagrams
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Presentation of Concept Modeling Diagrams
:
The Concept Domain Diagram
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Presentation of Concept Modeling Diagrams
:
Concept Structure Diagram
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Presentation of Concept Modeling Diagrams
:
Concept Type Structure Diagram
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Presentation of Concept Modeling Diagrams
:
State Concept State Structure Diagram
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Presentation of Concept Modeling Diagrams
:
Individual Structure Diagram
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Presentation of Concept Modeling Diagrams
:
The concept life cycle structure diagram
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Business Dictionary
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Business Dictionary
:
The Elements of a Business Dictionary
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Business Dictionary
:
The Elements of a Business Dictionary
:
Accessing the elements of a business dictionary
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Business Dictionary
:
The Elements of a Business Dictionary
:
Importing business information
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Business Dictionary
:
Work Business Dictionary
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Business Dictionary
:
Creating a Business Dictionary
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Business Dictionary
:
Initializing a Business Dictionary Using Logical or Physical Data
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Business Dictionary
:
Initializing a Business Dictionary Using Logical or Physical Data
:
Initializing a Business Dictionary Using Logical Data
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Business Dictionary
:
Initializing a Business Dictionary Using Logical or Physical Data
:
Initializing a Business Dictionary Using Physical Data
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Business Dictionary
:
Initializing a Business Dictionary Using Logical or Physical Data
:
Initializing a Business Dictionary from physical metadata
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Business Dictionary
:
Initializing a Business Dictionary Using Logical or Physical Data
:
Initializing a Business Dictionary when Creating Logical or Physical Data
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Business Dictionary
:
Initializing a Business Dictionary Using Logical or Physical Data
:
Displaying the Realization Chart
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Domain Map
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Domain Map
:
Creating a Concept Domain Map
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Domain Map
:
The Components of a Concept Domain Map
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Domain Map
:
Example of a Concept Domain Map
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Domain Map
:
Reports Available on a Concept Domain Map
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Domain
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Domain
:
Creating a Concept Domain
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Domain
:
Creating the Structure Diagram for a Concept Domain
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Domain
:
Building Concept Diagrams
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Domain
:
Building Concept Diagrams
:
Creating a concept diagram of a concept domain
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Domain
:
Building Concept Diagrams
:
The components of a concept diagram
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Domain
:
Building Concept Diagrams
:
Overview of links between objects
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Domain
:
Building Concept Diagrams
:
Graphic appearance of diagram objects
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Domain
:
Defining the Components of a Concept Domain
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Domain
:
Defining the Components of a Concept Domain
:
The components of a concept domain
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Domain
:
Defining the Components of a Concept Domain
:
Defining the access mode to the components (CRUD)
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
:
Accessing the List of Concepts
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
:
Creating Concepts
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
:
Concepts and Terms
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
:
Concepts and Terms
:
Synonyms
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
:
Concepts and Terms
:
Connecting an existing term to a concept
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
:
Concepts and Terms
:
Accessing the list of terms
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
:
Concepts and Terms
:
Creating terms in multiple languages
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
:
Hypernyms and Hyponyms
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
:
Renaming Concepts
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
:
Concept Properties
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
:
Concept Properties
:
Overview
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
:
Concept Properties
:
Characteristics
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
:
Concept Properties
:
Components
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
:
Concept Properties
:
Relationships
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
:
Concept Properties
:
Use of Data
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
:
Concept Properties
:
Rules and Regulations
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
:
Concept Properties
:
Data Quality
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
:
Concept Properties
:
Reports
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept
:
Concept Properties
:
Workflows
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Components
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Components
:
Accessing Concept Components
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Components
:
Creating a Concept Component from a Diagram
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Components
:
Describing Concept Power Components
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Components
:
Describing a Computed Concept Component
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Properties
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Properties
:
Creating a Concept Property
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Properties
:
Creating a Concept Property
:
Creating a Concept Property
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Properties
:
Creating a Concept Property
:
Connecting a concept property to a concept
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Properties
:
Creating a Concept Property
:
Connecting two concept properties
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Properties
:
Creating a Computed Concept property
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Inheritances
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Inheritances
:
Accessing Concept Inheritances
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Inheritances
:
Creating a Concept Inheritance from a Concept Diagram
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Inheritances
:
Defining Inheritance of a Concept Component
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Inheritances
:
Creating a Concept Component Substitution
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept structure diagram
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Individuals
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Individuals
:
Accessing Concept Individuals
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Individuals
:
Creating an Individual
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Individuals
:
Individual Properties
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Individuals
:
Creating an Individual Classification
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Individuals
:
Creating a Dictionary Entity Component
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Individuals
:
Individual Structure Diagram
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Describing State Concepts
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Describing State Concepts
:
Accessing the state concepts list
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Describing State Concepts
:
Creating a state concept from a business dictionary
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Describing State Concepts
:
State concept properties
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Describing Event Concepts
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Describing Event Concepts
:
Accessing the event concept list
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Describing Event Concepts
:
Creating an event concept from a business dictionary
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Describing Event Concepts
:
Event concept properties
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Describing Event Concepts
:
Connecting an event concept to its concept
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
State Concept Structure Diagram
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Describing Individual States and Events
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Describing Individual States and Events
:
Accessing the individual state and event list
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Describing Individual States and Events
:
Creating an Individual state from a concept domain
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Describing Individual States and Events
:
Individual state properties
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Describing Individual States and Events
:
Creating an Individual event from a concept domain
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Describing Individual States and Events
:
Connecting an individual event to an individual
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Concept life cycle structure diagram
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Concept life cycle structure diagram
:
Creating a concept life cycle
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Concept life cycle structure diagram
:
Creating a concept life cycle structure diagram
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Concept life cycle structure diagram
:
Adding a concept life cycle event
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Concept life cycle structure diagram
:
Creating a concept life cycle transition
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept or Individual States
:
Using periods
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Type
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Type
:
Accessing the Concept Types List
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Type
:
Creating a New Concept Type
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Type
:
Concept Type Properties
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Type
:
Describing Concept Type Components
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Type
:
Describing Concept Type Components
:
Accessing concept type components
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Type
:
Describing Concept Type Components
:
Creating a concept type component from a concept domain
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Type
:
Describing Concept Type Variations
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Type
:
Describing Concept Type Variations
:
Accessing concept type variations
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Type
:
Describing Concept Type Variations
:
Creating a concept type variation from a concept domain
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept Type
:
The Concept Type Structure Diagram
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept View
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept View
:
Creating a Concept View
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept View
:
Defining the Concept View Content
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept View
:
Defining the Concept View Content
:
Displaying objects in the view
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept View
:
Defining the Concept View Content
:
Adding a source object to the concept view
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept View
:
Defining the Concept View Content
:
Adding a component to the concept view
DATA - Data Architecture
:
Business Glossary
:
Defining Business Information
:
Concept View
:
The View Report
DATA - Data Architecture
:
Business Glossary
:
Calculation Rule on Concepts
DATA - Data Architecture
:
Business Glossary
:
Calculation Rule on Concepts
:
Associating a Calculation Rule with a Business Object
DATA - Data Architecture
:
Business Glossary
:
Calculation Rule on Concepts
:
Associating a Calculation Rule with a Business Object
:
Calculation Rule on a Concept Property
DATA - Data Architecture
:
Business Glossary
:
Calculation Rule on Concepts
:
Associating a Calculation Rule with a Business Object
:
Calculation Rule on a Concept Property
:
Example
DATA - Data Architecture
:
Business Glossary
:
Calculation Rule on Concepts
:
Associating a Calculation Rule with a Business Object
:
Calculation Rule on a Concept Property
:
Creating the calculation rule
DATA - Data Architecture
:
Business Glossary
:
Calculation Rule on Concepts
:
Associating a Calculation Rule with a Business Object
:
Calculation Rule on a Concept Property
:
Defining rule input and output objects
DATA - Data Architecture
:
Business Glossary
:
Calculation Rule on Concepts
:
Associating a Calculation Rule with a Business Object
:
Calculation Rule on a Concept
DATA - Data Architecture
:
Business Glossary
:
Connecting the Business Concepts to the Logical and Physical architecture
DATA - Data Architecture
:
Business Glossary
:
Connecting the Business Concepts to the Logical and Physical architecture
:
Realization of Concept
DATA - Data Architecture
:
Business Glossary
:
Connecting the Business Concepts to the Logical and Physical architecture
:
Realization of Concept
:
Defining the Object that Realizes a Concept
DATA - Data Architecture
:
Business Glossary
:
Connecting the Business Concepts to the Logical and Physical architecture
:
Realization of Concept
:
Defining the Concept Realized by a Class
DATA - Data Architecture
:
Business Glossary
:
Connecting the Business Concepts to the Logical and Physical architecture
:
Using Realization Matrices
DATA - Data Architecture
:
Business Glossary
:
Connecting the Business Concepts to the Logical and Physical architecture
:
Using Realization Matrices
:
Realization Levels
DATA - Data Architecture
:
Business Glossary
:
Connecting the Business Concepts to the Logical and Physical architecture
:
Using Realization Matrices
:
Creating a Realization Matrix
DATA - Data Architecture
:
Data and Database Design
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Logical Data Modeling Options
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Logical Data Modeling Options
:
Formalisms
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Logical Data Modeling Options
:
Notations
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Overview of Logical Data
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Overview of Logical Data
:
Data Dictionary
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Overview of Logical Data
:
Data Domain Map
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Overview of Logical Data
:
Logical Data Domain
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Overview of Logical Data
:
Logical Data View
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Overview of Logical Data
:
Data Model
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Overview of Logical Data
:
Data Model
:
Example
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Dictionary
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Dictionary
:
Elements of a Data Dictionary
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Dictionary
:
Elements of a Data Dictionary
:
Accessing the elements of a data dictionary
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Dictionary
:
Elements of a Data Dictionary
:
Importing logical data
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Domain Map
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Domain Map
:
Creating a Data Domain Map
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Domain Map
:
Components of a Data Domain Map
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Domains and Logical Data Domains
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Domains and Logical Data Domains
:
Creating a Data Domain
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Domains and Logical Data Domains
:
The Data Domain Diagram
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Domains and Logical Data Domains
:
The Data Domain Diagram
:
Example of diagram
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Domains and Logical Data Domains
:
The Data Domain Diagram
:
Creating the diagram of a data domain
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Domains and Logical Data Domains
:
The Data Domain Diagram
:
Adding an object to the diagram
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Domains and Logical Data Domains
:
Adding a Component to the Data Domain
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Domains and Logical Data Domains
:
Adding a Component to the Data Domain
:
Defining the access mode to the components (CRUD)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Logical Data View
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Logical Data View
:
Creating a Logical Data View
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Logical Data View
:
Creating a Logical Data View
:
Creating a data view (from a list of views)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Logical Data View
:
Creating a Logical Data View
:
Creating a data view directly from an object
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Logical Data View
:
Displaying Source Objects in the Data View
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Logical Data View
:
Defining the Data View Components
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Logical Data View
:
Defining the Data View Components
:
Embedded component
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Logical Data View
:
Defining the Data View Components
:
Referenced component
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Logical Data View
:
Defining the Data View Components
:
Using a view in another view
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Class Diagram
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Class Diagram
:
Creating a Package
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Class Diagram
:
Creating a Class Diagram
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Datatypes
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Datatypes
:
Data Type Packages
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Datatypes
:
Creating a New Datatype Package
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Datatypes
:
Creating a New Datatype Package
:
Creating a datatype
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Datatypes
:
Referencing Datatype Packages
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Datatypes
:
Assigning Types to Attributes
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Summary of Concepts
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Summary of Concepts
:
Data Model
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Summary of Concepts
:
Data diagram
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Building a Data Model
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Building a Data Model
:
Prerequisite
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Building a Data Model
:
Creating a Data Model
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Building a Data Model
:
Creating a Data Diagram
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Entities
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Entities
:
Creating an entity
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Attributes
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Attributes
:
Creating attributes
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Attributes
:
Inherited attributes
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Associations
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Associations
:
Creating an Association
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Associations
:
Defining association roles (ends)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Associations
:
Multiplicities
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Associations
:
Aggregation
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Associations
:
Composition
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Reflexive Associations
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
“N-ary” Association
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Constraints
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Normalization Rules
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Normalization Rules
:
First Normal Form
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Normalization Rules
:
Second Normal Form
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Normalization Rules
:
Third Normal Form
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Generalizations
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Generalizations
:
What is a generalization?
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Generalizations
:
Multiple sub-entities
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Generalizations
:
Multiple inheritance
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Generalizations
:
Creating a generalization
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Generalizations
:
Discriminator
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Entity Identifier
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Entity Identifier
:
Identification by an attribute
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Data Model Mapping
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Data Model Mapping
:
Functional Objectives
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Data Model Mapping
:
Running the mapping editor
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Data Model Mapping
:
Creating a mapping
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Data Model Mapping
:
Deleting a mapping
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Data Model Mapping
:
Mapping details
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Data Model
:
Data Model Mapping
:
Example of mapping between data models
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
About Data Modeling with IDEF1X
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Summary of Concepts (IDEF1X)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Creating a Data Model (IDEF1X)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Creating a Data Model (IDEF1X)
:
Prerequisite
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Creating a Data Model (IDEF1X)
:
Creating a Data Model
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Creating a Data Model (IDEF1X)
:
Data Diagram (IDEF1X)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Entities (IDEF1X)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Entities (IDEF1X)
:
Creating an entity
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Entities (IDEF1X)
:
Attributes
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Associations (IDEF1X)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Associations (IDEF1X)
:
Mandatory identifying relationship
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Associations (IDEF1X)
:
Mandatory non-identifying relationship
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Associations (IDEF1X)
:
Mandatory Non-Identifying Relationship
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Associations (IDEF1X)
:
non-specific relationship
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Associations (IDEF1X)
:
Associative entity
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Associations (IDEF1X)
:
Defining Association Roles
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Associations (IDEF1X)
:
Multiplicities
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Categorization Relationships (Generalizations) - (IDEF1X)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Categorization Relationships (Generalizations) - (IDEF1X)
:
What is a Categorization (Generalization)?
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Categorization Relationships (Generalizations) - (IDEF1X)
:
Creating a Categorization
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Categorization Relationships (Generalizations) - (IDEF1X)
:
Multiple Categories
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Categorization Relationships (Generalizations) - (IDEF1X)
:
Multiple Category Clusters
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Categorization Relationships (Generalizations) - (IDEF1X)
:
Complete Categorization
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
IDEF1X Notation
:
Categorization Relationships (Generalizations) - (IDEF1X)
:
Discriminator
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
I.E. Notation
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
I.E. Notation
:
About Data Modeling with I.E.
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
I.E. Notation
:
Summary of Concepts (I.E.)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
I.E. Notation
:
Creating a Data Model (I.E)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
I.E. Notation
:
Creating a Data Model (I.E)
:
Prerequisite
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
I.E. Notation
:
Creating a Data Model (I.E)
:
Creating a Data Model
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
I.E. Notation
:
Creating a Data Model (I.E)
:
Data Diagram (I.E.)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
I.E. Notation
:
Entities (I.E.)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
I.E. Notation
:
Entities (I.E.)
:
Creating an entity
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
I.E. Notation
:
Entities (I.E.)
:
Attributes
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
I.E. Notation
:
Associations (I.E)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
I.E. Notation
:
Associations (I.E)
:
Overview
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
I.E. Notation
:
Associations (I.E)
:
Associations and their Multiplicities
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
I.E. Notation
:
Sub-types (I.E)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
I.E. Notation
:
Sub-types (I.E)
:
What is sub-type?
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
I.E. Notation
:
Sub-types (I.E)
:
Multiple Subtypes
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
I.E. Notation
:
Sub-types (I.E)
:
Advantages of sub-types
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
I.E. Notation
:
Sub-types (I.E)
:
Multiple inheritance
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
I.E. Notation
:
Sub-types (I.E)
:
Creating a sub-type
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
About Data Modeling (Merise)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
Summary of Concepts (Merise)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
Creating a Data Model (Merise)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
Creating a Data Model (Merise)
:
Prerequisite
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
Creating a Data Model (Merise)
:
Creating a Data Model
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
Creating a Data Model (Merise)
:
Data Diagram (Merise)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
The entities (Merise)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
The entities (Merise)
:
Creating an entity
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
The associations (Merise)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
The associations (Merise)
:
Examples of associations
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
The associations (Merise)
:
Reflexive relationships
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
The associations (Merise)
:
"n-ary" relationships
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
The associations (Merise)
:
Participations or cardinalities
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
The associations (Merise)
:
Creating an Association (Relationship)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
Attributes (Information) - Merise
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
Attributes (Information) - Merise
:
Properties
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
Attributes (Information) - Merise
:
Identifier
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
Attributes (Information) - Merise
:
Creating Attributes
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
Normalization Rules (Merise)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
Normalization Rules (Merise)
:
First Normal Form
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
Normalization Rules (Merise)
:
Second Normal Form
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
Normalization Rules (Merise)
:
Third Normal Form
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
Refining Data Model Specification (Merise)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
Refining Data Model Specification (Merise)
:
Ordering Attributes
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
Refining Data Model Specification (Merise)
:
Attribute Description
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
Refining Data Model Specification (Merise)
:
Participations or cardinalities
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
Sub-typing (Merise)
DATA - Data Architecture
:
Data and Database Design
:
Modeling Data dictionaries
:
Merise Notation
:
Sub-typing (Merise)
:
What is sub-type?
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Logical Formalism and Synchronization
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Logical Formalism and Synchronization
:
Logical Formalism and Synchronization
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database
:
Creating Databases
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database
:
Database Properties
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database
:
Associating a Package with a Database
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database
:
Importing a DBMS Version
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Relational Domain Map and Relational Domains
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Relational Domain Map and Relational Domains
:
Relational Domain Map
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Relational Domain Map and Relational Domains
:
Relational Domain Map
:
Creating a relational domain map
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Relational Domain Map and Relational Domains
:
Relational Domain Map
:
Components of a relational domain map
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Relational Domain Map and Relational Domains
:
Relational Domain
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Relational Domain Map and Relational Domains
:
Relational Domain
:
Creating a relational domain
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Relational Domain Map and Relational Domains
:
Relational Domain
:
Relational Domain Diagram
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Relational Diagram
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Relational Diagram
:
Creating the Relational Diagram
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Relational Diagram
:
Creating the Relational Diagram
:
Creating objects in the diagram
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Relational Diagram
:
Creating the Relational Diagram
:
Configuring display of relational diagrams
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database Components
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database Components
:
Database Tables
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database Components
:
Database Tables
:
Creating a table
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database Components
:
Database Tables
:
Deleting a table
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database Components
:
Table Columns
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database Components
:
Table Columns
:
Viewing columns
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database Components
:
Table Columns
:
Creating a column
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database Components
:
Table Columns
:
Deleting a column
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database Components
:
Modifying Keys and Indexes
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database Components
:
Creating a Key
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database Components
:
Creating a Key
:
Primary key
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database Components
:
Creating a Key
:
Foreign key
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database Components
:
Creating an Index
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database Components
:
Adding a Column to a Key or Index
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Primary and foreign keys
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Primary and foreign keys
:
Specifying Primary Keys
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Primary and foreign keys
:
Specifying Foreign Keys
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Primary and foreign keys
:
Column Primary Key of Two Tables
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Primary and foreign keys
:
Column Primary Key of Three Tables
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Data Types and Column Datatypes
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Data Types and Column Datatypes
:
Attribute Datatypes
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Data Types and Column Datatypes
:
Determining Column Datatypes from Attribute Types
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Data Types and Column Datatypes
:
Determining Column Datatypes from Attribute Types
:
Pivot Types
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Data Types and Column Datatypes
:
Determining Column Datatypes from Attribute Types
:
Connecting a Datatype to a Pivot Type
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Data Types and Column Datatypes
:
Determining Column Datatypes from Attribute Types
:
Connecting a Datatype to a Pivot Type in UML Notation
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Data Types and Column Datatypes
:
Mappings Between Pivot Types and Datatypes
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Data Types and Column Datatypes
:
Mappings Between Pivot Types and Datatypes
:
Example of correspondence between pivot types and Oracle 8 datatypes
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Data Types and Column Datatypes
:
Creating New Datatypes
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Data Types and Column Datatypes
:
Creating New Datatypes
:
Creating Datatypes - Example for Oracle 10
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Data Types and Column Datatypes
:
Creating New Datatypes
:
Creating Datatypes - Example for SQL Server 7
DATA - Data Architecture
:
Data and Database Design
:
Modeling Databases
:
Database Modeling Rules
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Synchronization Display Options
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Synchronization Display Options
:
Synchronization Display Options
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
"Logical to Physical" Synchronization Rules
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
"Logical to Physical" Synchronization Rules
:
Logical to Physical Synchronization: the Entities (or Classes)
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
"Logical to Physical" Synchronization Rules
:
Logical to Physical Synchronization: the Entities (or Classes)
:
General rule
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
"Logical to Physical" Synchronization Rules
:
Logical to Physical Synchronization: the Entities (or Classes)
:
Sub-entity
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
"Logical to Physical" Synchronization Rules
:
Logical to Physical Synchronization: the Entities (or Classes)
:
Abstract entity
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
"Logical to Physical" Synchronization Rules
:
Logical to Physical Synchronization: the Entities (or Classes)
:
Realized entity
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
"Logical to Physical" Synchronization Rules
:
Logical to Physical Synchronization: the Associations
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
"Logical to Physical" Synchronization Rules
:
Logical to Physical Synchronization: the Associations
:
Constraint associations (multiplicities: 0,1 or 1,1)
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
"Logical to Physical" Synchronization Rules
:
Logical to Physical Synchronization: the Associations
:
Constraint associations (multiplicities: 0,1 and 0,1)
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
"Logical to Physical" Synchronization Rules
:
Logical to Physical Synchronization: the Associations
:
Deadlocks
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
"Logical to Physical" Synchronization Rules
:
Logical to Physical Synchronization: the Associations
:
Non-constraint association
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
"Logical to Physical" Synchronization Rules
:
Logical to Physical Synchronization: the Associations
:
Association class
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
"Logical to Physical" Synchronization Rules
:
Logical to Physical Synchronization: the Parts (UML)
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
"Logical to Physical" Synchronization Rules
:
Logical to Physical Synchronization: the Parts (UML)
:
Example 1: None / *
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
"Logical to Physical" Synchronization Rules
:
Logical to Physical Synchronization: the Parts (UML)
:
Example 2: Aggregation / *
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
"Logical to Physical" Synchronization Rules
:
Logical to Physical Synchronization: the Parts (UML)
:
Example 3: Composition / 0..1
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Logical Model to the Physical Model
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Logical Model to the Physical Model
:
Running Synchronization (Logical > Physical)
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Logical Model to the Physical Model
:
Running Synchronization (Logical > Physical)
:
Step 1: Selecting the source objects to be synchronized
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Logical Model to the Physical Model
:
Running Synchronization (Logical > Physical)
:
Step 2: Synchronization options
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Logical Model to the Physical Model
:
Running Synchronization (Logical > Physical)
:
Step 3: Protecting objects
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Logical Model to the Physical Model
:
Running Synchronization (Logical > Physical)
:
Step 4: Validating results
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Logical Model to the Physical Model
:
Using Options (Logical > Physical)
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Logical Model to the Physical Model
:
Using Options (Logical > Physical)
:
Take account of optimizations
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Logical Model to the Physical Model
:
Using Options (Logical > Physical)
:
Take account of deletions
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Logical Model to the Physical Model
:
Using Options (Logical > Physical)
:
Possible option combinations
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Logical Model to the Physical Model
:
Protecting Objects
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Logical Model to the Physical Model
:
Protecting Objects
:
Frozen mode
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Logical Model to the Physical Model
:
Protecting Objects
:
Realized mode
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Logical Model to the Physical Model
:
Synchronization Results: Correspondences
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Logical Model to the Physical Model
:
Synchronization Results: Correspondences
:
Mapping characteristics
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Reduced Synchronization (Logical to physical mode)
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Reduced Synchronization (Logical to physical mode)
:
Reduced Synchronization Source Objects (Logical > Physical)
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Reduced Synchronization (Logical to physical mode)
:
Reduced Synchronization Source Objects (Logical > Physical)
:
Running from a data model
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Reduced Synchronization (Logical to physical mode)
:
Reduced Synchronization Source Objects (Logical > Physical)
:
Running from a data model entity
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Reduced Synchronization (Logical to physical mode)
:
Reduced Synchronization Source Objects (Logical > Physical)
:
Running on an entity outside context
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Reduced Synchronization (Logical to physical mode)
:
Reduced Synchronization Strategies (Logical > Physical)
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Reduced Synchronization (Logical to physical mode)
:
Reduced Synchronization Strategies (Logical > Physical)
:
Impact of synchronized object on other objects
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Reduced Synchronization (Logical to physical mode)
:
Reduced Synchronization Strategies (Logical > Physical)
:
Impact of other objects on synchronized object
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Reduced Synchronization (Logical to physical mode)
:
Reduced Synchronization Strategies (Logical > Physical)
:
All impacts
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Reduced Synchronization (Logical to physical mode)
:
Running Reduced Synchronization (Logical > Physical)
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Reduced Synchronization (Logical to physical mode)
:
Running Reduced Synchronization (Logical > Physical)
:
Reduced synchronization options
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Running Synchronization After Modifications
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Running Synchronization After Modifications
:
Synchronization after Modification of the Data Diagram
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Running Synchronization After Modifications
:
Synchronization after Modification of the Data Diagram
:
Newly created entities, associations, and attributes in the data diagram
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Running Synchronization After Modifications
:
Synchronization after Modification of the Data Diagram
:
Entities, associations, or attributes deleted from the data diagram
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Running Synchronization After Modifications
:
Synchronization after Modification of the Data Diagram
:
Modified attribute characteristics
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Running Synchronization After Modifications
:
Synchronization after Modification of the Data Diagram
:
Modified name of an attribute, entity, or association
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Running Synchronization After Modifications
:
Synchronization after Modification of the Data Diagram
:
Modified maximum multiplicity of an association
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Running Synchronization After Modifications
:
Synchronization after Modification of the Data Diagram
:
Modified association links
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Running Synchronization After Modifications
:
Synchronization after Modifications to the Physical Diagram
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Running Synchronization After Modifications
:
Synchronization after Modifications to the Physical Diagram
:
Deleted table or column
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Running Synchronization After Modifications
:
Synchronization after Modifications to the Physical Diagram
:
Created objects
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Running Synchronization After Modifications
:
Synchronization after Modifications to the Physical Diagram
:
Modified characteristics of objects created by synchronization
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Running Synchronization After Modifications
:
Synchronization after Modifications to the Physical Diagram
:
Modified order
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Physical Model to the Logical Model
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Physical Model to the Logical Model
:
"Physical to Logical" Synchronization Rules
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Physical Model to the Logical Model
:
Running Synchronization (Physical > Logical)
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Physical Model to the Logical Model
:
Running Synchronization (Physical > Logical)
:
Step 1: Selecting objects to be synchronized
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Physical Model to the Logical Model
:
Running Synchronization (Physical > Logical)
:
Step 2: Synchronization options
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Physical Model to the Logical Model
:
Running Synchronization (Physical > Logical)
:
Step 3: Protecting objects
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Physical Model to the Logical Model
:
Running Synchronization (Physical > Logical)
:
Step 4: Validating results
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Physical Model to the Logical Model
:
Running Synchronization (Physical > Logical)
:
Reduced synchronization
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Physical Model to the Logical Model
:
"Physical to Logical" Synchronization Results
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Physical Model to the Logical Model
:
"Physical to Logical" Synchronization Results
:
Owner data model
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Physical Model to the Logical Model
:
"Physical to Logical" Synchronization Results
:
Data diagrams
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
From the Physical Model to the Logical Model
:
"Physical to Logical" Synchronization Results
:
Mappings
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Configuring Synchronization
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Configuring Synchronization
:
Preparing Synchronization
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Configuring Synchronization
:
Creation Options
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Configuring Synchronization
:
Creation Options
:
On a database
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Configuring Synchronization
:
Creation Options
:
On the DBMS
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Configuring Synchronization
:
Configuring Name Generation
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Configuring Synchronization
:
Configuring Name Generation
:
Naming rules
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Configuring Synchronization
:
Configuring Name Generation
:
Modifying a naming rule
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Configuring Synchronization
:
Configuring Name Generation
:
Entering the SQL mask
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Configuring Synchronization
:
Configuring Name Generation
:
Configuring PK column names (implicit identifier)
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Diagram Synchronization
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Diagram Synchronization
:
Case of Diagram Update at Synchronization
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Diagram Synchronization
:
Case of Diagram Update at Synchronization
:
After source diagram modification
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Diagram Synchronization
:
Case of Diagram Update at Synchronization
:
After target diagram modification
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Diagram Synchronization
:
Case of Diagram Update at Synchronization
:
After modification of both diagrams
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Diagram Synchronization
:
Case of Diagram Update at Synchronization
:
No modification detected
DATA - Data Architecture
:
Data and Database Design
:
Synchronizing logical and physical models
:
Diagram Synchronization
:
Case of Diagram Update at Synchronization
:
Particular case: an entity mapping with two tables
DATA - Data Architecture
:
Data and Database Design
:
Model Mapping
DATA - Data Architecture
:
Data and Database Design
:
Model Mapping
:
The Database Editor
DATA - Data Architecture
:
Data and Database Design
:
Model Mapping
:
The Database Editor
:
Run the editor on a database
DATA - Data Architecture
:
Data and Database Design
:
Model Mapping
:
The Database Editor
:
Run the editor on a database
:
Creating a Logical/Physical Mapping Tree
DATA - Data Architecture
:
Data and Database Design
:
Model Mapping
:
The Database Editor
:
Creating a Mapping
DATA - Data Architecture
:
Data and Database Design
:
Model Mapping
:
The Database Editor
:
Deleting a mapping
DATA - Data Architecture
:
Data and Database Design
:
Model Mapping
:
Mapping Details
DATA - Data Architecture
:
Data and Database Design
:
Model Mapping
:
Mapping Details
:
Mapping Properties
DATA - Data Architecture
:
Data and Database Design
:
Model Mapping
:
Mapping Details
:
Mapping Report
DATA - Data Architecture
:
Data and Database Design
:
Model Mapping
:
Mapping Details
:
Object status
DATA - Data Architecture
:
Data and Database Design
:
Model Mapping
:
Mapping Details
:
Object status
:
Saving display of editor indicators
DATA - Data Architecture
:
Data and Database Design
:
Model Mapping
:
Mapping Details
:
Mapping Source
DATA - Data Architecture
:
Data and Database Design
:
Model Mapping
:
Mapping Details
:
Mapping Drawing
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Denormalization Principles
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Denormalization Principles
:
Denormalization: consistency of models
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Denormalization Principles
:
Denormalization: consistency of models
:
Transferring mappings
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Denormalization Principles
:
Denormalization: consistency of models
:
Deleting source objects
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Denormalization Principles
:
Synchronization and Denormalization
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Denormalization Principles
:
Synchronization and Denormalization
:
Combining denormalization and synchronization options
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Denormalization Principles
:
Denormalization: Use Case
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Logical Denormalization
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Logical Denormalization
:
Running Logical Denormalization
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Logical Denormalization
:
Running Logical Denormalization
:
Logical denormalization example
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Logical Denormalization
:
Logical Denormalization Wizards
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Logical Denormalization
:
Logical Denormalization Wizards
:
Transform association to entity
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Logical Denormalization
:
Logical Denormalization Wizards
:
Transform entity to association
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Logical Denormalization
:
Logical Denormalization Wizards
:
Transform generalization to association
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Logical Denormalization
:
Logical Denormalization Wizards
:
Transform association to generalization
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Logical Denormalization
:
Logical Denormalization Wizards
:
Vertical partition of an entity
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Logical Denormalization
:
Logical Denormalization Wizards
:
Horizontal partition of an entity
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Logical Denormalization
:
Logical Denormalization Wizards
:
Merging of entities
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Logical Denormalization
:
Logical Denormalization Wizards
:
Merging of ascending entities
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Logical Denormalization
:
Logical Denormalization Wizards
:
Merging of descending entities
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Logical Denormalization
:
Logical Denormalization Wizards
:
Copy/paste of attributes
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Physical Denormalization
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Physical Denormalization
:
Running Physical Denormalization
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Physical Denormalization
:
Running Physical Denormalization
:
Physical denormalization example
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Physical Denormalization
:
List of Physical Denormalization Wizards
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Physical Denormalization
:
List of Physical Denormalization Wizards
:
Vertical partition of a table
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Physical Denormalization
:
List of Physical Denormalization Wizards
:
Horizontal partition of a table
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Physical Denormalization
:
List of Physical Denormalization Wizards
:
Merging of tables
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Physical Denormalization
:
List of Physical Denormalization Wizards
:
Transform foreign key to table
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Physical Denormalization
:
List of Physical Denormalization Wizards
:
Transform table to foreign key
DATA - Data Architecture
:
Data and Database Design
:
Denormalizing logical and physical models
:
Physical Denormalization
:
List of Physical Denormalization Wizards
:
Copy/paste of columns
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Running SQL Generation
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Running SQL Generation
:
Prerequisite
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Running SQL Generation
:
SQL Generation Objects
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Running SQL Generation
:
Start the generation wizard
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Incremental Generation
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Incremental Generation
:
Incremental Generation Objects
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Incremental Generation
:
Running Incremental Generation
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Incremental Generation
:
Running Incremental Generation
:
Generation options
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Incremental Generation
:
Running Incremental Generation
:
Start the generation wizard
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Configuring SQL generation
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Configuring SQL generation
:
Configuring the DBMS Version
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Configuring SQL generation
:
Configuring the DBMS Version
:
Supported DBMS versions
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Configuring SQL generation
:
Configuring the DBMS Version
:
Modifying DBMS version properties
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Configuring SQL generation
:
Configuring Database Generation
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Configuring SQL generation
:
Prefixing Object Names
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Configuring SQL generation
:
Prefixing Object Names
:
Inheritance
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Configuring SQL generation
:
Prefixing Object Names
:
DBMSs concerned
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Supported Syntax
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Supported Syntax
:
CREATE TABLE Instruction
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Supported Syntax
:
CREATE TABLE Instruction
:
Managing NOT NULL
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Supported Syntax
:
CREATE TABLE Instruction
:
PRIMARY KEY clause
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Supported Syntax
:
CREATE TABLE Instruction
:
FOREIGN KEY clause
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Supported Syntax
:
CREATE TABLE Instruction
:
UNIQUE clause
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Supported Syntax
:
CREATE INDEX Instruction (Oracle, Sybase, SQL Server)
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Supported Syntax
:
CREATE INDEX Instruction (Oracle, Sybase, SQL Server)
:
Definition of an index
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Supported Syntax
:
CREATE INDEX Instruction (Oracle, Sybase, SQL Server)
:
Processing and generating SQL commands
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Supported Syntax
:
CREATE INDEX Instruction (Oracle, Sybase, SQL Server)
:
CREATE VIEW Clause
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Defining Database Views
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Defining Database Views
:
Creating Database Views
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Defining Database Views
:
Creating Database Views
:
Add a table or a column to a view
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Defining Database Views
:
SQL Definition
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Defining Database Views
:
SQL Definition
:
View joints
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Defining Database Views
:
SQL Definition
:
User mode
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Defining Database Views
:
SQL Definition
:
Fields
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Defining Database Views
:
Defining a Data Group
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Defining Triggers for a Database
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Defining Triggers for a Database
:
Creating Triggers
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Defining Triggers for a Database
:
Creating Triggers
:
Trigger triggering
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Defining Triggers for a Database
:
Creating Triggers
:
References
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Defining Triggers for a Database
:
Repository Integrity
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Using Stored Procedures
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Adding Physical Properties to Database Objects
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Adding Physical Properties to Database Objects
:
Target DBMSs
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Adding Physical Properties to Database Objects
:
Creating Physical Properties
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Adding Physical Properties to Database Objects
:
Creating Physical Properties
:
Objects containing physical parameters
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Adding Physical Properties to Database Objects
:
Creating Physical Properties
:
Creating a new clause
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Adding Physical Properties to Database Objects
:
Creating Physical Properties
:
Connecting a clause
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Adding Physical Properties to Database Objects
:
Creating Physical Properties
:
Naming clauses
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Adding Physical Properties to Database Objects
:
Creating Physical Properties
:
Physical Model Customization Example
DATA - Data Architecture
:
Data and Database Design
:
Generating SQL scripts
:
Adding Physical Properties to Database Objects
:
Generating the SQL File
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Running Reverse Engineering
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Recognizing Datatypes by ODBC
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Recognizing Datatypes by ODBC
:
Datatype Recognition Problems
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Physical Properties Reverse Engineering
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Physical Properties Reverse Engineering
:
Default Values
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Physical Properties Reverse Engineering
:
Eliminating Redundant and Transverse Values
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Physical Properties Reverse Engineering
:
Specific Cases
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Physical Properties Reverse Engineering
:
Specific Cases
:
Physical properties of tablespaces
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Physical Properties Reverse Engineering
:
Specific Cases
:
Clusters Reverse Engineering
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Extracting Database Schema Description from Data Sources
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Extracting Database Schema Description from Data Sources
:
Required Data Source Configuration
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Extracting Database Schema Description from Data Sources
:
Downloading HOPEX Data Source Extractor
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Extracting Database Schema Description from Data Sources
:
Starting Data Extraction
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Extracting Database Schema Description from Data Sources
:
Starting Data Extraction
:
Extraction Report File
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Extracting Database Schema Description from Data Sources
:
Starting Data Extraction
:
Extraction Results File
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Extracting Database Schema Description from Data Sources
:
Customizing ODBC Extraction
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Extracting Database Schema Description from Data Sources
:
Customizing ODBC Extraction
:
Using the Odwdbex.ini file and customized queries
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Extracting Database Schema Description from Data Sources
:
Customizing ODBC Extraction
:
Using ODBC standard APIs
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Extracting Database Schema Description from Data Sources
:
Select Clause Formats
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Extracting Database Schema Description from Data Sources
:
Select Clause Formats
:
Primary Keys
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Extracting Database Schema Description from Data Sources
:
Select Clause Formats
:
Foreign Keys
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Extracting Database Schema Description from Data Sources
:
Select Clause Formats
:
Indexes
DATA - Data Architecture
:
Data and Database Design
:
Reverse engineer tables
:
Extracting Database Schema Description from Data Sources
:
Select Clause Formats
:
Columns
DATA - Data Architecture
:
Data and Database Design
:
Pivot Types and Datatypes Correspondence Tables
DATA - Data Architecture
:
Data and Database Design
:
Pivot Types and Datatypes Correspondence Tables
:
DB2 Version 9 For OS
DATA - Data Architecture
:
Data and Database Design
:
Pivot Types and Datatypes Correspondence Tables
:
MySQL 5.0
DATA - Data Architecture
:
Data and Database Design
:
Pivot Types and Datatypes Correspondence Tables
:
Oracle 11
DATA - Data Architecture
:
Data and Database Design
:
Pivot Types and Datatypes Correspondence Tables
:
PostgreSQL9.3
DATA - Data Architecture
:
Data and Database Design
:
Pivot Types and Datatypes Correspondence Tables
:
SQL ANSI/ISO 9075:1992
DATA - Data Architecture
:
Data and Database Design
:
Pivot Types and Datatypes Correspondence Tables
:
SQL Server 2008
DATA - Data Architecture
:
Data and Database Design
:
Pivot Types and Datatypes Correspondence Tables
:
Teradata Database
DATA - Data Architecture
:
Data Analysis Reports
DATA - Data Architecture
:
Data Analysis Reports
:
Accessing Reports
DATA - Data Architecture
:
Data Analysis Reports
:
Description Reports
DATA - Data Architecture
:
Data Analysis Reports
:
Description Reports
:
The View Report
DATA - Data Architecture
:
Data Analysis Reports
:
Description Reports
:
Glossary Report (Advanced)
DATA - Data Architecture
:
Data Analysis Reports
:
Description Reports
:
Data Domain Map
DATA - Data Architecture
:
Data Analysis Reports
:
Description Reports
:
Data Domain Dependencies
DATA - Data Architecture
:
Data Analysis Reports
:
Word Cloud Reports
DATA - Data Architecture
:
Data Analysis Reports
:
Word Cloud Reports
:
Amount of Information in Information Areas
DATA - Data Architecture
:
Data Analysis Reports
:
Word Cloud Reports
:
Extent of the Description of the Information
DATA - Data Architecture
:
Data Analysis Reports
:
Word Cloud Reports
:
Use of Information in Data Area
DATA - Data Architecture
:
Data Analysis Reports
:
Data Usage Reports
DATA - Data Architecture
:
Data Analysis Reports
:
Data Usage Reports
:
Use of information held by a container
DATA - Data Architecture
:
Data Analysis Reports
:
Data Usage Reports
:
Use of information in an domain
DATA - Data Architecture
:
Data Analysis Reports
:
Data Usage Reports
:
Use of information of an information map
DATA - Data Architecture
:
Data Analysis Reports
:
Data Usage Reports
:
Use of information
DATA - Data Architecture
:
Data Analysis Reports
:
Data Usage Reports
:
Use of information of the domains of a container
DATA - Data Architecture
:
Data Analysis Reports
:
Policies Reports
DATA - Data Architecture
:
Data Analysis Reports
:
Policies Reports
:
Regulatory Framework Report
DATA - Data Architecture
:
Data Analysis Reports
:
Policies Reports
:
Rules Report
DATA - Data Architecture
:
Data Analysis Reports
:
Report DataSets
DATA - Data Architecture
:
Data Analysis Reports
:
Report DataSets
:
Creating a Report DataSets
DATA - Data Architecture
:
Data Analysis Reports
:
Report DataSets
:
Example of a Report Dataset
DATA - Data Architecture
:
Data Validation Workflow
DATA - Data Architecture
:
Data Validation Workflow
:
Validation workflow steps
DATA - Data Architecture
:
Data Validation Workflow
:
Generating a workflow report
DATA - Data Architecture
:
Data Import and Export
DATA - Data Architecture
:
Data Import and Export
:
Importing Business Data from an Excel File
DATA - Data Architecture
:
Data Import and Export
:
Importing Business Data from an Excel File
:
Downloading the Excel File Template
DATA - Data Architecture
:
Data Import and Export
:
Importing Business Data from an Excel File
:
Content of the Excel Template
DATA - Data Architecture
:
Data Import and Export
:
Importing Business Data from an Excel File
:
Content of the Excel Template
:
Term Sheet
DATA - Data Architecture
:
Data Import and Export
:
Importing Business Data from an Excel File
:
Content of the Excel Template
:
Concept Sheet
DATA - Data Architecture
:
Data Import and Export
:
Importing Business Data from an Excel File
:
Content of the Excel Template
:
Synonym Sheet
DATA - Data Architecture
:
Data Import and Export
:
Importing Business Data from an Excel File
:
Content of the Excel Template
:
Component sheet
DATA - Data Architecture
:
Data Import and Export
:
Importing Business Data from an Excel File
:
Content of the Excel Template
:
State Concept sheet
DATA - Data Architecture
:
Data Import and Export
:
Importing Logical Data from an Excel File
DATA - Data Architecture
:
Data Import and Export
:
Importing Logical Data from an Excel File
:
Downloading the Excel File Template
DATA - Data Architecture
:
Data Import and Export
:
Importing Logical Data from an Excel File
:
Content of the Excel Template
DATA - Data Architecture
:
Data Import and Export
:
Importing Logical Data from an Excel File
:
Content of the Excel Template
:
Data Dictionary sheet
DATA - Data Architecture
:
Data Import and Export
:
Importing Logical Data from an Excel File
:
Content of the Excel Template
:
Data Type sheet
DATA - Data Architecture
:
Data Import and Export
:
Importing Logical Data from an Excel File
:
Content of the Excel Template
:
Data Type Component sheet
DATA - Data Architecture
:
Data Import and Export
:
Importing Logical Data from an Excel File
:
Content of the Excel Template
:
Class sheet
DATA - Data Architecture
:
Data Import and Export
:
Importing Logical Data from an Excel File
:
Content of the Excel Template
:
Attribute sheet
DATA - Data Architecture
:
Data Import and Export
:
Importing Logical Data from an Excel File
:
Content of the Excel Template
:
Relationship sheet
DATA - Data Architecture
:
Data Import and Export
:
Importing Logical Data from an Excel File
:
Content of the Excel Template
:
Generalization sheet
DATA - Data Architecture
:
Data Import and Export
:
Importing Data Assessments
DATA - Data Architecture
:
Data Import and Export
:
Importing Data Assessments
:
Import Example
DATA - Data Architecture
:
Data Import and Export
:
Importing Data Assessments
:
Content of the Excel Template
DATA - Data Architecture
:
Data Import and Export
:
Importing Data Assessments
:
Downloading the Excel Template
DATA - Data Architecture
:
Data Import and Export
:
Importing Data Assessments
:
Importing an Excel File of Data Assessments