Database fleet schema maintenance
AssigneeAmazon Technologies, Inc.
InventorsCarl Bellingan, Matthew James Eddey
Life of this patent
Estimating the term…
Abstract
A fleet of databases may comprise subsets of databases sharing a common schema for replication, horizontal partitioning and other applications. Events related to potential deviations from a desired schema may be monitored. Automated means may be employed to detect variations from a desired schema. An intermediate representation of database schema may be formed and used to compare database schemas. Subclasses and allowed versions of desired schemas may be defined. Security attributes related to schema inspection and modification may be mapped to enable selected operations on schema.
Claims20
A system, comprising:
- a memory to store machine-readable instructions, which as a result of being performed by a processor, cause the system at least to:
- monitor a first database for at least one event indicative of a discrepancy between a first schema and a second schema, the first schema indicative of one or more database objects in the first database, the second schema indicative of one or more second database objects in a second database;
- compare, in response to the at least one event, a first intermediate representation of the first schema and a second intermediate representation of the second schema, wherein the first intermediate representation comprises a columnar representation of the one or more database objects in the first database;
- identify, based on the comparison, the discrepancy between the first and second schemas;
- and
- send a notification of the discrepancy.
A method, comprising:
- monitoring a first database for at least one event indicative of a discrepancy between a first schema and a second schema, the first schema indicative of one or more database objects in the first database, the second schema indicative of one or more second database objects in a second database;
- comparing, in response to the at least one event, a first intermediate representation associated with the first schema and a second intermediate representation associated with the second schema, wherein the first intermediate representation comprises a columnar representation of the one or more database objects in the first database;
- identifying, based on the comparison, the discrepancy between the first and second schemas;
- and
- sending a notification of the discrepancy.
A non-transitory storage medium having stored thereon machine-readable instructions that, when performed by a computing device, cause the computing device to at least:
- track a first database for an event indicative of a discrepancy between a first schema and a second schema, the first schema indicative of one or more database objects in the first database, the second schema indicative of one or more second database objects in a second database;
- compare, in response to the event, a first intermediate representation of the first schema and a second intermediate representation of the second schema, wherein the first intermediate representation comprises a columnar representation of the one or more database objects in the first database;
- identify, based on the comparison, the discrepancy between the first and second schemas;
- and
- generate a notification of the discrepancy.
Dependencies are inferred from the claim text.