Showing posts with label erd. Show all posts
Showing posts with label erd. Show all posts

Friday, June 26, 2020

Meta_doc : metadatas and documents

Meta_doc

Metadatas and documents
Entity Relationship Diagram
Vincent Fortier
2021-02-15
Meta_doc...
documentidPKtitleUKstart_dateUKend_dateversionUKclassification_idUKtextstatedocument_metadatametadata_idPKdocument_idPKdublin_core_elementidPKelementUKdefinitiondocument_relationidPKdocument_source_idUFKdocument_target_idUFKdublin_core_relation_idUFKclassificationidPKcodeUKtitledescriptionmetadataidPKtermUKdescriptiondublin_core_element_idUFKdublin_core_relationidPKrelationUKdefinition
Viewer does not support full SVG 1.1

It is better to manage the metadata of a document in a relational database rather than placing it in the title of a document in a file system. For example, Projectx_document2_20150101_v01.doc lost in a maze of subfolders, duplicated on several servers.

To try to solve these problems simply, here is a data model of a basic document management (DM) system, with a search by metadata. Access to documents through a classification plan. The metadata categories as well as the types of relationships between documents are part of the Dublin Core repository. The ressource URL or attached documents URL are inside the field "text".

Application on GitHub

Followers