Integrated two-way communications between database client users and administrators

• US 9,634,966 B2
• Filed: 11/25/2014
• Issued: 04/25/2017
• Est. Priority Date: 01/20/2006
• Status: Active Grant

• Current Assignee: Snap, Inc.
• Original Assignee: Snap, Inc.
• Inventors: Bostick, James E., Forlenza, Randolph M., Kaemmerer, John P., Kalyanaraman, Raghuraman, Spooner, Courtney J.
• Primary Examiner(s): Phung, Luat
• Assistant Examiner(s): Cairns, Thomas R
• Application Number:
  US14/552,526
• Publication Number:
  US 20150081827A1
• Time in Patent Office: 882 Days
• CPC Class Codes: H04L 51/04 Real-time or near real-time messaging, e.g. instant messaging [IM]
• CPC Class Codes: H04L 67/1097 for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]

Abstract

A method and system for communicating between database client users and administrators. A message request is received from a database administrator (DBA) responsible for managing aspects of a particular database. The message request includes a database name of the particular database, at least two message recipients, and message content. The message request is a request to send the message content only to the at least two message recipients consisting of at least two but not all database client users currently connected to the particular database. An Internet Protocol (IP) address associated with each message recipient is determined, without using an instant messaging address for any of the message recipients. A first message including the message content is simultaneously transmitted to each of the determined IP addresses. A second message, which includes a reply message to the first message, is received from one of the determined IP addresses.

Claims

1. A method for communicating between database client users and administrators, the method comprising:

receiving, at at least one processor of a computer system and from a database administrator (DBA) responsible for managing aspects of a particular database, a message request comprising;

a database name of the particular database, a plurality of message recipients, and message content including a file attachment, the message request being a request to send the message content to database client users currently connected to the particular database;

determining an Internet Protocol (IP) address associated with each message recipient of the plurality of message recipients, without using an instant messaging address for each respective message recipient of the plurality of message recipients;

after determining the IP address associated with each respective message recipient of the plurality of message recipients, transmitting a first message comprising the message content including the file attachment to each of the determined IP addresses, the first message not including identification of any specific users of the particular database;

receiving a second message from one IP address of the determined IP addresses to which the first message was transmitted, the second message comprising a reply message to the first message and being transmitted to an IP address of a database server associated with the database administrator (DBA), the second message further not including an identity of the database administrator (DBA); and

initiating display of the second message in a display window.

2. The method of claim 1, wherein said determining the IP address associated with each message recipient comprises cross-referencing the plurality of message recipients with a list of IP addresses currently maintained by the database server to associated with the DBA database administrator (DBA).

3. The method of claim 1, further comprising redirecting the second message to an alternative database administrator (DBA) address.

4. The method of claim 1, wherein the aspects of the particular database comprise recoverability, resource management, integrity, security, availability, performance, and development and testing support.

5. A machine-accessible storage device comprising program instructions configured to be executed by at least one processor of a computer system to execute routines for communicating between database client users and administrators, the routines comprising:

the at least one processor receiving, from a database administrator (DBA) responsible for managing aspects of a particular database, a message request comprising;

a database name of the particular database, a plurality of message recipients, and message content including a file attachment, the message request being a request to send the message content to database client users currently connected to the particular database;

the at least one processor determining an Internet Protocol (IP) address associated with each message recipient of the plurality of message recipients, without using an instant messaging address for each respective message recipient of the plurality of message recipients;

after said determining the IP address associated with each respective message recipient of the plurality of message recipients, the at least one processor transmitting a first message comprising the message content including the file attachment to each of the determined IP addresses, the first message not including identification of any specific users of the particular database;

the at least one processor receiving a second message from one IP address of the determined IP addresses to which the first message was transmitted, the second message comprising a reply message to the first message and being transmitted to an IP address of a database server associated with the database administrator (DBA), the second message further not including an identity of the database administrator (DBA); and

the at least one processor initiating display of the second message in a display window.

6. The storage device of claim 5, wherein the routines to be executed by the at least one processor of the computer system determine the IP address associated with each message recipient by cross-referencing the plurality of message recipients with a list of IP addresses currently maintained by the database server associated with the database administrator (DBA).

7. The storage device of claim 5, wherein the routines to be executed by the at least one processor of the computer system redirect the second message to an alternative database administrator (DBA) address.

8. The storage device of claim 5, wherein the aspects of the particular database comprise recoverability, resource management, integrity, security, availability, performance, and development and testing support.

9. A computer system comprising at least one processor and a computer readable storage device coupled to the at least one processor, said storage device containing routines to be executed by the at least one processor to implement communicating between database client users and administrators, the routines comprising:

the at least one processor receiving, from a database administrator (DBA) responsible for managing aspects of a particular database, a message request comprising;

a database name of the particular database, a plurality of message recipients, and message content including a file attachment, the message request being a request to send the message content to database client users currently connected to the particular database;

the at least one processor determining an Internet Protocol (IP) address associated with each message recipient of the plurality of message recipients, without using an instant messaging address for each respective message recipient of the plurality of message recipients;

after said determining the IP address associated with each respective message recipient of the plurality of message recipients, the at least one processor transmitting a first message comprising the message content including the file attachment to each of the determined IP addresses, the first message not including identification of any specific users of the particular database;

the at least one processor receiving a second message from one IP address of the determined IP addresses to which the first message was transmitted, the second message comprising a reply message to the first message and being transmitted to an IP address of a database server associated with the database administrator (DBA), the second message further not including an identity of the database administrator (DBA); and

the at least one processor initiating display of the second message in a display window.

10. The computer system of claim 9, wherein said determining the IP address associated with each message recipient comprises cross-referencing the plurality of message recipients with a list of IP addresses currently maintained by the database server associated with the database administrator (DBA).

11. The computer system of claim 9, the method further comprising the at least one processor redirecting the second message to an alternative database administrator (DBA) address.

12. The computer system of claim 9, wherein the aspects of the particular database comprise recoverability, resource management, integrity, security, availability, performance, and development and testing support.