Q: What is the difference between the Content Management Server and the Content Delivery Server? The Content Management Server is where content editors create content. It features both the Master and the Core databases. The Content Delivery Server is for web site visitors. It features the Web database (and core database asp.net membership model by default).
Q: How SiteCore deals with data?
Sitecore reads data from the database and represents it in memory as XML. Developers *never* write SQL statements. Instead, they use the API to access the XML representation.
Q: What are the three Databases used by SiteCore?
A standard Sitecore installation uses three databases:
All versions of content, all languages, published and unpublished in any workflow state.
This is the work-in-progress database.
Latest version of published content that has completed workflow.
This is the live database.
Configuration information for the Sitecore user interfaces.
ASP.NET membership schema.