Data Normalization and Schema Evolution for Ticker Symbol Insights
Abstract
In this paper, the author will analyze the manner in which the data normalization and schema evolution enhance the management of ticker symbols in financial systems. It points to the constraints of the conventional flat and poorly normalized designs to manage corporate actions and identifier changes and be historically accurate. The study uses normalization to 3NF plus bi-temporal extensions with expand-migrate-contract schema evolution patterns to show how financial databases can ensure superior data integrity, regulations compliance and scalability of the systems. The results offer effective architectural principles of creating robust, scalable, and quality infrastructures of financial reference data.
Fields of Study & Subjects
Advanced Database Systems and Queries
Data Quality and Management
Engineering and Information Technology
Publication details
- Journal / source
- International Journal of Emerging Trends in Computer Science and Information Technology
- Volume
- 7
- Issue
- 1
- Pages
- 63–72
- Publication date
- 1 January 2026
- Language
- EN