by John E. Simpson – Q: What namespace prefix should I use in a W3C Schema? Although the W3 Schema specification uses the namespace prefix xsd:, it looks as though in current practice only xs: is used. Could you please confirm if this is the case and is the reason just that it is shorter? A
Other News
SQL Server pressing Oracle on price
Oracle unquestionably is the 800-pound gorilla of database companies. But Microsoft’s SQL Server is mounting a serious challenge to the market leader.
Implementing CRUD Operations Using Stored Procedures: Part 1
By Andrew Novick – This two-part series discusses how to create stored procedures to implement the CRUD operations in SQL Server. This article concentrates on the rational behind using stored procedures and discusses many of the technical issues that are particular to SQL Server.
XML traffic to force major network upgrades
By Jim Rendon – As Web services become more common, companies will be forced to upgrade their networks to deal with growing amounts of bulky XML traffic, industry experts say.
Attributes in ContentHandler
by Brett McLaughlin – The one aspect of data processing with ContentHandler that the author didn’t cover in his last tip was attribute processing. While attributes are most commonly used for information transfer between an XML document and an XML processor, they also often contain valuable business
Primary keys in DB2
SearchDatabase.com ASK THE EXPERTS : Our group was debating the pros and cons of DB2 versus Unisys RDMS while trying to design some new tables. Our debate became a little heated (as tech conversations do sometimes). Could you resolve a few questions regarding the physical implementation of DB2 table
Creating Intelligent and Flexible Business Solutions
The first in a series of articles examines scenarios for creating dynamic and responsive business solutions by integrating business process management, business rules and business intelligence.
Preventing Public Access to the DB2 Database – Part 2
By Marin Komadina – Concerned about who is walking unchallenged through the Public group door into your database? Marin Komadina concludes his examination of the security aspects of the DB2 database default PUBLIC group.
Accounting system with source code and distribution rights
STFB Inc. is a provider of accounting systems complete with source code and distribution rights for Microsoft Access, VB, VB Dot Net, MSDE 2000, SQL Server and Internet Platforms.
Using Web Services to Provide Information to Remote Windows Applications
By Russ Nemhauser – This is the first of an intended two part article on using Web Services to provide information for a remote Windows application. In the article, the author shows how to create a Web service that provides information, then a Windows application that sits in the System Tray and mak