Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Autonomous Database changes the way you build s...

Autonomous Database changes the way you build smart applications. Learn how easy it is!

Analytics are critical to successful applications; they need to be embedded in every part of your solution.
How do you simplify your path to success? We’ll step thru a use case to show you how.

Specifically, we’ll demonstrate using the Autonomous Database tool set how to:
- Discover and integrate data needed for analytics from multiple cloud stores
- Develop interactive dashboards
- Identify high-value, at-risk customers
- Personalize recommendations
Learn how to unleash your creativity using this immersive, easy-to-use, self-service platform!
How to access information and collateral about Autonomous Database
- We will show you how to get access to tutorials with tips and tricks, live demos, best practices and Live Labs for free hands-on experiences, and show the ADB monthly Newsletter.
Open Q&A
- Autonomous Database product managers will answer any technical questions about the Autonomous Database service, its features, integration capabilities and use cases.

Speakers:
- Martin Gubar, Director of Product Management, Autonomous Database
- Keith Laker, Senior Principal Product Manager, Autonomous Database
Hosted by Marcos Arancibia, Senior Principal Product Manager, Autonomous Database

Marcos Arancibia

May 15, 2023
Tweet

More Decks by Marcos Arancibia

Other Decks in Technology

Transcript

  1. Autonomous Database Learning Lounge Hosted by Marcos Arancibia Autonomous Database

    Product Management Autonomous Database changes the way you build smart applications. Learn how easy it is! THIS SESSION IS BEING RECORDED
  2. Agenda 2 Copyright © 2023, Oracle and/or its affiliates Autonomous

    Database changes the way you build smart applications. Learn how easy it is! Marcos Arancibia, Senior Principal Product Manager will briefly explain what Oracle Autonomous Database is and the basic concepts behind it. Marty Gubar, Director of Product Management will show how to simplify your path to success with Analytics thru a use case using Autonomous Database tool set easy- to-use, self-service platform: - Discover and integrate data needed for analytics from multiple cloud stores - Develop interactive dashboards - Identify high-value, at-risk customers - Personalize recommendations He will also show you how to get access to tutorials with tips and tricks, live demos, best practices and Live Labs for free hands-on experiences, and show the ADB monthly Newsletter. Open Q&A Product Managers will answer any technical questions about the Autonomous Database service, its features, integration capabilities and use cases.
  3. Before we begin… Copyright © 2023, Oracle and/or its affiliates

    3 • This session is for you!!! • Ask any questions in Q&A Oracle Product Managers are on standby • Recording will be available a few days after the session, in the same page you used to join today • Make sure to interact with us !
  4. What Sets Oracle Apart? We have a customer base of

    more than 430,000 customers Oracle Database: Platform of choice for the world’s most critical workloads 11g 10g 9i 8i Copyright © 2023, Oracle and/or its affiliates
  5. Broad ecosystem - everybody supports Oracle Database Data modeling integration,

    connectors Analytics and visualization SIs, development tools and CI/CD Industry solutions Copyright © 2023, Oracle and/or its affiliates
  6. Oracle’s delivers a new vision for data management …a completely

    NEW type of cloud service INFRASTRUCTURE DATA CENTER OPS DATABASE …an EVOLUTION of the world’s #1 Database g 1 0 9i g 1 1 Copyright © 2023, Oracle and/or its affiliates
  7. Deployment choices to match your CLOUD and DATA requirements Oracle

    Autonomous Database Public Cloud Shared Infrastructure Private Cloud Multi- Cloud Dedicated Infrastructure Oracle Database Service for Azure Exadata Cloud@Customer Dedicated Region Cloud@Customer Copyright © 2023, Oracle and/or its affiliates
  8. Oracle Database Vision Make it simple to deliver modern data-

    driven application and analytic workloads in the cloud Copyright © 2023, Oracle and/or its affiliates
  9. Manage increasing complexity of modern business operations Modern data-driven businesses

    create powerful experiences for users and more value for enterprises using a wide variety of data technologies: Breadth-depth of technologies used by modern businesses makes data management increasingly complex Making complete solutions manageable, available, and secure adds even more complexity What is the best way to deliver modern data management platform? Text Documents { JSON } Graph Many Types of Data Spatial Many Types of Workload Data Mesh Micro Services Blockchain IoT Social Graph Lake House Location Machine Learning Relational Pre-built Apps Copyright © 2023, Oracle and/or its affiliates
  10. Common platform, optimized for specific workloads Copyright © 2023, Oracle

    and/or its affiliates 11 Optimized for data warehousing Optimized for transaction processing Optimized for JSON Optimized for low-code Data Warehouse Built for decision support and data warehouse workloads. Fast queries over large volumes of data Transaction Processing Built for transactional workloads. High concurrency for short- running queries and transactions APEX Built for Oracle APEX App development. Creation and deployment of low- code applications, with database included JSON Built for JSON-centric application development. Developer-friendly document APIs and native JSON storage
  11. Develop smarter applications the way you want Dramatically reduce complexity,

    cost, and time-to-market Any Data Converged, open, SQL database for multiple data types and data models Any Workload Transactional processing, data warehousing, analytics, machine learning, application development and mixed workloads Any Development Style Zero-code/low-code to any-code through built-in frameworks: APEX, MongoDB API. Support for existing development styles and frameworks Copyright © 2023, Oracle and/or its affiliates
  12. Autonomous Database changes the way you build smart applications. Learn

    how easy it is! Copyright © 2023, Oracle and/or its affiliates 13
  13. Build Smart Applications with Autonomous Database Autonomous Database Learning Lounge

    Marty Gubar Product Management Oracle Autonomous Database May 2023
  14. [Date] Copyright © 2023, Oracle and/or its affiliates 15 Developers

    prefer… … single purpose databases • Document Database • Graph Database Ease of Use Specific Features CTOs want something else… … ease of repurposing data across the enterprise Common: • Tooling • Upgrades • Patches • Privacy policies How can a company improve both? developer productivity AND data productivity
  15. Oracle MovieStream: a personalized user experience Copyright © 2023, Oracle

    and/or its affiliates There is a lot of intelligence behind the application Machine Learning + Spatial Analytics Predict churn and localize an offer Analytic SQL Rankings over recent transactions Analytic SQL + Spatial Rankings refined based on location JSON Analytics Query complex JSON data types Graph Analytics Recommendations using sophisticated graph algorithms
  16. Front-end developer viewpoint Developing the personalized experience Copyright © 2023,

    Oracle and/or its affiliates • Must deliver a compelling user experience • Need a productive, easy to use API plus fast, reliable performance Don’t know and don’t care how page contents are derived!
  17. She’s the REST endpoint To make the best product recommendations

    or find at-risk customers, she needs to work with lots of data sets • about activity • about communities • about customers • from partners • and so much more This person cares about the page content Copyright © 2023, Oracle and/or its affiliates
  18. Your data can drive innovation, but… Copyright © 2023, Oracle

    and/or its affiliates Data systems and tools need to be modernized to deliver more and faster 95% requires extensive manual involvement 60% complained about overall management complexity 38% too costly to acquire and maintain 33% too slow to deploy
  19. Simplify data with Autonomous Database Copyright © 2023, Oracle and/or

    its affiliates Do more with data Put your data to work using built-in self- service tools and your favorite applications. Focus on innovating and gaining insights from all your data. Sleep well at night with the confidence that your data is always safe and available. 02 Integrate Collect and wrangle data sets Operationalize Apply insights to improve processes and mitigate risks 01 Discover Find and understand data sets available across the enterprise 03 Analyze Use your favorite applications to develop actionable insights 04
  20. How MovieStream leverages analytics 5/16/23 Copyright © 2023, Oracle and/or

    its affiliates 22 Discover and integrate data from Oracle Cloud and Amazon S3 What movies are popular near you? Find high value customers at risk of leaving Oracle MovieStream and make an offer Publish new data sets to interactive dashboards Recommend movies based on communities See the outcome in the Oracle MovieStream application! 1 2 3 4 6 5
  21. Productive, self-service data load experience • Simple user experience to

    link, load, and transform data from databases and cloud storage • Multi-cloud support, including OCI, Amazon S3, Azure Blob Storage, Google Cloud Storage, and more • Multi-database support, including Microsoft SQL Server, Azure SQL, Amazon Redshift, IBM DB2, MySQL, PostgreSQL, Snowflake, MongoDB and more Load or link to data sources Copyright © 2023, Oracle and/or its affiliates
  22. Full listing of APIs at https://bit.ly/adb-apis Take advantage of external

    data using comprehensive APIs Copyright © 2023, Oracle and/or its affiliates Authorization create_credential REST APIs send_request get_response_headers get_response_status_code get_response_text get_api_result_cache_size set_api_result_cache_size File management copy_object delete_object list_objects move_object put_object bulk_copy bulk_delete bulk_download bulk_move bulk_upload list_files delete_file Data Linking create_external_table create_external_part_table create_hybrid_part_table create_external_text_index Data Export export_data Data Loading copy_data copy_collection get_object
  23. Example: automatically generated partitioned external table improves performance -- Create

    an external table -- Partitions and columns automatically -- derived from parquet file content and location dbms_cloud.create_external_part_table ( table_name => 'ext_custsales', file_uri_list => '&gold_bucket/custsales/*', format => '{"type":"parquet", "partition_columns":["month"] }' ); APIs simplify optimized access to data lake sources Copyright © 2023, Oracle and/or its affiliates Object store bucket: sales with monthly partitions custsales month=2023-jan •file1.parquet •file2.parquet month=2023-feb •file1.parquet month=2023-mar •file1.parquet •file2.parquet create partitioned external table
  24. OCI Data Catalog - “Spotlight for OCI” • Quickly discover

    data across Object Storage, Autonomous Database, Oracle databases, MySQL, Kafka, Hive and more for analytics • Manage a business glossary and associated technical metadata to improve data governance Discover and understand available data Copyright © 2023, Oracle and/or its affiliates Data Discovery and Business Glossary Oracle Cloud and on-prem sources
  25. Autonomous Database both a Data Catalog source and consumer Data

    Catalog is the source of truth for Object Store metadata • Harvest object storage to derive schemas • Manage business glossary, terms and tags • Discover data using powerful search Use Autonomous Database to discover and analyze data sets • Managed schemas and tables defined automatically • Use Oracle SQL to query both metadata and object storage data Immediately use Data Catalog metadata to find and query data sets Copyright © 2023, Oracle and/or its affiliates Data Catalog Object Storage Autonomous Database(s) Harvest 1 Sync 2 Query 3
  26. Avoid falling off complexity cliff - Existing tools and applications

    just work Simplify analytics across complex data sources using Oracle SQL Copyright © 2023, Oracle and/or its affiliates Common Analytics Window functions Ranking Lag/lead Top-N WITH clause Pivot/Unpivot Aggregation functions Approximate Queries Ratio to Report Advanced Analytics Pattern matching Model clause Advanced Statistics Statistical aggregates Linear regression Descriptive stats Correlations Cross Tabs Hypothesis testing Distribution fitting Pareto analysis JSON Functions JSON Table JSON Object JSON Query JSON Object Machine Learning Regression Classification Clustering Anomaly detection Ranking Association Feature selection Row importance Time series Spatial Analytics 100s of functions Enrichment 2D, 3D, LiDAR, Raster, Network, Topology Text Analytics Indexing Linguistic Search words, themes Document Classification Named Entity Recognition Sentiment Analysis Graph Analytics Property graphs RDF graphs Community detection Ranking and walking Evaluating community Path finding Link prediction
  27. Analytics tools: freedom of choice Copyright © 2023, Oracle and/or

    its affiliates Tableau Looker SAP Business Objects Microsoft Power BI Cognos SAS Microstrategy Alteryx Qlik Tibco https://www.oracle.com/database/adw-cloud-tools.html Certified Tools with Autonomous Database
  28. Oracle Analytics Cloud Create and consume; • Highly stylized interactive

    dashboards • Parametrized dashboards • Pixel-perfect reports • Visualizations embedded into other apps Experience continuity across browser and mobile app Simple, interactive analytics Copyright © 2023, Oracle and/or its affiliates
  29. How are graphs used? • Community detection • Influencer analysis

    • Fraud prevention • Physical networks, supplier networks, ... • Dependency graphs o Part hierarchies, data lineage, org charts, ... • Workflows • … so much more Graphs: A powerful way to derive insights from connections Copyright © 2023, Oracle and/or its affiliates 34 E A D C B F Graph model connects entities
  30. Use SQL-like PGQL • Search for surrounding nodes • Traverse

    property paths • Pattern matching • Extract sub-graphs Execute graph algorithms (over 60 available) • Community detection, influencer analysis • Ranking and walking • Structure evaluation • Path finding • Link prediction MovieStream Product recommendation Predicting links based on ranking and walking Use Graph analytics Copyright © 2023, Oracle and/or its affiliates. 35 Customer Movie Watched Recommendation
  31. Simplify deep analytics to produce better results And that’s how

    Oracle MovieStream was built Copyright © 2023, Oracle and/or its affiliates Machine Learning + Spatial Analytics Predict churn and localize an offer Analytic SQL Rankings over recent transactions Analytic SQL + Spatial Rankings refined based on location JSON Analytics Query complex JSON data types Graph Analytics Recommendations using sophisticated graph algorithms
  32. Summary Developer Days 1 2 3 Use more data -

    integrate data from any source Do more with data to produce better results Sleep better knowing your platform is always performant, always available and always safe Copyright © 2023, Oracle and/or its affiliates Simplify
  33. 40 Copyright © 2023, Oracle and/or its affiliates 1 Sign-up

    for a free Oracle Cloud Account bit.ly/adb-free-trial
  34. 41 Copyright © 2023, Oracle and/or its affiliates 2 Review

    complete guide to getting started bit.ly/get-started-adb
  35. 42 Copyright © 2023, Oracle and/or its affiliates 3 Visit

    our library of free workshops bit.ly/adb-workshops
  36. 43 Copyright © 2023, Oracle and/or its affiliates 4 Watch

    our series of how-to demo videos bit.ly/adb-demos
  37. Important links for you to bookmark Links to get you

    started and to make sure you keep up to date with everything related to Autonomous Database 44 Copyright © 2023, Oracle and/or its affiliates 1 Sign-up for a free Oracle Cloud Account bit.ly/adb-free-trial 2 Review complete guide to getting started bit.ly/get-started-adb 3 Visit our library of free workshops bit.ly/adb-workshops 4 Watch our series of how-to demo videos bit.ly/adb-demos
  38. 45 Copyright © 2023, Oracle and/or its affiliates 5 Sign

    up for “what’s new” announcements bit.ly/adb-announcements
  39. 46 Copyright © 2023, Oracle and/or its affiliates 6 Join

    us on LinkedIn to chat about ADB bit.ly/linkedin-adb
  40. Important links for you to bookmark Links to get you

    started and to make sure you keep up to date with everything related to Autonomous Database 48 Copyright © 2023, Oracle and/or its affiliates 5 Sign up for “what’s new” announcements bit.ly/adb-announcements 6 Join us on LinkedIn to chat about ADB bit.ly/linkedin-adb 7 Follow us on Twitter @AutonomousDW twitter.com/AutonomousDW 8 Got a question? We are on stackoverflow bit.ly/adb-stackoverflow
  41. Get ideas and inspiration for your next project with Autonomous

    Hear how our customers are using the power of Autonomous Database to do more bit.ly/adb-customers
  42. Copyright © 2023, Oracle and/or its affiliates 51 Final thoughts

    Main Autonomous Database site oracle.com/autonomous-database Autonomous Datawarehousing Blogs blogs.oracle.com/datawarehousing Site containing demos of ADB features bit.ly/adb-demos Autonomous Database Newsletter bit.ly/adb-news-linkedin Autonomous Database LiveLabs Workshop bit.ly/adb-workshops Autonomous Database Getting Started documentation bit.ly/adb-getting-started-doc Latest features of Autonomous Database bit.ly/adb-latest-features Next Sessions bit.ly/adb-learning-lounge
  43. 52 Copyright © 2023, Oracle and/or its affiliates | Confidential:

    Internal Thank you por joining today's call !!! Upcoming Sessions: • Data Studio: Self-Service tools for Autonomous Database • Data Sharing for Autonomous Database