Online analytical processing (OLAP) is a technique for summarizing and interrogating data along multiple dimensions. As such, it is a valuable tool for any organization that must make sense of a large volume of data quickly. (pdf)
Other News
The secrets of open source security
(Chad Perrin) Debates rage across the Internet about the comparative security of Microsoft Windows and Linux-based operating systems. Many people have vested and biased interests in their positions on the matter. Misconceptions born of incomplete knowledge and logical fallacies contribute to the con
What is the Future of DB2?
(Sean McCown) I often wonder who will ultimatly take the lion’s share of the database market. Oracle and Microsoft seem to have a strong lead while IBM and Sybase seem to be lagging behind. And for some reason Sybase seems to be almost not even on the same course as the others.
BPEL in a Service-Oriented Architecture
(Adam Kolawa) Business Process Execution Language for Web Services (BPEL) is an XML-based language for standardizing business process description as well as standardization of interaction between business processes in a distributed environment. BPEL extends the Web services interaction model and dep
Overview of SQL Server 2005 Architecture
(Vidya Vrat Agarwal) This lesson introduces you to the various components and services of Microsoft SQL Server 2005. Database administrators (DBAs) are often required to manage multiple aspects of a database server, not just the relational database engine. Therefore, an awareness of the components a
‘Hello Ajax’! How to Do the Ajax Thing with Oracle JDeveloper
(Frank Nimphius) For sure, the world’s most successful computer program is “hello world”. Translations of it are available in almost every programming language and pattern.
FIX: The result set contains data for the whole relational source when you execute a query to retrieve a drillthrough result set in SQL Server 2000 Analysis Services
When you execute a query in SQL Server 2000 Analysis Services to retrieve a drillthrough result set, the result set contains data for the whole relational source. This problem occurs when the following conditions are true: • A cube role was defined for the relational source with the following set
Researcher: Oracle Needs To Patch 44 More Bugs
(Gregg Keizer) A German security researcher said this weekend that Oracle products, particularly its flagship database, are vulnerable to 44 bugs, the oldest reported to the Redwood Shores, Calif. developer two-and-a-half years ago, the newest submitted 12 days ago.
MDX Set Functions: The ToggleDrillState() Function
(William Pearson) In this article, we will continue the examination of “MDX for drilling up and down” that we began in Set Functions: The DrillDownMember() Function. We have discussed the nature of drilling, in general, in previous articles of our subseries, stating that it comprises an analytical t
Fundamentals of Recursion in PHP
(Alejandro Gervasio) Iteration is a straightforward concept. Recursion is a bit more complicated; it can be defined as a regular function that calls itself. PHP supports recursive functions. This article, the first of three parts, will explain recursive functions and help you see why they are useful