Page 1 of 1
RealTime QS
Posted: Wed Jun 22, 2005 3:23 am
by akrzy
Hi,
Do you know how QS "RealTime" works with matching process using big amount of data.
Anka
Posted: Wed Jun 22, 2005 4:41 am
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?
Posted: Wed Jun 22, 2005 5:48 am
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.
Posted: Wed Jun 22, 2005 5:10 pm
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.