STATEMENT LOGGING IN DATABASES
First Claim
1. A method for logging data manipulation language (DML) statements, comprising:
- receiving a plurality of parsed DML statements; and
logging one or more log records associated with said statements using at least a begin record marker and an end record marker to logically separate log records associated with each DML statement.
2 Assignments
0 Petitions
Accused Products
Abstract
System, method, computer program product embodiments and combinations and sub-combinations thereof for logging of data manipulation language (DML) statements are described herein. An embodiment includes a database engine, a replication agent and a replication server which replicates data from the database engine to one or more replicate databases. The database engine writes parsed query information into a transaction log so that a process of replication agent may read the parsed query information and forward it to the replication server. The database engine writes all log records associated with a statement in a manner that allows the replication server to distinguish if those log records belong to same statement. In another embodiment, replication agent selectively sends SQL statement information to the replication server based on the replication server architecture.
-
Citations
14 Claims
-
1. A method for logging data manipulation language (DML) statements, comprising:
-
receiving a plurality of parsed DML statements; and logging one or more log records associated with said statements using at least a begin record marker and an end record marker to logically separate log records associated with each DML statement. - View Dependent Claims (2, 3, 4, 5)
-
-
6. A method of logging data manipulation language (DML) statements, comprising:
logging DML statement information only when the number of rows affected by a DML statement in a log record reached a configurable threshold. - View Dependent Claims (7)
-
8. A system for logging data manipulation language (DML) statements, comprising:
-
a database engine operable to log DML transactions in a transaction log using at least a begin record marker and an end record marker to logically separate statements inside a transaction; a replication agent operable to read said data and statements from said transaction log; and a replication server operable to receive said transactions from said replication agent.
-
- 9. The system of claim 9, wherein said database engine includes said transaction log.
-
12. The system of claim 12, wherein each log record is associated with a transaction ID.
-
13. A computer program product having control logic stored therein, said control logic enabling a processor to replicate a data manipulation language statement, said control logic comprising:
-
receiving means for enabling a processor to receive a plurality of parsed DML statements; and storing means for enabling a processor to store one or more log records associated with said statements using at least a begin record marker and an end marker to logically separate log records associated with each of said DML statements.
-
-
14. A computer program product having control logic stored therein, said control logic enabling a processor to replicate a data manipulation language statement, said control logic comprising:
sending means for enabling a processor to selectively send DML statement information when said estimate matches a configurable threshold associated with said DML statement.
Specification