E
eddie
Hi everyone... I'm new here... seeking advice
I am trying to design a database flexible enough that it can be used by
software targeted for several industry sectors, where each sector might
refer to the same data entities/structure with different nomenclature.
So i am in seek of anyone who has experience with some sort of open
naming convention or schema.
For example: If the software is to be used by a firm in SectorID=1, it
should read the naming from ONC (OpenNamingConvention - for lack of a
better acronym) where SectorID=1... something like...
SportID Description
1 Football
2 Basketball
ONC_SportID OpenName UseName
1 object football
1 surface field
1 target endzone
2 object basketball
2 surface court
2 target hoop
Where if the software was used for football, it would read display names
where the sportid=1, basketball would read from sportid=2, etc.
It seemed logical to me to build this at the database level as much as
possible. If anyone has experience with this concept, or just ideas
about it, your input is greatly appreciated!
eddie21
I am trying to design a database flexible enough that it can be used by
software targeted for several industry sectors, where each sector might
refer to the same data entities/structure with different nomenclature.
So i am in seek of anyone who has experience with some sort of open
naming convention or schema.
For example: If the software is to be used by a firm in SectorID=1, it
should read the naming from ONC (OpenNamingConvention - for lack of a
better acronym) where SectorID=1... something like...
SportID Description
1 Football
2 Basketball
ONC_SportID OpenName UseName
1 object football
1 surface field
1 target endzone
2 object basketball
2 surface court
2 target hoop
Where if the software was used for football, it would read display names
where the sportid=1, basketball would read from sportid=2, etc.
It seemed logical to me to build this at the database level as much as
possible. If anyone has experience with this concept, or just ideas
about it, your input is greatly appreciated!
eddie21