Database Applications - IT Library : ZDNet Asia

White Papers

Case Studies

Vendor Webcast

Show all content

Title Date Added Company

PHP 5, Oracle, and the Future 2006-10-17 01:00:14 Oracle

Since PHP 4 featuring the Zend Engine was so successful, why do users even need PHP 5 and the Zend Engine II? The truth is that there are certain areas in which PHP 4 does not excel. Most of these areas are more important for large projects and companies, where project management is more structured and interoperability between systems is a must. PHP 5 addresses these issues, allowing PHP not only to be more attractive for such projects but also to remain a leading technology for Web application development. This paper addresses the reasoning behind PHP 5. It provides a short overview of some of its new features and takes a brief look at the future for PHP and Oracle users.

The DeployPHP Series, Part 1: Optimizing PHP and Oracle 2006-10-17 01:00:14 Oracle

The open-source language PHP: Hypertext Preprocessor (PHP) powers some of the most popular Web sites in the world, such as Yahoo!, Lufthansa, and Disney Online. This fact is even more remarkable when a person considers that PHP does so much with so little. As a PHP developer, one knows that the database is probably the most important component with which he or she will be interacting. In this first paper in the DeployPHP Series, the author discusses the checklist for developing and deploying powerful and scalable PHP applications on Oracle.

Generate External Tables From an Excel Spreadsheet Using Apache Jakarta POI 2006-10-17 01:00:14 Oracle

DBAs and application developers frequently face the task of loading data from Excel spreadsheets into Oracle databases. With the advent of Oracle 10g's spreadsheet-like model capabilities, it is likely that more data that is currently stored and viewed in spreadsheets will be loaded into Oracle databases for manipulation and processing. Oracle provides a variety of methods for loading data from a spreadsheet into a database. Most Oracle DBAs and developers are familiar with the capabilities of SQL*Loader. Oracle HTML DB can be used to load Excel data in batch as well. This paper presents and alternative method for loading data from an Excel spreadsheet that takes advantage of open source technology and external tables.

Scaling Oracle and PHP 2006-10-17 01:00:14 Oracle

Over the past few years, PHP has evolved from being a niche language for putting together personal Web sites to powering some of the world's largest and most highly trafficked sites. The three most important design aspects of any high-traffic Web site are scalability, performance, and maintainability. Tackling these three design goals with PHP is not difficult, but it does require forethought into how the application is structured and built. The topic of writing manageable, scalable, and fast PHP code is a broad one. This paper discusses the factors that directly relate to using Oracle with PHP.

Enterprise Application Development Using PHP and Oracle 2006-10-17 01:00:14 Oracle

At McGill University's (Montreal, Quebec, Canada) Department of Development and Alumni Relations, the authors are in the process of moving extensive, multifaceted services for 200 to 300 paid and volunteer staff and up to 160,000 alumni and donors to the Web using an industrial-strength PHP application and Oracle9i. It is expected that the program will accommodate tens of thousands of users per hour following major e-broadcasts. They are doing this using Oracle's powerful row-level security features and PHP's high performance and quick development platform. This paper addresses the background, why the authors chose PHP, Oracle9i, Apache, and Linux, structure of the application, security, synchronization, lessons learned and advice to developers.

Setting Up Oracle Database 10g and PHP on Mac OS X 2006-10-17 01:00:14 Oracle

Oracle, Mac OS X, and open source technologies such as Apache, PHP and gqlplus make for an enjoyable, productive, and stable development environment. Now that Mac OS X is an officially supported platform for the Oracle Database, IT departments can take a serious look at migrating developer workstations and servers to Macs. The following paper helps the reader to set up a development workstation with the Oracle Database, PHP compiled with OCI support, and a more productive wrapper for SQL*Plus.

PHP and ASP.NET Go Head-to-Head 2006-10-17 01:00:14 Oracle

When it comes to Web development these days, there is lot of options available. Many of these methods involve preprocessing - that is, embedding code into HTML pages with special tags that signal to a preprocessor that they contain code, and that it should do something with it. Much like a CGI, this code is then run on the server, and it returns some content, which then assumes part of the shape of the resulting HTML page sent back to the browser. Both the open source scripting language PHP and languages within Microsoft's ASP.NET framework fall into this category. This paper focuses on PHP, the technology Oracle has chosen to incorporate into its products, and ASP.NET.

DeployPHP Series, Part 4: Using the PEAR::MDB2 Database Abstraction Layer With Oracle 2006-10-17 01:00:14 Oracle

PEAR (PHP Extension and Application Repository) is a huge collection of high-quality PHP components. The repository contains PHP classes for almost any imaginable purpose, from database authentication, to networking, to images, to XML. This paper describes how to use MDB2, a high-level database abstraction layer that can be found in PEAR.

DeployPHP Series, Part 2: Bringing Data Security to PHP Applications 2006-10-17 01:00:14 Oracle

Using PHP to build a Web-based, database-driven application is an increasingly popular way to give trusted users easy access to corporate data. However, the PHP developers must acknowledge that linking sensitive and often mission critical data to an application accessible outside the corporate network is a serious security risk. At Department of Alumni Relations of McGill University, the author has chosen to combine Oracle's industrial-strength security with PHP's ease of development to ensure data availability without incurring the risk of compromising the security of the entire database. This paper highlights the major steps in building and deploying such a solution and walk through the code of a sample application.

Building Database-Driven PHP Applications on Oracle XML DB 2006-10-17 01:00:14 Oracle

Although, when working with Oracle XML DB from the PHP scripting language, one can still process XML data on the client side by using PHP's XML extensions, there are many advantages to processing XML content inside the database. Moving the XML processing to the database tier is particularly useful when a person is dealing with large XML documents stored in the database. This paper explains how to take advantage of XMLType views when a person needs to wrap existing relational or object-relational data in XML formats.

Jump to 1 [2] 3 4 5 6 7 8 9 10

Title	Date Added	Company
PHP 5, Oracle, and the Future	2006-10-17 01:00:14	Oracle
Since PHP 4 featuring the Zend Engine was so successful, why do users even need PHP 5 and the Zend Engine II? The truth is that there are certain areas in which PHP 4 does not excel. Most of these areas are more important for large projects and companies, where project management is more structured and interoperability between systems is a must. PHP 5 addresses these issues, allowing PHP not only to be more attractive for such projects but also to remain a leading technology for Web application development. This paper addresses the reasoning behind PHP 5. It provides a short overview of some of its new features and takes a brief look at the future for PHP and Oracle users.
The DeployPHP Series, Part 1: Optimizing PHP and Oracle	2006-10-17 01:00:14	Oracle
The open-source language PHP: Hypertext Preprocessor (PHP) powers some of the most popular Web sites in the world, such as Yahoo!, Lufthansa, and Disney Online. This fact is even more remarkable when a person considers that PHP does so much with so little. As a PHP developer, one knows that the database is probably the most important component with which he or she will be interacting. In this first paper in the DeployPHP Series, the author discusses the checklist for developing and deploying powerful and scalable PHP applications on Oracle.
Generate External Tables From an Excel Spreadsheet Using Apache Jakarta POI	2006-10-17 01:00:14	Oracle
DBAs and application developers frequently face the task of loading data from Excel spreadsheets into Oracle databases. With the advent of Oracle 10g's spreadsheet-like model capabilities, it is likely that more data that is currently stored and viewed in spreadsheets will be loaded into Oracle databases for manipulation and processing. Oracle provides a variety of methods for loading data from a spreadsheet into a database. Most Oracle DBAs and developers are familiar with the capabilities of SQL*Loader. Oracle HTML DB can be used to load Excel data in batch as well. This paper presents and alternative method for loading data from an Excel spreadsheet that takes advantage of open source technology and external tables.
Scaling Oracle and PHP	2006-10-17 01:00:14	Oracle
Over the past few years, PHP has evolved from being a niche language for putting together personal Web sites to powering some of the world's largest and most highly trafficked sites. The three most important design aspects of any high-traffic Web site are scalability, performance, and maintainability. Tackling these three design goals with PHP is not difficult, but it does require forethought into how the application is structured and built. The topic of writing manageable, scalable, and fast PHP code is a broad one. This paper discusses the factors that directly relate to using Oracle with PHP.
Enterprise Application Development Using PHP and Oracle	2006-10-17 01:00:14	Oracle
At McGill University's (Montreal, Quebec, Canada) Department of Development and Alumni Relations, the authors are in the process of moving extensive, multifaceted services for 200 to 300 paid and volunteer staff and up to 160,000 alumni and donors to the Web using an industrial-strength PHP application and Oracle9i. It is expected that the program will accommodate tens of thousands of users per hour following major e-broadcasts. They are doing this using Oracle's powerful row-level security features and PHP's high performance and quick development platform. This paper addresses the background, why the authors chose PHP, Oracle9i, Apache, and Linux, structure of the application, security, synchronization, lessons learned and advice to developers.
Setting Up Oracle Database 10g and PHP on Mac OS X	2006-10-17 01:00:14	Oracle
Oracle, Mac OS X, and open source technologies such as Apache, PHP and gqlplus make for an enjoyable, productive, and stable development environment. Now that Mac OS X is an officially supported platform for the Oracle Database, IT departments can take a serious look at migrating developer workstations and servers to Macs. The following paper helps the reader to set up a development workstation with the Oracle Database, PHP compiled with OCI support, and a more productive wrapper for SQL*Plus.
PHP and ASP.NET Go Head-to-Head	2006-10-17 01:00:14	Oracle
When it comes to Web development these days, there is lot of options available. Many of these methods involve preprocessing - that is, embedding code into HTML pages with special tags that signal to a preprocessor that they contain code, and that it should do something with it. Much like a CGI, this code is then run on the server, and it returns some content, which then assumes part of the shape of the resulting HTML page sent back to the browser. Both the open source scripting language PHP and languages within Microsoft's ASP.NET framework fall into this category. This paper focuses on PHP, the technology Oracle has chosen to incorporate into its products, and ASP.NET.
DeployPHP Series, Part 4: Using the PEAR::MDB2 Database Abstraction Layer With Oracle	2006-10-17 01:00:14	Oracle
PEAR (PHP Extension and Application Repository) is a huge collection of high-quality PHP components. The repository contains PHP classes for almost any imaginable purpose, from database authentication, to networking, to images, to XML. This paper describes how to use MDB2, a high-level database abstraction layer that can be found in PEAR.
DeployPHP Series, Part 2: Bringing Data Security to PHP Applications	2006-10-17 01:00:14	Oracle
Using PHP to build a Web-based, database-driven application is an increasingly popular way to give trusted users easy access to corporate data. However, the PHP developers must acknowledge that linking sensitive and often mission critical data to an application accessible outside the corporate network is a serious security risk. At Department of Alumni Relations of McGill University, the author has chosen to combine Oracle's industrial-strength security with PHP's ease of development to ensure data availability without incurring the risk of compromising the security of the entire database. This paper highlights the major steps in building and deploying such a solution and walk through the code of a sample application.
Building Database-Driven PHP Applications on Oracle XML DB	2006-10-17 01:00:14	Oracle
Although, when working with Oracle XML DB from the PHP scripting language, one can still process XML data on the client side by using PHP's XML extensions, there are many advantages to processing XML content inside the database. Moving the XML processing to the database tier is particularly useful when a person is dealing with large XML documents stored in the database. This paper explains how to take advantage of XMLType views when a person needs to wrap existing relational or object-relational data in XML formats.