Towards the design and implementation of a multilevel secure deductive database management system

Author(s):  
B. Thuraisingham
2017 ◽  
Vol 13 (1) ◽  
pp. 118-128
Author(s):  
Sama Salam Samaan

The main aim of this paper are the design and implementation of a pharmaceutical inventory database management system. The system was implemented by creating a database containing information about the stored medicines in the inventory, customers making transactions with the pharmaceutical trading company (which owns the inventory), medical suppliers, employees, payments, etc. The database was connected to the main application using C sharp. The proposed system should help in manag inginventory operations which include adding/updating employees’ information, preparing sale and purchase invoices, generating reports, adding/updating customers and suppliers, tracking customer payments and checking expired medicines in order to be disposed. The system can be used to facilitate smooth workflow of sale and purchase operations and bring the advantages of having the most efficient control with minimal efforts.


Author(s):  
Ana Aguilera ◽  
José Tomás Cadenas ◽  
Leonid Tineo

This chapter is focused in incorporating the fuzzy capabilities to a relational database management system (RDBMS) of open source. The fuzzy capabilities include connectors, modifiers, comparators, quantifiers, and queries. The extensions consider a more flexible DDL and DML languages. The aim is to show the design and implementation details in the RDBMS PostgreSQL. For this, a fuzzy query processor and fuzzy access mechanism has been designed and implemented. The physical fuzzy relational operators have been also defined and implemented. The flow of a fuzzy query through the different modules (parser, planner, optimizer, and executor) has been shown. Some experimental results have been included to demonstrate the performance of the proposal solution. These results show that the extensions have not decreased the performance of the RDBMS.


Sign in / Sign up

Export Citation Format

Share Document