(Roger L. Costello) This document describes a way of designing XML Schemas which enables data to be collected (and stored as XML) in an independent, distributed fashion, and with no restrictions on the XML vocabulary. The design pattern that is presented is especially useful for situations where:
Other News
DB2 stored procedures and dynamic cursors
(Tim Albrecht) With a more complete implementation of stored procedures in DB2 Versions 5 and 6, many new distributed access opportunities have been given to the DB2 developer. Many shops, ours included, severely limited or completely denied Dynamic SQL access to operational Online Transaction proce
Review: SQL Deploy
(Mike Gunderloy) Here’s a problem many developers have faced: your application is out there with customers, it’s cranking along, and you’ve fixed some bugs or enhanced some features. Now you need to update the SQL Server database that it depends on, without losing customer data. You’ve got the SQL s
Approximate XML Joins
(Sudipto Guha, Divesh Srivastava, H.V. Jagadish, Nick Koudas and Ting Yu) XML is widely recognized as the data interchange standard for tomorrow, because of its ability to represent data from a wide variety of sources. Hence, XML is likely to be the format through which data from multiple sources i
University of Michigan and IBM Collaborate on Digital Asset Management
The University of Michigan has selected IBM to pursue a digital vision and to collaborate on a Digital Asset Management system in the Living Laboratory of the university’s Media Union. The two are working on the university classroom of the near future, where faculty and students find and use audio,
Oracle Plans Mid-market Push With 10g
(Barbara Darrow) Oracle says its upcoming database will do big things for mid-sized customers. A key goal Oracle10g, due by years’ end, is not only to bolster the company’s strong position in the enterprise but to out-maneuver Microsoft SQL server in smaller companies, said Andy Mendelsohn, seni
Inside Microsoft’s Longhorn plans
(Martin LaMonica) Is Microsoft’s new version of Windows a radical innovation or a return to the company’s winner-take-all software strategy from a decade ago? The next operating system, code-named Longhorn, promises a huge leap forward from current versions of Windows, with better graphics, stor
Tuning DB2: Where Your Data Is and Why it Matters
(Greg Nash) Database performance is one of those things that goes unnoticed, until it starts flagging. There are three broad areas relevant to database performance. Read more about it in this article.
Trace That Event with SQL Server Profiler
(Itzik Ben-Gan) Tracing client requests and server responses isn’t easy if you’re using SQL Server versions before 6.5. A freeware tracing tool called SQLEye, a network Open Data Services (ODS) sniffer, can do the job, but it’s hard to set up and complex to use, even for basic traces.
Storing object data as XML
(Brian Schaffner) One of the benefits of XML over other data formats is that it closely resembles the structure of object data. Because much of today’s design and development is object-based, it’s no surprise that when the data is being passed around, it is often represented as XML. However, when it