Availability and architecture

(ethereal music) - Hello. Welcome to Oracle APEX Foundations Course, Getting Started with Oracle APEX module, Availability and Architecture lesson. My name is Chaitanya, I'm a product manager on the Oracle APEX product development team. Oracle APEX provides you with all the tools you need to build applications in a single extensible platform which runs as part of Oracle Database. You now have an understanding of what Oracle APEX is. Let's now do a deep dive into Oracle APEX availability and architectures. Oracle APEX runs everywhere your Oracle Database runs. In this lesson, you'll learn about various environments where Oracle APEX is available. You are introduced to Oracle APEX and Autonomous Database. You'll learn how Oracle APEX plus Autonomous Database is a powerful combination. You're also introduced to the simple, lowest cost, all-inclusive Oracle APEX service. You'll learn about Oracle APEX architecture. And finally, this lesson also covers Oracle APEX deployment options. With Oracle APEX, you can rapidly develop, customize, and deliver solutions. Oracle APEX Engine takes care of all of the low level plumbing, and provides a simple to use declarative framework, so developers can concentrate on solving business requirements, rather than spending time in writing hundreds of thousands of lines of code to build applications. APEX provides all the necessary pre-built controls to build an application that securely accesses a database, manages user credentials, complex business rules, session state, and more. So with APEX, you can go from prototype to production in just minutes. Rather than modifying lines of code, you can simply update the application definition, and then run it to see the changes. There is no need to check in code or generate deliverables. Just code, test, run, and repeat. Oracle APEX is a fully supported, no-cost feature of Oracle Autonomous Database, and all Oracle Database Distributions and Editions. This means if you have Oracle Database, you already have Oracle APEX. This also means that you have native access to all of the Oracle Database capabilities. APEX runs anywhere that Oracle Database runs, whether it is on premises, or in Oracle Cloud, or anywhere else, and you can deploy your Oracle APEX applications across any environment with ease. In Oracle Cloud, APEX is offered as a simple all-inclusive APEX service, with all Database Cloud Services, including Autonomous Database, and is also available as always free with APEX Service and Autonomous Database. Oracle Cloud Infrastructure's Autonomous Database is a fully managed, pre-configured database environment. Oracle Autonomous Database uses artificial intelligence and machine learning to automate many data management tasks performed by DBAs, including managing database backups, security, and performance tuning. Autonomous Database offers four different workload types. Autonomous Transaction Processing. This is built for transactional workloads, and offer high concurrency for short run queries and transactions. Autonomous Data Warehouse. This is built for decision support and data warehouse workloads. It offers fast queries over large volumes of data. Oracle APEX Application Development, or APEX Service, which is optimized for application developers who want a transaction processing database for application development using Oracle APEX. Autonomous JSON Database, which is built for JSON-centric application development. It offers developer-friendly document APIs, and native JSON storage. You can use the Oracle APEX service with each of the other workload types. Autonomous Database can be used without charge as part of the Oracle Cloud Infrastructure Suite of Always Free Resources. Oracle APEX plus Autonomous Database on Oracle Cloud Infrastructure is a powerful combination. Oracle APEX on Autonomous Database provides a pre-configured, fully managed, and secured environment to both develop and deploy world-class applications. Oracle takes care of configuration, tuning, backups, patching, encryption, scaling, and more, leaving you free to focus on solving your business problems. The Autonomous Database Cloud Services also include powerful technologies such as Oracle REST Data Services and Database Actions to access, manage, and maintain your data. The world's most popular enterprise low-code application development platform, Oracle APEX, along with the world's best converged database, Oracle Autonomous Database, on the world's best cloud infrastructure, Oracle Cloud Infrastructure, is available as a simple all-inclusive cloud service that scales as you grow. All-inclusive also means you are not constrained by additional costs that can impact the success and popularity of your applications. The Oracle APEX Application Development Service, or APEX Service, is the fastest, lowest cost way to develop and deploy world-class applications. Your APEX Service can be ready in just a few minutes, and you will never have to worry about the complexity of (indistinct), load balancers, encryption, and more. APEX Service simplifies costs that are typically associated other low-code platforms. There is no complex pricing associated with the number of users, developers, or applications within your APEX Service. There are also no limits on the number of applications that can be developed, the number of developers using the service, or the number of end users using your applications. There are also no additional fee for data transfer into or out of your service. You can utilize Oracle REST Data Services to create custom REST APIs against your application data, and use Database Actions to compose SQL queries and graphically model data. Now is the time to learn Oracle APEX architecture. Oracle APEX uses a simple three-tier architecture, where requests are sent from the browser through a web server to the database. All processing, data manipulation, and business logic is executed within the database. This architecture guarantees zero latency data access, top performance, and scalability out of the box. A web request from the web browser is sent to Oracle REST Data Services, where it is handed to Oracle Database to be actioned. Within the database, the request is processed by Oracle APEX. Once the processing is complete, the result is sent back through Oracle REST Data Services to the browser. When you create or extend an application, APEX creates or modifies the metadata stored in the database tables. When the application is run, the APEX Engine then reads the metadata and displays the requested page, or processes page submissions. There is no need for file-based compilation, and there is no code generation at all. All processing is performed by PL/SQL acting directly on the data schemas in the database. Therefore, Oracle APEX applications are very efficient, as data is manipulated directly in the database, and the results are sent back to your web browser. A single API call invokes all of the necessary data processing based on the metadata definition in a single request, rather than requiring multiple calls to the database. Oracle REST Data Services, Autonomous Database, and APEX are available fully managed with Oracle Autonomous Cloud Services. You can deploy Oracle APEX applications wherever Oracle Database runs. APEX enables you to seamlessly shift applications to and from the Oracle Database Cloud Service, private and public clouds, on premise, and even the free public evaluation service. For example, you can develop an APEX application running on Windows on premises, and deploy it to Oracle APEX running in the cloud on Linux, or vice versa. In this lesson, you learned about various environments where Oracle APEX is available. You understood the powerful combination of APEX on Autonomous Database. You're also introduced to APEX Service. This lesson also covered Oracle APEX Architecture. And finally, you learned about Oracle APEX deployment options. This concludes the lesson on Oracle APEX availability and architecture. I hope you found it useful. Thank you for watching.