Main Page | Report this Page
Computers Forum Index  »  Computer - Databases  »  What data standards should a database designer know...
Page 1 of 2    Goto page 1, 2  Next

What data standards should a database designer know...

Author Message
Philipp Post...
Posted: Wed Mar 25, 2009 1:40 pm
Guest
Joe,

Quote:
I am trying to get a book together on such standards so that maybe the next batch of Newbies will stop inventing their own encodings.

I guess as Ed already said this might become a very big one. Standards
become very specialized and it depends on the business for which the
database is in use, which are important and which are not, but the
idea of creating a reference book isn't bad.

Here my input for a chapter about international trade and
transportation - this is just a selection of those which appear most
important to me:

ISO 6346 numbering of freight containers (and also for chassis,
trailers, detachable equipment)
http://en.wikipedia.org/wiki/ISO_6346

UN location codes (mainly for trade and transportation)
http://www.unece.org/cefact/locode/

UN/ECE Package type codes
http://www.unece.org/cefact/recommendations/rec21/rec21rev4_ecetrd309.pdf

International Maritime Dangerous Goods (IMDG) Codes
http://www.imo.org/TCD/mainframe.asp?topic_id=158
(just available for purchase)
N.B: This is just the start: dangerous goods coding could fill a
chapter of itself.

Harmonized system (HS) customs cargo classification codes
http://en.wikipedia.org/wiki/Harmonized_System

INCOTERMS (13 codes for foreign trade contracts indicating the passing
of risk and costs from seller to buyer and further obligations)
http://www.iccwbo.org/incoterms/id3040/index.html

brgds

Philipp Post
 
Philipp Post...
Posted: Wed Mar 25, 2009 4:05 pm
Guest
When you deal with international applications you also need language
codes:

ISO 636
http://en.wikipedia.org/wiki/ISO_639

Here is the issue that some are using the old two letter codes and
others are using some version of the newer three-letter codes.

For banking, trade, transport, travel and many other business also
currency codes:

ISO 4217
http://en.wikipedia.org/wiki/ISO_4217

Brgds

Philipp Post
 
Ed Prochak...
Posted: Wed Mar 25, 2009 5:40 pm
Guest
On Mar 25, 8:40 am, Philipp Post <Post.Phil... at (no spam) googlemail.com> wrote:
Quote:
Joe,

I am trying to get a book together on such standards so that maybe the next batch of Newbies will stop inventing their own encodings.

I guess as Ed already said this might become a very big one. Standards
become very specialized and it depends on the business for which the
database is in use, which are important and which are not, but the
idea of creating a reference book isn't bad.

Here my input for a chapter about international trade and
transportation - this is just a selection of those which appear most
important to me:

ISO 6346 numbering of freight containers (and also for chassis,
trailers, detachable equipment)http://en.wikipedia.org/wiki/ISO_6346

UN location codes (mainly for trade and transportation)http://www.unece.org/cefact/locode/

UN/ECE Package type codeshttp://www.unece.org/cefact/recommendations/rec21/rec21rev4_ecetrd309...

International Maritime Dangerous Goods (IMDG) Codeshttp://www.imo.org/TCD/mainframe.asp?topic_id=158
(just available for purchase)
N.B: This is just the start: dangerous goods coding could fill a
chapter of itself.

Harmonized system (HS) customs cargo classification codeshttp://en.wikipedia.org/wiki/Harmonized_System

INCOTERMS (13 codes for foreign trade contracts indicating the passing
of risk and costs from seller to buyer and further obligations)http://www..iccwbo.org/incoterms/id3040/index.html

brgds

Philipp Post

Wow, some good ones!
 
--CELKO--...
Posted: Wed Mar 25, 2009 5:46 pm
Guest
Quote:
How about Internet standards:

.. and the regular expressions for their validation.

Quote:
medical (e.g., transcription codes)

ICD codes, SNOP and other are good

Quote:
Trucking VMRS (Vehicle maintenance Reporting standard)

Did not know it existed

Quote:
Does Legal industry have some standards (maybe Federal Register numbering?? I don't know.)

Laws are numbered, but at the state and local levels in the US.

Quote:
School classes - is there a standard for coding college classes? or does each school make up their own number scheme??

Yes and no. The ACM and IEEE have standard curriculum with their
numbering system. A lot of school use them, but the colleges map
their own encodings to the ACM for transfer credits.

Quote:
I'm surprised you don't list UPC and other bar codes.

I do; EAN and GTIN are the current things to watch.

Quote:
Geographic (latitude and longitude) Might be obvious but still don't want to create your own without at least thinking about using this.

I have them and the HTM (Hierarchical Triangular Mesh) and the UN
location codes

Quote:
Font numbering!!!!

Keep talking. I stopped setting type in the 1970's. Classification
schemes were not standardized, much less the fonts.

Quote:
This could be a big book. Need a collaborator?

Actually, I need about ten of them. I have my wife doing colors (land
system, Pantone, RGB, etc.)
 
Ed Prochak...
Posted: Wed Mar 25, 2009 5:46 pm
Guest
On Mar 25, 8:47 am, David Segall <da... at (no spam) address.invalid> wrote:
Quote:
--CELKO-- <jcelko... at (no spam) earthlink.net> wrote:
I am trying to get a book together on such standards so that maybe the
next batch of Newbies will stop inventing their own encodings.
Suggestions welcome!

If you were teaching the course would you recommend using a similar
book or doing a web search?

After thinking about it, I am guessing the idea is to cover key
standards, and to provide enough information about others to make a
web search succeed for each standard. But I'm sure Joe will comment.

Ed.
 
David Segall...
Posted: Wed Mar 25, 2009 6:47 pm
Guest
--CELKO-- <jcelko212 at (no spam) earthlink.net> wrote:

Quote:
I am trying to get a book together on such standards so that maybe the
next batch of Newbies will stop inventing their own encodings.
Suggestions welcome!

If you were teaching the course would you recommend using a similar
book or doing a web search?
 
--CELKO--...
Posted: Wed Mar 25, 2009 8:57 pm
Guest
Quote:
, but the idea of creating a reference book isn't bad.

The metadata Standards group is supposed to be working on a repository
for such stuff, but I do not have any idea how well that is going.

Quote:
Here my input for a chapter about international trade and transportation - this is just a selection of those which appear most important to me:

Very good! and exactly what I am after. Not so much depth, but a
taste of the basics in a given area.

Isn't there a book of holidays for ports that International Maritime
shipping uses?
 
--CELKO--...
Posted: Wed Mar 25, 2009 8:57 pm
Guest
Quote:
, but the idea of creating a reference book isn't bad.

The metadata Standards group is supposed to be working on a repository
for such stuff, but I do not have any idea how well that is going.

Quote:
Here my input for a chapter about international trade and transportation - this is just a selection of those which appear most important to me:

Very good! and exactly what I am after. Not so much depth, but a
taste of the basics in a given area.

Isn't there a book of holidays for ports that International Maritime
shipping uses?
 
--CELKO--...
Posted: Wed Mar 25, 2009 9:04 pm
Guest
Quote:
If you were teaching the course would you recommend using a similar book or doing a web search?

Doing a course, I would recommend using MY book Smile!! Hey, I have a
mortgage and nothing in my 401-k. I teach Database and not ethics.

Doing a project,
1) talk to the "Elders of the Tribe" of the client
2) Wikipedia what (1) told me
3) Google what (2) told me
4) Download what (3) told me
 
Steve Hayes...
Posted: Wed Mar 25, 2009 11:34 pm
Guest
On Wed, 25 Mar 2009 13:47:02 GMT, David Segall <david at (no spam) address.invalid> wrote:

Quote:
If you were teaching the course would you recommend using a similar
book or doing a web search?

Not David Segall the Scuttlebutt of the Holodeck, is it?

If so, see:

http://hayesfam.bravehost.com/HOLODECK.HTM


--
Steve Hayes from Tshwane, South Africa
Web: http://hayesfam.bravehost.com/stevesig.htm
Blog: http://methodius.blogspot.com
E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk
 
Troels Arvin...
Posted: Wed Mar 25, 2009 11:52 pm
Guest
--CELKO-- wrote:
Quote:
What data standards should a database designer know about?

ICD-10 (classification of diseases).

--
Troels
 
--CELKO--...
Posted: Thu Mar 26, 2009 1:12 am
Guest
Quote:
ICD-10 (classification of diseases).

Agreed. I worked with version 9 and SNOP decades ago
 
Philipp Post...
Posted: Thu Mar 26, 2009 8:45 am
Guest
Joe,

Quote:
Very good!  and exactly what I am after.  Not so much depth, but a taste of the basics in a given area.

You are welcome!

Quote:
Isn't there a book of holidays for ports that International Maritime shipping uses?

At least not to my knowledge. I would say it does not exist as there
is no pressing need. In most ports ships are operated also on holidays
due to the extremely high costs a vessel at standstill produces daily
(just landside operations are stopped then for a short period of time)
and also due to schedule integrity. Further regarding to port storage,
these tariffs are mostly made up by calendar days. The costs are on
account of the cargo. Foreign traders are supposed to either arrange
for pick up of their cargo prior to holiday or arrange their shipments
so that they will not arrive just within the holidays.

If you should have further questions on that biz, let me know - if
needed also by private mail (is in my profile).

brgds

Philipp Post
 
Jasen Betts...
Posted: Fri Mar 27, 2009 2:55 pm
Guest
On 2009-03-26, Gene Wirchenko <genew at (no spam) ocis.net> wrote:
Quote:
ISBN for books

And ISBN-13 (or whatever the new version is called).

Whatever it is actually called it's basically indistinguishable from EAN
 
Patrick Nolan...
Posted: Fri Mar 27, 2009 5:37 pm
Guest
On 2009-03-25, --CELKO-- <jcelko212 at (no spam) earthlink.net> wrote:
Quote:
What data standards should a database designer know about?

Digital Object Identifiers: http://doi.org
 
 
Page 1 of 2    Goto page 1, 2  Next
All times are GMT
The time now is Tue Dec 01, 2009 11:44 am