(Sven Viehweger) IBM Workplace Web Content Management is a key component in IBM WebSphere Portal Version 6. You can use it to manage corporate content from the creation of the first draft to the final Web presentation. You can also use it to design your Web site. Because Web Content Management separ
Other News
Oracle RAC Cache Fusion Efficiency: A Buffer Cache Analysis for RAC
(Christo Kutrovsky) Many people would like to know how well their application will run in RAC. Would it be faster or slower? Would it run at all?
Write PIVOT queries in SQL Server 2005
(Tim Chapman) New to SQL Server 2005 is the PIVOT operator, which gives you the ability to rotate row level data into tabular data without the use of the CASE statement, as was necessary in previous versions of SQL Server.
MySQL Cluster and the Death of Secondary Indexes
(Kevin Burton) Relational databases use indexes to speed up their performance usually due to the fact that their underlying storage is inherently slow (which has historically meant disk).
Output Caching in ASP.NET 2.0
(Scott Mitchell) One of the most sure-fire ways to improve a web application’s performance is to employ caching. Caching takes some expensive operation and stores its results in a quickly accessible location. ASP.NET version 1.0 introduced two flavors of caching: –Output Caching – caches the en
Build a shopping cart application using XForms
(Steve K Speicher, Keith Wells, Jan J. Kratky and Kevin Kelly) This tutorial focuses on key aspects of the W3C XForms 1.0 standard to produce a fully functional Web-based shopping cart. With this approach, the reader will get a good start at creating real-world applications with XForms, without havi
Building a data mining solution using IBM Intelligent Miner Modeling and WebSphere
(Stefan Warwas) The objective of this tutorial is to get you confident with the problem of handling multiple mining tasks at the same time in your J2EE Web application. The tutorial also demonstrates how to use the Easy Mining Procedures interface of Intelligent Miner Modeling to handle these mining
How to order SIBLINGS in Oracle hierarchy queries
(Bob Watkins) Oracle’s START WITH and CONNECT BY clauses in the SELECT statement automatically traverse a hierarchy. Without this feature, a complex self-join would be required to identify which rows are logically related to others. The START WITH clause identifies the row or rows to be considered t
Stored Procedures in SQL Server
(Mike Chapple) Microsoft SQL Server provides the stored procedure mechanism to simplify the database development process by grouping Transact-SQL statements into manageable blocks.
Advanced MySQL user variable techniques
(Xaprb) MySQL’s user variables have interesting properties that enable the useful techniques I wrote about in recent articles. One property is that you can read from and assign to a user variable simultaneously, because an assignment can an r-value (the result of the assignment is the final value of