Abstract: Methods for using SQL statements to access an application-server-managed database are disclosed herein. In some embodiments, a user sends, either directly or indirectly (i.e., remotely) a SQL statement from an ODBC application or server, respectively, to an application server that preprocesses SQL statements for accessing data from a centralized database. The application server may have a SQL endpoint, and access to the SQL endpoint may be determined by a user's logon credentials, a user's presentation of a SAML token, or a user's presentation of a valid certificate. The application server may then parse the SQL statement and determine the user's authorization to access certain objects in the centralized database based on a SQL handler design-time configuration. A result from the statement may be sent back to the user either directly or indirectly and exposed.

Abstract: Methods for using SQL statements to access an application-server-managed database are disclosed herein. In some embodiments, a user sends, either directly or indirectly (i.e., remotely) a SQL statement from an ODBC application or server, respectively, to an application server that preprocesses SQL statements for accessing data from a centralized database. The application server may have a SQL endpoint, and access to the SQL endpoint may be determined by a user's logon credentials, a user's presentation of a SAML token, or a user's presentation of a valid certificate. The application server may then parse the SQL statement and determine the user's authorization to access certain objects in the centralized database based on a SQL handler design-time configuration. A result from the statement may be sent back to the user either directly or indirectly and exposed.

Abstract: Disclosed herein are systems and methods for embedding database procedures in data-driven software applications written in a language different from the database-procedure language. For example, in some embodiments, the hosting application may be written in ABAP whereas the database procedure may be written in SQLScript. In various embodiments, the database procedures are encapsulated in specially marked methods of the host application, which, when called at runtime, cause the database procedures to be created in a database catalog and executed on a database server.

Abstract: Disclosed herein are systems and methods facilitating extensions to software applications that access a database, and in particular to applications with embedded database procedures. In various embodiments, an extension anchor embedded in the application as well as one or more extensions implemented as database procedures are encapsulated in specially marked database-procedure methods.

Abstract: Disclosed herein are systems and methods for the hot deployment of database procedures embedded in a host software application. In various example embodiments, the database procedures are encapsulated in specially marked methods of the host application, which, when called at runtime, cause the database procedures, and associated procedure stubs through which the database procedures are called, to be created in a database catalog and executed on the database server. When an embedded database procedure is modified in an application by one user during execution of that application by a second user, compilation of the modified database procedure may result in deletion of the original database procedure and/or associated procedure stub from the database, avoiding inconsistencies between database procedure versions during application execution by the second user.

Abstract: Disclosed herein are systems and methods for the hot deployment of database procedures embedded in a host software application. In various example embodiments, the database procedures are encapsulated in specially marked methods of the host application, which, when called at runtime, cause the database procedures, and associated procedure stubs through which the database procedures are called, to be created in a database catalog and executed on the database server. When an embedded database procedure is modified in an application by one user during execution of that application by a second user, compilation of the modified database procedure may result in deletion of the original database procedure and/or associated procedure stub from the database, avoiding inconsistencies between database procedure versions during application execution by the second user.

Abstract: Disclosed herein are systems and methods for embedding database procedures in data-driven software applications written in a language different from the database-procedure language. For example, in some embodiments, the hosting application may be written in ABAP whereas the database procedure may be written in SQLScript. In various embodiments, the database procedures are encapsulated in specially marked methods of the host application, which, when called at runtime, cause the database procedures to be created in a database catalog and executed on a database server.

Abstract: Disclosed herein are systems and methods facilitating extensions to software applications that access a database, and in particular to applications with embedded database procedures. In various embodiments, an extension anchor embedded in the application as well as one or more extensions implemented as database procedures are encapsulated in specially marked database-procedure methods.

Abstract: An interface for providing monitoring information from any monitored component to a central monitoring system in which an XML document is created according to a DTD conforming to a tree-structured monitoring architecture and then is made available to the central monitoring system either by posting it as an HTTP message or filing it in a designated directory, where it can be periodically polled by the central monitoring system. An initial long-form XML document can be used to completely specify the monitoring tree for the monitored component, and then subsequent short-form XML documents can be posted with current data corresponding to the monitoring tree elements themselves. An XML processor at the central monitoring system converts the XML document contents and applies them to a standard interface which has previously been available directly to fully conforming components.

Abstract: A system and method for monitoring availability of applications. According to an embodiment of the invention, a method includes providing a set of monitoring instructions to an agent, with the set of monitoring instructions including a time stamp and the set of monitoring instructions regarding monitoring of the availability of applications. The method includes receiving a status inquiry from the agent, the inquiry including the time stamp, comparing the time stamp received from the agent to a time stamp for up-to-date monitoring instructions, and sending the up-to-date monitoring instructions to the agent if the time stamp of the up-to-date monitoring instructions is later than the time stamp received from the agent.

Abstract: An interface for providing monitoring information from any monitored component to a central monitoring system in which an XML document is created according to a DTD conforming to a tree-structured monitoring architecture and then is made available to the central monitoring system either by posting it as an HTTP message or filing it in a designated directory, where it can be periodically polled by the central monitoring system. An initial long-form XML document can be used to completely specify the monitoring tree for the monitored component, and then subsequent short-form XML documents can be posted with current data corresponding to the monitoring tree elements themselves. An XML processor at the central monitoring system converts the XML document contents and applies them to a standard interface which has previously been available directly to fully conforming components.

Abstract: An interface for providing monitoring information from any monitored component to a central monitoring system in which an XML document is created according to a DTD conforming to a tree-structured monitoring architecture and then is made available to the central monitoring system either by posting it as an HTTP message or filing it in a designated directory, where it can be periodically polled by the central monitoring system. An initial long-form XML document can be used to completely specify the monitoring tree for the monitored component, and then subsequent short-form XML documents can be posted with current data corresponding to the monitoring tree elements themselves. An XML processor at the central monitoring system converts the XML document contents and applies them to a standard interface which has previously been available directly to fully conforming components.

Abstract: A system and method for monitoring availability of applications. According to an embodiment of the invention, a method includes providing a set of monitoring instructions to an agent, with the set of monitoring instructions including a time stamp and the set of monitoring instructions regarding monitoring of the availability of applications. The method includes receiving a status inquiry from the agent, the inquiry including the time stamp, comparing the time stamp received from the agent to a time stamp for up-to-date monitoring instructions, and sending the up-to-date monitoring instructions to the agent if the time stamp of the up-to-date monitoring instructions is later than the time stamp received from the agent.

Abstract: An interface for providing monitoring information from any monitored component to a central monitoring system in which an XML document is created according to a DTD conforming to a tree-structured monitoring architecture and then is made available to the central monitoring system either by posting it as an HTTP message or filing it in a designated directory, where it can be periodically polled by the central monitoring system. An initial long-form XML document can be used to completely specify the monitoring tree for the monitored component, and then subsequent short-form XML documents can be posted with current data corresponding to the monitoring tree elements themselves. An XML processor at the central monitoring system converts the XML document contents and applies them to a standard interface which has previously been available directly to fully conforming components.