Spatial and Graph, Product Development, Oracle
In times of a pandemic, it is crucial to understand the "spaces", if people have been close enough to each other for long enough to transmit the disease, and the "networks", if people have been involved in any cluster or had interactions with each other via any path. Oracle Database is an evolving converged database, which integrates sophisticated spatial and graph capabilities, and it enables us to extract the contact tracing information from a massive amount of geospatial data as well as to analyze the large networks of people to detect the paths and clusters using graph algorithms and queries. Since privacy issues are the concerns over such systems, it is also important to discuss if Oracle Database, one of the most secure platforms, can technically protect the datasets using its access controls, data masking, and encryption. This session will discuss how to maximize the state-of-the-art database technologies to build advanced contact tracing systems against the future threats of infectious diseases.
Graph database 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. Growing numbers of application developers and data scientists want to access the graph capabilities of databases to find clusters, detect paths, and uncover unusual patterns in data, while DBAs need to understand the architectures of different database management systems. The graph feature of the Oracle Database is included without additional license cost, and 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, how graph-based queries are translated to SQL, and how database administrators can leverage these capabilities from the command-line tools such as SQLcl.