Download
1 / 35

Oracle SQL Developer Data Modeler Overview - PowerPoint PPT Presentation


  • 112 Views
  • Uploaded on

Oracle SQL Developer Data Modeler Overview. David Last, Oracle UK.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Oracle SQL Developer Data Modeler Overview' - stacy-poole


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Oracle sql developer data modeler overview

Oracle SQL Developer Data Modeler Overview

David Last, Oracle UK


The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.


Agenda
Agenda direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Why Model?

  • Oracle SQL Developer Data Modeler Overview

  • Feature Highlights

  • New Features

  • More Information


Why model
Why Model? direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Top Five Reasons to Model

    • Easy to Change

    • Communication Method to Gather Requirements

    • Business Rules Validation

    • Target User Involvement

    • Documentation/Training


Oracle sql developer data modeler overview1
Oracle SQL Developer Data Modeler Overview direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • No cost diagramming and data modeling tool – standalone or within SQL Developer

  • Single tool for different users and functionality

  • Modeling across platforms within one integrated system

  • Business rule and process flow documentationand verification

  • Standards-driven DDL script generation

  • Migration support from other tools


Oracle sql developer data modeler overview2
Oracle SQL Developer Data Modeler Overview direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Technology and Architecture

    • Java based

    • Common IDE Framework

    • Metadata stored in XML Files

  • Database support

    • Oracle 9i, 10g, and Oracle 11g

    • Third-party databases: Microsoft SQL Server, DB2, UDB

  • Platform support

    • Windows

    • Linux

    • Mac OSX


Oracle sql developer data modeler overview3
Oracle SQL Developer Data Modeler Overview direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

Strategy and Analysis

Import Models

Domains

Data Type

DFD

ERD

Multidimensional

Logical

Reporting

Database Design

Physical

Star Schema

Relational

DDL Script

Data Dictionary


Logical modeling
Logical Modeling direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Model entities, attributes, relations and entity type hierarchies

  • Transform logical to many relational and multi-dimensional models

  • Configurable forward and reverse engineering

  • Provide different modeling notations and displays of same model

  • Use subviews to work on subset of model

  • Data Model – Entity Relationship Diagram


Logical modeling1
Logical Modeling direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Model external agents, processes, information flow and information stores

  • Different process types: primitive, composite and transformation

  • Decompose a process into lower level DFDs

  • Depict information flow from one object to another

  • Process Model – Data Flow Diagram


Relational modeling
Relational Modeling direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Model tables, columns and foreign keys

  • Map one logical data model to one or more relational models

  • Configurable forward and reverse engineering

  • Use subviews to work on subset of model


Working with diagrams
Working with Diagrams direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Autoroute vs. Manual mode

  • Context-sensitive windows


Working with objects
Working with Objects direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Properties Window


Forward and reverse engineering
Forward and Reverse Engineering direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Engineering options: General, compare/copy and synchronization

  • Include design glossary and naming standards

  • Transformation

Logical

Relational

Relational

Physical

Physical


Physical modeling
Physical Modeling direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

Relational

  • One relational model for many physical models

  • Documents tablespaces, users, stored procedures

  • Apply properties to many elements at once

  • Supports

    • Oracle9i, Oracle Database 10g and Oracle Database 11g

    • Microsoft SQL Server 2000 and 2005

    • IBM DB2/390 and DB2 LUW

Physical


Custom design rules and transformations
Custom Design Rules and Transformations direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Use scripting engine of choice

  • Create user defined transformation scripts

  • Apply multiple scripts or rules

  • Define Rule Sets

  • Create Libraries


Modeling data types
Modeling Data Types direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Support for SQL99 (Object Relational Modeling)

    • Distinct Types

    • Structured Types

    • Collection Types

  • Used in logical and relational models

  • Included in import

  • Generated in DDL


Multidimensional modeling
Multidimensional Modeling direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Model Cubes, Dimensions, Levels and Hierarchies, Measures and slices

  • Start from ROLAP, XMLA or from scratch

  • Generate Oracle Analytical Workspaces


Importing metadata
Importing Metadata direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Import using direct connections

    • Oracle Database

    • Microsoft SQL Server

    • IBM DB2 and UDB

    • Generic JDBC based dictionary (MySQL, Teradata)

    • Oracle Designer repository

  • File import

    • DDL

    • Domains

    • Other Modeling tools (CA ERwin)

    • Multi-Dimensional (Cube views, Microsoft XMLA)


Export and code generation
Export and Code Generation direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • DDL generation options

    • Design Rules

    • Object selection

    • Drop objects

    • Name Substitution

    • Table scripts

  • Standard database DDL scripts

    • Oracle

    • IBM DB2 and UDB

    • Microsoft SQL Server

  • Reporting Repository export

  • Multi-Dimensional Oracle AW, Cube Views and XMLA


Controlling the design environment
Controlling the Design Environment direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Defaults used during creation, manipulation, generation of all models

  • Naming Standards used during creation and transformation

  • Diagramming properties

  • Preferences


Controlling the design environment1
Controlling the Design Environment direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Administer cross model objects

  • Facilitates common tasks

  • Define abbreviations and glossary words

  • Customize and verify Design rules

  • Compare and merge models

  • Tools Options


Collaborative development overview
Collaborative Development Overview direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

WorkingDirectory

WorkingDirectory

Check out

Open/Modify

Check Out

Commit Changes

Commit Changes

Merge Changes

Open/Modify

Commit Changes

Subversion Repository

Make More Changes

User 1

User 2

Version History

V1

V2

V3

V4


Collaborative development
Collaborative Development direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Use Versioning Navigator to connect to Subversion repository

  • Checking in Design using Data Modeler or External client

  • Multiple users check out designs

  • Pending Changes dialog provides feedback to all users

  • Commit changes to repository

  • Manage conflicts

  • Review/Manage Version History


Reporting options
Reporting Options direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Integrated reporting

    • Generated in RTF, PDF and HTML formats

  • Repository reports

    • Export in Data Modeler

    • Run Data Modeler Reports in SQL Developer

    • Create custom reports


Sql developer data modeler release 3 1
SQL Developer Data Modeler Release 3.1 direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

New Features Overview

  • Synchronization

  • Versioning

  • Query Builder

  • Diagramming Enhancements

  • Reporting Enhancements

  • National Language Support

    • Fully translated into 9 Languages


Synchronization
Synchronization direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • “Easy synchronization"

    • One click synchronization

      between model and dictionary

      • Support for several connections

      • Supports synchronization in both directions

      • List of values/ranges can be extracted from column check constraint

      • Can exclude tracking of column order when tables are compared

      • No need to recreate table as alter statements are generated


Versioning
Versioning direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Version history is available at design and system level

  • Lock and unlock can be done at design, model and subview level

  • Support for branching and merging

    • delayed resolution of merge conflict

    • tree conflicts detected in advance


Query builder
Query Builder direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Convert between ANSI and

    Oracle joins.

  • Graphical Interface support

    • Build complex queries

    • Persist the layout of diagrams

    • Work with objects belonging to

      a specific subview

  • Synchronization of changes in the model with already created views

  • Validation of view definitions created with previous version of Data Modeler


Diagramming enhancements
Diagramming Enhancements direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • Diagrams can display primary, unique and foreign key columns

  • Display labels in Transformation diagrams

  • Setting default colors and fonts

    for Legends


Reporting enhancements
Reporting Enhancements direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • New Reports

    • Structured, collection and distinct types, change requests and measurements

  • Reporting templates can be defined

    • Define report sections to include in generated report

  • Report for objects belonging to specific  subview

  • Reporting Repository

    • Multidimensional, business information, change requests and measurement models


More information
More Information direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions

  • SQL Developer Data Modeler on OTN

    • www.oracle.com/technetwork/developer-tools/datamodeler/

  • Feature Exchange

    • sqldeveloper.oracle.com

  • Forums

    • forums.oracle.com/forums/forum.jspa?forumID=1317

  • Oracle Learning Library

    • www.oracle.com/oll


Q&A direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions


ad