Visa U.s.a. Inc.

Paypal, Inc.

Kamlakar K Singh

Mark Andrew Carlson

Sara Garrison

Thakur L Singh

Shajen Devassey

Kenneth Kang

Yaping Shi

Somenath Das

Petrica Lulian Voicu

Saibabu Devabhaktuni

Rosauro E Manansala

Shuping Tien

Systems and methods for improving database system performance are described. In one embodiment, a database system includes a database application cluster including at least one read-write node and a plurality of read nodes, a shared memory, and a multiplexer coupled to the database application cluster and shared memory. The multiplexer is configured to receive a request from a client computing system which includes a database query. Based on a lookup in the shared memory, the multiplexer determines that the database query can be routed to one of the plurality of read nodes. In response, the database query is routed to one of the read nodes for execution.

Read/write split database query routing

Systems and methods for improving database system performance are described. In one embodiment, a database system includes a master database, a replica database, a shared memory, and a multiplexer coupled to the master database, replica database, and shared memory. The multiplexer is configured to receive a request from a client computing system which includes a database query. Based on a lookup in the shared memory, the multiplexer determines that the database query can be satisfied by the replica database. In response, the database query is routed to the replica database for execution.

Replica database query routing for database environments

A parse/build engine that can handle multi-format financial messages. The engine converts the different format messages into a common format, and the common format message is then processed by the business service application. A parser examines the message and determines an appropriate schema for the particular format of message received. The schema is a data structure in a schema registry that includes a grammar structure for the received format as well as pointers to handlers for converting the different fields of the message into the internal message format using the grammar structure (the 'grammar' can include field sequence, field type, length, character encoding, optional and required fields, etc.). The handlers are individually compiled. As formats change, new formats or changes to old formats can be dynamically added to the parse/build engine by loading new schema and handlers.

Schema-based dynamic parse/build engine for parsing multi-format messages

Application level switching of transactions at a gateway is provided. The gateway is configured to switch the transaction based on the application level content, a current state of a transport environment, and/or dynamic rules for switching transactions. For example, several possible service providers can be selected for the type of transaction, and the gateway can monitor not only the round-trip time through the network(s) to different possible service providers, but also the time required to complete the transaction at the application level and return a response. The application is chosen on the sending side of the network, and application level formatting is done on the sending side as well. The gateway uses modular code and data, and separate instances of processing code to allow dynamic updating. Rules for application service selection can be selectively uploaded to the gateway from a client. The rules for different available application services can be distributed across different gateways.

Adaptive gateway for switching transactions and data on unreliable networks using context-based rules

Growing community of inventors

Foster City, CA, United States of America

Kamlakar K Singh