Our R&D Lab
Oracle database is an object-relational database management system. It supports all standard relational data types, as well as native storage of XML, Text, Documents, Images, Audio, Video and Location data. Access to data is via standard interfaces such as SQL, JDBC, SQLJ, ODBC .NET, OLE .NET and ODP .NET, SQL/XML and Xquery, and WebDAV.
Stored procedures can be written in Java, PL/SQL or using .Net CLR support in the Oracle Database. Also included are built-in analytical, statistical and modeling capabilities that can be used in any SQL-based Business Intelligence environment.
Oracle REST Data Services
Ex APEX Listener
Oracle REST Data Services (ORDS) are combined with Oracle Glassfish web server to establish connection between Oracle database and Oracle Application express. The ORDS is built in Java and is installed into a J2EE Web Server. ORDS is certified against Oracle Weblogic Server, Oracle Glassfish Server, and OC4J. ORDS provides several key capabilities for the Oracle Database. REST Data Services accepts RESTful Web Service call.
URLs and directs them to the appropriate SQL statement or PL/SQL block. REST Data Services marshals data returned from SQL statements into JSON or .csv format and also redirects calls to Application Express applications to the Application Express run-time engine. The J2EE implementation offers increased functionality including a web based configuration, enhanced security, and file caching.
Since Linxpot is a public and hosted environments Oracle REST Data Services is installed inside of the firewall, and the HTTP listener is installed outside of the firewall. The requests are sent to the external Web server and passed through the firewall to the REST Data Services.
User files (uploads) and application repository data are stored in primary and secondary application servers in conjunction with network attached storage allowing Linxpot to provide users higher storage capacity and flexibility for future upgrades to storage.
Oracle Application Express
Oracle Application Express consists of a metadata repository that stores the definitions of applications and an engine (called the Application Express engine) that renders and processes pages. It lives completely within Oracle database. It is comprised of nothing more than data in tables and large amounts of PL/SQL code. The essence of Oracle Application Express is approximately 425 tables and 230 PL/SQL packages containing 425,000+ lines of code.
The Application Express engine performs:
• Session state management
• Authentication services
• Authorization services
• Page flow control
• Validations processing
• Rendering and page processing
The asynchronous session state management architecture ensures the minimal CPU resources are consumed. The browser sends a URL request that is translated into the appropriate Oracle Application Express PL/SQL call. After the database processes the PL/SQL, the results are relayed back to the browser as HTML. This cycle happens each time one either requests or submits a page. The session state is managed in the database and does not use a dedicated database connection. Each page view results in a new database session, thus database resources are only consumed when the Application Express engine processes or renders a page. The Application Express engine is accessed from a Web browser through a Web server. Applications are rendered in real time from the metadata repository stored in database tables. Building or extending applications does not cause code to be generated; instead metadata is created or modified.