Sitecore 9 has delivered on a major request of it's customers - xDB support for SQL Server.
Experience Database (xDB) came with the release of Sitecore 7.5, and it brought in major overhaul around Sitecore's architecture for data storage. Earlier to Sitecore 7.5, Analytics was saved in SQL server where few key deficiencies were noted, like - it only scaled vertically, lead to inefficient scaling, and that the data was too complex to structure effectively. The change was a NoSQL database in the form of MongoDB.
Mongo provided vertically scaling - for speed, horizontal scaling - for size and Schemaless document database which allowed flexibility. However, it did present organizations with a number of challenges. The foremost of these challenges was probably the technical requirement for MongoDB as part of the platform, in addition to the pre-existing SQL Server.
With this release, Sitecore now supports using SQL Server 2017 as the database for xDB. This version of SQL Server provides the necessary level of capability for storing JSON structures in a noSQL type of manner that was not previously possible with SQL Server.
Note - Sitecore has expended the choice for both the partners and Azure customers, to the cosmos dB as well as the Sql Azure (which become's the perfect solution for the integrated Azure).
The support finally provides more options both in terms technology (SQL vs NoSQL) and hosting (Cloud vs On-Prem) to align with one's customers needs.
Experience Database (xDB) came with the release of Sitecore 7.5, and it brought in major overhaul around Sitecore's architecture for data storage. Earlier to Sitecore 7.5, Analytics was saved in SQL server where few key deficiencies were noted, like - it only scaled vertically, lead to inefficient scaling, and that the data was too complex to structure effectively. The change was a NoSQL database in the form of MongoDB.
Mongo provided vertically scaling - for speed, horizontal scaling - for size and Schemaless document database which allowed flexibility. However, it did present organizations with a number of challenges. The foremost of these challenges was probably the technical requirement for MongoDB as part of the platform, in addition to the pre-existing SQL Server.
With this release, Sitecore now supports using SQL Server 2017 as the database for xDB. This version of SQL Server provides the necessary level of capability for storing JSON structures in a noSQL type of manner that was not previously possible with SQL Server.
Note - Sitecore has expended the choice for both the partners and Azure customers, to the cosmos dB as well as the Sql Azure (which become's the perfect solution for the integrated Azure).
The support finally provides more options both in terms technology (SQL vs NoSQL) and hosting (Cloud vs On-Prem) to align with one's customers needs.
No comments:
Post a Comment