Standard Schemas?

Standard Schemas?

am 10.08.2007 13:03:23 von David Kirkby

Hi,

Anyone know an online source for database schemas, or schemas for single
tables i.e. where can I download a schema for an addresses table?


--
Rich

http://www.badangling.com -= Sea fishing badly explained =-

Re: Standard Schemas?

am 15.08.2007 20:24:52 von Arto V Viitanen

Rich wrote:
> Hi,
>
> Anyone know an online source for database schemas, or schemas for single
> tables i.e. where can I download a schema for an addresses table?
>
>
You might like to check your local post office, if they have anything.
For example, a Finnish standard for addresses is:
http://www.jhs-suositukset.fi/intermin/hankkeet/jhs/home.nsf /pages/C3059D924C150877C2256FAA00546B2F
The page is in Finnish, but that is to show my point: this is for a
single (and small for that matter) country, so for addresses alone there
would be hundreds of standards and I bet you need others also.

BTW. the standard contains an XML-schema as an example. You might get
better results, if you search for XML-schemata.

--
Arto Viitanen

Re: Standard Schemas?

am 17.08.2007 03:42:51 von David Kirkby

"Arto V Viitanen" wrote in message
news:UxHwi.324$T%3.257@read3.inet.fi...
> Rich wrote:
>> Hi,
>>
>> Anyone know an online source for database schemas, or schemas for single
>> tables i.e. where can I download a schema for an addresses table?
>>
>>
> You might like to check your local post office, if they have anything.
> For example, a Finnish standard for addresses is:
> http://www.jhs-suositukset.fi/intermin/hankkeet/jhs/home.nsf /pages/C3059D924C150877C2256FAA00546B2F
> The page is in Finnish, but that is to show my point: this is for a
> single (and small for that matter) country, so for addresses alone there
> would be hundreds of standards and I bet you need others also.
>
> BTW. the standard contains an XML-schema as an example. You might get
> better results, if you search for XML-schemata.
>
> --
> Arto Viitanen


Hi Arto,

And thanks for the link - I will take a look.

Here's an interesting site I found while searching for information on
addresses - http://www.vianica.com/nicaragua/14-addresses.html. It seems
Nicaragua has a unique way of creating addresses based on directions from a
known location. I wouldn't like to have to generate the XML for that!

--
Rich

http://www.badangling.com -= Sea fishing badly explained =-

Re: Standard Schemas?

am 17.08.2007 09:42:38 von Arto V Viitanen

Rich wrote:

> Here's an interesting site I found while searching for information on
> addresses - http://www.vianica.com/nicaragua/14-addresses.html. It
> seems Nicaragua has a unique way of creating addresses based on
> directions from a known location. I wouldn't like to have to generate
> the XML for that!
>

My friend told, that in Japan street houses are not numbered
sequentially, but based on their age. So if address is
"Somethingstreet 3", you have to search third oldest house
in the Somethingstreet.

--
Arto Viitanen

Re: Standard Schemas?

am 19.08.2007 19:32:56 von Joe Celko

>> My friend told, that in Japan street houses are not numbered
sequentially, but based on their age. So if address is
"Somethingstreet 3", you have to search third oldest house in the
Somethingstreet. <<

Not by street but by age within a block