|
Overview :
A relational database management system (RDBMS) is a program that lets you create, update, and administer a relational database. Most commercial RDBMS's use the Structured Query Language (SQL) to access the database, although SQL was invented after the development of the relational model and is not necessary for its use. The leading RDBMS products are Oracle, IBM's DB2 and Microsoft's SQL Server.
Sub Technology/Tools: PL/SQL
PL/SQL provides the capability to deploy programming logic along with DML and DDL support. It is a powerful tool which enables a program to process large volume of data in a short span of time.
PL/SQL is Oracle's procedural extension to industry-standard SQL. PL/SQL naturally, efficiently and safely extends SQL. Its primary strength is in providing a server-side, stored procedural language that is easy-to-use, seamless with SQL, robust, portable and secure. Thus, it offers a platform for robust, high-performing enterprise applications.
EDPSoft has used PL/SQL scripting in all applications developed using Oracle and Microsoft's SQL Server as a backend. It has also applied PL/SQL codes to designing queries, fetching data for reports, forms, etc.
|