Design and Implementation of Database Independent Auto Sequence Numbers

TL;DR

This paper presents a method for creating database-independent auto sequence numbers that are reusable and solve common problems associated with autonumber fields across different database systems.

Contribution

It introduces a novel approach to implement autonumber functionality independently of specific database systems, enhancing portability and reliability.

Findings

Proposed a reusable, database-independent autonumber solution.

Addressed common autonumber issues across various database systems.

Enhanced ease of use comparable to modern relational databases.

Abstract

Developers across the world use autonumber or auto sequences field of the backend databases for developing both the desktop and web based data centric applications which is easier to use at the development and deployment purpose but can create a lot of problems under varied situations. This paper examines how a database independent autonumber could be developed and reused solving all the problems as well as providing the same degree of easy to use features of autonumber offered by modern Relational Database Systems.