Big Data & Data Warehousing

Kscope17: Cloud and On-Premises - Where Big Data Lives!

The Kscope17 conference will be home to the best presentations on Big Data and Data Warehousing. As we continue to rapidly scale technologies across devices, the digital landscape further meshes with real world metrics. This creates a massive amount of data – BIG Data - that needs a home and needs to be warehoused.   

Data Integration:

Learn all the latest performance tuning tips and tricks using Oracle Data Integrator, GoldenGate, Hadoop, Kafka, Kerberos, and other Big Data tools to move and transform data for applications and data warehousing.

Data Modeling:

Design agile dimensional data vault models for a data warehouse using data modeling tools such as SQL Developer Data Modeler to build a virtualized ODS.

Data Architecture:

Dive into Big Data solution architecture and learn how to build a data and analytics platform. Learn how to pick the right data store and flow for the right purpose.

Check out the presentations listed below.



Kafka, Data Streaming, and Analytic Microservices
Stewart Bryson , Red Pill Analytics
When: Jun 26, 2017, Monday Session 2 , 11:45 am - 12:45 pm
Room: Magnolia
Topic: Data Warehousing & Big Data - Subtopic: Data Architecture

While traditional data warehouses excel at sourcing data from enterprise applications, they usually fail at handling the volume, velocity, and variety of data for modern analytics applications relying on big and fast data. Instead of modeling these data sources into a system that doesn't fit, let's apply a new software design pattern to analytics: microservices. Microservices are small, independent applications – building blocks that provide only a distinct subset of functionality – that can be stacked together to build an end-to-end platform.

In this presentation, we'll explore using Apache Kafka and the Confluent Platform 3.0 as the data streaming hub for ingesting data bound for downstream analytic applications: an enterprise data warehouse, a Hadoop cluster for batch processing, and lightweight, purpose-built microservices in the cloud or on-premise. Experience the next generation of analytic platforms.

Back to Top
Architecture Live: Designing an Analytics Platform for the Big Data Era
Jean-Pierre Dijcks , Oracle Corporation
Co-presenter(s): Stewart Bryson, Red Pill Analytics
When: Jun 26, 2017, Monday Session 1 , 10:30 am - 11:30 am
Room: Magnolia
Topic: Data Warehousing & Big Data - Subtopic: Data Architecture

Don't miss the Architecture Live experience! In this interactive session, you'll witness two industry experts digitally illustrating data-driven architectures live, with input and feedback from the audience.

Kafka, Lambda, and Streaming Analytics will be all covered. We’ll tell you what these words mean and more importantly how they affect the choices we make building an enterprise architecture. With the Oracle Information Management Reference Architecture as the backdrop, we'll clarify and delineate the different components involved in delivering big data, fast data, and all the gray area in between. The Architecture Live experience will be fun and different, and we'll all learn something along the way.

Back to Top
Things Every Oracle DBA Needs to Know About the Hadoop Ecosystem
Zohar Elkayam , Brillix-DBAces
When: Jun 27, 2017, Tuesday Session 9, 3:30 pm - 4:30 pm
Room: Magnolia
Topic: Data Warehousing & Big Data - Subtopic: Other Data Warehousing and Big Data

Big data is one of the biggest buzzwords in today's market. Terms such as Hadoop, HDFS, YARN, Sqoop, and non-structured data have been scaring DBAs since 2010, but where does the DBA team really fit in?

In this session, we will discuss everything database administrators and database developers need to know about big data. We will demystify the Hadoop ecosystem and explore the different components. We will learn how HDFS and MapReduce are changing the data world and where traditional databases fit into the grand scheme of things. We will also talk about why DBAs are the perfect candidates to transition into big data and Hadoop professionals and experts.

Back to Top
Analytic Views: A New Type of Database View for BI and Data Warehousing
William Endress , Oracle Corporation
When: Jun 28, 2017, Wednesday Session 15 , 3:00 pm - 4:00 pm
Room: Magnolia
Topic: Data Warehousing & Big Data - Subtopic: Data Modeling

Analytic views are a new type of view in Oracle Database 12c Release 2 that organize data for simplified access via SQL, extend data sets with aggregate data and measure calculations, and provide a rich metadata layer to support BI applications. In this session, learn how analytic views embed joins and aggregation rules, and measure calculations and navigation paths into a single view that is queried with very simple SQL. Use cases include simplifying access to data star schema, Oracle Big Data SQL, and JavaScript Object Notation and as an alternative to exporting data for the analysis in spreadsheets.

This session will be of particular interest to data warehouse architects and developers and business intelligence application developers.

Back to Top
High-Availability Oracle Data Integration Without the Need for J2EE
Holger Friedrich , sumIT AG
When: Jun 28, 2017, Wednesday Session 11, 8:30 am - 9:30 am
Room: Magnolia
Topic: Data Warehousing & Big Data - Subtopic: Data Integration

Internet of Things (IoT), cloud-based products, or real-time data warehousing - almost every state-of-the-art data integration (DI) application requires high-availability (HA) as a mandatory feature, not only in source and target systems, but also in the DI infrastructure. Oracle DI provides different installation alternatives offering different degrees of HA. Moreover, different platforms like e,g. Exadata allow only certain DI installation types. This presentation discusses the different HA and installation types available from Oracle out of the box with a special focus on how to achieve HA without having to pay for J2EE licenses and additional middle-tier hardware. It shows how HA can be achieved easily with little implementation effort on non-J2EE installations. The real-time data warehouse implementation of Switzerland's leading mobile payment provider TWINT serves as a successful example.

Back to Top
Analyzing the Panama Papers with Oracle Big Data Spatial and Graph
Jordan Meyer , Rittman Mead
When: Jun 27, 2017, Tuesday Session 7 , 11:15 am - 12:15 pm
Room: Magnolia
Topic: Data Warehousing & Big Data - Subtopic: Other Data Warehousing and Big Data

Oracle Big Data Spatial and Graph enables the analysis of data sets beyond that of standard relational analytics commonly used. Through graph technology relationships can be identified that may not otherwise have been. This has practical uses including in product recommendations, social network analysis, and fraud detection.

In this presentation we will see a practical demonstration of Oracle Big Data Spatial and Graph to load and analyse the "Panama Papers" data set. Graph algorithms will be utilized to identify key actors and organizations within the data, and patterns of relationships shown. This practical example of using the tool will give attendees a clear idea of the functionality of the tool and how it could be used within their own organization.

Back to Top
The Hybrid World – RDBMS + Hadoop
Kerry Osborne , Accenture Enkitec Group
When: Jun 28, 2017, Wednesday Session 16 , 4:15 pm - 5:15 pm
Room: Magnolia
Topic: Data Warehousing & Big Data - Subtopic: Data Architecture

The hybrid world is coming! There is no doubt that Hadoop has established a foothold in traditional enterprises by now. On the other hand, the well-established RDBMS products are far from dead. One of the major problems with Hadoop is that the native open source SQL engines are just not as capable as the traditional RDBMS engines. That’s understandable since the traditional RDBMS guys have a 20+-year head start. Oracle for example is the king of the hill with regards to complex transactional systems and has the most powerful SQL engine on the planet. What that means is that moving an application to Hadoop generally requires a major effort to re-write the data access layer (i.e. the SQL). Nevertheless, the power and the scalability of the distributed Hadoop architecture are undeniable. So why not use the best of both worlds? The combination of the two can create a platform that combines the best of both architectures. This presentation will discuss approaches for building just such a hybrid platform. This presentation includes a case study showing a hybrid architecture combining Oracle and Hadoop in an innovative use case that shows ankle bracelet tracking data with a google map interface.

Back to Top
SQL on Hadoop for the Oracle Professional
Michael Rainey , Gluent Inc
When: Jun 28, 2017, Wednesday Session 13, 11:15 am - 12:15 pm
Room: Magnolia
Topic: Data Warehousing & Big Data - Subtopic: Other Data Warehousing and Big Data

There is a fundamental shift underway in IT to include open, software defined, distributed systems like Hadoop. As a result, every Oracle professional should strive to learn these new technologies or risk being left behind. This session is designed specifically for Oracle database professionals so they can better understand SQL on Hadoop and the benefits it brings to the enterprise. Attendees will see how SQL on Hadoop compares to Oracle in areas such as data storage, data ingestion, and SQL processing. Various live demos will provide attendees with a first-hand look at these new world technologies.

Back to Top
The Great Debate: Where Should My Data Warehouse Live?
Michael Rainey , Gluent Inc
When: Jun 29, 2017, Deep-Dive Session, 9:00 am - 11:00 am
Room: Grand Oaks A/B
Topic: Data Warehousing & Big Data - Subtopic: Data Architecture

The long-standing debate of running your data warehouse on-premise versus in the cloud continues at the Kscope17 Big Data and Data Warehousing Thursday Deep Dive session. Whether built in a traditional, relational database or constructed from “schema on read” data in Hadoop, the recent rise of cloud services over the past few years has led data architects, IT directors, and CIOs to ask the question: “Where should my data warehouse live?”. Several experts in the Oracle data warehousing field will provide arguments for their preferred approach, while attempting to refute evidence presented for the alternative solution. Along with what should be a lively and engaging debate, the experts will join together to answer any questions you may have around big data, data warehousing, and data integration in general. Don’t miss this great debate and Q&A session!

Back to Top
I Know Why the On-Premise Oracle BI Applications Sings: Migrating OBIA to the Cloud
Christian Screen , Datavail
When: Jun 26, 2017, Monday Session 5 , 4:45 pm - 5:45 pm
Room: Magnolia
Topic: Data Warehousing & Big Data - Subtopic: Data Architecture

Cloud solutions continue to expand into the mainstream with obvious material value for businesses that have historically focused on their on-premise solutions. With all major concerns for security in the cloud addressed by bank grade encryption, integration by REST APIs and other supported interfaces, and a growing base of supported production customers, the concerns are turning to action. But there are still lingering questions on architectural best practices and the general approach to move from on-premise to the cloud especially for multi-tiered solutions such as Oracle BI applications. Questions are now less about concern and more about how to move forward. How much of the on-premise software architecture can be migrated to the cloud? And, how can it be done with best practices with the least risk and exposure? And, while getting it right the first time? This session discusses best practice architecture for migrating the Oracle BI applications to the cloud. It focuses on the Oracle Cloud platform and database services, with a nod to infrastructure services, to lay out the idea of the hybrid cloud, and variations of the new age cloud BI/DW architecture for your analytics environment to succeed while operating at the same reliability or better all the while benefiting from what the cloud offers best.

Back to Top