Customer information storage and delivery system

[0002] 1. Field of the Invention

[0003] The present invention relates to systems and processes that are deployed to store and deliver customer and project information to relatively large user populations. More particularly, the present invention relates to database management systems which are used to store and deliver customer and project related information to users of the same via network connections.

[0004] 2. Description of the Related Art

[0005] In large organizations such as those that are service oriented, the storage and retrieval of information related to ongoing projects and customers often present significant problems for system managers, customers, and service support staff. In particular, service based organizations such as telephony and communications organizations have no effective way to store and disseminate information that may be used by engineering staff, support personnel, and, most importantly, customers to obtain needed information about ongoing projects, status data, performance metrics, etc. For example, when service problems occur (e.g., network outages), it is not uncommon for customers to scurry to obtain current and valid contact numbers and addresses of key personnel who can correct or otherwise handle and address such problems. As a result, frustrations on the part of customers can run high, services often are interrupted, and problems are not effectively and efficiently addressed and resolved.

[0006] To address the problems associated with storing and delivering current information such as customer related information (e.g., support staff contact numbers and electronic mail addresses, etc.), many solutions have been proposed. For example, many organizations have implemented what have been referred to as “intranets” to allow organizational personnel to access central data repositories to retrieve contact information and the like. Unfortunately, such intranets often only allow small groups of select users (e.g., internal personnel) to access such information. Historically, intranets have not been deployed to allow larger user populations such as those including internal support and engineering personnel and external personnel such as customers to access central repositories of project and customer information.

[0007] To address the limitations of conventional intranets, “extranets” have been proposed to address the constant need to provide access to project and/or customer information. Such systems allow larger user populations to access databases of relevant information. Unfortunately, however, extranet systems have not been deployed in any common, uniform, or convenient way to facilitate easy and efficient use by larger user populations. In particular, each customer or project often calls for a separate and distinct network system, thus requiring an extranet to be established on al la carte, custom basis. Accordingly, the instantiation of a special extranet system to support each particular customer can become a project that may be more resource intensive to establish and operate than the underlying services to which it is to relate.

[0008] Moreover, in prior networked information delivery systems such as those embodying extranets and, in particular, in those utilized in organizations that provide telecommunications services, network management centers compiled trouble and customer support ticket data which was sent to various account teams. Upon receipt of such ticket data, the account teams would produce various reports for perusal by internal staff and customers. Accordingly, the information gathered via ticket responses, etc. was prepared internally and then delivered to customers for their processing. In prior systems, there was no way for customers, for example, to access an information repository managed by a service organization and retrieve live, up-to-date reports and analyses of system and network performance, statistics, contact information, process instructions, etc.

[0009] Accordingly, there exists no truly effective solution to the ever-present problem of providing project and customer information to diverse user populations. And, as organizations take on more customers and/or offer more services (e.g., telecommunications services, etc.), they are faced with allocating resources merely to control and service the demands for information that ought to be readily and immediately available. Because there are no shared repositories of information between user groups within a particular organization, that information must be disseminated and, often, replicated within a corresponding system. Such redundancy is often the cause of many inconsistencies among stored information.

[0010] Thus, there exists a need to provide a system and corresponding process for storing and providing customer and project related information to diverse user populations. To be viable such a system must be able to store customer and projected related information in a central repository that is accessible from inside and outside of an organization. Such a system must store and deliver information related to customers and projects including, but not limited to, personnel contact information, engineering information project status information, project planning procedures, etc. which is retrievable using conventional network data and content retrieval tools such as web browsers, etc.

[0011] The present invention solves the problems mentioned above by providing a centralized data store containing information related to customers and projects that is easily accessible by diverse user populations including internal organizational personnel and external personnel such as customers. As such, the present invention provides many benefits associated with data storage and distribution not heretofore realized by prior database management systems and facilities. For example, during times of network or service related problems (e.g., service failures, outages, etc.), customers can now easily access a centralized data store to retrieve engineering and contact personnel information, learn about corrective procedures and processes, and, possibly, page and otherwise automatically initiate contact to personnel that are equipped and trained to respond to a particular service customer's needs. Additionally, because the present invention utilizes standard tools and facilities (e.g., web servers coupled to web browsers, etc.) to distribute information and customer content (e.g., project related information such as statistics, etc.), users are able to access such information without having to know or understand special system protocols, etc.

[0012] The present invention solves the aforementioned problems to deliver the benefits mentioned above by providing a system and corresponding method for storing and delivering customer information. The system and method include and involve a data storage system for storing customer information including contact information, network addressing information, engineering, and customer service information related to at least one network service customer to whom network services are provided by a network service provider. The system and method also include and involve a network access system that is coupled to the data storage system via at least one data communications link and which is configured to provide access to at least one user to permit such user(s) to retrieve the customer information from the data storage system.

[0013] According to another aspect of the present invention, provided is a method of using a data communications network that includes the steps of accessing a data communications network via a network connection, receiving a login authorization prompt to be validated within the data communications network, entering a login sequence via the network connection to be validated by a validation system within the data communications network, accessing a document delivery system within the data communications network after being validated by the validation system, and receiving customer information from the document delivery system based on the login sequence. The customer information includes contact information, network addressing information, engineering and customer service information related to at least one network service customer to whom network services are provided by a network service provider.

[0014] The present invention is discussed in detail below with regard to the drawing figures attached hereto, of which:

[0015] FIG. 1 is a diagram of a system in which customer and project related information is centrally stored within a common data repository and delivered via network connections, and

[0016] FIG. 2 is a flowchart that illustrates steps that may be carried out within the system depicted in FIG. 1 to store and retrieve customer and project related information.

[0017] The present invention is now discussed in detail with regard to the drawing figures that were briefly described above. Unless otherwise indicated, like parts and processes are referred to with like reference numerals.

[0018] Referring now to FIG. 1, depicted therein is a diagram of a system in which customer and project related information is centrally stored within a common data repository and delivered, possibly to customers, via network connections. More particularly, FIG. 1 illustrates a system in which shared databases containing customer related information may be stored within server system and delivered to users such as customers via a variety of network connections. Such shared databases may include fields and tables needed to track network information for customers and/or projects. Such tables will include data such as IP addresses, protocols, phone numbers for contacts, personnel, passwords, and other contact information. Such data will be useful to customers, engineering staff, support personnel, account teams, etc. Additionally, databases stored in shared fashion in accordance with the present invention may include procedures and process instructions that further include escalation lists for problem handling, new site verification instructions, ticket opening and closing details, etc.

[0019] Accordingly, exemplary system 100 provides such data services and includes a web server 102 (e.g., one that operates in accordance with the Netscape Enterprise Server, WINDOWS Internet Information Server packages, etc.), database servers 104 and 106 (e.g., server systems that operate in accordance with the WINDOWS SQL Database server software package which is manufactured and marketed by MICROSOFT CORPORATION). A network backbone 108 (having an IP address 205.223.?.?—an IP address accessible via a TCP/IP based network), a router 110 coupled to a redundancy platform 115 that includes a router 112, a network backbone 117, a redundant web server 114, and a redundant database server 116.

[0020] Coupled to web server 102 are paging facilities 105 which are configured to automatically initiate pager notification calls in response to requests for the same from users who access web pages that facilitate immediate contact. Such paging facilities will be readily understood by those skilled in the art to allow numeric and text paging such as that used to send personnel text messages such as “CUSTOMER XXX NEEDS NETWORK TRAFFIC SUPPORT RELATIVE TO A DOWNED NETWORK SERVER.”

[0021] Also coupled to network backbone 108 via an exemplary network traffic interconnect is a hub and switch system comprising components 118 and 120. Connected thereto is a firewall system 122, a router system 124, a firewall system 126 and an organizational internal Intranet system 128. Organizational Intranet 128 may be configured to operate according to a protocol such as TCP/IP and may be addressable via an IP address such as 166.34.0.0 (a private IP address not necessarily registered with an IP address registration authority).

[0022] Coupled to the structures mentioned above, are various customer networks 130, which may be coupled to web server 102 and database servers 104 and 106, respectively, via the public internet 132, a hyperstream frame relay network 134, and/or other dial up facilities 136.

[0023] Accordingly, customer personnel accessing a network connection via a customer network such as one included within customer networks 130 may access internal intranet 128 via a dial-up facility through a firewall to gain access to customer and/or project information stored within database servers 104 and 106 via a conventional web browser facility. Because such information is centrally stored within a repository including data stored within database servers 104 and 106 which may be accessible via web server 102, a customer has ready access to current and up-to-date information related to a particular project or service offered and provided by an organization such as an organization that provides telecommunication services and the like. In particular, in the case that a network outage occurs, a customer may obtain ready access to information stored within data base servers 104 and 106 related to that particular customer via a web browser, for example, and immediately obtain information to contact appropriate personnel for correction and mitigation of network outage problems (e.g., such as via paging facilities 105).

[0024] Having such information available to all personnel associated with a particular project or service for a particular customer, for example, minimizes the amount of time need to contact someone. Additionally, system 100 may be outfitted with paging capability such that a script provided through web server 102 may allow automatic paging via paging facilities 105 to particular personnel about which data is stored in database servers 104 and 106 to allow a customer to automatically page a particular person at an active and current paging number in the event that problems and network difficulties are experienced. Such paging systems will be readily understood by those skilled in the art and may include text paging and the like. Accordingly, the present invention provides a singular and central store for customer and project information.

[0025] In addition, the present invention provides a reporting aspect that will allow various network management centers to report statistics such as mean time to repair, network availability, total number of tickets (e.g., trouble tickets) open, chronic issues and resolution scenarios etc. back to an account team and the customers associated therewith. By maintaining all of the reporting of such information on-line and in a current up-to-date central facility, the possibility that incorrect information is passed from one particular group to another is eliminated. The speed at which the reports are published may be measured in milliseconds unlike typical or traditional solutions where hard copy reports are printed and shipped overnight, etc. Customers and vendors can now download large files and print reports in a matter of seconds. Such a procedure eliminates the endless number of copies that are made for presentations and results are more user friendly. Less reproduction of unnecessary and unwanted copies will decrease reporting costs and increase information dissemination efficiency.

[0026] Furthermore, because the present invention utilizes HTML and other web based solutions to provide information, the present invention gives all parties involved with a particular service and/or project an interface to reports, data, and miscellaneous tools that are accessible through any standard web browser. The present invention provides servers which are accessible via various routes to account teams, engineers, and customer personnel. Moreover, the present invention will be available over connections such as dial-up facilities 136, dedicated circuits, shared local ETHERNET or even via the Internet (such as via the world wide web). Web server 102 will provide each appropriate group limited access to relevant information as defined through appropriate scripts, etc., which will be readily understood by those skilled in the art of information delivery and database storage after reviewing the present invention.

[0027] With specific regard to the access paths by which customer personnel may access web server 102 and data base servers 104 and 106, respectively, customers have the option of accessing the same via the public Internet 132, via hyperstream frame relay network 134, dial-up facilities, etc. Dial-up facilities are generally inexpensive and the simplest to establish. However, such facilities are limited by current analog modem speeds ranging from 28.8K bits per second up to almost 56K bits per second. In addition to the latency from such a slow connection, dial-up implementations provided by the present invention require that the customer set-up each of their computers with a dial-up facility. Accordingly, although dial-up facilities 136 are permitted in accordance with the present invention, customers and other personnel may choose not to use the same as dial-up facilities often are slower then desired.

[0028] Alternatively, customers and other personnel have the option of connecting to database servers 104 and 106 via web servers 102 via Internet connections. This option is simple to implement and can be done securely. Unfortunately, some customers and other personnel may be hesitant to rely on the public Internet due to security issues and the like. Although safe with encryption (e.g., SSL) on the browser side via a browser and a server system, a customer may be allowed to access a firewall available from an Internet service provider to the Internet.

[0029] Alternatively, a hyperstream frame relay (HSFR) connection may be used to establish a communications link between customer facilities and servers 102, 104 and 106 respectively. There are several key benefits that make this type of connection preferable over dial-up and Internet connections as discussed above. For example, a frame relay connection is a dedicated connection with guaranteed bandwidth. This insures that customers may access the information faster and allow developers of web sites, for example, to build content with graphics-intensive tools/pages. The circuit speeds can range from 56 kilobits (DS0) to 1.54 megabits (T1) based upon customer needs. A customer would have to add a single route to a service facility to their existing network routers to support hyperstream frame relay facilities. With such high-speed frame relay connections, a customer's data is only transmitted back to them and not via any other network connection which may be accessed by third parties such as those engaged in fraudulent review of network traffic. This version of connectivity can add value to a service by providing dedicated access. The customer, however, would purchase an additional permanent virtual circuit from a service provider for dedicated bandwidth or BOD (bandwidth on demand) requirements.

[0030] To facilitate secure data communications in the context of the present invention and, in particular, within the exemplary network arrangement illustrated in system 100, multiple security checkpoints are in place guaranteeing compliance with particular safety standards. If a customer is using dial-up communications, their communications will be restricted to the specific IP addresses of servers 102, 104, and 106. This type of restriction may be enforced via a firewall connection such as one handled by firewall 126. In the context of Internet and hyperstream frame relay, a first security checkpoint for Internet or HSFR connections is a CISCO router that is connected to the Internet and HSFR. This router would have access lists placed in it that limit each customer to their virtual IP address on the web server as well as restricting traffic to the HTTP protocol. In the event that a customer is using a private network address, an entry router will be configured with CISCO's national address translation software, eliminating the aforementioned problems.

[0031] Additionally, all connections through dial-up, Internet and hyperstream frame relay will go through a firewall 122. This firewall will be configured to restrict the customer, for example, to specific IP addresses of servers 102, 104, and 106. This firewall can be configured to grant everyone on the customers' own Intranet access to the web server or only the IP address that the customer provides.

[0032] Once the customer attempts to access web server 102, they will have to authenticate themselves via a secure, encrypted login sequence. Such login sequence will validate the users security privileges, for example, via the WINDOWS NT system level in the event that WINDOWS NT Version 4.0 (manufactured and marketed by MICROSOFT CORPORATION) is used. Each customer will belong to a specific NT system group which will allow them access to their particular homepage (as specified via a specific port and virtual server connection) while restricting them from other areas on the same server.

[0033] Each active server page will check in an encrypted database that will verify regions (home IP addresses) of the web server to which the particular user or customer has attempted to gain access.

[0034] Accordingly, the structure and arrangements depicted in FIG. 1, link personnel from various user populations (engineers, support personnel, customers, etc.) to customer systems allowing data to be shared that is otherwise stored in a single, central location. The dissemination of information in this manner is unique in the telecommunications service industry. Additionally, the present invention allows reports to be prepared via on-line sessions and to be made available directly to customers and corresponding account teams. The customer can page, send e-mail, and even videoconference with engineers from a web site initiated location.

[0035] By sharing a single source of data with customers and other personnel, a network service provider can react to problems in a more timely fashion to network outages, etc. The present invention prevents double keying of information and thus prevents entry errors. Additional benefits of the present invention include shared reports, commonality among all network management centers, data dissemination and tracking, and procedure availability. Streamlining and consistency are key parts to the novel approaches provided by the present invention. Any telecommunications company that utilizes the present invention may be able to manage more data networks and service additional customers. The present invention facilitates the dissemination of information from a central storage facility to those customers and other personnel who have appropriate access to the same. The operations that may be carried out to realize such functionality are illustrated in FIG. 2, to which reference is now made.

[0036] In particular, FIG. 2 illustrates the operations that may be carried out to obtain centrally stored information related to customers and/or projects. More particularly, FIG. 2 illustrates a flow chart that depicts the operations that may be carried out to obtain such information. In particular, process operations start at step S2-1 and immediately proceeds to step S2-2. At step S2-2, a customer and/or other personnel may access web server 102 via a network connection as described above with regard to system 100 shown in FIG. 1.

[0037] Next, at step S2-3, web server 102 will access databases containing customer-related information and format the same for delivery via a hypertext interface according to the present invention.

[0038] Next, at step S24, a user's end terminal (such as a customer's end user terminal or personnel data processing system such as a personnel computer, etc.) may receive web content and/or HTML content regarding customer related information, reports, tools, etc. from web server 102 via a network connection as described above.

[0039] Processing ends at step S2-5.

[0040] Thus, having fully described the present invention by way of example with reference to the attached drawings figures, it will be readily appreciated that many changes and modifications may be made to the invention and to any of the exemplary embodiments shown and/or described herein without departing from the spirit or scope of the invention, which is defined in the appended claims.