Abstract: User productivity can be facilitated by providing an interface between a high-level intent and low-level settings that should be configured to achieve the intent. The intent can be expressed in declarative language. The intent can be verified to determine if it conforms to a target, a policy, or both. Policy binding can provide a relationship between the target and the policy. An application view can be provided that allows the user to view a server having one or more databases.

Abstract: Automated sampling and aggregation of performance or other dynamically varying data facilitates user productivity by making data available for a wide range of uses. An automated sampling and aggregration system includes one or more types of data collectors, including a dedicated data collector per machine, multiple data collectors per machine, or an instance-less data collector.

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: User productivity can be facilitated by providing an interface between a high-level intent and low-level settings that should be configured to achieve the intent. The intent can be expressed in declarative language. The intent can be verified to determine if it conforms to a target, a policy, or both. Policy binding can provide a relationship between the target and the policy. An application view can be provided that allows the user to view a server having one or more databases.

Abstract: User productivity can be facilitated through automated sampling and aggregation of performance or other dynamically varying data to make such data available for a wide range of uses. A data collector is provided and can be a dedicated data collector per machine, there can be multiple data collectors per machine, or there can be an instance-less data collector.