# US 2008/0306883 A1 · Techniques for automatically provisioning a database over a wide area network

> Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt

- Number: US 2008/0306883 A1
- Document ID: US20080306883A1
- Status: Published application
- Kind: A1
- Application number: 09/872,235
- Filed: 2001-05-31
- Published: 2008-12-11
- Earliest claimed: 2000-09-08
- Assignees: Oracle International Corporation
- Inventors: Jean-Louis Baffier; Marc Dangeard; Thierry Gruet; Olaf Ziegler; Dean Tan; Christina Sechrest; Pascal Sero; Kevin Walsh
- Web page: https://patentgrep.com/patent/US20080306883A1

## CPC

- G06F 16/27: Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
- G06F 8/61: Installation
- G06F 11/1446: Point-in-time backing up or restoration of persistent data
- G06F 16/21: Design, administration or maintenance of databases
- G06Q 30/0283: Price estimation or determination
- G06Q 30/04: Billing or invoicing
- H04L 63/02: {for separating internal from external traffic, e.g. firewalls}
- G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N)
- G06Q: INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M)

## Abstract

Techniques for provisioning databases for users on a wide area network include a first party managing one or more database systems. Multiple second parties subscribe to database services supported by the database systems managed by the first party. The first party provides, over a network, to database applications controlled by the second parties, access to the database services to which the second parties are subscribed. The database systems may use database appliances. A database appliance includes a database process and a non-database process that is-tailored to the needs of the database process. The wide area network may be a public network of computer networks, such as the Internet. With the present invention, a user is able to obtain needed database resources from an Internet Database Service Provider (IDSP) with a minimum of user effort and without the user incurring the full costs of one or more database administrators, or the costs of a dedicated database equipment facility, or even the costs of a dedicated database device, depending on usage. At the same time, the IDSP can readily provide for several database users with minimum staffing loads on the IDSP because of self-service tools provided. Furthermore, the IDSP start-up and maintenance efforts are reduced through several tools, such as the costing model and automatic billing features.

## Claims

### Claim 1

A method for provisioning databases for users on a network, the method comprising the steps of:
a first party managing one or more database systems;
a plurality of second parties subscribing to database services supported by the one or more database systems managed by the first party, wherein the database services include services for storing and managing data provided by the second parties; and
wherein the step of subscribing includes performing a registration process during which said second parties identify database resources for which the second parties are willing to pay;
providing, over the network, to database applications owned and controlled by the second parties, access to the database services to which the second parties are subscribed,
wherein the database applications, owned and controlled by the second parties, interact with the database systems managed by the first party by sending, from the second parties, to the database systems, over the network, database commands that conform to the database language supported by the database system;
wherein execution of the database commands allows the second parties to manipulate data objects stored within at least one of the one or more database systems,
wherein the second parties control the source code of the database applications that the second parties use to send database commands to the database management systems managed by the first parties;
delivering to one of said second parties, over the network, one or more messages which cause generation of user interfaces that allow the second party to subscribe to said database services provided by said first party; and
delivering over the network, to a user associated with said one of said second parties, one or more messages which cause generation of user interfaces that allow the user to access a database for a database service to which said one of said second parties has subscribed.

### Claim 2 (depends on 1)

The method of claim 1 wherein:
at least one of said second parties is an application service provider that provides application services to a plurality of third parties over said network; and
the step of providing access to the database services includes providing database services to an application used by said application service provider to provide said application services to said third parties.

### Claim 3 (depends on 1)

The method of claim 1 further comprising the steps of:
receiving over said network a request to perform a database management operation from a user associated with a particular second party of said plurality of second parties; and
responding to said request by performing said database management operation on one or more databases controlled by said first party without human intervention by said first party.

### Claim 4

(canceled)

### Claim 5 (depends on 1)

The method of claim 1 wherein the step of providing access over a network includes providing access over a public network of computer networks

### Claim 6 (depends on 3)

The method of claim 3 wherein the step of performing the database management operation involves allocating a different amount of resources to said particular second party than is currently allocated for said particular second party.

### Claim 7

(canceled)

### Claim 8 (depends on 1)

The method of claim 1 wherein the user interfaces contain controls for specifying user profile information, payment information, and selection of database services.

### Claim 9

(canceled)

### Claim 10 (depends on 1)

The method of claim 1, wherein:
the first party also provides database application services over said network; and
the method further comprises the step of delivering over the network, to a user associated with one of said second parties, one or more messages which cause generation of user interfaces that allow the user to access a database application service to which said one of said second parties has subscribed.

### Claim 11 (depends on 1)

The method of claim 1, further comprising the step of delivering over the network, to a user associated with one of said second parties, one or more messages which cause generation of user interfaces that allow the user to indicate changes to at least one of profile information, payment information, and the selection of services to which said one of said second parties is subscribed.

### Claim 12 (depends on 1)

The method of claim 1, further comprising the step of delivering over the network, to a user associated with one of said second parties, one or more messages which cause generation of user interfaces that allow the user to supply content for a subscribed database.

### Claim 13 (depends on 1)

The method of claim 1, further comprising the step of delivering over the network, to a user associated with one of said second parties, one or more messages which cause generation of user interfaces that allow the user to develop a new database application.

### Claim 14 (depends on 1)

The method of claim 1, further comprising the step of delivering over the network, to a user associated with one of said second parties, one or more messages which cause generation of user interfaces that allow the user to integrate an external service.

### Claim 15 (depends on 1)

The method of claim 1, further comprising the step of delivering over the network, to a user associated with one of said second parties, one or more messages which cause generation of user interfaces that present a status of a user subscribed resource selected from database resources managed by said first party.

### Claim 16 (depends on 1)

The method of claim 1, further comprising the steps of:
delivering over the network, to a user associated with one of said second parties, one or more messages which cause generation of user interfaces that present the user with a user-selectable representation of a web site building wizard for building a Web page with a database component associated with an interface to a database;
receiving user input indicating the web site building wizard; and
executing said web site building wizard, including presenting a series of screens to the user to prompt user input for building the Web page.

### Claim 17 (depends on 1)

The method of claim 1, further comprising the step of the first party updating the one or more database systems by receiving from a community server over the network an update to the one or more database systems, wherein the community server provides the update to a plurality of service providers over said network.

### Claim 18 (depends on 1)

The method of claim 1, further comprising the step of the first party sending to a community server a status of a user subscribed resource, wherein the user subscribed resource is maintained by said first party.

### Claim 19 (depends on 1)

The method of claim 1, further comprising presenting to a user associated with said first party a user interface to allow said first party to configure a database device used to provide said database services as one of a dedicated device and a plurality of virtual devices.

### Claim 20 (depends on 1)

The method of claim 1, further comprising presenting to a user associated with said first party a user interface to allow said first party to configure at least one of a dedicated device and a virtual device of a plurality of virtual devices as one of a staging device available only to a database service developer for developing database services, and a production device for making database services available to a user who is not the database service developer.

### Claim 21 (depends on 20)

The method of claim 20, further comprising presenting a user interface for transferring an application from a staging device to a production device.

### Claim 22 (depends on 1)

The method of claim 1 wherein:
the step of delivering to one of said second parties over the network one or more messages which cause generation of user interfaces that allow the party to subscribe to said database services is performed as part of a registration process;
the interfaces include controls for receiving a user input value for a maximum amount of subscribed resources; and
the method further includes the step of presenting an alert if an amount of subscribed resources consumed by said party exceeds a threshold percentage of the maximum amount of subscribed resources.

### Claim 23 (depends on 22)

The method of claim 22, further comprising the steps of:
receiving a user input value for a particular threshold percentage; and
presenting an alert if an amount of resources consumed by said party exceeds the particular threshold percentage of the maximum amount of subscribed resources.

### Claim 24 (depends on 22)

The method of claim 22, wherein the maximum amount of subscribed resources includes a maximum amount of at least one of
an amount of storage space,
a number of users connected to a platform in a period of time,
an amount of processor time used in a period of time, and
a number of transactions completed in a period of time.

### Claim 25 (depends on 12)

The method of claim 12, further comprising the steps of:
presenting to the user a set of selectable sources of content;
receiving user input indicating a selected source; and
launching a source update process to connect to the selected source and update a database with information received from the selected sources.

### Claim 26 (depends on 25)

The method of claim 25, wherein
the user input indicating a selected source also indicates a schedule for updating from the selected source; and
the source update process connects to the selected source according to the schedule for updating from the selected source.

### Claim 27 (depends on 12)

The method of claim 12, further comprising the steps of:
in response to user input that specifies that data should be loaded into a subscribed database, determining whether the subscribed database currently exists for said one of said second parties; and
creating the subscribed database if the subscribed database does not currently exist for said one of said second parties.

### Claim 28 (depends on 13)

The method of claim 13, further comprising the steps of:
presenting representations of selectable application development kits;
receiving user input indicating a selected development kit from the user; and
launching a staging process including
configuring consumable database resources on a staging database device, wherein a staging database device can be accessed by the user for developing the new database application and cannot be accessed by users associated with other parties of said plurality of second parties,
receiving development input from the user; and
building a new application on the staging database device based on the selected development kit and the development input.

### Claim 29 (depends on 28)

The method of claim 28, the step of developing the new database application further comprising the steps of
after receiving user input indicating a selected development kit, determining whether a client process of the selected development kit must be downloaded to a computer of the user over the wide area network; and
if it is determined the client process of the selected development kit must be downloaded, downloading the client process to the computer of the user over the wide area network before the step of building the new application.

### Claim 30 (depends on 28)

The method of claim 28, the step of developing a new database application further comprising the steps of:
receiving input from the user indicating the new application is ready for operational use; and
in response to receiving input from the user indicating the new application is ready for operational use, launching a production transfer process including sending a request to the first party to transfer the new application to a production device on which the new application may be accessed by users who did not develop the new application.

### Claim 31 (depends on 14)

The method of claim 14, further comprising integrating the external service, wherein the step of integrating comprises the steps of:
presenting a representation of a selectable external service;
receiving user input indicating a selected external service; and
launching an integration process to provide the external service to the user.

### Claim 32 (depends on 31)

The method of claim 31, wherein the selectable external service includes at least one of a payment service, a mobile Internet portal, an enterprise resource planning application, and a customer relationship management application.

### Claim 33 (depends on 1)

The method of claim 1, further comprising the first party performing at least one of the steps of:
setting up database parameters;
reporting database usage;
backing up the database;
upgrading the database;
controlling database versions;
implementing database security; and
implementing data security within the database.

### Claim 34 (depends on 1)

The method of claim 1, further comprising the steps of:
if a costing database does not already exist, then
automatically creating the costing database of database resource usage by user, and
initiating a costing model with price per unit of consumable resource per service;
inserting data into the costing database based on actual use of database resources by the user;
executing the costing model to compute a cost-per-user based on the data in the costing database and the price per unit of consumable resource per service; and
billing the user for the cost computed by the costing model.

### Claim 35 (depends on 34)

The method of claim 34, wherein the costing model supports:
fixed price per unit of usage;
variable price per unit usage as a function of usage;
flat price up to a maximum value of usage;
different prices for different users;
different prices for different services; and
different prices for increments of usage above a maximum subscribed usage.

### Claim 36

A computer-readable medium carrying instructions for provisioning databases for users on a network, the instructions comprising instructions for performing the steps of:
a first party managing one or more database systems;
a plurality of second parties subscribing to database services supported by the one or more database systems managed by the first party, wherein the database services include services for storing and managing data provided by the second parties; and
wherein the step of subscribing includes performing a registration process during which said second parties identify database resources for which the second parties are willing to pay;
providing, over the network, to database applications owned and controlled by the second parties, access to the database services to which the second parties are subscribed,
wherein the database applications, owned and controlled by the second parties, interact with the database systems managed by the first party by sending, from the second parties, to the database systems, over the network, database commands that conform to the database language supported by the database system;
wherein execution of the database commands allows the second parties to manipulate data objects stored within at least one of the one or more database systems,
wherein the second parties control the source code of the database applications that the second parties use to send database commands to the database management systems managed by the first parties;
delivering to one of said second parties, over the network, one or more messages which cause generation of user interfaces that allow the second party to subscribe to said database services provided by said first party; and
delivering over the network, to a user associated with said one of said second parties, one or more messages which cause generation of user interfaces that allow the user to access a database for a database service to which said one of said second parties has subscribed.

### Claim 37 (depends on 36)

The computer-readable medium of claim 36 wherein:
at least one of said second parties is an application service provider that provides application services to a plurality of third parties over said network; and
the step of providing access to the database services includes providing database services to an application used by said application service provider to provide said application services to said third parties.

### Claim 38 (depends on 36)

The computer-readable medium of claim 36 further comprising instructions for performing the steps of:
receiving over said network a request to perform a database management operation from a user associated with a particular second party of said plurality of second parties; and
responding to said request by performing said database management operation on one or more databases controlled by said first party without human intervention by said first party.

### Claim 39

(canceled)

### Claim 40 (depends on 36)

The computer-readable medium of claim 36 wherein the step of providing access over a network includes providing access over a public network of computer networks.

### Claim 41 (depends on 38)

The computer-readable medium of claim 38 wherein the step of performing the database management operation involves allocating a different amount of resources to said particular second party than is currently allocated for said particular second party.

### Claim 42

(canceled)

### Claim 43 (depends on 36)

The computer-readable medium of claim 36 wherein the user interfaces contain controls for specifying user profile information, payment information, and selection of database services.

### Claim 44

(canceled)

### Claim 45 (depends on 36)

The computer-readable medium of claim 36, wherein:
the first party also provides database application services over said network; and
the computer-readable medium further comprises instructions for performing the step of delivering over the network, to a user associated with one of said second parties, one or more messages which cause generation of user interfaces that allow the user to access a database application service to which said one of said second parties has subscribed.

### Claim 46 (depends on 36)

The computer-readable medium of claim 36, further comprising instructions for performing the step of delivering over the network, to a user associated with one of said second parties, one or more messages which cause generation of user interfaces that allow the user to indicate changes to at least one of profile information, payment information, and the selection of services to which said one of said second parties is subscribed.

### Claim 47 (depends on 36)

The computer-readable medium of claim 36, further comprising instructions for performing the step of delivering over the network, to a user associated with one of said second parties, one or more messages which cause generation of user interfaces that allow the user to supply content for a subscribed database.

### Claim 48 (depends on 36)

The computer-readable medium of claim 36, further comprising instructions for performing the step of delivering over the network, to a user associated with one of said second parties, one or more messages which cause generation of user interfaces that allow the user to develop a new database application.

### Claim 49 (depends on 36)

The computer-readable medium of claim 36, further comprising instructions for performing the step of delivering over the network, to a user associated with one of said second parties, one or more messages which cause generation of user interfaces that allow the user to integrate an external service.

### Claim 50 (depends on 36)

The computer-readable medium of claim 36, further comprising instructions for performing the step of delivering over the network, to a user associated with one of said second parties, one or more messages which cause generation of user interfaces that present a status of a user subscribed resource selected from database resources managed by said first party.

### Claim 51 (depends on 36)

The computer-readable medium of claim 36, further comprising instructions for performing the steps of:
delivering over the network, to a user associated with one of said second parties, one or more messages which cause generation of user interfaces that present the user with a user-selectable representation of a web site building wizard for building a Web page with a database component associated with an interface to a database;
receiving user input indicating the web site building wizard; and
executing said web site building wizard, including presenting a series of screens to the user to prompt user input for building the Web page.

### Claim 52 (depends on 36)

The computer-readable medium of claim 36, further comprising instructions for performing the step of the first party updating the one or more database systems by receiving from a community server over the network an update to the one or more database systems, wherein the community server provides the update to a plurality of service providers over said network.

### Claim 53 (depends on 36)

The computer-readable medium of claim 36, further comprising instructions for performing the step of the first party sending to a community server a status of a user subscribed resource, wherein the user subscribed resource is maintained by said first party.

### Claim 54 (depends on 36)

The computer-readable medium of claim 36, further comprising instructions for presenting to a user associated with said first party a user interface to allow said first party to configure a database device used to provide said database services as one of a dedicated device and a plurality of virtual devices.

### Claim 55 (depends on 36)

The computer-readable medium of claim 36, further comprising instructions for presenting to a user associated with said first party a user interface to allow said first party to configure at least one of a dedicated device and a virtual device of a plurality of virtual devices as one of a staging device available only to a database service developer for developing database services, and a production device for making database services available to a user who is not the database service developer.

### Claim 56 (depends on 55)

The computer-readable medium of claim 55, further comprising instructions for presenting a user interface for transferring an application from a staging device to a production device.

### Claim 57 (depends on 36)

The computer-readable medium of claim 36 wherein:
the step of delivering to one of said second parties over the network one or more messages which cause generation of user interfaces that allow the party to subscribe to said database services is performed as part of a registration process;
the interfaces include controls for receiving a user input value for a maximum amount of subscribed resources; and
the computer-readable medium further includes instructions for the step of presenting an alert if an amount of subscribed resources consumed by said party exceeds a threshold percentage of the maximum amount of subscribed resources.

### Claim 58 (depends on 57)

The computer-readable medium of claim 57, further comprising instructions for performing the steps of:
receiving a user input value for a particular threshold percentage; and
presenting an alert if an amount of resources consumed by said party exceeds the particular threshold percentage of the maximum amount of subscribed resources.

### Claim 59 (depends on 57)

The computer-readable medium of claim 57, wherein the maximum amount of subscribed resources includes a maximum amount of at least one of
an amount of storage space,
a number of users connected to a platform in a period of time,
an amount of processor time used in a period of time, and
a number of transactions completed in a period of time.

### Claim 60 (depends on 47)

The computer-readable medium of claim 47, further comprising instructions for performing the steps of:
presenting to the user a set of selectable sources of content;
receiving user input indicating a selected source; and
launching a source update process to connect to the selected source and update a database with information received from the selected sources.

### Claim 61 (depends on 60)

The computer-readable medium of claim 60, wherein
the user input indicating a selected source also indicates a schedule for updating from the selected source; and
the source update process connects to the selected source according to the schedule for updating from the selected source.

### Claim 62 (depends on 47)

The computer-readable medium of claim 47, further comprising instructions for performing the steps of:
in response to user input that specifies that data should be loaded into a subscribed database, determining whether the subscribed database currently exists for said one of said second parties; and
creating the subscribed database if the subscribed database does not currently exist for said one of said second parties.

### Claim 63 (depends on 48)

The computer-readable medium of claim 48, further comprising instructions for performing the steps of:
presenting representations of selectable application development kits;
receiving user input indicating a selected development kit from the user; and
launching a staging process including
configuring consumable database resources on a staging database device, wherein a staging database device can be accessed by the user for developing the new database application and cannot be accessed by users associated with other parties of said plurality of second parties,
receiving development input from the user; and
building a new application on the staging database device based on the selected development kit and the development input.

### Claim 64 (depends on 63)

The computer-readable medium of claim 63, the step of developing the new database application further comprising the steps of
after receiving user input indicating a selected development kit, determining whether a client process of the selected development kit must be downloaded to a computer of the user over the wide area network; and
if it is determined the client process of the selected development kit must be downloaded, downloading the client process to the computer of the user over the wide area network before the step of building the new application.

### Claim 65 (depends on 63)

The computer-readable medium of claim 63, the step of developing a new database application further comprising the steps of:
receiving input from the user indicating the new application is ready for operational use; and
in response to receiving input from the user indicating the new application is ready for operational use, launching a production transfer process including sending a request to the first party to transfer the new application to a production device on which the new application may be accessed by users who did not develop the new application.

### Claim 66 (depends on 49)

The computer-readable medium of claim 49, further comprising instructions for integrating the external service, wherein the step of integrating comprises the steps of:
presenting a representation of a selectable external service;
receiving user input indicating a selected external service; and
launching an integration process to provide the external service to the user.

### Claim 67 (depends on 66)

The computer-readable medium of claim 66, wherein the selectable external service includes at least one of a payment service, a mobile Internet portal, an enterprise resource planning application, and a customer relationship management application.

### Claim 68 (depends on 36)

The computer-readable medium of claim 36, further comprising instructions for the first party performing at least one of the steps of:
setting up database parameters;
reporting database usage;
backing up the database;
upgrading the database;
controlling database versions;
implementing database security; and
implementing data security within the database.

### Claim 69 (depends on 36)

The computer-readable medium of claim 36, further comprising instructions for performing the steps of:
if a costing database does not already exist, then
automatically creating the costing database of database resource usage by user, and
initiating a costing model with price per unit of consumable resource per service;
inserting data into the costing database based on actual use of database resources by the user;
executing the costing model to compute a cost-per-user based on the data in the costing database and the price per unit of consumable resource per service; and
billing the user for the cost computed by the costing model.

### Claim 70 (depends on 69)

The computer-readable medium of claim 69, wherein the costing model supports:
fixed price per unit of usage;
variable price per unit usage as a function of usage;
flat price up to a maximum value of usage;
different prices for different users;
different prices for different services; and
different prices for increments of usage above a maximum subscribed usage.

### Claim 71

A method, comprising:
an internet database service provider (IDSP) party managing one or more database systems;
a plurality of second parties subscribing to database services supported by the one or more database systems managed by the IDSP, wherein the database services include services for storing and managing data provided by the second parties; and
wherein the step of subscribing includes performing a registration process during which said second parties identify database resources for which the second parties are willing to pay;
providing, over the network, to database applications owned and controlled by the second parties, access to the database services to which the second parties are subscribed,
wherein the database applications, owned and controlled by the second parties, interact with the database systems managed by the IDSP by sending, from the second parties, to the database systems, over the network, database commands that conform to the database language supported by the database system;
wherein execution of the database commands allows the second parties to manipulate data objects stored within at least one of the one or more database systems,
wherein the second parties control the source code of the database applications that the second parties use to send database commands to the database management systems managed by the IDSP;
delivering to one of said second parties, over the network, one or more messages which cause generation of user interfaces that allow the second party to subscribe to said database services provided by the IDSP; and
delivering over the network, to a user associated with said one of said second parties, one or more messages which cause generation of user interfaces that allow the user to access a database for a database service to which said one of said second parties has subscribed.

### Claim 72 (depends on 71)

The method of claim 71, wherein one of the plurality of second parties is an Internet Service Provider (ISP).

### Claim 73 (depends on 71)

The method of claim 71, wherein one of the plurality of second parties is an Application Service Provider (ASP).
