Categories
Newss

IDC recognizes innovators in relational database software market 2018

IDC (International Data Corporation) has recognized Clustrix, Cockroach Labs, NuoDB, and Splice Machine as the IDC Innovators for dynamically scalable and alterable relational database software in 2018.

The emerging vendors which generate over $100 million revenue, and have demonstrated either an innovative business model or technology, are considered as the IDC Innovators.

Relational database management systems (RDBMS) are a group of programs that allow enterprises to create, update, administer and interact with a relational database. The enterprise-grade RDBMS generally use SQL to access the database.

The RDBMS helps enterprises to gain flexibility and scalability in the technologies they use. It enhances the utility for complex analysis of real-time data, and supports analytics transaction processing (ATP). The ATP is a combination of online transaction processing (OLTP) and online analytical processing (OLAP).

According to IDC, the technologies built by the IDC innovators provide all the benefits expected by RDBMS, and additionally provide support for dynamic resource and dynamic schema change, and extension of databases across several clusters and regions.

“It is often stated as an article of faith that relational databases can’t scale, but there is nothing about the concept of relational databases that supports that assertion,” said Carl Olofson, research vice president for Data Management Software at IDC. “A new class of RDBMSs has overcome the flexibility and scalability obstacles and also supports dynamically adding or removing resources such as processor capacity (nodes) and storage or making dynamic schema changes without interrupting database operations.”

Clustrix is known for its scale-out database called ClustrixDB that scales the database horizontally by adding cores and servers using a shared-nothing architecture. It moves the query to the data, rather than moving data to the query.

Cockroach Labs provides the SQL database for cloud services through CockroachDB. The CockroachDB helps companies to simplify the process of running a distributed database by automatically scaling, rebalancing, and repairing data.

Whereas, NuoDB is an elastic SQL database company for hybrid cloud applications. The NuoDB database system can run on containers, virtual machines, and across on-premises, public and hybrid cloud environments.

Splice Machine is disrupting the traditional database world with a hybrid data platform that unifies streaming, analytics and transactions in a single relational database system, removing latency, cost and complexity from supporting modern big data applications.

Also read: MongoDB removes need for traditional relational database with version 4.0

SM- Clustrix, Cockroach Labs, NuoDB and Splice Machine recognized as innovators by IDC in relational database software.

Categories
Cloud Cloud News

Azure SQL Data Sync now generally available

Microsoft recently announced the general availability of its Azure SQL Data Sync solution, which allows users to synchronize data between Azure SQL Database and other SQL endpoints.

Built on Azure SQL Database, the SQL Data Sync allows synchronization of data unidirectionally as well as bidirectionally across multiple SQL databases and SQL Server instances.

“It enables hybrid SQL deployment and allows local data access from both Azure and on-premises application. It also allows you to deploy your data applications globally with a local copy of data in each region, and keep data synchronized across all the regions,” said Xiaochen Wu, Senior Program Manager, Azure SQL Database.

Microsoft reckons that Azure SQL Data Sync will reduce the impact of network latency and connection failure rate on applications, resulting in improved application response time and reliability.

The processing of Data Sync takes place in three steps— tracking data changes, synchronizing data, and resolving conflicts. The changes are tracked using insert, update, and delete triggers.

The technology has been available in preview for a while. Since its preview launch, Microsoft has updated SQL Data Sync with a number of improvements, including more reliable configuration workflow and more intuitive user experience. Users can now load database schema more efficiently using the new SQL Server Management Objects (SMO) library.

Also, Microsoft has made it GDPR compliant, with end-to-end synchronization workflow and data encryption.

Also read: Microsoft rolls out next generation of Azure SQL Data Warehouse featuring major performance improvements

The new offering will be more appealing to the customers moving to cloud and would like to move some of their application in Azure. It will be also useful for enterprises spanning multiple regions, having distributed applications.