, 1994) and today have progressed into the use of this communications standard to allow for full transaction support of tables regardless of where the database is actually residing. XML integration is extensively used for the updating fields, records and tables for each specific transaction completed. Where TCP/IPi¿½s more fundamental commands including using ftp shell scripts to retrieve and place files on servers were used in the past, today XML data integration standards are used for connecting databases into a more integrated platform (Roth, Hernandez,i¿½Coulthard,i¿½Yan,i¿½ et al., 2006). The implications of this from a database programming perspective is first, databases can now be transaction-oriented and less relegated to being just a repository of data. The transaction orientation has made the use of databases pervasive in distributed order management, content management and logistics applications, all of which are used in many e-commerce companies including Amazon.com for example. In addition, the use of XML programming is pervasive for streamlining databases as the basis for online catalogs and online ordering systems. Microsofti¿½s extensive use of SQL Server on their own websites globally is an example of this trend in database use. Microsoft also has their own internal supply chain and procurement system, MSMarket running on SQL Server. Comprised of several dozen SQL databases, MSMarket coordinates 60,000 different products that Microsoft regularly uses.
The catalyst of many organizations; reliance on IT systems to support their business strategies are the ability to parse, manipulate and manage database data, relying SQL commands to call stored procedures. The more structured the data, the more efficient and accurate SQL Server 2005 executes commands, yet this is in direct conflict with the need of many organizations in terms of
...