US 8,819,068 B1Granted

Automating creation or modification of database objects

AssigneeAmazon Technologies, Inc.

InventorsKorey Allen Knote, Kumar S Gounder, Mark J Golazeski, Deenadayal S Yakkali, Jay Borja, Rakesh Poddar, Suresh Viswanathan

Life of this patent

Estimating the term…

patentgrep

Loading patent…

Abstract

In some implementations, a user interface (UI) module provides a user interface to a user device to enable input of information for creating or modifying a database object, such as a schema object of a schema maintained in one or more separate databases. The UI module may determine validity of the inputs in real time as the user enters the inputs. Further, the UI module may check permissions of the user and/or obtain a manual approval of a request for creating or modifying the database object. The UI module may forward the user inputs with instructions for creating or modifying the database object to one or more databases. Computing devices associated with the databases may create or modify the database object based, at least in part, on the inputs from the user, creation or modification rules, syntax rules and/or a logical database associated with the user.

Claims24

Dependent claims

One or more non-transitory computer-readable media maintaining instructions executable by a processor to perform operations comprising:

accessing one or more first metadata tables associated with a first task, wherein the first task creates or modifies a first schema object in a schema of a user;
generating a first user interface from information obtained from the one or more first metadata tables, wherein the first user interface includes first features associated with the first task;
providing the first user interface to a user device associated with the user;
receiving from the user device at least one input entered into the first user interface for creating or modifying a schema object in the schema of the user;
performing a validation of the at least one user input received from the user device based, at least in part, on additional information included in the one or more first metadata tables;
identifying a plurality of physical databases that maintain the schema of the user;
sending instructions including the at least one input to one or more computing devices associated with individual ones of the plurality of physical databases, the instructions instructing the one or more computing devices to create or modify the first schema object in the schema of the user on the individual ones of the plurality of physical databases according to the first task, wherein creation or modification of the first schema object in the schema of the user is propagated across at least a subset of the plurality of physical databases that maintain the schema of the user in response to the at least one input;
accessing one or more second metadata tables associated with a second task, wherein the second task creates or modifies a second schema object in the schema of the user;
generating a second user interface from information obtained from the one or more second metadata tables, wherein the second user interface includes second features associated with the second task;
and
providing the second user interface to the user device.

8 more elements

A method comprising:

under control of one or more processors specifically configured with executable instructions,
generating a user interface from information obtained from a metadata table associated with a task to create or modify a database object, the user interface including features associated with the task;
receiving, from a user device associated with a user, at least one input entered into the user interface for creating or modifying the database object;
determining, based at least in part on logical database information, a plurality of separate databases that maintain information of the user;
and
sending instructions including the at least one input entered into the user interface to one or more computing devices associated with individual ones of the plurality of separate databases, to create or modify the database object in the plurality of separate databases that maintain the information of the user, wherein creation or modification of the database object based on the input from the user is automatically propagated across at least a subset of the physical databases that maintain information of the user without the user logging into each physical database to which the creation or modification of the database object is propagated.

3 more elements

A system, comprising:

at least one computing device configured to implement one or more services, wherein the one or more services are configured to:
in response to receiving one or more inputs for creating or modifying a schema object of a user from a user interface provided to a user device of the user, checking a validity of the one or more user inputs against creation or modification rules to determine in real time whether the one or more inputs conform to creation or modification rules for creating or modifying the schema object, the creation or modification rules for creating or modifying the schema object being based, at least in part, on a metadata table that includes information to generate the user interface;
determine, from logical database information, a plurality of separate databases on which a schema of the user is maintained;
send the one or more user inputs to respective computing devices associated with each database of the plurality of separate databases to cause creation or modification of the schema object on individual ones of the plurality of separate databases, wherein creation or modification to the schema object is propagated across at least a subset of the separate databases that maintain the schema of the user in response to the one or more inputs;
and
change a parameter of the metadata table to change a feature of the user interface, wherein the feature is configured to receive user input to change or modify the schema object.

3 more elements

Dependencies are inferred from the claim text.