(Michael Klaene) Auditing data of business applications is a common requirement. In this article, I’ll demonstrate one way to audit Oracle data that is both simple and flexible. The code is written in Oracle PL/SQL and can be applied to any modern Oracle database. The process demonstrated can be dup
Other News
Use OracleAS SSO External Applications to connect your Portal to any system
(Tugdual Grall) Often portlets have to access various systems to publish personalized data into your portal. Some examples are connecting to a mail server, a third party application using J2EE Connector Architecture or proprietary APIs. In a lot of cases the application you need to connect to is not
Face Time With Paul Zikopoulos
I come from a mainframe background, so my DB2 Universal Database (UDB) disaster recovery plan is designed to re-create my current running environment exactly as is on a recovery site machine. From my research, DB2 UDB in the Microsoft Windows 2000 environment seems slanted more toward failover than
Microsoft Application Center 2000 – An Introduction
(Sujith K.) CLUSTERING technology, which allows multiple stand-alone computing systems to function as a single virtual machine, has become a powerful ally in the fight for e-commerce application scalability and availability. In a nutshell, clustering boosts performance through better load balancing,
Introduction to MSSQL Server 2000 Analysis Services: Putting Actions to Work in Regular Cubes
(William Pearson) In this article, we will examine Actions, a powerful feature in MSAS that allows information consumers to go beyond the robust OLAP perspective offered by the application, and to “step outside” for related information, or to generate commands or initialize programs, without leaving
Optimizing Microsoft SQL Server Analysis Services: Optimization Tools: Usage-Based Optimization Wizard
(William E. Pearson III) This is the third article of the series, Optimizing MSSQL Server Analysis Services. The primary focus of this series is the introduction of optimization tools and concepts for MSSQL Server Analysis Services (“MSAS”). The series is designed to provide hands-on application of
Denormalization of DB2 tables
(Craig Mullins) Speeding the retrieval of data from DB2 tables is a frequent requirement for DBAs and performance analysts. One way to accomplish this is to denormalize DB2 tables. The opposite of normalization, denormalization is the process of putting one fact in many places. This speeds data retr
All About Blogs and RSS
(Aaron Skonnard) Q What is blogging all about? A First, “blog” is short for Web log. It’s a medium in which an author writes a journal-style Web site with provisions for readers to respond. These Web logs are becoming quite valuable in the software community for sharing ideas.
How an XSLT processor works
(Benoît Marchal) This article examines how an XSLT processor works. To demonstrate his point, the author codes a special stylesheet that makes some aspects of the processing more visible. He pays special attention to the recursive nature of XSLT coding. A good understanding of the XSLT processor wil
An ASP Class for XML Data Transfer
(Seth Juarez) Hey, I wrote the “A Couple of ASP Functions for XML Data Transfer” functions and, as any self-respecting programmer, was unhappy with its stiffness. I decided enough is enough and created an actual class that handles more things. clsXML.asp is the actual class and objXML.asp is an impl