Showing posts with label geographic. Show all posts
Showing posts with label geographic. Show all posts

Tuesday, March 27, 2012

Geographic Locations in a database

Hi

Has anyone ever tried to store international address information in to a single data

example

UK Address
Nildram Ltd
Ardenham Court
Oxford Road
AYLESBURY
BUCKINGHAMSHIRE
HP19 3EQ
GREAT BRITAIN

US Address
CHRIS NISWANDEE
BITBOOST SYSTEMS
421 E DRACHMAN
TUCSON AZ 85705
USA

Spainish Address
Organismo Autnomio Correos y Telgraphos
Area de Asuntos Internacionales
Calle Aduana, 29
28070 MADRID
SPAIN

Has anyone ever normalised this information into a database, because Im not sure if I should create separate tables or US States etc. Are there any other countries that contain data such as states?

Im just wondering how large organisation such as Yahoo or Microsoft would store this information.

Regards
Bennettas you have posted a question in the articles section it is being moved to SQL Server Forum.

MODERATOR.

geographic load balancing

Say we have 2 farms of servers in Asia and America.. what hardware or
software is out there that load balances geographically i.e Asia users go to
the Asia farm and America users go to America farm as an example ? Actually
how are IPs ranged for different countries so that any of the load balancing
tools know that this IP is from this country ,so and so forth.. Any article
that talks about IP addressing for countries would help
I know this is not SQL related question but SQL is in the farm and not too
sure whom to askYou cannot load balance SQL Server unless you are doing
read only servers.
If you are talking Web servers and such, many products
could potentially do it from HW to SW. If you want to do
it on Web servers, I'd ask in an IIS or Windows forum.

Geographic Cluster

I have one site which is running W2K with one IIS server with 100
Websites and one SQL2000 server, we are running with 6 meg of
bandwidth at our main site and 1.5 meg of bandwith at our remote
site.in case of a disaster at my main site, i want my remote site to
start taking web requests. I am looking into Microsofts Geographic
Cluster option, how would I go about setting up this option? can it
all be done with Microsofts products, if so how? if not what third
party software do I need? I have not used clustering before, so I
might have left something out, if more info is needed, please let me
know.Fist, MS has no geographic cluster option. Unless you are
referring to a Majority Node Set cluster, which is only in
Windows Server 2003 (which isn't good for SQL and I'll
explain in a minute), all geographic cluster solutions are
third-party based. You should read KB article
http://support.microsoft.com/default.aspx?scid=kb;en-
us;280743.
MNS clusters are not good for SQL Server because in a
clustered situation, you still have a shared disk
requirement.
Other options you may want to consider are things like NLB
for your web servers and log shipping to create the
standby DB at your other site.
>--Original Message--
>I have one site which is running W2K with one IIS server
with 100
>Websites and one SQL2000 server, we are running with 6
meg of
>bandwidth at our main site and 1.5 meg of bandwith at
our remote
>site.in case of a disaster at my main site, i want my
remote site to
>start taking web requests. I am looking into Microsofts
Geographic
>Cluster option, how would I go about setting up this
option? can it
>all be done with Microsofts products, if so how? if not
what third
>party software do I need? I have not used clustering
before, so I
>might have left something out, if more info is needed,
please let me
>know.
>.
>|||thanks for the quick response.
On Wed, 10 Dec 2003 08:31:20 -0800, "Allan Hirt"
<allanh@.NOSPAMavanade.com> wrote:
>Fist, MS has no geographic cluster option. Unless you are
>referring to a Majority Node Set cluster, which is only in
>Windows Server 2003 (which isn't good for SQL and I'll
>explain in a minute), all geographic cluster solutions are
>third-party based. You should read KB article
>http://support.microsoft.com/default.aspx?scid=kb;en-
>us;280743.
>MNS clusters are not good for SQL Server because in a
>clustered situation, you still have a shared disk
>requirement.
>Other options you may want to consider are things like NLB
>for your web servers and log shipping to create the
>standby DB at your other site.
>
>>--Original Message--
>>I have one site which is running W2K with one IIS server
>with 100
>>Websites and one SQL2000 server, we are running with 6
>meg of
>>bandwidth at our main site and 1.5 meg of bandwith at
>our remote
>>site.in case of a disaster at my main site, i want my
>remote site to
>>start taking web requests. I am looking into Microsofts
>Geographic
>>Cluster option, how would I go about setting up this
>option? can it
>>all be done with Microsofts products, if so how? if not
>what third
>>party software do I need? I have not used clustering
>before, so I
>>might have left something out, if more info is needed,
>please let me
>>know.
>>.|||Allen,
do you know what third party packages are out there for handling
geographic clustering?
On Wed, 10 Dec 2003 08:31:20 -0800, "Allan Hirt"
<allanh@.NOSPAMavanade.com> wrote:
>Fist, MS has no geographic cluster option. Unless you are
>referring to a Majority Node Set cluster, which is only in
>Windows Server 2003 (which isn't good for SQL and I'll
>explain in a minute), all geographic cluster solutions are
>third-party based. You should read KB article
>http://support.microsoft.com/default.aspx?scid=kb;en-
>us;280743.
>MNS clusters are not good for SQL Server because in a
>clustered situation, you still have a shared disk
>requirement.
>Other options you may want to consider are things like NLB
>for your web servers and log shipping to create the
>standby DB at your other site.
>
>>--Original Message--
>>I have one site which is running W2K with one IIS server
>with 100
>>Websites and one SQL2000 server, we are running with 6
>meg of
>>bandwidth at our main site and 1.5 meg of bandwith at
>our remote
>>site.in case of a disaster at my main site, i want my
>remote site to
>>start taking web requests. I am looking into Microsofts
>Geographic
>>Cluster option, how would I go about setting up this
>option? can it
>>all be done with Microsofts products, if so how? if not
>what third
>>party software do I need? I have not used clustering
>before, so I
>>might have left something out, if more info is needed,
>please let me
>>know.
>>.|||http://www.nsisoftware.com/pro/geocluster/
"Pat" <htech@.hotmail.com> wrote in message
news:t1ihtv4b04b6ten1u43ohha02a7vmsrc19@.4ax.com...
>
> Allen,
> do you know what third party packages are out there for handling
> geographic clustering?
> On Wed, 10 Dec 2003 08:31:20 -0800, "Allan Hirt"
> <allanh@.NOSPAMavanade.com> wrote:
> >Fist, MS has no geographic cluster option. Unless you are
> >referring to a Majority Node Set cluster, which is only in
> >Windows Server 2003 (which isn't good for SQL and I'll
> >explain in a minute), all geographic cluster solutions are
> >third-party based. You should read KB article
> >http://support.microsoft.com/default.aspx?scid=kb;en-
> >us;280743.
> >
> >MNS clusters are not good for SQL Server because in a
> >clustered situation, you still have a shared disk
> >requirement.
> >
> >Other options you may want to consider are things like NLB
> >for your web servers and log shipping to create the
> >standby DB at your other site.
> >
> >
> >>--Original Message--
> >>I have one site which is running W2K with one IIS server
> >with 100
> >>Websites and one SQL2000 server, we are running with 6
> >meg of
> >>bandwidth at our main site and 1.5 meg of bandwith at
> >our remote
> >>site.in case of a disaster at my main site, i want my
> >remote site to
> >>start taking web requests. I am looking into Microsofts
> >Geographic
> >>Cluster option, how would I go about setting up this
> >option? can it
> >>all be done with Microsofts products, if so how? if not
> >what third
> >>party software do I need? I have not used clustering
> >before, so I
> >>might have left something out, if more info is needed,
> >please let me
> >>know.
> >>.
> >>
>|||Thank You.
On Thu, 11 Dec 2003 16:19:38 -0500, "Eric Sabine"
<mopar41@.____h_o_t_m_a_i_l_._ScPoAmM> wrote:
>http://www.nsisoftware.com/pro/geocluster/
>
>"Pat" <htech@.hotmail.com> wrote in message
>news:t1ihtv4b04b6ten1u43ohha02a7vmsrc19@.4ax.com...
>>
>> Allen,
>> do you know what third party packages are out there for handling
>> geographic clustering?
>> On Wed, 10 Dec 2003 08:31:20 -0800, "Allan Hirt"
>> <allanh@.NOSPAMavanade.com> wrote:
>> >Fist, MS has no geographic cluster option. Unless you are
>> >referring to a Majority Node Set cluster, which is only in
>> >Windows Server 2003 (which isn't good for SQL and I'll
>> >explain in a minute), all geographic cluster solutions are
>> >third-party based. You should read KB article
>> >http://support.microsoft.com/default.aspx?scid=kb;en-
>> >us;280743.
>> >
>> >MNS clusters are not good for SQL Server because in a
>> >clustered situation, you still have a shared disk
>> >requirement.
>> >
>> >Other options you may want to consider are things like NLB
>> >for your web servers and log shipping to create the
>> >standby DB at your other site.
>> >
>> >
>> >>--Original Message--
>> >>I have one site which is running W2K with one IIS server
>> >with 100
>> >>Websites and one SQL2000 server, we are running with 6
>> >meg of
>> >>bandwidth at our main site and 1.5 meg of bandwith at
>> >our remote
>> >>site.in case of a disaster at my main site, i want my
>> >remote site to
>> >>start taking web requests. I am looking into Microsofts
>> >Geographic
>> >>Cluster option, how would I go about setting up this
>> >option? can it
>> >>all be done with Microsofts products, if so how? if not
>> >what third
>> >>party software do I need? I have not used clustering
>> >before, so I
>> >>might have left something out, if more info is needed,
>> >please let me
>> >>know.
>> >>.
>> >>
>sql