US Patent No: 5,379,419
Number of patents in Portfolio can not be more than 2000
Methods and apparatus for accesssing non-relational data files using relational queries
Stats
-
Jan 3, 1995
Issued date -
Dec 7, 1990
filing date -
07/623,762
serial no -
Expired
status
Importance
Loading Importance Indicators...
Overall
|
US Family Size
|
International Coverage
|
Patent Longevity
|
Forward Citations
|
Abstract
A relational data access facility allows relation-type queries to access data stored in non-relational data files by converting relational queries into a set of common commands which are sent to data drivers to obtain the data specified by those queries. The facility uses metadata which describes the organization of the data in the non-relational files, and examines the expressions in the relational queries to formulate an access plan for the data. The plan is formulated to reduce cost and promote efficiency.
Loading the Abstract Image...
First Claim
Related Publications
Loading Related Publications...
- 15 United States
- 10 France
- 8 Japan
- 7 China
- 5 Korea
- 2 Other
Patent Owner(s)
| Patent Owner | Address | Total Patents |
|---|---|---|
| HEWLETT-PACKARD DEVELOPMENT COMPANY, L.P. | HOUSTON, TX | 25733 |
International Classification(s)
- [Classification Symbol]
- [Patents Count]
Inventor(s)
| Inventor Name | Address | # of filed Patents | Total Citations |
|---|---|---|---|
| Heffernan, John S | Acton, MA | 1 | 162 |
| Pittman, Steven J | Arlington, MA | 1 | 162 |
| Savage, Peter L | Mont Vernon, NH | 3 | 178 |
| Sunkara, Ramu V | Reading, MA | 4 | 261 |
Cited Art
| Patent Info | (Count) | # Cites | Year |
|---|---|---|---|
|
|
|||
| 4,829,427 Database query code generation and optimization based on the cost of alternate access methods | 112 | 1984 | |
|
|
|||
| 5,091,852 System for optimizing query processing in a relational database | 137 | 1989 | |
|
|
|||
| 4,769,772 Automated query optimization method using both global and parallel local optimizations for materialization access planning for distributed databases | 240 | 1985 | |
|
|
|||
| 4,956,774 Data base optimizer using most frequency values statistics | 94 | 1988 | |
Patent Citation Ranking
Forward Cites
| Patent Info | (Count) | # Cites | Year |
|---|---|---|---|
|
|
|||
| 7,624,356 Task-sensitive methods and systems for displaying command sets | 12 | 2000 | |
| 7,415,672 System and method for designing electronic forms | 3 | 2003 | |
| 7,370,066 System and method for offline editing of data files | 19 | 2003 | |
| 7,913,159 System and method for real-time validation of structured data files | 11 | 2003 | |
| 7,516,145 System and method for incrementally transforming and rendering hierarchical data files | 4 | 2003 | |
| 7,581,177 Conversion of structured documents | 11 | 2003 | |
| 7,406,660 Mapping between structured data and a visual surface | 66 | 2003 | |
| 7,334,187 Electronic form aggregation | 11 | 2003 | |
| 7,451,392 Rendering an HTML electronic form by applying XSLT to XML using a solution | 70 | 2003 | |
| 7,376,673 Offline editing of XML files using a solution | 23 | 2003 | |
| 7,430,711 Systems and methods for editing XML documents | 13 | 2004 | |
| 7,318,063 Managing XML documents containing hierarchical database information | 5 | 2004 | |
| 7,496,837 Structural editing with schema awareness | 83 | 2004 | |
| 7,412,645 User interface for integrated spreadsheets and word processing tables | 12 | 2004 | |
| 7,568,101 Digital signatures with an embedded view | 11 | 2004 | |
| 7,774,620 Executing applications at appropriate trust levels | 13 | 2004 | |
| 7,676,843 Executing applications at appropriate trust levels | 17 | 2004 | |
| 7,533,268 Digital signature with an embedded view | 12 | 2004 | |
| 7,712,048 Task-sensitive methods and systems for displaying command sets | 10 | 2004 | |
| 7,610,562 Task-sensitive methods and systems for displaying command sets | 14 | 2004 | |
| 7,512,896 Task-sensitive methods and systems for displaying command sets | 12 | 2004 | |
| 7,818,677 Single window navigation methods and systems | 19 | 2004 | |
| 7,779,027 Methods, systems, architectures and data structures for delivering software via a network | 12 | 2004 | |
| 7,673,227 User interface for integrated spreadsheets and word processing tables | 18 | 2004 | |
| 7,350,141 User interface for integrated spreadsheets and word processing tables | 37 | 2004 | |
| 7,392,522 Architectures for and methods of providing network-based software extensions | 11 | 2004 | |
| 7,692,636 Systems and methods for handwriting to a screen | 17 | 2004 | |
| 7,549,115 System and method for integrated spreadsheets and word processing tables | 26 | 2004 | |
| 7,506,242 System and method for integrating spreadsheets and word processing tables | 3 | 2004 | |
| 7,506,243 System and method for integrating spreadsheets and word processing tables | 1 | 2004 | |
| 7,712,022 Mutually exclusive options in electronic forms | 18 | 2004 | |
| 7,584,417 Role-dependent action for an electronic form | 27 | 2004 | |
| 7,721,190 Methods and systems for server side form processing | 17 | 2004 | |
| 7,509,353 Methods and systems for exchanging and rendering forms | 2 | 2004 | |
| 7,904,801 Recursive sections in electronic forms | 4 | 2004 | |
| 7,437,376 Scalable object model | 7 | 2004 | |
| 7,937,651 Structural editing operations for network forms | 7 | 2005 | |
| 7,743,063 Methods and systems for delivering software via a network | 12 | 2005 | |
| 7,689,929 Methods and systems of providing information to computer users | 17 | 2005 | |
| 7,346,610 Methods and systems of providing information to computer users | 35 | 2005 | |
| 7,725,834 Designer-created aspect for an electronic form template | 16 | 2005 | |
| 7,360,171 Methods and systems of providing information to computer users | 1 | 2005 | |
| 8,010,515 Query to an electronic form | 5 | 2005 | |
| 7,543,228 Template for rendering an electronic form | 27 | 2005 | |
| 8,200,975 Digital signatures for network forms | 2 | 2005 | |
| 7,613,996 Enabling selection of an inferred schema part | 25 | 2005 | |
| 7,979,856 Network-based software extensions | 6 | 2005 | |
| 8,001,459 Enabling electronic documents for limited-capability computing devices | 4 | 2005 | |
| 7,490,109 System and method for offline editing of data files | 19 | 2006 | |
| 7,900,134 Authoring arbitrary XML documents using DHTML and XSLT | 10 | 2006 | |
| 7,865,477 System and method for real-time validation of structured data files | 10 | 2007 | |
| 8,074,217 Methods and systems for delivering software | 6 | 2007 | |
| 7,971,139 Correlation, association, or correspondence of electronic forms | 6 | 2007 | |
| 7,925,621 Installing a solution | 9 | 2008 | |
| 7,933,916 Querying nonSQL data stores with a SQL-style language | 0 | 2008 | |
| 8,078,960 Rendering an HTML electronic form by applying XSLT to XML using a solution | 1 | 2008 | |
| 8,046,683 Structural editing with schema awareness | 2 | 2009 | |
| 8,429,522 Correlation, association, or correspondence of electronic forms | 0 | 2011 | |
|
|
|||
| 5,504,886 System and method for applying user supplied relation definitions to application files for a relational database | 27 | 1993 | |
| 5,664,171 System and method for query optimization using quantile values of a large unordered data set | 22 | 1994 | |
| 5,678,038 Storing and retrieving heterogeneous classification systems utilizing globally unique identifiers | 22 | 1994 | |
| 5,553,234 System and method for including stored procedures, user-defined functions, and trigger processing in an existing unit of work | 19 | 1994 | |
| 5,450,581 System for copying from one database management system to another by translating authorization statements | 46 | 1994 | |
| 5,850,544 System and method for efficient relational query generation and tuple-to-object translation in an object-relational gateway supporting class inheritance | 51 | 1995 | |
| 5,829,006 System and method for efficient relational query generation and tuple-to-object translation in an object-relational gateway supporting class inheritance | 29 | 1995 | |
| 5,689,633 Computer program product and program storage device for including stored procedure user defined function or trigger processing within a unit of work | 27 | 1995 | |
| 5,564,113 Computer program product for rendering relational database management system differences transparent | 26 | 1995 | |
| 5,761,678 Creation of clone storage area with identification of base storage area and deferred cloning of metadata | 88 | 1996 | |
| 5,764,979 Method for capturing and cataloging program characteristics for the usage of datastore persistent classes | 5 | 1996 | |
| 5,737,597 Method for cataloging datastore characteristics and defining and generating datastore persistent objects | 12 | 1996 | |
| 5,737,598 Method for capturing and cataloging specifications for datastore persistent classes | 4 | 1996 | |
| 5,765,159 System and method for generating an optimized set of relational queries for fetching data from a relational database management system in response to object queries received from an object oriented environment | 81 | 1997 | |
| 5,864,841 System and method for query optimization using quantile values of a large unordered data set | 19 | 1997 | |
| 6,058,394 Manager server selects an agent server to execute query based on availability of the server connections to data source and target | 24 | 1997 | |
| 5,995,973 Storing relationship tables identifying object relationships | 31 | 1997 | |
| 6,243,703 Method of accessing and displaying subsystem parameters including graphical plan table data | 13 | 1997 | |
| 6,128,622 IMS web studio taskguide | 21 | 1998 | |
| 6,223,184 Method for cataloging datastore characteristics and defining and generating datastore persistent objects | 10 | 1998 | |
| 6,108,658 Single pass space efficent system and method for generating approximate quantiles satisfying an apriori user-defined approximation error | 10 | 1998 | |
| 6,085,188 Method of hierarchical LDAP searching with relational tables | 127 | 1998 | |
| 6,529,914 Object-oriented programming model for accessing hierarchical databases | 16 | 1998 | |
| 6,360,229 Generic execution model for isolating applications from underlying databases | 6 | 1998 | |
| 6,202,069 Execution paradigm for accessing hierarchical data using an object framework | 8 | 1998 | |
| 6,128,619 Generating an internet application for accessing a hierarchical database | 32 | 1998 | |
| 6,141,660 Command line interface for creating business objects for accessing a hierarchical database | 89 | 1998 | |
| 6,356,892 Efficient implementation of lightweight directory access protocol (LDAP) search queries with structured query language (SQL) | 40 | 1998 | |
| 6,343,288 Single pass space efficient system and method for generating an approximate quantile in a data set having an unknown size | 5 | 1999 | |
| 6,502,088 Method and system for improved access to non-relational databases | 15 | 1999 | |
| 6,430,571 Multi-frame output form that facilitates internet search and update in a hierarchical database | 10 | 1999 | |
| 6,457,003 Methods, systems and computer program products for logical access of data sources utilizing standard relational database management systems | 29 | 1999 | |
| 6,604,096 Apparatus and method for locally caching query explain data | 10 | 2000 | |
| 7,058,620 Cross-platform subselect metadata extraction | 0 | 2000 | |
| 7,392,245 Direct call threaded code | 0 | 2000 | |
| 6,938,052 Access to server resources from heterogeneous platforms | 2 | 2000 | |
| 6,915,305 Restructuring view maintenance system and method | 18 | 2001 | |
| 8,001,242 Method for redirection of host data access to multiple non-host file systems or data stores | 0 | 2002 | |
| 7,610,300 Automated relational schema generation within a multidimensional enterprise software system | 1 | 2004 | |
| 7,593,955 Generation of aggregatable dimension information within a multidimensional enterprise software system | 0 | 2004 | |
| 7,505,888 Reporting model generation within a multidimensional enterprise software system | 1 | 2004 | |
| 7,418,438 Automated default dimension selection within a multidimensional enterprise software system | 3 | 2004 | |
| 7,933,891 Web services data aggregation system and method | 1 | 2007 | |
| 8,156,134 Using different groups of query graph transform modules to generate execution plans for queries for different database types | 0 | 2007 | |
| 7,974,968 Direct call threaded code | 0 | 2008 | |
| 8,131,533 Reporting model generation within a multidimensional enterprise software system | 0 | 2009 | |
|
|
|||
| 6,385,604 Relational database management system having integrated non-relational multi-dimensional data store of aggregated data elements | 120 | 2000 | |
| 7,392,248 Data aggregation server supporting rapid query response with sparse multi-dimensional data | 25 | 2002 | |
| 7,333,982 Information system having a mode of operation in which queries form one or more clients are serviced using aggregated data retrieved from a plurality of different types of data storage structures for improved query performance | 29 | 2002 | |
| 7,315,849 Enterprise-wide data-warehouse with integrated data aggregation engine | 35 | 2002 | |
| 8,195,602 Relational database management system (RDBMS) employing a relational datastore and a multi-dimensional database (MDDB) for serving query statements from client machines | 0 | 2009 | |
| 8,170,984 System with a data aggregation module generating aggregated data for responding to OLAP analysis queries in a user transparent manner | 1 | 2009 | |
| 8,041,670 Data aggregation module supporting dynamic query responsive aggregation during the servicing of database query requests provided by one or more client machines | 3 | 2010 | |
|
|
|||
| 5,675,779 Data processing system and method for maintaining cardinality in a relational database | 28 | 1995 | |
| 5,826,259 Easily expandable data processing system and method | 13 | 1997 | |
| RE40526 Data processing system and method for retrieving and entity specified in a search path record from a relational database | 0 | 2005 | |
| RE40520 Easily expandable data processing system and method | 1 | 2005 | |
| RE40235 Data processing system and method for detecting mandatory relations violation in a relational database | 16 | 2005 | |
|
|
|||
| 7,047,526 Generic command interface for multiple executable routines | 6 | 2000 | |
| 6,738,781 Generic command interface for multiple executable routines having character-based command tree | 11 | 2001 | |
| 6,611,216 Fast look-up table based scheme for NRZI encoding/decoding and zero insertion/removal in serial bit streams | 0 | 2001 | |
| 6,980,996 Generic command interface for multiple executable routines having character-based command tree | 1 | 2004 | |
|
|
|||
| 5,819,251 System and apparatus for storage retrieval and analysis of relational and non-relational data | 91 | 1996 | |
| 5,819,256 Method and apparatus for processing count statements in a database system | 19 | 1996 | |
| 6,377,943 Initial ordering of tables for database queries | 30 | 1999 | |
| 6,564,203 Defining instead-of triggers over nested collection columns of views | 12 | 2000 | |
|
|
|||
| 7,644,366 Method and system for displaying a plurality of discrete files in a compound file | 3 | 1999 | |
| 6,842,758 Modular method and system for performing database queries | 27 | 1999 | |
| 8,091,040 Method and system for displaying a plurality of discrete files in a compound file | 0 | 2009 | |
|
|
|||
| 5,511,190 Hash-based database grouping system and method | 84 | 1995 | |
| 5,600,833 Attribute portion based document retrieval system with system query language interface | 97 | 1995 | |
| 6,012,072 Display apparatus for the display of documents in a three-dimensional workspace | 58 | 1996 | |
|
|
|||
| 5,978,790 Method and apparatus for restructuring data in semi-structured databases | 21 | 1997 | |
| 5,960,425 Database access system with optimizable expressions | 11 | 1997 | |
|
|
|||
| 5,581,756 Network database access system to which builds a table tree in response to a relational query | 27 | 1995 | |
| 5,615,371 Debug processing system for user programs | 5 | 1995 | |
|
|
|||
| 5,864,842 Optimization of SQL queries using hash star join operations | 79 | 1995 | |
| 8,396,862 Product join dynamic partition elimination for multilevel partitioning | 0 | 2007 | |
|
|
|||
| 6,446,094 Data structure for emulating virtual memory working spaces | 6 | 2000 | |
|
|
|||
| 5,630,120 Method to help in optimizing a query from a relational data base management system | 38 | 1995 | |
|
|
|||
| 6,151,608 Method and system for migrating data | 128 | 1998 | |
|
|
|||
| 6,061,688 Geographical system for accessing data | 13 | 1997 | |
|
|
|||
| 8,103,704 Method for database consolidation and database separation | 3 | 2007 | |
|
|
|||
| 6,269,359 Relational data base system and method for rapidly realizing a query to a database | 9 | 1993 | |
|
|
|||
| 6,581,054 Dynamic query model and method | 97 | 1999 | |
|
|
|||
| 5,826,076 Computer-based information access method and apparatus to permit SQL-based manipulation of programming language-specific data files | 35 | 1994 | |
|
|
|||
| 5,600,831 Apparatus and methods for retrieving information by modifying query plan based on description of information sources | 128 | 1994 | |
|
|
|||
| 5,754,843 Data retrieval apparatus, evaluation entry apparatus and sensibility entry apparatus | 2 | 1996 | |
|
|
|||
| 6,772,142 Method and apparatus for collecting and expressing geographically-referenced data | 42 | 2000 | |
|
|
|||
| 7,516,399 Structured-document path-language expression methods and systems | 13 | 2004 | |
|
|
|||
| 5,974,407 Method and apparatus for implementing a hierarchical database management system (HDBMS) using a relational database management system (RDBMS) as the implementing apparatus | 162 | 1997 | |
|
|
|||
| 6,138,111 Cardinality-based join ordering | 14 | 1997 | |
|
|
|||
| 6,341,281 Database system with methods for optimizing performance of correlated subqueries by reusing invariant results of operator tree | 87 | 1999 | |
|
|
|||
| 5,717,911 Relational database system and method with high availability compliation of SQL programs | 60 | 1995 | |
|
|
|||
| 8,429,138 Method and apparatus for data exchange in a distributed system | 0 | 2009 | |
|
|
|||
| 6,301,581 Method and system for managing access to a plurality of data objects | 21 | 1994 | |
|
|
|||
| 5,687,361 System for managing and accessing a dynamically expanding computer database | 23 | 1995 | |
|
|
|||
| 8,332,348 Knowledge extraction and prediction | 0 | 2009 | |
|
|
|||
| 6,055,543 File wrapper containing cataloging information for content searching across multiple platforms | 175 | 1997 | |
|
|
|||
| 8,321,373 Method of servicing query statements from a client machine using a database management system (DBMS) employing a relational datastore and a multi-dimensional database (MDDB) | 2009 | ||
|
|
|||
| 6,192,366 Integrated database system and computer-readable recording medium recorded with program for managing database structure thereof | 7 | 1998 | |
| 6,269,356 Computer system program for creating new ideas and solving problems | 13 | 1999 | |
| 7,548,935 Method of recursive objects for representing hierarchies in relational database systems | 1 | 2003 | |
| RE40063 Data processing and method for maintaining cardinality in a relational database | 1 | 2005 | |
Maintenance Fees
| Fee | Large entity fee | small entity fee | micro entity fee | due date |
|---|
| Fee | Large entity fee | small entity fee | micro entity fee |
|---|---|---|---|
| Surcharge after expiration - Late payment is unavoidable | $700.00 | $350.00 | $175.00 |
| Surcharge after expiration - Late payment is unintentional | $1,640.00 | $820.00 | $410.00 |