Abstract: A script driven infrastructure is provided in order to selectively move structure and data from a source database to a target database. The structure and data is moved using a data transfer mechanism, where the data is contained in disk files stored on the source database and it has corresponding script files describing the structure of the data. The transfer of the data is driven by the script files which allows for selective transfer of structure and data. In one aspect of the invention, the disk files are stored in SQL format and the script files are saved in SQL format and XML format, where the script files saved in SQL format create objects and relational constraints in the target database, and the script files stored in XML format drive the transfer process of the data stored in the disk files.

Abstract: A method of generating commands for a database server includes accessing a script having parser-specific commands, a first set of database-specific commands and optional shell commands. A componentized batch parser splits out the different command types and converts the parser-specific commands into a second set of database-specific commands. The first set and second set of database-specific commands may be sent to a target database for execution. The optional shell commands may be executed by a user tool at a local console. The batch parser offers features including separation of parsing functions using batch separators, performing automatic substitution of tokens in the script with defined values or substitution of tokens by requesting token values via a client tool, stripping off comments and blanks spaces from processed commands, referencing and editing files outside the script, and the ability to connect to different servers.

Abstract: A method of granting permission to use computer software resources when the user may be offline is accomplished through the use of proxy accounts. Each proxy account encapsulates a single set of user credentials. A set of user credentials contains at least a user name and a secret identifier, such as a password. These credentials are used by a scheduler function as an agent for the user to utilize computer resources to run jobs or tasks on behalf of the user. An embodiment of the invention allows for many different proxy account objects each having one set of credentials. The credentials are used at runtime to impersonate the user and allow a job to run. The job may involve multiple software subsystems. The architecture allows multiple proxy accounts to be created which allows system administrators flexibility in assigning different permissions to different users across multiple software environments.

Abstract: A monitoring tool requests traceable information from a server. Such traceable information preferably includes traceable events and associated columns. The monitoring tool preferably generates a display of the traceable information, from which a user may select information to be traced. The monitoring tool requests a trace of the selected information. The trace is preferably displayed to the user, and the user may use the trace to identify and correct problems occurring at the server.

Abstract: A monitoring tool requests traceable information from a server. Such traceable information preferably includes traceable events and associated columns. The monitoring tool preferably generates a display of the traceable information, from which a user may select information to be traced. The monitoring tool requests a trace of the selected information. The trace is preferably displayed to the user, and the user may use the trace to identify and correct problems occurring at the server.

Abstract: A monitoring tool requests traceable information from a server. Such traceable information preferably includes traceable events and associated columns. The monitoring tool preferably generates a display of the traceable information, from which a user may select information to be traced. The monitoring tool requests a trace of the selected information. The trace is preferably displayed to the user, and the user may use the trace to identify and correct problems occurring at the server.

Abstract: A script driven infrastructure is provided in order to selectively move structure and data from a source database to a target database. The structure and data is moved using a data transfer mechanism, where the data is contained in disk files stored on the source database and it has corresponding script files describing the structure of the data. The transfer of the data is driven by the script files which allows for selective transfer of structure and data. In one aspect of the invention, the disk files are stored in SQL format and the script files are saved in SQL format and XML format, where the script files saved in SQL format create objects and relational constraints in the target database, and the script files stored in XML format drive the transfer process of the data stored in the disk files.

Abstract: An automated database tuning tool may include a user interface component and a tuning engine. The user interface may be a graphical component that interfaces with a user to collect configuration parameters for a tuning session for a specified database. The configuration parameters may be stored in a tuning database. A tuning engine that performs the actual tuning process may generate physical design recommendations and reports. The recommendations and reports may be stored in the tuning database, enabling the tuning tool to be run off-line or in background. Communication between components of the tuning tool may occur via stored procedures.

Abstract: A method of granting permission to use computer software resources when the user may be offline is accomplished through the use of proxy accounts. Each proxy account encapsulates a single set of user credentials. A set of user credentials contains at least a user name and a secret identifier, such as a password. These credentials are used by a scheduler function as an agent for the user to utilize computer resources to run jobs or tasks on behalf of the user. An embodiment of the invention allows for many different proxy account objects each having one set of credentials. The credentials are used at runtime to impersonate the user and allow a job to run. The job may involve multiple software subsystems. The architecture allows multiple proxy accounts to be created which allows system administrators flexibility in assigning different permissions to different users across multiple software environments.

Abstract: A method of generating commands for a database server includes accessing a script having parser-specific commands, a first set of database-specific commands and optional shell commands. A componentized batch parser splits out the different command types and converts the parser-specific commands into a second set of database-specific commands. The first set and second set of database-specific commands may be sent to a target database for execution. The optional shell commands may be executed by a user tool at a local console. The batch parser offers features including separation of parsing functions using batch separators, performing automatic substitution of tokens in the script with defined values or substitution of tokens by requesting token values via a client tool, stripping off comments and blanks spaces from processed commands, referencing and editing files outside the script, and the ability to connect to different servers.

Abstract: A monitoring tool requests traceable information from a server. Such traceable information preferably includes traceable events and associated columns. The monitoring tool preferably generates a display of the traceable information, from which a user may select information to be traced. The monitoring tool requests a trace of the selected information. The trace is preferably displayed to the user, and the user may use the trace to identify and correct problems occurring at the server.

Abstract: A first query may be generated at a client computing device. The first query is written in a uniform format that is not unique to a particular object. The first query is submitted to a query translation system, which translates the first query to a request for information that is formatted for processing on a first object associated with a first class of objects in a hierarchy of objects. The request is submitted to the first object for execution at the first object. Results of the request may be returned back to the client.