Patents by Inventor Kumar Ramaiyer

Kumar Ramaiyer 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: 11922221
    Abstract: In accordance with an embodiment, described herein is a system and method for dependency analysis for a calculation script in a multidimensional database computing environment. A multidimensional database cube aggregation can be represented as a lattice of blocks or cube, arranged according to a database outline (e.g., intra-dimensional or member hierarchy). When the multidimensional database system performs computations in parallel for a given calculation script, portions of the cube that can be computed concurrently are identified.
    Type: Grant
    Filed: September 23, 2021
    Date of Patent: March 5, 2024
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Vinod Padinjat Menon, Kumar Ramaiyer
  • Patent number: 11797559
    Abstract: In accordance with an embodiment, described are systems and methods for real time data aggregation in a virtual cube in a multidimensional database. A method can provide, at a computer that includes one or more microprocessors, a multidimensional database server executing on the computer, wherein the multidimensional database server supports at least one multidimensional cube, a data source associated with the multidimensional cube, and at least one source of real-time data accessible by the data source. The method can query, by the multidimensional cube, the data source, the query comprising an identification of the at least one source of real-time data. The method can provide, by the data source, on-demand access to the multidimensional cube to the at least one source of real-time data. The method can use targeted data from the at least one source of real-time data within the multidimensional cube without being stored therein.
    Type: Grant
    Filed: October 5, 2021
    Date of Patent: October 24, 2023
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Kumar Ramaiyer, Victor Belyaev, Alexey Roytman, Natasha Reichman
  • Patent number: 11797496
    Abstract: A system and method is described for use with a multidimensional database computing environment to provide support for parallel calculation of multidimensional slices. Users are able to specify a set of slices and a number of parallel threads to employ. The multidimensional database environment generates tasks that include calculations and/or aggregations, which are able to be executed by the system in parallel. Also described herein are mechanisms of utilizing variables within the calculations performed by respective threads, and combining thread variables after execution.
    Type: Grant
    Filed: March 12, 2021
    Date of Patent: October 24, 2023
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Long Tran, Vinod Padinjat Menon, Kumar Ramaiyer
  • Publication number: 20230334030
    Abstract: In accordance with an embodiment, described herein are systems and methods for supporting slowly changing dimensions and metadata versioning in a multidimensional database, comprising. A system can comprise a computer that includes one or more microprocessors, and a multidimensional database server executing on the computer, wherein the multidimensional database server supports at least one hierarchical structure of data dimensions. A data dimension can slowly change over time. When such changes occur, metadata associated with the data dimension can be updated. Advantageously, a current snapshot of the data structure can allow searching of previous changes to the slowly changing dimension based upon the metadata.
    Type: Application
    Filed: June 23, 2023
    Publication date: October 19, 2023
    Inventor: Kumar Ramaiyer
  • Patent number: 11789978
    Abstract: In accordance with an embodiment, systems and methods can provide for load, aggregate, and batch calculation in in a multidimensional database environment. Metadata can be used to identify in which higher dimensions each leaf-level load is used. At such time, the data from the leaf level is aggregated to each of the higher dimensions where it is to be used. Then, the aggregate values are stored in memory until a completed sum (or other calculation) is completed at the higher levels. At such time, the aggregate values can be discarded from memory. The ability of the system to perform a load, aggregate, and batch calculation in one scan is particularly useful in processing very large sets of data, for example in big data environments, where it may not be desirable to load the data for all of the leaf nodes into current memory.
    Type: Grant
    Filed: June 21, 2021
    Date of Patent: October 17, 2023
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventor: Kumar Ramaiyer
  • Patent number: 11734293
    Abstract: In accordance with an embodiment, described herein are systems and methods that enable client-side calculation with data provided at a multidimensional or other database server. Data provided at the server in accordance with a server-side model, can be transformed/prepared into a grid, for use with a client-side application, for example a client spreadsheet application. During preparation of the grid, one or more portions of the grid that are identified as client-side dynamic parameters, can be represented as dynamic formulas that are modifiable within the client-side application; while parameters of the server-side model that are outside of the grid can be represented as constant values. The grid provided to the client can be used to perform client-side calculations that allow for rapid calculations in response to changes in the client-side model, without introducing a round-trip performance lag between the client-side and server-side.
    Type: Grant
    Filed: January 20, 2021
    Date of Patent: August 22, 2023
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Kumar Ramaiyer, John Xiao
  • Patent number: 11704294
    Abstract: In accordance with an embodiment, described herein are systems and methods for supporting slowly changing dimensions and metadata versioning in a multidimensional database, comprising. A system can comprise a computer that includes one or more microprocessors, and a multidimensional database server executing on the computer, wherein the multidimensional database server supports at least one hierarchical structure of data dimensions. A data dimension can slowly change over time. When such changes occur, metadata associated with the data dimension can be updated. Advantageously, a current snapshot of the data structure can allow searching of previous changes to the slowly changing dimension based upon the metadata.
    Type: Grant
    Filed: March 12, 2021
    Date of Patent: July 18, 2023
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventor: Kumar Ramaiyer
  • Publication number: 20230185827
    Abstract: In accordance with an embodiment, described herein are systems and methods for enabling multiple parents with weights in a multidimensional database. An exemplary system can comprise a computer that includes one or more microprocessors, and a multidimensional database server executing on the computer, wherein the multidimensional database server supports at least one hierarchical structure of data dimensions. A data dimension can comprises a plurality of members, a first set of members being a first level, and a second set of members being at a second level. A member of the second set of members at the second level can comprises two or more member-member relationships with two or more members of the first set of members at the first level. Each of the two or more member-member relationships are associated with a weight.
    Type: Application
    Filed: February 9, 2023
    Publication date: June 15, 2023
    Inventor: Kumar Ramaiyer
  • Publication number: 20230089618
    Abstract: In accordance with an embodiment, described herein is a system and method for use of a dynamic flow process (referred to herein in some examples as Query Processing Dynamic Flow (QPDF)) in a multidimensional database computing environment. The dynamic flow process enables hybrid use of, for example, aggregate storage option, block storage option, or other types of storage containers, and provides a common flow to process a received input query in bottom-up mode. The approach can be used to reduce the size of the cube, which provides for efficient calculation of dynamic members.
    Type: Application
    Filed: November 22, 2022
    Publication date: March 23, 2023
    Inventors: Natasha Reichman, Sergei Riaboi, Alexey Roytman, Victor Belyaev, Kumar Ramaiyer
  • Patent number: 11593402
    Abstract: In accordance with an embodiment, described herein are systems and methods for enabling multiple parents with weights in a multidimensional database. An exemplary system can comprise a computer that includes one or more microprocessors, and a multidimensional database server executing on the computer, wherein the multidimensional database server supports at least one hierarchical structure of data dimensions. A data dimension can comprises a plurality of members, a first set of members being a first level, and a second set of members being at a second level. A member of the second set of members at the second level can comprises two or more member-member relationships with two or more members of the first set of members at the first level. Each of the two or more member-member relationships are associated with a weight.
    Type: Grant
    Filed: June 29, 2018
    Date of Patent: February 28, 2023
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventor: Kumar Ramaiyer
  • Patent number: 11531662
    Abstract: In accordance with an embodiment, described herein is a system and method for use of a dynamic flow process (referred to herein in some examples as Query Processing Dynamic Flow (QPDF)) in a multidimensional database computing environment. The dynamic flow process enables hybrid use of, for example, aggregate storage option, block storage option, or other types of storage containers, and provides a common flow to process a received input query in bottom-up mode. The approach can be used to reduce the size of the cube, which provides for efficient calculation of dynamic members.
    Type: Grant
    Filed: January 6, 2020
    Date of Patent: December 20, 2022
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Natasha Reichman, Sergei Riaboi, Alexey Roytman, Victor Belyaev, Kumar Ramaiyer
  • Publication number: 20220350819
    Abstract: In accordance with an embodiment, described herein is a system and method for improving performance within a multidimensional database computing environment. A multidimensional database, utilizing a block storage option, performs numerous input/output (I/O) operations when executing calculations. To separate I/O operations from calculations, a background task queue is created to identify data blocks requiring I/O. The background task queue is utilized by background writer threads to execute the I/O operations in parallel with calculations.
    Type: Application
    Filed: July 6, 2022
    Publication date: November 3, 2022
    Inventors: Cloud Walker, Vinod Padinjat Menon, Kumar Ramaiyer
  • Patent number: 11422881
    Abstract: In accordance with an embodiment, described herein are systems and methods for automatic root cause analysis and generation of key metrics in a multidimensional database. A system can comprise a computer and a multidimensional database server executing on the computer, wherein the multidimensional database server supports at least one hierarchical structure of data dimensions. One or more one or more user logs are created, the one or must user logs representing a plurality of operations performed by a plurality of users of the multidimensional database server and accessing the at least one hierarchical structure of data dimensions. Based upon historical data of the at least one hierarchical structure of data dimensions, a change in a query result of a user is detected. Based upon the detection of a change, a set of data dimensions can be provided to the user that contains the data dimensions most contributing to the change.
    Type: Grant
    Filed: March 29, 2019
    Date of Patent: August 23, 2022
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventor: Kumar Ramaiyer
  • Patent number: 11403321
    Abstract: In accordance with an embodiment, described herein is a system and method for improving performance within a multidimensional database computing environment. A multidimensional database, utilizing a block storage option, performs numerous input/output (I/O) operations when executing calculations. To separate I/O operations from calculations, a background task queue is created to identify data blocks requiring I/O. The background task queue is utilized by background writer threads to execute the I/O operations in parallel with calculations.
    Type: Grant
    Filed: June 7, 2019
    Date of Patent: August 2, 2022
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Cloud Walker, Vinod Padinjat Menon, Kumar Ramaiyer
  • Publication number: 20220107963
    Abstract: In accordance with an embodiment, described herein is a system and method for use with a multidimensional database computing environment. Particularly, a system and method are described for performing in-place data writes to a data storage medium associated with the multidimensional database computing environment. For example, when multiple data updates from calculation scripts are associated with a same set of blocks, the in-place data enable the system to reduce fragmentation of the data storage medium, and also to reduce contention due to index updates.
    Type: Application
    Filed: December 16, 2021
    Publication date: April 7, 2022
    Inventors: KUMAR RAMAIYER, YOUNG JOON KIM, HARITHA GONGALORE, VILAS KETKAR, SHUBHAGAM GUPTA
  • Publication number: 20220027381
    Abstract: In accordance with an embodiment, described are systems and methods for real time data aggregation in a virtual cube in a multidimensional database. A method can provide, at a computer that includes one or more microprocessors, a multidimensional database server executing on the computer, wherein the multidimensional database server supports at least one multidimensional cube, a data source associated with the multidimensional cube, and at least one source of real-time data accessible by the data source. The method can query, by the multidimensional cube, the data source, the query comprising an identification of the at least one source of real-time data. The method can provide, by the data source, on-demand access to the multidimensional cube to the at least one source of real-time data. The method can use targeted data from the at least one source of real-time data within the multidimensional cube without being stored therein.
    Type: Application
    Filed: October 5, 2021
    Publication date: January 27, 2022
    Inventors: KUMAR RAMAIYER, VICTOR BELYAEV, ALEXEY ROYTMAN, NATASHA REICHMAN
  • Patent number: 11226987
    Abstract: In accordance with an embodiment, described herein is a system and method for use with a multidimensional database computing environment. Particularly, a system and method are described for performing in-place data writes to a data storage medium associated with the multidimensional database computing environment. For example, when multiple data updates from calculation scripts are associated with a same set of blocks, the in-place data enable the system to reduce fragmentation of the data storage medium, and also to reduce contention due to index updates.
    Type: Grant
    Filed: October 24, 2016
    Date of Patent: January 18, 2022
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Kumar Ramaiyer, Young Joon Kim, Haritha Gongalore, Vilas Ketkar, Shubhagam Gupta
  • Publication number: 20220012100
    Abstract: In accordance with an embodiment, described herein is a system and method for dependency analysis for a calculation script in a multidimensional database computing environment. A multidimensional database cube aggregation can be represented as a lattice of blocks or cube, arranged according to a database outline (e.g., intra-dimensional or member hierarchy). When the multidimensional database system performs computations in parallel for a given calculation script, portions of the cube that can be computed concurrently are identified.
    Type: Application
    Filed: September 23, 2021
    Publication date: January 13, 2022
    Inventors: Vinod Padinjat Menon, Kumar Ramaiyer
  • Patent number: 11188554
    Abstract: In accordance with an embodiment, described herein are systems and methods for real time data aggregation in a virtual cube in a multidimensional database, in accordance with an embodiment. A method can provide, at a computer that includes one or more microprocessors, a multidimensional database server executing on the computer, wherein the multidimensional database server supports at least one multidimensional cube, a data source associated with the multidimensional cube, and at least one source of real-time data accessible by the data source. The method can query, by the multidimensional cube, the data source, the query comprising an identification of the at least one source of real-time data. The method can provide, by the data source, on-demand access to the multidimensional cube to the at least one source of real-time data. The method can use targeted data from the at least one source of real-time data within the multidimensional cube without being stored therein.
    Type: Grant
    Filed: April 3, 2019
    Date of Patent: November 30, 2021
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Kumar Ramaiyer, Victor Belyaev, Alexey Roytman, Natasha Reichman
  • Patent number: 11144361
    Abstract: In accordance with an embodiment, described herein is a system and method for dependency analysis for a calculation script in a multidimensional database computing environment. A multidimensional database cube aggregation can be represented as a lattice of blocks or cube, arranged according to a database outline (e.g., intra-dimensional or member hierarchy). When the multidimensional database system performs computations in parallel for a given calculation script, portions of the cube that can be computed concurrently are identified.
    Type: Grant
    Filed: October 21, 2019
    Date of Patent: October 12, 2021
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: Vinod Padinjat Menon, Kumar Ramaiyer