2015 Fall General Meeting – Presentations
2015 Fall General Meeting – Presentations
September 24, 2015 Sponsored by EMC and Meta7
This presentation will discuss how the Oracle Database can talk to Hadoop and other big data sources via SQL. It will explain the technical components and how data processing occurs. Specific topics to be covered include:
- How to access data on Hadoop through Oracle SQL
- Where data processing occurs
- What needs to be configured on the Oracle database
- Redacting data which resides on Hadoop via Oracle SQL
Brian Macdonald is a Distinguished Sales Consultant and certified Oracle Enterprise Architect focused on Big Data and Analytic platforms with Oracle. He is a co-author of the Oracle Big Data Handbook (2013, Oracle Press) Brian has over 20 years of experience creating architectures and implementing analytic platforms to address a wide range of customer needs including Data Warehousing, Business Intelligence, OLAP, Hadoop, Master Data Management and ETL technologies. Brian has been focused on Big Data technologies for the last several years showing customers how to improve existing applications by providing innovative solutions using these new technologies. Prior to Oracle, Brian worked for Information Resources Inc. implementing OLAP and data warehouse applications to perform complex mathematical algorithms for loan portfolio management. Brian enjoys using analytic techniques
to analyze a wide range of sporting statistics.
DBA TRACK: Latches Demystified
DBAs need to understand latches, especially when the database suffers performance issues because of problems caused by latches. This session will explain, in simple terms, how latches work, how to identify and drill down to them, and so on. All will be explained using live examples. Most important, attendees will learn how to resolve problems related to latches.
Arup Nanda has been an Oracle DBA for over 20 years with experience spanning all aspects from Modeling to performance tuning and Exadata. He speaks frequently, has authored about 300 articles, co-authored 5 books, blogs at arup.blogspot.com and mentors new and seasoned DBAs. He won Oracle’s DBA of the Year in 2003, Enterprise Architect of the Year in 2012, is an ACE Director and a member of Oak Table Network.
Thinking about Big Data and Hadoop involves all of the technology components and scripting languages that make up the system. Rather than solving a business problem, it becomes a technology challenge. Oracle Big Data Discovery (BDD) is a one-of-a-kind Hadoop visualization tool that allows easy access to the data stored in big data infrastructure. Unlike other tools, it not only provides rich visualization but processing capabilities too. This presentation will explain how BDD works and how it can provide better and faster value in the hands of analysts
without having to write a single line of code to process the big data.
Wilfrido Solano has over 20 years of experience with multiple Oracle technologies and services, starting with Oracle databases and moving on to implement complex Oracle ERP systems for Fortune 500 companies including BI, Identity Management and Federation. Wilfrido graduated from the Slovak University of Technology with a Master’s Degree in Computer Science.
Kshitij Kumar heads the Apps Associates Office of Technology based in the Boston area headquarters. He is responsible for evaluating, driving and facilitating innovation across technologies that are aligned with overall business strategy. Kshitij has over 15 years of industry experience with a deep technical background in data warehousing and database technologies. Kshitij holds a Master’s Degree in Management Information systems (MIS) from Northeastern University, Boston, MA.
DBA TRACK: The DBA and the Long Game – Seeing (and Moving) into the Future!’ (Paper); The DBA and the Long Game – Seeing (and Moving) into the Future!’ (Presentation)
Companies today ‘breathe’ data, and it is one of the most important assets of any business. The DBA stands at a critical juncture as both guardian and gatekeeper of this lifeblood. As gatekeeper, the DBA right in the middle of business processes, end users and technology, has an often under-appreciated potential as enabler and information hub with what we see as opportunity to lead beyond the defined parameters of their role. This presentation discusses this importance of how a DBA needs to transform over time by incorporating the traits and virtues of a leader. DBAs can
positively impact their organizations as well as mapping out a more fulfilling path of contribution in their core role and opening themselves out to new opportunities by progressing into leadership roles.
Ziaul H. Mannan is currently Database Architect for Yale New Haven Health System (YNHH), based in New Haven Connecticut. Zia joined YNHH in 2002, prior to that; he worked in Bangladesh, New Zealand and Australia. As a database specialist with over 18 years of experience, Zia enjoys designing and architecting systems in fast-paced 24×7 environments. As database architect, he oversaw development of critical clinical systems at Yale School of Medicine, Yale New Haven Health System and Yale Medical Group. He continues to be involved in projects centered on clinical innovation and breakthroughs within these institutions. Clearly with emersion of big data, majority of his projects these days are around data analytics, data warehousing and data interchange.
DEVELOPER TRACK: Data-Centric Security Key to Cloud and Digital Business
The rapid rise of cloud databases, storage and applications has led to unease among adopters over data security. Whether it is data stored in a public, private, or hybrid cloud, or used in third party SaaS applications, companies have good reason to be concerned. In order to realize the benefits promised by these new ways of doing business, a datacentric strategy is needed in order to protect the sensitive data flowing through these digital business systems. This presentation focuses on practical advice on what to look for in cloud service providers and includes a review of the
technologies and architectures available to protect sensitive data in the cloud, both on- and offsite. Through real life use cases, Ulf will discuss solutions to some of the most common issues of usability, database indexing, database searches, separation of duties, key management, tokenization, compliance, privacy and security in the cloud environment.
Ulf Mattsson created the innovative architecture of the Protegrity database security technology. Prior to joining Protegrity, he worked for 20 years at IBM for with databases and holds more than 20 patents. Leading journals and professions magazines, including IEEE Xplore, DB2 Magazine and Oracle Journals, have published more than 100 of Ulf’s in-depth professional articles and papers. Ulf is a frequent presenter at leading security and database conferences in US, Europe and ASIA, and leads tutorials at international Oracle conferences.
AWR analysis is difficult and complex. Many statistics are presented that are often contradictory or confusing. This presentation discusses ten performance robbing findings that you may miss which can be significant sources of performance issues in your database. Fixes as well as issues will be explained.
Mike Ault is a frequent presenter at Oracle events. Mike has worked with Oracle since 1990 and has written or cowritten over 25 Oracle related books. Mike is the Oracle FlashSystem Consulting Manager for IBM.
DEVELOPER TRACK: Creating and Working with JSON in the Oracle Database
conditions in the SQL engine to query JSON data – even joining it to relational data. Best of all, these features can be used along with the many relational features from Oracle, including transactions and indexing. This presentation will describe JSON and explain how to generate it from relational data, and how to work with it in the Oracle Database.
DBA TRACK: oRCAle World: Root Cause Analysis
Oracle Database unavailability is often not the result of a database failure, which makes finding the original cause difficult for DBAs who are not trained in storage, networking, and DNS issues. Root cause analysis (RCA) is about finding the underlying issue that caused an Oracle database to crash or be unresponsive. Quite often events that look like database problems are, in fact, the result of underlying issues with storage, network, and other parts of the stack. This presentation will use real-world case studies to show how to troubleshoot and identify some of the most
common causes of database problems where the database was an innocent bystander. Real-world examples from recent years will be used to demonstrate how to get past misdirection in alert log messages to ferret out the real cause. This presentation uses real-world examples to show how to dig down past the alert, listener, and clusterware logs to find the root cause of what appear, at first, to be database issues.
Oracle ACE Director Daniel Morgan in addition to being the Morgan behind the MorgansLibrary.org website and his teaching activities has an active consulting practice diagnosing the root causes of performance and stability issues a large percentage of which are not the result of an in-database failure.
This presentation will describe various tips and tricks to get the most from your Oracle licensing, including how to manage the licenses, and how to virtualize to reduce expenses. From database to applications, this presentation will cover the most common ways to reduce what you pay such as how you can use virtualization to double dip on database licenses. Erik and Erica will discuss new ways to free up licenses and to be more efficient with what you have.
Erik Benner is a published author and an Enterprise Architect with the Mythics Enterprise Architecture & Technology Solutions Group. He is focused on architecting solutions that meet the customer’s business and technical needs. Erik has worked with Oracle and Sun Systems since the mid-1990’s, and is experienced with most of the core Oracle technologies.
Erica Meinke manages the license migration team for Mythics. While at Oracle, she built the Oracle process for license migrations.