The Data Warrior

Changing the world, one data model at a time. How can I help you?

Archive for the tag “oracle openworld”

The Data Warrior Goes to Oracle Open World 2015 (#OOW15)

Yes boy and girls, it is that time of year again. Time for the BIG show in San Francisco – OOW15

I will as usual, attend, but only for a few days this year (been away from home too much).

My Talk

I will be presenting my session Worst Practices in Data Warehouse Design (UGF9985) on Sunday at 10:00 AM in Moscone South, room 274 (courtesy of ODTUG!).  This will be a quick one as I only have 45 minutes to do a one hour talk. Yikes!

If you will be in SF by Sunday, be sure to come by and say “hi.”

Morning Chi Gung?

As usual, I will try to gather some folks near either Union Square or maybe by Yerba Buena Gardens for a little morning relaxation with some Chi Gung (Qigong) . Most likely around 7 AM for 30 minutes. Probably Saturday, Sunday, and Tuesday, Follow me on twitter @kentgraziano and look for #MorningChiGung #OOW15 for final time and location.

Monday for sure though, I will be doing a shortened session on the beach at the 4th Annual OOW SF Bay Swim around 9:15 AM or so. Nothing like a little chi movement to warm you up before and after jumping in the bay.

The Rest of My Schedule

Much shorter than usual but here is what I plan to see so far:

Session Title Session Code Date Start Time End Time Room
Oracle Database 12c-Data Redaction UGF1513 10/25/2015 8:00 8:45 Moscone West-3011
Oracle Business Intelligence Best Practices: the Bad, the Worse, and the Really Ugly UGF7409 10/25/2015 9:00 9:45 Moscone South-301
Worst Practices in Data Warehouse Design (ME) UGF9985 10/25/2015 10:00 10:45 Moscone South-274
Oracle Database Security: Frustrating the Patient Intruder UGF10016 10/25/2015 11:00 11:45 Moscone South-274
Improving Analytics: Experiences Testing Oracle Database In-Memory 12c Feature UGF9936 10/25/2015 13:30 14:15 Moscone South-303
Fennia Two Years in Production with Oracle Exadata UGF5105 10/25/2015 14:30 15:15 Moscone South-305
Managing the Changes in Database Structures (Heli) UGF6317 10/25/2015 15:30 16:15 Moscone South-306
Oracle OpenWorld Welcome Keynote KEY10818 10/25/2015 17:00 19:00 Moscone North-Hall D
Oracle OpenWorld Monday Keynote Swim The Bay!
KEY10819 10/26/2015 9:00 10:00 Moscone North-Hall D The Dolphin Club
Oracle SQL Developer Tips and Tricks (Jeff Smith) CON8721 10/26/2015 16:00 16:45 Moscone South-304
Database Development for the Cloud and On Premises (Kris Rice) CON8779 10/26/2015 17:15 18:00 Moscone South-304

Other Fun Stuff

Along with the educational sessions is of course the opportunity to network with folks. I expect I will be doing that as much as possible. There is the annual Oracle ACE dinner, and who know what else. I am sure I will find plenty to keep me busy.

Since I arrive early for the Oracle ACE Directors annual briefing at HQ, I know I will be downtown Friday evening and all day Saturday. Drop me a note if you will be there too and want to hang out and see some of the sites and eat some top notch grub.



The Data Warrior

Live from #OTW14: Worst Data Warehouse Design Practices

Back in September at the now annual OakTable world (OTW) at Oracle OpenWorld, I was privileged to give a talk where I ranted a bit about some of the worst data warehouse design mistakes that I have seen.

Well, if you missed out, now you can see that talk thanks to Kyle Hailey who had all the OTW talks videoed. This week, he tweeted that the video was ready for viewing.

So if you missed the talk, or just want to see it again, check it out!


The Oracle Data Warrior

P.S. If you would like to have me do this very fun presentation at your company or meeting, I would be happy to discuss arrangements with you. You know how to find me so drop me a comment, email, tweet, FB, DM, or even call 🙂

It’s almost time! #OOW14 and #OTW14 – the biggest gathering of Oracle experts anywhere

Hi gang!

As you can guess by my lack of recent posts, I have been very busy this fall. Along with client work, home life, and editing a really cool book on SQL Developer Data Modeler, I have also been prepping for my annual pilgrimage to Moscone Center in San Francisco for Oracle Open World and OakTable World 2014.

As usual, there will be much to see, do, and learn at what is arguably the largest (60k+ people) gathering of Oracle users and experts in the world. Expect big news from Oracle Corp, great sessions from Oracle ACEs and ACE Directors, and of course the annual customer appreciation event.

So here is my short list of what to check out this year:

Annual ODTUG Sunday Symposiums:

ODTUG’s best speakers during the week:

OOW Executive Keynotes:

For all the sessions by day, check the main Content Catalog (over 2028 sessions):

OakTable World 2014:

This year I will again have the honor or presenting at OakTable World on Tuesday, September 29. I will give a data warehouse design session in the morning, then do a short TED-style talk over lunch about a Data Vault 2.0 innovation using MD5 hash functions.

If you have not heard of OTW, it is a FREE event co-located with OOW ( It was organized by members of the elite OakTable and is in its third (or fourth?) year. Be sure to stop by and say hi!

As for special events, I plan to participate in the Run/Walk the Bridge on Sunday morning,  the 3rd annual Swim the Bay on Monday and I will again do some Morning Chi Gung with a few friends (follow me on Twitter for where and when).

So there are lots of opportnities to meet up.

See you there!


The Oracle Data Warrior

p.s. Later next week I will be at Oracle HQ at the annual ACE Directors briefing. Watch my Twitter feed for pictures and updates.

Oracle OpenWorld 2013: Recap Part 2

For those that missed this year’s event, here is another little recap complete with links to all the relevant details.

Thanks to the folks at Oracle for giving me permission to re-blog this post! ( I apologize in advance for some of the funky formatting)




  • Major Announcements: The SPARC M5-32 and Oracle SuperCluster M6-32 Oracle’s new systems dramatically redefine the price/performance equation in the high-end server market, offering customers entry-level price/performance, while maintaining extreme performance and the highest levels of availability. SPARC M6-32 servers with up to 32 terabytes of memory and up to 384 processor cores can run entire applications and databases in-memory to deliver unprecedented performance. Oracle SuperCluster M6-32 is Oracle’s fastest and most scalable engineered system and integrates SPARC M6-32 servers with Oracle Exadata Storage Servers optimized for Oracle Database performance. Read the Press Release:
  • Oracle Big Data Appliance Incorporating Big Data into your enterprise can result in opportunities to transform your business, but the growing volume and complexity of big data can also pose a challenge. Through Oracle’s Unified Information Architecture, customers can easily and cost-effectively integrate Hadoop and NoSQL platforms with their data warehousing and business analytics solutions to maximize the value of big data. While Hadoop provides a scalable foundation for Big Data projects, the lack of built-in security has been an obstacle for many enterprises. To meet this need, Oracle has enhanced the Oracle Big Data Appliance to include enterprise-class security capabilities for Hadoop. Oracle is also announcing new versions of Oracle Big Data Connectors and Oracle NoSQL Database, which provide enhanced functionality, performance, and scalability. Read the Press Release:
  • Oracle Exalytics T5-8 Scales Up to Deliver Customers with Analytic Insights: With the ever-increasing volume, scale and scope of business data, organizations need to quickly turn high-velocity data into actionable insights to gain a competitive edge. To extract the maximum value from this very dynamic data, organizations must process data faster and take timely action. Oracle Exalytics In-Memory MachineT5-8, the new engineered system with 4TB of memory per machine, delivers extreme performance for business intelligence (BI) and enterprise performance management (EPM) applications, helping organizations drive better efficiency by speeding answers to complex business scenarios. Read the Press Release:
  • Oracle DB Backup Logging Recovery Appliance Unveiled at OpenWorld 2013 in San Francisco, Oracle DB Backup Logging Recovery Appliance answers the demand for total data protection without the loss of application performance or availability. The new product helps business users prevent data loss, avoid long restore downtimes, and protect against system slowdowns during backups. Read the Press Release Watch Larry Ellison Announces Oracle DBLRA Get the Executive Brief (PDF)
  • Oracle DB In-Memory Option for Oracle DB 12c Discovering meaningful insight from a mountain of information is the core Big Data challenge. The new Oracle Database In-Memory Option for Oracle Database 12c dramatically accelerates database performance, enabling new business insights, real-time decision-making, and much faster online transaction processing response times without changes to existing applications. Using the Oracle Database In-Memory Option, decades of IT investments become immediately more valuable. Read the Press Release:
  • Enhanced In-Memory Applications with New Oracle DB In-Memory Option Speed and agility define today’s global economy. Traditional transactional systems generate incredible amounts of useful data but require batch, manual, or separate system processing to analyze and immediately present data visually for business decisions. Processing power has improved significantly and can speed the performance of business critical applications, but has not been leveraged to generate complex data analysis in real-time to make sound decisions and solve critical business problems. Read the Press Release:
  • Oracle Marketing Cloud: New, Fully Integrated Digital and Social Solution Managing digital marketing and social efforts separately make it difficult for marketers to deliver a compelling and consistent experience at every touch point. To address this challenge, Oracle Marketing Cloud announced further integration between Oracle Eloqua and Oracle Social Relationship Management (SRM) to deliver the industry’s most comprehensive, scalable, and integrated modern marketing solution. The enhanced profiling, social analytics, tracking, publishing, and custom targeting capabilities will help modern marketers better understand, target, engage, convert, and analyze target audiences. Read the Press Release:
  1. New Cloud Services
  • Database as a Service, Java as a Service, and Infrastructure as a Service: Oracle powers the top 10 SaaS providers, thousands of SaaS applications, and many of the world’s private clouds. All of these rely on a robust cloud platform that provides applications with rich functionality with high performance, elasticity, availability and security. To support a wider variety of workloads, Oracle introduced new Oracle Cloud services: Oracle Database as a Service, Oracle Java as a Service, and Oracle Infrastructure as a Service.
  • 10 New Services to Expand the Industry’s Most Comprehensive Cloud Portfolio: As organizations of all sizes move more of their information systems to the cloud, Oracle is expanding the number of Oracle Cloud services to strengthen its position as the industry’s most comprehensive public cloud. Oracle Cloud offers a broad range of modern, functionally rich and integrated services running in a secure, enterprise and standards-based cloud platform. With new Application, Platform, and Infrastructure Services announced today, Oracle is helping customers and partners further capitalize on the power of cloud computing.
  • New Global Cloud Marketplace Gives Partners an Opportunity to Reach Oracle Customers: With the proliferation of cloud, mobile, and social technologies, organizations want easy access to innovative, trusted business applications. To meet this demand from customers and create new opportunities for partners, Oracle has introduced the Oracle Cloud Marketplace. Featuring more than 100 business applications developed by Oracle partners, the Oracle Cloud Marketplace enables Oracle Cloud customers to easily browse, evaluate, and buy trusted business applications. Leveraging Oracle Cloud Platform Services, Oracle partners can quickly build applications, extend, and integrate with Oracle SaaS applications, and publish their applications on the Oracle Cloud Marketplace to reach Oracle customers.
  • Roadmap for Nimbula Director and OpenStack API Integration with Oracle Exalogic Elastic Cloud: The integration of Nimbula Director into Oracle Exalogic Elastic Cloud will enable customers and service providers to deploy an open, standards-based Infrastructure as a Service (IaaS) foundation with proven breakthrough application performance for Java, Oracle Fusion Middleware, and Oracle Applications. This highly scalable, self-healing and resilient cloud infrastructure will scale from a single Oracle Exalogic rack to thousands of virtual machines and many racks. Leveraging OpenStack and other open industry standards, Oracle Exalogic will deliver a high performance cloud solution that more seamlessly integrates into customers’ existing data centers.
  • Oracle Simplifies Enterprise Mobile Application Development with Mobile Platform in the Cloud: As business demands have increased and the workforce has become more mobile, the need for enterprises to ensure users are connected via any device to their enterprise applications, at any time has become more critical. Oracle’s Mobile Platform addresses this challenge by simplifying application development and allowing developers to securely create and deliver more compelling user experiences. By simplifying this process, enterprises can maximize IT investments and lower application development costs
  • Oracle Billing and Revenue Management Cloud Service Helps Enterprises Deliver and Monetize Innovative New Product Offerings and Capture Recurring Revenue Streams: Oracle unveiled Oracle Billing and Revenue Management Cloud Service to provide enterprises with a robust and highly scalable billing solution to capture recurring revenues from new digital services. This advanced cloud billing service is suited for multiple industries including financial services, media, and communications; and offers sophisticated subscription management and rating using any combination of measurable metrics including usage, time of day, length of use, delivery method, device, medium, volume, and the like
  • Oracle Exalytics Enables Customers Worldwide to Quickly Uncover Business Insights: Organizations that derive actionable, real-time insights from unified business data can capitalize on innovation and efficiencies that deliver a competitive edge. Built using industry-standard hardware, market-leading business intelligence software and in-memory database technology, Oracle Exalytics In-Memory Machine is an engineered system that delivers answers to business questions with unmatched speed, intelligence and simplicity. Customers around the world continue to rapidly adopt Oracle Exalytics to uncover their business answers, faster.
  • Oracle Empowers Modern Workforce with Cutting Edge Mobile Applications Across Entire Enterprise Application Portfolio: Organizations across all industries are increasingly looking for robust and powerful applications that are tailored to mobile devices and can provide their people with anywhere, anytime access to enterprise information. To give the mobile workforce access to mission- critical information at their fingertips, Oracle has developed a wide range of cutting-edge mobile capabilities. By giving organizations a huge choice of out-of-the-box mobile applications, as well as the option of leveraging Oracle’s Mobile platform to develop their own mobile applications, Oracle is empowering the mobile workforce for organizations across the world.
  • Oracle Achieves New World Record with SPECjEnterprise2010 Benchmark in Virtualized Environment: Further demonstrating extreme performance, Oracle WebLogic Server and Oracle Database running virtualized on a single Oracle SPARC T5-8 server have achieved a new world record result. The SPECjEnterprise2010 benchmark beats IBM’s Power7+ benchmark, also running on a single virtualized server.
  • Oracle HCM Cloud and Oracle Talent Management Cloud Updates Advance Its Vision for the Future of Work: To help manage the complex and evolving role of HR, businesses are turning to modern HR technologies as a way to develop an efficient and productive workforce that positively impacts the bottom line. Oracle announced significant enhancements to the world’s most complete cloud-enabled HCM solution including core HR, benefits, payroll, recruiting, performance management, and learning. Updates to Oracle Human Capital Management (HCM) Cloud and Oracle Talent Management Cloud support the changing workplace by delivering a more interactive, social and mobile employee experience across our global workforce and talent solutions for global HR, workforce rewards and optimization, recruiting, talent management, performance management, succession planning, and learning management.


General Availability of JDE Release 9.1 Update 2

  • Featuring innovative solutions that focus on Mobility, Industry, and User Productivity
  • New smartphone and tablet applications deliver role based solutions to meet the needs of mobile users
  • Update 2 continues to deliver many enhancements that provide deep vertical industry solutions focused on manufacturing and distribution, consumer goods, projects and service, and asset intensive industries
  • Usability and productivity enhancements are found throughout the applications and business processes such as new capabilities to support automation of the voucher match process

JDE Release 9.1 Update 2 Enhancements

  • Mobile Service Time Entry
  • Speed Case Entry Tablet application
  • Warehouse Management Tablet application
  • Warehouse Management One View Reporting
  • Real Estate Management Unit Attributes
  • Health and Safety Incident Management – previously announced
  • Automated Inventory to G/L Reconciliation
  • One View drill back capabilities to EnterpriseOne Applications

Oracle Product Catalog for JDE

  • Includes all enhancements for JDE. Dynamic, online search tool that enables you to obtain release net change information
  • You can customize the search by release, product, feature, any word, or compare changes between releases
  • You can export the output to csv, email, html, pdf, or rtf formats
  • Access the product catalog from the link:

Oracle Technical Catalog

  • Online search tool across releases. You can search by release, functional product areas, object type and system codes, or compare changes between releases
  • Oracle Technical Catalog replaces the JD Edwards Applications Programmer’s Guide as the single source to find technical changes for the JD Edwards products
  • The Applications Programmer’s Guide is now obsolete and will no longer be published. Access the Oracle Technical Catalog from either of the following links:


– site by clicking the Resources button

Other JDE Information Resources


  • JDE Upgrade Resources


  • 9.1 Update 2 application enhancement details


  • JDE Customer Success Videos



WebCenter Content

  • New User Interface
    • Simple & Fast
  1. Single Page App – faster then current UI
  2. New Document Library views
  3. Type-Ahead search & filtering, integrated viewers
  • Compelling
  1. Provides the best capabilities in the industry
  2. Modeled after consumer web design
  • Architectural Improvements
  1. Detached UI app in front of Content Server
  2. New Enterprise Libraries
  • Mobile
    • Supports B.Y.O.D. Initiatives
    • Knowledge-worker focused apps
    • iOS/Android apps
    • Automated content synchronization
    • Supports business process solutions
  • Automated Capture and Forms Recognition
    • What’s New
  1. Web-based scan/index/admin user interface
  2. Improved data recognition and extraction engine (OCR, handprint and table extraction)
  • Benefits
  1. Standard deployment, administration and language support model
  2. Improved cross-browser support
  3. Simplified support for distributed capture of documents into WebCenter Content

Let’s Review #OOW13 and #OTW13 in Pictures

Yes I have been derelict in my duty and not posted about the sessions I attended at Oracle OpenWorld (#OOW13) and OakTable World (#OTW).

Well here are the high points with pictures!


Monday started off with the now annual Swim the Bay (so I missed the keynote). If you have Facebook, you can see pictures from the event here.

Most of the day I then spent at the alternate conference, OakTable World (#OTW13) seeing a few talk and giving one myself.

My good friend from Denver, Tim Gorman gave a nice talk about all the data compression options available in Oracle.

Tim Gorman: Oracle Compression Options

Tim Gorman: Oracle Compression Options

Next was a great session from the well known blogger and author Fabian Pascal. I have been reading his work for years but this was the first time I got to hear him speak in person. As with his writing, the talk was both intellectually stimulating and challenging!

Fabian Pascal: The Last Null

Fabian Pascal: The Last Null

It really is quite a debate in the database world about the meaning and use of NULL in an RDBMS. Fabian has a proposal on how we can (and should) represent data in a way where there will never be NULL attributes.

After a some scheduling issues. later in the day, I did my presentation on using Data Vault Modeling for Agile Data Warehouse Modeling. The room I got had a huge wall for me to project my session on. Definitely the biggest screen ever for one of my talks.

Biggest screen ever for me and my data vault presentation.

Biggest screen ever for me and my data vault presentation.


Started the morning with a few friends doing morning Chi Gung in Union Square, then followed by getting a quick survey of the exhibit hall in Moscone South and a trip to the Demo grounds.

The throng descends into the depths of Moscone West to hunt the exhibit hall for goodies.

The throng descends into the depths of Moscone West to hunt the exhibit hall for goodies.

The hall was of course HUGE as usual so some of the vendors who were tucked in back got creative on getting the foot traffic to come their way.

A clever gimmick one vendor did to get traffic to their booth in the gigantic hall

A clever gimmick one vendor did to get traffic to their booth in the gigantic hall

For sessions, I attend a road map session on Oracle’s Big Data strategy given by my friend JP Dijcks.

JP talks all things Big Data

JP talks all things Big Data

Mostly he painted a picture of the issues with figuring out how to collect and put all that data to real work. Of course Oracle has a ton of products to offer to help solve the problem.

How to shrink the gap between getting big data and actually using it!

How to shrink the gap between getting big data and actually using it!

Next up I attended Jeff Smith’s session on SQL Developer 4.0 and got to learn that there was a data mining extension available for the tool that makes doing some advanced analytics a lot easier.

Definition for Data Mining. An extension for Data Mining is available for SQL Developer.

Definition for Data Mining. An extension for Data Mining is available for SQL Developer.

Next on my agenda was the Cloud keynote with Microsoft. I wrote about that here.

Finally for the day, a late presentation by Maria Colgan and Jonathan Lewis giving us their top tuning tips in what they called the SQL Tuning Bootcamp.

Optimizer tips from a pro Jonathan Lewis. I am sure it means something to someone out there!

Optimizer tips from a pro Jonathan Lewis. I am sure it means something to someone out there!

As always with these type session, there was a ton of useful information that makes my brain hurt. I have to keep reviewing  my notes to make sure I can use at least 10% of what they taught.


This was mostly a work day for me at a client site. And a late lunch to see the final race of the America’s Cup.

In case you have been under a rock since last week, Team USA won! It was great to actually be there on Pier 27 during the final race. Not a great vantage point overall but with the big screen to watch and then seeing the boats right after they finished, it was worth the walk.

After the race and a little more data model work at my client’s office, I walked back to the conference to see a final session (for me) given by Gwen Shapira about using solid state disks with Exadata.

I really did not know much about SSDs before this session but feel really educated now. I actually had no idea that SSD and FLASH drives or FLASH memory were the same thing. Guess I was behind on the hardware buzzwords.

Gwen and Mark on Solid State Disk AKA Flash

Gwen and Mark on Solid State Disk AKA Flash

Then it was off to the annual blogger meetup then dinner on the town with friends at The Stinking Rose (thanks Tim!).

I decided to skip the appreciation event this year and take it easy, have a nice dinner, then pack up to head home. Thursday it was breakfast at Lori’s Diner then off to the airport and back home.

As a reminder if you want to see what the buzz was at the events, just check out the hashtags #OOW13 and #OTW13 on twitter (if you had a big data machine you might even be able to generate some insight from those feeds).

Well that’s a wrap for this years big show.

Next up, I will be speaking at the upcoming ECO conference in North Carolina. Should be fun.



P.S. If you want to see my OTW presentation, you can find them on Slideshare.

P.P.S. For another great review of OOW13 check out this post by my friend from Turkey, Gurcan. See if you can find my unlabeled cameo in the post.

Post Navigation

%d bloggers like this: