摘要:
A system and method for managing internal controls within a heterogeneous enterprise environment is provided. The invention may include an open and extensible standards-based architecture that may be used to create, monitor, test, or otherwise manage internal controls by capturing, organizing, translating, and exchanging controls data, tests, and test results across organizational boundaries and between an enterprise and its external auditors. By providing an automated software solution for managing internal controls, business, finance, information technology, audit, or other professionals may automate on-demand testing, or perform closed-loop remediation and continuous exception-based monitoring of controls within and across enterprise systems.
摘要:
Techniques for automatic data warehouse generation are disclosed herein. A first data set is received. The first data set includes a plurality of tables and includes a plurality of keys. A dimensional model is mapped onto the first data set. A schema is automatically generated based on the dimensional model.
摘要:
Determining an improvement action is disclosed. The impact of a plurality of candidate actions is analyzed. The probability of making each of the candidate actions is analyzed. A desirable improvement action is determined based at least in part on the impact of and probability of making the candidate action.
摘要:
Selecting a report from among a plurality of candidate reports is disclosed. A set of metrics and attributes associated with the plurality of candidate reports is received. Each of the candidate reports is evaluated with respect to a plurality of populations and with respect to the received set of metrics and attributes. A candidate report to be outputted is automatically selected based at least in part on the evaluation.
摘要:
A method and apparatus for dynamically retrieving ontological context are described herein. In one embodiment, the method includes receiving pattern language code that includes definitions of business classes and field classes, wherein the field classes include ontological contexts. The method also includes generating high-level object-oriented code that includes the business classes and the field classes with ontological contexts.
摘要:
Salient sampling for query size estimation includes identifying two or more columns in a database table that have corresponding columns in one or more other tables. One or more hash functions are applied to domains of each of the identified columns. A first hash function is applied to a domain of the first column and a second hash function to a domain of the second column. A subset of the rows in the database table is selected. The selecting includes selecting rows in the database table where results of the first hash function meet a first numeric threshold and selecting rows in the database table where results of the second hash function meet a second numeric threshold. A sample database table corresponding to the database table is created. The sample database table includes the selected subset of the rows in the database table.
摘要:
An aspect includes a method for maintaining active queries. The method includes executing a query based on data items in at least two relations in a database. The executing includes outputting a query result and control information associated with the query. The query result and the control information are recorded. A notification that at least one of the data items has been updated subsequent to the executing is received. The query result is modified, responsive to the control information, to reflect the data items that were updated subsequent to the executing.