| [URL]http://www.monza.reol50.org[/URL] [URL]http 2006-11-16, 7:15 pm |
|
> Hello.
>
> I'm pretty new to SQL Server (switching from Visual FoxPro).
>
> I'm developing a database that will store, amongst other things, names
> and addresses of people from all over the world (approx 100,000
> records). Up to now, I've always used a flat model of storing address
> data using fields:
>
> Address line 1
> Address line 2
> Town/City
> County/State
> Postcode/ZIP
> Country
>
> But this model doesn't cater very well for the intricacies of postal
> systems all over the world. There is also redundancy, particularly with
> fields Line2, County/State, Postcode/ZIP, which are not needed for many
> countries.
>
> It also occurs to me that using multiple fields like this in a table
> with several fields gives no indication of the linked nature of the
> information. For example, if the town field is changed, then chances
> are that some of the other lines of the address become obsolete unless
> they are changed at the same time.
>
> So I have been thinking about storing the address in an XML structure
> in a single field. This will allow me, where necessary, to break down
> address data into smaller units where known (e.g. premise name, premise
> number, apartment number), or if a breakdown is not known to store
> chunks of data together. It also then allows me the flexibility to
> re-build the data in an appropriate order (e.g. for an address label)
> relevant for the particular country/language - for example number
> before/after street; postcode before town/separate line at the end.
>
> An example fragment might be:
>
> <address>
> <streetaddress>
> <premisename>Oak Cottage</premisename>
> <premisenumber>15</premisenumber>
> <streetname>Greenhill</streetname>
> <streettype>Crescent</streettype>
> </streetaddress>
> <locality>
> <village>Little Hampton</village>
> <town>Rickmansworth</town>
> <county>Hertfordshire</county>
> </locality>
> <postcode>WD3 3UH</postcode>
> <country>UK</country>
> </address>
>
>
> Bearing in mind some of this data will need to be searchable
> (especially postcode, country, and possibly town), are the possible
> benefits of this going to be outweighed by vast amounts of extra work,
> and a performance penalty, or does it sound like a good practical use
> of the XML data type?
>
> Any comments gratefully appreciated.
>
> Ben
[URL]http://www.monza.reol50.org[/URL] [URL]http://www.tarot.erotikh8.org[/URL] [URL]http://www.francesca.reol50.org[/URL] [URL]http://www.juventus.libro4jgratis.org[/URL] [URL]http://www.trenitalia.erotikh8.org[/URL] [URL]http://www.bambino.l
ibro4jgratis.org[/URL] [URL]http://www.supereva.reol50.org[/URL] [URL]http://www.arma.libro4jgratis.org[/URL] [URL]http://www.keira-knightley.erotikh8.org[/URL] [URL]http://www.sexy.erotikh8.org[/URL] [URL]http://www.novella.reol50.org[/URL] [
URL]http://www.sonora.erotikh8.org[/URL] [URL]http://www.nuoto.erotikh8.org[/URL] [URL]http://www.giochi.libro4jgratis.org[/URL] [URL]http://www.cosi.erotikh8.org[/URL] [URL]http://www.jesse-mccartney.reol50.org[/URL] [URL]http://www.cannavaro.e
rotikh8.org[/URL] [URL]http://www.filosofia.reol50.org[/URL] [URL]http://www.umbria.libro4jgratis.org[/URL] [URL]http://www.giorgia-palmas.reol50.org[/URL] [URL]http://www.viaggio.erotikh8.org[/URL] [URL]http://www.bikini.erotikh8.org[/URL] [U
RL]http://www.presidente.erotikh8.org[/URL] [URL]http://www.winnie-the-pooh.reol50.org[/URL] [URL]http://www.hospital.libro4jgratis.org[/URL] [URL]http://www.mano.reol50.org[/URL] [URL]http://www.hentay.libro4jgratis.org[/URL] [URL]http://www.nu
de.libro4jgratis.org[/URL] [URL]http://www.spiaggia.reol50.org[/URL] [URL]http://www.antologia.reol50.org[/URL] [URL]http://www.suzuki.reol50.org[/URL] [URL]http://www.curriculum.erotikh8.org[/URL] [URL]http://www.vittorio-emanuele.libro4jgratis
.org[/URL] [URL]http://www.porno.libro4jgratis.org[/URL] [URL]http://www.sex.reol50.org[/URL] [URL]http://www.erotico.libro4jgratis.org[/URL] [URL]http://www.finale.libro4jgratis.org[/URL] [URL]http://www.tutto.erotikh8.org[/URL] [URL]http://w
ww.universita.libro4jgratis.org[/URL] [URL]http://www.mail.libro4jgratis.org[/URL] [URL]http://www.calcio.erotikh8.org[/URL] [URL]http://www.rossi.reol50.org[/URL] [URL]http://www.chi.libro4jgratis.org[/URL] [URL]http://www.fido.reol50.org[/URL]
[URL]http://www.suonerie.erotikh8.org[/URL]
Posted from http://www.topxml.com/renntp using reNNTP: the website based NNTP reader.
|