SQL on Steroids: BULK Processing
Session Number: 8545
Sub-Categorization: DB Dev
Session Type: Tips, Techniques and Tuning
Primary Presenter: Helen J. Sanders [Assistant Director - Temple University]
Co-Presenter: Kim Berg Hansen [Senior Developer - Trivadis]
Time: Jun 24, 2019 (11:45 AM - 12:45 PM)
Room: 617, Level 6
Speaker Bio: Helen Sanders is a seasoned professional with over 21 years of experience in the IT industry. She worked as a database developer first on an IBM mainframe writing COBOL for several years before her employer, Temple University, moved to an ERP system. It was through her support of Ellucian's Banner product that she became exposed to Oracle, SQL, PL/SQL, and the ODTUG community.
Helen is a graduate of ODTUG's second Leadership Class and was program coordinator for the 2016-2017 class. She obtained a master's degree in educational leadership in 2013 and was promoted to an assistant director for the Student Collaboration Center in the applications support services area at Temple University during the summer of 2015. In the fall of 2018, she began her second master's program in digital innovation in marketing, where she is learning how data can change the world and how to be a disruptor!
Helen is very active in the ODTUG Database community and was on the committee to merge the DBA/development communities into one cohesive unit. She has organized TwitChats for the community, is involved with the community newsletter, and helps manage the community's LinkedIn group. She served on the ODTUG Kscope15, 16, and 17 Abstract Review Committees for the database track as well as for RMOUG (2015, 2016) and GAOUG (2015, 2016). She is the Database track lead for ODTUG Kscope18 and 19.
Helen began public speaking at the Pennsylvania Banner Users Group (PABUG) Conference in November 2015, followed by gigs at ODTUG Kscope16 and Kscope17 to good reviews. In 2016, she served as student track lead for the PABUG annual conference. In October of 2016 she collaborated with Oracle's Jeff Smith, and together they created the first online training session ever offered to PABUG members, after which PABUG created an online learning track and appointed Helen to be the track lead for it. Helen holds board positions with the Network of Women with Careers in Technology (VP) (2015-2017), and the Temple University Alumni Association. Most recently she has started carving out some time to be part of the fabe project—helping technology create a better earth.
Follow Helen on Twitter at @helenjsanders and get updates on what's going on in her world at http://helenjsanders.com.
Technologies or Products Used: Oracle Database; SQL; PL/SQL
Session Summary for Attendees: One thing I have recently mastered is how to speed up PL/SQL jobs using Oracle BULK processing. See a script that I took from an hour run time to under five minutes! I’ll also share tips on how you can transform your processing from "row-by-row, slow-by-slow" to lightning fast! There will be code snippets and a brief visit to the Oracle Dev Gym—where developers can go to learn how to do cool things to BULK up their code!
Be sure to keep your user profile up to date! Click here to update now.