Sap Se

Isharingsoft, Inc.

Sap Ag

Yongjae Chuh

Juchang Lee

Jaeyun Noh

Norman May

Chang Gyoo Park

Hannes Jakschitsch

Thomas Seufert

Changgyoo Park

Hae Kyung Cho

Yi-Ling Lin

Michael Muehle

Jin Yeon Lee

Hyungyu Shin

Seongyun Ko

Methods and systems for transmitting location updates include determining a deviation distance, based on an extrapolated travel direction and an actual travel direction from a last updated location. It is determined that the deviation distance exceeds a deviation threshold. A location update is transmitted to a tracking server, responsive to the determination that the deviation distance exceeds the deviation threshold.

Bandwith-efficient location tracking

Bandwidth efficient location tracking

Disclosed herein are system, method, and computer program product embodiments for efficiently providing transaction-consistent snapshots of data stored in or associated with a database stored within a database management system. An embodiment operates by receiving, at a source database, an update request to update a table at the source database and transmitting a message to a cache node to invalidate a copy of a table time stamp associated with the table, where the copy of the table time stamp is stored at the cache node. The embodiment continues by updating the table at the source database based on the update request.

Transactional cache invalidation for inter-node caching

Disclosed herein are systems, methods, and computer program products for providing transaction-consistent snapshots of data stored in or associated with a database. An embodiment operates by receiving, at a source database, an update request to update data associated with a table stored at the source database, and modifying a value of a modification-in-progress data structure corresponding to the table to indicate that a modification is in progress for the table. The embodiment includes updating a value of a commit identification counter and a table time stamp associated with the table to indicate that cached data having a time stamp older than the updated time stamp are invalid. The embodiment further includes modifying the value of the modification-in-progress counter to indicate completion of table modification.

Atomic visibility switch for transactional cache invalidation

Technologies for performing garbage collection in database systems, such as multi-version concurrency control (MVCC) database systems, are described. For example, different garbage collection techniques can be used separately or in various combinations, including interval garbage collection, group garbage collection, table garbage collection, and combinations. For example, a particular type of combination, called hybrid garbage collection, uses technique from interval garbage collection and group garbage collection, or from interval, group, and table garbage collection.

Hybrid garbage collection for multi-version concurrency control in database systems

A method for processing user location information based on non-periodic update includes at least: requesting installation of a location processing agent controlling a location measurement sensor from the at least one location information providing terminal; receiving a request for approval of at least one location information providing terminal from a location information requesting terminal and providing a link message accepting the approval request of the at least one location information providing terminal; if a request for location of a specific location information providing terminal is received from the location information requesting terminal, requesting the corresponding location information from the corresponding location processing agent; and if the location measurement sensor is successfully controlled by the corresponding location processing agent, receiving location information of the specific location information providing terminal from the corresponding location processing agent.

Method of processing user location information based on non-periodic update

Systems, methods and computer program product embodiments for providing a locking protocol for partitioned and distributed database tables are disclosed herein. A locking method includes executing, by at least one processor, a first database transaction on a second node, attempting to acquire and acquiring a lock on the second node in intentional exclusive mode, executing, by the at least one processor, a second database transaction on a first node, acquiring a lock on the first node in exclusive mode and waiting to acquire a lock on the second node in exclusive mode, routing, by the at least one processor, the first database transaction to the first node and unsuccessfully trying to acquire a lock on the first node and committing, by the at least one processor, the first database transaction.

Locking protocol for partitioned and distributed tables

Systems, methods and computer program product embodiments for providing version garbage collection using snapshot lists are disclosed herein. Version garbage collection using snapshot lists includes storing, by at least one processor, versions of a record in a database table, the record comprising a record value and a version timestamp, storing, by the at least one processor, active snapshots in two levels of active snapshot lists, an active snapshot comprising a transaction identifier and a snapshot timestamp, determining, by the at least one processor, a minimum active snapshot from the active snapshots in the two levels of active snapshot lists and deleting, by the at least one processor, versions of the record having a version timestamp earlier than a snapshot timestamp of the minimum active snapshot.

Growing community of inventors

Seoul, South Korea

Yongjae Chuh