Method and system for integrating file system events into a relational database
First Claim
1. A method for integrating file system events into a database management system (DBMS), comprising:
- designating a file of interest;
detecting a file state change event associated with the file of interest;
updating a file events table of a database upon a detection of the file state change event;
generating a database trigger upon a change in the file events table; and
updating the database with data from the file of interest upon receipt of the database trigger.
1 Assignment
0 Petitions
Accused Products
Abstract
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.
20 Citations
20 Claims
-
1. A method for integrating file system events into a database management system (DBMS), comprising:
-
designating a file of interest;
detecting a file state change event associated with the file of interest;
updating a file events table of a database upon a detection of the file state change event;
generating a database trigger upon a change in the file events table; and
updating the database with data from the file of interest upon receipt of the database trigger. - View Dependent Claims (2, 3, 4, 5, 6, 7, 12)
-
-
8. A system for integrating file system events into a database management system (DBMS), comprising:
-
a database;
a file events table associated with the database;
a file of interest;
logic for detecting a file state change event associated with the file of interest;
logic for updating the file events table upon a detection of the file state change event;
a database trigger generated upon a change in the file events table; and
logic for updating the database with data from the file of interest upon receipt of the database trigger. - View Dependent Claims (9, 10, 11, 13, 14)
-
-
15. A computer programming product for integrating file system events into a database management system (DBMS), comprising:
-
a memory;
logic, stored on the memory, for designating a file of interest;
logic, stored on the memory, for detecting a file state change event associated with the file of interest;
logic, stored on the memory, for updating a file events table of a database upon a detection of the file state change event;
logic, stored on the memory, for generating a database trigger upon a change in the file events table; and
logic, stored on the memory, for updating the database with data from the file of interest upon receipt of the database trigger. - View Dependent Claims (16, 17, 18, 19, 20)
-
Specification