 |
 |
Guess it depends on how many parents an item can have. If you want a one parent hierarchy, then give WordPress or Drupal a whirl On 2016-02-15 10:00, Fred Riley wrote: > Although this query isn't specifically OER, it is repository-related, > and OER and repositories go together like bread and butter. I posted > the following to Stack Exhange on 18th January and got a -1 rating and > no replies for my troubles, so plainly it was inappropriate. I also > tried the Jiscmail CETIS list and it dropped into a cyberspatial black > hole. So, can anyone on this board, particularly anyone with > experience of designing repositories with multi-level taxonomies, > point me towards example designs? Although my Q is initially about a > personal site, I realised quickly that it's also applicable to > repositories implementing taxonomies, and of course many large-scale > repos (eg Intralibrary, DSpace) do exactly that. > > If this query is at too detailed a technical level for this board, do > please point me to more appropriate fora which I can query. > > Thanks :) > > Fred > www.fredriley.org.uk [1] > > --------- > > I'm looking to implement a small static site of mine (CALL@Hull [2]) > in a relational database. The site already has a shallow hierarchical > data structure (taxonomy), to which I might want to add another > hierarchy or two. I've looked at the thread "Creating Taxonomy table > in MySQL" [3] from a few years back, which opened my eyes up to the > concepts of Adjacency Lists and Nested Set models, outlined in some > detail in the the article Managing Hierarchical Data in MySQL [4]. > Another useful thread is "What are the options for storing > hierarchical data in a relational database?" [5]. > > My question: is there an example hierarchical database > application/diagram which I could study to get my head around storing > taxonomies in a relational DB? > > I'll be implementing in PHP (Codeigniter) and MySQL, but I'm really > after seeing the database and application structure at a design level. > If this doesn't count as a programming or DB design question then my > apologies for posting in the wrong place. > > I'm also into (educational) metadata schemas and learning object > repositories, so it would be useful for me to understand more general > solutions to this topic. I'm looking at small-scale databases (eg <10k > records) so am not bothered about execution times for different > approaches. > > ----- > > > Links: > ------ > [1] http://www.fredriley.org.uk > [2] http://www.fredriley.org.uk/callhull > [3] > http://stackoverflow.com/questions/4240433/creating-taxonomy-table-in-mysql > [4] > http://mikehillyer.com/articles/managing-hierarchical-data-in-mysql/ > [5] > http://stackoverflow.com/questions/4048151/what-are-the-options-for-storing-hierarchical-data-in-a-relational-database -- Pgogy Webstuff pgogywebstuff.com