Datometry, Inc.

Pivotal Software, Inc.

Emc Corporation

Microsoft Technology Licensing, LLC

Amazon Technologies, Inc.

Emc IP Holding Company LLC

Microsoft Cororation

Florian Michael Waas

Lyublena Rosenova Antova

Mohamed A Soliman

Michael Alexander Duller

Dmitri Korablev

Sivaramakrishnan Narayanan

Zhongxian Gu

Cesar Alejandro Galindo-Legaria

Michele Gage

Mark Morcos

Konstantinos Krikellas

John Glenn Eshleman

Entong Shen

Tuan Anh Cao

Joy Jie Kent

Milind Madhukar Joshi

Eric N Hanson

Amirhossein Aleyasen

Conor J Cunningham

Michail Petropoulos

Mohamed F Soliman

Brian C Hagenbuch

Amr El-Helw

Goetz Graefe

Venkatesh Raghavan

Alberto Bengoa

Deepak Patel

Jeffrey Ira Cohen

Chad Whipkey

Robbert VanRenesse

Marc Sugiyama

Christopher J Pedrotti

Chris Pedrotti

Milena Bergant

Gavin Sherry

Christian Kleinerman

Carlos Garcia-Alvarado

Gavin John Sherry

Jueigen Thomas

Mohamed Y Soliman

Chad William Whipkey

Some embodiments provide a method for migrating data from a first database to a second database. The data is susceptible to change at the first database before all of the data is migrated to the second database and is available for access through the second database. The method transfers segments of data incrementally from the first database to the second database and generates a first digital signature for each transferred segment. The method identifies a set of transferred segments that have been modified in the first database before the data is available for access through the second database by generating a second digital signature for each transferred segment in the set and comparing the second digital signature for the segments with the first digital signature for the segments. The method transfers the modified segments from the first database to the second database in order to replace the previously transferred segments.

Incremental transfer of database segments

A method for providing database management system support to a source application configured to operate with a source database management system Is provided. The method comprises detecting database management system communications issued by the source application to the source database management system; and responsive to said database management systems communications, impersonating the source database management system to the source application.

Method and system for transparent interoperability between applications and data management systems

Some embodiments provide a method for quantifying the workload placed on a database by an application. The method identifies a first group of database queries that the application directed towards the database. The method produces a second group of queries by removing, from the first group of queries, queries that are duplicates based on the semantic structure of the queries. Based on a set of properties of the second group of queries, the method computes a complexity indicator that represents a complexity expression of the second group of queries.

Quantifying complexity of a database application

Some embodiments provide a method of emulating a presentation of at least one system object of a first database, based on multiple system objects of a second database. From a client, the method receives a first query for the first database requesting a presentation of the system object. From a metadata storage, the method identifies a second query for the second database that references the system objects of the second database, and generates the requested presentation of the system object. The method replies to the client with the generated presentation.

Emulation of database catalog for migration to a different database

A system for controlling access to a downstream database management system (DMS) is provided. The system comprises an interface to maintain client connections with a plurality of upstream clients; a pooling component to establish a dynamic pool, and to selectively route each client connection to a pool; within each pool maintaining a queue comprising client database requests associated with particular client connections; and selectively granting access to the client database requests within each queue to at least one downstream DMS.

Method and system for workload management for data management systems

Some embodiments provide a method for migrating data from a first database to a second database. The method uses a data segmentation process to dynamically determine a set of segmentation criteria for a particular portion of the first database. The method uses the set of segmentation criteria to divide the particular portion of the first database into multiple data segments. The method incrementally transfers the multiple data segments from the first database to the second database.

Database segmentation

Some embodiments provide a method for quantifying complexity of database queries that reference database objects in a database. The method identifies a database query that includes a reference to a set of one or more database objects in the database. The method identifies a set of properties associated with a set of components of the identified query, and computes, from the identified set of properties, a complexity indicator that represents a complexity expression of the database query.

Quantifying complexity of a database query

For multiple queries written for a first database, some embodiments provide a method of processing the queries on a second database. From a client, the method receives individually each of the multiple queries written for the first database. The method performs an automated process to analyze properties of the second database to determine that the multiple queries can be replaced by a single query to the second database. Based on the determination, the method combines the multiple queries to generate a single query for the second database. The method forwards the generated single query to the second database for execution.

Batching database queries for migration to a different database

Some embodiments provide a method for analyzing database queries performed on a database. The method receives log data associated with queries that were performed on the database, wherein the log data includes multiple sub-tables that each include a set of data entries. Based on the log data, the method assembles a set of queries that were performed on the database, where different queries in the set are assembled by combining different subsets of data entries from the sub-tables. The method performs a query interpretation operation on each query to quantify the impact of performing the assembled set of queries on the database.

Analysis of database query logs

Some embodiments provide a method for migrating a set of data objects from a first database of a first database type to a second database of a second database type. The method retrieves a particular set of data from the first database and performs an automated process to analyze the particular set of data in order to select the second database type from multiple other database types. The method presents on a display the selected second database type and a user interface control for migrating the set of data objects stored in the first database to the second database of the second database type. In response to a selection of the user interface control, the method provisions the second database and transfers the set of data objects from the first database to the second database.

One-click database migration with automatic selection of a database

Some embodiments provide an automated method for processing a query. The method receives a query from a client, where the query references an object in a source database, the object having two sets of properties. The method generates a full set of properties by retrieving one set of properties from the target database and retrieving the other set of properties from a metadata storage. Based on the full, combined set of properties, the method generates a new query for execution on the target database.

Static emulation of database queries for migration to a different database

For a query written for a first database, some embodiments provide a method of processing the query on a second database. From a client, the method receives the query written for the first database. The method performs an automated process to analyze properties of the second database to determine that the received query should be replaced by multiple queries to the second database. Based on the determination, the method generates multiple queries for the second database. The method individually forwards each generated query to the second database for execution.

Unbatching database queries for migration to a different database

Some embodiments provide a method for expressing viability of a first database as a candidate for replacing a second database. The method identifies a first group of database queries that a group of applications directed towards the second database. The method produces a second group of queries by removing, from the first group, queries that are duplicates. Based on a set of complexity values associated with a set of components of the second group of queries, the method generates a complexity indicator representing a level of difficulty for rewriting the second group of queries for the second database.

Expressing complexity of migration to a database candidate

Some embodiments provide a method for migrating a set of data objects from a first database of a first database type to a second database of a second database type. The method receives a selection of the second database type and receives a selection of a user interface control for initiating the database migration from the first database of the first database type to the second database of the selected second database type. The method provisions the second database and transfers the set of data objects from the first database to the second database.

One-click database migration to a selected database

Growing community of inventors

San Francisco, CA, United States of America

Florian Michael Waas