Method and apparatus for translating variable names to column names for ...

(54) METHOD AND APPARATUS FOR

TRANSLATING VARIABLE NAMES TO
COLUMN NAMES FOR ACCESSING A
DATABASE

(75) Inventor: Russell C. Brown, Austin, TX (US)

(73) Assignee: Advanced Micro Devices, Inc.,

Houston, TX (US)

( * ) Notice: Subject to any disclaimer, the term ol this patent is extended or adjusted under 35 U.S.C. 154(b) by 0 days.

(21)

(22)

(51) (52)

(58)

(56)

Appl. No.: 09/219,053
Filed: Dec. 23, 1998

Int. CI.7 G06F 17/30

U.S. CI 707/2; 707/2; 707/4; 707/104;

704/7; 717/1

Field of Search 707/1-5, 9, 102,

707/203, 104; 704/7; 706/45, 922; 710/20;

711/20, 150, 216; 717/1

References Cited

U.S. PATENT DOCUMENTS

5,418,950 * 5/1995 Li et al 707/4

5.584,026 * 12/1996 Knudsen et al 707/1

5,594,899 * 1/1997 Knudsen et al 707/2

5,596,752 * 1/1997 Knudsen et al 707/1

5,682,535 * 10/1997 Knudsen 717/1

5,734,887 * 3/1998 Kingberg et al 707/4

5.761,672 * 6/1998 Samuelsson et al 707/104

5,774,692 * 6/1998 Boyer et al 707/3

5,794,229 * 8/1998 French et al 707/2

5,812,840 * 9/1998 Shwartz 707/4

5,893,087 * 4/1999 Wlaschin et al 707/3

5,937,402 * 8/1999 Pandit 707/4

6,161,103 * 12/2000 Rauer et al 707/4

OTHER PUBLICATIONS

Sullivan, Joan, "SQL Test Suite Goes Online", Software Diagnostics & Conformance Testing Div., US NIST, Computer, vol. 30, Issue: 6, Jun. 1997, pp. 103, 105.* Bansal, Arvind K. et al., "Data-parallel Compilation and Query Power Extension ol Large Knowledge Bases", Proceedings ol the Fourth International Conlerence on Tools with Artificial Intelligence, 1992, TAI '92, Nov. 10-13, 1992, pp. 276-283.*

* cited by examiner

Primary Examiner—Hosain T. Alam
Assistant Examiner—Shahid Alam

(74) Attorney, Agent, or Firm—-Williams, Morgan & Amerson, PC.

(57) ABSTRACT

A method for accessing a database is provided. The database includes an information table. The method includes providing an alias table. The alias table includes a plurality ol variable names and a plurality ol column names. Each column name is associated with one ol the plurality ol variable names. A message is received. The message includes at least a first variable name. The alias table is accessed based on the first variable name to identily a first column name associated with the first variable name. The information table is accessed based on the first column name.

25 Claims, 4 Drawing Sheets