Each manufacturing facility contains a huge number of assets, from screwdrivers to machines. To track all of them, observing the S95 requirements, you need a suitable database storing asset data. Available storage options can be subdivided into the following groups.
Selecting a storage
Relational DBMS
A relational DBMS is a table-oriented store based on the relational model (originally described by Edgar F. Codd). Such databases comprise a number of records (entities), each corresponding to a row in a table. The records (entities) contain attribute values.
Relation schemas within a database table are defined by the table name, a fixed number of attributes, and fixed data types. The schemas are the product of normalization...