The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.

The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.

Patent No.:

US 11797555 B1

Date of Patent:

Oct. 24, 2023

Filed:

Dec. 20, 2021

Method for copying spanner databases from production to test environments

Applicant:

Google Llc, Mountain View, CA (US);

Inventors:

Srinath Badrinath, Bangalore, IN;

Carlos Arguelles, Edmonds, WA (US);

Danhao Guo, San Mateo, CA (US);

Benson Margulies, Seatlle, WA (US);

Assignee:

Google LLC, Mountain View, CA (US);

Attorney:

Lerner David LLP

Primary Examiner:

Alex Gofman

Int. Cl.

CPC ...

G06F 15/16 (2006.01); G06F 16/25 (2019.01); G06F 9/48 (2006.01); G06F 16/21 (2019.01); G06F 16/27 (2019.01);

U.S. Cl.

CPC ...

G06F 16/25 (2019.01); G06F 9/4881 (2013.01); G06F 16/214 (2019.01); G06F 16/27 (2019.01);

Abstract

A method of copying a production database to a test environment using one or more processors. The production database includes a plurality of tables and one or more constraints indicating interleaving of the plurality of tables. The method involves constructing a directed acyclic graph (DAG) of the plurality of tables, whereby each table is represented by a respective node of the DAG and interleaving of the tables is represented by edges of the DAG, topologically ordering the tables according to the DAG, and copying data from the production database to the test environment according to the topological ordering of the tables.

Find Patent Forward Citations