by Joe Lax – SQL Server and Oracle each have very different methods for maintaining data constancy when accessed by concurrent users. Oracle maintains a snapshot of the data, which prevents queries from hanging without stooping to "dirty reads." Find out how it works.
Other News
Quilt: An XMLQuery Tutorial
by Javier Lozano – This is a paper written by Don Chamberlin, the father of SQL. It gives a nice overview of Quilt, a query language for heterogenous data sources. The paper goes through and explains how to use the syntax of quilt along how it can be modeled to a mimic a relational database. It has
dtddoc step 2: Internal data structures
After parsing XML DTDs with four different software packages, we will look at the resulting data structures in Java, Perl, and PHP, respectively.
A Tour of 4Suite
by Uche Ogbuji – In this article and the next, I’ll introduce just the basic Python library portion of 4Suite, which includes facilities for XML parsing (complementing PyXML), RELAX NG, XPath, XPatterns, XSLT, RDF, XUpdate and more. If you are unfamiliar with any of these technologies, see the resou
Oracle Releases TopLink Upgrade, Road Map
Oracle has released an updated version of the TopLink Java development tool it recently acquired from WebGain, along with a road map pledging continued TopLink support for competitors’ databases and application servers.
Using SQL’s EXISTS Predicate to Identify Missing Data
Sometimes knowing that data is missing is just as important as finding data that exists. Use SQL’s EXISTS predicate to select data based on the presence (or absence) of other values.
Novell to Include MySQL in NetWare 6
By Peter Galli – Network software stalwart Novell Inc. is planning to ship a commercial version of the open-source MySQL database, which has been optimized for its NetWare 6 network operating system, by the end of the year.
Troubleshooting DTS Problems
In his latest article, Alexander Chigrik presents a checklist of troubleshooting tips to find potential solutions should you have problems working with Data Transformation Services (DTS) in SQL Server.
Tablespace Usage – Revised
by Karen Kolbe – I picked this script off the internet 4-5 years ago. The previous version had created 2 views for the final select, but I have incorporated all the selects into a single statement.
XMLSPY 5
Unleash the full power of xmlspy® 5 – the original XML Development Environment to fully support the designing and editing of all XML technologies; including XML editing and validation, Schema and DTD design, and XSL transformation. xmlspy® 5 builds on the success of the previous award-winning versio