Patents by Inventor Ritesh K. Gupta
Ritesh K. Gupta has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 10673801Abstract: A computer detects initialization of a first messaging session. The computer receives one or more message commands relating to one or more messages. The computer monitors message progress of the first messaging session. The computer detects errors in the message progress. The computer starts one or more additional messaging session(s). The computer monitors message progress of the first messaging session and the one or more additional messaging session(s). The computer detects contraction of messaging sessions is appropriate. The computer closes one or more messaging sessions.Type: GrantFiled: November 29, 2017Date of Patent: June 2, 2020Assignee: International Business Machines CorporationInventors: Venkat R. Arra, Ritesh K. Gupta
-
Patent number: 10579638Abstract: A method for testing an extract, transform, load job (ETL job) is provided. The method may include receiving an uploaded ETL job. The method may also include executing a functionality test of the uploaded ETL job using a test bucket. The method may further include determining the executed functionality test produces a failure result. The method may also include creating at least one test sub-job corresponding to at least one stage within on the uploaded ETL job. The method may further include generating a plurality of test data for each of the at least one created test sub-job. The method may also include executing the at least one created test sub-job using the plurality of generated test data. The method may further include creating a report based on a plurality of results associated with the at least one executed test sub-job.Type: GrantFiled: November 22, 2016Date of Patent: March 3, 2020Assignee: International Business Machines CorporationInventors: Raghavendra R. Dhayapule, Ritesh K. Gupta, Sumit Kumar, Rajesh Phillips
-
Patent number: 10366112Abstract: Compiling test cases. The method may include uploading at least one extract, transform, load job (ETL job) and a plurality of test cases. The method may also include identifying a plurality of design features associated with the at least one uploaded ETL job. The method may further include identifying at least one feature change within the plurality of identified design features. The method may also include determining a plurality of related test cases within the plurality of uploaded test cases corresponding to the at least one identified feature change. The method may further include creating a test bucket based on a grouping of the determined plurality of related test cases. The method may also include adding at least one of a plurality of corresponding ETL jobs and a plurality of corresponding ETL job stages associated with the at least one identified feature change to the created test bucket.Type: GrantFiled: March 22, 2018Date of Patent: July 30, 2019Assignee: International Business Machines CorporationInventors: Raghavendra R. Dhayapule, Ritesh K. Gupta, Sumit Kumar, Rajesh Phillips
-
Patent number: 10353913Abstract: A method for testing an extract, transform, load job (ETL job) is provided. The method may include receiving an uploaded ETL job. The method may also include executing a functionality test of the uploaded ETL job using a test bucket. The method may further include determining the executed functionality test produces a failure result. The method may also include creating at least one test sub-job corresponding to at least one stage within on the uploaded ETL job. The method may further include generating a plurality of test data for each of the at least one created test sub-job. The method may also include executing the at least one created test sub-job using the plurality of generated test data. The method may further include creating a report based on a plurality of results associated with the at least one executed test sub-job.Type: GrantFiled: June 14, 2018Date of Patent: July 16, 2019Assignee: International Business Machines CorporationInventors: Raghavendra R. Dhayapule, Ritesh K. Gupta, Sumit Kumar, Rajesh Phillips
-
Publication number: 20190166081Abstract: A computer detects initialization of a first messaging session. The computer receives one or more message commands relating to one or more messages. The computer monitors message progress of the first messaging session. The computer detects errors in the message progress. The computer starts one or more additional messaging session(s). The computer monitors message progress of the first messaging session and the one or more additional messaging session(s). The computer detects contraction of messaging sessions is appropriate. The computer closes one or more messaging sessions.Type: ApplicationFiled: November 29, 2017Publication date: May 30, 2019Inventors: Venkat R. Arra, Ritesh K. Gupta
-
Patent number: 10140355Abstract: Compiling test cases. The method may include uploading at least one extract, transform, load job (ETL job) and a plurality of test cases. The method may also include identifying a plurality of design features associated with the at least one uploaded ETL job. The method may further include identifying at least one feature change within the plurality of identified design features. The method may also include determining a plurality of related test cases within the plurality of uploaded test cases corresponding to the at least one identified feature change. The method may further include creating a test bucket based on a grouping of the determined plurality of related test cases. The method may also include adding at least one of a plurality of corresponding ETL jobs and a plurality of corresponding ETL job stages associated with the at least one identified feature change to the created test bucket.Type: GrantFiled: September 2, 2015Date of Patent: November 27, 2018Assignee: International Business Machines CorporationInventors: Raghavendra R. Dhayapule, Ritesh K. Gupta, Sumit Kumar, Rajesh Phillips
-
Publication number: 20180293287Abstract: A method for testing an extract, transform, load job (ETL job) is provided. The method may include receiving an uploaded ETL job. The method may also include executing a functionality test of the uploaded ETL job using a test bucket. The method may further include determining the executed functionality test produces a failure result. The method may also include creating at least one test sub-job corresponding to at least one stage within on the uploaded ETL job. The method may further include generating a plurality of test data for each of the at least one created test sub-job. The method may also include executing the at least one created test sub-job using the plurality of generated test data. The method may further include creating a report based on a plurality of results associated with the at least one executed test sub-job.Type: ApplicationFiled: June 14, 2018Publication date: October 11, 2018Inventors: Raghavendra R. Dhayapule, Ritesh K. Gupta, Sumit Kumar, Rajesh Phillips
-
Patent number: 10067993Abstract: Handling extract-transform-load (ETL) job mismatches as “exceptions.” Exception handling may include the following steps: (i) determining a mismatch while running an extract-transform-load job with the mismatch being a mismatch of at least one of the following types: design time information mismatch, and/or operational metadata mismatch; and (ii) responsive to determining the mismatch, handling the mismatch as an exception.Type: GrantFiled: August 11, 2016Date of Patent: September 4, 2018Assignee: International Business Machines CorporationInventors: Raghavendra R. Dhayapule, Ritesh K. Gupta, Ajay Sood
-
Patent number: 10042903Abstract: A method for testing an extract, transform, load job (ETL job) is provided. The method may include receiving an uploaded ETL job. The method may also include executing a functionality test of the uploaded ETL job using a test bucket. The method may further include determining the executed functionality test produces a failure result. The method may also include creating at least one test sub-job corresponding to at least one stage within on the uploaded ETL job. The method may further include generating a plurality of test data for each of the at least one created test sub-job. The method may also include executing the at least one created test sub-job using the plurality of generated test data. The method may further include creating a report based on a plurality of results associated with the at least one executed test sub-job.Type: GrantFiled: September 2, 2015Date of Patent: August 7, 2018Assignee: International Business Machines CorporationInventors: Raghavendra R. Dhayapule, Ritesh K. Gupta, Sumit Kumar, Rajesh Phillips
-
Publication number: 20180210949Abstract: Compiling test cases. The method may include uploading at least one extract, transform, load job (ETL job) and a plurality of test cases. The method may also include identifying a plurality of design features associated with the at least one uploaded ETL job. The method may further include identifying at least one feature change within the plurality of identified design features. The method may also include determining a plurality of related test cases within the plurality of uploaded test cases corresponding to the at least one identified feature change. The method may further include creating a test bucket based on a grouping of the determined plurality of related test cases. The method may also include adding at least one of a plurality of corresponding ETL jobs and a plurality of corresponding ETL job stages associated with the at least one identified feature change to the created test bucket.Type: ApplicationFiled: March 22, 2018Publication date: July 26, 2018Inventors: Raghavendra R. Dhayapule, Ritesh K. Gupta, Sumit Kumar, Rajesh Phillips
-
Patent number: 9959336Abstract: Compiling test cases. The method may include uploading at least one extract, transform, load job (ETL job) and a plurality of test cases. The method may also include identifying a plurality of design features associated with the at least one uploaded ETL job. The method may further include identifying at least one feature change within the plurality of identified design features. The method may also include determining a plurality of related test cases within the plurality of uploaded test cases corresponding to the at least one identified feature change. The method may further include creating a test bucket based on a grouping of the determined plurality of related test cases. The method may also include adding at least one of a plurality of corresponding ETL jobs and a plurality of corresponding ETL job stages associated with the at least one identified feature change to the created test bucket.Type: GrantFiled: September 22, 2016Date of Patent: May 1, 2018Assignee: International Business Machines CorporationInventors: Raghavendra R. Dhayapule, Ritesh K. Gupta, Sumit Kumar, Rajesh Phillips
-
Patent number: 9679033Abstract: Insertion, in a data warehouse process, of a buffer operator between an upstream data operator and a downstream data operator. The processor processes a data record for the upstream data operator to pass to the downstream data operator. In response to determining that the downstream data operator is not ready to accept the data record from the upstream data operator, a buffer operator is inserted between the upstream data operator and the downstream data operator. The data record processed by the upstream data operator is passed to the buffer operator for storing into a buffer allocated for use by the buffer operator. The data record stored into the buffer is passed to the downstream data operator when the downstream data operator is ready to accept data. In another aspect, when the allocated buffer utilization decreases to a threshold value, the buffer operator is removed and the buffers are released.Type: GrantFiled: March 21, 2014Date of Patent: June 13, 2017Assignee: International Business Machines CorporationInventors: Krishna K. Bonagiri, Kalyanji Chintakayala, Ritesh K. Gupta
-
Publication number: 20170075967Abstract: A method for testing an extract, transform, load job (ETL job) is provided. The method may include receiving an uploaded ETL job. The method may also include executing a functionality test of the uploaded ETL job using a test bucket. The method may further include determining the executed functionality test produces a failure result. The method may also include creating at least one test sub-job corresponding to at least one stage within on the uploaded ETL job. The method may further include generating a plurality of test data for each of the at least one created test sub-job. The method may also include executing the at least one created test sub-job using the plurality of generated test data. The method may further include creating a report based on a plurality of results associated with the at least one executed test sub-job.Type: ApplicationFiled: November 22, 2016Publication date: March 16, 2017Inventors: Raghavendra R. Dhayapule, Ritesh K. Gupta, Sumit Kumar, Rajesh Phillips
-
Publication number: 20170060968Abstract: Compiling test cases. The method may include uploading at least one extract, transform, load job (ETL job) and a plurality of test cases. The method may also include identifying a plurality of design features associated with the at least one uploaded ETL job. The method may further include identifying at least one feature change within the plurality of identified design features. The method may also include determining a plurality of related test cases within the plurality of uploaded test cases corresponding to the at least one identified feature change. The method may further include creating a test bucket based on a grouping of the determined plurality of related test cases. The method may also include adding at least one of a plurality of corresponding ETL jobs and a plurality of corresponding ETL job stages associated with the at least one identified feature change to the created test bucket.Type: ApplicationFiled: September 2, 2015Publication date: March 2, 2017Inventors: Raghavendra R. Dhayapule, Ritesh K. Gupta, Sumit Kumar, Rajesh Phillips
-
Publication number: 20170060971Abstract: Compiling test cases. The method may include uploading at least one extract, transform, load job (ETL job) and a plurality of test cases. The method may also include identifying a plurality of design features associated with the at least one uploaded ETL job. The method may further include identifying at least one feature change within the plurality of identified design features. The method may also include determining a plurality of related test cases within the plurality of uploaded test cases corresponding to the at least one identified feature change. The method may further include creating a test bucket based on a grouping of the determined plurality of related test cases. The method may also include adding at least one of a plurality of corresponding ETL jobs and a plurality of corresponding ETL job stages associated with the at least one identified feature change to the created test bucket.Type: ApplicationFiled: September 22, 2016Publication date: March 2, 2017Inventors: Raghavendra R. Dhayapule, Ritesh K. Gupta, Sumit Kumar, Rajesh Phillips
-
Publication number: 20170060969Abstract: A method for testing an extract, transform, load job (ETL job) is provided. The method may include receiving an uploaded ETL job. The method may also include executing a functionality test of the uploaded ETL job using a test bucket. The method may further include determining the executed functionality test produces a failure result. The method may also include creating at least one test sub-job corresponding to at least one stage within on the uploaded ETL job. The method may further include generating a plurality of test data for each of the at least one created test sub-job. The method may also include executing the at least one created test sub-job using the plurality of generated test data. The method may further include creating a report based on a plurality of results associated with the at least one executed test sub-job.Type: ApplicationFiled: September 2, 2015Publication date: March 2, 2017Inventors: Raghavendra R. Dhayapule, Ritesh K. Gupta, Sumit Kumar, Rajesh Phillips
-
Publication number: 20160350390Abstract: Handling extract-transform-load (ETL) job mismatches as “exceptions.” Exception handling may include the following steps: (i) determining a mismatch while running an extract-transform-load job with the mismatch being a mismatch of at least one of the following types: design time information mismatch, and/or operational metadata mismatch; and (ii) responsive to determining the mismatch, handling the mismatch as an exception.Type: ApplicationFiled: August 11, 2016Publication date: December 1, 2016Inventors: Raghavendra R. Dhayapule, Ritesh K. Gupta, Ajay Sood
-
Patent number: 9449060Abstract: Handling extract-transform-load (ETL) job mismatches as “exceptions.” Exception handling may include the following steps: (i) determining a mismatch while running an extract-transform-load job with the mismatch being a mismatch of at least one of the following types: design time information mismatch, and/or operational metadata mismatch; and (ii) responsive to determining the mismatch, handling the mismatch as an exception.Type: GrantFiled: August 6, 2013Date of Patent: September 20, 2016Assignee: International Business Machines CorporationInventors: Raghavendra R. Dhayapule, Ritesh K. Gupta, Ajay Sood
-
Publication number: 20160162507Abstract: In an approach to identifying duplicates in data, one or more computer processors receive a request from a user to identify duplicates in a data set. The one or more computer processors retrieve the data set utilizing data discovery. The one or more computer processors perform data profiling on the data set. The one or more computer processors determine one or more domain types of the data set, based, at least in part, on the performed data profiling. The one or more computer processors perform data standardization on the data set, based, at least in part, on the one or more determined domain types. Responsive to performing data standardization, the one or more computer processors perform probabilistic matching on the data set. The one or more computer processors to identify two or more duplicates in the data set, based, at least in part, on the probabilistic matching.Type: ApplicationFiled: December 5, 2014Publication date: June 9, 2016Inventors: Ritesh K. Gupta, Namit Kabra, Manish Kumar, Srinivas K. Mittapalli
-
Patent number: 9336564Abstract: Methods for resolving a number of in-memory issues associated with parallel query execution of a database operation on a database utilizing a graphics processing unit (GPU) are presented including: tying a table choice to a number of accesses per second made to a table; and synchronizing threads in a same shared GPU multiprocessor to avoid compromising concurrency, and where the parallel query execution of the database operation is performed solely by the GPU. In some embodiments, methods further include storing data from the GPU to a disk to solve volatility; and enabling a user, at any time, to query the amount of memory being used by the table created by the user to monitor memory consumption.Type: GrantFiled: February 1, 2013Date of Patent: May 10, 2016Assignee: International Business Machines CorporationInventors: Akshay Gautam, Ritesh K. Gupta