Invention Grant
- Patent Title: Extract-transform-load script generation
-
Application No.: US17084161Application Date: 2020-10-29
-
Publication No.: US11630833B2Publication Date: 2023-04-18
- Inventor: Manish Kesarwani , Sumit Bhatia , Sameep Mehta
- Applicant: International Business Machines Corporation
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Ference & Associates LLC
- Main IPC: G06F16/25
- IPC: G06F16/25 ; G06F16/242 ; G06F16/2455 ; G06F16/2457

Abstract:
One embodiment provides a computer implemented method, including: receiving, from a user, a natural language query for data contained within at least one data repository; identifying at least one concept from the natural language query, wherein the at least one concept includes an entity and an intent; identifying a plurality of datasets satisfying the natural language query by querying the at least one data repository utilizing the at least one concept; ranking the dataset based on relevance to the query; generating an extract-transform-load script that extracts, transforms, and loads a dataset selected by the user from the plurality of datasets; and retrieving data included in the dataset utilizing the extract-transform-load script, wherein the retrieving includes returning the data to the user.
Public/Granted literature
- US20220138216A1 EXTRACT-TRANSFORM-LOAD SCRIPT GENERATION Public/Granted day:2022-05-05
Information query