Killing the Oracle DBMS_JOB

 
 while ago I published an article on Killing the Oracle DBMS_JOB. This was also a favorite of some of my readers and I still get questions on it today. So I thought I would post it here as it has surely been lost out in the web archives unless you search deep. Just remember the [...]

Read Full Post »

Using a Linked table

There are a couple of things you have to remember while using a linked table. The main one is how to reference the tables in the remote database. In the previous post, I mentioned that you have to assign a name to your linked table, and it didn’t have to be the actual name of [...]

Read Full Post »

Meta Integration Technology

Meta Integration Technology (MITI) is the leading “Metadata Component Provider” to major database, data integration, business intelligence, repository, and modeling tool vendors. MITI has established itself as the ” Switzerland of Metadata ” as expressed by then-Giga Information Group Analyst Lou Agosta in a 2002 IdeaByte article.
MITI is a privately held US based software company.
MITI [...]

Read Full Post »

ABC of EAI Layers

In the last post, we briefly touched upon the black art of XML. It was meant to be an introduction to the technology as you will need it as an integration developer. We will definitely go deep into XML once we dive into implementation specific topics. However, today we will talk about the layered approach [...]

Read Full Post »

Coding Horror: The Two Types of Programmers – Or Why Open Source Doesn’t Get It

Read it yet?  If not, go read it and then come back.  You simply won’t get what I’m about to say if you don’t go read that link.  That means you, Mike.
OK, now to my response to this elitist drivel.  To me this blog post sums up everything I absolutely loathe about the Open Source [...]

Read Full Post »

SAS acquires Teragram

SAS has announced the acquisition of privately held Teragram. The acquisition will enhance SAS’ own robust text mining and analytical BI offerings, and extend them to enterprise and mobile search.
More than a decade ago, SAS was among the first companies to recognize the importance of text mining, the analysis of text and other unstructured data [...]

Read Full Post »

DB2 LUW Performance: Table Read I/O and Overflows

Understanding Table I/O performance is critically important to properly diagnosing the health and efficiency of a database and pinpointing problems. In fact, if I only had just a few minutes to quickly assess a database, I’d look at 3 key measurements…

The Database Synchronous Read Percentage, SRP,
The Database Index Read Efficiency, IREF,
Table I/O measurements:

The average number [...]

Read Full Post »