*********************************** * METADATA TABLES FOR ABCD PROVIDERS *********************************** This folder contains templates to create 2 tables in a providers unitlevel-database(UDB) that hold metadata about the collection/provider. It is primarily meant for the use of configuring a UDB for the ABCD schema, that connects to the BioCASE network. There is are SQL scripts (MySQL->metadata.sql, oracle_* for Oracle) and an Access2000 database containing the definition of 2 tables that can hold all metadata relevant ABCD concepts. Create those tables in your database so you can use the preconfigured PSF and CMF templates below: *********************************** * CMF & PSF TEMPLATES *********************************** The respective configuration templates can be found inside the "config-files" template directory aside this metadata-tables directory. There are always three version of the config files, identified by their ending: nothing: a raw and empty configuration file METATABLES: preconfigured for the metatables to be used by any DBMS apart from MS Access META_ACCESS:preconfigured for the metatables to be used by MS Access Copy this file to your dbwrapper config directory and configure the rest of your datasource. MS Access has restrictions on using outer joins and inner joins at the same time, thefore it is not possible to use the static table command in a CMF. To overcome this, create a view (=query) in Access that includes the metadata query of the metadata.mdb file included here. In the PSF (provider setup file) use the tableAlias "unit" for this table, because this is the alias already used in the CMF template for access. For a successful XML output, ABCD requires some mandatory data. Following is a list of mandatory attributes, which you have to fill in. Without valid data you wont be able to produce ABCD data: Mandatory fields in the metadata table: --------------------------------------- source_code source_name source_update supplier_supplied_when supplier_organisation /OR/ supplier_person TABLE ATTRIBUTE DESCRIPTIONS: (taken from DESCRIPTION form in access DB) ------------------------------------------ source_code Unique identifier of the institution holding the original datasource (first part of dataset identifier). n institutional abbreviation, perhaps with indication of the standard it pertains to (e.g. IH-P for Index Herbariorum and the herbarium at the MNHN in Paris). A controlled vocabulary for collection institutions, but inclusion of private collections must be made possible. The units within the datasource are not necessarily all owned or administred by this institution. source_name Name or code of the data source (unique within the institution, second part of the dataset identifier). May be the name of a collection if all records are for a stem from a single collection. Together with the element DBInstitution, DBName provides a unique identifier for the datasetīs original source. Mandatory second partial identifier for a dataset. source_update Date when the content or structure of the database was last changed. Date when the database was last changed, including the addition, deletion, or editing of records as well as structural changes that may influence the format or structure of ABCD-conformant output. Mandatory to raise efficiency of "harvesters" and indexing engines working on datasets derived from the data source. source_version Version of the datasource. Version number or edition of the datasource. source_url URI of the original datasource. A URL providing an access interface to the original datasource. source_expiry Expiry date of records from the datasource. Date after which the records in the database should not anymore be used. source_number_of_records Number of units in the source database. Total number of unit-level records in the datasource. supplier_supplied_when Date supplied. Mandatory. supplier_organisation Supplier of the dataset. Individual or organisation who have (generated and) supplied the dataset. supplier_organisation_code Supplier of the dataset. Acronym or short term for organisation. Use most recognised code within discipline. supplier_person Supplier of the dataset. Name of person as normally used. May include titles. supplier_url Supplier of the dataset. URL for person or organisation supplier_adress Supplier of the dataset. Contact address. Address of person or organisation. supplier_telephone Supplier of the dataset. Telephone or fax number. Numbers should be provided in the ITU International Format (""+CountryCode AreaCode Number""). supplier_email Supplier of the dataset. E-mail address for contact. legal_owner_organisation Contact details for the legal owner. Organisation to contact. legal_owner_organisation_code Contact details for the legal owner. Acronym or short term for organisation. Use most recognised code within discipline. legal_owner_person Contact details for the legal owner. Person to contact. Name of person as normally used. May include titles. legal_owner_adress Contact details for the legal owner. Contact address. Address of person or organisation. legal_owner_telephone Contact details for the legal owner. telephone or fax number for person or organisation. legal_owner_email Contact details for the legal owner. E-mail address for contact. legal_owner_url Contact details for the legal owner. URL for person or organisation. terms_of_use Terms of use. acknowledgement Text acknowledging the contributions of other parties. description Text describing the DataSet. A free text statement describing the dataset, including e.g. statements about selective criteria or sort order used in the generation of the dataset. disclaimer Disclaimer on data quality. restrictions Restrictions on acess or usage. logo_url URL of a logo image of the item or holding organization which may be to give a quick visual indication of source in result sets comprising data from several datasets. statement_url A URL of a document with statements. copyright Declaration of copyright ownership. ipr Declaration of Intellectual Property Rights. rights_url A URL of a document stating legal rights.