Without calling into question all SQL concepts, additional techniques must be integrated to manage shared data in a more semantic way. Find out how to bridge the gap between Semantic Data Management and SQL-OLTP world

The purpose of complementing SQL to gain a better level of expressiveness is not limited to ORM. Indeed, new databases qualified as “Not Only SQL (NoSQL)” are numerous and tackle in priority storage of large and fast-growing data sets, such as those managed by social networks on the web. However, NoSQL doesn’t improve the level of data expressiveness, in particular nothing is integrated in term of data validation rules and data governance: modeling of data validation rules, data version management, collaborative work on data in shared transactional scopes, etc.

This paper highlights how to overcome these issues when devising canonical data models whose requirements in semantic expressiveness are strong whereas data volumes still remain limited compared to usual transactional databases including NoSQL initiative for the web.