Tuesday, 23 January 2018

SQL Server 2017 and Graph Databases

I recently came across the Microsoft blog for SQL Server and there are some really interesting articles. With the recent expansion of NoSQL databases there are a wide range of databases to get your read round. It used to be that you just has all the different types of relational databases to look at, Oracle and SQL Server etc. however now you also need to consider, for projects with Big Data at least, the use of NoSQL databases. Here you have a variety of different options including graphs databases which is what is discussed in the article on the Microsoft blog. 


I won't go into the detail of what a graph databases is (look on Google or Wikiepedia) however it appears that SQL Server is going to "SQL Server 2017 fully integrates with Transact-SQL (T-SQL) to create and query graph objects. Maintain your existing SQL Server database and benefit from pairing graph capabilities with other SQL Server technologies like columnstore, HA, R services, and others. SQL graph database also supports all the security and compliance features available with SQL Server."


No comments:

Post a Comment