ABSTRACT

This project introduces SocketDB, a novel real-time SQL database system specifically engineered to meet the evolving demands of contemporary applications requiring instantaneous data updates and robust query processing capabilities. By integrating a WebSocket-based notification system, SocketDB offers a unique approach, allowing clients to subscribe and instantly receive updates, thus facilitating real-time interactions and analytics. Built on a columnar data layout, it ensures efficient query performance and storage optimization, particularly beneficial for read-intensive scenarios. The core of SocketDB is enhanced by a recursive descent SQL parser, enabling comprehensive support for a wide array of SQL operations, making it highly adaptable to complex data manipulation needs. Additionally, SocketDB incorporates advanced features such as data compression with the Zstandard algorithm, ensuring reduced storage footprint without compromising access speed. Embedded fault tolerance mechanisms and scalable infrastructure further reinforce its reliability and applicability in diverse environments. Aimed at developers and businesses alike, SocketDB is poised to transform real-time data handling, offering a scalable, efficient, and user-friendly platform for dynamic data management and analysis.