Patent CH255443A successfully refreshed from Google Patents.
Patent US3851141A successfully refreshed from Google Patents.
Patent US5740423A successfully refreshed from Google Patents.
← Back to Patent Explorer
US5740423A Expired / Lapsed US ⏱️ 0.0 years remaining

System and method for accessing distributed data on a plurality of databases

Assignee: CSG Systems Inc
•
Filing: 1995-12-28
•
Granted: 1998-04-14
•
Expires: 2015-12-28
📄 Original PDF 🌐 Google Patents 🔄 Sync Now

Abstract

Abstract A system for accessing data distributed on databases in an integrated computer system includes a distributed data port, which initiates a XRef server query, generates a virtual table having a first result set including at least one data row responsive to the XRef server query, initiates Populate queries each having one of the data rows as an argument, and updates the virtual table with data responsive to the Populate queries. The system also includes a XRef server, which receives the XRef server query from the distributed data port and identifies at least one of the databases having a data row responsive to the XRef server query. A temporary virtual table relays each Populate query to a data directory server, and the data directory server is linked to each of the databases. It locates at least one of the databases having data responsive to the XRef server query and the Populate query, retrieves that data, and transmits data responsive to said XRef query to the distributed data port and data responsive to the Populate query to a temporary virtual table. The temporary virtual table populates each data row of the result set with data responsive to the Populate query and transmits the populated data row to the distributed data port to update the virtual table.

Inventors

  • 👤 James Richard Logan
  • 👤 Kurt Deshazer

Bibliographic Details

Application Number —
Jurisdiction US
Data Source google_patents
Last Synchronized 2026-10-30 20:24
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/24; G06F16/245; G06F16/2458; G06F16/2471; G06F16/25; G06F16/256; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934

Claims Analysis

Total Claims: 10
Claim 1
Independent Claim 96 words
A method for accessing data distributed on a plurality of databases, comprising the steps of: initiating a cross-reference server query that retrieves at least one cross-reference data row; generating a virtual table having a first result set including said at least one cross-reference data row; initiating at least one populate query having each of said at least one cross-reference data rows as an argument; generating a temporary virtual table that populates each cross-reference data row of said result set with data responsive to said populate query; and updating said virtual table with said populated data row.
Claim 2
Independent Claim 96 words
A method for accessing data distributed on a plurality of databases, comprising the steps of: initiating a cross-reference server query that retrieves at least one cross-reference data row; generating a virtual table having a first result set including said at least one cross-reference data row; initiating at least one populate query having each of said at least one cross-reference data rows as an argument; generating a temporary virtual table that populates each cross-reference data row of said result set with data responsive to said populate query; and updating said virtual table with said populated data row.
Claim 3
Dependent Claim 15 words
The method of claim 1, wherein said populate query defines a single distributed data set.
Claim 4
Dependent Claim 13 words
The system of claim 1, further comprising means for displaying said virtual table.
Claim 5
Dependent Claim 15 words
The method of claim 1, further comprising the step of ordering said cross-reference data rows.
Claim 6
Independent Claim 260 words
A system for accessing data distributed on a plurality of databases in an integrated computer system, comprising: a plurality of databases; a distributed data port, which (1) initiates a cross-reference server query, (2) generates a virtual table having a first result set including at least one cross-reference data row responsive to said cross-reference server query, (3) initiates at least one populate query each having one of said at least one data rows as an argument, and (4) updates said virtual table with data responsive to said at least one populate query; a cross-reference server, which receives said cross-reference server query from said distributed data port, identifies at least one of said plurality of databases having at least one of said data rows, and transmits said cross-reference server query to a data directory server; and a temporary virtual table, which relays each of said at least one populate queries to said data directory server; wherein said data directory server is linked to each of said plurality of databases, locates at least one of said plurality of databases having data responsive to said cross-reference server query and said populate query, retrieves said data, and transmits data responsive to said cross-reference server query to said distributed data port and data responsive to said populate query to a temporary virtual table; and wherein said temporary virtual table populates each of said at least one cross-reference data rows of said result set with data responsive to said populate query and transmits said populated data row to said distributed data port to update said virtual table.
Claim 7
Independent Claim 260 words
A system for accessing data distributed on a plurality of databases in an integrated computer system, comprising: a plurality of databases; a distributed data port, which (1) initiates a cross-reference server query, (2) generates a virtual table having a first result set including at least one cross-reference data row responsive to said cross-reference server query, (3) initiates at least one populate query each having one of said at least one data rows as an argument, and (4) updates said virtual table with data responsive to said at least one populate query; a cross-reference server, which receives said cross-reference server query from said distributed data port, identifies at least one of said plurality of databases having at least one of said data rows, and transmits said cross-reference server query to a data directory server; and a temporary virtual table, which relays each of said at least one populate queries to said data directory server; wherein said data directory server is linked to each of said plurality of databases, locates at least one of said plurality of databases having data responsive to said cross-reference server query and said populate query, retrieves said data, and transmits data responsive to said cross-reference server query to said distributed data port and data responsive to said populate query to a temporary virtual table; and wherein said temporary virtual table populates each of said at least one cross-reference data rows of said result set with data responsive to said populate query and transmits said populated data row to said distributed data port to update said virtual table.
Claim 8
Dependent Claim 15 words
The system of claim 5, wherein said populate query defines a single distributed data set.
Claim 9
Dependent Claim 30 words
The system of claim 5, wherein said distributed data port includes a orders said at least one data rows according to a comparison code using a generic library sorting method.
Claim 10
Dependent Claim 13 words
The system of claim 5, further comprising means for displaying said virtual table.

References Cited (Backward Citations)

US4731734A Cited
US4811207A Cited
US5012405A Cited
US5276870A Cited
US4864497A Cited
US5325290A Cited
US5513348A Cited
US5361349A Cited
US5263167A Cited
US5446886A Cited
US5515531A Cited
US5581758A Cited
US5551027A Cited

USPTO Annuity & Maintenance Windows

Annuity Stage Window Opens Payment Deadline Surcharge Period Until Estimated Fee Status
3.5 Years (Year 4) 2001-04-13 2001-10-13 2002-04-14 $2000.00 Window Closed / Lapsed
7.5 Years (Year 8) 2005-04-13 2005-10-13 2006-04-14 $3760.00 Window Closed / Lapsed
11.5 Years (Year 12) 2009-04-13 2009-10-13 2010-04-14 $7700.00 Window Closed / Lapsed

Assigned Categories & Tags

No categories assigned to this patent yet.

Assign Category Tag