The conversion of different database table structure, the use of PowerDesigner tutorial

Learning PowerDesigner tools, learning conceptual models, physical models, object-oriented models, business models, and the transformation of different database table structures.

Share with the case, how the SQL Server 2008r2 between the database and the Oracle database. Recognize several concepts before you learn to convert.

Conceptual model: Modeling data and information, organizing data using entity-relationship diagrams (e-r), and verifying the validity and rationality of data design.

Logical data Model (LDM): The logical model is mainly to make the whole conceptual model easier to understand, without relying on the specific database implementation, using the logical model can generate a specific database management system physical model. The logical model is not required throughout the step, and can be generated directly from the conceptual model.

Physical model: Based on a specific DBMS, the conceptual data model, logical data model based on the design. Generate a database from a physical data model, or reverse engineer a database to get a physical data model.

Object-oriented: Contains all the graphs common to UML: Class diagram, object graph, package diagrams, use case diagram, time series diagram, collaboration diagram, interaction diagram, activity diagram, state diagram, Component diagram, composite structure diagram, deployment diagram (configuration diagram). OOM is essentially a static conceptual model of a software system.

Business model: BPM describes the various internal tasks and internal processes of the business, and how customers interact with these tasks and processes. BPM is a conceptual model of business logic and rules from the point of view of a business partner, using a diagram to describe the interactions between programs, processes, information, and cooperation agreements.

Information flow model (ILM): ILM is a high-level information flow model that is primarily used for data replication between distributed databases.

Enterprise Architecture Model (EAM): A full description of the enterprise architecture from the business, application, and technology levels. Include: Organization chart, business communication diagram, process diagram, City plan diagram, application frame composition, service oriented diagram, technical framework diagram.

Case: Conceptual model to physical model transformation as shown:

Case: Transformation of the physical model to the conceptual model:

Case: Conversion case between Oracle and SQL Server database tables

A detailed approach to table structure transformation between different databases

The conversion of different database table structure, the use of PowerDesigner tutorial