| |
| Title: |
Model and Query data with Oracle SQL Property Graph in Oracle 23c Database |
| Presenter: |
Kai Yu |
| Organization: |
Dell Technologies, Inc |
| |
| Summary: |
By representing data as a graph with vertices for entities and edges for relationship, a property graph data model is based on connections or relationship within data, where vertices and edges can have multiple properties. With this graph model, a property graph database stores explicitly information about relationships or connections between entities. We directly analyze or query these relationships in the database, which leads to many business use cases. Oracle 23c database introduced the property graph support in SQL which allows us to create and query a property graph view over the graph data stored in the relational tables. Coming to this session to learn how Oracle SQL property graph simplifies the relationship-based Querying on property graph and several business use cases where developers can leverage the SQL Property Graph. We also will discuss that you can use graph queries such as the new GRAPH_TABLE SQL query operator to makes it easy to build queries against Property Graphs and how we can use the SQL Property Graph to avoid complex multiple joins in the relational database. |
| |
| Topic: |
Analytics / Developer
|
| Session Type: |
One Hour Session |
| Target Audience: |
Architecture, AI/BI, Data Management |
| Experience Level: |
Novice |
| Session: |
9: 02/09/2024 2:00 pm to 3:00 pm |
| Location: |
Analytics / Developer |
| |
| Biographical Sketch: |
Kai Yu is a Distinguished Engineer and a member of Dell Technical Leadership Community in Dell Technologies and. Kai has 30 years experience of architecting various IT solutions by specializing in Oracle database, Oracle EBS, virtualization &Cloud, Oracle BI Analytics and machine learning. Kai has been a frequent speaker at various IT/Oracle conferences such as IEEE HPCC, OOW, Collaborates, DOAG, UKOUG, RMOUG etc with over 220 presentations in more than 25 countries. He also authored 35 articles in technical journals such as IEEE Transactions on Big Data, IOUG Select etc. Kai had co-authored Apress book “Expert Oracle RAC12c” and recently published “ Machine Learning for Oracle Database Professionals”
Kai has been Quest/IOUG conference committee member, IOUG RAC SIG president and IOUG Cloud SIG co-founder and the current vice president. Kai has been an Oracle ACE Director since 2010 and was featured as Oracle ACE Spotlight. He also received the 2011 OAUG Innovator of Year award the 2012 Oracle Excellence Award: Technologist of the Year: Cloud Architect by Oracle Magazine.
|
| Accomplishments: |
Kai has been a frequent speaker at various IT/Oracle conferences with over 220 presentations in more than 25 countries. He also authored 35 articles in technical journals such as IEEE Transactions on Big Data, IOUG Select and Dell Power Solutions and co-authored Apress book “Expert Oracle RAC12c”. Kai has taken some leadership positions in IOUG such as IOUG conference committee member, IOUG RAC SIG president and IOUG Cloud SIG co-founder and the current vice president. Kai has been an Oracle ACE Director since 2010 and was featured as Oracle ACE Spotlight by OTN. He also received the 2011 OAUG Innovator of Year award the 2012 Oracle Excellence Award: Technologist of the Year: Cloud Architect by Oracle Magazine. Kai has shared all his technical articles and conference presentations on his Oracle blog: https://kyuoracleblog.wordpress.com/. Kai has published his c-authored book “ Machine Learning for Oracle Database Professionals in 2021. |
| |
| |
