Patents
Literature
Hiro is an intelligent assistant for R&D personnel, combined with Patent DNA, to facilitate innovative research.
Hiro

55 results about "Database trigger" patented technology

A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database. The trigger is mostly used for maintaining the integrity of the information on the database. For example, when a new record (representing a new worker) is added to the employees table, new records should also be created in the tables of the taxes, vacations and salaries. Triggers can also be used to log historical data, for example to keep track of employees' previous salaries.

Subscription within workflow management systems

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.
Owner:IBM CORP

Method and system for preserving real-time access to a system in case of a disaster

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.
Owner:KAPUR RAJESH

Database for executing policies for controlling devices on a network

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.
Owner:ORACLE INT CORP

Database Trigger Modification System and Method

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.
Owner:IBM CORP

Data synchronization method and system for heterogeneous databases

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.
Owner:CHINA MOBILE GROUP JIANGSU

Method, system, and program for implementing a database trigger

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.
Owner:IBM CORP

Method of data update, database trigger and SE (search engine)

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.
Owner:HUAWEI TECH CO LTD

Method and system for identifying database triggers

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.
Owner:IBM CORP

Data extraction system and data extraction method

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.
Owner:新智云数据服务有限公司

Method and apparatus for web cache using database 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.
Owner:DELL PROD LP

K-anonymization based motion track data privacy protection method and system

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.
Owner:NANJING NORTH OPTICAL ELECTRONICS

Government affair intranet and extranet data synchronization method and system

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.
Owner:LINEWELL SOFTWARE

An indoor positioning self-adaptive sampling method and apparatus

ActiveCN106612543AThe practical engineering application is convenient and reliableReduce engineering complexityPosition fixationHigh level techniquesComputer terminalDatabase trigger
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.
Owner:北京金坤科创技术有限公司

Web service and method for customers to define their own alert for real-time production status

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.
Owner:TAIWAN SEMICON MFG CO LTD

Scalable rule-based data synchronization systems and methods

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.
Owner:VERIZON PATENT & LICENSING INC

Platform data remote backup method

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.
Owner:UNIV OF SCI & TECH BEIJING

A route planning method based on touch operation

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.
Owner:BEIJING AERONAUTIC SCI & TECH RES INST OF COMAC +1

Method for handling uncertainty of return results of trigger

ActiveCN102707956AAccurate processing of returned resultsClear structureSpecific program execution arrangementsProgram segmentOracle database
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.
Owner:福建汇智数字通达科技有限公司

Data synchronization method and system and storage medium

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.
Owner:广州市正盟计算机科技有限公司

Method and Apparatus for Effecting Database File Performance by Allowing Delayed Query Language Trigger Firing

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.
Owner:IBM CORP

Base station monitoring method for realizing alarm based on database trigger

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.
Owner:UNIV OF ELECTRONICS SCI & TECH OF CHINA

A method and device for realizing database trigger function

InactiveCN102289433AImprove the efficiency of real-time synchronizationVersatileSpecial data processing applicationsDatabase design/maintainanceLevel triggerComputer module
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.
Owner:ZTE CORP

Affecting database file performance by allowing delayed query language trigger firing

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.
Owner:IBM CORP

Method for intelligently synchronizing generic edition platform cloud disc file and media resource 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.
Owner:成都东方盛行电子有限责任公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products