Posts

Showing posts from December, 2014

Analytical SQL scripts now on Github

Image
After this year’s OpenWorld I ran a 1-day workshop on analytical SQL for our Data Warehouse and Big Data Global Leaders  customers. This was part of the Global Leaders ‘Days with Development' programme. We had a pack room at the Oracle Conference Center and I was very lucky to have Stew Ashton, Technical Architect, BNP Paribas , Dr. Holger Friedrich, CTO at sumIT AG and Joerg Otto, Head of DB Engineering, IDS GmbH co-present with me and have them explain how they were using analytical SQL in their projects.  The workshop covered the following topics: Analytic SQL concepts and foundations Analytic functions for reporting Analytic functions for aggregation More advanced and new 12c features: Pattern Matching SQL Model clause For the workshop I created a comprehensive slide deck ( I will post the presentation shortly on our OTN home page ) which included code samples and explain plans to highlight the key benefits of using our analytical SQL features and functions. The grea

Part 5: X-Charging for Sandboxes

Image
This is the next part in my on-going series of posts on the topic of how to successfully manage sandboxes within an Oracle data warehouse environment. In  Part 1  I provided an overview of sandboxing (key characteristics, deployment models) and introduced the concept of a lifecycle called BOX’D ( B uild,  O bserve,  X -Charge and  D rop). In  Part 2  I briefly explored the key differences between data marts and sandboxes.  Part 3  explored the  B uild-phase of our lifecycle. Part 4  explored the O bserver-phase of our lifecycle so we have now arrived at the X -Charge part of our model. To manage the chargeback process for our sandbox environment we are going to use the new Enterprise Manager 12c Cloud Management pack, for more information visit the EM home page on OTN . Why charge for your providing sandbox services? The simple answer is that placing a price or cost on a service ensures that the resources are used wisely. If a project team incurred zero costs for their database envir