Skip to main content

Integrating Third-Party Data (D&B, ZoomInfo, Construction Feeds) into a Unified Data Model

Sravan Kumar Kunadi

Abstract

The amalgamation of third party data provider, such as Dun and Bradstreet (D&B), Zoom info and construction feeds into one data structure has become more crucial where the organizations need to have correct, enriched, and actionable business intelligence. They provide immense information on firmographics, contact intelligence, project activity, financial indicators and market trends, but due to their separate data structures, varying standards and identifiers, interoperability and use as analytics become some of the biggest interoperability problems ever. The paper presents a framework of applying heterogeneous third-party datasets into one data model that is consistent, scaled to support and enhance decision-making. The paper will focus on such essential processes as schema mapping, entity resolution, data standardization, deduplication and harmonization of master data. It also addresses issues relating to data quality, semantic wars, reliability of the source and governance requirements during the pull together. By aligning multiple sources external to organizations using a common data architecture, organizations can seek a unified and consistent view of companies, contacts and construction opportunities. The proposed solution enhances the downstream applications, such as: customer relationship management, market segmentation, lead scoring, sales intelligence and predictive analytics. In addition to this, the paper has observed the strategic benefits of being able to integrate data to enhance operational efficiency, reduce redundancy and the availability of data across functional boundaries. The findings suggest that an efficient integrated data model does not only simplify utilizing third-party data, but it additionally boosts business operations based on data in dynamic and competitive business contexts.

Article Information

Journal

International Journal of Science, Research and Technology

Volume (Issue)

Vol. 6 No. 5 (2023): International Journal of Science, Research and Technology (IJSRAT)

DOI

https://doi.org/10.15662/IJSRAT.2023.0605020

Pages

10661-10671

Published

September 12, 2023
Copyright

Open Access

This work is licensed under a Creative Commons Attribution 4.0 International License.

How to Cite

Sravan Kumar Kunadi (%2023). Integrating Third-Party Data (D&B, ZoomInfo, Construction Feeds) into a Unified Data Model. International Journal of Science, Research and Technology , Vol. 6 No. 5 (2023): International Journal of Science, Research and Technology (IJSRAT) , pp. 10661-10671. https://doi.org/10.15662/IJSRAT.2023.0605020

References

[1] O. Binette and R. C. Steorts, “(Almost) all of entity resolution,” Science Advances, vol. 8, no. 12, p. eabi8021, 2022.
[2] V. Christophides, V. Efthymiou, T. Palpanas, G. Papadakis, and K. Stefanidis, “An overview of end-to-end entity resolution for big data,” ACM Computing Surveys, vol. 53, no. 6, pp. 1–42, 2021.
[3] G. Papadakis, E. Ioannou, E. Thanos, and T. Palpanas, The Four Generations of Entity Resolution. San Rafael, CA, USA: Morgan & Claypool, 2021.
[4] I. F. Ilyas and X. Chu, Data Cleaning. New York, NY, USA: Association for Computing Machinery, 2019.
[5] J. Asher, D. Resnick, J. Brite, R. Brackbill, and J. Cone, “An introduction to probabilistic record linkage with a focus on linkage processing for WTC registries,” Int. J. Environ. Res. Public Health, vol. 17, no. 18, p. 6937, 2020.
[6] A. Jurek-Loughrey and P. Deepak, “Semi-supervised and unsupervised approaches to record pairs classification in multi-source data linkage,” in Semi-Supervised and Unsupervised Approaches to Record Pairs Classification, Cham, Switzerland: Springer, 2019, pp. 55–78.
[7] T. Enamorado, B. Fifield, and K. Imai, “Using a probabilistic model to assist merging of large-scale administrative records,” Amer. Polit. Sci. Rev., vol. 113, no. 2, pp. 353–371, 2019.
[8] M. Shan, K. Thomas, and R. Gutman, “A Bayesian multi-layered record linkage procedure to analyze functional status of medicare patients with traumatic brain injury,” arXiv preprint arXiv:2005.08549, 2020.
[9] E. Farley and R. Gutman, “A Bayesian approach to linking data without unique identifiers,” arXiv preprint arXiv:2012.00601, 2020.
[10] X. L. Dong and D. Srivastava, Big Data Integration. San Rafael, CA, USA: Morgan & Claypool, 2015.
[11] A. Doan, A. Halevy, and Z. Ives, Principles of Data Integration. Burlington, MA, USA: Morgan Kaufmann, 2012.
[12] A. K. Elmagarmid, P. G. Ipeirotis, and V. S. Verykios, “Duplicate record detection: A survey,” IEEE Trans. Knowl. Data Eng., vol. 19, no. 1, pp. 1–16, 2007.