Dynamic PSP

Dynamic PSP (DPSP) is a development tool of web applications based on Oracle PL/SQL. Oracle PSP expansion.

The place in IT infrastructure

DPSP (Dynamic PSP)  is the interpreter and the compiler of server pages (PL/SQL Server Pages) intended for work in the environment of Oracle RDBMS and Oracle Application Server (OAS)/Oracle9i Application Server (iAS). DPSP is a simple, but effective remedy of development of web applications.

Architecture/subspecies

DPSP is constructed as a set of the modules interacting with each other for achievement of necessary functionality. So, by a call on accomplishment of the PSP page, the starting procedure (GO) causes Run-Time which, in turn, causes one of Preprocessors. The preprocessor generates the executed code from the source code and transfers him to the Core. The core creates the page environment including the CGI variables and call arguments and transfers the executed code to accomplishment to the necessary scheme of the project. In each scheme of the project supported by a core of DPSP the packet of Agent which starts the code of the page on accomplishment works. Accomplishment of the code of the page leads to generation of the output text (HTML, XML, WML, CSS and an entrance). This output text gathers Poison and is transferred further to HTTP gateway which returns the resulting page to the client.

DPSP is established in Oracle in the form of a set of packets PL/SQL and the classes Java. The scheme DB should be published for the Internet by means of iAS or means of a deliverable lock servlet of JOPA placed on any application server (Tomcat, Websphere, etc.). Creation and editing PSP pages and also other transactions over them, are performed via the Web interface so by machines of developers installation of any special software except the normal Web browser supporting HTML4.0/DHTML is not required. Oracle has the term 'PSP' with the same value too: ‘PL/SQL Server Pages’, however its implementation significantly differs from DPSP. Oracle PSP is submitted to us a little limited on the functionality therefore we also decided to create the own Oracle RDBMS/AS expansion. We called it Dynamic PSP (dynamic PSP) as this name best of all describes, чтó we wanted to receive and in what the main difference from oraklovsky approach consists. We hope that Dynamic PSP is a real alternative both for Oracle PSP, and for Oracle JSP.

Economic Efficiency

DPSP allows to create difficult interactive web applications, providing at the same time remote development thanks to the Web interface of the developer.

Connected subjects

Links

Official site