[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Re: Are the data users happy? Why not?


Re:  Re: Are the data users happy? Why not?
AndrewWatt2000@a... wrote:
>>  PHB: "Hey, we've got lots of invalid phone numbers in our documents!"
...
> Isn't the problem there the phone numbers which validate and which don't 
> work? :)

It depends. In the project I grabbed the example from they found
shorcut numbers like "*35", which don't validate but work perfectly
well for the guys who configured their phones to map this to the
correct number. Also, internal phones need a special prefix, which
may differ dependent on how the local telephone system was configured.
This leads to series of corrections "Dumb! It's 001234567." "Geez,
they should now it is actually #901234567".

Straying a bit off the telephone number track, you might remember
the ZIP code reform in germany 10 years ago, where they suddenly
realized that what everybody regarded as a number until then was
really a string of digits, as new codes were introduced with a
mandatory leading zero.
There are lots of irregularities which break common assumptions on
certain data. Account numbers are no longer numbers if you want the
"number" to be the SWIFT id of a bank. You can't infer from the fact
that nobody yet had a total amount of securities in a depot which
overflowed a 10 digit number that this will never happen (and
unsurprisingly a program crashed because of this at the end of 1999).
There is a swiss municipality which is italian by telephone country
code, breaking the usual nationality->phone country code mapping.
There are quite a few villages where one half pays its tax to the
authority of region A, the other to region B, requiring you to
maintain a map by street/house number.

If you want to integrate several applications things tend to
become worse. Regardless how sophisticated the schema for the
data is, there's always an application with yet another exception.
Otherwise, you wouldn't need this application, I think. As Mike Kay
once noticed here "if you found two exactly matching fields, you
have a winner". This happens rarely enough, and no amount of CORBA
or Web Services standardisation is going to change this. Of course,
Web Services make it easier to transform the data while on transport,
which is one of the main reasons (together with NULL values) why they
will ultimately win over CORBA.

<rant mode off/>

J.Pietschmann


PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
 

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.


Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.