Techniques for automatically provisioning a database over a wide area network

• US 8,478,778 B2
• Filed: 08/10/2012
• Issued: 07/02/2013
• Est. Priority Date: 09/08/2000
• Status: Expired due to Term

• 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/571,528
• Publication Number:
  US 20120303584A1
• Time in Patent Office: 326 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:

receiving, over a wide area network, information describing a subscription to one or more database services supported by one or more database systems, the one or more database systems comprising one or more database servers and one or more database storage devices;

examining the information describing the subscription to identify one or more database resources of the one or more database systems to allocate in accordance with the subscription to the one or more database services;

based on the examining of the information describing the subscription, automatically configuring the one or more database systems by at least allocating the one or more database resources of the one or more database systems in accordance with the subscription;

wherein the one or more database services include one or more services for storing and managing data provided over the wide area network in one or more tables on the one or more database storage devices;

receiving requests over the wide area network, the requests requiring access to the one or more database services associated with the subscription;

responding to the requests 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 to retrieve at least a portion of the data provided over the wide area network from a table stored in the one or more database storage devices;

wherein each step of the method is performed by one or more computing devices.

2. The method of claim 1, further comprising:

monitoring usage of the allocated one or more database resources in association with the subscription;

when usage of the allocated one or more database resources exceeds a threshold, generating a message alerting a subscriber associated with the subscription;

providing a web interface for allowing the subscriber to allocate additional database resources.

3. The method of claim 1, further comprising, at the database server, receiving the database query over the wide area network.

4. The method of claim 1, wherein allocating the one or more database resources comprises reserving a dedicated database appliance in association with the subscription.

5. The method of claim 1, further comprising:

receiving the database query from one or more database applications over the wide area network;

providing, over the wide area network, 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 resources include one or more of:

a database development application, a sales database application, an invoice database application, an inventory database application, an personnel database application, or a document database application.

8. The method of claim 1, further comprising providing, over the wide area network, 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 providing to the one or more database applications, over the wide area network, 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 information describing the subscription includes specification information for 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 set of one or more database applications, wherein the database stores at least some of the data provided over the wide area network, and wherein the one or more database applications access the database via a local area network that is different than the wide area network.

12. The method of claim 1, further comprising:

providing database services using at least a first server application installed at a first computing device of the one or more computing devices;

the one or more computing devices monitoring for updates, from one or more vendors, to the first server application;

the first computing devices automatically installing the updates to the first server application.

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 information describing the subscription indicates an amount of storage space to allocate to a subscriber associated with the subscription, wherein allocating the one or more database resources comprises reserving storage space of the amount for storage of the data provided over the wide area network, 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 presenting one or more registration web pages over the wide area network;

the web server receiving the information describing the subscription via input provided over the wide area network using one or more forms in the one or more registration web pages.

16. The method of claim 1, wherein managing the one or more database systems further comprises 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:

receiving, in association with the subscription, a specification of a source of database content;

creating the table in response to the subscription; and

periodically importing data from the source into at least the table in accordance with the subscription.

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

19. The method of claim 1, wherein the subscription is one of a plurality of subscriptions to the one or more database services supported by the one or more database systems, the method further comprising:

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

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

the management server reallocating the one or more 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 allocating the one or more database resources comprises creating a virtual database appliance in accordance with the subscription.

21. The method of claim 1, wherein the requests requiring access to the one or more database services are from one or more database applications that provide web-based services using the one or more database services.

22. The method of claim 1,

wherein receiving the requests comprises, a first application executing at a first computing device of the one or more computing devices, receiving the requests from one or more applications over the wide area network;

wherein responding to the requests comprises the first application sending the database query to the database server.

23. The method of claim 1, further comprising:

receiving, at the database server, one or more commands over the wide area network to insert the data into at least the table.

24. The method of claim 1, wherein the one or more computing devices are coupled together by a first network, the one or more computing devices comprising at least two computing devices, wherein wide area network is different from the first network, wherein the first network is protected from the wide area network by a firewall.

25. The method of claim 1, wherein at least some of the requests conform to Structured Query Language (“

SQL”

) or PL/SQL.

26. The method of claim 1, further comprising, based on the information describing the subscription, automatically:

creating the one or more tables, generating a web site that uses the one or more tables, and installing the website on at least a first computing device of the one or more computing devices.

27. The method of claim 1, further comprising:

monitoring usage of the allocated one or more database resources in association with the subscription;

generating bills in association with the subscription based on the monitored usage.

28. A system comprising:

a plurality of computing devices coupled by a first network;

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 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 one or more database services, supported by the one or more database servers, that include one or more 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 at least a second computing device of the plurality of computing devices, configured to;

receive, over a wide-area network that is different than the first network, information describing a subscription to the one or more database services;

examine the information describing the subscription to identify one or more database resources of the one or more database systems to allocate in accordance with the subscription to the one or more database services; and

based on the examining of the information describing the subscription, trigger performance of reconfiguring the one or more database systems, the reconfiguring comprising at least allocating the one or more database resources of the one or more database systems in accordance with the subscription;

wherein the one or more database servers are configured to receive one or more commands to insert data provided over the wide area network into at least a first table of the one or more tables stored in the one or more database storage devices;

wherein one or more computing devices of the plurality of computing devices are configured to receive requests over the wide area network, the requests requiring access to the one or more database services associated with the subscription;

wherein one or more computing devices of the plurality of computing devices are configured to respond to the requests 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 command to retrieve at least a portion of the data provided over the wide area network from the first table.

29. The system of claim 28, further comprising:

a backup server, executing at 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.

30. The system of claim 28, further comprising:

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

31. The system of claim 28, further comprising:

one or more application servers, executing at at least a third computing device of the plurality of computing devices, configured to host at least a first application that was automatically installed in response to the subscription to provide at least a first service if the one or more database services associated with the subscription.

32. The system of claim 28, further comprising a firewall between the wide area network and the first network, through which the requests are received.

33. The system of claim 28, further comprising one or more virtual database appliances.

34. The system of claim 28, wherein at least some of the requests conform to Structured Query Language (“

SQL”

) or PL/SQL.

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

receiving, over a wide area network, information describing a subscription to one or more database services supported by one or more database systems, the one or more database systems comprising one or more database servers and one or more database storage devices;

examining the information describing the subscription to identify one or more database resources of the one or more database systems to allocate in accordance with the subscription to the one or more database services;

based on the examining of the information describing the subscription, automatically configuring the one or more database systems by at least allocating the one or more database resources of the one or more database systems in accordance with the subscription;

wherein the one or more database services include one or more services for storing and managing data provided over the wide area network in one or more tables on the one or more database storage devices;

receiving requests over the wide area network, the requests requiring access to the one or more database services associated with the subscription;

responding to the requests 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 to retrieve at least a portion of the data provided over the wide area network from a table stored in the one or more database storage devices.

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

monitoring usage of the allocated one or more database resources in association with the subscription;

when usage of the allocated one or more database resources exceeds a threshold, generating a message alerting a subscriber associated with the subscription;

providing a web interface for allowing the subscriber to allocate additional database resources.

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

38. The one or more non-transitory computer-readable media of claim 35, wherein allocating the one or more database resources comprises reserving a dedicated database appliance in association with the subscription.

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

receiving the database query from one or more database applications over the wide area network;

providing, over the wide area network, access to a development kit server for developing the one or more database applications.

40. The one or more non-transitory computer-readable media of claim 35, 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.

41. The one or more non-transitory computer-readable media of claim 35, wherein the one or more database resources include one or more of:

a database development application, a sales database application, an invoice database application, an inventory database application, an personnel database application, or a document database application.

42. The one or more non-transitory computer-readable media of claim 35, wherein the instructions, when executed by the one or more processors, further cause providing, over the wide area network, one or more predefined web site database components for use by the one or more database applications.

43. The one or more non-transitory computer-readable media of claim 35, wherein the instructions, when executed by the one or more processors, further cause providing to the one or more database applications, over the wide area network, 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.

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

45. The one or more non-transitory computer-readable media of claim 35, wherein the information describing the subscription includes specification information for 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 set of one or more database applications, wherein the database stores at least some of the data provided over the wide area network, and wherein the one or more database applications access the database via a local area network that is different than the wide area network.

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

providing database services using at least a first server application installed at a first computing device of the one or more computing devices;

the one or more computing devices monitoring for updates, from one or more vendors, to the first server application;

the first computing devices automatically installing the updates to the first server application.

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

48. The one or more non-transitory computer-readable media of claim 35, wherein the information describing the subscription indicates an amount of storage space to allocate to a subscriber associated with the subscription, wherein allocating the one or more database resources comprises reserving storage space of the amount for storage of the data provided over the wide area network, wherein the method further comprises creating and storing the table in the reserved storage space.

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

a web server presenting one or more registration web pages over the wide area network;

the web server receiving the information describing the subscription via input provided over the wide area network using one or more forms in the one or more registration web pages.

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

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

receiving, in association with the subscription, a specification of a source of database content;

creating the table in response to the subscription; and

periodically importing data from the source into at least the table in accordance with the subscription.

52. The one or more non-transitory computer-readable media of claim 35, wherein the subscription is one of a plurality of subscriptions to specific database services supported by a specific database system of the one or more database systems, wherein the instructions, when executed by the one or more processors, further cause automatically configuring and enforcing security policies on the table to secure the table from other subscriptions in the plurality of subscriptions.

53. The one or more non-transitory computer-readable media of claim 35, wherein the subscription is one of a plurality of subscriptions to the one or more database services supported by the one or more database systems, the method further comprising:

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

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

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

updated subscription information or failure of a database device.

54. The one or more non-transitory computer-readable media of claim 35, wherein allocating the one or more database resources comprises creating a virtual database appliance in accordance with the subscription.

55. The one or more non-transitory computer-readable media of claim 35, wherein the requests requiring access to the one or more database services are from one or more database applications that provide web-based services using the one or more database services.

56. The one or more non-transitory computer-readable media of claim 35,

wherein receiving the requests comprises, a first application executing at a first computing device of the one or more computing devices, receiving the requests from one or more applications over the wide area network;

wherein responding to the requests comprises the first application sending the database query to the database server.

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

receiving, at the database server, one or more commands over the wide area network to insert the data into at least the table;

58. The one or more non-transitory computer-readable media of claim 35, wherein the one or more computing devices are coupled together by a first network, the one or more computing devices comprising at least two computing devices, wherein wide area network is different from the first network, wherein the first network is protected from the wide area network by a firewall.

59. The one or more non-transitory computer-readable media of claim 35, wherein at least some of the requests conform to Structured Query Language (“

SQL”

) or PL/SQL.

60. The one or more non-transitory computer-readable media of claim 35, wherein the instructions, when executed by the one or more processors, further cause, based on the information describing the subscription, automatically:

creating the one or more tables, generating a web site that uses the one or more tables, and installing the website on at least a first computing device of the one or more computing devices.

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

monitoring usage of the allocated one or more database resources in association with the subscription;

generating bills in association with the subscription based on the monitored usage.