SQL Developer Data Modeling - Northeast Ohio Oracle Users Group
Download
Report
Transcript SQL Developer Data Modeling - Northeast Ohio Oracle Users Group
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