{"id":4314,"date":"2012-02-15T17:07:12","date_gmt":"2012-02-15T22:07:12","guid":{"rendered":"http:\/\/jianmingli.com\/wp\/?p=4314"},"modified":"2013-10-11T15:05:34","modified_gmt":"2013-10-11T20:05:34","slug":"sql-developer-data-modeler","status":"publish","type":"post","link":"https:\/\/jianmingli.com\/wp\/?p=4314","title":{"rendered":"SQL Developer Data Modeler"},"content":{"rendered":"
\n

Contents<\/h2>\n
    \n\t
  1. \n\t\tInstall<\/a>\n\t\t
      \n\t\t\t
    1. \n\t\t\t\tDownload and Unzip<\/a>\n\t\t\t<\/li>\n\t\t\t
    2. \n\t\t\t\tStartup<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
    3. \n\t\tOverview<\/a>\n\t\t
        \n\t\t\t
      1. \n\t\t\t\tDiagrams<\/a>\n\t\t\t<\/li>\n\t\t\t
      2. \n\t\t\t\tModels<\/a>\n\t\t\t<\/li>\n\t\t\t
      3. \n\t\t\t\tUtilities<\/a>\n\t\t\t<\/li>\n\t\t\t
      4. \n\t\t\t\tRelationship Among Model and Diagrams<\/a>\n\t\t\t<\/li>\n\t\t\t
      5. \n\t\t\t\tImport<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
      6. \n\t\tSample Session<\/a>\n\t\t
          \n\t\t\t
        1. \n\t\t\t\tCreate a New Project<\/a>\n\t\t\t<\/li>\n\t\t\t
        2. \n\t\t\t\tImport From Data Dictionary<\/a>\n\t\t\t<\/li>\n\t\t\t
        3. \n\t\t\t\tFormat Diagrams<\/a>\n\t\t\t<\/li>\n\t\t\t
        4. \n\t\t\t\tCreate SubViews<\/a>\n\t\t\t<\/li>\n\t\t\t
        5. \n\t\t\t\tCreate Displays<\/a>\n\t\t\t<\/li>\n\t\t<\/ol>\n\t
        6. \n\t\tReferences<\/a>\n\t<\/li>\n<\/ol>\n<\/ol>\n<\/div>\n
           <\/div>\n

          Install<\/h2><\/span>\n

          Download and Unzip<\/h3><\/span>\n

          * Download SQL Developer Data Modeler from http:\/\/www.oracle.com\/technetwork\/developer-tools\/datamodeler\/downloads\/index.html<\/a>.
          \n* I downloaded Oracle SQL Developer Data Modeler for Windows (This zip does not include a JRE) (97 M) <\/em>
          \n* Extract zip content to a local folder, e.g. C:\\prog<\/em><\/p>\n

          Startup<\/h3><\/span>\n

          * Go to the folder where zip content has been extracted, e.g. C:\\prog\\datamodeler<\/em>
          \n* Double click datamodeler.exe or datamodeler64.exe if your Windows OS supports 64 bits
          \n* Browse to java.exe file<\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * SQL Modeler started<\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          Overview<\/h2><\/span>\n

          Diagrams<\/h3><\/span>\n

          * ER Diagram
          \n* Relational Diagram
          \n* Data Types
          \n* Multidimensional Models
          \n* Data Flow: primitive, composite, transformational tasks<\/p>\n

          Models<\/h3><\/span>\n

          * Domain models
          \n* Physical models
          \n* Business information<\/p>\n

          Utilities<\/h3><\/span>\n

          * Two way engineering between logical and relational models
          \n* Import from various databases
          \n* Export for various databases
          \n* DDL script generation
          \n* Resign rules for verifying standards and completeness
          \n* Name templates, glossary, and abbreviation files for supporting naming standards<\/p>\n

          Relationship Among Model and Diagrams<\/h3><\/span>\n
          \"\"<\/a><\/h6><\/span>\n

          Import<\/h3><\/span>\n

          You can import from various sources:<\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          Sample Session<\/h2><\/span>\n

          Create a New Project<\/h3><\/span>\n

          * In Browser pane, right click Designs <\/em>folder and select New Design<\/em>. A new design model is created with default name such as Untitled_x<\/em> where x is a number such as 1 or 2.
          \n* Right click the newly created model and select Save Design<\/em>. Save the model, for example, as mymodel<\/strong> in a local directory.<\/p>\n

          Import From Data Dictionary<\/h3><\/span>\n

          * Select File > Import > Data Dictionary<\/em>
          \n* Select design model, e.g. mymodel<\/em><\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * Click Add <\/em>button to add a new database connection. Click Test <\/em>button to test the connection.<\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * Click Save <\/em>to save the new connection. Click Connection<\/em> to close the dialog.
          \n* Highlight the newly created database connection and click Next.<\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * Select the schema to import, e.g. HR<\/em>. Click Next<\/em>.<\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * Select the Tables, Views etc. to be imported. Optionally, click the Select All<\/em> icon located at the lower left corner to select all objects.<\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * Click Next <\/em>and Finish<\/em>. Relational_1 diagram is displayed:<\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          Format Diagrams<\/h3><\/span>\n

          * Auto Route: right click diagram and select Auto Route<\/em>
          \nNote: don’t use<\/strong> auto route if you manually formatted the diagram. You manual format will be lost!?<\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * Format: right click an element such as a table and select Format<\/em>. You can set font, foreground, and background colors.<\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * Change view details: right click diagram and select View Details<\/em><\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          Create SubViews<\/h3><\/span>\n

          * Right click Relational_1<\/em> from Browser, or directly on relational diagram and select Create SubView<\/em>.<\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * You can also select the elements to be included in the subview and then right click and select Create SubView<\/em>.<\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          * Subviews are stored in SubViews<\/em> tree node under Relational_1<\/em>
          \n* Right click<\/strong> (not double click!) the subview and then Show Diagram<\/em> to view.<\/p>\n

          \"\"<\/a><\/h6><\/span>\n

          Create Displays<\/h3><\/span>\n

          * Right click on a diagram and select Create Display<\/em> to create a display.
          \n* Display is just an alternative view of a diagram (either main model or subview).
          \n* Display lives only within the context of a diagram<\/p>\n

          References<\/h2><\/span>\n

          * Document Library<\/a>
          \n*           http:\/\/www.oracle.com\/technetwork\/developer-tools\/datamodeler\/overview\/index.html<\/a>
          \n*           Data Modeler User’s Guide (HTML)<\/a>
          \n*           Data Modeler User’s Guide (PDF)<\/a>
          \n*           SQL Developer Documentation<\/a>
          \n* Oracle SQL Developer 2.1 By: Sue Harper <\/p>\n","protected":false},"excerpt":{"rendered":"

          Install Download and Unzip * Download SQL Developer Data Modeler from http:\/\/www.oracle.com\/technetwork\/developer-tools\/datamodeler\/downloads\/index.html. * I downloaded Oracle SQL Developer Data Modeler for Windows (This zip does not include a JRE) (97 M) * Extract zip content to a local folder, e.g. … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[127],"tags":[],"class_list":["post-4314","post","type-post","status-publish","format-standard","hentry","category-sqlmodeler"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8cRUO-17A","_links":{"self":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/4314","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4314"}],"version-history":[{"count":13,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/4314\/revisions"}],"predecessor-version":[{"id":9145,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=\/wp\/v2\/posts\/4314\/revisions\/9145"}],"wp:attachment":[{"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4314"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4314"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jianmingli.com\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4314"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}