Oracle Embedded Programming and Application Development / Edition 1

Oracle Embedded Programming and Application Development / Edition 1

by Lakshman Bulusu

ISBN-10: 1439816441

ISBN-13: 9781439816448

Pub. Date: 09/08/2010

Publisher: Taylor & Francis

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

…  See more details below


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

Read More

Product Details

Taylor & Francis
Publication date:

Table of Contents



About the Author


What This Book Covers

Who is This Book For?

Why a Separate Book?

Chapter 1 Embedded Programming An Oracle-Centric Approach 1

1.1 Embedded Programming from an Oracle Perspective: The Primary Indicators and the Solution Life Cycle 2

1.2 What's In and What's Not: Programming Languages, Platforms, and Solution Options Available for an Oracle-Based Solution 3

1.2.1 Using .NET-Based Languages 5

1.2.2 Using Java-Based Languages (Java Libraries, Java via JDBC, Java via SQLJ, Java via Java Stored Procedures) 6

1.2.3 Using PHP-Based Languages (PHP-only, PHP and Ajax, PHP Web Pages) 9

1.2.4 The Foundations: Architecture, Technologies, and Methodologies for Integration and Interaction with Oracle 11

1.3 Oracle Database-Specific Code versus Non-Oracle 3GL and 4GL code in Conjunction with SQL and PL/SQL: Key Differentiators 15

1.3.1 Data Processing Differentiators 16

1.3.2 Data Sharing Differentiators 17

1.3.3 Code Manageability Differentiators 18

1.3.4 Error Handling Differentiators 19

1.3.5 Other Key Differentiators 19

Chapter 2 Feature-Set and Solution-Set Enhancements 23

2.1 Introduction 23

2.2 New Feature and Solution Options in Oracle11g 23

2.2.1 SQL/PL/SQL 23

2.2.2 New Functionalities That Benefit the Enterprise Grid 31

2.2.3 PHP/Ajax 32

2.2.4 Oracle, .NET and C# 33

2.2.5 Java 34

2.2.6 XML 35

2.3 New Feature and Solution Options in Oracle10g 35

2.3.1 Regular Expressions 35


2.3.3 Tracking the Error Line Number 36

2.3.4 Enhanced FORALL Statement for Handling DML Array Processing with Sparse Collections 39

2.3.5 Conditional Compilation (Oracle 1OGR2) 40

2.3.6 Compile-Time Warnings 41

2.3.7 Integrated mod_plsql 42

Chapter 3 Programming Languages, Platforms, and Solutions 43

3.1 Introduction 43

3.2 Why and When Architecture Takes Precedence over Feature Set 44

3.2.1 Suitability Criteria from a Business/Customer Perspective 49

3.2.2 Suitability Criteria from a Solution Architecture (Technical/Techno-Functional) Perspective 50

3.3 Best Practices in Terms of Oracle Database Interaction 53

3.3.1 Enforcing Business Rules for Efficiency 56

3.3.2 Pre-emptive and Proactive Measures 57

3.3.3 Database Interaction: More than Just GB and Data Quality 58

3.4 Best Practices for using SQL and PUSQL only (with HTML, XML via PSP or Web Toolkit) 59

3.5 Extending PUSQL to Use Emerging Dynamic Scripting Languages Like Groovy in the Database 61

3.5.1 Extending PUSQL to Use HTMUXML 61

3.5.2 Generating Web-Enabled PUSQL Applications Using Oracle APEX/Oracle JDeveloper 65

3.6 Best Practices for Using .NET-Based Languages (C++, C#, J#) 66

3.6.1 ODP.NET: More than Just ADO.NET Rehashed 66

3.6.2 Leverage J2EE Inherent Server-Specific Benefits with Minimal Cost and Time-to-Deliver 67

3.7 Best Practices for Using Java-Based Languages aava Libraries, Java via JDBC, Java via SQLJ, Java via Java Stored Procedures) 69

3.7.1 Using Java via JDBC, SQLJ, Java Stored Procedures or Java Libraries 73

3.8 Best Practices for Using PHP-Based Languages (PHP-only, PHP and Ajax, PHP Web Pages) 75

3.9 Perl in the Picture: Best Practices for the Perfect Fit and Use of Peri in an Embedded Scenario 77

3.10 For Better or Worse: Application-centric and Business-centric Key Performance Indicators 78

3.10.1 Focus on the Customer 78

3.10.2 Application-Centric 79

Chapter 4 Best Practices for Data Structure Management 83

4.1 Introduction 83

4.2 Data Representation: Database versus Programming Language Perspectives 85

4.2.1 Database Implementation 93

4.2.2 Programming Language Implementation 94

4.3 Best Practices for Using Heterogeneous Data Structures: Arrays, Array Lists, Lists, Maps, Enumerations 95

4.3.1 Design of a Code Accelerator that Uses Optimized Data Structures for Efficient Data as Well as Data Structure Management 98

4.4 Best Practices for Using LINQ to Objects (in Oracle11g) 100

4.4.1 How does LINQ fit in the Oracle11g-.NET space? 101

4.4.2 Best Uses of ODP.NET LINQ to Objects in Oracle11g 103

4.5 Best Practices for Using Objects as Data Structures 104

4.5.1 Code Accelerator for the Consolidation of Data based on Type Granularity 105

4.6 Best Practices for Metaprogramming: Use or Eliminate 107

Chapter 5 Best Practices for Robust Error Detection and Handling Management 111

5.1 Introduction 111

5.2 Best Design Practices to Reduce the Probability of Errors and Enable Quick Resolution 113

5.2.1 Design Pattern for a Typical Error-Handling Code Accelerator 118

5.2.2 Best Practices in Terms of Tracking and Trapping Errors 122

5.3 Techniques to Obtain Complete Error Information 128

5.3.1 Tracking Error Information for Database Errors (Occurring in Any Tier) 130

5.4 Techniques to Customize the Error Information Returned 131

5.4.1 Database Errors 131

5.4.2 Programming Language Specific Errors (Not Related to Oracle Server Errors) 132

5.5 Techniques for Halting Further Processing on Error Occurrences 133

Chapter 6 Best Practices for Data Management 135

6.1 Introduction 135

6.2 Database Management Using Embedded Programming Languages: Design Practices for the Best Degree of Fit 140

6.3 Best Practices in Terms of Connectivity to and Interaction with the Oracle Database 144

6.4 Techniques to Connect to Multiple Databases Simultaneously Using the Same Metadata 148

6.5 Best Fit for Oracle in the ADO.NET Framework-ODP.NET and ODE.NET 150

6.6 Best Practices for Data Retrieval 150

6.7 Best Practices for Data Manipulation 153

6.8 Best Practices for Data Validation 155

6.9 Best Practices for using LINQ to SQL 158

6.10 Best Practices for Using XML 158

6.11 Best Practices for Handling Unstructured Data 162

6.12 Best Practices to Protect Data Integrity and Special Cases Involved 165

6.12.1 User Interaction with Data (and hence with the Database) 166

6.12.2 Special Cases Involved 171

6.12.3 Application Interaction with Data (and hence with the Database) 171

6.12.4 Design Pattern for a Typical Code Accelerator 176

Chapter 7 Best Practices for Application Management 181

7.1 Introduction 181

7.2 Code Accelerators for Rapid Application Development: Design and Coding Aspects 183

7.2.1 Code Accelerator Design Pragmatics 187

7.3 Best Practices for Application Web Interaction: Receiving, Routing, Responding, Redirecting, Rendering, Linking 196

7.3.1 Personalized A-La-Carte of Customer/End-User Service Requests: A Real-World Use Case of Application Web Interaction 199

7.4 Best Practices for Application Integrity 200

7.4.1 A Design Pattern for a Common Information Integrity Framework at the End-to-End Solution Level 201

7.5 Best Practices for Application Consistency 204

7.5.1 Multitenancy of Data Services Calls, Web Services Calls, and Java Services Calls 205

7.5.2 A Real-World Scenario that Demonstrates the Use of These Best Practices for Implementation 208

7.6 Best Practices for Security Beyond User Authentication: End-to-End Application Security 209

7.6.1 Real-World Use Cases for Implementing Web Security Policies 214

7.7 Best Fit for Oracle in the ASP.NET Framework 216

7.8 Best Practices for Templates: Use or Eliminate? 220

7.9 Best Practices Beyond HTML: Auto-generate Dynamic Visual Content, Web Services, and Mobile Applications 221

7.9.1 Auto-generate Dynamic Visual Content 221

7.9.2 Web Services 225

7.9.3 Mobilizing Applications 226

7.10 Best Practices for Creative Reporting 227

Chapter 8 Application Development Frameworks 237

8.1 Introduction 237

8.2 Application Development Framework: A Pragmatic "Best-Possible" Solution 238

8.2.1 For a Transactional Solution 240

8.2.2 For a Reporting and Analysis Solution 243

8.3 Master Error Management Framework 251

8.3.1 Error-Logging Framework 251

8.3.2 DML Auditing Framework 261

8.4 Performance Tuning Framework 273

8.4.1 Framework for Monitoring and Tuning SQL 274

8.4.2 Framework for Monitoring and Tuning PL/SQL 277

8.5 Debugging Framework 280

8.5.1 Putting a Robust Error-Handling Mechanism in Place 281

8.5.2 Introducing Debug Messages as Part of Code Asynchronously 281

8.5.3 Testing of the Application Solution 294

Chapter 9 Miscellaneous Best Practices 297

9.1 Simulating Oracle-Based Datasets: Best Practices for Design and Coding 297

9.1.1 The In-Memory Processing Framework 298

9.1.2 Simulating Oracle-Based Data Sets Using Transformation Pipeline Chain 302

9.2 Building a Highly Visible Web Site 307

Chapter 10 Best Practices in Terms of Coding Standards and Troubleshooting 315

10.1 Introduction 315

10.2 Coding Standards from an Oracle11g Embedded Programming Perspective 316

10.3 Tuning SQL and PL/SQL Code for Optimality 321

10.4 Tuning Embedded Language Code for Optimality: Data Structures and Procedural Code 330

10.5 Fine-Tuning Solution Methodology for Optimality 333

Index 339

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network


Most Helpful Customer Reviews

See all customer reviews >