| Computers Forum Index » Computer - Databases » What data standards should a database designer know... |
|
Page 1 of 2 Goto page 1, 2 Next |
|
| Author |
Message |
| Philipp Post... |
Posted: Wed Mar 25, 2009 1:40 pm |
|
|
|
Guest
|
|
| Back to top |
|
|
|
| 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 |
|
|
| Back to top |
|
|
|
| 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! |
|
|
| Back to top |
|
|
|
| --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
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.) |
|
|
| Back to top |
|
|
|
| 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. |
|
|
| Back to top |
|
|
|
| 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? |
|
|
| Back to top |
|
|
|
| --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? |
|
|
| Back to top |
|
|
|
| --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? |
|
|
| Back to top |
|
|
|
| --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 !! 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 |
|
|
| Back to top |
|
|
|
| Steve Hayes... |
Posted: Wed Mar 25, 2009 11:34 pm |
|
|
|
Guest
|
|
| Back to top |
|
|
|
| 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 |
|
|
| Back to top |
|
|
|
| --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 |
|
|
| Back to top |
|
|
|
| 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 |
|
|
| Back to top |
|
|
|
| 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 |
|
|
| Back to top |
|
|
|
| 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 |
|
|
| Back to top |
|
|
|
|