(Herts Chen) Analysis Services is a high-performance, multidimensional query engine for processing analytical and statistical queries, which a relational SQL engine doesn’t handle well. When such queries are simple or have pre-aggregations, Analysis Services can make your job easier. But when querie
Other News
XPath in Five Paragraphs
(Ronald Bourret) An XPath expresssion is a series of location steps separated by slashes (/). Each step selects a set of nodes in relation to the current node. These nodes become the current node(s) for the next step. The set of nodes selected by the expression are the nodes remaining after processi
Learn to Use XML with DB2
(Greg Nash) If you need to store XML data in DB2, translate XML to relational data, or shred relational data into XML, the XML Extender for DB2 is an essential utility. But it’s not always straightforward. Find out what it can do and what problems to expect.
The Basics of DB2 Log Shipping
(Dale McInnis) This article provides the details on how to implement log shipping to guarantee high availability for your DB2 UDB for Linux, UNIX and Windows databases.
Temporary Tables: Declared and Created
(Craig S. Mullins) DB2 for OS/390 has provided the capability to create temporary tables since Version 5. But the initial functionality was practical only in certain circumstances due to some inherent limitations. This first type of temporary table is known as a created temporary table. IBM’s suppor
Happy Birthday, XML!
(Dave Hollander and C. M. Sperberg-McQueen) Though it’s hard to believe that it has already been five years, the World Wide Web Consortium (W3C) published XML 1.0 as a Recommendation on February 10, 1998, making XML five years old. Since its first introduction, the Extensible Markup Language has bec
Inserting Data to an XML Document
(Mahesh Chand) The XmlNode and the XmlDocument classes can be used to insert XML data to an existing document or to a new document.
Getting ANSI About Joins
(Jim Czuprynski) JOIN … USING. When you need to join tables that share more than one column naturally, the JOIN … USING syntax needs to be used. A NATURAL join between the Employees and Departments tables, for example, could yield unexpected results because the tables share both the DEPARTMENT_I
Changing Databases Using XML
(Dinesh Asanka) As a database developer , you may have being fed up with the never ending customer changes. Actually this is not only relevant to database developers but for all of the other developers. But for database developers has to meet the customer requirements they may need to change the dat
Microsoft SQL Server 2000 Analysis Services Performance Guide
Users can analyze data stored in Microsoft® SQL Server™ Analysis Services with greater speed and flexibility than users can query the same data stored in a relational database. Analysis Services queries data more efficiently because it organizes data into multidimensional structures, stores aggregat