(Stéphane Faroult and Peter Robson) In this chapter, we are going to take a close look at the SQL query and examine how its construct can vary according to the tactical demands of particular situations. This will involve examining complex queries and reviewing how they can be decomposed into a succe
Other News
Migrating to IBM database servers gets easier with the latest MTK release
(Hemant Bhatia and Nicholas Geib) The free-of-charge Migration Toolkit (MTK) has long been a powerful tool for moving from non-IBM databases to IBM products. In December 2005, a new version of MTK was released, and it includes a number of new capabilities. It supports two new target databases (Infor
Discovery Card
(Michael S. Dougherty) Giving customers what they want is how companies stay in business. But, when it comes to e-commerce, that’s sometimes easier said than done.
Connecting People and Processes
(David Baum) Chris Haddad, manager of the Applications Platform Strategy Service consulting practice at Burton Group, recently talked to Oracle Magazine about how enterprise portals help workers collaborate as part of a modern information infrastructure.
PostgreSQL experts: Why are you still using a big bucks database
(MiMi Yeh) Your company doesn’t have to pay big bucks for a big database. If your apps are not completely chained to Microsoft, then you’ve got a chance to save money and get enterprise-level scalability, functionality and ease of use with open source PostgreSQL, say Robert Treat and Jason Gilmore,
Publish Data Using External Tables in Oracle 10g
(Arup Nanda) John Q. Public is a very angry man. As the vice president of operations at Insurance R Us, an international life insurance company, he is responsible for making sure the information flows rapidly and accurately among various entities inside the company to provide the adequate levels of
Hints and sorts
(Jonathon Lewis) There is white paper on OTN at present about the improved sorting algorithm used by Oracle in 10g Release 2. The file name of this paper is twp_general_sort_performance_10gr2_0605.pdf and, as the name indicates, it was written about six months ago to describe the general improvement
Determine the correct XML parser type for a Java application
(Padma Apparao) The benefits of XML spring primarily from the standard’s inherent flexibility and its suitability for use with any kind of data at any depth of complexity. The extensibility features of XML enable one to define new tags as needed. XML also provides validation checks for structural co
Using XML: A PHP Developer’s Primer, Part 3
(Adam Delves) In our last article, we touched the surface of Ajax by developing a simple email validation application. In this article we are going to delve deeper into Ajax and explore how XSL can be used on both the client side (using Javascript) and on the server (using PHP) to transform XML data
The Null Design Pattern
(Partha S) In this post, we’ll take a look at the Null Design Pattern. For all you guys who were about to shout – hey ! GoF book never had this , I agree. The Null Design pattern was not part of the original GoF book. It’s a very useful pattern nonetheless and definitely deserves mention.