Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
walter_sobchak
Starting Member
1 Post |
 Posted - 2005-02-02 : 12:51:31
|
| I'm trying to set up an item classification system along the lines of the .NET Common Type System... not that complex, but I'd like something with that kind of flexibility. What I mainly want is to have one table in which all types, their relational structures, and basic properties are collected. So far I have a table like this:TypeID TypeCode TypeName ParentTypeID TypeLevelThe function of ParentTypeID is obvious; TypeLevel is what I came up with to differentiate types defined for a static relational hierarchy from types whose membership is defined by dynamic criteria. So, for example, since the database deals with stocks, part of the type system includes the standardized economic sector / industry classification structure:Sector (Level 4) --> Industry Group (Level 3) --> Industry Subgroup (Level 2) --> Company (Level 1)Most types, however, are not relational. For example, we have a set of price ranges defined for the purposes of statistical analysis, as well as groups based on investment style and various other criteria.Anyway, I've gone through about 10 iterations of trying to set this up, and every time I reach a point at which the hierarchy of the type system ends up either so complex or so fragile and dependent on intimate knowledge of its construction that it seems impossible for anyone but me to maintain it. It seems that I must be doing something wrong in either the taxonomy itself or in the logical design of the table.I don't know if this is a coherent enough explanation to make sense, but I'm hoping someone can at least point me in the direction of a resource for designing database classification systems, because I can't seem to find one. Thanks in advance.MikeThis is not Nam, Smokey. This is bowling. There are rules. |
|
|
|
|
|
|
|
Type / Classification System