Pat, I've been whirling with Wordpress for many years now, and whilst it's a fine CMS and small- to medium-sized web design tool, it sucks as a links database for all sorts of reasons, not least that it ditched the LInks library in v2.8 or so. Indeed, my hope is that I might be able to write a WP plugin to remedy this lack. Fred www.fredriley.org.uk On 15 February 2016 at 15:53, Pat Lockley (Pgogy) <[log in to unmask]> wrote: > 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 >