(Lewis Cunningham) I am frequently asked to blog about data warehousing from a beginner view. I have started to do that several times but there are just so many topics to talk about it’s hard to know where to start.
Tag: Oracle
Adding New Nodes to Your Oracle RAC 10g Cluster on Linux
(Murali Vallath) In most businesses, a primary business requirement for an Oracle Real Application Clusters (RAC) configuration is scalability of the database tier across the entire system—so that when the number of users increases, additional instances can be added to the cluster to distribute the
SAP and Oracle Battle for SOA Bragging Rights
(Lee Kroon) Over the last two weeks, enterprise application vendors Oracle and SAP have been locking horns in another of their public battles. This time, the dispute is over which company is ahead of the other in delivering a next-generation application suite that delivers a complete service-oriente
Oracle 1000 Events: Applications World Tour to visit 27 cities across EMEA
(Marc Sparrow) Oracle is to take its “Applications Unlimited” message to conferences in 27 cities across Europe, the Middle East and Africa (EMEA), starting on 27 September in Paris. The full-day events, which are part of Oracle’s 1000 Events Applications World Tour, are designed to discuss the comp
Copying a Table from Oracle 10G XE to SQL 2000 Server using DTS
(Jayaram Krishnaswamy) Database users sometimes need to transfer data from one vendor type to another. Sometimes data stored in a large scale database such as Oracle or MS SQL Server may be transferred to smaller desktop database applications such as MS Access, MS Visual FoxPro, etc. This tutorial i
Oracle GL Overview
(njethwa) Continuing with the simplicity and popularity of “What is Oracle Apps?” article, this article will try to explain the GL basics in simple terms. It assumes you have basic accounting knowledge like debit, credits, expense, accounts, etc.
Oracle 10g Materialized View Enhancements, Part 2
(Jim Czuprynski) Oracle 10g Release 2 (10gR2) has improved the effectiveness and speed of materialized view refreshes, something especially important as data warehouses and data mart environments become increasingly complex and mission-critical requirements for all enterprises. This article – the la
Experts wonder if Oracle’s revenue growth is sustainable
(Mark Brunelli) Wall Street analysts and IT industry experts are wondering whether Oracle’s explosive growth in new applications license revenues is sustainable over the long term. (R)
Book Review: Expert Oracle Database 10g Administration
(Steve Callan) Every once in a while, it’s worth noting an exceptional product or publication, and the purpose of this article is to do just that by highlighting Sam Alapati’s Expert Oracle Database 10g Administration (Apress). The amount of material covered in the book is extensive and its database
Using Oracle’s COALESCE function as a quick CASE statement
(Bob Watkins) Database applications sometimes store information about multiple, related entities in the same table. For example, purchased parts and parts built in-house are both parts. Managers and employees are both employees. Although the multiple entity types may have slight differences in the d
