PsiDB: An Algebraic Framework for Batched Query Processing and Its Implementation and Optimization

Tech ID: 19A010

Competitive Advantages

  •     Multiple queries into a single global query
  •     Eliminate redundant I/O in processing queries in a workload
  •     Performance improvement of up to 36X over conventional systems

Summary

Scientists at the USF have introduced a novel theoretical framework for processing multiple queries into a single query expression where the results are distributed among all the individual queries on-the-fly. Moreover, a design and implementation of a query optimizer following the PsiDB method has been developed. Compered to the conventional techniques, this new concept of query processing drastically improve the performance of database systems. Also, PsiDB beats the performance of similar batch-processing systems by speedup of 4X.  

Speedup of PsiDB over MySQL 

Desired Partnerships

  • License
  • Sponsored Research
  • Co-Development

Technology Transfer
TTOinfo@usf.edu
(813) 974-0994

Researcher(s)

Patents