Oracle ETL Tools and AI Integration: New Data Management Approach
Abstract
Industries like Healthcare produce enormous amounts of data. Collecting, cleaning, and processing the data to make the data available for deep insights is a greater need in today’s competitive world. This process of data integration and data management is called Extract, Transform, Load (ETL). There are several products and tools in the market to accomplish this task. The focus of this paper is on Oracle data management tools, the Oracle ETL tool set. Combining Artificial Intelligence (AI) with ETL tools is changing how data is managed and processed. Oracle’s ETL tools, like Oracle Data Integrator (ODI) and Oracle GoldenGate, are key in handling large data movements and transformations. As AI technologies advance, these tools are now including smart features to automate, optimize, and improve the ETL processes. This paper looks into how AI can be added to Oracle ETL tools, discussing the advantages, challenges, and future possibilities of these integrations for better data processing, decision-making, and business analysis.
How to Cite This Article
Kiran Veernapu (2020). Oracle ETL Tools and AI Integration: New Data Management Approach . International Journal of Multidisciplinary Research and Growth Evaluation (IJMRGE), 1(5), 120-124. DOI: https://doi.org/10.54660/IJMRGE.2020.1.5-120-124
References
- 1. Lo AW, Brynjolfsson E. Theriseofdatacapital. MITTechnology Review Custom; c2016.
- 2. Sirsikar S, Jain A, Raina D, Munot R, Nimbhorkar W. Databaseagnostic ETLtool: Aneconomicalsolutiontostoreandprocessdata. Int JComput Sci Appl.2016;9(1\.
- 3. Oracle?. Releasenotesfor Oracle Data Integrator12c(12.2.1.3.0\E96506-
- 3. Oracle; c
- 2019. Availablefrom: https://docs. oracle. com/cd/F17736_01/12.2.1.3/odirn/release-notes-oracle-data-integrator. pdf
- 4. Oracle. Oracle Data Integrator12c Architecture Overview. Oracle; c
- 2014. Availablefrom: https://www. oracle. com/technetwork/middleware/data-integrator/overview/oracledi-architecture-1-129425. pdf
- 5. Gupta R, Gupta R. Introductionto Oracle Golden Gate(OGG\. In: Mastering Oracle Golden Gate.2016:3-10.
- 6. Oracle Help Center. Oracle Golden Gatefor Windowsand Unix. Oracle; c
- 2020. Availablefrom: https://docs. oracle. com/goldengate
- 7. Roh Y, Heo G, Whang SE. Asurveyondatacollectionformachinelearning: Abigdata-AIintegrationperspective. IEEETrans Knowl Data Eng.2019;33(4\:1328-1347.
- 8. Gadde H. AI-enhanceddatawarehousing: Optimizing ETLprocessesforreal-timeanalytics. Rev Intellig Artif Med.2020;11(1\:300-327.
- 9. Mikkilineni R. Convergenceofnaturalintelligenceandartificialintelligence. In: Theoretical Information Studies: Informationinthe World.2020:391-415.
- 10. Davuluri M. Navigating AI-drivendatamanagementinthecloud: Exploringlimitationsandopportunities. Trans Latest Trends Io T.2018;1(1\:106-112.
- 11. Raschka S, Patterson J, Nolet C. Machinelearningin Python: Maindevelopmentsandtechnologytrendsindatascience, machinelearning, andartificialintelligence. Inf.2020;11(4\:193.
- 12. Needle D. Oracleupdatesautonomouscloudservices, dataintegration. e Week.
- 2018. Availablefrom: https://www. eweek. com/cloud/oracle-updates-autonomous-cloud-services-data-integration/
- 13. Abellera R, Bulusu L. Oraclebusinessintelligencewithmachinelearning. In: Artificial Intelligence Techniquesin OBIEEfor Actionable BI.2018:978-1.
- 14. Curtis B, Curtis B. Monitoring Oracle Golden Gate. In: Pro Oracle Golden Gateforthe DBA.2016:79-100.
- 15. Mondal KC, Biswas N, Saha S. Roleofmachinelearningin ETLautomation. In: Proc21st Int Conf Distribut Comput Networking.2020:1-
- 6. International Journalof Multidisciplinary Researchand Growth Evaluationwww. allmultidisciplinaryjournal. com
- 12416. Davenport TH. Fromanalyticstoartificialintelligence. JBus Anal.2018;1(2\:73-80.
- 17. Chinta S. Theroleofgenerative AIin Oracledatabaseautomation: Revolutionizingdatamanagementandanalytics. World JAdv Res Rev.
- 2019. Availablefrom: https://doi. org/10.30574/wjarr