Oracle Embedded Programming and Application Development

Focusing on tried and true best practice techniques in cross-technology based Oracle embedded programming, this book provides authoritative guidance for improving your code compilation and execution. Geared towards IT professionals developing Oracle-based Web-enabled applications in PL/SQL, Java, C, C++, .NET, Perl, and PHP, it covers application development from concepts to customization, following a pragmatic approach to design, coding, testing, deployment, and customization—explaining how to maximize embedded programming practices. Oracle Embedded Programming and Application Development explains application development frameworks using 3GL and 4GL high-level language code as embedded code segments across .NET, Java, and Open Source technologies, in conjunction with SQL and/or PL/SQL and the Oracle RDBMS through version 11gR2. It also: Features pluggable code using parameterized constructs to promote code reuse Explains when to use a particular embedded language as a best fit for specific applications Highlights design considerations that reduce the probability of errors, enable quick resolution, and boost performance in terms of enabling a Fast-Actionable-Synchronized-Tested (FAST) solution implementation Provides best practice techniques that can enhance any application development code-design methodology for a better, easier, faster, cheaper, and pervasive solution that in turn helps achieve a Better Business Benefit (B-B-B) This practical guide details techniques for constructing architecture and code design methodologies for live application development projects that can be generalized and standardized as application development and code design frameworks. Cover to cover, the text provides an understanding of how the designed, developed, and deployed solutions conform to emerging and next-generation trends. It also discusses the conformance and usage of Web 2.0-based RIA functionality and regulatory compliance practices involving auditing and security. Praise for: "Taking an Oracle-centric approach, Lakshman skillfully guides you through the maze of various popular programming languages and environments including .NET, C/C++, Perl, PHP, Java, and even SQL and PL/SQL – not only showing you how they interact with Oracle but also which language is the best fit for a given situation."—John Kanagaraj, Executive Editor, IOUG SELECT Journal

INTRODUCTORY CONCEPTS Embedded Programming—An Oracle-Centric ApproachEmbedded Programming from the Oracle Perspective: The Primary Indicators and the Solution Life CycleWhat’s In and What’s Not: Programming Languages, Platforms, and Solution Options Available for an Oracle-Based SolutionThe Foundations: Architecture, Technologies, and Methodologies for Integration and Interaction with OracleOracle Database-Specific Code Versus Non-Oracle 3GL and 4GL code in Conjunction with SQL and PL/SQL: Key Differentiators Feature-Set and Solution-Set EnhancementsNew feature and solution options in Oracle11gNew feature and solution options in Oracle10g BEST PRACTICES BY WAY OF DESIGN AND DEVELOPMENT Programming Languages, Platforms, and Solutions: Best Practices in Terms of Choice and Suitability—How Best Is the "Best"?Why and when architecture takes precedence over feature setBest practices in terms of Oracle database interactionBest practices for using SQL and PL/SQL only (with HTML, XML via PSP, or Web Toolkit)Best practices for using .NET based languages (C++, C#)Best practices for using Java-based languages (Java Libraries, Java via JDBC, Java via SQLJ, Java via Java Stored Procedures)Best practices for using PHP-based languages (PHP-only, PHP and AJAX, PHP Web pages) Perl in the picture—best practices for the perfect fit and use of Perl in an embedded scenarioFor better or worse: Application-centric and business-centric key performance indicatorsBest Practices for Data Structure ManagementData representation: database versus programming language perspectivesBest practices for using heterogeneous data structures: arrays, array lists, lists, maps, enumerationsBest practices for using LINQ to objects (in Oracle11g)Best practices for using objects as data structuresBest Practices for meta-programming: use or eliminate Best Practices for Robust Error Detection and HandlingBest design practices to reduce the probability of errors and enable quick resolutionTechniques to obtain complete error informationTechniques to customize the error information returnedTechniques for halting further processing on error occurrence Best Practices for Data ManagementDatabase management using embedded programming languages – Design Practices for best degree of fitBest practices in terms of Connectivity and Interactivity to the Oracle databaseTechniques to connect to multiple databases simultaneously using same meta-dataBest fit for Oracle in the ADO.NET Framework – ODP.NET, ODE.NET Best Practices for Data RetrievalBest Practices for Data ManipulationBest Practices for using LINQ to SQLBest Practices for Data validationBest Practices for using XML Best Practices for Handling Unstructured DataBest Practices to protect data integrity and special cases involved Best Practices for Application ManagementCode Accelerators for Rapid Application Development & Management: Design, and coding aspectsBest Practices for Application IntegrityBest Practices for Application ConsistencyBest Practices for Application Web Interaction: Receiving, Routing, Responding, Redirecting, Rendering, LinkingBest practices for Security beyond User Authentication – End-to-End Application SecurityBest fit for Oracle in the ASP.NET FrameworkBest Practices for Templates: use or eliminateBest Practices beyond HTML – Auto-generate dynamic visual content, Web Services, and Mobile ApplicationsBest Practices for Creative Reporting APPLYING EMBEDED PROGRAMMING IN THE REAL WORLD Application Development FrameworksApplication Development Framework – A Pragmatic "best possible" solution Next Generation Web Framework for Interaction and Intercommunication with Internet, Web Services and E-mailMaster Error Management FrameworkMaster Audit Management FrameworkPerformance Tuning FrameworkDebugging Framework Miscellaneous Best PracticesSimulating Oracle-based datasets – Best practices for design and codingBuilding a highly visible website Best Practices in Terms of Coding Standards and TroubleshootingCoding Standards from an Oracle11g embedded programming perspectiveTuning SQL & PL/SQL Code for optimalityTuning embedded language code for optimality-Data Structures and Procedural CodeFine Tuning Solution methodology for optimality

Lakshman Bulusu hasmore than 16 years of experience in the management, supervision, mentoring, review, design and development of Oracle Database, Data Warehousing Business Intelligence , and application development related projects. He is well versed in the primary Oracle technologies through Oracle11g using SQL and PL/SQL; Oracle-related embedded programming, including design and development of Web applications, that are PL/SQL based, .NET based, Java based, Open source based (using Perl, PHP and AJAX) and C, C++ based; Oracle tools like Oracle SQL Developer Data Modeler, Oracle Designer, Oracle Developer Suite, Oracle Warehouse Builder, ODI, etc. His design of Application Development Frameworks using PL/SQL, from design andcoding to testing, debugging, andperformance tuning has been implemented forFortune 500 clients in the US.