ABSTRACT
Embedded programming from the Oracle perspective: the primary indicators and the solution life cycle
What’s in and what’s not: Programming languages, platforms, and solution options available for an Oracle-based solution
The foundations: architecture, technologies, and methodologies for integration and interaction with Oracle
Oracle database-specific code versus non-Oracle 3GL and 4GL code in conjunction with SQL and PL/SQL: key differentiators
This chapter details the foundations of embedding and using nonOracle-based programming languages/applications, such as Java, C/C++, C#/J#, PHP/Ajax, Groovy, or HTML/XML, in those that are SQL/PL/ SQL-based to architect, build, deploy, and customize an Oracle11g-based end-to-end solution. Starting by identifying the key indicators necessary for the solution orientation, the chapter goes on to explain the end-to-end life cycle, categorized across three major dimensions: the business landscape, the technology landscape, and the programmer-to-implementer landscape. Then it describes the programming languages, platforms, and solution options supported for an Oracle11g-based solution, in terms of what’s in and what’s not. The third section outlines what’s involved in building the targeted solution so that it meets business needs and deploying it at a customer site (or using it otherwise). The chapter then discusses key points regarding what, how, and when to use the available options so that the resulting solution is a best fit for the business needs, and gives the betterbusiness-benefit (B-B-B) takeaway. Finally, the chapter highlights the key differentiators between SQL and PL/SQL code versus embedded programming language code (e.g., Java-based, .NET-based, PHP/Ajax-based, or
Perl-based) from a code design, coding, code design patterns, compilation, execution, and efficiency standpoint.
