Kentico CMS provides a content management sub-system, also known as content repository, that allows you to organize website structure and content. Moreover, it provides a layer of security, workflow, versioning, search and other services. All types of content can be retrieved and modified through a single Application Programming Interface (API).

 

The following figure explains the difference between common data access approach and a content repository of Kentico CMS:

 

 

As you can see, a common approach to building dynamic websites is to write code for every page and every content type. It means that you need to write similar ADO.NET commands and SQL queries over and over again. With unified content repository, you use a complete set of API methods that allow you to save and retrieve any content type using methods someone wrote for you.

 

It greatly simplifies the management and retrieval of content since:

 

 

An important part of content repository is metadata. The metadata includes:

 

 

In the example above, you can see that with classic approach, both News and Articles tables contain the attribute Author. In the content repository, the author is stored in shared metadata for all documents, regardless of their type.

 

 

As you can see, the content repository represents a systematic approach to content storage, manipulation and security.

 

Page url: http://devnet.kentico.com/docs/devguide/index.html?where_is_the_content_stored.htm