Client/server computer system having personalizable and securable views of database data
First Claim
1. A method for managing access to data in a database, the database residing on a computer system, the computer system including a server system and one or more client systems, the method comprising the steps:
- when a user signs on to the computer system from one of the one or more client systems, verifying the user by the steps including;
identifying the user; and
associating a profile with the user, wherein the profile is unique to the user and contains meta data providing for the user a plurality of programmable views of and mappings to elements of the database, the profile residing on the server system;
retrieving a subset of the meta data according to the profile;
modifying an interface for the user in an application executing on the client based on the subset of the meta data;
generating a data request based on the subset of the meta data;
translating the data request on the client system according to the contents of the profile;
creating a data results set on the server system by servicing the translated data request on the server system;
translating the data results set on the client system according to the contents of the profile to generate a translated data results set; and
displaying the translated data results set on a display device of the client system.
9 Assignments
0 Petitions
Accused Products
Abstract
A client/server computer system having personalizable views of database data. The personalizable views programmed in client profiles which are customized for each client in the client/server computer system. The client/server computer system featuring a translator for converting client application database input and output requests into native database commands. The translator also supporting processing functions on data both retrieved from the database and stored to the database according to each individual client profile. The client/server computer system also supporting a hierarchy of preprogrammable group profiles which may be assigned to a group of clients. The client/server system also providing a security function for database data without modifying either the client applications executing on each client terminal or the native database.
-
Citations
8 Claims
-
1. A method for managing access to data in a database, the database residing on a computer system, the computer system including a server system and one or more client systems, the method comprising the steps:
-
when a user signs on to the computer system from one of the one or more client systems, verifying the user by the steps including; identifying the user; and associating a profile with the user, wherein the profile is unique to the user and contains meta data providing for the user a plurality of programmable views of and mappings to elements of the database, the profile residing on the server system; retrieving a subset of the meta data according to the profile; modifying an interface for the user in an application executing on the client based on the subset of the meta data; generating a data request based on the subset of the meta data; translating the data request on the client system according to the contents of the profile; creating a data results set on the server system by servicing the translated data request on the server system; translating the data results set on the client system according to the contents of the profile to generate a translated data results set; and displaying the translated data results set on a display device of the client system. - View Dependent Claims (2)
-
-
3. A system for managing access to data in a database, the database residing on a computer system, the computer system comprising at least one server system and one or more client systems connected to the at least one server system, the system comprising:
-
a plurality of profiles, each profile created for one of a plurality of users including personalizable meta data for controlling access to the data in the database; a first portion executing on the server, for identifying each user signing onto the server system and for associating a profile with each user signing onto the server system; a second portion executing on each client system for retrieving a subset of each profile associated with each user signing onto the server system; an application executing on each client system for creating a data request based on each of the subsets, the application using the subsets to configure user interfaces for each user; a third portion executing on each client system for translating the data request based on each profile and for transmitting a translated data request to the server system; a fourth portion executing on the server system for servicing the translated data request and transmitting a result to the client system making the translated data request; and a fifth portion executing on each client system processing the result according to the profile of each user of each client system. - View Dependent Claims (4, 5)
-
-
6. A system for managing access to data in a database, the database residing on a computer system, the computer system comprising at least one server system and one or more client systems connected to the at least one server system, the system comprising:
-
a plurality of profiles, each profile created for one of a plurality of users including personalizable meta data for controlling access to the data in the database; a server program executing on the server, the server program identifying each user signing onto the server system and for associating a profile with each user signing onto the server system, the server program processing translated data requests from the one or more client systems and transmitting a result to each of the one or more client systems issuing the translated data requests; and for each client system of the plurality of client systems; an application executing on each client system, the application creating a data request based on profile meta data, the application using the profile meta data to configure user interfaces for each user; and a client program executing on each client system, the client program; retrieving a subset of each profile associated with each user signing onto the server system; translating the data request by the application based on each profile; transmitting a translated data request to the server system; and processing the result according to the profile of each user for each client system. - View Dependent Claims (7, 8)
-
Specification