Volunteer SpotLight Featured Articles
    Mriley.png

    ODTUG Volunteer Spotlight: Mike Riley
    Read the article

    The latest ODTUG Volunteer Spotlight focuses on Mike Riley. You probably know Mike as the past president of ODTUG (2009-2012) or ODTUG Kscope Conference Chair (2008, 2013-2014). You might even know he was once trapped in an elevator at Oracle OpenWorld 2008 with then-UKOUG President Debra Lilley for two hours until someone from Oracle Support saw her social media plea for help on OTN’s Oracle Mix and called the hotel to rescue them. You might even know Mike through his work as an Oracle ACE. 

    I was amazed to discover Mike had never been the subject of ODTUG’s Volunteer Spotlight before, pretty surprising for a guy who has been at the heart of ODTUG for years. In fact, Mike has overseen the transformation of ODTUG into one of the largest Oracle user groups in the world and expanded the always-super ODTUG Kaleidoscope Conference into the world-best ODTUG Kscope conference we know today. Kscope has grown so successful that it is known as one of the “big six” conferences to Oracle’s product managers and management. 

    Mike was even the original author of the ODTUG Technical Journal Volunteer Spotlight column (what goes around, comes around). 

    Read more about Mike here.


    BookReviewImage.jpg
    JohnKing.png John King, King Training Resources
    Oracle PL/SQL Performance Tuning Tips & Techniques” by Michael Rosenblum and Dr. Paul Dorsey is a book you should read soon. A quote from Oracle’s Bryn Llwellyn in the book’s forward says it all “Every professional PL/SQL programmer should study this book and act upon its teachings.”

     

    Misha and Paul take the scientific route to performance, providing readers the how and why of effective performance. The first chapter sets the tone, showing how performance is an aggregate typically of nine steps from execution of code on the client side, through middleware, to server, and back again to the client. Learn how PL/SQL works from two of the best, whose shared stories of actual issues underline the importance of performance planning and thinking.

    Read more here.


        

    You must be a member of ODTUG to access the featured articles. Log in or click here to become a member of ODTUG.

    dana.png Development Tools at Oracle OpenWorld 2014: A Recap
    Dana Singleterry, Oracle Corporation
    Oracle OpenWorld 2014 is now behind us, and it was filled with information and plans for the present and future presented by Oracle Product Management, developers, and evangelists the world over. This year’s event announced the release of our new design patterns, including the new Oracle Alta UI system, for building modern applications for multichannel delivery. Mobile was also front and center with a key announcement around in-depth integration between Oracle Mobile Application Framework (Oracle MAF) and Oracle Mobile Security Suite. Let’s not forget the cloud, with a focus on developer tooling in the cloud and the empowerment of non-technical users with Oracle Mobile Accelerator.

    Philip.png
    bodo.png
    Where Is My Input Data? How to Find and Convert Input Data into Level 0 Data
    Philip Hulsebosch, Trexco
    Bodo Abenhardt, Vodafone Germany
    If you want to convert an existing Block Storage (BSO) database into Aggregate Storage (ASO), you may find out some of the data in this BSO database has not been loaded at leaf level for all dimensions. You must load data at leaf level in ASO, so you need to have this data. Finding this upper-level entry data in a fully aggregated cube is difficult. This data is aggregated in the dimensions and likely cannot be found manually by drilldown. It will require a technical approach. This article will present you the method to find upper-level input data in a large BSO database and export it to be loaded at Level 0 in an ASO database. It will describe the steps required and the calculation logic applied to BSO.

    KevinM.png Part 2: Making the Case for Leveraging Agile and Continuous Integration in Oracle BI Development
    Kevin McGinley, Red Pill Analytics
    In part 1 of my article, I made the argument that the waterfall methodology is a methodology that we, as BI/DW professionals, blindly follow for BI/DW projects, even though it doesn’t make sense considering today’s technology and business demands. I introduced Continuous Integration and Agile as approaches we should be adopting instead and promised to explore both in parts 2 and 3 of this series. Given a more general lack of familiarity with Continuous Integration (CI) in the BI/DW space, it makes sense to tackle it first.

    WilliamHodges.png Keeping a 'Road from ODTUG' Conversion Experience from Becoming a 'Bumpy Road to Groovy Existence
    William Hodges, The Hackett Group 
    “Wouldn't it be nice if I could find ‘the one’?” Haven't we all said this at one time or another? Having been struck off his PowerShell horse on the way back from ODTUG by an Aultman bolt of lightning, a certain Essbase developer went into seclusion. There, he reflected on what had just happened, saw the light, rejected his automating ways, and set out on a new mission. Against all kinds of opposition and logistical roadblocks, he championed the conversion of a large collection of automation scripts from a Windows platform to a Linux platform, from CMD, esscmd, MaxL, VBScript, and PowerShell to Groovy. This is his story.

    KevinM.png Part 1: Making the Case for Leveraging Agile and Continuous Integration in Oracle BI Development
    Kevin McGinley, Red Pill Analytics 
    Close your eyes. OK, maybe not quite yet. Read the next few sentences; then close your eyes. Once your eyes are closed, imagine every IT project you’ve ever been a part of, whether as an employee of the company owning the project or a consultant contributing your valuable skills toward the successful completion of the project. Wrap your mind around each project, considering its flaws and successes, its challenges and hurdles. Go ahead and close your eyes now, and when you open them again, try to recall the singular thread that weaves through all of the projects you can remember.

    Submit an Article
    Author Guidelines
    Search Archives

     


    Letter from Editor
    Karen Cannell, TH Technology
    As ODTUG opens a new chapter, commencing next quarter, our Journal will be entirely online and released in a distributed format. We will deliver one feature article and one or more of our regular columns right to odtug.com’s Tech Corner on a monthly basis. You will have the opportunity to give online feedback and comment on each article – and you know how we ODTUGgers like to exchange opinions!

    No worries, some things will stay the same—we will keep our same columns, so you can look forward to your favorites each quarter. We will also have greater opportunity and flexibility to bring you more varied content, to keep pace with the ever-growing family of Oracle development tools.
    Karen Cannell

    Our aim is to bring delivery of the ODTUG Technical Journal in line with today’s social media options. These days our members are consuming more information online, and in shorter formats, such as blogs, podcasts, newsfeeds, and tweets, as opposed to formal whitepapers and other printed media. The times, they are a changin’, and ODTUG is keeping up. Join us!




    2601 Iron Gate Drive, Suite 101 | Wilmington, NC 28412 | Phone (855) 853-0491 | odtug@odtug.com | Copyright © 2014