(Mohd Abdul Moyeed) XML is definitely the best way to share data via the World Wide Web. I came across a situation where I needed to export the database table rows in XML file format. XML data can easily be integrated into web applications for many uses. However, at some point you want XML data adde
Other News
IBM’s Tony Higham fields questions about WebSphere Portal
Several weeks ago, Tony Higham, an executive IT architect in the WebSphere Portal Technology team at IBM, conducted a “residency” on TechTarget’s Expert Answer Center. During this two-week period, Higham entertained questions from TechTarget readers about WebSphere Portal. (R)
Proof that XML is extremely bloated
(George Ou) When I wrote this blog blasting the massive bulk of XML, our own John Carroll responded with a defense of XML for some situations. John and I both agree that XML should not be used to handle large amounts of data because of increased storage and processing requirements, we only disagree
Building ASP.NET 2.0 Web Sites Using Web Standards
(Stephen Walther) Microsoft ASP.NET 2.0 has many features to help you design and build Web sites that are compliant with XHTML and accessibility standards. This article looks at how and why you should be building these standards-compliant sites.
PostgreSQL SQL Syntax and Use (Sample Chapter)
(Korry Douglas) This chapter covers the basic operation of PostgreSQL, including naming conventions, creating a database, and indexing. When you finish with it, you should be able to use PostgreSQL for most basic functions.
Recommended reading list: DB2 UDB for Linux, UNIX, and Windows application development
(Cindy Wong and Samuel Poon) This article provides a list of DB2 UDB for Linux, UNIX, and Windows application development materials available on the Internet. The DB2 UDB Information Center is also a good source of information. Many of the items listed below are published as articles on IBM develope
Optimize Result Set Retrieval Using ODP.NET and Ref Cursors
(Mark A. Williams) There are several ways to return query results from an Oracle database to a client application, using Oracle Data Provider for .NET; one of the most powerful, flexible, and scalable methods is to use ref cursor. This article introduces ref cursors and why they are useful, incl
Processing XML with Xerces and the DOM
(Ethan McCallum) From data storage to data exchange and from Perl to Java, it’s rare to write software these days and not bump into XML. Adding XML capabilities to a C++ application, though, usually involves coding around a C-based API.
SQL Server 2005 – SQL Server Integration Services – Part 8
(Marcin Policht) We are continuing our overview of different types of enumerators available in the Foreach Loop Container of SQL Server 2005 Integration Services. The ones covered so far provided the ability to iterate over a set of files matching an arbitrary set of criteria (Foreach File Enumerato
Choosing a database partitioning method
(Hilary Cotter) Partitioning is the distribution of a table over multiple subtables that may reside on different databases or servers in order to improve read/write performance. Partitioning is typically done at the table level, and a database is considered partitioned when groups of related tables