Hidden Gems of Database Tools in Autonomous Database

Опубликовано: 14 Октябрь 2024
на канале: Oracle Database Product Management
282
5

In this Autonomous Database Learning Lounge session, Database Developer Tools Product Management introduced the wide capabilities available to you inside the Database Tools that come with every Autonomous Database.
Register for our bi-weekly sessions at https://bit.ly/adb-learning-lounge
Slides for this session at: https://bit.ly/adbll-slides-dbtools
Outline
Autonomous Database Learning Lounge series presents “Hidden Gems of Database Tools in Autonomous Database”
Jeff Smith, Distinguished Product Manager did a tour of Database Tools and showed several components that you might not know, and the latest features that have been added recently.
Open Q&A
Autonomous Database product managers answered technical questions about the Autonomous Database service, its features, integration capabilities and use cases.
Video highlights:
00:38 Agenda
01:20 Important links on Autonomous Database
01:36 Hidden Gems - Autonomous Database Features
05:13 REST APIs, what are those?
08:40 REST APIs: easier access
09:58 REST APIs are ubiquitous
12:13 REST APIs for your Data and Business Logic
15:30 Autonomous Experience: Ready to go on Day 0
17:26 Customers are using APIs, a lot
21:34 But why?
22:56 How real customers are using REST APIs
26:00 Customer "As One" use of Oracle REST Data Services (ORDS)
27:05 Customer "Satlog Gmbh" runs a Fleet Management service with Oracle REST
28:10 Customer "Trailcon" uses ORDS for telematics and fleet maintenance data
29:11 Customer "Advania" peaks at 100k requests per min (40 to 900ms)
31:05 Customer "Minesense" deploy APIs in an automated fashion
31:19 REST and HTTPS in Autonomous Database
31:41 AutoREST
33:43 REST API modules
35:27 REST Enabled SQL
37:51 SODA for REST and MongoAPI for Oracle
38:50 Did you know: Built-in swagger tooling
41:26 Did you know: Data Pump from your browser
43:34 Did you know: Batch load CSV to your tables via REST
45:32 Did you know: Search and browse your database
47:02 Did you know: Scheduler interface
48:38 Resources
50:04 Q&A
52:24 Important links on Autonomous Database
52:47 Final thoughts