Introduction

Concept of logicDCMS


logicDCMS is a Document Control and Management System for medium size projects.
It is especially useful in the engineering and construction phase of projects, to support the process of exchanging documents between the company using logicDCMS, the client for the project and third party companies ( suppliers, vendors ).
Actual file storage is done on the companies internal network. There is no 'black-box' in logicDCMS containing all the files. However, documents or files can be opened directly from logicDCMS. Synchronizing the network contents with logicDCMS can be done easily.
All meta-data and runtime information related to all project documents is stored in the database.
logicDCMS is built as a standalone database application in Microsoft Access.
The application consists of a separate front-end and a back-end (database) per project.

 

 The concept of a database
A database is a structured environment in which data is stored unambigiously
In general, a database uses tables to store data. Tables exist of fields and records, comparable with f.i. Excel sheets.
By defining relations between tables, so called queries, a structured collection of data arises.
Each entity, like f.i. a document title is stored in only one place insite the database.In this way inconsistency is prevented.
From organized data, information can be obtained. Despite the fact that queries can be directly used to display information, in practice forms and reports are created for that purpose.