Abstract: A system and method for logging changes to a database table are disclosed. The system comprises an administration tool, table metadata, a history table, and a service engine. The administration tool provides an interface through which a database administrator (DBA), database programmer, or other user can manage the table metadata and the history table, including the selection of columns within the table for which the system will track changes. In the preferred embodiment, the service engine is a middleware application that tracks changes for the selected columns. The service engine processes all user-requested database operations and adds operations to manage the history table before relaying the request operations to a DBMS. Alternatively or additionally, the service engine may be a wrapper to existing services that the database application provides.

Abstract: A system and method for logging changes to a database table are disclosed. The system comprises an administration tool, table metadata, a history table, and a service engine. The administration tool provides an interface through which a database administrator (DBA), database programmer, or other user can manage the table metadata and the history table, including the selection of columns within the table for which the system will track changes. In the preferred embodiment, the service engine is a middleware application that tracks changes for the selected columns. The service engine processes all user-requested database operations and adds operations to manage the history table before relaying the request operations to a DBMS. Alternatively or additionally, the service engine may be a wrapper to existing services that the database application provides.

Abstract: A system and method for logging changes to a database table comprises an administration tool, table metadata, a history table, and a service engine. The administration tool provides an interface through which a database administrator (DBA), database programmer, or other user can manage the table metadata and the history table, including the selection of columns within the table for which the system will track changes.

Abstract: Generally, systems, methods and media for processing a spreadsheet for storage in a database are disclosed. Embodiments may include a method for processing records of a spreadsheet by receiving a request to process a spreadsheet having a plurality of records for storage in a database. Embodiments may also include accessing a configuration file associated with the spreadsheet and, for each record of the spreadsheet, creating a new business object and populating the new business object based on the record and the configuration file associated with the spreadsheet. Embodiments may also include passing each new business object to a back-end business component for processing. The configuration file may include a name of a business object associated with a record of the spreadsheet, metadata for one or more columns of the spreadsheet, and/or a name of a back-end business component associated with the spreadsheet.

Abstract: Generally speaking, systems, methods and media for processing a spreadsheet for storage in a database are disclosed. Embodiments may include a method for processing records of a spreadsheet by receiving a request to process a spreadsheet having a plurality of records for storage in a database. Embodiments may also include accessing a configuration file associated with the spreadsheet and, for each record of the spreadsheet, creating a new business object and populating the new business object based on the record and the configuration file associated with the spreadsheet. Embodiments may also include passing each new business object to a back-end business component for processing. The configuration file may include a name of a business object associated with a record of the spreadsheet, metadata for one or more columns of the spreadsheet, and/or a name of a back-end business component associated with the spreadsheet.

Abstract: Generally, systems, methods and media for processing a spreadsheet for storage in a database are disclosed. Embodiments may include a method for processing records of a spreadsheet by receiving a request to process a spreadsheet having a plurality of records for storage in a database. Embodiments may also include accessing a configuration file associated with the spreadsheet and, for each record of the spreadsheet, creating a new business object and populating the new business object based on the record and the configuration file associated with the spreadsheet. Embodiments may also include passing each new business object to a back-end business component for processing. The configuration file may include a name of a business object associated with a record of the spreadsheet, metadata for one or more columns of the spreadsheet, and/or a name of a back-end business component associated with the spreadsheet.

Abstract: A system for logging changes to a database table comprises an administration tool, table metadata, a history table, and a service engine. The administration tool provides an interface through which a database administrator (DBA), database programmer, or other user can manage the table metadata and the history table, including the selection of columns within the table for which the system will track changes.

Abstract: A system and method for logging changes to a database table are disclosed. The system comprises an administration tool, table metadata, a history table, and a service engine. The administration tool provides an interface through which a DBA, database programmer, or other user can manage the table metadata and the history table, including the selection of columns within the table for which the system will track changes. In the preferred embodiment, the service engine is a middleware application that tracks changes for the selected columns. The service engine processes all user-requested database operations and adds operations to manage the history table before relaying the request operations to a DBMS. Alternatively or additionally, the service engine may be a wrapper to existing services that the database application provides.

Abstract: A method for generating a transaction-bound sequence of records in a database table is disclosed. In response to a transaction attempting to insert a record to a database table within a relational database, an identification (ID) of the transaction and the name of the associated database table are initially obtained. A determination is then made whether or not the obtained transaction ID and the associated database table name are found in the transaction-bound tracking table. If they are not found in the transaction-bound tracking table, a new entry is generated in the transaction-bound tracking table for the obtained transaction ID and database table name, and a value in a last_order_number column associated with the entry is set to 1; otherwise, a value in the last_order_number column associated with the entry is incremented by 1.

Abstract: A method for generating a transaction-bound sequence of records in a database table is disclosed. In response to a transaction attempting to insert a record to a database table within a relational database, an identification (ID) of the transaction and the name of the associated database table are initially obtained. A determination is then made whether or not the obtained transaction ID and the associated database table name are found in the transaction-bound tracking table. If they are not found in the transaction-bound tracking table, a new entry is generated in the transaction-bound tracking table for the obtained transaction ID and database table name, and a value in a last_order_number column associated with the entry is set to 1; otherwise, a value in the last_order_number column associated with the entry is incremented by 1.

Abstract: Illustrative embodiments provide for the creation and maintenance of substitute database replication tables in the form of materialized query tables and associated staging tables for each selected table of a target database. One aspect of an illustrative embodiment provides a method for the creation of substitute database replication tables. The method comprising, obtaining a plurality of input specifications, to create an identified set of target databases of a database management system. The method also establishes a connection with the database management system of the identified set of target databases. Further generating a materialized query table and corresponding staging table combination for each specified table from a plurality of tables belonging to a respective database of the identified set of target databases.

Abstract: Generally speaking, systems, methods and media for processing a spreadsheet for storage in a database are disclosed. Embodiments may include a method for processing records of a spreadsheet by receiving a request to process a spreadsheet having a plurality of records for storage in a database. Embodiments may also include accessing a configuration file associated with the spreadsheet and, for each record of the spreadsheet, creating a new business object and populating the new business object based on the record and the configuration file associated with the spreadsheet. Embodiments may also include passing each new business object to a back-end business component for processing. The configuration file may include a name of a business object associated with a record of the spreadsheet, metadata for one or more columns of the spreadsheet, and/or a name of a back-end business component associated with the spreadsheet.

Abstract: Systems, methods and media for propagation of database schema changes are provided. In one embodiment, a usability tool identifies changes in the schema of a database. The usability tool identifies source code dependencies that are affected by the changes in database schema. A tool informs a user of the affected dependencies and may also automatically update existing source code dependencies corresponding to the changed schema.

Abstract: A unified network address database for recording network addresses for both internally accessible (e.g. intranet) and externally accessible (e.g. Internet) sites, servers and resources, including ownership information and authorization policies. A system for accessing the address database is provided to allow a user access to the contents according to the user's defined privileges.