• 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 Meta Datasets
        • 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
        • Connecting an existing term to a concept
        • Creating terms in multiple languages from a concept
        • Creating synonyms in multiple languages
      • Renaming Concepts
      • Concept Properties
        • Overview
        • Characteristics
        • Components
        • Relationships
        • Data Usage
        • 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
    • Database
      • Creating Databases
      • Database Properties
      • Associating a Package with a Database
      • Importing a DBMS Version
    • Relational Schema Map and Relational Schemas
      • Relational Schema Map
        • Creating a relational schema map
        • Components of a relational schema map
      • Relational Schema
        • Creating a Relational Schema
        • Relational Schema 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
    • "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
        • SQL Definition
      • 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
    • 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