Microsoft announces Extensible-Storage-Engine, embedded/ISAM-based database engine

by ·

Since Nadella became the CEO of Microsoft, the company’s open-source business is obvious to all. Nadella tends to embrace open source rather than as a competitor.

A few days ago, Microsoft’s open-source software library has once again added a blockbuster project. The Microsoft Extensible Storage Engine (ESE), which has been in service for more than 25 years, is now open source for community users.

The Extensible Storage Engine (ESE) is one of Microsoft’s core assets. The engine was born in Windows NT 3.51 and is still used by Microsoft.

Including Microsoft 365 mailbox storage back-end server, large-scale SMP system, and every Windows client, etc. contain the code of the ESE storage engine.

  • It’s running on 100s of thousands of machines and millions of disks for the Office 365 Mailbox Storage Backend servers
  • It’s also running on large SMP systems with TB of memory for large Active Directory deployments
  • Every single Windows Client computer has several database instances running in low memory modes. In over 1 billion Windows 10 devices today, ESE has been in use in Windows client SKUs since Windows XP

The Scalable Storage Engine is a non-SQL database engine that allows applications to use transaction processing data update and retrieval to enjoy a consistent data state.

At the same time, it provides a failure recovery mechanism, which can continue to maintain data consistency even in the case of a system crash. The engine also supports highly concurrent transaction processing.

Therefore, it is also suitable for server applications, and its intelligent data caching function can ensure high-performance access to data and improve data processing efficiency.

Tags: