Seeking Fast, Durable Data Management
January 7, 2013 — McObject’s white paper, “Seeking Fast, Durable Data Management: A Database System and Persistent Storage Benchmark”, explores solutions for database durability and recoverability, using McObject’s original test results to shine light on the best approach when performance is critical and data loss is not an option.
In-memory database systems (IMDSs) eliminate I/O latency associated with traditional on-disk database management systems (DBMSs), but some applications require a higher level of data durability (i.e. an ability to recover if someone “pulls the plug” or otherwise disrupts volatile memory). As a solution, IMDSs offer transaction logging, in which changes to the database are recorded on persistent media.
But critics object that logging re-introduces the storage-related latency that builds slowness into on-disk DBMSs. Will an IMDS with transaction logging outperform a traditional DBMS? Will type of storage – hard disk drive vs. solid state drive vs. state-of-the-art memory-tier products – affect the results? McObject’s report answers these questions with tests using its own eXtremeDB IMDS and on-disk DBMS technology, along with commercially available hardware including Fusion ioDrive2 NAND flash memory from Fusion-io. It also examines the impact of transaction length (long vs. short) on database system performance and the interplay of storage device type with this effect.
Download “Seeking Fast, Durable Data Management: A Database System and Persistent Storage Benchmark.”
MORE WHITE PAPERS NEWS
Discussing the Power of Configurable Process Control
By Anthony Borges, Pinpoint Information Systems
The power of an MES System or configurable process control system is now well beyond that of what...
FCI aims to enhance gas and air ratio control with ST100 flow meter
Installing a direct mass device in the process control loop offers a number of advantages. It allows the operator to achieve a direct ratio of...
An Introduction of Tibbo's AggreGate SCADA/HMI
By Victor Polyakov, Tibbo Systems
This whitepaper is an introduction AggreGate IoT Platform-based products. In 2010, two years after AggreGate...
Industry 4.0-based Network Manager Ensures Solid Industrial Connectivity
With the hot topics of Industry 4.0, Industrial Internet of Things (IIoT), intelligent automation and so forth emerging into the market, factory...
Infinity QS releases whitepaper on automated food safety guidelines
The increasing availability of the tools that facilitate higher levels of manufacturing productivity and quality creates an opportunity for...
Bill’s Deep Dive: Prometheus Multivendor PLC Configuration and Management Software from Wonderware
By Bill Lydon, Editor, Automation.com
Wonderware/Schneider Electric's Prometheus is configuration and management software for defining HMI and...
Abaco announces hiring of Mrinal Iyengar as Vice President, Product Management
In her new role, Iyengar will bring her in-depth understanding of the needs of customers in the embedded computing industry with a brief to drive...
Fairhair and Zigbee Alliances sign partnership agreement to facilitate smart buildings
The two organizations will explore opportunities to combine expertise to simplify the development and deployment of lighting and building...
congatec announces support for SMARC 2.0 specification
First congatec SMARC 2.0 modules as well as carrier boards and starter kits including extensive software, driver and BIOS support will be available...
Allied Market Research releases 2015 Embedded Computing Market report
The report projects that the world embedded computing market is likely to generate revenue of $236.5 billion by 2022, with an estimated CAGR of...