Data Normalization and Schema Evolution for Ticker Symbol Insights
DOI:
https://doi.org/10.63282/3050-9246.IJETCSIT-V7I1P109Keywords:
Ticker Symbol Management, Data Normalization, Schema Evolution, Financial Data Architecture, Identifier Mapping, Data Quality, Regulatory Compliance, Financial DatabasesAbstract
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.
Downloads
References
[1] T.-T. Ho and Y. Huang, “Stock Price Movement Prediction Using Sentiment Analysis and CandleStick Chart Representation,” Sensors, vol. 21, no. 23, p. 7957, Nov. 2021, doi: https://doi.org/10.3390/s21237957.
[2] M. Pykälistö, “How database normalization and schema versioning improve system efficiency, data integrity, and flexibility in changing business settings,” aaltodoc.aalto.fi, 2024, Available: https://aaltodoc.aalto.fi/items/a7b0ec3a-10ee-4479-8b69-9cbfd2809796
[3] City Group, “Citigroup (C) Laps the Stock Market: Here’s Why,” Nasdaq.com, 2025. https://www.nasdaq.com/articles/citigroup-c-laps-stock-market-heres-why-1 (accessed Jan. 12, 2026).
[4] E. Codd, “FURTHER NORMALIZATION OF THE DATA BASE RELATIONAL MODEL,” Aug. 1971. Available: https://forum.thethirdmanifesto.com/wp-content/uploads/asgarosforum/987737/00-efc-further-normalization.pdf
[5] N. Antonio and R. Amato, “Mastering database normalization: A comprehensive exploration of normal forms,” Oct. 2023. Available: https://www.researchgate.net/profile/Nicola-Antonio-Roberto-Amato/publication/374509386_Mastering_database_normalization_A_comprehensive_exploration_of_normal_forms/links/652106cffc5c2a0c3bbe361d/Mastering-database-normalization-A-comprehensive-exploration-of-normal-forms.pdf
[6] Z. Zhang and S. Link, “Synthesizing Third Normal Form Schemata that Minimize Integrity Maintenance and Update Overheads: Parameterizing 3NF by the Numbers of Minimal Keys and Functional Dependencies,” Proceedings of the ACM on Management of Data, vol. 3, no. 3, pp. 1–25, Jun. 2025, doi: https://doi.org/10.1145/3725362.
[7] Z. Brahmia, F. Grandi, and B. Oliboni, “A Literature Review on Schema Evolution in Databases,” Computing Open, vol. 02, Jan. 2024, doi: https://doi.org/10.1142/s2972370124300012.
[8] J. Edwards, T. Petricek, van, and G. Litt, “Schema Evolution in Interactive Programming Systems,” The Art Science and Engineering of Programming, vol. 9, no. 1, Oct. 2024, doi: https://doi.org/10.22152/programming-journal.org/2025/9/2.
[9] S. Frischbier, M. Paic, A. Echler, and C. Roth, “Managing the Complexity of Processing Financial Data at Scale - An Experience Report,” Springer eBooks, pp. 14–26, Nov. 2019, doi: https://doi.org/10.1007/978-3-030-34843-4_2.
[10] Yahoo Finance, “Citigroup, Inc. (C) Stock Price, Quote, History & News,” @YahooFinance, 2019. https://finance.yahoo.com/quote/C/
[11] Investors, “Committee on Uniform Securities Identification Procedures (CUSIP) | Investor.gov,” Investor.gov, 2026. https://www.investor.gov/introduction-investing/investing-basics/glossary/committee-uniform-securities-identification (accessed Jan. 12, 2026).
[12] ISIN, “ISIN Organization: international securities identification numbers organization,” Isin.org, 2023. https://www.isin.org/
[13] Open FIGI, “Overview | OpenFIGI,” Openfigi.com, 2025. https://www.openfigi.com/about/overview (accessed Jan. 12, 2026).
[14] C. Mazzocca, A. Acar, Selcuk Uluagac, R. Montanari, Paolo Bellavista, and M. Conti, “A Survey on Decentralized Identifiers and Verifiable Credentials,” IEEE Communications Surveys & Tutorials, pp. 1–1, Jan. 2025, doi: https://doi.org/10.1109/comst.2025.3543197
[15] Z. B. Yusof, “The Role of High-Quality Data in Risk Assessment: Strategies for Ensuring Accuracy, Completeness, and Timeliness in Financial Predictive Analytics,” International Journal of Advanced Computational Methodologies and Emerging Technologies, vol. 15, no. 2, pp. 8–16, 2025, Available: https://owenpress.com/index.php/IJACMET/article/view/2025-02-07
[16] L. Evans, “A Smart Data Ecosystem for the Monitoring of Financial Market Irregularities,” e-space.mmu.ac.uk, Sep. 21, 2022. https://e-space.mmu.ac.uk/630409/
[17] M. Golfarelli and S. Rizzi, “From Star Schemas to Big Data: 20 $$+$$ Years of Data Warehouse Research,” Studies in Big Data, pp. 93–107, May 2017, doi: https://doi.org/10.1007/978-3-319-61893-7_6.
[18] Vijayan Naveen Edapurath, “Building Scalable Data Warehouses for Financial Analytics in Large Enterprises,” Philpapers.org, 2024. https://philpapers.org/rec/NAVBSD-2 (accessed Sep. 17, 2025).
[19] N. J. Rodrigues, “Transforming enterprise finance with data-centric architectures and platform integration,” World Journal of Advanced Engineering Technology and Sciences, vol. 15, no. 3, pp. 937–945, Jun. 2025, doi: https://doi.org/10.30574/wjaets.2025.15.3.1001.
[20] H. Gadde, “AI-Driven Schema Evolution and Management in Heterogeneous Databases,” International Journal of Machine Learning Research in Cybersecurity and Artificial Intelligence, Oct. 19, 2024. https://www.academia.edu/download/119017466/332_356_ijmlrcai_2019.pdf (accessed Aug. 31, 2025).
[21] V. B. Ramu, “Optimizing Database Performance: Strategies for Efficient Query Execution and Resource Utilization,” International Journal of Computer Trends and Technology, vol. 71, no. 7, pp. 15–21, Jul. 2023, doi: https://doi.org/10.14445/22312803/ijctt-v71i7p103.
[22] F. Ekundayo, “International Journal of Engineering Technology Research & Management STRATEGIES FOR MANAGING DATA ENGINEERING TEAMS TO BUILD SCALABLE, SECURE REST APIS FOR REAL-TIME FINTECH APPLICATIONS,” 2024. Accessed: Jun. 11, 2025. [Online]. Available: https://ijetrm.com/issues/files/May-2023-22-1747903717-AUG202314.pdf
[23] B. Hamdikatama, “BEYOND ALGORITHMS: AN INTEGRATED APPROACH TO FAKE NEWS DETECTION USING MACHINE LEARNING TECHNIQUES,” JITK (Jurnal Ilmu Pengetahuan dan Teknologi Komputer), vol. 10, no. 3, Feb. 2025, doi: https://doi.org/10.33480/jitk.v10i3.6061.
[24] AWS, “OLAP vs. OLTP - Comparing Data Processing Systems - AWS,” Amazon Web Services, Inc., 2025. https://aws.amazon.com/compare/the-difference-between-olap-and-oltp/
[25] R. Sekar, “The need for auto schema evolution in modern data engineering: Challenges and solutions,” World Journal of Advanced Research and Reviews, vol. 26, no. 1, pp. 909–917, Apr. 2025, doi: https://doi.org/10.30574/wjarr.2025.26.1.1115.
[26] Manolis Katopis, “The Expand and Contract pattern,” Medium, Oct. 24, 2023. https://medium.com/@ekatopis/the-expand-and-contract-pattern-0479a74f4f2d (accessed Jan. 12, 2026).
[27] T. Wellhausen, “Expand and Contract - A Pattern to Apply Breaking Changes to Persistent Data with Zero Downtime,” Tim-wellhausen.de, 2018. https://www.tim-wellhausen.de/papers/ExpandAndContract/ExpandAndContract.html (accessed Jan. 12, 2026).
[28] CFI, “High-Frequency Trading (HFT),” Corporate Finance Institute, 2025. https://corporatefinanceinstitute.com/resources/equities/high-frequency-trading-hft/
[29] F. Musciotto, J. Piilo, and R. N. Mantegna, “High-frequency trading and networked markets,” Proceedings of the National Academy of Sciences, vol. 118, no. 26, Jun. 2021, doi: https://doi.org/10.1073/pnas.2015573118.
[30] Ravish Tillu, Muthukrishnan Muthusubramanian, and Vathsala Periyasamy, “Transforming Regulatory Reporting with AI/ML: Strategies for Compliance and Efficiency,” Journal of knowledge learning and science technology, vol. 2, no. 1, pp. 145–157, Jun. 2023, doi: https://doi.org/10.60087/jklst.vol2.n1.p157.
[31] M. A. Mallouli, Romain Perchet, François Soupé, and R. Leote, “Multi-Asset Portfolios with Active and Passive Funds: A Robust Optimization Framework,” SSRN Electronic Journal, Jan. 2025, doi: https://doi.org/10.2139/ssrn.5863562.
[32] Ramteke Rakesh, “The Role of Caching in Modern System Design,” Medium, May 30, 2025. https://medium.com/@ramteke.rakesh/the-role-of-caching-in-modern-system-design-a30132d0c438 (accessed Jan. 12, 2026).
[33] J. M. García Lara, B. García Osma, I. Gazizova, and A. Khalilov, “Demand-driven corporate social responsibility: Symbolic versus substantive change after environmental disasters,” Journal of Corporate Finance, vol. 94, p. 102816, Sep. 2025, doi: https://doi.org/10.1016/j.jcorpfin.2025.102816.
[34] F. C. Mendes, P. Sarna, Pavel Emelyanov, and C. Dunlop, Database Performance at Scale. 2023. doi: https://doi.org/10.1007/978-1-4842-9711-7.
[35] R. D. Edwardson, “Implementing Role-Based Access Control (RBAC) for Least Privilege Security,” Medium, Mar. 02, 2025. https://medium.com/o-m-n-i-navigating-the-new-cyber-era/implementing-role-based-access-control-rbac-for-least-privilege-security-f382b4083c82
[36] BIS, “Global FX trading hits $9.6 trillion per day in April 2025 and OTC interest rate derivatives surge to $7.9 trillion: Triennial Survey,” Bis.org, Sep. 30, 2025. https://www.bis.org/press/p250930.htm (accessed Oct. 05, 2025).
[37] C. P. Ratnawat, “AI-POWERED STORY CREATION: TRANSFORMING AGILE DEVELOPMENT IN THE INSURANCE INDUSTRY,” INTERNATIONAL JOURNAL OF RESEARCH IN COMPUTER APPLICATIONS AND INFORMATION TECHNOLOGY, vol. 7, no. 2, pp. 2464–2473, Dec. 2024, doi: https://doi.org/10.34218/ijrcait_07_02_183.
