(Page 2 of 2)
Big Data in a Box
With all that said, Microsoft is positioning its new data platform as built for this era of ambient intelligence. The new data platform includes new Internet of Things capabilities and promises customers the building blocks they need to connect their data, refine and analyze it, and deliver insights to people who can take action.
The platform includes SQL Server 2014, Microsoft Azure Intelligence Systems Service, and the Analytics Platform System (APS). The latest SQL version delivers real-time performance with built-in in-memory technology and public cloud scale and disaster recovery with Microsoft Azure.
The Microsoft Azure Intelligent Systems Service aims to help customers embrace the Internet of Things by connecting to, managing and capturing machine-generated data from sensors and devices on any operating system. Finally, APS combines the best of Microsoft’s SQL Server database and Hadoop technology in one low-cost offering that delivers big data in a box.
Competing With SAP HANA
We turned to Charles King, principal analyst at Pund IT, for his take on the new SQL Server and the overall data platform. He told us one of the most interesting aspects of the new database software is added support for in-memory online transaction processing, or OLTP. That automatically makes SQL Server competitive with other in-memory database solutions, including SAP HANA.
“HANA has not only been designed specifically to support extremely high performance, SAP has to approve the systems HANA runs on,” King said. “It’s a rigorous design and development process. That means you can’t just drop HANA into any system without SAP’s approval.”
Indeed, enterprises have to meet strict performance and support guidelines in order to get the SAP stamp of approval. King said it’s not clear if Microsoft is following that same level of rigor with SQL Server 2014.
“This could be very positive for Microsoft,” King said. “But until I hear more about how SQL Server 2014 performs in-memory compared to some other systems I’m going to reserve judgment.”
Posted: 2014-05-31 @ 6:08pm PT
To me this feature reads like a nice table-level tweak to addressing hot spot tables with high enough transaction rates to make SQL Server struggle.
That's handy in a few cases, but it doesn't seem that big a deal. Maybe I'm missing the point?
Posted: 2014-05-30 @ 11:34pm PT
What about SAP Hana and oracle how of they compare