|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-ords-for-paas/
课程评论：没有评论
课程名称：Oracle REST 数据服务（ORDS）入门（适用于 PaaS） 课程概述： Oracle REST 数据服务（ORDS）是 Oracle 数据库的 HTTPS 网络网关，提供了多种功能，包括 Oracle 数据库操作、Oracle APEX 访问、REST API 接口，以及对 MongoDB 的支持等。ORDS 是一个基于 Java EE 的替代方案，提供更强大的功能，包括命令行配置、增强的安全性、文件缓存和 RESTful 网络服务等。ORDS 支持通过 Oracle WebLogic Server、Apache Tomcat 和独立模式进行灵活部署，简化了部署过程，并不需要 Oracle home，因其使用了嵌入式 JDBC 驱动来实现连接。 ORDS 的主要特点包括： 1. **数据库操作**：提供基于 Web 的接口，包含开发、数据工具、管理和监控功能，支持 Oracle Autonomous Database Cloud Services 。 2. **REST 启用 SQL**：允许执行随需而来的 SQL 和 SQL 脚本，通过服务发送一个或多个 SQL 语句，返回结果为 JSON 格式。 3. **数据库 REST API**：提供超过 500 个 REST API，用于监控和维护 Oracle 数据库，包括 PDB 生命周期管理、性能、安全性和数据字典等操作。 4. **REST API 定义**：支持用 SQL 和 PL/SQL 定义 REST API，自动处理 SQL 查询的分页，支持 GeoJSON 空间格式，并处理常见数据库错误，并返回适当的 HTTPS 响应。 5. **PL/SQL 网关**：作为 Oracle HTTP Server 和 mod_plsql 的 Java EE 替代方案，实现无缝迁移，兼容之前的数据库资源配置。 6. **RESTful 网络服务**：支持表和视图的自动 REST 功能、PL/SQL 的 RPC、自定义服务等，提供 JSON 响应和分页结果。 7. **管理与性能调优**：提供数据库管理 API 和 500 多个管理接口功能，包括 PDB 管理、数据泵和性能监控等。 课程将帮助学员掌握 ORDS 的基础知识与应用，学会如何通过 REST API 进行数据库操作和管理，从而增强使用 Oracle 数据库的能力。
About Oracle REST Data ServicesOracle REST Data Services (ORDS) is the HTTPS Web Gateway for your Oracle Database, which includes features such as Oracle Database Actions, Oracle APEX access, REST APIs for your data and databases, Oracle Database API for MongoDB, and much more. Oracle REST Data Services is a Java EE-based alternative for Oracle HTTP Server and mod_plsql. The Java EE implementation offers increased functionality including a command-line based configuration, enhanced security, file caching, and RESTful web services. Oracle REST Data Services also provides increased flexibility by supporting deployments using Oracle WebLogic Server, Apache Tomcat, and a standalone mode.The Oracle APEX architecture requires a web server to proxy requests between a web browser and the Oracle APEX engine. Oracle REST Data Services Meets the requirement but its use goes beyond that of Oracle APEX configurations. Oracle REST Data Services simplifies the deployment process because there is no Oracle home required, as connectivity is provided using an embedded JDBC driver.Features of Oracle REST Data ServicesThis section lists the features of Oracle REST Data Services (ORDS).Database ActionsDatabase Actions, is a web-based interface that provides development, data tools, administration, and monitoring features for Oracle Database. Additionally, ORDS is provided as a managed feature of the Oracle Autonomous Database Cloud Services.REST-Enabled SQLREST-Enabled SQL is a REST API that allows for ad-hoc SQL and SQL Scripts to be executed. You can POST one or more SQL statements to the service. The service then runs the SQL statements against Oracle Database and returns the results and output to the client in a JSON format.Database REST APIsORDS includes a collection of more than 500 REST APIs for performing operations such as monitoring and maintaining your Oracle Database, including PDB lifecycle management, performance, security, data dictionary, data pump.REST APIsProvides the ability to define the REST APIs with SQL and PL/SQL. ORDS marshals SQL and PL/SQL types to and from JSON, auto-paginates the results of your SQL queries, supports GeoJSON for spatial, handles common database errors with appropriate HTTPS responses and much more. Users can also choose to REST enable tables, views, and stored procedures to take advantage of the AutoREST feature.PL/SQL GatewayOracle REST Data Services is a Java EE-based alternative for Oracle HTTP Server and mod_plsql. An Oracle HTTP Server mod_plsql application can be migrated to ORDS by defining the new ORDS configuration files. The mod_plsql database resources such as before procedures, after procedures, request validation functions, owa_custom packages, document upload procedures and document tables require no change when you are migrating to ORDS. PL/SQL gateway enables you to access your APEX applications from an application server such as WebLogic or Tomcat.RESTful Web ServicesAuto REST for tables and views, RPC for PL/SQLCustom services built with SQL & PL/SQL{json} responsesPaged resultsOpen API DocumentationFull dev support (GUI, CLI, API)SQL Developer WebWeb application hosted by ORDSSQL WorksheetREST Development EnvironmentJSON WorkshopManagement and Performance TuningDatabase Management API500+ endpoints for managing your Oracle DatabasePDB managementData PumpData DictionaryPerformanceMonitoring
