Expert system for designing computer networks

• US 5,557,775 A
• Filed: 02/23/1994
• Issued: 09/17/1996
• Est. Priority Date: 02/23/1994
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Shedletsky, John J.
• Primary Examiner(s): Teska, Kevin J.
• Assistant Examiner(s): NGUYEN, TAN QUANG
• Application Number:
  US08/200,249
• Time in Patent Office: 937 Days
• Field of Search: 395/500, 395/325, 395/800, 395/908, 395/75, 395/50, 395/63, 395/21, 395/306, 395/309
• US Class Current: 703/13
• CPC Class Codes: G06F 30/00 Computer-aided design [CAD]

Abstract

An expert system is used to design a computer network comprising hardware platforms, applications, data bases, user interfaces, etc. The expert system initially displays questions and receives responsive information from a user as to characteristics of backend data bases and whether copies of said backend data bases should be stored in respective frontend data bases. In response, the expert system "builds" one of a predetermined set of backend models which corresponds to the information. Next, to reduce complexity, the expert system identifies two or more of the frontend data bases of compatible type that can be merged together and then displays questions and receives responsive information indicating whether the mergers should be made. Next, the expert system displays questions and receives responsive information as to characteristics of frontend components including an intermediate server. In response, the expert system builds one of a set of predetermined frontend models which corresponds to the information. Next, the expert system identifies a function of the intermediate server that can be performed on a backend platform within the backend model. Next, the expert system displays questions and receives responsive information whether the function should be performed on the backend platform, and updates the frontend model accordingly. Next, the expert system displays questions and receives responsive information as to characteristics of connections between the updated frontend model and the backend model. In response, the expert system determines a final design of the computer network based on the connection information, backend model and updated frontend model.

Claims

1. An expert system for designing a computer network, said system comprising:

means for displaying questions and receiving responsive decisions as to types of back end data bases and whether copies of said back end data bases should be stored in respective fronted data bases;

means for determining if two or more of said fronted data bases can be merged together based on compatibility of their types and notifying an operator of the determination;

means for receiving a decision from said operator whether said two or more fronted data bases should be merged together, if compatible; and

means for determining a final design of the computer network based in part on the decision whether said two or more fronted databases should be merged together.

2. A system as set forth in claim 1 wherein said types of data bases comprise relational data bases, hierarchical data bases and/or file systems.

3. A system as set forth in claim 2 wherein only data bases of the same type are compatible with each other.

4. A system as set forth in claim 1 further comprising means for displaying a question and receiving a responsive decision whether data from two of said back end data bases should be staged into a common fronted data base, and if so, designing a computer network which merges the staged data into a common fronted data base if the two back end data bases are compatible types.

5. A method for designing a computer network, said method comprising the computer implemented steps of:

displaying questions and receiving responsive decisions as to types of back end data bases and whether copies of said back end data bases should be stored in respective fronted data bases, and in response identifying a back end model which corresponds to the back end decisions;

displaying questions and receiving responsive decisions of types of fronted components, and in response identifying a fronted model which corresponds to the fronted decisions;

identifying a program function that can be performed on either an intermediate server or the back end model; and

displaying a question and receiving a responsive decision whether said intermediate server should be included in said computer network to perform said program function.

6. A method as set forth in claim 5 further comprising the step of displaying questions and receiving responsive decisions of types of connections between said intermediate server, if any, fronted model, and said back end model, and in response determining a final design of said computer network based on said connection decision, intermediate server, if any, back end model and fronted model.

7. A method as set forth in claim 6 further comprising the step of displaying information with said questions about said connections, said information indicating advantages or disadvantages for different connection decisions.

8. A method as set forth in claim 5 further comprising the step of:

identifying two or more of said fronted data bases of compatible type that can be merged together; and

displaying a question and receiving a responsive decision whether said two or more fronted data bases should be merged together.

9. A method as set forth in claim 8 wherein said two or more front end data bases of compatible type are each staged.

10. A method as set forth in claim 5 further comprising the step of displaying information with said questions about said fronted components, said information indicating advantages or disadvantages for different front end decisions.

11. A method as set forth in claim 5 wherein the design is built in stages and further comprising the step of displaying the design after each of various stages.

12. A method as set forth in claim 5 wherein said questions about said fronted components include questions about desired clustering of users into workgroups.

13. A method as set forth in claim 5 further comprising the subsequent step of constructing the computer network according to the final design.

14. A method for designing a computer network, said method comprising the computer implemented steps of:

displaying questions and receiving responsive decisions of types of back end data bases and whether copies of said back end data bases should be stored in respective fronted data bases, and in response identifying a predetermined back end model which corresponds to said back end decisions;

displaying questions and receiving responsive decisions of types of fronted components, and in response identifying a fronted model which corresponds to said fronted component decisions;

determining and presenting reasons to include an intermediate server to execute a program function needed in said computer network; and

in response to the presented reasons, receiving a decision from an operator whether to include said intermediate server in a final design of said computer network.

15. A method as set forth in claim 14 further comprising the step of displaying the final design of the computer network.

16. A method as set forth in claim 14 wherein said computer network needs presentation logic program function, business logic program function and data access logic program function, and determines and presents reasons to include said intermediate server to execute any of said program functions.

17. A method as set forth in claim 14 further comprising the step of:

displaying questions and receiving responsive decisions of types of connections between said fronted model, said back end model and said intermediate server, if any, and in response determining said final design based on the connection decisions, intermediate server, if any, back end model and fronted model.

18. A process as set forth in claim 14 wherein said reasons include performance considerations.

19. A process as set forth in claim 14 wherein said reasons include scope of required access to data associated with said function.

20. A system for designing a computer network, said system comprising:

means for displaying questions and receiving responsive decisions of types of back end data bases and in response identifying a back end system from a predetermined set of back end systems which corresponds to the back end decisions;

means for displaying questions and receiving responsive decisions of types of fronted components and in response identifying a fronted system from a predetermined set of fronted systems which corresponds to the fronted decisions; and

means for displaying questions and receiving responsive decisions of types of connections between the identified fronted system and the identified back end system, and in response determining a final design of said computer network based on the connection decision, the identified back end system and the identified fronted system.

21. A system as set forth in claim 20 wherein said predetermined set of back end systems consists substantially of DBobject Cases 1-7.

22. A system as set forth in claim 21 wherein said predetermined set of fronted systems consists substantially of Fecases A-G, H1, H2, J1 and J2.

23. A system as set forth in claim 20 wherein said predetermined set of back end systems comprises at least five of DBobject Cases 1-7.

24. A system as set forth in claim 23 wherein said predetermined set of fronted systems comprises at least eight of Fecases A-G, H1, H2, J1 and J2.

25. A system as set forth in claim 20 wherein said predetermined set of fronted systems consists substantially of Fecases A-G, H1, H2, J1 and J2.

26. A system as set forth in claim 20 wherein said predetermined set of fronted systems comprises at least eight of Fecases A-G, H1, H2, J1 and J2.

27. A system as set forth in claim 20 further comprising:

means for displaying questions and receiving responsive decisions of whether an application executing in said system is distributed, resource centric or front ended and using said application decisions to determine whether to place components of application logic on said back end model, said fronted model or said intermediate server, if any.

28. A system as set forth in claim 20 further comprising:

means for displaying questions and receiving responsive decisions of whether an application executing in said system is distributed, resource centric or front ended and using said application decisions to determine a number of each of said back end model, said fronted model and said intermediate server to include in the final design.