Big Data is growing exponentially, requiring massive-scale infrastructure however, business analytics has shifted from reactive to proactive analysis; this is the era of streaming data (a.k.a. Fast Data). Apache Hadoop is very good for analyzing data at rest but cannot handle streaming data. Big Data analytics needs new Big data frameworks. Apache Spark brings in-memory processing and RDD data abstraction which allow real-time processing of streaming data however its micro batch architecture incurs high latency. Apache Flink brings low latency and could address Spark limitations however it is not as mature and largely adopted as Spark. Apache Beam promotes its portable Beam model across Big data frameworks (Spark, Flink, Dataflow). Tis session presents and overview of the major Big Data frameworks and suggests that DBA should embrace these frameworks and expand their skills as a necessary path to becoming Data Architects.
Kuassi is Director of Product Management at Oracle. He looks after the following product areas (i) Java connectivity to DB (Cloud, on-premises), in-place processing with DB embedded JVM (ii) MicroServices and DB connectivity, and related topics (Data & Tx models, Kubernetes, SAGAs... Read More →
Tuesday March 20, 2018 10:10am - 11:00am PDT
4-Rm 104
Big Data Analytics requires unstructured data (a.k.a. Big Data) but also Master data generally stored in RDBMS tables.
Apache Spark furnishes the Spark SQL interface for querying unstructured data using SQL. This interface provisions the Datasource API with a JDBC interface for accessing relational databases. How to join RDBMS tables with Big data using Spark SQL without moving data over?
This session describes an implementation of the Spark Datasource API and explains the optimizations that (i) allow parallel and direct access to the RDBMS database (with the option of controlling the number of concurrent connections); (ii) introspect the RDBMS table, generate partitions of Spark JDBCRDDs based on the split pattern and rewrite Spark SQL queries into the RDBMS SQL; (iii) use hooks in the JDBC driver for faster type conversions; (iv) push down predicates to the RDBMS, prune partitions based on the where clause to reduce the amount of data returned to the RDBMS.
Kuassi is Director of Product Management at Oracle. He looks after the following product areas (i) Java connectivity to DB (Cloud, on-premises), in-place processing with DB embedded JVM (ii) MicroServices and DB connectivity, and related topics (Data & Tx models, Kubernetes, SAGAs... Read More →
Tuesday March 20, 2018 11:15am - 12:05pm PDT
5-Rm 105
In the Cloud managed Data Warehouse services are still rare. Amazon Red Shift and Snowflake are examples of new contenders in the market place. At Oracle Open World Larry Ellison announced the Oracle Autonomous Data Warehouse Cloud service (ADWC). It shall become available at the turn of the calendar year as a fully managed DWH service, running on Exadata hardware.
sumIT took part in a preview programme in summer and autumn of 2017 and has gained insights and experience with the new service. In this presentation those experiences will be shared with the audience. Key features of the service, like its ease of provisioning, use, and interfacing other systems and clouds will be presented and also demonstrated.
Lessons learned will be told, the services sweet spot and limits be discussed. Moreover, AWDC will be compared to other managed DWH cloud services. This will illustrate the advantages AWDC gives customers, but will also help identify room for improvement in future AWDC versions.
Dr.-Ing. Holger Friedrich is co-founder and CTO of sumIT. sumIT is a Swiss based consulting firm, specialized on Data Warehousing, Business Intelligence, and Big Data projects. Holger holds a Ph.D. in computer science from the Karlsruhe Institute of Technology (KIT). He is a regular... Read More →
Tuesday March 20, 2018 11:15am - 12:05pm PDT
4-Rm 104
This session answers architecture questions related to the overall structure and strategy for an enterprise analytics system. How do we design a data warehouse for analytics purposes? What do we integrate into a central warehouse or maintain in separate data marts? How do we integrate long term storage systems that we need to query only occasionally? Data lakes? Big Data?? What are the tradeoffs with different tools and how much do we invest in custom code? How do we integrate real-time data streaming? What ETL and integration strategies are we going to use? Where and how do we extend our raw data with calculated measures and analytic functions? How do we create a system that has a strong foundation, but can grow and evolve over time? This presentation will draw from real-world data architecture projects that were designed with analytics in mind.
As a senior consultant, I am a veteran Oracle data warehouse architect and a Software Engineer. While I have solid experience working with transactional systems, my specialty has been data warehouse and business intelligence applications. I bring tremendous data warehouse experience... Read More →
Dan Vlamis is President and founder of Vlamis Software Solutions, a boutique consultancy which has led more than 200 Business Analytics implementations for more than 25 years at many of the world’s leading organizations. Recognized by Oracle as an Oracle ACE Director, he consults with Oracle Product Management regularly. Dan covers Oracle Analytics... Read More →
Tuesday March 20, 2018 11:15am - 12:05pm PDT
2-Rm 102
Join us for our lightning round presentations by our sponsors. These are about 4-minute presentations by each sponsor, moving quickly between sponsors. Come have lunch with us! You can also download each of the sponsors' presentations.
Providing Technology Engineering Services, Sales, Business Development, contract negotiations, ERP solutions, software development and IT services to enterprise and technology companies. Also, specializing in software & technology business development in the Silicon Valley and Southern... Read More →
E8 Storage is a pioneer in shared accelerated storage for data-intensive, high-performance applications that drive business revenue. E8 Storage’s affordable, reliable and scalable solution is ideally suited for the most demanding low-latency workloads, including real-time analytics... Read More →
Eighteen years of Information Technology consulting services experience with eight plus years specifically focused on Oracle technologies. Extensive experience in program and project management in data warehousing and business intelligence. Public Sector Contribution Award from the... Read More →
Kirby Lunger is a Partner at Performance Architects, a leading business and technology consulting firm focused on enterprise analytics (analytics, BI and EPM). She maintains over 22 years of experience in the consulting, internet services, and software markets. She is the Co-Chair... Read More →
Steve has been employed with Safe Software as an FMETechnology Expert since 2011. His role is helping customers solve theirdata interoperability challenges with a particular focus on FME Server clients.Steve is also FME Certified in Desktop, Server and as a FME Trainer. Prior tothis... Read More →
We help businesses (big and small) maximize their return on investment for Oracle Business Analytics, Enterprise Performance Management & Big Data. Our recipe for success is our desire to innovate and re-imagine how Oracle EPM and BI solutions are deployed to reduce complexity and... Read More →
Digital Transformation Architect: AI, Machine Learning, Big Data, Iot and Cybersecurity20 years of IT consulting experience for commercial and government clients. Senior architect and project manager helping enterprises migrate streaming analytics to modern cloud-based architectures... Read More →
As partners for more than 17 years, Oracle has relied on HERE Technologies to deliver high quality digital map data and robust location cloud services. Integrating mapping, analytics, geocoding, and routing, our data and location cloud services have helped power Oracle products, including... Read More →
Richard
Solari is a Director in the Deloitte Analytics and Information Management
Practice and currently serves as the Oracle Business Intelligence and Analytics
National Practice Lead. Mr. Solari’s primary
area of focus and expertise is Oracle Data Warehousing, Business... Read More →
Tim Tow is the Founder and President of Applied OLAP and the visionary for the innovative Dodeca product line. He has been working exclusively with Oracle Essbase since 1995, specializing in the Essbase Java API. An Oracle ACE Alumni, Tim blogs on Essbase topics, leads the development... Read More →
Dan Vlamis is President and founder of Vlamis Software Solutions, a boutique consultancy which has led more than 200 Business Analytics implementations for more than 25 years at many of the world’s leading organizations. Recognized by Oracle as an Oracle ACE Director, he consults with Oracle Product Management regularly. Dan covers Oracle Analytics... Read More →
An entrepreneur with experience starting firms and managing them on sound business principles, I am a strong believer in optimism, positive attitude and not accepting any limits. I continually look forward to my next set of challenges, opportunities and successes. Failure is not... Read More →
Tuesday March 20, 2018 12:20pm - 1:10pm PDT
1-Auditorium
With the Oracle Database 18c release, Oracle Spatial and Graph brings new performance and usability features across the board to complement features introduced in Oracle Database 12c Release 2. This release also makes it easy to develop spatial applications in Oracle Cloud. Spatial now supports distributed transactions, making it easy to develop web applications that update spatial data. More geometry types can be converted between SDO_GEOMETRY and JSON formats, and Oracle REST Data Services supports spatial queries. Sharding support (introduced in 12.2) is now extended to spatial tables and indexes. Web services are enhanced to support multiple data sources so that a single web service instance can serve data from different database schemas, and CSW 2.0.2 ISO metadata application profiles are supported. GeoRaster now supports many GDAL functions via external procedures. Learn what’s new with the leading spatial platform that’s fast, cloud-ready, and developer-friendly.
Siva manages the development team for Oracle’s spatial technologies. He is one of the founding members of the development of Spatial technologies in Oracle since the Oracle7 release. He holds numerous patents, has several journal and conference publications, and authored a book... Read More →
Tuesday March 20, 2018 3:35pm - 4:05pm PDT
3-Rm 103
Limited Capacityfull Adding this to your schedule will put you on the waitlist.
Oracle Database 12c now includes property graphs - a powerful feature that goes beyond relational, to analyze relationships in big data, such as finding the most influential people in a social network, discovering patterns of fraud within financial transaction data, or recommending products based on what similar customers are buying. Don’t have the slightest clue on how to get started with and use property graphs? Good news! If you can form a complete sentence (coffee allowed) then you can do this! This hands on lab by Vlamis will show you exactly how to create, load and use property graphs on the Oracle Database. We will cover how to create a property graph using Java or PLSQL, how to load data into a property graph from existing database tables, how to create an in-memory instance of a property graph, how to run algorithms such as page rank against a property graph, how to use PGQL (a sql like language for property graphs) to query a graph and ways to visualize graph data.
In order to complete the hands on lab you will need to bring your own laptop with VNC Viewer installed (https://www.realvnc.com/en/connect/download/viewer/) so you can access the virtual machines we have set up for the lab.
Arthur Dayton is a business analytics and data integration professional who works as a Senior Consultant for Vlamis Software Solutions. He teaches technology fundamentals to students at the University of Nebraska Omaha and also shares technical knowledge on his blog https://helpm... Read More →
VP of Consulting Services, Vlamis Software Solutions, Inc.
Cathye has 23 years of experience working with Oracle Business Intelligence (BI) technologies; 14 of those years have been with Vlamis. Prior to entering the Oracle BI world, Cathye owned her own insurance agency. As VP of Consulting Services, Cathye leads the consulting organization... Read More →
Tuesday March 20, 2018 3:35pm - 5:10pm PDT
6-Bldg 500
Ordnance Survey Ireland (OSi), the Irish national mapping agency, maintains national spatial data sets and creates mapping products for government agencies and the public. Achieving a leadership role in national mapping requires addressing many challenges: dealing with the explosion of 3D terrain data from aerial photos and satellites, needing to automate complex workflow processes, handling 1.2+ petabytes of data holdings including geospatial data with scalability and security, and sharing data widely with the public._x000D_ _x000D_ With the Oracle Spatial and Graph, Database 12c, and Exadata platform, OSi has addressed these challenges. OSi uses Oracle Spatial and Graph point cloud, raster, and linked open data capabilities for solutions in the areas of Cartographic Automation, 3D Solid Geometry, Point Cloud Classification, Visualisation & Dissemination and Geospatial Linked Data. OSi is also looking toward cloud-based solutions using Oracle. Learn about OSi’s innovative geospatial solutions._x000D_ _x000D_
General Manager, Geospatial Services, Ordnance Survey Ireland
Éamonn Clinton is the General Manager, Geospatial Services, Data Governance & Quality and Spatial Strategist with Ordnance Survey Ireland, the Irish national mapping agency. Éamonn has worked in the geospatial industry for over 20 years. He has worked on a large number of public... Read More →
Tuesday March 20, 2018 4:20pm - 4:45pm PDT
3-Rm 103
As early as 2001 Enterprise Data Warehousing (EDW) design patterns like "Corporate Information Factory" (CIF) began to emerge. Theses patterns established EDW as the central focus of reporting. Current BI/DW 1.0 projects still follow these patterns today. Problems in the BI/DW 1.0 methodology have appeared. Increases in data volume, variety and velocity have all created considerable challenges for this legacy architecture. In this presentation we will review the legacy of BI/DW 1.0 and dive into the future BI/DW 2.0 and 3.0 architectures. Taking a close look and advanced staging areas, operational data stores and how those architectures can be used for cloud facilitation in BI/DW 2.0. Additionally, this presentation will drive into the BI/DW 3.0 data tipping point and where various Oracle products fit in these new emerging modern data architectures.
A business and technology consultant with over 20 years of experience in delivering value to organizations by closing the gap between business needs and IT capabilities. I take a hands on approach to delivering technical work, with a strong ability to speak to and gather C-Level requirements... Read More →
Tuesday March 20, 2018 4:20pm - 5:10pm PDT
5-Rm 105
Every 15 minutes the world’s news is captured into the Global Knowledge Graph. The data set contains nearly a trillion sentiment snapshots and more than 1.5 billion location references. Oracle ingested the data set on the Bare Metal Cloud to create a data warehouse. The project was designed to meet the needs of big data users, such as cyber threat and defense intelligence analysts. They require analysis of the connections between people, places, events, content and sentiment embedded in traditional data sources. They also need a pipeline and robust visualizations to filter the data, carve out relevant subsets and save the results to a property graph database for further analysis. This session will describe the challenges, complexities, and technologies used to create a 35TB data warehouse, and filter, visualize, analyze and write results back, with a single click, to the Oracle Spatial and Graph database using Tom Sawyer Perspectives.
With more than 20 years of experience in the software industry, Kevin Madden brings an innovative approach to Tom Sawyer Software. Originally the third software engineer at Tom Sawyer Software, today he plays a strategic role in the direction of the company's server-based products... Read More →
Wednesday March 21, 2018 9:00am - 9:50am PDT
3-Rm 103
Oracle Database recently switched to new annual Release Model with Oracle Database 18c the first annual release in the new model. This session is a unique opportunity to get ahead of the curve and learn what's new in Oracle Database 18c directly from the Oracle Database development team.
Penny Avril is a Vice President in Oracle Server Technology Division, leading product management for Oracle Database. Penny works with release and development management on taking the product from design spec through development to production. Her team runs the customer advisory board... Read More →
Wednesday March 21, 2018 11:10am - 12:00pm PDT
4-Rm 104
This presentation focuses on unlocking the power of Data Science for data-driven decision support. It details the pragmatics of using Machine Learning techniques in OBIEE for actionable BI and Predictive Analytics from a business standpoint. Two industry use cases are presented to illustrate the implementation of the same using OBIEE 12c.
Lakshman Bulusu has around 30 years of US experience as a database developer, database engineer, and database architect using Oracle, MySql, Sqlserver and Vertica across telecom, retail, healthcare, pharma, and insurance industry verticals in both OLAP and OLTP environments.His book... Read More →
Wednesday March 21, 2018 1:00pm - 1:50pm PDT
2-Rm 102
Graph analysis is an effective methodology in data analysis which considers fine-grained relationships between data entities. This session presents an example of anomaly detection using graph analysis on data stored in Oracle Database with Oracle R Enterprise and the OAAgraph package, using a real-world public data set. Specifically, we analyze the public information of medical transactions from CMS (United States Center for Medicare and Medicaid Services) for the year 2012. We load this data set as a graph into Oracle Database, and use the OAAgraph package to apply graph analysis algorithms whose results are be visualized using R's ggplot2 visualization package. Our analysis successfully identifies suspicious records in the data set -- medical providers who perform procedures far from their specialties. We also discuss techniques how to reduce false positive outcomes.
Mark Hornick is the Senior Director of Product Management for the Oracle Machine Learning (OML) family of products. He leads the OML PM team and works closely with Product Development on product strategy, positioning, and evangelization, Mark has over 20 years of experience with integrating... Read More →
Big data is still a trending topic in higher education and other industries. While understanding the importance of big data is critical, most universities are not leveraging the power of small data. Many data warehouse implementations in higher education fail as they only provide reports that do not aid in improving daily business functions. This session will highlight various technologies and strategies in incorporating data and analytics into the institutional culture. Business intelligence is not just getting sophisticated reports but being integrated into the applications that students, faculty, advisors, and staff use daily. Data and analytics should be used to drive processes and provide alerts when interventions are needed. This session will provide an overview of how Valdosta State University have integrated data into the academic and administrative functions of the university, leading to improved insight and value.
IT executive with extensive experience in business intelligence, data analysis, enrollment and retention management. Ability to blend leadership, strategic vision, innovation, and technical expertise to define and deliver a campus-wide vision and strategic plan for all academic and... Read More →
Thursday March 22, 2018 8:45am - 9:35am PDT
4-Rm 104
In this session learn about Oracle's soon to be released prepackaged "SaaS on PaaS" cloud applications called "Adaptive Intelligent Applications for Manufacturing". This product is built directly on top of several Oracle’s PaaS components to collect, store, and analyze massive amounts of Operational Technology (OT) data coming from shopfloor systems such as MES, quality systems, LIMS, Equipment, Test stations and contextualizes this data with Information Technology (IT) data residing in HCM/CRM/SCM/ERP applications in a single consolidated operational data store and analyzed by applying advanced analytics, data mining/data science, and AI techniques to discover key patterns and correlations from historical data related to manufacturing efficiencies and also provide actionable predictive analytics to improve yield, reduce defects, reduce scrap, minimize cycle times, manufacturing costs, and equipment downtime.
Software leader with proven track record of product ideation, execution, and management of cutting edge SaaS solutions that enable business and digital transformation for enterprises. Drive performance through dynamic leadership, strategic planning, process design, product innovation... Read More →
Thursday March 22, 2018 1:55pm - 2:20pm PDT
1-Auditorium
Location and other geographical information is traditionally stored in Oracle databases using specialized data types, such as the SDO_GEOMETRY type. That data type is powerful and flexible, but can be difficult to use. A modern alternative is to use a JSON-based encoding, called GeoJSON instead. GeoJSON is a lightweight format suited to data exchange and transfer, popular for reading and publishing spatial data on the Web, in Big Data, and for the Internet of Things.
This session will explain the way GeoJSON encodes a variety of geographical objects, from simple points to complex multi-polygonal structures. It will also explain how those structures can be indexesd, and how they can be used in spatial analytics, in isolation or in conjunction with classic SDO_GEOMETRY types. Finally we will show how the GeoJSON objects can be displayed on a map.
Albert Godfrind has over 25 years of experience in designing, developing, and deploying IT applications. His interest and enthusiasm for spatial information and geographical information systems started at Oracle when he started using the spatial extensions of the Oracle database in... Read More →
Thursday March 22, 2018 3:40pm - 4:05pm PDT
3-Rm 103
