(Doug Eckersley) SQL is a powerful tool for querying data from iSeries databases. Part of what makes SQL so powerful is its predicates, used to select certain rows or groups of rows. A predicate, according to IBM’s documentation, “specifies a condition that is true, false, or unknown about a given r
Other News
Delivering an effective and flexible data warehouse solution: Part I: Customer engagement and project planning
(Leon Gong, Mike Olivas, Christine Posluszny, Donna Venditti and George McMillan) Business Intelligence has evolved to include more and more data analytic technologies. No matter which data analysis approach you take, the data warehouse remains a vital foundation for leveraging information assets. T
Mitigate Business Intelligence Project Risks with Rule-Based Audits and Proof-of-Concepts
(Michael L. Gonzales) This white paper describes two methods for minimizing the risk associated with BI iterations: Rule-Based Audits and Proof-of-Concepts. Independently used, each will help you clarify and better understand risk points associated with your project. (R)
On VSAM and DB2
(Craig S. Mullins) Lately I’ve been getting a lot of questions from people looking to convert their VSAM data to DB2. So I thought I’d put together my thoughts on the topic for my IDUG Solutions Journal column so I can share them with everybody.
Newcomers Target MySQL in Open-Source Database Market
(Jennifer LeClaire) Regardless of which vendor you pick in the open-source database horse race, open source itself is a good bet, according to Yankee Group analyst Dana Gardner. Gardner told LinuxInsider that open-source databases generally hold a lot of promise, and there is room for multiple playe
An Introduction to XUL Part 5
(Dan Wellman) Learn about XUL, a subset of XML used to describe user interfaces, that helps you to make rich user interfaces with nothing more complicated than a text editor. In the fifth part of this series you will receive an introduction to XPCOM, the object model used by XUL, and take a clos
Security’s Starring Role in Oracle’s 10g DB
(Clint Boulton) Eighteen months after its grid computing Database 10g product took to the streets with a fervor, Oracle is pounding the pavement again with the second release of the software.
MSSQL Server Reporting Services: Mastering OLAP Reporting: Percent of Total – Two Perspectives
(William Pearson) In this session, we will examine the satisfaction of a business requirement within the cube upon which a pre-existing report is based (we will modify a sample OLAP report to save time and maintain the focus of the lesson as much as possible). We will then add the same capability at
Fifteen things DBAs should unlearn about Oracle
Oracle 8i, 9i, and 10g have altered the facts behind several common practices followed by database administrators. Consultant and veteran DBA Bob Watkins suggests that ‘products move on,’ and the old way of doing things sometimes needs to be abandoned in favor of the methods that new features make p
Storage Enhancements in DB2
(Chris Eaton) If you’re new to DB2 UDB for Linux, UNIX, and Windows or if you are an old pro, there are always new features that may have escaped your line of sight. Over the next few weeks I’ll highlight some of the newest features particularly around the area of storage management and how you