By Igor Dayen – There are various ways to solve the problem of effective, automatic conversion of XML data into and out of relational databases. Database vendors such as IBM, Microsoft, Oracle, and Sybase have developed tools to assist in converting XML documents into relational tables. The various
Author: SSWUG Research
Using Index Intersection to Boost SQL Server Performance
by Neil Boyle – First introduced in SQL Server 7.0, and of course available with SQL Server 2000, Index Intersection gives you new options for creating indexes on tables in order to maximize performance. To demonstrate how Index Intersection works, I am going to use the "authors"
Initial draft of DOM Level 3 XPath
Philippe Le Hegaret has announced a first public Working Draft for the Document Object Model (DOM) Level 3 XPath Specification, a specification to provide access to DOM trees using XPath 1.0 expressions.
Preparing You For Real World Business Solutions
XMLSolutions' training curriculum helps companies and individuals understand and apply the syntax and semantics of XML. All training courses feature hands-on approaches to learning XML and its sister technologies, as well as seminars on how XML enables real-world business solutions.
Making XSLT style sheets from XSLT components
By Alan Knox – XSLT style sheets can be used to dynamically transform XML to complex presentation markup for browsers — but if the presentation is complex, the style sheet will be too. What's needed is some tool that can build complex style sheets from simple components. Since XSLT is itself an
Dynamic SQL
Dynamic SQL is a term used to mean SQL code that is generated programatically (in part or fully) by your program before it is executed. As a result it is a very flexable and powerful tool. You can use dynamic sql to accomplish tasks such as adding where clauses to a search based on what fields are f
Installing and Configuring Pervasive.SQL 2000 for WebApp™ Server
A Data Access Worldwide White Paper by Marcia Ferreira – The main objective of this White Paper is to list all the installation steps that one needs to go through on both Server and Client (using Windows NT), and some configuration involved when preparing Pervasive.SQL 2000 version 7.82 to be the ba
Harnessing the Power of SQL's Analysis Services
June 27, 2001 from 9:00am to 10:30am Pacific Time. Enroll Now! Registration closes 24 hours prior to the event start time.<br> Do you use SQL Server as one of your relational databases? Are you aware of the powerful analysis tools included in the product? Many customers are in your same predicament
Are W3C XML Schema and XInclude compatible?
The W3C XML Schema Working Group has published a list of strong concerns regarding the XInclude Last Call Working Draft and its lack of harmonization with the "other foundation specifications." Mary Holstege, for the W3C XML Schema Working Group, has posted a list of inconsistenci
Common Lisp support for the 'Extensible Markup Language' (CL-XML)
By James Anderson – Common Lisp support for the Extensible Markup Language (CL-XML) is a set of modules for XML processing. The validating parser is namespace-aware and will validate based upon a Document Type Definition (DTD). CL-XML provides support for XML Path Language (XPath), XML Qu