Ponedeljek, 8. november 2021
Otvoritev dogodka Analytics
Tudi prejšnje leto smo imeli virtualno konferenco, ki se je odvijala čez cel teden, zato smo jo poimenovali MakeIT Week. Letos smo se odločili za drugačen format. Namesto dveh dni z več vzporednimi predavanji, bomo imeli več enodnevnih ali dvodnevnih dogodkov. Vsi ti dogodki bodo v jeseni, zato ime MakeIT Autumn.
Use Cases for Oracle Analytics
Mojca Gros & Žiga Vaupot
Predstavitev je zamišljena kot mini delavnica, na kateri si bomo podrobno pogledali nekaj primerov uporabe orodij, ki so del Oracle Analytics.
Upravljanje s podatki je pomembna dopolnitev orodij, ki smo jih predtem poznali pod imenom Oracle Business Intelligence. Oracle Analytics omogoča uporabniku delo in upravljanje s podatki, ki jih je mogoče organizirati v podatkovne modele, jih medsebojno povezovati ne glede na njihov izvor in jih dodatno obogatiti brez posredovanja strokovnjakov za razvoj rešitev poslovne analitike.
Učinkovita vizualizacija podatkov je v modernih orodjih za poslovno analitiko nepogrešljiva. Med posebnimi tipi vizualizacij podatkov sodi tudi uporaba geografskih podatkov in njihova uporaba v mapah. V predstavitvi bomo podrobno pregledali zmožnosti vizualizacije podatkov v mapah, ki so uporabniku na voljo za uporabo, na dejansko izredno enostaven in intuitiven način.
V tretjem sklopu primerov, pa si bomo pogledali nekaj primerov uporabe strojnega učenja, ki je vgrajeno v Oracle Analytics in jih lahko končni uporabniki s pridom izkoristijo v svojih poslovnih analizah.
Kosilo / Lunch
Apache Kafka and Flink: Stateful Streaming Data Pipelines made easy with SQL
A stateful streaming data pipeline needs both a solid base and an engine to drive the data. Apache Kafka is an excellent choice for storing and transmitting high throughput and low latency messages. Apache Flink adds the cherry on top with a distributed stateful compute engine available in a variety of languages, including SQL.
In this session we'll explore how Apache Flink operates in conjunction with Apache Kafka to build stateful streaming data pipelines, and the problems we can solve with this combination. We will explore Flink's SQL client, showing how to define connections and transformations with the most known and beloved language in the data industry.
This session is aimed at data professionals who want to reduce the barrier to streaming data pipelines by making them configurable as set of simple SQL commands.
Francesco comes from Verona, Italy and works as a Developer Advocate at Aiven. With his many years of experience as a data engineer, he has stories to tell and advice for data-wranglers everywhere. Francesco loves sharing knowledge with others as a speaker and writer, and is on a mission to defend the world from bad Italian food!
Introduction to Oracle Graph for DBAs
Albert Godfrind & Hans Viehmann
Graph analysis offers a different way of looking at data and has become very popular in recent years to gain new insights into the connections and relationships in data. In database administration, graphs can make it easy to analyze hierarchies of dependencies, for example. Mapping the content of the DBA_DEPENDENCIES view to a graph structure to determine which triggers will fail if a given PL/SQL function does not compile any longer would be just one possible use case. Similarly, graphs enable the DBA to determine, through which role a given user directly or indirectly has access to which resources, or vice versa, which users have access to a given column with, say, personally identifiable information.
The graph feature of the Oracle Database is included without additional license cost. It enables developers to create graphs from database tables, search for graph patterns, and apply graph algorithms to data. This session is a how-to for DBAs who need to support their organizations in using this feature. We will explain what the graph feature entails, how to install it, what components are necessary, what tools are available, and how database administrators can leverage these capabilities from the command line using SQLcl.
The session will be covered by Albert Godfrind from Oracle Corporation. Albert 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. Ever since, Albert has been evangelizing the use of spatial information to GIS and BI communities across Europe, consulting with partners and customers, speaking at conferences, and designing and delivering in-depth technical training.
Albert is one of the authors of the first book on Oracle Spatial, "Pro Oracle Spatial - The essential guide to developing spatially enabled business applications"
Hans Viehmann is working for ORACLE Corporation as director of product management for the spatial and graph technologies.
He holds a degree in Physics from Hamburg University and started his career in Research before joining ORACLE over twenty-five years ago. After various positions in Presales and Business Development, he joined the Product Management Team in 2011. He is responsible for the outbound product managers on the Oracle Spatial and Graph team. With his team, he is looking after strategic projects and partnerships, the marketing activities, as well as the internal awareness around the Spatial and Graph technologies worldwide. He is working closely with various Oracle User Groups and helped establish Spatial and Graph Special Interest Groups in several countries. He is a regular speaker at conferences and user group events and serves on the advisory board of InGeoForum, Germany.