Techniques for automatically provisioning a database over a wide area network

• US 8,316,044 B2
• Filed: 12/28/2011
• Issued: 11/20/2012
• Est. Priority Date: 09/08/2000
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Baffier, Jean-Louis, Dangeard, Marc, Gruet, Thierry, Ziegler, Olaf, Tan, Dean, Sechrest, Christina, Sero, Pascal, Walsh, Kevin
• Primary Examiner(s): Casanova, Jorge A
• Application Number:
  US13/339,193
• Publication Number:
  US 20120101994A1
• Time in Patent Office: 328 Days
• Field of Search: 707/769, 707/802, 707/812, 709217-224
• US Class Current: 707/769
• CPC Class Codes: G06F 11/1446 Point-in-time backing up or restoration of persistent data
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 8/61 Installation
• CPC Class Codes: G06Q 30/0283 Price estimation or determination
• CPC Class Codes: G06Q 30/04 Billing or invoicing
• CPC Class Codes: H04L 63/02 for separating internal from external traffic, e.g. firewalls

Abstract

Techniques for provisioning databases for users on a wide area network such as the Internet include a first party managing one or more database systems. Second parties subscribe to database services supported by the managed database systems. The first party provides, over a network, to database applications of the second parties, access to database services to which the second parties are subscribed. The database systems may use database appliances hosting both database process(es), and non-database process(es) tailored to the needs of the database process(es). A user is therefore able to obtain database resources from an Internet Database Service Provider (IDSP) without incurring the full costs of database administrator(s), dedicated database equipment facilit(ies), or even dedicated database device(s), depending on usage. Meanwhile, the IDSP incurs minimum staffing loads because of self-service tools. Costing model and automatic billing are also described.

Claims

1. A method comprising:

a first party managing one or more database systems comprising one or more database servers and one or more database storage devices;

based on information describing a subscription of a second party to one or more database services supported by the one or more database systems managed by the first party, the first party configuring the one or more database systems by at least allocating one or more database resources of the one or more database systems for use by the second party;

wherein the second party is different than the first party;

wherein the database services include services for storing and managing data provided by the second party in one or more tables on the one or more database storage devices;

one or more computing devices of the first party responding to requests, from one or more database applications of the second party, to access the one or more database services to which the second party is subscribed using the allocated one or more database resources, wherein responding to the requests comprises a database server of the one or more database systems executing a database query received over a network to retrieve at least a portion of the data provided by the second party from a table stored in the one or more database storage devices;

wherein at least the responding is performed by the one or more computing devices.

2. The method of claim 1, further comprising, at the database server, receiving the database query from the one or more database applications.

3. The method of claim 1, further comprising, at the database server, receiving the database query from the one or more database applications over a wide-area network.

4. The method of claim 1, wherein the one or more database applications are software applications that are one or both of:

provided by one or more vendors, other than the first party;

or developed by the second party.

5. The method of claim 1, further comprising the first party providing the second party with access to a development kit server for developing the one or more database applications.

6. The method of claim 1, wherein the one or more database applications are software applications having database components that rely upon information, stored in one or more databases of the one or more database resources, that is updated over time and that changes among users of the one or more database applications.

7. The method of claim 1, wherein the one or more database applications include one or more of:

database development applications, sales database applications, invoice database applications, inventory database application, personnel database applications, or document database applications.

8. The method of claim 1, further comprising the first party providing to the second party one or more predefined web site database components for use by the one or more database applications.

9. The method of claim 1, further comprising the first party providing to the one or more database applications of the second party one or more of:

components for searching for products described by data in the table, components for searching for personnel listed in the table, or components for implementing a shopping cart based on information in the table.

10. The method of claim 1, wherein allocating the one or more database resources comprises creating a database for storing at least the table.

11. The method of claim 1, wherein the subscription information includes specification information for the one or more database applications, wherein allocating the one or more database resources comprises, in response to the specification information, the one or more computing devices:

installing, creating, and/or configuring the one or more database applications in accordance with the specification information; and

creating a database for the one or more database applications.

12. The method of claim 1, further comprising:

the one or more computing devices installing the one or more database applications at appliances hosted by the first party;

the one or more computing devices monitoring for updates, from one or more vendors, to the one or more database applications;

the one or more computing devices installing the updates at the appliances hosted by the first party.

13. The method of claim 12, wherein the updates are installed to a staging appliance prior to being rolled out to a production appliance.

14. The method of claim 1, wherein the subscription information indicates an amount of storage space to allocate to the user, wherein allocating the one or more database resources comprises reserving storage space of the amount for storage of the data provided by the second party, wherein the method further comprises creating and storing the table in the reserved storage space.

15. The method of claim 1, further comprising:

a web server hosted by the first party presenting one or more registration web pages to the second party;

the web server receiving the subscription information via input provided by the second party using the one or more forms in the registration web pages;

the one or more computing devices automatically allocating the one or more database resources, without human intervention, in response to the receiving the subscription information.

16. The method of claim 1, wherein managing the one or more database systems further comprises the first party automatically creating a backup of the table and restoring the backup upon failure of a database appliance at which the table is stored.

17. The method of claim 1, further comprising the first party receiving from the second party a specification of a source of database content and, in response, the first party periodically importing data from the source into at least the table.

18. The method of claim 1, wherein the second party is one of a plurality of subscribers to the database services supported by a specific database system of the one or more database systems, the method further comprising enforcing security policies on the table to secure the table from other subscribers in the plurality of subscribers.

19. The method of claim 1, wherein the second party is one of a plurality of subscribers to the database services supported by the one or more database systems managed by the first party, the method further comprising:

maintaining, at a management server, subscription information for each of the plurality of subscribers;

the management server discovering new database devices that have been added to the one or more database systems;

the management server reallocating database resources to utilize the new database devices in response to one or both of;

updated subscription information or failure of a database device.

20. The method of claim 1, wherein the one or more database applications of the second party are controlled by and licensed to the second party.

21. The method of claim 1, wherein the second party is an Application Service Provider that provides, through the one or more database applications, web-based services to third-parties.

22. The method of claim 1,

wherein the database services comprise database applications of the first party;

wherein responding to the requests comprises;

database applications of the first party, executing at the one or more computing devices, receiving the requests from the database applications of the second party;

the database applications of the first party sending the database query to the database server.

23. A method comprising:

at a management server hosted by a first party, managing one or more database systems comprising one or more database servers and one or more database storage devices storing data on behalf of a plurality of subscribers, wherein the one or more database servers are executed by computing devices of the first party;

receiving, at a web server, information describing a subscription of a second party to one or more database services supported by the one or more database systems;

based on the information describing the subscription of the second party to the one or more database services supported by the one or more database systems managed by the first party, triggering automatic performance of configuring the one or more database systems, the configuring comprising at least allocating one or more database resources of the one or more database systems for use by the second party;

wherein the second party is different than the first party;

wherein the database services include services for storing and managing data provided by the second party in one or more tables on the one or more database storage devices;

receiving, at a database server of the one or more database systems, one or more commands from the second party to insert data into at least a table of the one or more tables stored in the one or more database storage devices;

one or more computing devices of the first party responding to requests, from one or more database applications of the second party, to access the one or more database services to which the second party is subscribed using the allocated one or more database resources, wherein responding to the requests comprises the database server of the one or more database systems executing a database request, received from the one or more database applications, to retrieve at least a portion of the data provided by the second party from the table stored in the one or more database storage devices;

wherein the method is performed by the computing devices.

24. The method of claim 23, wherein the computing devices of the first party are coupled together by a network hosted by the first party, the method further comprising a first computing device of the computing devices hosted by the first party receiving the one or more commands to insert data and the database request to retrieve at least the portion of the data over a wide-area network that is different from the network hosted by the first party.

25. The method of claim 24, wherein the database request conforms to Structured Query Language (“

SQL”

) or PL/SQL.

26. A system comprising:

a plurality of interconnected computing devices managed by a first party;

one or more database storage devices storing data on behalf of a plurality of subscribers;

one or more database systems implemented by the plurality of computing devices, the one or more database systems including one or more database servers and the one or more database storage devices;

a management server, executing at least a first computing device of the plurality of computing devices, configured to perform management tasks with respect to the one or more database systems;

wherein the plurality of computing devices are further configured to execute database services, supported by the one or more database servers, that include services for storing and managing data provided by the subscribers in one or more tables on the one or more database storage devices; and

a web server, executing at least a second computing device of the plurality of computing devices, configured to;

receive information describing a subscription of a second party, different than the first party, to the one or more database services; and

based on the information describing the subscription of the second party to the one or more database services, trigger performance of reconfiguring the one or more database systems, the reconfiguring comprising at least allocating one or more database resources of the one or more database systems for use by the second party;

wherein the one or more database servers are configured to receive one or more commands from the second party to insert data into at least a first table of the one or more tables stored in the one or more database storage devices;

wherein the one or more computing devices are configured to respond to requests, from one or more database applications of the second party, to access the one or more database services to which the second party is subscribed using the allocated one or more database resources, wherein responding to the requests comprises the database server of the one or more database systems executing a database query, received by the database server from the one or more database applications of the second party, to retrieve at least a portion of the data provided by the second party from the first table.

27. The system of claim 26, further comprising:

a backup server, executing at least a third computing device of the plurality of computing devices, configured to perform automated backup and restoration tasks for the one or more database systems.

28. The system of claim 26, further comprising:

a directory server, executing at least a third computing device of the plurality of computing devices, configured to monitor for new computing devices on the network and inform the management server of the availability of new consumable database resources at the new computing devices.

29. The system of claim 26, further comprising:

one or more application servers, executing at least a third computing device of the plurality of computing devices, configured to host at least one of the database applications of the second party.

30. The system of claim 26, further comprising a firewall through which the database server receives the database query from a database application operating at a computing device outside of the network.

31. The system of claim 26, wherein the management services component is further configured to, as part of the reconfiguring of the one or more database systems, perform the allocation of the one or more database resources of the one or more database systems for use by the second party.

32. The system of claim 26, wherein the database query conforms to Structured Query Language (“

SQL”

) or PL/SQL.

33. One or more non-transitory computer-readable media storing instructions that, when executed by one or more processors, cause:

a first party managing one or more database systems comprising one or more database servers and one or more database storage devices;

based on information describing a subscription of a second party to one or more database services supported by the one or more database systems managed by the first party, the first party configuring the one or more database systems by at least allocating one or more database resources of the one or more database systems for use by the second party;

wherein the second party is different than the first party;

wherein the database services include services for storing and managing data provided by the second party in one or more tables on the one or more database storage devices;

one or more computing devices of the first party responding to requests, from one or more database applications of the second party, to access the one or more database services to which the second party is subscribed using the allocated one or more database resources, wherein responding to the requests comprises a database server of the one or more database systems executing a database query received over a network to retrieve at least a portion of the data provided by the second party from a table stored in the one or more database storage devices.

34. The one or more non-transitory computer-readable media of claim 33, wherein the instructions, when executed by the one or more processors, further cause, at the database server, receiving the database query from the one or more database applications.

35. The one or more non-transitory computer-readable media of claim 33, wherein the instructions, when executed by the one or more processors, further cause, at the database server, receiving the database query from the one or more database applications over a wide-area network.

36. The one or more non-transitory computer-readable media of claim 33, wherein the one or more database applications are software applications that are one or both of:

provided by one or more vendors, other than the first party;

or developed by the second party.

37. The one or more non-transitory computer-readable media of claim 33, wherein the instructions, when executed by the one or more processors, further cause the first party providing the second party with access to a development kit server for developing the one or more database applications.

38. The one or more non-transitory computer-readable media of claim 33, wherein the one or more database applications are software applications having database components that rely upon information, stored in one or more databases of the one or more database resources, that is updated over time and that changes among users of the one or more database applications.

39. The one or more non-transitory computer-readable media of claim 33, wherein the one or more database applications include one or more of:

database development applications, sales database applications, invoice database applications, inventory database application, personnel database applications, or document database applications.

40. The one or more non-transitory computer-readable media of claim 33, wherein the instructions, when executed by the one or more processors, further cause the first party providing to the second party one or more predefined web site database components for use by the one or more database applications.

41. The one or more non-transitory computer-readable media of claim 33, wherein the instructions, when executed by the one or more processors, further cause the first party providing to the one or more database applications of the second party one or more of:

components for searching for products described by data in the table, components for searching for personnel listed in the table, or components for implementing a shopping cart based on information in the table.

42. The one or more non-transitory computer-readable media of claim 33, wherein allocating one or more database resources comprises creating a database for storing at least the table.

43. The one or more non-transitory computer-readable media of claim 33, wherein the subscription information includes specification information for the one or more database applications, wherein allocating the one or more database resources comprises, in response to the specification information, the one or more computing devices:

installing, creating, and/or configuring the one or more database applications in accordance with the specification information; and

creating a database for the one or more database applications.

44. The one or more non-transitory computer-readable media of claim 33, wherein the instructions, when executed by the one or more processors, further cause:

the one or more computing devices installing the one or more database applications at appliances hosted by the first party;

the one or more computing devices monitoring for updates, from one or more vendors, to the one or more database applications;

the one or more computing devices installing the updates at the appliances hosted by the first party.

45. The one or more non-transitory computer-readable media of claim 44, wherein the updates are installed to a staging appliance prior to being rolled out to a production appliance.

46. The one or more non-transitory computer-readable media of claim 33, wherein the subscription information indicates an amount of storage space to allocate to the user, wherein allocating the one or more database resources comprises reserving storage space of the amount for storage of the data provided by the second party, wherein the method further comprises creating and storing the table in the reserved storage space.

47. The one or more non-transitory computer-readable media of claim 33, wherein the instructions, when executed by the one or more processors, further cause:

a web server hosted by the first party presenting one or more registration web pages to the second party;

the web server receiving the subscription information via input provided by the second party using the one or more forms in the registration web pages;

the one or more computing devices automatically allocating the one or more database resources, without human intervention, in response to the receiving the subscription information.

48. The one or more non-transitory computer-readable media of claim 33, wherein managing the one or more database systems further comprising the first party automatically creating a backup of the table and restoring the backup upon failure of a database appliance at which the table is stored.

49. The one or more non-transitory computer-readable media of claim 33, wherein the instructions, when executed by the one or more processors, further cause the first party receiving from the second party a specification of a source of database content and, in response, the first party periodically importing data from the source into at least the table.

50. The one or more non-transitory computer-readable media of claim 33, wherein the second party is one of a plurality of subscribers to the database services supported by a specific database system of the one or more database systems, the method further comprising enforcing security policies on the table to secure the table from other subscribers in the plurality of subscribers.

51. The one or more non-transitory computer-readable media of claim 33, wherein the second party is one of a plurality of subscribers to the database services supported by the one or more database systems managed by the first party, the method further comprising:

maintaining, at a management server, subscription information for each of the plurality of subscribers;

the management server discovering new database devices that have been added to the one or more database systems;

the management server reallocating database resources to utilize the new database devices in response to one or both of;

updated subscription information or failure of a database device.

52. The one or more non-transitory computer-readable media of claim 33, wherein the one or more database applications of the second party are controlled by and licensed to the second party.

53. The one or more non-transitory computer-readable media of claim 33, wherein the second party is an Application Service Provider that provides, through the one or more database applications, web-based services to third-parties.

54. The one or more non-transitory computer-readable media of claim 33,

wherein the database services comprise database applications of the first party;

wherein responding to the requests comprises;

database applications of the first party, executing at the one or more computing devices, receiving the requests from the database applications of the second party;

the database applications of the first party sending the database query to the database server.

55. One or more non-transitory computer-readable media storing instructions that, when executed by one or more processors, cause:

at a management server hosted by a first party, managing one or more database systems comprising one or more database servers and one or more database storage devices storing data on behalf of a plurality of subscribers, wherein the one or more database servers are executed by computing devices of the first party;

receiving, at a web server, information describing a subscription of a second party to one or more database services supported by the one or more database systems;

based on the information describing the subscription of the second party to the one or more database services supported by the one or more database systems managed by the first party, triggering automatic performance of configuring the one or more database systems, the configuring comprising at least allocating one or more database resources of the one or more database systems for use by the second party;

wherein the second party is different than the first party;

wherein the database services include services for storing and managing data provided by the second party in one or more tables on the one or more database storage devices;

receiving, at a database server of the one or more database systems, one or more commands from the second party to insert data into at least a table of the one or more tables stored in the one or more database storage devices;

one or more computing devices of the first party responding to requests, from one or more database applications of the second party, to access the one or more database services to which the second party is subscribed using the allocated one or more database resources, wherein responding to the requests comprises the database server of the one or more database systems executing a database request, received from the one or more database applications, to retrieve at least a portion of the data provided by the second party from the table stored in the one or more database storage devices;

wherein the method is performed by the computing devices.

56. The one or more non-transitory computer-readable media of claim 55, wherein the computing devices of the first party are coupled together by a network hosted by the first party, the method further comprising a first computing device of the computing devices hosted by the first party receiving the one or more commands to insert data and the database request to retrieve at least the portion of the data over a wide-area network that is different from the network hosted by the first party.

57. The one or more non-transitory computer-readable media of claim 56, wherein the database request conforms to Structured Query Language (“

SQL”

) or PL/SQL.