(Susan Jackson and Hannah Parker) This tutorial offers an insight into the new Call Control XML (CCXML) language. This language enhances the telephony industry by allowing development of call control functionality, irrespective of the base proprietary telephony system. (R)
Other News
How To Back Up a Microsoft Data Engine Database with Transact-SQL
SQL Client Tools are not part of the Microsoft Data Engine (MSDE) installation. Therefore, to back up an MSDE database, you can use the Transact-SQL BACKUP DATABASE statement, which is discussed in this article.
Under Wraps
(Brian Connolly) Most large businesses have an untapped asset: their warehouses of data about individual customer purchases. Market research firms, for example, will pay for this information because they forecast future buying trends based on demographic analysis of past activity. But while this
The Buzz around Stinger
(Paul C. Zikopouos) If you’ve read an IT magazine, attended a conference, or are an IBM DB2 Universal Database(DB2 UDB) user, you’ve heard the buzz about “Stinger”, the preview of the next release of DB2 UDB for Linux, UNIX, and Windows “Stinger” introduces over 175 valuable features -more than some
Cycling with CTEs
(Itzik Ben-Gan) Common table expressions (CTEs), a new T-SQL feature in SQL Server 2005 (formerly code-named Yukon), give you expressive powers for writing T-SQL queries to manipulate hierarchies easily and efficiently. Some major advantages of CTEs are that they’re ANSI SQL-99 compliant, they l
SQL/400 Data Definition Language
This part of the book covers Structured Query Language (SQL), specifically DB2 for OS/400 SQL (or SQL/400, for short).1 SQL is an industry-standard language for defining and manipulating data contained in a relational database. This chapter introduces SQL/400 and covers the Data Definition Language
Create 3D representations with XSLT and SVG
(Nicholas Chase) In part 4 of this series on analyzing data with XSLT, the MindMap Research Team realized that the cognitive data they’re analyzing might be easier to understand if represented in the 3D space for which it is intended. The team decides to use XSLT to transform it into a 3D graph so c
Essential Facts about Index Covering in DB2 Universal Database
(Alexander Kuznetsov) This article uses examples to illustrate cases in which adding a column or two to an index can boost a query’s performance by “covering” the columns used in a SELECT statement. The DB2 optimizer is very good in recognizing such situations and can choose a very efficient executi
SimpleXML
(James Murray) Learn an easy way to parse XML and putput it the way you want by using the simpleXML extensions in PHP5. Murray outlines the 3 main elements of an XML document and how to replace them with your own non-template data and how to build an array of all the tags put in the document.
HOWTO: Retrieve XML Data with an XPath Query in an ASP Client
This article demonstrates how to retrieve an eXtensible Markup Language (XML) data stream from a SQL Server 2000 mapping schema by using an XPath query for an Active Server Pages (ASP) client. The sample also allows you to test XPath queries against the mapping schema. Two methods are used to sho