(Joe Pluta) Let me start with a disclaimer: This column is not intended to bash Web Services. Far from it. In fact, as I did my research, I became more and more impressed with how far Web Services have progressed, and the article sort of evolved into a list of things that, in my opinion, need to be
Other News
Web Services Integration Patterns, Part 2
(Massimiliano Bigatti) In the first installment of this article, I introduced some design patterns applied to the problem area of web services integration. This article presents more patterns: –Configuration Driven Service –Data Logger –Flow Logger –State Logger –Input/Output Valida
Fun with SQL
(Jeff Hunter) Structured Query Language (SQL) is an implementation of a “data sublanguage” used in almost all relational database systems. SQL was developed by IBM in the early 1970s for use in System R, and is “de facto” standard, as well as an ISO and ANSI standard. (R)
An Introduction to Control Center Personalities in DB2 Universal Database Stinger
(Paul C. Zikopoulos and Roman B. Melnyk) If you come from a Windows background, you are likely to leverage a graphical user interface (GUI) to perform most of the management tasks for your environment, including managing your IBM DB2 Universal Database (DB2 UDB) server. The Control Center is the
An Introduction to OLAP in SQL Server 2005
(Gail Tieh) If you’re a database developer, you’ve no doubt heard of On-Line Analytical Processing (OLAP) and the advantages of analysis using multi-dimensional, pre-aggregated data. Maybe you’ve even thought about creating your own multidimensional cubes to give your end users true ad hoc capabilit
XSL requests in Internet Explorer do not use the client-side cache correctly
When Microsoft Internet Explorer retrieves an XML file as the result of a POST request, and that XML file includes an XSL style sheet that is available locally in the cache, the style sheet is not retrieved from the client-side cache. Instead, the style sheet is requested in full from the specified
Computing the Trimmed Mean in SQL
(Bob Newstadt) This article presents code to compute a trimmed mean in SQL. The trimmed mean is a more robust version of the simple mean (SQL AVG() aggregate function). It is a useful tool for summarizing ill-behaved real world data.
DB2 for z/OS: DB2 Universal Database concurrency
(Fred Whitlark) Concurrency is the ability of a database management system to allow multiple users to access data at the same time while maintaining the integrity and consistency of the data. This article provides some general guidelines and recommendations for improving concurrency in DB2 for z/OS
MDX in Analysis Services: Mastering Time: Period – to – Date Aggregations
(William Pearson) In this article, we will examine “period-to-date” aggregations, a common business requirement. Year-to-Date totals top the list in popularity here, but the same concept of accumulation over a period range applies at subordinate time levels, as well. We will examine the means of
Scoring with Web Services
(Kelli Wiseth) Ask Whit Andrews about Web services, and he’ll tell you a story about plastic. At some point, explains the Gartner research director, “plastic became integral to a variety of other products and established a new baseline—consider the dosage cup that’s packaged with cough medicine thes