Sap Se

International Business Machines Corporation

Edgardo Gildo Koenig

Arndt Effern

Guenter Briam

Steffen Siegmund

Ralf Stauffer

Thomas Rech

Joern Klauke

Andreas Christian

Hans-Juergen Moldowan

According to some embodiments, each of a plurality of computer systems to be monitored receives a monitoring solution agent code portion and a monitoring solution agent content portion, the monitoring solution agent code portion and monitoring solution agent content portion together forming a monitoring solution agent. The monitoring solution agent code portion and monitoring solution agent content portion may comprise a remote Monitoring Solution Agent that executes at the computer system to be monitored. According to some embodiments, monitoring solution agent content portion includes a data source layer, a data provider layer, a request layer, and a user interface layer.

System and method for updating monitoring software using content model with validity attributes

The disclosure generally describes methods, software, and systems, including a method for defining and using dependencies and equivalences for data elements in the data model in order to improve query efficiency. At design time of a data model, dependencies and equivalences for data elements in the data model are received over a computer network. The dependencies and equivalences are stored in persistent storage with the data model. A request is received over the computer network, the request to be executed to obtain results from a database associated with the data model. An optimized query is generated using the received request and the dependencies and equivalences. The optimized query is optimized relative to the received request.

Deep filter propagation using explicit dependency and equivalency declarations in a data model

The disclosure generally describes methods, software, and systems, including a method for optimizing queries referencing large object (LOB) information. A structured query language (SQL) query containing an LOB field is identified. LOB replacement information for the LOB field is obtained from a data model. The SQL query is optimized including substituting, using the obtained LOB replacement information, the LOB field with replacement language to create an updated SQL query, and extending the updated SQL query with a join of LOB field language to create an extended SQL query.

Explicit declaration of associations to optimize grouping of elements by large data objects

A local monitoring system of a computer system to be monitored may receive a monitoring solution agent code portion and a first monitoring solution agent content portion. Version D may be assigned to the first content portion, and a status of version D may be set to active such that new end user sessions are initialized with a local agent comprising the code portion and version D. A second content portion may be uploaded and assigned to be version A. Responsive to an end user request, the status of version D may be set to ready and the status of version A may be set to active such that new sessions are initialized with an agent comprising the code portion and version A. A third content portion may then be uploaded and assigned to be version B. Responsive to an end user request, the status of version A may be to ready and the status of version B may be set to active such that new sessions are initialized with an agent comprising the code portion and version B. When sessions using version A no longer exist, version A may be deleted.

System and method for updating content without downtime

Method, program products and apparatus are disclosed for optimizing access to a data table. A value-existence structure is used to determine whether the data table contains rows for a given database query. The value-existence structure may be useful, for example, for managing transparent access to an online database and a nearline database.

Database-transparent near online archiving and retrieval of data

A method for compressing index pages in a database system is provided. The database system includes a table, and the table includes table columns. The method includes: providing an index associated with the table, wherein the index is stored on at least one index page of the database system, and wherein the index comprises index columns related to a part of the table columns; providing a first sequence of the index columns; providing a second sequence of the index columns; arranging the index columns stored on the at least one index page according to the second sequence; performing a prefix compression on entries of the at least one index page; and accessing the index using the first sequence of the index columns.

Growing community of inventors

Leimen, Germany

Edgardo Gildo Koenig