In this Autonomous Database Learning Lounge session, the Oracle Autonomous Database PM team talked about the modern data platform and the best practices when using Autonomous Database, which can integrate data and metadata from different clouds..
Register for our bi-weekly sessions and watch recordings at [ Ссылка ]
Slides for this session at: [ Ссылка ]
Outline
- Alexey Filanovskiy, Senior Principal Product Manager, showed you how to create a modern data platform using the Oracle Autonomous Database. He explained how to work with various types of data across different clouds and integrate with other metadata sources, such as AWS Glue.
- He covered how to share data throughout your organization and make the most of different data formats.
- Additionally, he introduced the power of Autonomous Database Data Studio, a self-service UI that is an essential companion for interacting with data in a modern data platform.
Video highlights:
00:36 Agenda
01:43 Important links on Autonomous Database
02:30 Modern Data Platform opportunity
05:13 Modern Data Platform pillars:
05:22 Modern Data Platform pillars: Secure Object Store access
05:50 Authentication with non-Oracle object stores
06:13 Live Demo: Data Studio - Loading Data from Object Storage
08:44 Modern Data Platform pillars: Data integration and Data Virtualization
08:50 Data Federation with non-Oracle databases
09:39 Data Transforms data sources
09:59 New Feature: AI API integration in Autonomous Database
10:33 Live Demo: Data Studio - bring data from public AI sources
11:38 Modern Data Platform pillars: Data catalogs
11:49 Synchronize with OCI Data Catalog
11:59 Synchronize with AWS Glue
12:53 Live Demo: Data Studio integration with AWS Glue catalog
14:28 Modern Data Platform pillars: Data Lake file formats
14:49 Iceberg table as Oracle External table
15:56 Live Demo: Data Studio integration with Iceberg table
17:31 Delta Share table as Oracle External table
17:57 Live Demo: Data Studio loading data from Delta Share
19:23 Modern Data Platform pillars: Data Sharing
21:06 Data Sharing in Autonomous Database
22:35 Delta Share vs. Direct Database Connection
24:18 Live Demo: Data Studio creating Delta Share for MS PowerBI
27:24 Integrating Natural Language using GenAI
27:50 Autonomous Database Select AI
28:41 Easy to extend and build new natural language Apps
29:38 Oracle Modern Data Platform "Pyramid"
31:55 Q&A Suppose my app DB is in AWS S3 and I want it migrated to ADB - do we have utility to get everything into ADB so I don't have to use AWS anymore
32:58 Q&A Is this available on DRCC
33:15 Q&A Can ADB connect directly to on-premises, heterogeneous databases?
33:42 Q&A Is there any caching done for data extraction from multiple sources to reduce the latency and one th fly data merging?
34:03 Q&A What is the default model used by Select AI , is it using OCI GenAI Cohere?
34:37 Q&A Does the new DataStudio support wildcards in filename pattern?
34:52 Q&A Can ADB Data transforms connect to data sharing api?
35:19 Q&A How do I handle Spreadsheet data that need to be pulled in to my ATP on-prem db (monthly) from FTP or Shared folder, the data is used in OML for projections. Scheduled to auto pull data. Are there any Live labs that may cover these type of import extract?
37:41 Q&A Is ADB thinking about a feature for converting different fie data types like pptx,csv,xlsx,docx,pdf into vector embedding?
38:50 Q&A When we use Delta sharing to share data, and lets say the data changes at the source after a day or two, how-when does it reflect on the consumer?
40:28 Important links on Autonomous Database
40:59 Final thoughts
