The Young DBA

When storing data in main memory, gives performance benefits but it is an expensive method of data storage. An approach to realizing the benefits of in-memory storage while limiting its costs is to store the most frequently accessed data in-memory and the rest on disk. This approach is called hybrid architecture of in-memory with Disk. There are some benefits of using hybrid architecture listed below: Performance (which is enhanced by sorting, storing and retrieving specified data entirely in memory, rather than going to disk). Lower TCO from reduction in hardware investment Cost, because a less costly hard disk can be substituted for more memory. Reduced point of failure using Persistence - All data is stored and managed exclusively in RAM is at risk of being lost upon a process or server failure. So every In-memory database  provide solution as a persistence to disk. This is usually act like hardening transaction log from memory to disk. Different vendor have different mechani

Now-a-days almost every relational or non-relational database gives in-memory capability. Traditional database vendor gives this capability using add-on in-memory engine and some are also specialized vendors. MySQL have in-memory table engine,  SQL server have in-Memory OLTP engine,  SAP has HANA,  Oracle have TimesTen,   Mongodb have separate in-memory services.  These all are version and edition dependent. To use this we need extra licensing cost. Apart from that there are some popular specialized in-memory database vendor like  Redis,  Aerospike,  VoltDB and  Arangodb.  Thanks for reading Plz dont forget to like Facebook Page.. https://www.facebook.com/pages/Sql-DBAcoin/523110684456757

In-Memory OLTP  In-Memory OLTP is an in-memory computing technology developed by Microsoft to speedup the performance of transaction processing applications running on SQL Server databases. In-Memory OLTP is built with two core components: memory-optimized tables and natively compiled stored procedures. In-Memory OLTP, also known as 'Hekaton' and 'In-Memory Optimization', which is Microsoft's latest in-memory processing technology of 2014. In-Memory Tables It is integrated into SQL Server's Database Engine and which can be used in the similar way as other Database Engine component. In-Memory OLTP originally came with SQL Server 2014 . Memory-Optimized Tables Memory-optimized tables are fully durable, like transactions on disk-based tables, transactions on memory-optimized tables are fully ACID compatible . Memory-optimized tables and natively compiled stored procedures support only a subset of Transact-SQL features. The primary storage for memory-o