Nuodb, Inc.

Oracle International Corporation

Dassault Systemes

Sreenath Bodagala

Paul D Smith

Ross R Shaull

Benoit Dageville

Mohamed Ziauddin

Mark Charles Ramacher

Alex Tsukerman

Stephen John Vivian

Ross Shaull

Methods and systems to detect and resolve failure in a distributed database system is described herein. A first node in the distributed database system can detect an interruption in communication with at least one other node in the distributed database system. This indicates a network failure. In response to detection of this failure, the first node starts a failure resolution protocol. This invokes coordinated broadcasts of respective lists of suspicious nodes among neighbor nodes. Each node compares its own list of suspicious nodes with its neighbors' lists of suspicious nodes to determine which nodes are still directly connected to each other. Each node determines the largest group of these directly connected nodes and whether or not it is in that group. If a node isn't in that group, it fails itself to resolve the network failure.

Node failure detection and resolution in distributed databases

A computer readable medium storing a database query language statement tuning base in a tuning base memory location is disclosed. The tuning base includes tuning information for one or more query language statements. The tuning information for each statement includes one or more tuning actions for the statement, and a signature to allow an optimizer to identify the one or more tuning actions for the statement.

SQL tuning base

Growing community of inventors

Nashua, NH, United States of America

Sreenath Bodagala