Session Abstract
Data Refactoring Advisor is an innovative methodology designed to assist Oracle Database developers in refactoring their schemas by identifying communities based on join activity. This technique simplifies the complex task of transforming monolithic applications into agile microservices.
In this talk, we will show how to use SQL Tuning Sets to detect which tables are queried together as part of joins and determine how frequently these joins occur. We will convert the result into a graph, from which we can identify and visualize dependencies and relationships. Using algorithms from graph theory, we can even automatically determine logically related groups of tables, which potentially represent bounded contexts and can therefore serve as the basis for microservices.
In the session, we will briefly explain the basics of tuning sets and graph analysis. We will then use a concrete example to show how to define a graph in the database, search for dependencies, and automatically identify groups of related objects. In the live demo, we will present various queries in practice and graphically render the results.