17th January 2012
“The Claridges”, New Delhi
Today I happen to attend another OTN(Oracle Technology Network) – Developer Day Event. This time the event was held in Hotel “The Claridges”, New Delhi.
For those of who are not aware of OTN
What is OTN?
Oracle Technology Network is the world’s largest community of application developers, database admins, system admins/developers, and architects using industry-standard technologies in combination with Oracle products.
Millions of members collaborate online to share real-world expertise and best practices about how to best design, build, deploy, manage and optimize applications. OTN is also a provider of free developer workshops across the globe, as well as a sponsor of third-party conferences, user group meetings, and events.
How to register for the event?
OTN events happen round the year at different venues across the globe. All Oracle Certified Professional, who have registered at Oracle website (http://events.oracle.com) may receive the email invite at their email with which they have registered (Usually the SSO id)
The nomination/invite for this event is sent from Oracle. After the invite is received the candidate has to register for the event at Oracle website or the link mentioned in the mail. Oracle confirms the registration on the basis of the role of the Oracle Professional and seats available for the event.
On successful confirmation candidate should receive an email at their email id.
About the Event
The event kicked-off by filling up registration form and distribution of badge and agenda followed by breakfast.
|09:30 a.m. – 10:00 a.m.||Welcome and opening remarks|
|10:00 a.m. – 10:45 a.m.||Keynote: What’s New In Oracle Application Development|
|10:45 a.m. – 11:30 a.m.||Migrating from non-Oracle Databases to Oracle Database with Oracle SQL Developer|
|11:30 a.m. – 11:45 a.m.||Tea/coffee Break|
|11:45 a.m. – 12:45 p.m.||Updating Your Database Design with Oracle SQL Developer Data Modeler|
|12:45 p.m. – 01:30 p.m.||Lunch Break|
|1:30 p.m. – 2:15 p.m.||Data Subsetting and Masking: Advanced Techniques for A Secure Test Data Management|
|2:15 p.m. – 3:00 p.m.||Worry-Free Application Upgrade with the Change Management Capabilities in Oracle Database Lifecycle Management Pack|
|3:00 p.m. – 3:45 p.m.||Big Data – Are You Ready?|
Session 1: Keynote: What’s New In Oracle Application Development
This was the first session and focused on new features and enhancements in various oracle tools and products viz. Oracle SQL Developer 3.1, Apex 4.1, Oracle PL/SQL Result Cache, Times Ten in-memory Database Cache, Oracle 11g,
In the interest of the time last few topics were discussed only in brief.
Session 2: Migrating from non-Oracle Databases to Oracle Database with Oracle SQL Developer
This session showcased the migration feature of the SQL Developer tool shipped by Oracle. It discussed various kinds of migrations:
a) Windows to Linux migration
b) Sybase to Oracle 11g
c) VB to Java
d) MS SQL Server to Oracle 11g
e) MS Access to Apex
f) Teradata to Exadata
All this migration are done in 5 stages from 3rd party to Oracle. The 5 stages are:
Connect -> Capture -> Convert -> Generate -> Data Move
The Migration can be done online as well as offline.
Databases supported are:
2. MS SQL Server
3. MS Access
4. MySQL (3.x, 4.x, 5.x)
5. IBM DB2 UDB(8 & 9)
6. Teradata (12,13)
The presenter with help of video demonstrated how drivers to different databases can be added to SQL Developer and configured.
Interesting URLs shared at the end: http://www.googlefight.com
Session 3: Updating Your Database Design with Oracle SQL Developer Data Modeler
This session was primarily of interest for the Database Architects and who are involved in designing and modelling of the database. It discussed three kinds of Models: Logical, Physical and Relational.
It also discussed Top Down Model (Business Info to Physical Model) and Bottom up Model (Reverse Engineer DB, Revise/modified model and Generate the modified DDL)
Interesting Visits: http://www.oracle.com/goto/oll (Oracle Learning Library link for more videos and tutorials on Data Modeler tool by Oracle)
Session 4: Data Subsetting and Masking: Advanced Techniques for A Secure Test Data Management
This session showed how production data can be made available on non-production environment like Development, UAT and Staging. Sensitive data can be masked and made available to non-production environment. Types of masking discussed were:
a) Compound Masking
b) Condition Masking
c) SQL expression Masking
d) Key based Reversible Masking
Intersting URLs: http://www.oracle.com/goto/oll (Oracle Learning Library)
Session 5: Worry-Free Application Upgrade with the Change Management Capabilities in Oracle Database Lifecycle Management Pack
The session showcased the features of Database Lifecycle Management Pack:
1. Discoverer (Auto-Discoverer – new in 12c)
2. DB Provisioning
3. Patch Management
4. Database Upgrade
5. Change Management
6. Dictionary Baseline
7. DBMS_COMPARISION package (new in 12c)
8. Configuration Management
9. Drift Management (Cell to Cell, RAC to RAC and Intance to Instance)
Session 6: Big Data – Are You Ready?
Data is classified on basis of Volume, Velocity, Variety and Value.
This session stressed on Hadoop architecture, Oracle Exadata, Exalogic and Exalytics with help of following video
Overall the event was very informative and gave first hand info on latest technologies in Oracle 11g and Oracle Enterprise Manager 12c from developer and DBA perspective. I have tried to highlight most of the features showcased in the event.
Hope you find it useful!