dbTalk Databases Forums  

Standard Schemas?

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss Standard Schemas? in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rich
 
Posts: n/a

Default Standard Schemas? - 08-10-2007 , 06:03 AM






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 =-


Reply With Quote
  #2  
Old   
Arto V Viitanen
 
Posts: n/a

Default Re: Standard Schemas? - 08-15-2007 , 01:24 PM






Rich wrote:
Quote:
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/interm...256FAA00546B2F
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


Reply With Quote
  #3  
Old   
Rich
 
Posts: n/a

Default Re: Standard Schemas? - 08-16-2007 , 08:42 PM



"Arto V Viitanen" <arto.viitanen (AT) pp4 (DOT) inet.fi> wrote

Quote:
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/interm...256FAA00546B2F
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 =-



Reply With Quote
  #4  
Old   
Arto V Viitanen
 
Posts: n/a

Default Re: Standard Schemas? - 08-17-2007 , 02:42 AM



Rich wrote:

Quote:
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


Reply With Quote
  #5  
Old   
--CELKO--
 
Posts: n/a

Default Re: Standard Schemas? - 08-19-2007 , 12:32 PM



Quote:
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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.