US6065002A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Simplified interface for relational database access using open database connectivity
Assignee: Ellucian Co LLC
•
Filing: 1996-10-31
•
Granted: 2000-05-16
•
Expires: 2016-10-31
Abstract
Abstract A user interface is provided to a relational database to provide simplified data access for users. A user input/output device interacts with an application tool accessible via a computer. A template accessible to the application tool via an API or native interface provides a selection of attributes corresponding to a particular category. The attributes specify information obtainable from data stored in the relational database and are selectable using the application tool. The template is responsive to attributes selected using the application tool, for retrieving data from the relational database and forwarding the data to the application tool via the API or native interface. The template is independent of the application tool, thereby enabling the user interface to access information from the relational database using any of a plurality of different application tools. Functions are also provided for use in calculating complex attributes from data contained in the database, where the complex attribute is not itself contained in the database.
Inventors
- 👤 James Brian Knotts
- 👤 Robert Lynn Bailey
- 👤 Michael Fleming Clouser
- 👤 Robert Eric Marsilio
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-29 03:20
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/25; G06F16/252; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99933; Y10S707/99934
Claims Analysis
Total Claims: 14
Claim 1
Independent Claim
225 words
An open database connectivity (ODBC) compliant system for accessing data from a relational database, comprising: user input/output device for interacting with an ODBC compliant application tool accessible via a computer; an ODBC interface; an ODBC compliant template for simplifying access to complex data stored in said relational database, said template being accessible to said application tool via said ODBC interface for enabling user selection of attributes corresponding to a particular category, said attributes specifying information obtainable from data stored in said relational database and being selectable using said application tool; said ODBC compliant template being responsive to selected attributes received from said application tool via said ODBC interface, for retrieving data from said relational database and forwarding said data to said application tool via said ODBC interface for use in generating an output; wherein: said ODBC compliant template is independent of said application tool, thereby enabling a user to access information from said relational database using any one of a plurality of different application tools; and said template (i) directly accesses attributes selected via said application tool when the selected attributes are stored in the database or (ii) when the selected attributes are not stored in the database, enables complex attributes selected via said application tool to be calculated via selectively executable algorithms by obtaining data from said database that is required by said algorithms.
Claim 2
Dependent Claim
225 words
An open database connectivity (ODBC) compliant system for accessing data from a relational database, comprising: user input/output device for interacting with an ODBC compliant application tool accessible via a computer; an ODBC interface; an ODBC compliant template for simplifying access to complex data stored in said relational database, said template being accessible to said application tool via said ODBC interface for enabling user selection of attributes corresponding to a particular category, said attributes specifying information obtainable from data stored in said relational database and being selectable using said application tool; said ODBC compliant template being responsive to selected attributes received from said application tool via said ODBC interface, for retrieving data from said relational database and forwarding said data to said application tool via said ODBC interface for use in generating an output; wherein: said ODBC compliant template is independent of said application tool, thereby enabling a user to access information from said relational database using any one of a plurality of different application tools; and said template (i) directly accesses attributes selected via said application tool when the selected attributes are stored in the database or (ii) when the selected attributes are not stored in the database, enables complex attributes selected via said application tool to be calculated via selectively executable algorithms by obtaining data from said database that is required by said algorithms.
Claim 3
Dependent Claim
44 words
An ODBC compliant system in accordance with claim 1 comprising a plurality of different ODBC compliant templates, each providing a set of attributes corresponding to a different category, said attributes specifying information obtainable from data stored in said relational database for their associated category.
Claim 4
Dependent Claim
31 words
An ODBC compliant system in accordance with claim 2 wherein said ODBC interface comprises an application program interface (API) for allowing said application tool, said templates, and said database to communicate.
Claim 5
Dependent Claim
44 words
An ODBC compliant system in accordance with claim 1 comprising a plurality of different ODBC compliant templates, each providing a set of attributes corresponding to a different category, said attributes specifying information obtainable from data stored in said relational database for their associated category.
Claim 6
Dependent Claim
32 words
An ODBC compliant system in accordance with claim 1 wherein said application tool includes at least one of a report writer, statistical analysis tool, spreadsheet and desktop tool that is ODBC compliant.
Claim 7
Dependent Claim
31 words
An ODBC compliant system in accordance with claim 1 wherein said ODBC interface comprises an application program interface (API) for allowing said application tool, said templates, and said database to communicate.
Claim 8
Dependent Claim
28 words
An ODBC compliant system in accordance with claim 1 wherein said template requires a user to designate, via said application tool, information for at least one mandatory condition.
Claim 9
Dependent Claim
31 words
An ODBC compliant system in accordance with claim 1 wherein said application tool is provided with direct access to said database in addition to access to said database via said template.
Claim 10
Dependent Claim
62 words
An ODBC compliant system in accordance with claim 8 wherein: said application tool and said template are ODBC compliant; and data obtained by said application tool directly from said database and data obtained by said application tool via said template are able to be combined due to the ODBC compliant nature of said tool and template for use in generating said output.
Claim 11
Dependent Claim
23 words
An ODBC compliant system in accordance with claim 1 further comprising means for enabling a user to specify properties for customizing said template.
Claim 12
Dependent Claim
18 words
An ODBC compliant system in accordance with claim 10 wherein said properties are specified using said application tool.
Claim 13
Dependent Claim
29 words
An ODBC compliant system in accordance with claim 1 wherein said template comprises: a meta layer that dynamically converts data from said relational database into a simplified conceptual format.
Claim 14
Dependent Claim
30 words
An ODBC compliant system in accordance with claim 12 wherein said simplified conceptual format is a format that avoids the complexity of relationships within the structure of said relational database.
References Cited (Backward Citations)
US5263167A
Cited
US5555403A
Cited
US5404518A
Cited
US5426781A
Cited
US5418950A
Cited
US5423033A
Cited
US5608899A
Cited
US5550971A
Cited
US5617528A
Cited
US5584024A
Cited
US5752027A
Cited
US5832496A
Cited
US5664173A
Cited
US5878411A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2003-05-16 | 2003-11-15 | 2004-05-16 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2007-05-16 | 2007-11-15 | 2008-05-16 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2011-05-16 | 2011-11-15 | 2012-05-16 | $7700.00 | Window Closed / Lapsed |