SQL Developer Data Modeling - Northeast Ohio Oracle Users Group

Report
1
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
What’s New in Oracle SQL
Developer
Jeff Smith
Senior Principal Product Manager
[email protected]
@thatjeffsmith
Legal
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.
3
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Agenda
 Product History
 SQL Developer New Features
 Question/Answer
4
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Oracle SQL Developer Overview
 Database IDE
 3,500,000+ users worldwide
 Windows, OS X, *NIX
 Third Party DB Migrations
 Administer APEX Listener
5
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
SQL Developer Release History

Version 1.1 – 2006

Version 1.2 - 2007
 Version 1.5 - 2008
 Version 2.1 - 2009
 Version 3.0 - 2011
 Version 3.1/3.2 - 2012
 Version 3.2.2 - 2012
Version 4.0 2013 - GA

6
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Support for Other Oracle Database Products
Times Ten
Data Miner
XML DB
Spatial & Graph
7
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
SQL Developer Data Modeling
Strategy and Analysis
Import Models
Data Type
Domains
DFD
ERD
Logical
Multidimensional
Reporting
Database Design
Relational
8
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Star Schema
Physical
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
SQL Developer Release 4.0
9
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
What’s New?
10
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Under The Covers
 Smaller Memory Footprint, faster load times
 Now Requires Java 7 JDK
 Supports Subversion 1.7
 Better Command Line Interface
 Central Framework - SDCLI
 Stores all Feature Commands
11
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Look & Feel
 Float & Clone
Object Editors
 Editor tabs can
be reordered
 ‘Cleaner’
window rendering
12
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Configurable Connection Tree Nodes (hide stuff)
 less scrolling,
searching
 all connections
(for now)
13
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Find DB Object
 Search multiple Schemas
 Search multiple Object Types
 Standard Editor for Results
 full screen, easier browsing
 pin results for later
 Trick: Auto-invoke search on
selected text in editor with ‘Alt+G’
14
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Database Cart
 Multiple Carts
 Before & After Object Scripting
 Before & After INSERT Scripting
 Compare Cart w/DB or Carts
 Invoke DB Copy based on Cart
 Command Line Interface
15
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Reports
 Editor loads faster
 See Report as You Design It
 New chart options
 Command Line Run -> HTML
16
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Reports + Command Line Interface = HTML
17
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
SQL Worksheet
Semantic Analysis Info Tips
 ‘Explode’ * to column names
 Auto-add GROUP BY clauses
 Find missing statement delimiters
 Yes, you CAN disable these!
18
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Temporal Data Type Editors
Calendar pickers
 dates
 timestamps
 intervals
19
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Clickable Error Messages
20
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Explain Plan & Autotrace
Cached Plans vs Explains
21
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Procedure Editor
Navigation Aids
 Package Member Toggles
 ‘Breadcrumbs’
22
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Database Performance
 Enhanced Database Performance Monitoring
 Snapshots
 Baselines and Templates
 Automatic Database Diagnostic
Monitoring (ADDM)
 ASH Report Viewer
 AWR Report Viewer
 Range, Diff, SQL Viewer
 Diagnostic Pack License
23
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
SQL Developer RESTful Services Admin
 UI to manage RESTful Services
 Restful Service Definitions
 Example: www.example.com/employees/<Resource Handler>
 Resource Handlers
HTTP Methods: GET, POST, PUT, DELETE
 REST SQL Worksheet
Tune and Test Query or your PL/SQL
*8890 Creating RESTful APIs with Application Express Listener – Wed 10:15 – Golden Gate C2*
24
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
RESTful Services Administration
*10031 HOL: Developing REST for On-Premises or the Cloud – Wed 5pm – Salon 3 and 4*
25
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
And much, much more!
 Tons of productivity enhancements
 2 Top #10 Exchange Features
implemented
 Color coded connections
 GIT
 Many hundreds of bug fixes
 Oracle Database 12c Support
available in version 3.2
26
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Multitenant in SQL Developer
Plug, Clone, Alter State, and more
 Container Database
management
 Accessed via the
DBA panel
 Available in version
3.2.20.09 and higher
27
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
SQL Translation Framework
Run your non-Oracle apps against Oracle translate SQL on-the-fly
 SQL Translation Framework
– SQL Translation Profile – collection of translated statements
 Each application can have its own profile
– SQL Translator – java engine that translates the SQL
 SQL Developer can install Sybase & SQL Server translators
 SQL Translation Framework Benefits
– Test and Verify application code before production
– Helps define Task List of modifying the application code
– Convert Applications To Oracle Quicker
– Temporary Step before migrating application fully
28
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Database Redaction in Oracle SQL Developer
 Oracle Data Redaction, a part of Oracle
Advanced Security, enables you to mask
(redact) data that is queried by lowprivileged users or applications.
The redaction occurs in real time when
users query the data.
29
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Creating a Redaction Policy
*8891 SQL Developer and Oracle Database 12c - Tues 12 pm – Golden Gate B*
30
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Brand New Today!
31
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Design Redaction into the Model
Data Modeler Release 4.0

Redaction Policy
 Full, Partial, Random, Regular
Expressions
 Define Redaction at Table and
Column Level
 Data Masking Templates
 Transparent Sensitive Data
Protection (TSDP) Policy
Support for 11g and 12c Models
32
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Generate DDL
*8893 Implementing Data Redaction with Data Modeler - Wed 11:45 pm – Golden Gate C2*
33
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
New Features in Data Model 4.0

Support for JDK 1.7
 Faster and Cleaner UI
 Code folding in DDL Preview
 Float your Diagrams
 Comment-only displays
 Multiple Classification Types
34
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Properties at Design Level
 Set Properties at Design Level
 Classification Types
 Format Colors, Fonts, Line Widths
 DDL Migration - Name Substitutions
 Naming Standards
 Increased Flexibility!
35
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Classification Type Options
 Classification Type for a Table
 Fact, Dimension, Temporary,
Summary, Logging
 Add new Types
 Assign a Type to Many Tables
 Customize Color
 Display Classification Name on
Diagram
 Assign multiple Types to a Table
36
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Comments Only
37
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Diagram, PDF Printing Enhancements
38
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
SQL Developer Resources
 SQL Developer on OTN
– www.oracle.com/sqldeveloper
 Feature Exchange
– sqldeveloper.oracle.com
 Forums
– https://forums.oracle.com/forums/forum.jspa?forumID=260
 Oracle Learning Library
– www.oracle.com/oll
39
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template
Graphic Section Divider
40
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Insert Information Protection Policy Classification from Slide 12 of the corporate presentation template

similar documents