(mustapha) Beginning with MySQL 5.1.5, two functions providing basic XPath (XML Path Language) capabilities are available: ExtractValue and UpdateXML.
Author: SSWUG Research
Coding fun solutions to crummy problems using XSLT collections
(Edmond Woychowsky) I’ve made no secret that a former manager described me as the guy that does “mad scientist stuff”, and that he used a word other than stuff. This statement does a lot to explain my love of tinkering will all aspects of application development. Often my creations are nothing speci
Enabling Real-Time Analytics
(Michael L. Gonzales) In a competitive environment, businesses require a thorough understanding of their own as well as their partners’ processes. Process knowledge is crucial to reaching across the extended enterprise.
The XmlTextReader – A Beginner’s Guide
(Marc Clifton) The XmlTextReader class is not the most intuitive class to work with, as the methods and properties are very low level. While the XmlTextReader class is rich in properties and methods, I’ve found that most of what it provides isn’t necessary for the average day-to-day job. So, in th
Rational Data Architect skills series, Part 2: Generate SQL/XML queries with Rational Data Architect
(Torsten Bittner) You can use the SQL/XML query language to transform relational data into XML format. Since it is cumbersome to manually write SQL/XML queries, IBM Rational Data Architect simplifies this work by automatically generating SQL/XML queries based on graphically defined mappings. Get an
Would you put a Data Warehouse on the Mainframe (DB2 for z/OS that is)?
(Willie Favero) I would… and in a New York second. Ok, maybe I’m not really in a position that would allow me to “put up a warehouse someplace”, but if I were, or if I was asked for my opinion, I would most certainly, and without hesitation, recommend it to anyone, anytime, and even for a non-DB2 sh
FIX: The connection that processes the cube stops responding, and the cube is locked in SQL Server 2000 Analysis Services
Consider the following scenario. In Microsoft SQL Server 2000 Analysis Services, one connection processes a cube in a loop. This cube uses the relational OLAP (ROLAP) storage mode. At the same time, another connection runs a succession of multiple Multidimensional Expressions (MDX) queries. In this
MS SQL Joins Part 3
(Don Schlichting) The purpose of a Join is to combine query results from two or more related tables into one logical result set. If a database is designed for OLTP (Online Transaction Processing) or data entry, then many related tables will be used in the design rather than one large all encompassin
Sampling Nested Tables
SQL Server Data Mining is unique in its ability to mine multiple tables of data simultaneously through the nested table feature. This functionality, however, adds some complexity when performing basic data manipulation tasks required for data mining, such as sampling. How does one split a data set
Tip/Trick: Creating Re-Usable Project and Item Templates with VS 2005
(Scott Guthrie) Typically when you work on projects you have a standard approach that you like to use to structure and organize your code (folder layout, default namespaces included, assembly references included by default, standard CSS stylesheets included, etc). This is often the first thing deve