US 12,001,454 B2Granted

System and method for capturing workloads in a multidimensional database environment

AssigneeOracle International Corporation

InventorKenneth Lau

Life of this patent

Estimating the term…

Loading patent…

Abstract

In accordance with an embodiment, described herein is a system and method for capturing workloads in a multidimensional database environment. Workloads in the multidimensional database environment can be captured over a period of time as an archive file, which can be replayed using a standalone player against the same multidimensional database environment, or a different multidimensional database environment. The standalone player can selectively replay any portion of the archive file. Results from the replay can be compared to original base results in the recorded archive; and any difference between the results can be displayed. The player can filter out noise and expected differences, and display unexpected differences, including paths for potential issues, for use in troubleshooting, and environment and patching validation.

Claims20

Dependent claims

A system for capturing workloads in a multidimensional database, comprising:

a first multidimensional database server and a second multidimensional database server, wherein the first multidimensional database server and the second multidimensional database server respectively execute on one or more processors and share a same database outline;
a recorder executing on a first computer having one or more first microprocessors configured to generate an archive file recorded against the first multidimensional database server and capturing workloads that include interactions between a client application and the first multidimensional database together with results received from the first multidimensional database server in response to inputs from a user;
and
a standalone player executing on a second computer having one or more second microprocessors separate from the first and second multidimensional database servers, wherein the standalone player is configured to:
receive the archive file recorded against the first multidimensional database server;
selectively replay portions of the recorded archive file against the second multidimensional database server to generate a replay output file, including during replay selectively replacing one or more of the inputs captured by the archive file;
determine one or more differences between the recorded archive file and the replay output file, wherein the standalone player utilizes one or more filters configured to filter out expected differences between the recorded archive file and the replay output file;
and
output the one or more differences between the recorded archive file and the replay output file to a user interface, wherein each of the one or more differences is represented by a combined output showing of a user request executed against the first and second multidimensional database, a first value or property from one or more cells of the first multidimensional database from the recorded archive file returned in response to the user request, a second value or property from one or more cells of the second multidimensional database from the replay output file returned in response to the user request, and respective paths pointing to the first and second cells in the multidimensional databases.

6 more elements

A method for capturing workloads in a multidimensional database, comprising:

generating, with a recorder, an archive file recorded against the first multidimensional database server, wherein the archive file captures workloads over a period of time in the first multidimensional database server, wherein the workloads captured further include user interactions and traffic between a client and the first multidimensional database;
receiving, at a standalone player, the archive file recorded against the first multidimensional database server;
selectively replaying, by the standalone player, portions of the recorded archive file against a second multidimensional database server to generate a replay output file including selectively replacing one or more of the inputs captured by the archive file, wherein the first multidimensional database server and the second multidimensional database server include a same database outline;
determining, by the standalone player, one or more differences between the recorded archive file and the replay output file, wherein the standalone player utilizes one or more filters configured to filter out expected differences between the recorded archive file and the replay output file;
and
displaying, by the standalone player, the one or more differences between the recorded archive file and the replay output file in a user interface, wherein each of the one or more differences is represented by a combined output showing of a user request executed against the first and second multidimensional database, a first value or property from one or more cells of the first multidimensional database from the recorded archive file returned in response to the user request, a second value or property from one or more cells of the second multidimensional database from the replay output file returned in response to the user request, and respective paths pointing to the first and second cells in the multidimensional databases,
wherein the standalone player is separate from the first and second multidimensional database servers.

4 more elements

A non-transitory computer readable storage medium, including instructions for a standalone player stored thereon which when read and executed by one or more computers cause the one or more computers to perform the steps comprising:

generating, with a recorder, an archive file recorded against the first multidimensional database server, wherein the archive file captures workloads over a period of time in the first multidimensional database server, wherein the workloads captured further include user interactions and traffic between a client and the first multidimensional database;
receiving, at a standalone player, the archive file recorded against the first multidimensional database server;
selectively replaying, by the standalone player, portions of the recorded archive file against a second multidimensional database server to generate a replay output file including selectively replacing one or more of the inputs captured by the archive file, wherein the first multidimensional database server and the second multidimensional database server include a same database outline;
determining, by the standalone player, one or more differences between the recorded archive file and the replay output file, wherein the standalone player utilizes one or more filters configured to filter out expected differences between the recorded archive file and the replay output file;
and
displaying, by the standalone player, the one or more differences between the recorded archive file and the replay output file in a user interface, wherein each of the one or more differences is represented by a combined output showing of a user request executed against the first and second multidimensional database, a first value or property from one or more cells of the first multidimensional database from the recorded archive file returned in response to the user request, a second value or property from one or more cells of the second multidimensional database from the replay output file returned in response to the user request, and respective paths pointing to the first and second cells in the multidimensional databases,
wherein the standalone player is separate from the first and second multidimensional database servers.

4 more elements

Dependencies are inferred from the claim text.

Facts

Application: 15/332,794Filed 24 Oct 2016 · us provisional application
Priority: 23 Oct 2015
Published: US 2017/0116254 A127 Apr 2017
Granted: 4 Jun 2024
Term ends: Not estimatedThe source records don’t support an estimate.

Classification5 codes

G06F 16/283
Databases characterised by their database models, e.g. relational or object models: multi-dimensional databases or data warehouses, e.g. MOLAP or…
G06F 11/30
Error detection; Error correction; Monitoring: monitoring
G06F 11/3414
For performance assessment: workload generation, e.g. scripts, playback
G06F 2201/80
Indexing scheme relating to error detection, to error correction, and to monitoring: database-specific techniques

Family

Application62/245,896Us provisional application · filed 23 Oct 2015
US 2017/0116254 A1Pre-grant publication · published 27 Apr 2017
US 12,001,454 B2This patent

From the US filing history. Foreign family members aren’t listed.

Timeline

Citations

Open elsewhere

Building an agent or pulling many patents? Use the API or MCP server instead of scraping pages. Get an API key