Patents by Inventor Gangadhar Ronanki

Gangadhar Ronanki 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).

  • System and method for automatic generation of extract, transform, load (ETL) asserts
    Patent number: 11803798
    Abstract: In accordance with an embodiment, described herein are systems and methods for use with an analytic applications environment, for automatic generation of asserts in such environments. A data pipeline or process, such as, for example an extract, transform, load (ETL) process, can operate in accordance with an analytic applications schema adapted to address particular analytics use cases or best practices, to receive data from a customer's (tenant's) enterprise software application or data environment, for loading into a data warehouse instance. Each customer (tenant) can additionally be associated with a customer tenancy and a customer schema. During the process of populating a data warehouse instance, the system can automatically generate dynamic data-driven ETL asserts, including determining a list of columns for tables in the data warehouse; determining a data type for each column; generating an assert for each determined data type; validating the generated assert; and maintaining the generated assert.
    Type: Grant
    Filed: April 17, 2020
    Date of Patent: October 31, 2023
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Krishnan Ramanathan, Gangadhar Ronanki, Aman Madaan
  • SYSTEM AND METHOD FOR AUTOMATIC GENERATION OF EXTRACT, TRANSFORM, LOAD (ETL) ASSERTS
    Publication number: 20200334267
    Abstract: In accordance with an embodiment, described herein are systems and methods for use with an analytic applications environment, for automatic generation of asserts in such environments. A data pipeline or process, such as, for example an extract, transform, load (ETL) process, can operate in accordance with an analytic applications schema adapted to address particular analytics use cases or best practices, to receive data from a customer's (tenant's) enterprise software application or data environment, for loading into a data warehouse instance. Each customer (tenant) can additionally be associated with a customer tenancy and a customer schema. During the process of populating a data warehouse instance, the system can automatically generate dynamic data-driven ETL asserts, including determining a list of columns for tables in the data warehouse; determining a data type for each column; generating an assert for each determined data type; validating the generated assert; and maintaining the generated assert.
    Type: Application
    Filed: April 17, 2020
    Publication date: October 22, 2020
    Inventors: Krishnan Ramanathan, Gangadhar Ronanki, Aman Madaan