DASe & Metadata

Early in the development of the DASe project we decided/realized that the ONLY way we would be able to quickly and efficiently deal with all of the various digital collections we hoped to incorporate would be to NOT enforce any kind of metadata scheme on anyone, but rather simply let folks describe their “stuff” anyway they wish. Not to mention, since many of these were legacy collections set up in a FileMaker or Access database or even an Excel spreadsheet, there was often already a schema in place and folks (rightly) didn’t want to change. Note that we are talking about faculty members and department administrators who have lots better things to do that figure out how to use Dublin Core to describe the images that the have already been using for years in their classes, research, and publications.

We (Liberal Arts Instructional Technology Services at The University of Texas at Austin) had an interest in “rationalizing” this hodge-podge of data & metadata towards two ends: one, we wanted folks to be able to share their collections easily if they wished, and two, we wanted a means by which we could easily repurpose the digital assets in all sorts of ways: podcasts, websites, specialized search interfaces, etc. So we went with what is essential key-value pairs: collection managers create “attributes” (e.g., title, description, person depicted, time period, etc.) that best describes their assets and we provide an interface that allows them to add metadata to any item by filling in a value for any/all attributes that apply. Well, turns out this works REALLY well. We currenly have 88 collections, comprising over 300,000 items (images, audio, video, documents, etc) and the system holds over 4 million pieces of metadata (i.e. the “values” table has over 4 million rows). Searching is fast, adding new collections is easy, and application maintenance (including backing up collections as XML documents) is painless.

The current version of DASe runs on PHP4 with a PostgreSQL back end. The next rev, which is a significant retooling of the current architecture and code base will be PHP5 and will be able to use PostgeSQL, MySQL, SQLite, or XML files as a backend. How that all works, where Atom, REST, RDF and more fit in, problems encountered along the way, as well as solutions settled on (tentative and otherwise) will be some of the topics explored in future posts.

14 comments

  1. Syed’s avatar

    Peter, after reading your post I feel you might be interested in Brainwave’s “Poseidon” database its a schemaless database which doesn’t require any data modeling for development, packed along with a complete development and deployment platform.

  2. Jarod Clark’s avatar

    Is the new version that runs on PHP5 out yet?

  3. grocery coupons printable’s avatar

    Hi! I just wanna give you a huge thumbs up for the great info you have here on this post. I will be returning to your blog for more later.

  4. hertz coupon code’s avatar

    Nice post. But I get an error when I try to sign up to your feed. Is it a problem with my settings, or is anyone else here getting it as well?

  5. Australian Jobsearcho’s avatar

    Well, it is okay for me if they’re not going to mention it, looking at the diagram, I got some good ideas. And it is more easy to understand as well.Australian Jobsearcho

  6. Ventilator’s avatar

    It is very nice site

  7. fujifilm’s avatar

    I still really like your writing style. Keep up the great work.

  8. online shopping vcc’s avatar

    Thank you a lot for giving everyone an extremely superb opportunity to read from this web site. It really is so useful and jam-packed with amusement for me and my office fellow workers to visit your site at least thrice weekly to read the latest guides you have. And definitely, I am at all times astounded for the mind-blowing inspiring ideas served by you. Some 4 points in this post are rather the simplest I have ever had.

  9. susan’s avatar

    Really nice article. Author has described everything in a great way.

  10. David’s avatar

    Very interesting article and I would also like to know if the new version is out for PHP5 yet?
    Many thanks :)

  11. Charlie’s avatar

    Good article and I’ll be a frequent visitor to your blog.
    Thanks!

  12. McAfeepromocodes.com’s avatar

    Very interesting article and I would also like to know if the new version is out for PHP5 yet?

  13. vpromocode’s avatar

    Nice article read it full twice

Comments are now closed.