RealTime QS

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
akrzy
Participant
Posts: 121
Joined: Wed Dec 08, 2004 4:46 am

RealTime QS

Post by akrzy »

Hi,

Do you know how QS "RealTime" works with matching process using big amount of data.


Anka
roy
Participant
Posts: 2598
Joined: Wed Jul 30, 2003 2:05 am
Location: Israel

Post by roy »

Hi,
Mentioning of real time and large amounts of data at the same breath???

Could you specify more details?

usually real time means handling of 1 request individually.

SOA (former RTI) allows you to have n instances of a process at any givven time after you exceed that number you might create a bottle neck.

So what exactly do you have in mind?
Roy R.
Time is money but when you don't have money time is all you can afford.

Search before posting:)

Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Image
akrzyzan
Participant
Posts: 33
Joined: Mon Dec 29, 2003 4:48 am

Post by akrzyzan »

It depends of what you mean 1 request at the time.
Lets say I have client database of several million records and I have 1 new record to match with that database to see if there are any duplicates of it.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Then you need a fast method of retrieving not just the matching record but also its standardized forms.
I normally solve this by adding fifteen columns to the table into which I initialize the standard forms (e.g. NYSIIS of last name, NYSIIS of city) then index these and any raw data fields that I may need to match. An alternative is to have an identically-keyed table containing the standard forms - it's mostly about what you can convince the DBA is the better approach.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply