Scribd
Upload
11 views16 pages

Inventory Management with Berkeley DB

This document describes an inventory management system that uses Berkeley DB as its underlying data storage. It provides concise summaries of key points: 1) Berkeley DB is an embedded open source database library that provides scalable and high-performance transactional data management services via a simple API. 2) Berkeley DB uses an in-process function call interface, requiring no inter-process communication, unlike SQL-based RDBMS which require parsing and execution planning. 3) The inventory management system uses the small 2MB Berkeley DB library versus a large multi-GB RDBMS application.

Uploaded by

Balakrishnan Pillai Perumal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
11 views16 pages

Inventory Management with Berkeley DB

This document describes an inventory management system that uses Berkeley DB as its underlying data storage. It provides concise summaries of key points: 1) Berkeley DB is an embedded open source database library that provides scalable and high-performance transactional data management services via a simple API. 2) Berkeley DB uses an in-process function call interface, requiring no inter-process communication, unlike SQL-based RDBMS which require parsing and execution planning. 3) The inventory management system uses the small 2MB Berkeley DB library versus a large multi-GB RDBMS application.

Uploaded by

Balakrishnan Pillai Perumal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd

Inventory Management System

With Berkeley DB

1
What is Berkeley DB?

Berkeley DB is an Open Source embedded


database library that provides scalable, high-
performance, transaction-protected data
management services to applications. Berkeley
DB provides a simple function-call API for data
access and management.

2
Berkeley DB vs RDBMS

Function-call interface vs SQL Statement


Because the library runs in the same address
space, no inter-process communication is required
for database operations.
Berkeley DB uses a simple function-call interface
for all operations, there is no query language to
parse, and no execution plan to produce.

3
2MB library vs GB application

Inventory Management System Inventory Management System


with BDB with RDBMS

4
What can you get from this App?

Functionality:
Inventory management
Look up and update items and vendors
Add or remove items and vendors
Add new categories, such as clothes and food
Sales log management
Look up sales records
Add or remove sales records
Daily sales summary
Pattern discoverer
Find the best-selling items
Find the sales peak

5
Performance:
With Berkeley DB as the underlying storage, this
application is built to provide fast, reliable,
transaction-protected inventory management.
By keeping the library small and simple, we
guarantee that the database system stays fast,
because there is very little code to execute.
Deployment and Maintenance:
Users can save money by replacing the local
servers in each store with Windows tablets

6
User Manual

7
Look up an item and vendor

8
Add a new item

9
Add a new vendor

10
Add a new category

11
Look up sales log

12
Add a new sales record

13
Daily sales summary

14
Find pattern based on item

15
Find pattern based on time

16

You might also like