112 results about "Domine Database" patented technology

Objects in a master database and objects in a replicated database are synchronized using identifiers and version stamps of the objects. Each object has a unique identifier and a version stamp that is incremented when the object is updated at the master database. A synchronization server uses the identifiers and version stamps of objects to perform out-of-date detection and conflict detection. The synchronization server resolves update conflicts according to rules.

An on-line primary database is momentarily QUIESCED to enable a physically consistent snapshot of the primary database to be mirrored to a secondary database as a backup while allowing the primary database to continue on servicing multiple user applications.

An online primary database is automatically configured to enable a physically consistent snapshot of the primary database at the secondary database to be uniquely mirrored to a secondary remote database as backup while allowing the specialized control audit images to be created at the primary database.

The present invention provides for a method and an apparatus for archiving and retrieving data. At least one top-level directory is created to store files. A file-location database is created to track stored files in the top level directory. Files from a primary database are received. Files received from the database are archived into the top level directory, in response to receiving files from a primary database. An immediate backup of the archived files is created. A long-term backup of the archived files is created.

A method of optimizing an execution of a query on data may include steps of creating schema object(s) in a database schema, enable monitoring of the schema object(s) to monitor the amount of change of a predetermined characteristic of the schema object(s) over time and loading the data into the created schema object(s). It is then determined whether the amount of change of the predetermined characteristic exceeds a selectable threshold. Updated statistical information may be obtained only when the amount of change exceeds the threshold. The updated statistical information may then be provided to a query execution optimizer, which selects an execution plan based upon the updated statistical information when the amount of change exceeds the threshold or based upon previously provided statistical information when the amount of change does not exceed the threshold. The query may then be executed using the selected execution plan.

A system includes an active node and a standby node and zero or more replica nodes. Each of the nodes includes a database system, such as an in-memory database system. Client updates applied to the active node are written through to the standby node, and the standby node writes the updates through to a primary database and updates the replica nodes. Commit ticket numbers tag entries in transaction logs and are used to facilitate recovery if either of the active node or the standby node fails. Updates applied to the primary database are autorefreshed to the active node and written through by the active node to the standby node which propagates the updates to the replica nodes. Bookmarks are used to track updated records of the primary database and are used to facilitate recovery if either of the active node or the standby node fails.

In a client / server computer environment having a fileserver running a mater database and clients supporting cache databases, inconsistent data write accesses are prevented by using a data locking technique, which locks data during the course of an up-date transaction requested by one client. This prevents access to the same data by another client. Data consistency is checked prior to the write access, by comparing a time stamp associated with a respective cache database entry and a time stamp associated with the index to the corresponding data entry in the master database. Time stamp equivalence obviates the need to access the master database or to transfer data across the client / server communications network.

The invention comprises a system for assisting an organization to implement and maintain compliance management programs, the system comprising a plurality of modules relating to particular legislative or other obligations with which the organization is required to comply; at least one master database containing information on said legislative or other compliance obligations; at least one slave database containing and allowing entry of information of activities and incidents or accidents in the organization and assessments of the organization; and report generating means for generating a report on actions required to render the organization complaint with the legislative or other requirements in the master database.

A method is provided to verify a database copy of a primary database which has been replicated. A secondary physically consistent copy of the primary database is put in a state of quiesce while the primary database is allowed to resume update activity. The consistent copy, in a state of quiesce, can be used for database maintenance activities or as a recovery source should the primary database be damaged, but the consistent copy is first checked for integrity by using a Verify option before such recovery source is utilized.

An efficient partitioning scheme is provided to improve efficiency of updating a reference list database of a deduplication engine. Transaction objects of a transaction log can be divided into a number of partitioned log files, based on criteria. The transaction objects within each partitioned log file are then sorted in parallel, while maintaining time order of the transaction objects. The present disclosure also provides for dividing database records of a reference list database into multiple tables, such as a master database table and a number of child database tables. The efficient partitioning scheme also provides for processing the transaction objects of each partitioned log file against a respective child table of the reference list database in parallel, such as by updating temporary child tables with information from the transaction objects in parallel. The temporary database tables then replace (the previous version of) the reference list database tables.

Disclosed is a data replication method in a Database Management System (DBMS). The data replication method includes generating a replication log through a transaction log of a master database to thereby transmit the generated replication log to a distributor, determining a slave host distributing the replication log to thereby distribute the replication log to the corresponding slave host, and reflecting the replication log in a slave database.

A method and system that annotates a redo log to provide information concerning the execution of a procedure at a primary database. The annotations include entry and exit markers that indicate the beginning and the end of the execution along with any arguments passed to the procedure, and whether the execution of the procedure was successful. At the standby database, these markers are used to create a logical transaction associated with the procedure. The operations performed by the procedure are grouped into individual transactions, and these individual transactions are grouped as belonging to the logical transaction. If the execution of the procedure was successful at the primary database, then the individual transactions are discarded, and the logical transaction is applied by executing the procedure at the standby database. If the execution of the procedure failed at the primary database, then the individual transactions and the logical transaction are discarded.

An application that was not internationalized when coded may be internationalized through the addition of interception and localization logic and tables without modification of the original application logic. The interception logic may be configured to intercept calls to an application component and invoke localization logic in response to an intercepted call to the application component. The interception logic may use dynamic proxies to intercept method calls from a client component to an application component both before and after the execution of the method. The interception logic may use JAVA reflection to determine whether input parameters or return values associated with the method call are localizable. The application component logic may operate on data stored in a primary database table in which the data is represented in the system default locale.

A surveillance monitoring and automated reporting method is used for detecting observable changes in data sources over a network, such as the internet, for accessing changing data, such as world wide web content data, and for providing scheduled change detection notifications and results through user defined search criteria for automated monitored search criteria matches on a recurring basis by user defined scheduling. The method extracts content data from the data sources and updates a master database, then detects changes in the content data within the search criteria. Upon detection, the user is notified using graphical interfaces, electronic mail messages, pager messages, or personal data assistant messages.

Objects in a master database and objects in a replicated database are synchronized using identifiers and version stamps of the objects. Each object has a unique identifier and a version stamp that is incremented when the object is updated at the master database. A synchronization server uses the identifiers and version stamps of objects to perform out-of-date detection and conflict detection. The synchronization server resolves update conflicts according to rules.

An arbitrary number of custom catalogs for an arbitrary number of customers can be published from a single database of seller catalog data. Custom browse hierarchies can be generated for each of the custom catalogs. The custom catalogs are subsets of the catalog database, and are generated in accordance with a set of rules that defines the scope of the content of the custom catalog. The rule sets define a series of sequential searches by which a subset of the product SKUs contained in the database are returned. A primary hierarchy is maintained that can have a scope coextensive with the primary database. Custom browse hierarchies can be pruned to render their scope approximately coextensive with each subset. The custom catalog subsets and the custom browse hierarchies are generated periodically through a virtual publication process.

A graphical user interface based method of configuring automatic failover from a primary database system to a standby database system that is coupled to the primary database system by a network. Also coupled to the network is an observer process that is independent of the database systems and that initiates the failover process. The observer periodically pings the database systems to determine whether a failover is necessary. The graphical user interface permits a user to specify the primary and secondary database systems, configure the observer, and specify conditions under which a failover may occur and to enable automatic failover. A failover context is created from the inputs to the GUI and stored in persistent storage belonging to the database systems. If the Observer's context is stale, the Observer fetches the database system's context.

The various embodiments herein include at least one of systems, methods, and software that operate to replicate structural changes made to a master database to a replicate database. In some such embodiments, changes made to a master database are identified and a representation thereof is provided to a process that implements such changes in the replicate database. The structural changes are then replicated in the replicate database.

The invention discloses a system and a method for integration of change information collection and spatiotemporal data update. The system comprises a geospatial change information collecting terminal,a main database server and a client database server. The method comprises the following steps: step 1, obtaining present map data; step 2, carrying out changing surveying on geospatial sites to generate incremental information files; step 3, sending the incremental information files to the main database server and the client database server by the geospatial change information collecting terminalthrough a communication network; and step 4, timely updating a geospatial database in a database server by the main database server and the client database server according to the received incremental information files. The method improves the automation degree of spatiotemporal data update and consistency maintenance through integration of change information collection and update, accelerates the reaction speed of spatiotemporal data and reduces the burden of network transmission.

Techniques are provided for detecting lost writes so that data corruption can be avoided. According to one technique, lost writes are detected by comparing version numbers that are indicated in redo log entries with version numbers that are indicated in corresponding blocks in a standby database. According to one technique, which may be used in conjunction with the above technique, lost writes are detected by logging read operations that occur relative to a primary database, and comparing version numbers that are indicated in read log entries with version numbers that are indicated in corresponding blocks in a standby database. According to one technique, lost writes are detected by comparing, in response to read operations, (a) version numbers that are stored in a persistent in-memory cache with (b) version numbers that are indicated in corresponding blocks that are read from a primary database.

A patient encounter electronic medical record system, method, and computer product includes pre-populated, diagnosis specific templates, selective, specialty-specific master databases, and anatomic specific databases and templates to achieve comprehensive, accurate and compliant medical documentation that captures patient data concurrently with the clinical patient encounter session. The system is enabled for a distributed computing environment including graphical user interfaces and voice, text, and digital image and x-ray input.

Provision of a database access method allowing an open environment such as a Web system to access a main database constituted by a hierarchical database. A system for accessing a hierarchical database, including a storage section for storing schema information related to the hierarchical database converted to tree-structured data, and an access request generating section for generating a second access request to the hierarchical database based on the schema information converted to the tree-structured data corresponding to a first access request.

The invention discloses a database synchronization method and system. The method comprises the steps that a main database and a sub-database are divided into a plurality of zones, and each main data zone and each sub data zone are respectively provided with a main binary system journal file and a sub binary system journal file. When data changing happens in the main data zones, data changing is recorded in the main binary system journal files, the data changing record is transmitted to the sub-database, data changing is recorded in the sub binary system journal files, and data changing is carried out in the sub data zones of the sub-database. According to the method and the database system, the database is divided into the zones, the binary system journal files are arranged corresponding to the database zones, multithreading concurrent processing binary system journal file synchronization is used, and the problem that during a binary system journal file synchronization process, database end playback is slow, and database end system resource using rate is low is solved. In addition, data of the main database is transmitted to the sub-database end in a batch mode, and data lost from the sub-database end are reduced as much as possible.

The present invention relates to phonetic self-improving search engines. The search engine may include a phonetic database having a plurality of phonetic equivalent formulas stored therein, each of the phonetic equivalent formulas being associated with at least one respective pronounceable unit. After an initial query in a primary database fails to produce a positive result, an error memory database may be queried with a search string to obtain a positive result based on records of previously failed searches which ultimately found a positive result. If no record is found, the search string may be parsed into at least one pronounceable unit. Phonetically equivalent formulas may be applied to the at least one pronounceable unit to create at least one phonetic search string which is re-queried into the error memory database and the primary database. Successful positive results may be stored with the search string in the error memory database.

A system and method of distributing electronic coupon securely are disclosed, which includes a main database system, and a client system interconnected by a distributed computer network. Coupon data and advertising data can be encrypted to reduce the likelihood that such data may be misused, such as by unauthorized duplication. In addition, the client database system can be identified by a user identification that is allocated and associated with the user information collected from the user of the client database system. The user information can be indicative of one or more demographic characteristics of the user without being sufficiently and personally identify the user, thus preserving privacy. An icon can be provided to alert the user that new coupons are available.

A system, method, and processor readable medium containing code for causing a processor to synchronize a secondary database system, such as one stored on a palmtop electronic device, with a distributed database system, comprising a main database and at least one replica database. The system further comprises a modification module that contains entries for modifications that have been made to the secondary database since a previous synchronization between the secondary database and the distributed database system and a synchronization module that synchronizes the secondary database with one of the databases of the distributed database system using the modification module. Each database in the distributed database system stores an identification mapping database having an assigned version number. The system further comprises a replica identification database associated with the secondary database that contains an entry for each source database of the distributed database system, each entry comprising information regarding the last synchronization between the secondary database and the source database including the version of the identification mapping database associated with the source database when the synchronization occurred. A pruning module is provided for pruning entries from the modification module using the replication identification database.

A replication system with methodology for replicating stored procedure calls is described. In one embodiment, for example, in a database system without support for logging stored procedure invocations, a method of the present invention is described for replicating invocation of a stored procedure from a primary database to a replicate database, the method comprises steps of: inserting table data into the primary database for storing information sufficiently characterizing the procedure's invocation to allow its replication, the table data being logged to a log file; reading the log file, for determining changes to apply to the replicate database for replicating the procedure's invocation; and reconstructing the procedure's invocation at the replicate database based on the determined changes.

A system that improves the real time presentation of web analytics data to clients. Real time data is improved in one embodiment by using a messaging system that directs the data stream to RAM memory, before it is sent to the database. A separate path is provided for presenting the real time data, which does not require going through the main database. The data is serialized and streamed in batches at an interval which can be set from the order of seconds to minutes. Additionally, the data is aggregated in RAM according to the desired groupings of data, so that the aggregation is pre-computed.

The present invention relates to a system and method of data restoration, for instance, after the occurrence of a user error. In particular, snapshot database can be maintained that stores a copy of database data. The snapshot database does not have to store a complete copy of all data on a source database, but rather shares data that is common to both but not necessarily identical. If an error occurs on the primary database then the database can be reverted back to a point in time prior to the error by replacing source database files with snapshot files. Additionally, an undo component can be employed in conjunction with the snapshot to approach an error to a finer grained point in time. In brief, the present invention can restore a database much faster and simpler, while utilizing less space and resources than conventional data restoration technologies.