- Shopping Bag ( 0 items )
Other sellers (Hardcover)
-
All (5) from $79.71
-
New (3) from $79.71
-
Used (2) from $112.13
More About This Textbook
Overview
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:
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
Editorial Reviews
From the Publisher
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
Product Details
Meet the Author
Lakshman Bulusu has more 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 and coding to testing, debugging, and performance tuning has been implemented for Fortune 500 clients in the US.
Table of Contents
Foreword
Acknowledgements
About the Author
Introduction
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.2 DBMS JAVA.SET_OUTPUT 36
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