|
|
Articles
Beyond Monitoring - Measuring the effectiveness of a Data Warehouse - II
Posted on April 21, 2008The data warehouse should be considered a work in progress, always needing improvements. Part-2 of this article discusses the factors that affect complex data environments and how they can be managed and improved.
Beyond Monitoring - Measuring the effectiveness of a Data Warehouse - I
Posted on April 20, 2008Successful measurement is the key to warehouse quality and effectiveness. In Part-1 of this article, the author discusses different types of metrics that help assess whether a data warehouse meets user requirements.
Reading data across sessions by using DBMS_PIPE package
Posted on December 4, 2007As we know Oracle uses PGA (Program Global Area) for execution of PL/SQL programs and SGA (System Global Area) for maintaining other data for a specific session.
DB2 Tools: An Introduction to the Bare Bones of using DB2 Effectively.
Posted on August 21, 2007In this series of articles, we shall be discussing the various tools available in DB2 for effectively performing tasks pertaining to a number of situations.
Stored Procedures, User Defined Functions and Triggers in IBM DB2 8.2
Posted on August 11, 2007In this article, the author discuses about working with stored procedures, UDFs and triggers in DB2. Examples have been provided for easier understanding
Understanding SQL Injection
Posted on June 22, 2007A technique often employed by malicious users for gaining illegal access to remote machines, through the web applications’ vulnerability, is SQL injection.
Data Mining using Fuzzy SQL Queries
Posted on May 31, 2007This article offers some useful tips for performing queries to locate trends in a database. Information thus obtained could result in enhanced profits if the pattern can be deciphered…
Database Design and Modelling for Programmers
Posted on May 20, 2007Most programmers aren't qualified database administrators, but were often thrust into the role of "Acting DBA". This article will cover some basic techniques of database design and modelling.
COBOL not dead, not yet
Posted on April 26, 2007Shekar Shetty of Keane Software argues that Cobol has a future, though it is very old. He tells the readers not to write or read an obituary of this language, which many consider redundant.
Ten Technology Trends for 2007
Posted on April 7, 2007In this article we take a look at the biggest developer technology predictions for 2007. These are trends that we feel will most likely lead to the way we develop software in the New Year.
Reading data across sessions using DBMS_PIPE package
Posted on November 8, 2006In this article, the author explains how to make use of DBMS_PIPE package to allow for access to the value of a variable across different sessions.
Object Relational Mapping with SQLObject
Posted on February 2, 2005The author delves into a tool that allows for easier switching between databases.
Oracle Data Piping
Posted on January 20, 2005As we know, Oracle uses Program Global Area (PGA) for execution of PL/SQL programs and System Global Area (SGA) for maintaining other data for a specific session. Several times, it becomes imperative to share the value of a variable across different sessions. Normally, when we use a variable,
HeadLines
Low Cost and Easy to Deploy IT Solutions Create Momentum in the Financial Services Sector for Oracle
Posted on August 27, 2008Oracle Unveils Oracle Enterprise Performance Management System
Posted on August 26, 2008Books
Beginning SQL Server 2005 for Developers
Posted on August 28, 2008<p class="MsoNormal">This book is for those who don’t have database Knowledge or professionals who have little Knowledge of database in general and ...
Beginning SQL Server 2005 for Developers: From Novice to Professional
Posted on April 4, 2008This book is for those who don’t have database Knowledge or professionals who have little Knowledge of database in general and SQL ...