(Robert Catterall) How do you determine whether to use a materialized query table (MQT) using DB2 Cube Views or DB2 OLAP Server for a particular analytic need?
Other News
A Simplified SQL-CSV Import/Export Functionality
(codeajay) This small but important utility has been created for users who would surely like to understand how to import and export data between SQL and CSV files. There are many alternatives to this utility. The (BCP) bulk copy of SQL provides a facility to insert multiple records through a single
Quick Study: Improve XML Transformations
As many enterprise developers work on web services and data integration projects, they are becoming increasingly frustrated that they don’t have more control over the XML portions of their work. Consequently, more developers are asking, “Isn’t there a better way to control XML transformations withou
Demystifying the SQL Server DATETIME Datatype
(Frank Kalis) When you follow online communities dedicated to SQL Server with open eyes, you certainly notice a whole lot of questions are closely related to the DATETIME datatype in one way or the other. Obviously, working with DATETIME not as easy as it may seem.
Multimodality: Simple Technologies Drive a New Breed of Complex Application Input
(Erin Gannon) The proliferation of handheld devices means that users are increasingly relying on them to perform routine, daily tasks—the cell phone, with its video card and internet access is becoming a constant companion. With this ubiquity comes the necessity to make these devices smaller, more c
A Database Journal Guide to MySQL Certification: Part 1, Core Certification
(Ian Gilfillan) I recently arranged for the developers at our company to get MySQL certified. From the employer’s point of view, it was not the piece of paper I was after. Rather, the improved productivity that properly-trained MySQL users could provide. The benefits have been noticeable. The number
Managing XML data: A look ahead
(Elliotte Harold) Much has been written about how to process XML documents, including how to search them with XPath, transform them with XSLT, style them with CSS, and create them with DOM. But as XML becomes increasingly popular and begins to pervade your systems (whether you want it to or not), a
Understanding SQL Server’s WITH RECOMPILE option
(Arthur Fuller) SQL Server’s ability to optimize and compile a stored procedure is great but, if you aren’t careful, it can bite you when you least expect it. See how Arthur Fuller executes a stored procedure using the WITH RECOMILE option, and then consider whether you need to revisit any stored pr
11 PHP functions for parsing and manipulating URLs and HTML
PHP comes with numerous functions for parsing and manipulating URLs and HTML documents. These functions make it possible to easily accomplish specialized tasks, such as turning text into HTML, reading script variables from a URL or sending HTTP directives to the user’s browser. The table in this
How the Internet Is Dying
(Thomas M. Stockwell) Imagine that you are buying your next pair of shoes from your favorite Internet shoe site. You’ve logged into your account, browsed a few dozen pairs, and made your selection. Now, it’s time to check out with your market basket, enter in your credit card number, and close t