Development of a relational database schema for collection-level descriptions in SCONE, the Scottish Collections Network

Gordon Dunsire

    Research output: Contribution to conferencePaper

    Abstract

    The paper describes the development of the database schema and structure of SCONE, the Scottish Collections Network, which provides a web based retrieval of information about the location, content and accessibility of print and digital library collections held in Scotland, with appropriate links to online resources and finding aids. The basic schema is derived from an entity-relationship model of collections and their catalogues, primarily concerned with single instances, which has been extended to cover multiple collections at different levels of aggregation. Several large data sets were used to test the schema and develop an implementation of it in a normalized relational database. The database structure has been compared with and mapped to other collection-level description schemas in use or under development in the United Kingdom. Content standards have been established for some schema attributes, and the degree of compatibility with other schemas identified. Single collection-level descriptions are created from the database using Structured Query Language. The database schema accomodates the use of a functional granularity, or pragmatic approach to collection description by allowing multiple levels of sub-collection in a polyhierarchical relationship. Inheritance and other features of the implementation of the database in the SCONE service improve reusability and maintenance of the data. The database schema and structure continue to be developed as part of current research projects in subject retrieval, interoperability, and distributed digital library environments.

    Conference

    Conference7th Seminar on Archives, Libraries, Museums
    CityPoreč, Croatia
    Period26/11/0328/11/03

    Fingerprint

    accessibility
    relational database
    resource
    library
    research project
    services
    test
    attribute

    Keywords

    • collection-level description
    • relational database schema
    • SCONE
    • indexing
    • digital libraries

    Cite this

    Dunsire, G. (2004). Development of a relational database schema for collection-level descriptions in SCONE, the Scottish Collections Network. Paper presented at 7th Seminar on Archives, Libraries, Museums, Poreč, Croatia, .
    Dunsire, Gordon. / Development of a relational database schema for collection-level descriptions in SCONE, the Scottish Collections Network. Paper presented at 7th Seminar on Archives, Libraries, Museums, Poreč, Croatia, .
    @conference{ffded39016d04e028f22e057d4bb2648,
    title = "Development of a relational database schema for collection-level descriptions in SCONE, the Scottish Collections Network",
    abstract = "The paper describes the development of the database schema and structure of SCONE, the Scottish Collections Network, which provides a web based retrieval of information about the location, content and accessibility of print and digital library collections held in Scotland, with appropriate links to online resources and finding aids. The basic schema is derived from an entity-relationship model of collections and their catalogues, primarily concerned with single instances, which has been extended to cover multiple collections at different levels of aggregation. Several large data sets were used to test the schema and develop an implementation of it in a normalized relational database. The database structure has been compared with and mapped to other collection-level description schemas in use or under development in the United Kingdom. Content standards have been established for some schema attributes, and the degree of compatibility with other schemas identified. Single collection-level descriptions are created from the database using Structured Query Language. The database schema accomodates the use of a functional granularity, or pragmatic approach to collection description by allowing multiple levels of sub-collection in a polyhierarchical relationship. Inheritance and other features of the implementation of the database in the SCONE service improve reusability and maintenance of the data. The database schema and structure continue to be developed as part of current research projects in subject retrieval, interoperability, and distributed digital library environments.",
    keywords = "collection-level description, relational database schema, SCONE, indexing, digital libraries",
    author = "Gordon Dunsire",
    note = "Published in Croatian as proceedings in: 7. seminar Archivi, Knjiznice, Muzeji (2004). pp58-68. HKD: Zagreb.; 7th Seminar on Archives, Libraries, Museums ; Conference date: 26-11-2003 Through 28-11-2003",
    year = "2004",
    language = "English",

    }

    Dunsire, G 2004, 'Development of a relational database schema for collection-level descriptions in SCONE, the Scottish Collections Network' Paper presented at 7th Seminar on Archives, Libraries, Museums, Poreč, Croatia, 26/11/03 - 28/11/03, .

    Development of a relational database schema for collection-level descriptions in SCONE, the Scottish Collections Network. / Dunsire, Gordon.

    2004. Paper presented at 7th Seminar on Archives, Libraries, Museums, Poreč, Croatia, .

    Research output: Contribution to conferencePaper

    TY - CONF

    T1 - Development of a relational database schema for collection-level descriptions in SCONE, the Scottish Collections Network

    AU - Dunsire, Gordon

    N1 - Published in Croatian as proceedings in: 7. seminar Archivi, Knjiznice, Muzeji (2004). pp58-68. HKD: Zagreb.

    PY - 2004

    Y1 - 2004

    N2 - The paper describes the development of the database schema and structure of SCONE, the Scottish Collections Network, which provides a web based retrieval of information about the location, content and accessibility of print and digital library collections held in Scotland, with appropriate links to online resources and finding aids. The basic schema is derived from an entity-relationship model of collections and their catalogues, primarily concerned with single instances, which has been extended to cover multiple collections at different levels of aggregation. Several large data sets were used to test the schema and develop an implementation of it in a normalized relational database. The database structure has been compared with and mapped to other collection-level description schemas in use or under development in the United Kingdom. Content standards have been established for some schema attributes, and the degree of compatibility with other schemas identified. Single collection-level descriptions are created from the database using Structured Query Language. The database schema accomodates the use of a functional granularity, or pragmatic approach to collection description by allowing multiple levels of sub-collection in a polyhierarchical relationship. Inheritance and other features of the implementation of the database in the SCONE service improve reusability and maintenance of the data. The database schema and structure continue to be developed as part of current research projects in subject retrieval, interoperability, and distributed digital library environments.

    AB - The paper describes the development of the database schema and structure of SCONE, the Scottish Collections Network, which provides a web based retrieval of information about the location, content and accessibility of print and digital library collections held in Scotland, with appropriate links to online resources and finding aids. The basic schema is derived from an entity-relationship model of collections and their catalogues, primarily concerned with single instances, which has been extended to cover multiple collections at different levels of aggregation. Several large data sets were used to test the schema and develop an implementation of it in a normalized relational database. The database structure has been compared with and mapped to other collection-level description schemas in use or under development in the United Kingdom. Content standards have been established for some schema attributes, and the degree of compatibility with other schemas identified. Single collection-level descriptions are created from the database using Structured Query Language. The database schema accomodates the use of a functional granularity, or pragmatic approach to collection description by allowing multiple levels of sub-collection in a polyhierarchical relationship. Inheritance and other features of the implementation of the database in the SCONE service improve reusability and maintenance of the data. The database schema and structure continue to be developed as part of current research projects in subject retrieval, interoperability, and distributed digital library environments.

    KW - collection-level description

    KW - relational database schema

    KW - SCONE

    KW - indexing

    KW - digital libraries

    M3 - Paper

    ER -

    Dunsire G. Development of a relational database schema for collection-level descriptions in SCONE, the Scottish Collections Network. 2004. Paper presented at 7th Seminar on Archives, Libraries, Museums, Poreč, Croatia, .