Patent US5937415A successfully refreshed from Google Patents.
US5937415A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Data base development system with methods facilitating copying of data from one data source to another
Assignee: Sybase Inc
•
Filing: 1996-12-11
•
Granted: 1999-08-10
•
Expires: 2016-12-11
Abstract
Abstract A Client/Server Database System with improved methods for performing database queries, particularly DSS-type queries, is described. The system includes one or more Clients (e.g., Terminals or PCs) connected via a Network to a Server. In general operation, Clients store data in and retrieve data from one or more database tables resident on the Server by submitting SQL commands, some of which specify "queries"--criteria for selecting particular records of a table. The system implements a "Data Pipeline" feature for programming replication of data from one database to another in client applications. Specifically, a pipeline object and SQL SELECT statement are built using a Pipeline Painter. The Data Pipeline lets a user (developer) easily move data from a high-end database server (e.g., Sybase) to a local database (Watcom SQL), all without the user having to issue SQL commands. The pipeline object facilitates moving data from one database management system to another, or between databases of the same type.
Inventors
- 👤 Kim A. Sheffield
- 👤 Alan L. Preston
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-05 23:17
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/284; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934; Y10S707/99941; Y10S707/99943; Y10S707/99951; Y10S707/99952; Y10S707/99955
Claims Analysis
Total Claims: 10
Claim 1
Independent Claim
151 words
A method for copying data from one data source to another, the method comprising: selecting source and destination database profiles for source and destination data sources, respectively, each profile comprising sufficient information for supporting a connection to a respective one of the source and destination data sources; establishing a connection to said source and destination data sources; displaying a graphical user interface for graphically defining a pipeline object, said pipeline object specifying particular data to copy from the source data source to the destination data source; saving said pipeline object to a storage device, so that it can be executed upon invocation; and copying data from the source data to the destination data by executing said pipeline object; wherein displaying a graphical user interface step includes: receiving user input for graphically creating a SQL SELECT statement which specifies the data to be copied from the source data to the destination data.
Claim 2
Independent Claim
151 words
A method for copying data from one data source to another, the method comprising: selecting source and destination database profiles for source and destination data sources, respectively, each profile comprising sufficient information for supporting a connection to a respective one of the source and destination data sources; establishing a connection to said source and destination data sources; displaying a graphical user interface for graphically defining a pipeline object, said pipeline object specifying particular data to copy from the source data source to the destination data source; saving said pipeline object to a storage device, so that it can be executed upon invocation; and copying data from the source data to the destination data by executing said pipeline object; wherein displaying a graphical user interface step includes: receiving user input for graphically creating a SQL SELECT statement which specifies the data to be copied from the source data to the destination data.
Claim 3
Dependent Claim
37 words
The method of claim 1, wherein displaying a graphical user interface step includes: specifying that copying of data from the source data source to the destination data source includes appending the data to the destination data source.
Claim 4
Dependent Claim
34 words
The method of claim 1, wherein displaying a graphical user interface step includes: specifying that copying of data from the source data source to the destination data source includes updating the destination data source.
Claim 5
Dependent Claim
39 words
The method of claim 1, wherein displaying a graphical user interface step includes: specifying that copying of data from the source data source to the destination data source includes creating a new database table at the destination data source.
Claim 6
Dependent Claim
18 words
The method of claim 1, wherein said pipeline object executes in response to invocation from a user-supplied script.
Claim 7
Dependent Claim
36 words
The method of claim 1, wherein said source data source comprises a first set of database tables and wherein said destination data source comprises a second set of database tables, each set residing on different servers.
Claim 8
Dependent Claim
19 words
The method of claim 1, wherein said data being copied comprises database rows selected from the source data source.
Claim 9
Dependent Claim
43 words
The method of claim 7, further comprising: determining error rows, said error rows comprising those rows, if any, selected from the source data source would, if copied, lead to errors in the destination data source; and foregoing any copying of such error rows.
Claim 10
Dependent Claim
39 words
The method of claim 8, further comprising: displaying a user interface dialog allowing an end user at runtime to perform a selected one of repairing some or all such error rows or abandoning some or all such error rows.
References Cited (Backward Citations)
US5121477A
Cited
US5420981A
Cited
US5179652A
Cited
US5204947A
Cited
US5293615A
Cited
US5148154A
Cited
US5566330A
Cited
US5396616A
Cited
US5701479A
Cited
US5560038A
Cited
US5655140A
Cited
US5664182A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-08-09 | 2003-02-08 | 2003-08-10 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-08-09 | 2007-02-08 | 2007-08-10 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-08-09 | 2011-02-08 | 2011-08-10 | $7700.00 | Window Closed / Lapsed |