55 results about "Database trigger" patented technology

A database that can store static and dynamic entries, wherein a static entry contains conventional static data, and a dynamic entry contains information specifying dynamic behavior to control devices on a network. In this database, the act of storing a dynamic entry in the database triggers control over devices on the network. More specifically, one embodiment of a database system according to the present invention includes a data storage medium for storing entries as well as an indexing structure for locating entries on the data storage medium. It also includes a storage mechanism for performing operations to store entries on the data storage medium. Encoded on the data storage medium are dynamic entries containing descriptions of dynamic behavior for the devices on the network. The database additionally includes an execution mechanism that, in response to a dynamic entry being stored on the data storage medium, commands the devices on the network to perform the dynamic behavior specified in the dynamic entry. In a variation on the above embodiment, the execution mechanism is configured to periodically monitor and control the devices on the network.

The present invention relates to the area of workflow management systems (WFMS). More particularly the inventions extends WFMS by subscription means. The subscription means operate on an audit trail stored within a database. The subscription means may encompass a multitude of subscription monitors. Subscription monitors allow to subscribe to the audit trail, i.e. to formulate certain interests as subscription selectors on information entered into the audit trail. A subscription monitor autonomously checks the audit trail for subscribed audit records. If such audit records have been determined the subscription monitor executes a subscription actuator, i.e. a pre-defined program. The subscription actuator may inform the subscriber on the subscribed audit record or may start any type of program. The current invention teaches to implement the subscription monitors as database triggers of the database storing the audit trail. The subscription selectors are realized as search conditions of the database trigger. Finally the subscription actuator can be implemented according the current teaching as user-defined functions of the database.

A method and system for preserving access of a system in case of disaster having a primary filestore and a primary system database, comprising: a replica system having a replica filestore and a replica system database; having a second empty filestore for recording all changes to the primary filestore; and having at least one database trigger on each primary system table save those that uniquely identify the primary system on the network fabric for catching recording and transferring, reference data to the replica system database which has been inserted deleted and or been updated in the primary system table; and at least one access preservation table for storing access preservation data; and at least one transaction table one being placed on the replica, and primary system for storing all transactions, and reference data on the basis of earliest recorded time; and at least one database procedure to carry out asynchronously fast forward or rollback changes in the metadata and or filestore by using the transaction tables, access preservation tables and the second replica filestore.

A database that can store static and dynamic entries, wherein a static entry contains conventional static data, and a dynamic entry contains information specifying dynamic behavior to control devices on a network. In this database, the act of storing a dynamic entry in the database triggers control over devices on the network. More specifically, one embodiment of a database system according to the present invention includes a data storage medium for storing entries as well as an indexing structure for locating entries on the data storage medium. It also includes a storage mechanism for performing operations to store entries on the data storage medium. Encoded on the data storage medium are dynamic entries containing descriptions of dynamic behavior for the devices on the network. The database additionally includes an execution mechanism that, in response to a dynamic entry being stored on the data storage medium, commands the devices on the network to perform the dynamic behavior specified in the dynamic entry. In a variation on the above embodiment, the execution mechanism is configured to periodically monitor and control the devices on the network.

A method, apparatus and program product modify the behavior of a database trigger. An attribute desired by a user for a database trigger may be received. The attribute may relate to a change in the functionality of the trigger, such as a restriction on trigger behavior. An object that includes the attribute may be generated. The attribute may be associated with and applied to the trigger. In this manner, the attribute may be selectively applied to multiple triggers.

Provided is a method, system, and program for implementing a database trigger. Upon detecting a trigger event, a determination is made of at least one row in a base table affected by the trigger event. For each column in the base table of a data type that is referenced in a triggered action associated with the trigger event, a reference is generated referencing the data of the data type. The reference is inserted in a transition table column including data of the data type from the affected row in the base table referenced in the triggered action. The reference is used to access the data of the data type when performing the triggered action.

Provided is a data synchronization method and a system for heterogeneous databases. Two heterogeneous databases respectively set the same unique identifier for related control data of the same application level transaction. A source database triggers modification of the related control data, with the unique identifier, of the same application level transaction. Modification information is set in a source data synchronization table in the source database. The source data synchronization process in a data synchronization execution system reads the modification information in the source data synchronization table, and the modification information is converted into a standard text file to store. The target database synchronization process in the data synchronization execution system reads the standard text file, and the standard text file is converted into the modification information of the related control target data, with the unique identifier, of the same application level transaction. The modification information is written into a target data synchronization table in a target database. The related target data in the target database is modified after the modification information of the related control target data in the target data synchronization table. According to the data synchronization method and the system for heterogeneous databases, data synchronization between databases with different data storage structures is achieved.

Provided is a method, system, and program for implementing a database trigger. Upon detecting a trigger event, a determination is made of at least one row in a base table affected by the trigger event. For each column in the base table of a data type that is referenced in a triggered action associated with the trigger event, a reference is generated referencing the data of the data type. The reference is inserted in a transition table column including data of the data type from the affected row in the base table referenced in the triggered action. The reference is used to access the data of the data type when performing the triggered action.

The invention provides a method of data update, a database trigger and an SE (search engine). The method comprises the following steps: when the attribute of the business data in a business table is updated, establishing an updating log, and triggering the SE to update index data according to the updating log, wherein the business table comprises the unique identification of each business data and at least one attribute of each business data; the updating log comprises the unique identification of the updated business data and updating type; the index data and the updated business data have the same unique identification; the SE is used for searching the index data. According to the method of data update, the database trigger and the SE, disclosed by the invention, the attribute of the search data and the attribute of the business data in the business table can be consistent as much as possible through establishing the updating log and triggering the SE to timely update the index data according to the updating log.

The present invention is aimed at resolving the problems of that its efficiency is low, operation is complex and its data are easily damaged which are existed in the data reproduction between two data bases with different versions, and utilizes the adoption of data base trigger technique and programmes the data reproduction software so as to implement large batch reproduction of data in non-file mode.

A system to identify database triggers in a data processing system. A request is received to create a database monitor for a specific application event and in response to receiving the request to create the database monitor, the database monitor is created. Then, a request is received to monitor the specific application event within a database and in response to receiving the request to monitor the specific application event, a replicate database of the database is created. Subsequently, the database is compared to the replicate database after the specific application event occurs to identify changes in the database associated with the specific application event. A best candidate is identified for a database trigger based upon the identified changes in the database associated with the specific application event.

A system to identify database triggers in a data processing system. A request is received to create a database monitor for a specific application event and in response to receiving the request to create the database monitor, the database monitor is created. Then, a request is received to monitor the specific application event within a database and in response to receiving the request to monitor the specific application event, a replicate database of the database is created. Subsequently, the database is compared to the replicate database after the specific application event occurs to identify changes in the database associated with the specific application event. A best candidate is identified for a database trigger based upon the identified changes in the database associated with the specific application event.

The embodiment of the invention discloses a data extraction system and a data extraction method. The data extraction system comprises a data source and a big data platform, wherein the data source comprises a data reproduction module and a data extraction module, and the big data platform comprises a distributed file module and / or a data warehouse tool module; the data reproduction module is usedfor adding database triggers to the data source and duplicating updated data from the database triggers to generate an incremental data extraction queue; the data extraction module is used for extracting the updated data from the incremental data extraction queue according to a set time interval and sending the updated data to the big data platform; the big data platform is used for correcting stored data according to the updated data; the distributed file module and the data warehouse tool module are used for receiving the updated data. According to the technical scheme, a Hadoop big data platform can obtain processing operations of data tables by enterprise management software SAP, and updates the data tables stored in itself according to the obtained processing operations.

Provided is a method of integrating events such as creation, modification and deletion associated with computer files into a database management system (DBMS) or relational DBMS (RDBMS). Once a file associated with a RDBMS is created, updated or deleted, the RDBMS is notified of the event so that a trigger corresponding to the event and the file can be executed. A file system callback mechanisms associated with asynchronous and non-blocking input / output (I / O) functions communicates the completion of file creation, deletion and update operations to a RDBMS. The RDBMS recognizes the communication and fires an appropriate database trigger or triggers.

A method and apparatus for providing web pages to a client with improved speed and efficiency. Web pages are cached in a web server and are referenced from a database in a database server. When a request from a client is sent to the web server for a web page, the web server checks the web page cache table in the database server. The web page cache table contains a field wherein a flag is set to indicate whether any data that affects the web page has been updated. Database triggers are used to change the value of the flag when specified data fields corresponding to a web page have been changed. If the value of the flag indicates that there has not been any change in the data, the web server reads the html file reference in the web page cache table, retrieves the corresponding page from the web page cache in the web server and sends the page back to the client. If the value of the flag indicates that the data has changed, the web server reconstructs the web page from the database, caches the web page and resets the value of the flag before sending the web page to the client. The method and apparatus of the present invention is capable of delivering cached web pages in a much shorter time than is needed to generate the web page each time a request is received from a client.

The invention discloses a K-anonymization based motion track data privacy protection method and system. A K-anonymization technology is adopted for generalizing motion track data and hiding real data, the generalized data is encrypted at the same time by establishing a database trigger mechanism, and the generalized data is decrypted and recovered into original data by utilizing a design data recovery algorithm, so that privacy protection of the motion track data is realized. According to the K-anonymization based motion track data privacy protection method and system, a K-anonymization generalization algorithm is improved, so that the generalized track privacy data can be recovered, it is ensured that the original data can be recovered while the privacy data is hidden, and the data completeness is realized.

The invention belongs to the field of government affair network data sharing, and discloses a government affair intranet and extranet data synchronization method and system, and the government affairintranet and extranet data synchronization method comprises the steps: creating a trigger, and automatically recording newly added, updated and deleted services; creating a timing task, and recordingdata regularly; batch processing programs can be manually executed at regular time to be exported or correspondingly imported into an external network according to a management system. According to the invention, data synchronization between systems deployed in a physical isolation network is realized, the characteristics of a database trigger are fully utilized, the complete change process of data is recorded, and data synchronization is conveniently carried out in an import and export manner. The government affair intranet and extranet data synchronization method is simple, convenient, easyto implement and high in data consistency, data synchronization between systems is achieved, repeated input is reduced, and the working efficiency is improved.

The invention provides an indoor positioning self-adaptive sampling method. The method is characterized in that a periodically triggered self-adaptive database updating period, a sampling transmission interval and the characteristic quantity difference threshold updated by a self-adaptive database triggered by an event are configured through a network side. When a system detects that the database satisfies the condition of the periodic updating or the event updating, sampling instructions are sent through a network side sampling terminal to instruct the sampling terminal to transmit a wireless signal according to the network side configuration, and the network side extracts a wireless signal characteristic quantity of the sampling terminal and dynamically updates the present database. The method enables the system to match dynamic changes of a wireless environment in a self-adaptive mode, and raises the indoor positioning precision of the system.

An automated method and system that uses a Web service to make real-time production status available to customers from a manufacturing environment. Each time Work in Process (WIP) data is updated from manufacturing execution systems to a central database, a database trigger checks the alert conditions. These conditions are automatically compared to the WIP data to see if the user-defined conditions have been met. If so, a function is called which automatically sends an alert to the customer via the internet and either e-mail, pager, or mobile phone.

Exemplary scalable, rule-based data synchronization systems and methods are disclosed. An exemplary method includes at least one computing device executing a database trigger process in response to a database trigger event, the database trigger process including writing a general data message to a general message repository. The method further includes the at least one computing device executing an independent process including monitoring the general message repository, detecting the general data message in the general message repository, and processing, in response to the detecting of the general data message in the general message repository, the general data message in accordance with a predefined set of rules. Corresponding systems and methods are also disclosed.

The invention provides a platform data remote backup method which can realize the remote backup of the data in a platform. The method comprises the following steps: obtaining a data operation type and operated data by using a database trigger in a main station; transmitting the obtained data operation type and the operated data to a main station asynchronous backup service; enabling the main station asynchronous backup service to send changed data in a database to a remote backup station according to the received data operation type and the operated data so that a remote backup station backup service stores the received changed data in the remote backup station locally and records data backup information in the database of the remote backup station, wherein the data backup information is corresponding information between the local data of the remote backup station and the data in the main station platform. The platform data remote backup method is suitable for the technical field of cloud computing platform data backup.

The invention discloses a route planning method based on touch operation, which comprises the following steps of: selecting and inputting takeoff airport data on a first operation touchpad, acquiringrelevant instruction data by a navigation database and triggering next operation instruction; selecting and inputting the landing airport data on a second operation touchpad, and a navigation databaseobtaining relevant instruction data and triggering a next working instruction; the navigation database triggering the sub-selection system upon receiving instructions of the first operation touch padand the second operation touch pad, displaying the sub-selection items on the first operation touchpad and the second operation touchpad, and the operator continuing to select the route point until the take-off route point, and the landing route point and other route points to be connected to form a complete route.

The invention mainly provides a method for handling uncertainty of return results of a trigger, relating to the technical field of computer software. The method specifically includes the following steps that first of all, a variable is stated and is assigned; when processing a cursor, the variable value is changed according to different numbers of the return results through the corresponding abnormal handlings conducted to different return results in an Oracle database, for example, the variable is 1 at the beginning, when the cursor returns one result, the value remains unchanged, when the cursor returns a plurality of results, the variable value is assigned to be 2 and when the cursor returns no result, the variable value is assigned to be 0; and finally different program segments are executed with respect to different variable values by judging the sentences. In such a way, the return results are of clear structure and are simple and explicit, and therefore the trigger can accurately handle the return results of the cursor, the complicated problem is simplified and the expected target is accomplished. The invention aims to solve the technical problem of providing a method for handling the uncertainty of the return results of the trigger so as to ingeniously solve the problem of uncertainty of the return results of the trigger of a database by analyzing the results.

The invention discloses a data synchronization method and system and a storage medium, the system comprises a main database, a database trigger, a synchronization queue and at least one client database, a plurality of synchronization data are stored in the main database, and the synchronization queue is provided with database tables corresponding to the synchronization data; wherein the database trigger is used for monitoring a main database, triggering to generate trigger information when a synchronous data sending event operation of the main database is monitored, and sending the trigger information to a corresponding database table; wherein the synchronization queue is used for acquiring synchronization data from the main database in combination with the trigger information and the database table, and performing synchronization operation on the client database according to the acquired synchronization data. Synchronization is carried out in a monitoring and queue synchronizing mode,namely data synchronization is carried out on the basis of a database layer, performance is high, fault tolerance is good, data can be prevented from being lost in data synchronization, and the method can be widely applied to the technical field of data synchronization.

Embodiments of the invention provide techniques for processing database triggers having delay attributes. In general, delay attributes may selectively introduce a delay between the firing of a trigger and the execution of the triggered action. The delay may be based on waiting for a specified time interval, waiting until a specified time, or reaching a predetermined threshold of a measure of system performance. The use of delay attributes may enable greater control over the timing of the execution of the triggered action, resulting in reduced impact on the performance of an underlying system.

The invention belongs to the field of a monitoring system and provides a base station monitoring method for realizing alarm based on a database trigger. The method is used for improving the expansibility and maintainability of a base station monitoring system and reducing system development and debugging workloads and the system development difficulty. The method comprises the steps of setting a database, wherein items of the database comprise monitoring objects, real-time monitoring values, a monitoring value upper limit and a monitoring value lower limit, and setting a trigger for each detection object; collecting the real-time monitoring values of base stations through sensors and storing the real-time monitoring values to the database in real time; checking the real-time monitoring values by the database through the triggers, calling an alarm processing program when the real-time monitoring values exceed the monitoring value upper limit or the monitoring value lower limit; and uploading alarm information comprising the current detection objects and the real-time monitoring values to a monitoring center by the alarm processing program. The base station monitoring method provided by the invention has the advantages of high expansibility, high maintainability and convenient management.

A method and a device for realizing the function of database trigger are disclosed. The method includes the following steps: registering a table-level trigger (S101); obtaining a table record, which is needed to be loaded, from a file, when the file is needed to be added to the database, and comparing the obtained table record with a table record in the database (S102); updating the database when there is variation in the obtained table record, and distributing a message about variety of the table in the database according to the registered table-level trigger (S103). A function of triggering in table unit and informing an application module of the data in the database being varied is realized. The method enriches the function of database trigger, satisfies the application requirement of table-level triggering, saves the processing time of the trigger by the database, and enhances the efficiency of the data real-time synchronization at the foreground.

Embodiments of the invention provide techniques for processing database triggers having delay attributes. In general, delay attributes may selectively introduce a delay between the firing of a trigger and the execution of the triggered action. The delay may be based on waiting for a specified time interval, waiting until a specified time, or reaching a predetermined threshold of a measure of system performance. The use of delay attributes may enable greater control over the timing of the execution of the triggered action, resulting in reduced impact on the performance of an underlying system.

The invention discloses a method for intelligently synchronizing a generic edition platform cloud disc file and a media resource system. The method comprises the following steps: the number of handles opened at present, locking identity and filing process identity are checked; whether a present file is subjected to filing treatment or not is detected through a databank trigger when the number of handles is zero; if the present file is not subjected to filing treatment, an identity position bit is targeted; the instruction that one file needs to be synchronized is notified to a synchronous filing progress of a server; after the synchronous filing progress receives a synchronization request, the synchronization request is put into a waiting queue so as to wait for treatment; an asynchronous working thread takes out the request and carries out filing treatment; and the treatment accomplishment of the databank is identified with a position bit, and the targeting identity is reset. With the adoption of the method, the media resource is utilized reasonably, and the cost of system equipment is reduced; the synchronization between multiple types of cloud disc files and media resource systems is supported; a synchronizer is called in accordance with the level of the priority; and the synchronizer can be called orderly and efficiently.