Database Development Zone

ML, Arrays, DataSets, database tables, collections of all types?all these have a common attribute; they are data stores that hold sets of data values or objects grouped together for some

onsider the following scenario. You have a production system that needs a lot of data from other systems on hand during the day. The data sources that you get this

nce in a while something comes along that is so simple, so straightforward, and so obvious that it’s amazing that nobody did it long ago. Take blogging, for example: People

ometimes we developers put unnecessary burden on the server, having it perform too many sorts or sort more data than necessary. By applying the techniques described in the following sections

ultiple Active Result Sets (MARS) is a new feature of ADO.NET 2.0 that allows multiple queries or stored procedures to be performed on a single connection. The result of this

racle’s COM automation feature lets Oracle PL/SQL or Java developers leverage any of the thousands of pre-existing COM components, as well as any pre-built, in-house COM components (See Sidebar 1:

igh-volume database traffic is a frequent cause of performance problems in Web applications. Hibernate is a high-performance, object/relational persistence and query service, but it won’t solve all your performance issues

ny database engine, whether it is IBM DB2 UDB, Oracle, or Microsoft SQL Server, depends on stored metadata for the normal operation of a database instance. In DB2 UDB, this

xperienced PL/SQL programmers and Oracle developers will learn to master Oracle’s procedural extension to industry-standard SQL. “Expert Oracle PL/SQL” should help you become expert at developing robust, high-performance enterprise applications