spacer

Webref WebRef   Sitemap · Experts · Tools · Services · Newsletters · About i.com

home / experts / xml / column19

XML, what for?

Database access

Web Designers with Mad Skills!
Aquent
US-CA-Los Angeles

Justtechjobs.com Post A Job | Post A Resume
Developer News
Google Chrome Playing Catch-Up on Extensions
Open Solutions Alliance Gets New Leadership
Red Hat Spacewalk Expands Linux Management

Most database APIs are defined in a particular programming language, so that results are returned in that language's native data types. While Standard Query Language (SQL) is a widely accepted (not quite standard) method for specifying the database "question," there is not yet a language-independent and database-neutral specification for the "response."

Most database vendors work on XML add-ons for their products, so that result sets are returned in XML form, separating rows and columns with corresponding tags. These results can then be turned into display information using XSL or some other transformation method.

Inter-application data exchange

Today many different applications exist in organizations, and most of them do not talk to each other. This way much time and effort is wasted on duplicate data entry and data integrity checking. In addition, the Web has created a world-wide infrastructure for communicating between applications (the Web server and the system behind it) and users (the person sitting behind the Web browser). This communication system can also be used between applications to exchange messages in a secure manner across the Internet. HTTP is the only protocol with decent firewall support, and since messages in XML format are plain text they can be transmitted as they are.

While text-based formats are less compact than binary representations, the human-readability of those messages make expensive tools for encoding and decoding them obsolete. Published DTDs can be the basis for software development with standard XML tools like parsers, editors, and XSL processors. In the future hopefully all software systems will come with built-in support for XML-based import and export of data.

Conclusion

XML is useful for many tasks outside the direct Web context, in Office documents, searching and indexing applications, databases and data exchange. In combination with the Web technologies we can achieve interoperability across application and organizational boundaries. Let's break down those barriers using XML!

http://www.internet.com

internet.comearthweb.comDevx.commediabistro.comGraphics.com

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info

Legal Notices, Licensing, Reprints, Permissions, Privacy Policy.
Advertise | Newsletters | Tech Jobs | Shopping | E-mail Offers

webref The latest from WebReference.com Browse >
Popular JavaScript Framework Libraries: An Overview - Part 3 · Accessing Your MySQL Database from the Web with PHP · Working with the DOM Stylesheets Collection
Sitemap · Experts · Tools · Services · Email a Colleague · Contact FREE Newsletters 
 The latest from internet.com
Review: Lenovo ThinkPad SL300 · OCZ PC3-10666 Gold 2x1GB Review · Apple Recommends Antivirus for Macs

Produced by Michael Claßen
All Rights Reserved. Legal Notices.

URL: http://www.webreference.com/xml/column19/2.html
Created: Sep 10, 2000
Revised: Sep 10, 2000