Method and apparatus for monitoring an in-memory computer system
First Claim
Patent Images
1. A method for monitoring system performance of an in-memory computer system comprising:
- executing, by the in-memory computer system, a script written in a SQL query language to perform the steps of;
conducting a plurality of on-line transaction processes (OLTPs) to receive and store data in a main memory component of the in-memory computer system;
conducting a plurality of on-line analytical processes (OLAPs) on the data stored in the main memory component to produce a plurality of data analysis results;
storing the data analysis results in the main memory component;
storing runtime information in a plurality of system tables in the main memory component relating to the step of conducting the plurality of OLTPs and the step of conducting the plurality of OLAPs;
andperforming one or more predetermined data analyses on the runtime information stored in the plurality of system tables in the main memory component to produce a plurality of system performance metrics.
2 Assignments
0 Petitions
Accused Products
Abstract
An in-memory computing system for conducting on-line transaction processing and on-line analytical processing includes system tables in main memory to store runtime information. A statistics server can access the runtime information to collect monitoring data and generate historical data and other system performance metrics.
25 Citations
20 Claims
-
1. A method for monitoring system performance of an in-memory computer system comprising:
executing, by the in-memory computer system, a script written in a SQL query language to perform the steps of; conducting a plurality of on-line transaction processes (OLTPs) to receive and store data in a main memory component of the in-memory computer system; conducting a plurality of on-line analytical processes (OLAPs) on the data stored in the main memory component to produce a plurality of data analysis results; storing the data analysis results in the main memory component; storing runtime information in a plurality of system tables in the main memory component relating to the step of conducting the plurality of OLTPs and the step of conducting the plurality of OLAPs; and performing one or more predetermined data analyses on the runtime information stored in the plurality of system tables in the main memory component to produce a plurality of system performance metrics. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8, 9)
-
10. An in-memory computing system having performance monitoring comprising:
-
a plurality of server subsystems; a main memory subsystem in data communication with the plurality of server subsystems and having stored thereon one or more system tables; a disk storage subsystem; and computer executable instructions stored in a script written in a SQL query language that is stored among the main memory subsystem and the disk storage subsystem, wherein executing the script causes the server subsystems to; execute a plurality of on-line transaction processes (OLTPs) to receive and store data in a memory component of the in-memory computer system; execute a plurality of on-line analytical processes (OLAPs) on the data stored in the memory component to produce a plurality of data analysis results; store the data analysis results in the main memory subsystem; store runtime information in a plurality of system tables in the main memory subsystem relating to the step of conducting the plurality of OLTPs and the step of conducting the plurality of OLAPs; and perform one or more predetermined data analyses on the runtime information stored in the plurality of system tables in the main memory subsystem to produce a plurality of system performance metrics. - View Dependent Claims (11, 12, 13, 14)
-
-
15. A non-transient computer readable medium stored within an in-memory computer system, the non-transient computer readable medium having stored thereon a script written in a SQL query language that contains computer executable instructions configured to cause one or more data processing units to perform the steps of:
-
conducting a plurality of on-line transaction processes (OLTPs) to receive and store data in a main memory of the in-memory computer system; conducting a plurality of on-line analytical processes (OLAPs) on the data stored in the main memory to produce a plurality of data analysis results; storing the data analysis results in the main memory; storing runtime information in a plurality of system tables in the main memory relating to the step of conducting the plurality of OLTPs and the step of conducting the plurality of OLAPs; and performing one or more predetermined data analyses on the runtime information stored in the plurality of system tables in the main memory to produce a plurality of system performance metrics. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification