Patent application number | Description | Published |
20100030730 | System, Method, and Computer Program Product for Determining SQL Replication Process - A system, method, and computer program product are provided for replicating a table in a source database to a target database. In accordance with an embodiment of the present invention, a subscription to the table is defined and a query is executed on the source database. The query is then normalized, and it is determined whether the query would cause semantically appropriate changes to the target database. If so, the normalized query is sent to the target database for execution, in accordance with an additional embodiment of the present invention. | 02-04-2010 |
20100030817 | STATEMENT CATEGORIZATION AND NORMALIZATION - Systems, methods and computer program products for statement categorization and normalization are described herein. An embodiment includes a statement categorizer and a statement normalizer. The statement categorizer categorizes statements to reduce or even eliminate inconsistencies that may arise between primary and replicate databases as a result of executing certain statements. Categorized statements are normalized by the statement normalizer to generate normalized statements, which are provided to a replication server. Normalized statements assist replication server to regenerate a statement to be executed on a replicate database. | 02-04-2010 |
20100030824 | STATEMENT LOGGING IN DATABASES - 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. | 02-04-2010 |
20110153568 | HIGH VOLUME, HIGH SPEED ADAPTIVE DATA REPLICATION - System, method, computer program product embodiments and combinations and sub-combinations thereof for data replication in a database system environment are described. In an aspect, the data replication includes grouping, in-memory, a plurality of transactions to be replicated as a single transaction from a source database system to a target database system. A plurality of net row changes is compiled for the plurality of transactions, and data inconsistency detection and resolution within a command application order are performed. Further included is bulk application of the plurality of net row changes to the target database system. | 06-23-2011 |
20120158650 | DISTRIBUTED DATA CACHE DATABASE ARCHITECTURE - System, method, computer program product embodiments and combinations and sub-combinations thereof for a distributed data cache database architecture are provided. An embodiment includes providing a scalable distribution of in-memory database (IMDB) system nodes organized as one or more data fabrics. Further included is providing a plurality of data granularity types for storing data within the one or more data fabrics. Database executions are managed via the one or more data fabrics for a plurality of applications compatible with at least one data granularity type. | 06-21-2012 |
20120158805 | NON-DISRUPTIVE DATA MOVEMENT AND NODE REBALANCING IN EXTREME OLTP ENVIRONMENTS - Systems and methods for non-disruptive cache startup, shutdown, data partition movement, and node rebalancing for a data fabric within a data grid in a database environment. The data grid is a clustered in-memory database (IMDB) cache comprising one or more data fabrics including multiple IMDB cache nodes. The method takes a time tag and moves data from source to destination nodes while allowing updates to data on the source nodes. The method propagates updates occurring after the time tag to destination nodes from source nodes and switches applications and ownership to the destination nodes. Another method slices data for a partitioned fabric and stores slices on nodes. Another method starts a data fabric by moving data from a grid backend to the nodes. In an embodiment, another method rebalances nodes in a non-disruptive manner. When a fabric is shutdown, the method saves data from the nodes to the grid backend. | 06-21-2012 |
20130159249 | HYBRID DATA REPLICATION - System, method, computer program product embodiments and combinations and sub-combinations thereof for hybrid data replication are described. Aspects include identifying a type of database data replication, the type including a combination of replication approaches, and managing replication based on the identified type, including coordinated switching from one replication approach to another automatically with transactional consistency maintained among source and target databases. | 06-20-2013 |
20130159253 | DIRECTING A DATA REPLICATION ENVIRONMENT THROUGH POLICY DECLARATION - System, method, computer program product embodiments and combinations and sub-combinations thereof for directing a data replication environment through policy declaration are described. Aspects include identifying a policy declaration defining a replication environment, and processing the policy declaration to instantiate the replication environment according to parameters established in the policy declaration. | 06-20-2013 |
20140072945 | Method and a system to deliver a live and instant interactive school experience over a plurality of learning sites at different locations, such locations being broadcast simultaneously to a plurality of cohort or individual learners at different locations throughout a network. - A system for delivering distance learning enables a plurality of teaching sites to be streamed to multiple locations via a network with instant, real time information conveyance and instant interaction between at least one teacher at least one of said teaching sites and at least one learner at least one learning site via video images, audio signals, whiteboard functions, and other text chat messaging and other digital signal modes. | 03-13-2014 |