This reflects our experience in building the RedLightGreen DB2 database and our current work in a similar but far more comprehensive Union Catalog database.
Dave Richards, chief technology officer for The Research Libraries Group Inc., of Mountain View, Calif., said his organization uses XML to store bibliographic data, which requires a great deal of auxiliary table construction to search and access records. Richards said the native XML support improvements for DB2 will allow digital records to be stored in a preparsed form, enabling streamlined and more efficient searches. "We wanted to be able to support queries that just were based on information in the e-records that had not been indexed. The way we have to do that at the moment is not terribly efficient," said Richards. "[Native XML support] is going to enable us to store things more compactly and access them easier ... and make it easy for us to be able to ingest and then export data in XML when we're able to migrate to that version of DB2." Richards said RLG is implementing a 1.5TB database featuring 140 million records representing books, serials, maps, films and music scores.Posted by judielaine at January 4, 2005 03:41 PM