Techniques for automatically discovering a database device on a network

• US 20070162420A1
• Filed: 02/05/2007
• Published: 07/12/2007
• Est. Priority Date: 01/21/2004
• Status: Abandoned Application

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Presley, Darryl, Ou, Yuanjiang, Thivakaram, Sivakumar, Malla, Venkat
• Application Number:
  US11/702,850
• Publication Number:
  US 20070162420A1
• Time in Patent Office: Days
• US Class Current: 1/1
• 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

Abstract

Techniques for automatically adding a database device to a network of database devices include sending a first request from the database device over the network in response to detecting that the database device is connected to the network. In response to the first request, the database device receives data that identifies a database device-management server. The database device sends a second request to the database device-management server. The second request identifies the database device and requests that the device-management server register the database device as a database device on the network in response to the second request. The new database device may be a database appliance having a database process and a special purpose operating system tailored to the database process. With these techniques, a new database device can be plugged into a network and be automatically discovered, registered, and assigned management tasks without human intervention. This alleviates the load on human operators and makes adding database device to a network more reliable and simple.

Claims

1. A method for automatically adding a database device to a network of database devices, the method comprising the steps of:

in response to detecting that the database device is connected to the network, sending a first request from the database device over the network,

wherein the database device includes database server software for performing operations on data stored in a database in response to database commands that conform to structured query language (SQL), which is supported by the database server software;

receiving

(a) first data, in response to the first request, that identifies a database device-management server, and

(b) information about a database that is to be managed by the database device;

sending a second request to the database device-management server identified in said first data, the second request identifying said database device and requesting that said database device be registered as a database device on said network by the database device-management server in response to the second request;

in response to receiving database commands that conform to the structured query language (SQL) supported by the database server software, performing operations on the data stored in the database identified in the information; and

registering said database device on said network.

2. The method of claim 1 wherein the step of sending the first request is performed as part a booting up operation of said database device.

3. The method of claim 1 wherein:

the first request is a request for a network address for said database device; and

in response to the first request, the database device also receives the network address for the database device.

4. The method of claim 3 wherein:

the first request is sent to the dynamic hosting server; and

the first data is received from the dynamic hosting server.

5. The method of claim 1, wherein the first data further includes at least a value of a configuration parameter for configuring the database device.

6. The method of claim 1, wherein the first data further includes at least an indication of a language to be installed on the database device to process requests over the network for database services from the database device.

7. The method of claim 1, wherein the first data further includes at least a network address for a database directory server.

8. The method of claim 1, wherein the first data further includes at least a network address for a database backup server.

9. The method of claim 1, further comprising receiving, from the database device-management server, managed node information indicating a management task to be performed by the database device.

10. The method of claim 9, further comprising installing instructions on the database device for performing the management task.

11. The method of claim 1, wherein the information about the database includes a name for the database, wherein the database is created on the database device, and wherein the first data further includes at least:

a value of a configuration parameter for configuring the database device,

an indication of a language to be installed on the database device to process requests over the network for database services from the database device,

a network address for a database directory server, and

a network address for a database backup server.

12. The method of claim 9, wherein the managed node information further includes at least

a value of a configuration parameter for configuring the database device, and

instructions necessary to perform the management task.

13. The method of claim 9, wherein the management task is one of a plurality of management tasks to be performed by the database device, and the managed node information includes each of the plurality of management tasks, the plurality of management tasks including at least:

a database management function,

a response to a triggering event, and

a software patch to install.

14. The method of claim 13, wherein the database management function is one of a plurality of database management functions, and the managed node information includes each of the plurality of database management functions, the plurality of database management functions including at least:

a backup operation;

monitoring storage space usage;

creating an index; and

synchronizing content with another database.

15. The method of claim 1, wherein the database device is a database appliance comprising a database process and a special purpose operating system tailored to the database process.

16. The method of claim 9, wherein the management task includes at least a database management function.

17. The method of claim 9, wherein the management task includes at least a response to a triggering event.

18. The method of claim 16, wherein the database management function includes at least a backup operation.

19. The method of claim 16, wherein the database management function includes at least monitoring storage space usage.

20. The method of claim 16, wherein the database management function includes at least creating an index.

21. The method of claim 16, wherein the database management function includes at least synchronizing content with another database.

22. A computer-readable storage medium for automatically adding a database device to a network of database devices, the computer readable medium carrying one or more sequences of instructions wherein execution of the one or more sequences of instructions by one or more processors causes the one or more processors to perform the steps of:

in response to detecting that the database device is connected to the network, sending a first request from the database device over the network,

wherein the database device includes database server software for performing operations on data stored in a database in response to database commands that conform to structured query language (SQL), which is supported by the database server software;

receiving

(a) first data, in response to the first request, that identifies a database device-management server, and

(b) information about a database that is to be managed by the database device;

sending a second request to the database device-management server identified in said first data, the second request identifying said database device and requesting that said database device be registered as a database device on said network by the database device-management server in response to the second request; and

in response to receiving database commands that conform to the structured query language (SQL) supported by the database server software, performing operations on the data stored in the database identified in the information.

23. The computer-readable storage medium of claim 22 wherein the step of sending the first request is performed as part a booting up operation of said database device.

24. The computer-readable storage medium of claim 22 wherein:

the first request is a request for a network address for said database device; and

in response to the first request, the database device also receives the network address for the database device.

25. The computer-readable storage medium of claim 24 wherein:

the computer-readable medium further comprises information including a network address of a dynamic hosting server running on a second device;

the instructions further cause the one or more processors to load the information prior to sending the first request;

the first request is sent to the dynamic hosting server; and

the first data is received from the dynamic hosting server.

26. The computer-readable storage medium of claim 22, wherein the first data further includes at least a value of a configuration parameter for configuring the database device.

27. The computer-readable storage medium of claim 22, wherein the first data further includes at least an indication of a language to be installed on the database device to process requests over the network for database services from the database device.

28. The computer-readable storage medium of claim 22, wherein the first data further includes at least a network address for a database directory server.

29. The computer-readable storage medium of claim 22, wherein the first data further includes at least a network address for a database backup server.

30. The computer-readable storage medium of claim 22, the one or more sequences of instructions further causing the one or more processes to perform the step of receiving, from the database device-management server, managed node information indicating a management task to be performed by the database device.

31. The computer-readable storage medium of claim 30, the one or more sequences of instructions further causing the one or more processes to perform the step of installing instructions on the database device for performing the management task.

32. The computer-readable storage medium of claim 22, wherein the information about the database includes a name for the database, wherein the database is created on the database device, and wherein the first data further includes at least:

a value of a configuration parameter for configuring the database device,

an indication of a language to be installed on the database device to process requests over the network for database services from the database device,

a network address for a database directory server, and

a network address for a database backup server.

33. The computer-readable storage medium of claim 30, wherein the managed node information further includes at least:

a value of a configuration parameter for configuring the database device, and

instructions necessary to perform the management task.

34. The computer-readable storage medium of claim 30, wherein the management task is one of a plurality of management tasks to be performed by the database device, and the managed node information includes each of the plurality of management tasks, the plurality of management tasks including at least:

a database management function,

a response to a triggering event, and

a software patch to install.

35. The computer-readable storage medium of claim 34, wherein the database management function is one of a plurality of database management functions, and the managed node information includes each of the plurality of database management functions, the plurality of management tasks including at least:

a backup operation;

cleaning out one or more logs;

monitoring storage space usage;

creating an index; and

synchronizing content with another database.

36. The computer-readable storage medium of claim 22, wherein the database device is a database appliance comprising a database process and a special purpose operating system tailored to the database process.

37. The computer-readable storage medium of claim 30, wherein the management task includes at least a database management function.

38. The computer-readable storage medium of claim 30, wherein the management task includes at least a response to a triggering event.

39. The computer-readable storage medium of claim 37, wherein the database management function includes at least a backup operation.

40. The computer-readable storage medium of claim 37, wherein the database management function includes at least monitoring storage space usage.

41. The computer-readable storage medium of claim 37, wherein the database management function includes at least creating an index.

42. The computer-readable storage medium of claim 37, wherein the database management function includes at least synchronizing content with another database.