July 14, 2015
ASP.NET Web CMS Database: NoSQL vs. SQL Server

No topic on ASP.NET CMS platforms would be complete without talking about the database. But before you read this post, make sure you've read about architecture models, development models and structured content.

ASP.NET Web CMS DatabaseNearly all ASP.NET CMS platforms use Microsoft SQL Server for a database engine. In some cases, they might use Oracle, or MySQL. All of these are relational database platforms that store web content, customer data and analytics data using a standard model and schema. In a relational database content is typically stored as Blobs.

Unfortunately, in an agile decoupled content management and deployment model, a relational database presents challenges. Content needs to be managed in a more structured (or intelligent) manner than a Blob provides. What's required is a flexible content or data model, offering a richer content structure, and that's where NoSQL can help.  

NoSQL databases - or better described as "not only SQL" -  support agile content management and deployment because they are schema free, meaning content can have any structure and that structure can change over time. In NoSQL, content is stored as documents or JSON objects that have richer metadata and use search-based indexing allowing content to be easily queried and retrieved based on the metadata.  

There are many advantages to a NoSQL database for content management. They are:

  • Designed to manage content and provide a much more intelligent content model for storage and reuse
  • Schema-free so content definitions can change without database upgrades or "joins"
  • Less expensive and easier to administrate
  • Provide automatic "sharding" of information so they are easier to cluster, scale, and geographically distribute
  • Work very well in cloud-based deployments

We think this topic is huge for the future of web content management and web experience management. Here we've only scratched the surface, so stay tuned for a more in-depth discussion on the future of NoSQL in the Web CMS market.

We hope you are enjoying this post series on ASP.NET Web CMS. Here's the full list of posts in the series.

Subscribe to Blog

Subscribe to the Ingeniux blog for the latest in web experience management. 

Subscribe to Blog