US6275939B1 — System and method for securely accessing a databa…

Claim 1

Independent Claim 212 words

A system for preventing unauthorized access of database systems, comprising: a client configured to maintain a list of coded expressions, said client configured to display a plurality of options to a user and to enable said user to select one of said options, said client further configured to correlate one of said coded expressions with said one option selected by said user and to transmit said one coded expression to said first server; a database configured to receive a query, to retrieve data based on said query, and to transmit said retrieved data; and a first server configured to maintain said list of coded expressions, to receive said one coded expression from said client, to translate said one coded expression into said query, to transmit said query to said database, to receive said data transmitted from said database, to encrypt said data received from said database, and to transmit said encrypted data to said client, wherein said first server, in translating said one coded expression into said query, is configured to correlate said one coded expression with query data based on said list, to retrieve said query data correlated with said one coded expression in response to said one coded expression, and to form said query based on said retrieved query data.

Claim 2

Independent Claim 212 words

A system for preventing unauthorized access of database systems, comprising: a client configured to maintain a list of coded expressions, said client configured to display a plurality of options to a user and to enable said user to select one of said options, said client further configured to correlate one of said coded expressions with said one option selected by said user and to transmit said one coded expression to said first server; a database configured to receive a query, to retrieve data based on said query, and to transmit said retrieved data; and a first server configured to maintain said list of coded expressions, to receive said one coded expression from said client, to translate said one coded expression into said query, to transmit said query to said database, to receive said data transmitted from said database, to encrypt said data received from said database, and to transmit said encrypted data to said client, wherein said first server, in translating said one coded expression into said query, is configured to correlate said one coded expression with query data based on said list, to retrieve said query data correlated with said one coded expression in response to said one coded expression, and to form said query based on said retrieved query data.

Claim 3

Dependent Claim 16 words

The system of claim 1 , wherein said query is a structured query language (SQL) query.

Claim 4

Dependent Claim 33 words

The system of claim 1 , wherein said database is located at a premises of said first server and said client is located remotely from said first server across an unsecure communications link.

Claim 5

Dependent Claim 61 words

The system of claim 1 , wherein said first server is configured to encrypt said data received from said database with a new encryption key transmitted to said client from said first server in response to said client establishing a data session with said first server, wherein said first server transmits said encrypted data to said client during said data session.

Claim 6

Dependent Claim 45 words

The system of claim 1 , wherein said client is configured to transmit a password to said first server, and wherein said first server is configured to translate said password into an alias password and to utilize said alias password to access to said database.

Claim 7

Dependent Claim 68 words

The system of claim 1 , wherein said data retrieved by said database is stored within a column of a data table in said database, and wherein said first server is further configured to determine whether said data retrieved by said database is accessible to said client based on predefined security information stored in said first server, to discard data determined to be inaccessible by said first server.

Claim 8

Dependent Claim 121 words

The system of claim 1 , wherein said first server is further configured to transmit a request for data based on said coded expression transmitted from said client and wherein said system further comprises: a remote database configured to receive a second query, to retrieve data associated with said request for data based on said second query, and to transmit said data associated with said request for data; and a remote server configured to receive said request for data, to translate said request for data into said second query, to receive said data transmitted from said remote database, to encrypt said data received from said remote database, and to transmit said data received from said remote database to said first server.

Claim 9

Dependent Claim 89 words

The system of claim 1 , further comprising: a second database configured to receive a second query, to retrieve data associated with said one coded expression based on said second query, and to transmit said data retrieved by said second database, wherein said first server is further configured to translate said one coded expression into said second query, to receive said data transmitted from said second database, to encrypt said data retrieved from said second database, and to transmit said data retrieved from said second database to said client.

Claim 10

Dependent Claim 17 words

The system of claim 7 , wherein said second query is a structured query language (SQL) query.

Claim 11

Dependent Claim 16 words

The system of claim 8 , wherein said first server transmits said queries via different protocols.

Claim 12

Independent Claim 193 words

A system for preventing unauthorized access of database systems, comprising: means for establishing a communication session between a client computer and a server computer; means for maintaining a list of coded expressions at said client computer; means for maintaining said list of coded expressions at said server computer; means for displaying a plurality of options to a user of said client computer; means for enabling said user to select one of said options; means for coffelating said one option selected by said user with one of said coded expressions; means for transmitting said one coded expression from said client computer; means for receiving said one coded expression at said first server computer; means for correlating said one coded expression with query data; means for retrieving said query data in response to said one coded expression received by said receiving means; means for forming a query with said retrieved query data; means for querying a database with said query; means for retrieving data from said database based on said query; means for encrypting said data retrieved from said database; and means for transmitting said data encrypted by said encrypting means to said client computer.

Claim 13

Independent Claim 193 words

A system for preventing unauthorized access of database systems, comprising: means for establishing a communication session between a client computer and a server computer; means for maintaining a list of coded expressions at said client computer; means for maintaining said list of coded expressions at said server computer; means for displaying a plurality of options to a user of said client computer; means for enabling said user to select one of said options; means for coffelating said one option selected by said user with one of said coded expressions; means for transmitting said one coded expression from said client computer; means for receiving said one coded expression at said first server computer; means for correlating said one coded expression with query data; means for retrieving said query data in response to said one coded expression received by said receiving means; means for forming a query with said retrieved query data; means for querying a database with said query; means for retrieving data from said database based on said query; means for encrypting said data retrieved from said database; and means for transmitting said data encrypted by said encrypting means to said client computer.

Claim 14

Dependent Claim 16 words

The system of claim 11 , wherein said query is a structured query language (SQL) query.

Claim 15

Dependent Claim 66 words

The system of claim 11 , further comprising: means for transmitting a new encryption key from said first server computer to said client computer in response to said communication session; means for encrypting said one coded expression at said client computer with said new encryption key; and means for encrypting said data retrieved from said database with said new encryption key at said first server computer.

Claim 16

Dependent Claim 41 words

The system of claim 11 , further comprising: means for transmitting a password from said client computer to said first server computer; means for translating said password into a different password; and means for accessing said database via said different password.

Claim 17

Dependent Claim 99 words

The system of claim 11 , further comprising: means for retrieving information from a column of a table within said database in response to said one coded expression; means for analyzing said information at said server to determine whether said information includes inaccessible data; means for discarding said inaccessible data at said first server computer; and means for transmitting a remainder of said information from said first server computer to said client computer, wherein said remainder of said information includes information form a row in said column and said inaccessible data includes information form another row in said column.

Claim 18

Dependent Claim 121 words

The system of claim 11 , further comprising: means for creating a request for data based on said one coded expression at said first server computer; means for transmitting said request for data to a remote server computer; means for translating said request for data at said remote server computer into a second query; means for querying a remote database with said second query; means for retrieving remote data from said remote database based on said second query; means for encrypting said remote data retrieved from said remote database; means for transmitting said remote data from said remote server computer to said first server computer; and means for transmitting said remote data from said first server computer to said client computer.

Claim 19

Dependent Claim 17 words

The system of claim 16 , wherein said second query is a structured query language (SQL) query.

Claim 20

Independent Claim 182 words

A method for preventing unauthorized access of a database systems, comprising the steps of: establishing communication between a client computer and a first server computer; maintaining a list of coded expressions at said client computer; maintaining said list of coded expressions at said server computer; displaying a plurality of options to a user of said client computer; enabling said user to select one of said options; correlating said one option selected by said user with one of said coded expressions; transmitting, in response to said correlating said one option step said one coded expression from said client computer; receiving said one coded expression at said first server computer; subsequent to said receiving step, correlating said one coded expression with query data; retrieving, in response to said correlating said one coded expression step, said query data; forming a query with said retrieved query data; querying a database with said query; retrieving data from said database based on said query; encrypting said data retrieved from said database at said first server computer; and transmitting said data retrieved from said database to said client computer.

Claim 21

Independent Claim 182 words

A method for preventing unauthorized access of a database systems, comprising the steps of: establishing communication between a client computer and a first server computer; maintaining a list of coded expressions at said client computer; maintaining said list of coded expressions at said server computer; displaying a plurality of options to a user of said client computer; enabling said user to select one of said options; correlating said one option selected by said user with one of said coded expressions; transmitting, in response to said correlating said one option step said one coded expression from said client computer; receiving said one coded expression at said first server computer; subsequent to said receiving step, correlating said one coded expression with query data; retrieving, in response to said correlating said one coded expression step, said query data; forming a query with said retrieved query data; querying a database with said query; retrieving data from said database based on said query; encrypting said data retrieved from said database at said first server computer; and transmitting said data retrieved from said database to said client computer.

Claim 22

Dependent Claim 16 words

The method of claim 18 , wherein said query is a structured query language (SQL) query.

Claim 23

Dependent Claim 63 words

The method of claim 18 , further comprising the steps of: transmitting a new encryption key from said first server computer to said client computer in response to said establishing step; encrypting said one coded expression at said client computer with said new encryption key; and encrypting said data retrieved from said database with said new encryption key at said first server computer.

Claim 24

Dependent Claim 38 words

The method of claim 18 , further comprising the steps of: transmitting a password from said client computer to said first server computer; translating said password into a different password; and accessing said database via said different password.

Claim 25

Dependent Claim 99 words

The method of claim 18 , further comprising the steps of: retrieving information from a column of a table within said database in response to said one coded expression; analyzing said information at said server to determine whether said information includes inaccessible data; discarding said inaccessible data at said first server computer; and subsequent to said discarding step, transmitting a remainder of said information from said first server computer to said client computer, wherein said remainder of said information includes information from a row in said column and said inaccessible data includes information from another row in said column.

Claim 26

Dependent Claim 109 words

The method of claim 18 , further comprising the steps of: creating a request for data based on said one coded expression at said first server computer; transmitting said request for data to a remote server computer; translating said request for data at said remote server computer into a second query; querying a remote database with said second query; retrieving remote data from said remote database based on said second query; encrypting said remote data retrieved from said remote database; transmitting said remote data from said remote server computer to said first server computer; and transmitting said remote data to from said first server computer to said client computer.

Claim 27

Dependent Claim 17 words

The method of claim 23 , wherein said second query is a structured query language (SQL) query.

Claim 28

Dependent Claim 28 words

The system of claim 1 , wherein said client is further configured to encrypt said one coded expression before transmitting said one coded expression to said first server.

Claim 29

Dependent Claim 20 words

The system of claim 11 , wherein said client computer further comprises a means for encypting said one coded expression.

Claim 30

Dependent Claim 20 words

The method of claim 18 , further comprising the step of encrypting said one coded expression at said client computer.

Claim 31

Independent Claim 134 words

A method for preventing unauthorized access of database systems, comprising the steps of: establishing communication between a client computer and a first server computer; maintaining a list of coded expressions at said client computer; displaying a plurality of options to a user of said client computer; enabling said user to select one of said options; correlating said one option selected by said user with one of said coded expressions; transmitting said one coded expression from said client computer in response to said correlating step; receiving said one coded expression at said first server computer; subsequent to said receiving step, translating said one coded expression into a query; querying a database with said query; retrieving data from said database based on said query; and transmitting said data retrieved from said database to said client computer.

Claim 32

Independent Claim 134 words

A method for preventing unauthorized access of database systems, comprising the steps of: establishing communication between a client computer and a first server computer; maintaining a list of coded expressions at said client computer; displaying a plurality of options to a user of said client computer; enabling said user to select one of said options; correlating said one option selected by said user with one of said coded expressions; transmitting said one coded expression from said client computer in response to said correlating step; receiving said one coded expression at said first server computer; subsequent to said receiving step, translating said one coded expression into a query; querying a database with said query; retrieving data from said database based on said query; and transmitting said data retrieved from said database to said client computer.

Claim 33

Dependent Claim 20 words

The method of claim 28 , further comprising the step of encrypting said one coded expression at said client computer.

Annuity Stage	Window Opens	Payment Deadline	Surcharge Period Until	Estimated Fee	Status
3.5 Years (Year 4)	2004-08-13	2005-02-12	2005-08-14	$2000.00	Window Closed / Lapsed
7.5 Years (Year 8)	2008-08-13	2009-02-12	2009-08-14	$3760.00	Window Closed / Lapsed
11.5 Years (Year 12)	2012-08-13	2013-02-12	2013-08-14	$7700.00	Window Closed / Lapsed

System and method for securely accessing a database from a remote location

Abstract

Inventors

Bibliographic Details

Claims Analysis

References Cited (Backward Citations)

USPTO Annuity & Maintenance Windows

Assigned Categories & Tags

Assign Category Tag