Comdb2 bloomberg's highly available relational database system

Abstract

Comdb2 is a distributed database system designed for geographical replication and high availability. In contrast with the latest trends in this field, Comdb2 o↵ers full transactional support, a standard relational model, and the expressivity of SQL. Moreover, the system allows for rich stored procedures using a dialect of Lua. Comdb2 implements a serializable system in which reads from any node always return current values. Comdb2 provides transparent High Availability through built-in service discovery and sophisticated retry logic embedded in the standard API. In addition to the relational data model, Comdb2 implements queues for publisher-to-subscriber message delivery. Queues can be combined with table triggers for timeconsistent log distribution, providing functionality commonly needed in modern OLTP. In this paper we give an overview of our last twelve years of work. We focus on the design choices that have made Comdb2 the primary database solution within our company, Bloomberg LP (BLP).

A Hybrid Shortest Path Algorithm for IKEA Warehousing System

“…For example, one customers would like to pick up from node 1,18,7,12,13,6. The Test set is {1,18,7,12,13,6}.…”

“…Warehousing information often involves with the information related to the warehouse management and inventory control [6]. This article combines the traditional shortest path method which concerns with the location of the product as well as the destination in warehousing facilities and the technology-based warehousing information to constitute a more efficiency and timesaving management system.…”