Cool ice column profiling

• US 6,496,821 B1
• Filed: 11/09/1998
• Issued: 12/17/2002
• Est. Priority Date: 11/09/1998
• Status: Expired due to Fees

• Current Assignee: Unisys Corporation
• Original Assignee: Unisys Corporation
• Inventors: Gebauer, Niels, Bae, Seongho, Watts, Julian C.
• Primary Examiner(s): CHOULES, JACK M
• Application Number:
  US09/188,649
• Time in Patent Office: 1,499 Days
• Field of Search: 707/9, 707/10
• US Class Current: 1/1
• CPC Class Codes: G06F 16/972 Access to data in other repository systems, e.g. legacy data or dynamic Web page generation
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries
• CPC Class Codes: Y10S 707/99939 Privileged access

Abstract

An apparatus for and method of utilizing an internet terminal coupled to the world wide web to access an existing proprietary data base management system having a dialog-based request format. The user request is received by a web server from the world wide web and converted into one or more sequenced data base management commands stored as corresponding to the service request. A security profile, if necessary, is also stored with the one or more sequenced data base management commands based upon the specific data columns within the specific data tables within the data base which must be accessed to honor the service request. The security profile is compared to the user-id of the requester. If a match is found, the data base management commands are sequentially presented to the data base management system and the intermediate products stored. After all of the sequenced data base management commands have been executed, the web server combines the intermediate products to form a complete response to the initial user request. The response is transferred to the user over the world wide web. If the user-id and security profile do not match, the service request is not executed and an error response is provided to the user.

Claims

1. In a data processing environment having a user terminal with a user-id for generating a service request for access to a first data column within a first data table responsively coupled to a data base management system via a publically accessible digital data network having at least one data base having a plurality of data tables wherein said first data table contains at least one data column wherein said at least one data column includes said first data column, the improvement comprising:

a. an administration terminal responsively coupled to said data base management system whereat an administrator assigns a security profile corresponding to said user-id; and

b. wherein said security profile corresponding to said user-id permits said user terminal to access the entirety of said first data column of said first data table if and only if said security profile corresponds to access to said first data column of said first data table.

2. The improvement according to claim 1 wherein said at least one data column of said first data table is a plurality of data columns and said security profile does not correspond to access of at least one of said plurality of data columns within said first data table.

3. The improvement according to claim 2 further comprising a second user terminal with a second user-id for generating a second service request for accessing a second one of said plurality of data columns within said first data table wherein said second user terminal is prohibited from accessing said first data column within said first data table.

4. The improvement according to claim 3 further comprising a third user terminal with a third user-id for generating a third service request for accessing every one of said plurality of data columns within said first data table wherein said third user-id corresponds to a third security profile for accessing every one of said plurality of data columns within said first data table.

5. The improvement according to claim 4 wherein said data base management system is Classic MAPPER.

6. An apparatus comprising:

a. a user terminal having a user-id;

b. a data base management system having access to a data base with a plurality of data columns within each of a plurality of data tables responsively coupled to said user terminal via a publically accessible digital data communication network;

c. an administration terminal whereat an administrator assigns a security profile to said user terminal corresponding to said user-id; and

d. wherein said data ba se management system provides access to a particular one of said plurality of data columns within a particular one of said plurality of data tables of said data base by said user terminal if and only if said security profile corresponds to access to said particular one of said plurality of data columns within said particular one of said plurality of data tables.

7. The apparatus of claim 6 wherein said user terminal accesses said data column by transferring a service request to said data base management system.

8. The apparatus of claim 7 wherein said data base management system accesses said data base using a command language script.

9. The apparatus of claim 8 wherein said service request corresponds to said command language script.

10. The apparatus of claim 9 wherein said security profile corresponds to said command language script.

11. A method of utilizing a user terminal having a user-id to access a remote data base management system via a publically accessible digital data communication network having a data base with a plurality of data tables comprising:

a. defining a service request by an administrator via an administration terminal;

b. assigning a security profile to said service request;

c. transmitting said service request requiring access to a one of said plurality of data tables from said user terminal;

d. receiving said service request by said remote data base management system;

e. accessing said security profile corresponding to said service request by an administration module;

f. comparing said security profile with said user-id within said administration module; and

g. honoring said service request if and only if said user-id corresponds to said security profile.

12. A method according to claim 11 wherein said transmitting step further comprises transmitting said user-id.

13. A method according to claim 12 wherein said honoring step further comprises executing a command language script corresponding to said service request.

14. A method according to claim 13 wherein said comparing step further comprises accessing said security profile as corresponding to said command language script.

15. A method according to claim 14 wherein said remote data base management system further comprises Classic MAPPER data base management system.

16. An apparatus comprising:

a. means having a user-id for permitting a user to interact via a publically accessible digital data communication network with a data column within a data table of a digital data base having a plurality of data columns within a plurality of data tables using a service request;

b. means responsively coupled to said permitting means for offering data processing services involving access to said data column to said user in response to said service request;

c. means responsively coupled to said offering means for preventing said offering means from said offering data processing services to said user in response to said service request unless said user-id corresponds to a security profile previously defined by an administrator via an administration terminal wherein said security profile permits access to said data column.

17. An apparatus according to claim 16 wherein said offering means further comprises means for storing command language script corresponding to said service request.

18. An apparatus according to claim 17 wherein said storing means also stores said security profile.

19. An apparatus according to claim 18 wherein said offering means further comprises Classic MAPPER data base management system.

20. An apparatus according to claim 19 wherein said permitting means further comprises an industry standard personal computer.