Abstract: Herein are spatially scalable techniques for anisotropic compression of shared entropy between alternate representations of same data. In an embodiment, a computer compresses an uncompressed independent column into a compressed independent column. Based on the compressed independent column, an uncompressed dependent column is compressed into a compressed dependent column. The compressed independent column and the compressed dependent column are stored in a same file. In an embodiment, a computer stores, in metadata, an encrypted private key for decrypting an encrypted column. The encrypted column and the metadata are stored in a file. A request to read the encrypted column is received. Based on a public key and the file, the encrypted private key is decrypted into a decrypted private key. The public key is contained in the request and/or the file. The request is executed by decrypting, based on the decrypted private key and the file, the encrypted column.

Abstract: Herein are spatially scalable techniques for anisotropic compression of shared entropy between alternate representations of same data. In an embodiment, a computer compresses an uncompressed independent column into a compressed independent column. Based on the compressed independent column, an uncompressed dependent column is compressed into a compressed dependent column. The compressed independent column and the compressed dependent column are stored in a same file. In an embodiment, a computer stores, in metadata, an encrypted private key for decrypting an encrypted column. The encrypted column and the metadata are stored in a file. A request to read the encrypted column is received. Based on a public key and the file, the encrypted private key is decrypted into a decrypted private key. The public key is contained in the request and/or the file. The request is executed by decrypting, based on the decrypted private key and the file, the encrypted column.

Abstract: Herein are spatially scalable techniques for anisotropic compression of shared entropy between alternate representations of same data. In an embodiment, a computer compresses an uncompressed independent column into a compressed independent column. Based on the compressed independent column, an uncompressed dependent column is compressed into a compressed dependent column. The compressed independent column and the compressed dependent column are stored in a same file. In an embodiment, a computer stores, in metadata, an encrypted private key for decrypting an encrypted column. The encrypted column and the metadata are stored in a file. A request to read the encrypted column is received. Based on a public key and the file, the encrypted private key is decrypted into a decrypted private key. The public key is contained in the request and/or the file. The request is executed by decrypting, based on the decrypted private key and the file, the encrypted column.

Abstract: A job scheduling technique that allows jobs to be launched as a result of messages which are not targeted specifically at the job, and for jobs to be interrelated in complex ways.

Abstract: A system, method, computer program and article of manufacture for improved process flow of job processing is accomplished via a combination of complex dependencies, task and chain reuse, and use of one or more events as a task.

Abstract: A system, method, computer program and article of manufacture for improved process flow of job processing is accomplished via a combination of complex dependencies, task and chain reuse, and use of one or more events as a task.

Abstract: A job scheduling technique that allows jobs to be launched as a result of messages which are not targeted specifically at the job, and for jobs to be interrelated in complex ways.

Abstract: Various embodiments of the invention provide solutions to facilitate the management and/or automation of various database tasks, in particular system tasks. Merely by way of example, some embodiments provide methods systems and/or software products that can facilitate automation of such tasks. In accordance with certain embodiments, a maintenance window may be defined. The maintenance window can provide an opportunity for system tasks (and/or other tasks, especially those that consume significant database resources) to execute without significantly impacting the usability of the database. In particular embodiments, a maintenance window may be defined to coincide with a period of relatively low user activity. In some cases, a maintenance window may be implemented in conjunction with a job scheduler and/or a resource manager.

Abstract: An apparatus and method for accessing foreign processes in a heterogeneous database environment includes a local database server having a heterogeneous services module to selectively send requests to the foreign processes based on their respective capabilities. A client application sending a statement to the local database server is checked by the local server process to determine if the statement includes a reference to a foreign database system, or whether the statement is registered as an external routine. The heterogeneous services module selectively outputs a request to an agent process executing in an address space separate from the local server process and in communication with the foreign database. The agent process performs all necessary interaction with the foreign database, including data type translation.

Abstract: An apparatus and method for accessing foreign processes in a heterogeneous database environment includes a local database server having heterogeneous services to selectively send requests to the foreign processes based on their respective capabilities. A client application sending a statement to the local database server is checked by the local server process to determine if the statement includes a reference to a foreign database system. The local server process selectively outputs a request to an agent process in communication with a foreign database via a generic Application Programming Interface (API). The request output to the foreign database is based on accessing a capabilities table specifying the operations that can be executed by the foreign database.

Abstract: A database server is configured to process original requests received from a client and callback requests received from an external routine. The database server saves global information before calling the external routine to distinguish whether a received request is an original or a callback request. Furthermore, both types of requests can be submitted via the same application programming interface and preferably with the same interprocess communication protocol.

Abstract: An apparatus and method for accessing foreign processes in a heterogeneous database environment includes a local database server having heterogeneous services to selectively send foreign operations to the appropriate foreign processes in a controllable manner. A client application sending a statement to the local database server is checked by the local server to determine if the statement includes a reference to a foreign database system. The heterogeneous services selectively outputs a the foreign request to an agent process in communication with the foreign database system via an Application Programming Interface (API), where a foreign database driver corresponding to the foreign database maps the request from the API to the format of the foreign database. The local database server selectively allocates memory space for expected results from the foreign database, and completes execution of the statement upon receiving the expected results from the agent process.

Abstract: An apparatus and method for accessing foreign processes in a heterogeneous database environment includes a local database server having a heterogeneous services module to selectively send requests to the foreign processes based on their respective capabilities. A client application sending a statement to the local database server is checked by the local server process to determine if the statement includes a reference for a registered external routine executable by an agent process in an address space separate from the local server process. The heterogeneous services module selectively initiates a network connection with an external agent process, and the external agent process executes the external routine by accessing a dynamically linked library. If necessary, the local database server and the agent process exchange callback queries and callback results via the heterogeneous services module to complete intermediate queries within the same user instance.