 |
|
ss
Oracle Tips by Burleson |
Two Phase
Commit
Two phase commit is the tool used for handling
distributed databases. If transaction modifies objects in more then
one database, a single “two phase commit” can commit changes in both
databases. Oracle achieves this by splitting commit in two phases:
first, each database involved in the transaction is sent “prepare for
commit” request. When all involved databases respond with “ready”
message, a commit request is sent to every database participating in
the transaction. To be able to issue such distributed commits, the
tool must implement the transaction interface, embodied in so called
XA library. This library is standard and defines operations utilized
by TP monitors like Encina, Top End, Tuxedo or CICS. PHP5 does not
implement the standard transaction interface, as web servers normally
aren't utilized as TP monitors.
Web applications are expected to have certain look
and feel. These applications are expected to have rapid response and
to deal primarily with the interactive data, entered by the end user
himself. Web applications are not batch applications designed to
perform large calculations or manipulate extremely large quantities of
data. Oracle features designed to speed up large batch applications
were left out of the implementation at this point. This is not to say
that these features will not be added in some future implementation,
as both World Wide Web and Oracle RDBMS
are undergoing daily changes and development.
Zend Corp. has developed, in partnership with
Oracle Corp. the product called Zend Core for
Oracle which simplifies the installation and fixes many of the bugs
which one can come across in an open source version. Zend Core for
Oracle is pre-built version of PHP5 with a GUI installer which makes
it possible to pick and choose the desired modules, without tedious
and complex software rebuilding effort. Initial reactions to Zend
Core for Oracle are more then enthusiastic. By all means, it’s a
wonderful product. Future for PHP and Oracle looks very bright.
See
code depot for complete scripts
The above book excerpt is from:
Easy Oracle
PHP
Create Dynamic Web Pages with Oracle Data
ISBN
0-9761573-0-6
Mladen Gogala
http://www.rampant-books.com/book_2005_2_php_oracle.htm
|
