CA2484009A1 - Managing expressions in a database system - Google Patents
Managing expressions in a database system Download PDFInfo
- Publication number
- CA2484009A1 CA2484009A1 CA002484009A CA2484009A CA2484009A1 CA 2484009 A1 CA2484009 A1 CA 2484009A1 CA 002484009 A CA002484009 A CA 002484009A CA 2484009 A CA2484009 A CA 2484009A CA 2484009 A1 CA2484009 A1 CA 2484009A1
- Authority
- CA
- Canada
- Prior art keywords
- predicate
- data
- query
- expression
- expressions
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/84—Mapping; Conversion
- G06F16/86—Mapping to a database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/137—Hierarchical processing, e.g. outlines
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/953—Organization of data
- Y10S707/961—Associative
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99931—Database or file accessing
- Y10S707/99933—Query processing, i.e. searching
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99943—Generating database or data structure, e.g. via user interface
Abstract
Managing expressions includes receiving a first query that includes a conditional expression. The expression is then represented as data in a colu mn of a table. A second query is received that specifies a first set of criteri a, and the second query is executed to select data based at least on whether expressions in the column satisfy the first set of criteria. In an embodimen t, the second query further specifies a second set of criteria, wherein executi ng the second query includes selecting data based on whether data in columns other than the expression column satisfy the second criteria. A special inde x is defined, which can be created on the column that stores the expressions, to filter large sets of expressions efficiently. A method of evaluating an expression set stored as data in a table classifies each predicate from each expression, and filters the expression set based on the predicate classification.
Claims (16)
1. A method for managing expressions in a database, the method comprising the steps of:
receiving a first query that includes a first conditional expression;
representing the first conditional expression as data in a column of a table;
receiving a second query that specifies a first set of one or more criteria;
and executing the second query to select data based at least on whether conditional expressions in the column satisfy the first set of criteria.
receiving a first query that includes a first conditional expression;
representing the first conditional expression as data in a column of a table;
receiving a second query that specifies a first set of one or more criteria;
and executing the second query to select data based at least on whether conditional expressions in the column satisfy the first set of criteria.
2. The method of Claim 1, wherein the second query further specifies a second set of one or more criteria, and wherein the step of executing the second query includes selecting data based on whether data in one or more columns other than the column satisfies the second set of criteria.
3. The method of Claim 1, wherein the step of receiving a first query includes receiving the first query from a first user of a database application, and wherein the first conditional expression specifies one or more criteria that must be satisfied by data for the data to be of interest to the user.
4. The method of Claim 3, wherein the step of receiving the second query includes receiving the second query from a second user of a database application, and wherein the second query specifies a second set of one or more criteria that must be satisfied by data for the data to be made available to the first user, thus enabling mutual filtering among the first user and the second user.
5. The method of Claim 1, wherein the step of receiving a first query includes receiving the first query from a subscriber to an information subscription system, and wherein the first conditional expression specifies one or more criteria that must be satisfied by data for the data to be of interest to the subscriber.
6. The method of Claim 5, wherein the step of receiving the second query includes receiving the second query from a publisher in the subscription system, and wherein the second query specifies a second set of one or more criteria that must be satisfied by data for the data to be published to the subscriber.
7. The method of Claim 1, wherein the step of receiving the second query includes receiving the second query from a publisher in an information subscription system, and wherein the second query specifies a second set of one or more criteria that must be satisfied by data for the data to be published to a subscriber to the subscription system.
8. The method of Claim 1, wherein the step of representing a first conditional expression as data in a column includes representing a set of first conditional expressions from a plurality of first queries as data in the column, the method further comprising the steps of:
creating an index on the column of the table by grouping predicates from the set of first conditional expressions based on predicate identifiers that are associated with respective criteria of the first set of criteria;
storing in a predicate table sets of predicate operators and constants in association with respective predicate identifiers;
creating a concatenated bitmap index based on a set of predicate operators and constants associated with a particular predicate identifier.
creating an index on the column of the table by grouping predicates from the set of first conditional expressions based on predicate identifiers that are associated with respective criteria of the first set of criteria;
storing in a predicate table sets of predicate operators and constants in association with respective predicate identifiers;
creating a concatenated bitmap index based on a set of predicate operators and constants associated with a particular predicate identifier.
9. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the any one of the methods recited in Claims 1-8.
10. A method for evaluating an expression set that is stored as data in a column of a table, the method comprising the steps of:
classifying each predicate from each expression of the expression set as one of, an indexed attribute predicate, wherein a bitmap index is created based on a set of operator and constant attributes that are stored in respective columns of a predicate table in association with a respective predicate identifier;
a stored attribute predicate, wherein a set of operator and constant attributes are stored in respective columns of the predicate table in association with a respective predicate identifier, and wherein no index is created on the set of operator and constant attributes;
a sparse predicate, in which a predicate identifier associated with a sparse predicate is uncommon in the expression set, and wherein a sparse predicate is stored as data in the predicate table; and filtering the expression set based on the classification of predicates from the expression set.,
classifying each predicate from each expression of the expression set as one of, an indexed attribute predicate, wherein a bitmap index is created based on a set of operator and constant attributes that are stored in respective columns of a predicate table in association with a respective predicate identifier;
a stored attribute predicate, wherein a set of operator and constant attributes are stored in respective columns of the predicate table in association with a respective predicate identifier, and wherein no index is created on the set of operator and constant attributes;
a sparse predicate, in which a predicate identifier associated with a sparse predicate is uncommon in the expression set, and wherein a sparse predicate is stored as data in the predicate table; and filtering the expression set based on the classification of predicates from the expression set.,
11. The method of Claim 10, wherein the step of filtering the expression set includes the steps of first, filtering the indexed attribute predicates to obtain a first set of expressions that includes one or more expressions for which all of its indexed attribute predicates are true for a given data item;
second, filtering the stored attribute predicates of the first set of expressions to obtain a second set of expressions that includes one or more expressions for which all of its stored attributes are true for the given data item; and third, filtering the sparse predicates, if any, of the second set of expressions to obtain a third set of expressions that includes one or more expressions for which all of its predicates are true for the given data item.
second, filtering the stored attribute predicates of the first set of expressions to obtain a second set of expressions that includes one or more expressions for which all of its stored attributes are true for the given data item; and third, filtering the sparse predicates, if any, of the second set of expressions to obtain a third set of expressions that includes one or more expressions for which all of its predicates are true for the given data item.
12. The method of Claim 11, further comprising the step of:
publishing the given data item to a subscriber to an information subscription system that has expressed interest in data that meets criteria represented by an expression from the third set of expressions.
publishing the given data item to a subscriber to an information subscription system that has expressed interest in data that meets criteria represented by an expression from the third set of expressions.
13. A computer-readable medium carrying one or more sequences of instructions which, when executed by one or more processors, causes the one or more processors to perform the any one of the methods recited in Claims 10-12.
14. A computer-readable medium storing an index that is built on a table that has a plurality of rows, the index comprising:
concatenated bit vectors, wherein each bit vector is associated with one of an operator and a constant that are each stored in respective columns of the table;
wherein the operator and the constant are associated with a predicate of one or more predicates from a conditional expression that specifies one or more criteria that must be satisfied by data for the data to be of interest to a subscriber to a subscription system.
concatenated bit vectors, wherein each bit vector is associated with one of an operator and a constant that are each stored in respective columns of the table;
wherein the operator and the constant are associated with a predicate of one or more predicates from a conditional expression that specifies one or more criteria that must be satisfied by data for the data to be of interest to a subscriber to a subscription system.
15. An apparatus for managing expressions in a database, comprising:
means for receiving a first query that includes a first conditional expression;
means for representing the first conditional expression as data in a column of a table;
means for receiving a second query that specifies a first set of one or more criteria; and means for executing the second query to select data based at least on whether conditional expressions in the column satisfy the first set of criteria.
means for receiving a first query that includes a first conditional expression;
means for representing the first conditional expression as data in a column of a table;
means for receiving a second query that specifies a first set of one or more criteria; and means for executing the second query to select data based at least on whether conditional expressions in the column satisfy the first set of criteria.
16. An apparatus for evaluating an expression set that is stored as data in a column of a table, comprising:
means for classifying each predicate from each expression of the expression set as one of, an indexed attribute predicate, wherein a bitmap index is created based on a set of operator and constant attributes that are stored in respective columns of a predicate table in association with a respective predicate identifier;
a stored attribute predicate, wherein a set of operator and constant attributes are stored in respective columns of the predicate table in association with a respective predicate identifier, and wherein no index is created on the set of operator and constant attributes;
a sparse predicate, in which a predicate identifier associated with a sparse predicate is uncommon in the expression set, and wherein a sparse predicate is stored as data in the predicate table; and means for filtering the expression set based on the classification of predicates from the expression set.
means for classifying each predicate from each expression of the expression set as one of, an indexed attribute predicate, wherein a bitmap index is created based on a set of operator and constant attributes that are stored in respective columns of a predicate table in association with a respective predicate identifier;
a stored attribute predicate, wherein a set of operator and constant attributes are stored in respective columns of the predicate table in association with a respective predicate identifier, and wherein no index is created on the set of operator and constant attributes;
a sparse predicate, in which a predicate identifier associated with a sparse predicate is uncommon in the expression set, and wherein a sparse predicate is stored as data in the predicate table; and means for filtering the expression set based on the classification of predicates from the expression set.
Applications Claiming Priority (5)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US37801802P | 2002-05-10 | 2002-05-10 | |
US60/378,018 | 2002-05-10 | ||
US10/254,383 US7127467B2 (en) | 2002-05-10 | 2002-09-24 | Managing expressions in a database system |
US10/254,383 | 2002-09-24 | ||
PCT/US2003/014892 WO2003098479A2 (en) | 2002-05-10 | 2003-05-08 | Managing search expressions in a database system |
Publications (2)
Publication Number | Publication Date |
---|---|
CA2484009A1 true CA2484009A1 (en) | 2003-11-27 |
CA2484009C CA2484009C (en) | 2012-12-11 |
Family
ID=29406453
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CA2484009A Expired - Lifetime CA2484009C (en) | 2002-05-10 | 2003-05-08 | Managing expressions in a database system |
Country Status (7)
Country | Link |
---|---|
US (4) | US7127467B2 (en) |
EP (1) | EP1504380A2 (en) |
JP (1) | JP2005525657A (en) |
CN (1) | CN100428227C (en) |
AU (1) | AU2003249632B2 (en) |
CA (1) | CA2484009C (en) |
WO (1) | WO2003098479A2 (en) |
Families Citing this family (228)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6948135B1 (en) | 2000-06-21 | 2005-09-20 | Microsoft Corporation | Method and systems of providing information to computer users |
US7191394B1 (en) | 2000-06-21 | 2007-03-13 | Microsoft Corporation | Authoring arbitrary XML documents using DHTML and XSLT |
US7624356B1 (en) | 2000-06-21 | 2009-11-24 | Microsoft Corporation | Task-sensitive methods and systems for displaying command sets |
US7000230B1 (en) | 2000-06-21 | 2006-02-14 | Microsoft Corporation | Network-based software extensions |
US7155667B1 (en) | 2000-06-21 | 2006-12-26 | Microsoft Corporation | User interface for integrated spreadsheets and word processing tables |
US6883168B1 (en) | 2000-06-21 | 2005-04-19 | Microsoft Corporation | Methods, systems, architectures and data structures for delivering software via a network |
US7346848B1 (en) | 2000-06-21 | 2008-03-18 | Microsoft Corporation | Single window navigation methods and systems |
US7127467B2 (en) | 2002-05-10 | 2006-10-24 | Oracle International Corporation | Managing expressions in a database system |
US7565379B2 (en) | 2002-08-01 | 2009-07-21 | Edwina Lu | Preventing change cycling using rules and redo tags in a redo log |
US7613741B2 (en) | 2002-08-01 | 2009-11-03 | Oracle International Corporation | Utilizing rules in a distributed information sharing system |
US8374966B1 (en) | 2002-08-01 | 2013-02-12 | Oracle International Corporation | In memory streaming with disk backup and recovery of messages captured from a database redo stream |
US7185033B2 (en) | 2002-08-01 | 2007-02-27 | Oracle International Corporation | Buffered message queue architecture for database management systems with unlimited buffered message queue with limited shared memory |
US20040024771A1 (en) * | 2002-08-01 | 2004-02-05 | Oracle International Corporation | Buffered message queue architecture for database management systems with transactional enqueue support |
US7203706B2 (en) * | 2002-08-01 | 2007-04-10 | Oracle International Corporation | Buffered message queue architecture for database management systems with memory optimizations and “zero copy” buffered message queue |
US7031974B1 (en) | 2002-08-01 | 2006-04-18 | Oracle International Corporation | Replicating DDL changes using streams |
US8005802B2 (en) * | 2002-08-01 | 2011-08-23 | Oracle International Corporation | Partial evaluation of rule sets |
US7181482B2 (en) * | 2002-08-01 | 2007-02-20 | Oracle International Corporation | Buffered message queue architecture for database management systems |
US7185034B2 (en) | 2002-08-01 | 2007-02-27 | Oracle International Corporation | Buffered message queue architecture for database management systems with guaranteed at least once delivery |
JP4036718B2 (en) * | 2002-10-02 | 2008-01-23 | インターナショナル・ビジネス・マシーンズ・コーポレーション | Document search system, document search method, and program for executing document search |
US7761459B1 (en) | 2002-10-15 | 2010-07-20 | Ximpleware, Inc. | Processing structured data |
US7133857B1 (en) * | 2002-10-15 | 2006-11-07 | Ximpleware, Inc. | Processing structured data |
US7224698B2 (en) * | 2002-11-27 | 2007-05-29 | Bellsouth Intellectual Property Corporation | Edge side assembler |
US7263102B2 (en) * | 2002-11-27 | 2007-08-28 | At&T Intellectual Property, Inc. | Multi-path gateway communications device |
US6999968B1 (en) * | 2002-11-27 | 2006-02-14 | Microsoft Corporation | Fast merge into large ordered sets |
US7379464B2 (en) * | 2002-11-27 | 2008-05-27 | At&T Bls Intellectual Property, Inc. | Personal digital gateway |
US20040177315A1 (en) * | 2003-03-03 | 2004-09-09 | International Business Machines Corporation | Structured document bounding language |
US7415672B1 (en) | 2003-03-24 | 2008-08-19 | Microsoft Corporation | System and method for designing electronic forms |
US7275216B2 (en) * | 2003-03-24 | 2007-09-25 | Microsoft Corporation | System and method for designing electronic forms and hierarchical schemas |
US7370066B1 (en) | 2003-03-24 | 2008-05-06 | Microsoft Corporation | System and method for offline editing of data files |
US7296017B2 (en) * | 2003-03-28 | 2007-11-13 | Microsoft Corporation | Validation of XML data files |
US7913159B2 (en) | 2003-03-28 | 2011-03-22 | Microsoft Corporation | System and method for real-time validation of structured data files |
US7668902B2 (en) * | 2003-05-30 | 2010-02-23 | Microsoft Corporation | Application programming interface for implementing directory service access using directory service markup language |
US7451392B1 (en) | 2003-06-30 | 2008-11-11 | Microsoft Corporation | Rendering an HTML electronic form by applying XSLT to XML using a solution |
US7406660B1 (en) | 2003-08-01 | 2008-07-29 | Microsoft Corporation | Mapping between structured data and a visual surface |
US7334187B1 (en) | 2003-08-06 | 2008-02-19 | Microsoft Corporation | Electronic form aggregation |
US8365193B2 (en) | 2003-08-14 | 2013-01-29 | Oracle International Corporation | Recoverable asynchronous message driven processing in a multi-node system |
US7814047B2 (en) * | 2003-08-25 | 2010-10-12 | Oracle International Corporation | Direct loading of semistructured data |
US8001156B2 (en) * | 2003-08-29 | 2011-08-16 | Cybertrust Ireland Limited | Processing XML node sets |
US8694510B2 (en) * | 2003-09-04 | 2014-04-08 | Oracle International Corporation | Indexing XML documents efficiently |
US7315852B2 (en) * | 2003-10-31 | 2008-01-01 | International Business Machines Corporation | XPath containment for index and materialized view matching |
US8819072B1 (en) | 2004-02-02 | 2014-08-26 | Microsoft Corporation | Promoting data from structured data files |
US7430711B2 (en) * | 2004-02-17 | 2008-09-30 | Microsoft Corporation | Systems and methods for editing XML documents |
US20050216518A1 (en) * | 2004-03-26 | 2005-09-29 | Oracle International Corporation | Database management system with persistent, user-accessible bitmap values |
US20050222996A1 (en) * | 2004-03-30 | 2005-10-06 | Oracle International Corporation | Managing event-condition-action rules in a database system |
US7496837B1 (en) | 2004-04-29 | 2009-02-24 | Microsoft Corporation | Structural editing with schema awareness |
WO2005114494A1 (en) * | 2004-05-21 | 2005-12-01 | Computer Associates Think, Inc. | Storing multipart xml documents |
US7774620B1 (en) | 2004-05-27 | 2010-08-10 | Microsoft Corporation | Executing applications at appropriate trust levels |
US7108433B2 (en) * | 2004-06-24 | 2006-09-19 | Eastman Kodak Company | Thermal processor employing varying roller spacing |
US8000452B2 (en) * | 2004-07-26 | 2011-08-16 | General Motors Llc | Method and system for predictive interactive voice recognition |
US9767146B2 (en) * | 2004-08-31 | 2017-09-19 | International Business Machines Corporation | Use of generated SQL for evaluation of decision point rules in a workflow system |
US9171100B2 (en) | 2004-09-22 | 2015-10-27 | Primo M. Pettovello | MTree an XPath multi-axis structure threaded index |
US7692636B2 (en) | 2004-09-30 | 2010-04-06 | Microsoft Corporation | Systems and methods for handwriting to a screen |
US7792274B2 (en) | 2004-11-04 | 2010-09-07 | Oracle International Corporation | Techniques for performing multi-media call center functionality in a database management system |
US8185518B2 (en) | 2004-11-12 | 2012-05-22 | International Business Machines Corporation | Method, system and program product for rewriting structured query language (SQL) statements |
US7712022B2 (en) | 2004-11-15 | 2010-05-04 | Microsoft Corporation | Mutually exclusive options in electronic forms |
US7721190B2 (en) | 2004-11-16 | 2010-05-18 | Microsoft Corporation | Methods and systems for server side form processing |
US7904801B2 (en) | 2004-12-15 | 2011-03-08 | Microsoft Corporation | Recursive sections in electronic forms |
US7779418B2 (en) * | 2004-12-30 | 2010-08-17 | Oracle International Corporation | Publisher flow control and bounded guaranteed delivery for message queues |
US7818386B2 (en) * | 2004-12-30 | 2010-10-19 | Oracle International Corporation | Repeatable message streams for message queues in distributed systems |
US7937651B2 (en) | 2005-01-14 | 2011-05-03 | Microsoft Corporation | Structural editing operations for network forms |
US20060190461A1 (en) * | 2005-02-18 | 2006-08-24 | Schaefer Brian M | Apparatus, system, and method for managing objects in a database according to a dynamic predicate representation of an explicit relationship between objects |
US7725834B2 (en) | 2005-03-04 | 2010-05-25 | Microsoft Corporation | Designer-created aspect for an electronic form template |
US7567975B2 (en) | 2005-03-16 | 2009-07-28 | Oracle International Corporation | Incremental evaluation of complex event-condition-action rules in a database system |
US8010515B2 (en) | 2005-04-15 | 2011-08-30 | Microsoft Corporation | Query to an electronic form |
EP1872276A4 (en) * | 2005-04-18 | 2008-07-02 | Research In Motion Ltd | Method and apparatus for searching, filtering and sorting data in a wireless device |
US7836027B2 (en) * | 2005-06-22 | 2010-11-16 | Statware, Inc. | Method and apparatus for communicating list orders |
CA2510661A1 (en) * | 2005-06-23 | 2006-12-23 | Cognos Incorporated | Filter manager system and method of managing filter expressions |
US8200975B2 (en) | 2005-06-29 | 2012-06-12 | Microsoft Corporation | Digital signatures for network forms |
US7480649B2 (en) * | 2005-07-06 | 2009-01-20 | International Business Machines Corporation | Method for efficient evaluation of index screening predicates |
US20070130206A1 (en) * | 2005-08-05 | 2007-06-07 | Siemens Corporate Research Inc | System and Method For Integrating Heterogeneous Biomedical Information |
US20070050364A1 (en) * | 2005-09-01 | 2007-03-01 | Cummins Fred A | System, method, and software for implementing business rules in an entity |
US20070083807A1 (en) * | 2005-10-06 | 2007-04-12 | Microsoft Corporation | Evaluating multiple data filtering expressions in parallel |
US8196150B2 (en) * | 2005-10-07 | 2012-06-05 | Oracle International Corporation | Event locality using queue services |
US7680793B2 (en) * | 2005-10-07 | 2010-03-16 | Oracle International Corporation | Commit-time ordered message queue supporting arbitrary read and dequeue patterns from multiple subscribers |
US7664742B2 (en) | 2005-11-14 | 2010-02-16 | Pettovello Primo M | Index data structure for a peer-to-peer network |
US7966315B2 (en) * | 2005-11-15 | 2011-06-21 | Vmware, Inc. | Multi-query optimization |
US8001459B2 (en) | 2005-12-05 | 2011-08-16 | Microsoft Corporation | Enabling electronic documents for limited-capability computing devices |
US7941515B2 (en) * | 2006-01-13 | 2011-05-10 | Cisco Technology, Inc. | Applying a filter set to information provided to a subscribing client |
US7779343B2 (en) * | 2006-01-30 | 2010-08-17 | Microsoft Corporation | Opening network-enabled electronic documents |
US20070260976A1 (en) * | 2006-05-02 | 2007-11-08 | Slein Judith A | Rule Engines and Methods of Using Same |
US7801856B2 (en) * | 2006-08-09 | 2010-09-21 | Oracle International Corporation | Using XML for flexible replication of complex types |
CN101535990B (en) * | 2006-08-23 | 2013-05-29 | 创新解决方案公司 | Efficient search result update mechanism |
US8694524B1 (en) * | 2006-08-28 | 2014-04-08 | Teradata Us, Inc. | Parsing a query |
US20080104042A1 (en) * | 2006-10-25 | 2008-05-01 | Microsoft Corporation | Personalized Search Using Macros |
US20080104092A1 (en) * | 2006-10-27 | 2008-05-01 | Electronic Data Systems Corporation | Integrating Business Rules into Automated Business Processes |
US20080147615A1 (en) * | 2006-12-18 | 2008-06-19 | Oracle International Corporation | Xpath based evaluation for content stored in a hierarchical database repository using xmlindex |
US20080147710A1 (en) * | 2006-12-19 | 2008-06-19 | Microsoft Corporation | Generating web pages utilizing user-defined search parameters |
US7552119B2 (en) * | 2006-12-20 | 2009-06-23 | International Business Machines Corporation | Apparatus and method for skipping XML index scans with common ancestors of a previously failed predicate |
US7716210B2 (en) | 2006-12-20 | 2010-05-11 | International Business Machines Corporation | Method and apparatus for XML query evaluation using early-outs and multiple passes |
US20080228801A1 (en) * | 2007-03-13 | 2008-09-18 | Champion Technologies, Inc. | Context-variable data framework for hierarchical data warehousing |
US20080244380A1 (en) * | 2007-03-27 | 2008-10-02 | Canon Kabushiki Kaisha | Method and device for evaluating an expression on elements of a structured document |
US9027025B2 (en) | 2007-04-17 | 2015-05-05 | Oracle International Corporation | Real-time database exception monitoring tool using instance eviction data |
US7596584B2 (en) * | 2007-04-25 | 2009-09-29 | Microsoft Corporation | Predicate based group management |
US8108399B2 (en) * | 2007-05-18 | 2012-01-31 | Microsoft Corporation | Filtering of multi attribute data via on-demand indexing |
US20080320031A1 (en) * | 2007-06-19 | 2008-12-25 | C/O Canon Kabushiki Kaisha | Method and device for analyzing an expression to evaluate |
US7895189B2 (en) * | 2007-06-28 | 2011-02-22 | International Business Machines Corporation | Index exploitation |
US8086597B2 (en) * | 2007-06-28 | 2011-12-27 | International Business Machines Corporation | Between matching |
US9009292B2 (en) * | 2007-07-30 | 2015-04-14 | Sybase, Inc. | Context-based data pre-fetching and notification for mobile applications |
US7840609B2 (en) * | 2007-07-31 | 2010-11-23 | Oracle International Corporation | Using sibling-count in XML indexes to optimize single-path queries |
US7752165B2 (en) * | 2007-08-01 | 2010-07-06 | Sybase, Inc. | Persistent query system for automatic on-demand data subscriptions from mobile devices |
US8204870B2 (en) * | 2007-08-03 | 2012-06-19 | Sybase, Inc. | Unwired enterprise platform |
US7725448B2 (en) * | 2007-08-31 | 2010-05-25 | International Business Machines Corporation | Method and system for disjunctive single index access |
US8810190B2 (en) * | 2007-09-14 | 2014-08-19 | The Powerwise Group, Inc. | Motor controller system and method for maximizing energy savings |
US9171282B2 (en) * | 2007-10-22 | 2015-10-27 | Oracle International Corporation | Interactive complex event pattern builder and visualizer |
US8862619B1 (en) | 2008-01-07 | 2014-10-14 | Amdocs Software Systems Limited | System, method, and computer program product for filtering a data stream utilizing a plurality of contexts |
US7962490B1 (en) * | 2008-01-07 | 2011-06-14 | Amdocs Software Systems Limited | System, method, and computer program product for analyzing and decomposing a plurality of rules into a plurality of contexts |
US20090182689A1 (en) * | 2008-01-15 | 2009-07-16 | Microsoft Corporation | Rule-based dynamic operation evaluation |
US8145641B2 (en) * | 2008-01-18 | 2012-03-27 | Oracle International Corporation | Managing feature data based on spatial collections |
US8290950B2 (en) * | 2008-01-31 | 2012-10-16 | SAP France S.A. | Identifying locale-specific data based on a total ordering of supported locales |
US8566909B2 (en) * | 2008-02-01 | 2013-10-22 | Oracle International Corporation | Row-level security with expression data type |
US8706820B2 (en) * | 2008-02-08 | 2014-04-22 | Microsoft Corporation | Rules extensibility engine |
US7996444B2 (en) * | 2008-02-18 | 2011-08-09 | International Business Machines Corporation | Creation of pre-filters for more efficient X-path processing |
US8606757B2 (en) * | 2008-03-31 | 2013-12-10 | Intel Corporation | Storage and retrieval of concurrent query language execution results |
US7865502B2 (en) * | 2008-04-10 | 2011-01-04 | International Business Machines Corporation | Optimization of extensible markup language path language (XPATH) expressions in a database management system configured to accept extensible markup language (XML) queries |
US8131729B2 (en) * | 2008-06-12 | 2012-03-06 | International Business Machines Corporation | System and method for best-fit lookup of multi-field key |
US8533606B2 (en) * | 2008-06-13 | 2013-09-10 | At&T Intellectual Property I, L.P. | System and method for personalized hold |
US8375044B2 (en) * | 2008-06-24 | 2013-02-12 | Microsoft Corporation | Query processing pipelines with single-item and multiple-item query operators |
US8364750B2 (en) | 2008-06-24 | 2013-01-29 | Microsoft Corporation | Automated translation of service invocations for batch processing |
US8713048B2 (en) * | 2008-06-24 | 2014-04-29 | Microsoft Corporation | Query processing with specialized query operators |
US8819046B2 (en) * | 2008-06-24 | 2014-08-26 | Microsoft Corporation | Data query translating into mixed language data queries |
US8364751B2 (en) * | 2008-06-25 | 2013-01-29 | Microsoft Corporation | Automated client/server operation partitioning |
US20100050153A1 (en) * | 2008-08-21 | 2010-02-25 | Clevest Solutions Inc. | Method and system of editing workflow logic and screens with a gui tool |
US20100049568A1 (en) * | 2008-08-21 | 2010-02-25 | Clevest Solutions Inc. | System and Method for an Extensible Workflow Management |
US10747952B2 (en) | 2008-09-15 | 2020-08-18 | Palantir Technologies, Inc. | Automatic creation and server push of multiple distinct drafts |
US8336021B2 (en) * | 2008-12-15 | 2012-12-18 | Microsoft Corporation | Managing set membership |
US9128895B2 (en) | 2009-02-19 | 2015-09-08 | Oracle International Corporation | Intelligent flood control management |
US8468113B2 (en) | 2009-05-18 | 2013-06-18 | Tufin Software Technologies Ltd. | Method and system for management of security rule set |
IL205815A0 (en) | 2009-05-18 | 2010-11-30 | Tufin Software Technologies Ltd | Method and system for management of security rule set |
US8676808B2 (en) | 2009-07-09 | 2014-03-18 | Dillon Software Services, Llc | Data store interface that facilitates distribution of application functionality across a multi-tier client-server architecture |
US8631028B1 (en) | 2009-10-29 | 2014-01-14 | Primo M. Pettovello | XPath query processing improvements |
US9424365B2 (en) * | 2009-10-30 | 2016-08-23 | Oracle International Corporation | XPath-based creation of relational indexes and constraints over XML data stored in relational tables |
US9165086B2 (en) | 2010-01-20 | 2015-10-20 | Oracle International Corporation | Hybrid binary XML storage model for efficient XML processing |
US8918388B1 (en) * | 2010-02-26 | 2014-12-23 | Turn Inc. | Custom data warehouse on top of mapreduce |
US20120047223A1 (en) * | 2010-08-20 | 2012-02-23 | Nokia Corporation | Method and apparatus for distributed storage |
US8392466B2 (en) * | 2010-08-27 | 2013-03-05 | International Business Machines Corporation | Method and apparatus for automated processing of a data stream |
US20120072824A1 (en) * | 2010-09-20 | 2012-03-22 | Research In Motion Limited | Content acquisition documents, methods, and systems |
US8566702B2 (en) * | 2010-09-20 | 2013-10-22 | Blackberry Limited | Methods and systems of outputting content of interest |
US8458530B2 (en) | 2010-09-21 | 2013-06-04 | Oracle International Corporation | Continuous system health indicator for managing computer system alerts |
US8914841B2 (en) | 2010-11-24 | 2014-12-16 | Tufin Software Technologies Ltd. | Method and system for mapping between connectivity requests and a security rule set |
US8839132B2 (en) * | 2010-12-02 | 2014-09-16 | Tecsys, Inc. | Method and system for providing visual instructions to warehouse operators |
US9253156B2 (en) * | 2011-06-09 | 2016-02-02 | International Business Machines Corporation | Dynamically defining network access rules |
CN102831121B (en) * | 2011-06-15 | 2015-07-08 | 阿里巴巴集团控股有限公司 | Method and system for extracting webpage information |
US9092482B2 (en) | 2013-03-14 | 2015-07-28 | Palantir Technologies, Inc. | Fair scheduling for mixed-query loads |
US8756509B2 (en) | 2011-07-27 | 2014-06-17 | International Business Machines Corporation | Visually representing and managing access control of resources |
US8732574B2 (en) | 2011-08-25 | 2014-05-20 | Palantir Technologies, Inc. | System and method for parameterizing documents for automatic workflow generation |
US8504542B2 (en) | 2011-09-02 | 2013-08-06 | Palantir Technologies, Inc. | Multi-row transactions |
US10534606B2 (en) | 2011-12-08 | 2020-01-14 | Oracle International Corporation | Run-length encoding decompression |
US9378526B2 (en) | 2012-03-02 | 2016-06-28 | Palantir Technologies, Inc. | System and method for accessing data objects via remote references |
CN103377252B (en) * | 2012-04-28 | 2018-03-27 | 国际商业机器公司 | The method and apparatus that data filtering is carried out in Internet of Things |
US9043309B2 (en) * | 2012-06-05 | 2015-05-26 | Oracle International Corporation | SQL transformation-based optimization techniques for enforcement of data access control |
US9176999B2 (en) * | 2012-09-13 | 2015-11-03 | International Business Machines Corporation | Multiplication-based method for stitching results of predicate evaluation in column stores |
IL221975A (en) | 2012-09-19 | 2015-02-26 | Tufin Software Technologies Ltd | Method of managing connectivity between resources in a computer network and system thereof |
US10635674B2 (en) | 2012-09-28 | 2020-04-28 | Oracle International Corporation | Migrating a pluggable database between database server instances with minimal impact to performance |
US10430391B2 (en) * | 2012-09-28 | 2019-10-01 | Oracle International Corporation | Techniques for activity tracking, data classification, and in database archiving |
US10860605B2 (en) | 2012-09-28 | 2020-12-08 | Oracle International Corporation | Near-zero downtime relocation of a pluggable database across container databases |
US9348677B2 (en) | 2012-10-22 | 2016-05-24 | Palantir Technologies Inc. | System and method for batch evaluation programs |
US9471370B2 (en) * | 2012-10-22 | 2016-10-18 | Palantir Technologies, Inc. | System and method for stack-based batch evaluation of program instructions |
US9367463B2 (en) | 2013-03-14 | 2016-06-14 | Palantir Technologies, Inc. | System and method utilizing a shared cache to provide zero copy memory mapped database |
US8868486B2 (en) | 2013-03-15 | 2014-10-21 | Palantir Technologies Inc. | Time-sensitive cube |
US8909656B2 (en) | 2013-03-15 | 2014-12-09 | Palantir Technologies Inc. | Filter chains with associated multipath views for exploring large data sets |
US10248962B2 (en) * | 2013-04-08 | 2019-04-02 | Oracle International Corporation | Profitability simulator |
US9965512B2 (en) * | 2013-06-25 | 2018-05-08 | Sap Se | Operators for constants in aggregated formulas |
US11113054B2 (en) | 2013-09-10 | 2021-09-07 | Oracle International Corporation | Efficient hardware instructions for single instruction multiple data processors: fast fixed-length value compression |
US9348888B1 (en) * | 2013-09-24 | 2016-05-24 | Emc Corporation | Iterative filter expression processing for filtering embedded data objects |
US9105000B1 (en) | 2013-12-10 | 2015-08-11 | Palantir Technologies Inc. | Aggregating data from a plurality of data sources |
US9495444B2 (en) | 2014-02-07 | 2016-11-15 | Quixey, Inc. | Rules-based generation of search results |
US20150261860A1 (en) * | 2014-03-12 | 2015-09-17 | Kaushal MITTAL | Predicate execution in shared distributed computing environment |
US8935201B1 (en) | 2014-03-18 | 2015-01-13 | Palantir Technologies Inc. | Determining and extracting changed data from a data source |
CN104102689B (en) * | 2014-05-12 | 2018-01-12 | 华迪计算机集团有限公司 | The method and apparatus retrieved based on data model to media data |
US20160026923A1 (en) | 2014-07-22 | 2016-01-28 | Palantir Technologies Inc. | System and method for determining a propensity of entity to take a specified action |
CN105447032A (en) * | 2014-08-29 | 2016-03-30 | 国际商业机器公司 | Method and system for processing message and subscription information |
US9785725B2 (en) | 2014-09-26 | 2017-10-10 | Oracle International Corporation | Method and system for visualizing relational data as RDF graphs with interactive response time |
WO2016115735A1 (en) | 2015-01-23 | 2016-07-28 | Murthy Sharad R | Processing high volume network data |
US11916727B2 (en) | 2015-01-23 | 2024-02-27 | Ebay Inc. | Processing high volume network data |
CN105989060A (en) * | 2015-02-09 | 2016-10-05 | 阿里巴巴集团控股有限公司 | Data management method and device |
US10025823B2 (en) * | 2015-05-29 | 2018-07-17 | Oracle International Corporation | Techniques for evaluating query predicates during in-memory table scans |
US9591489B2 (en) | 2015-07-09 | 2017-03-07 | International Business Machines Corporation | Controlling application access to applications and resources via graphical representation and manipulation |
US10067954B2 (en) | 2015-07-22 | 2018-09-04 | Oracle International Corporation | Use of dynamic dictionary encoding with an associated hash table to support many-to-many joins and aggregations |
US10366083B2 (en) | 2015-07-29 | 2019-07-30 | Oracle International Corporation | Materializing internal computations in-memory to improve query performance |
US10204135B2 (en) | 2015-07-29 | 2019-02-12 | Oracle International Corporation | Materializing expressions within in-memory virtual column units to accelerate analytic queries |
US10558339B1 (en) | 2015-09-11 | 2020-02-11 | Palantir Technologies Inc. | System and method for analyzing electronic communications and a collaborative electronic communications user interface |
US10789131B2 (en) | 2015-10-23 | 2020-09-29 | Oracle International Corporation | Transportable backups for pluggable database relocation |
US10289980B2 (en) * | 2015-11-24 | 2019-05-14 | Ariba, Inc. | In-memory index for evaluating a complex expression |
US9798787B1 (en) | 2015-12-10 | 2017-10-24 | Palantir Technologies Inc. | System and user interfaces for searching resources and related documents using data structures |
US10706368B2 (en) * | 2015-12-30 | 2020-07-07 | Veritas Technologies Llc | Systems and methods for efficiently classifying data objects |
US10061832B2 (en) | 2016-11-28 | 2018-08-28 | Oracle International Corporation | Database tuple-encoding-aware data partitioning in a direct memory access engine |
US10055358B2 (en) | 2016-03-18 | 2018-08-21 | Oracle International Corporation | Run length encoding aware direct memory access filtering engine for scratchpad enabled multicore processors |
US10402425B2 (en) | 2016-03-18 | 2019-09-03 | Oracle International Corporation | Tuple encoding aware direct memory access engine for scratchpad enabled multi-core processors |
US10061714B2 (en) | 2016-03-18 | 2018-08-28 | Oracle International Corporation | Tuple encoding aware direct memory access engine for scratchpad enabled multicore processors |
CN107231283B (en) * | 2016-03-23 | 2020-12-18 | 阿里巴巴集团控股有限公司 | Message management method and device and message pre-reading method and device |
US10554516B1 (en) | 2016-06-09 | 2020-02-04 | Palantir Technologies Inc. | System to collect and visualize software usage metrics |
US10552531B2 (en) | 2016-08-11 | 2020-02-04 | Palantir Technologies Inc. | Collaborative spreadsheet data validation and integration |
US10373078B1 (en) | 2016-08-15 | 2019-08-06 | Palantir Technologies Inc. | Vector generation for distributed data sets |
US10303894B2 (en) | 2016-08-31 | 2019-05-28 | Oracle International Corporation | Fine-grained access control for data manipulation language (DML) operations on relational data |
US10540217B2 (en) | 2016-09-16 | 2020-01-21 | Oracle International Corporation | Message cache sizing |
US10650086B1 (en) | 2016-09-27 | 2020-05-12 | Palantir Technologies Inc. | Systems, methods, and framework for associating supporting data in word processing |
US10152306B2 (en) | 2016-11-07 | 2018-12-11 | Palantir Technologies Inc. | Framework for developing and deploying applications |
US10459859B2 (en) | 2016-11-28 | 2019-10-29 | Oracle International Corporation | Multicast copy ring for database direct memory access filtering engine |
US10725947B2 (en) | 2016-11-29 | 2020-07-28 | Oracle International Corporation | Bit vector gather row count calculation and handling in direct memory access engine |
US10261763B2 (en) | 2016-12-13 | 2019-04-16 | Palantir Technologies Inc. | Extensible data transformation authoring and validation system |
FR3061337A1 (en) | 2016-12-23 | 2018-06-29 | Dhatim | UNIVERSAL AND OPTIMIZED RULES ENGINE FOR THE PROCESSING OF MANAGEMENT DOCUMENTS |
US10509844B1 (en) | 2017-01-19 | 2019-12-17 | Palantir Technologies Inc. | Network graph parser |
US10180934B2 (en) | 2017-03-02 | 2019-01-15 | Palantir Technologies Inc. | Automatic translation of spreadsheets into scripts |
US10572576B1 (en) | 2017-04-06 | 2020-02-25 | Palantir Technologies Inc. | Systems and methods for facilitating data object extraction from unstructured documents |
US10824604B1 (en) | 2017-05-17 | 2020-11-03 | Palantir Technologies Inc. | Systems and methods for data entry |
US10534595B1 (en) | 2017-06-30 | 2020-01-14 | Palantir Technologies Inc. | Techniques for configuring and validating a data pipeline deployment |
US10204119B1 (en) | 2017-07-20 | 2019-02-12 | Palantir Technologies, Inc. | Inferring a dataset schema from input files |
US10754820B2 (en) | 2017-08-14 | 2020-08-25 | Palantir Technologies Inc. | Customizable pipeline for integrating data |
US11016936B1 (en) | 2017-09-05 | 2021-05-25 | Palantir Technologies Inc. | Validating data for integration |
US11386058B2 (en) * | 2017-09-29 | 2022-07-12 | Oracle International Corporation | Rule-based autonomous database cloud service framework |
US11327932B2 (en) | 2017-09-30 | 2022-05-10 | Oracle International Corporation | Autonomous multitenant database cloud service framework |
CN107729496B (en) * | 2017-10-19 | 2018-08-28 | 珠海图思科软件有限公司 | SQL statement tuning method based on inscriptions on bones or tortoise shells In-Memory |
US11379525B1 (en) | 2017-11-22 | 2022-07-05 | Palantir Technologies Inc. | Continuous builds of derived datasets in response to other dataset updates |
US10552524B1 (en) | 2017-12-07 | 2020-02-04 | Palantir Technolgies Inc. | Systems and methods for in-line document tagging and object based data synchronization |
US10360252B1 (en) | 2017-12-08 | 2019-07-23 | Palantir Technologies Inc. | Detection and enrichment of missing data or metadata for large data sets |
US11176116B2 (en) | 2017-12-13 | 2021-11-16 | Palantir Technologies Inc. | Systems and methods for annotating datasets |
US10853352B1 (en) | 2017-12-21 | 2020-12-01 | Palantir Technologies Inc. | Structured data collection, presentation, validation and workflow management |
US10866963B2 (en) | 2017-12-28 | 2020-12-15 | Dropbox, Inc. | File system authentication |
GB201800595D0 (en) | 2018-01-15 | 2018-02-28 | Palantir Technologies Inc | Management of software bugs in a data processing system |
US10599762B1 (en) | 2018-01-16 | 2020-03-24 | Palantir Technologies Inc. | Systems and methods for creating a dynamic electronic form |
US10885021B1 (en) | 2018-05-02 | 2021-01-05 | Palantir Technologies Inc. | Interactive interpreter and graphical user interface |
US11263263B2 (en) | 2018-05-30 | 2022-03-01 | Palantir Technologies Inc. | Data propagation and mapping system |
US10795909B1 (en) | 2018-06-14 | 2020-10-06 | Palantir Technologies Inc. | Minimized and collapsed resource dependency path |
US11226955B2 (en) | 2018-06-28 | 2022-01-18 | Oracle International Corporation | Techniques for enabling and integrating in-memory semi-structured data and text document searches with in-memory columnar query processing |
CN109145013A (en) * | 2018-08-10 | 2019-01-04 | 上海达梦数据库有限公司 | A kind of expression formula conversion method, device, equipment and storage medium |
CN110109957B (en) * | 2019-03-29 | 2021-10-01 | 奇安信科技集团股份有限公司 | Streaming event correlation matching method and device |
US11636124B1 (en) * | 2020-11-25 | 2023-04-25 | Amazon Technologies, Inc. | Integrating query optimization with machine learning model prediction |
KR102490281B1 (en) * | 2020-12-21 | 2023-01-19 | 부산대학교 산학협력단 | Method and Apparatus for Analysis of Product Defect |
Family Cites Families (101)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US152149A (en) * | 1874-06-16 | Improvement in distributing apparatus for derricks | ||
US193575A (en) * | 1877-07-24 | Improvement in names | ||
US46421A (en) * | 1865-02-14 | Improved machine for | ||
US236834A (en) * | 1881-01-18 | Magazine fire-arm | ||
US47270A (en) * | 1865-04-18 | Improvement in feed-bags for horses | ||
US181543A (en) * | 1876-08-29 | Improvement in dumb-waiters | ||
US32475A (en) * | 1861-06-04 | Clothes-wringer | ||
US120642A (en) * | 1871-11-07 | Improvement in cutting up and punching sole-leather | ||
US4815030A (en) | 1986-09-03 | 1989-03-21 | Wang Laboratories, Inc. | Multitask subscription data retrieval system |
US5072405A (en) | 1988-10-31 | 1991-12-10 | Digital Equipment Corporation | RETE network with provisional satisfaction of node conditions |
US8700458B2 (en) | 1989-05-01 | 2014-04-15 | Catalina Marketing Corporation | System, method, and database for processing transactions |
US6044205A (en) * | 1996-02-29 | 2000-03-28 | Intermind Corporation | Communications system for transferring information between memories according to processes transferred with the information |
US5466885A (en) * | 1990-09-27 | 1995-11-14 | Furukawa Denki Kogyo Kabushiki Kaisha | Magnetically shielding structure |
JP2929042B2 (en) | 1991-09-30 | 1999-08-03 | 国際電気株式会社 | Portable financial information reporting system and its control device |
US5283856A (en) | 1991-10-04 | 1994-02-01 | Beyond, Inc. | Event-driven rule-based messaging system |
US5627764A (en) | 1991-10-04 | 1997-05-06 | Banyan Systems, Inc. | Automatic electronic messaging system with feedback and work flow administration |
US5446885A (en) | 1992-05-15 | 1995-08-29 | International Business Machines Corporation | Event driven management information system with rule-based applications structure stored in a relational database |
US5530855A (en) | 1992-10-13 | 1996-06-25 | International Business Machines Corporation | Replicating a database by the sequential application of hierarchically sorted log records |
GB2274182B (en) | 1993-01-09 | 1996-09-25 | Digital Equipment Int | Database co-processor |
JPH06319024A (en) | 1993-05-07 | 1994-11-15 | Nippon Rojisuteikusu Kk | Facsimile server system |
JPH0816378A (en) | 1994-06-30 | 1996-01-19 | Fujitsu Ltd | Method and device for analyzing program reverse |
US5870552A (en) | 1995-03-28 | 1999-02-09 | America Online, Inc. | Method and apparatus for publishing hypermedia documents over wide area networks |
US5564047A (en) | 1995-04-11 | 1996-10-08 | International Business Machines Corporation | Trigger generation in an active database management system |
US5692125A (en) | 1995-05-09 | 1997-11-25 | International Business Machines Corporation | System and method for scheduling linked events with fixed and dynamic conditions |
CA2176164A1 (en) | 1995-05-19 | 1996-11-20 | Hosagrahar Visvesvaraya Jagadish | Method for managing rule conflicts in active rule-based systems |
US5873084A (en) | 1996-01-18 | 1999-02-16 | Sun Microsystems, Inc. | Database network connectivity product |
US5870605A (en) | 1996-01-18 | 1999-02-09 | Sun Microsystems, Inc. | Middleware for enterprise information distribution |
US5999946A (en) | 1996-04-10 | 1999-12-07 | Harris Corporation | Databases in telecommunications |
US5864871A (en) | 1996-06-04 | 1999-01-26 | Multex Systems | Information delivery system and method including on-line entitlements |
US5870747A (en) | 1996-07-09 | 1999-02-09 | Informix Software, Inc. | Generalized key indexes |
US5995980A (en) | 1996-07-23 | 1999-11-30 | Olson; Jack E. | System and method for database update replication |
US5852818A (en) | 1996-12-23 | 1998-12-22 | Oracle Corporation | Non-recursive method for parameter evaluation within an information management system |
US5984786A (en) * | 1997-01-03 | 1999-11-16 | 2 Am Inc. | Run-time environment for simulations and games |
JPH10222493A (en) | 1997-02-06 | 1998-08-21 | Kokusai Denshin Denwa Co Ltd <Kdd> | Mutual causality analysis system |
AU6440398A (en) | 1997-02-26 | 1998-09-18 | Siebel Systems, Inc. | Method of using a cache to determine the visibility to a remote database client of a plurality of database transactions |
US6067540A (en) | 1997-02-28 | 2000-05-23 | Oracle Corporation | Bitmap segmentation |
US5940839A (en) | 1997-04-04 | 1999-08-17 | Hewlett-Packard Company | Fault-tolerant system and method of managing transaction failures in hierarchies |
US5873075A (en) | 1997-06-30 | 1999-02-16 | International Business Machines Corporation | Synchronization of SQL actions in a relational database system |
US6038601A (en) | 1997-07-21 | 2000-03-14 | Tibco, Inc. | Method and apparatus for storing and delivering documents on the internet |
US5999931A (en) | 1997-10-17 | 1999-12-07 | Lucent Technologies Inc. | Concurrency control protocols for management of replicated data items in a distributed database system |
US6490574B1 (en) | 1997-12-17 | 2002-12-03 | International Business Machines Corporation | Method and system for managing rules and events in a multi-user intelligent agent environment |
US6122639A (en) | 1997-12-23 | 2000-09-19 | Cisco Technology, Inc. | Network device information collection and change detection |
US6073129A (en) | 1997-12-29 | 2000-06-06 | Bull Hn Information Systems Inc. | Method and apparatus for improving the performance of a database management system through a central cache mechanism |
US6182086B1 (en) | 1998-03-02 | 2001-01-30 | Microsoft Corporation | Client-server computer system with application recovery of server applications and client applications |
US6560592B1 (en) | 1998-03-19 | 2003-05-06 | Micro Data Base Systems, Inc. | Multi-model computer database storage system with integrated rule engine |
US6247017B1 (en) | 1998-03-20 | 2001-06-12 | Sun Microsystems, Inc. | Server-client communication over a network |
US6304882B1 (en) | 1998-05-05 | 2001-10-16 | Informix Software, Inc. | Data replication system and method |
EP0959416A3 (en) | 1998-05-08 | 2005-08-10 | International Business Machines Corporation | Using database query technology for message subscriptions in messaging systems |
JP3004008B1 (en) | 1998-10-20 | 2000-01-31 | 三菱電機株式会社 | Update history management device and update history management method |
US6185555B1 (en) | 1998-10-31 | 2001-02-06 | M/A/R/C Inc. | Method and apparatus for data management using an event transition network |
US6285997B1 (en) | 1998-11-16 | 2001-09-04 | International Business Machines Corporation | Query optimization with deferred update and autonomous sources |
US6738975B1 (en) * | 1998-11-18 | 2004-05-18 | Software Ag, Inc. | Extensible distributed enterprise application integration system |
US6442568B1 (en) | 1998-12-11 | 2002-08-27 | Compaq Computer Corporation | Customer information control system application programming interface with transient data functions, in a loosely coupled data processing environment |
US6473772B1 (en) | 1998-12-17 | 2002-10-29 | International Business Machines Corporation | Apparatus and methods for dynamic simulation event triggering |
DE10003015A1 (en) | 1999-02-06 | 2000-08-17 | Ibm | Computer-aided method for automatically transforming a process model |
US6233537B1 (en) | 1999-03-26 | 2001-05-15 | E.Piphany, Inc. | Workflow modeling language |
US6539381B1 (en) | 1999-04-21 | 2003-03-25 | Novell, Inc. | System and method for synchronizing database information |
US6728879B1 (en) | 1999-06-02 | 2004-04-27 | Microsoft Corporation | Transactional log with multi-sector log block validation |
US6405191B1 (en) | 1999-07-21 | 2002-06-11 | Oracle Corporation | Content based publish-and-subscribe system integrated in a relational database system |
US6801915B1 (en) | 1999-07-28 | 2004-10-05 | Robert Mack | Paired keys for data structures |
GB2354847A (en) | 1999-09-28 | 2001-04-04 | Ibm | Publish/subscribe data processing with subscription points for customised message processing |
GB2354848A (en) | 1999-09-28 | 2001-04-04 | Ibm | Publish/subscribe data processing with subscriber requested messageflow for customised message processing |
US6604093B1 (en) | 1999-12-27 | 2003-08-05 | International Business Machines Corporation | Situation awareness system |
US7016910B2 (en) | 1999-12-30 | 2006-03-21 | Decode Genetics Ehf. | Indexing, rewriting and efficient querying of relations referencing semistructured data |
AU2001227857A1 (en) | 2000-01-14 | 2001-07-24 | Saba Software, Inc. | Method and apparatus for a business applications management system platform |
US6604100B1 (en) | 2000-02-09 | 2003-08-05 | At&T Corp. | Method for converting relational data into a structured document |
WO2001061565A1 (en) | 2000-02-16 | 2001-08-23 | Askit Systems Inc. | Customer service system and method |
US7080382B2 (en) | 2000-02-25 | 2006-07-18 | Oracle International Corporation | Accessing shorter-duration instances of activatable objects based on object references stored in longer-duration memory |
US6427146B1 (en) | 2000-03-31 | 2002-07-30 | Wesley W. Chu | Database event detection and notification system using type abstraction hierarchy (TAH) |
US6681383B1 (en) | 2000-04-04 | 2004-01-20 | Sosy, Inc. | Automatic software production system |
GB2367407B (en) | 2000-05-18 | 2004-12-29 | Daiwa Shoken Group Honsha Kabu | Transmission method for stock price information,system of the same,notification information database therefor,condition detection server and customer terminal |
US6925476B1 (en) | 2000-08-17 | 2005-08-02 | Fusionone, Inc. | Updating application data including adding first change log to aggreagate change log comprising summary of changes |
WO2002021413A2 (en) | 2000-09-05 | 2002-03-14 | Zaplet, Inc. | Methods and apparatus providing electronic messages that are linked and aggregated |
US20020069157A1 (en) * | 2000-09-15 | 2002-06-06 | Jordan Michael S. | Exchange fusion |
US20030061061A1 (en) | 2000-10-27 | 2003-03-27 | Cox Earl D. | Uniform data model |
US6493701B2 (en) | 2000-11-22 | 2002-12-10 | Sybase, Inc. | Database system with methodogy providing faster N-ary nested loop joins |
US7844666B2 (en) | 2000-12-12 | 2010-11-30 | Microsoft Corporation | Controls and displays for acquiring preferences, inspecting behavior, and guiding the learning and decision policies of an adaptive communications prioritization and routing system |
US6931644B2 (en) | 2000-12-21 | 2005-08-16 | International Business Machines Corporation | Hierarchical connected graph model for implementation of event management design |
US20020091685A1 (en) | 2001-01-10 | 2002-07-11 | Letmeknow Technology | System and method for filtering data events |
US7162467B2 (en) | 2001-02-22 | 2007-01-09 | Greenplum, Inc. | Systems and methods for managing distributed database resources |
US7103586B2 (en) | 2001-03-16 | 2006-09-05 | Gravic, Inc. | Collision avoidance in database replication systems |
US7177866B2 (en) | 2001-03-16 | 2007-02-13 | Gravic, Inc. | Asynchronous coordinated commit replication and dual write with replication transmission and locking of target database on updates only |
US6697791B2 (en) | 2001-05-04 | 2004-02-24 | International Business Machines Corporation | System and method for systematic construction of correlation rules for event management |
US6868413B1 (en) | 2001-05-10 | 2005-03-15 | Networks Associates Technology, Inc. | System and method for customizing and processing business logic rules in a business process system |
US6918107B2 (en) * | 2001-07-02 | 2005-07-12 | Bea Systems, Inc. | Programming language extensions for processing data representation language objects and related applications |
US6745209B2 (en) | 2001-08-15 | 2004-06-01 | Iti, Inc. | Synchronization of plural databases in a database replication system |
US6901410B2 (en) | 2001-09-10 | 2005-05-31 | Marron Pedro Jose | LDAP-based distributed cache technology for XML |
US7089228B2 (en) | 2002-04-18 | 2006-08-08 | International Business Machines Corporation | Computer apparatus and method for caching results of a database query |
US7127467B2 (en) | 2002-05-10 | 2006-10-24 | Oracle International Corporation | Managing expressions in a database system |
US6691155B2 (en) | 2002-06-20 | 2004-02-10 | Linda Gottfried | Multimedia system for sharing brand information keeps history of modifications of production information by consumers to allow recreating multimedia interface in its previous formats |
US6917946B2 (en) | 2002-08-12 | 2005-07-12 | International Business Machines Corporation | Method and system for partitioning filter rules for multi-search enforcement |
US7149738B2 (en) * | 2002-12-16 | 2006-12-12 | International Business Machines Corporation | Resource and data administration technologies for IT non-experts |
US7644361B2 (en) | 2002-12-23 | 2010-01-05 | Canon Kabushiki Kaisha | Method of using recommendations to visually create new views of data across heterogeneous sources |
US20040193575A1 (en) | 2003-03-25 | 2004-09-30 | Chia-Hsun Chen | Path expressions and SQL select statement in object oriented language |
CA2472887A1 (en) | 2003-06-30 | 2004-12-30 | Gravic, Inc. | Methods for ensuring referential integrity in multithreaded replication engines |
US7289988B2 (en) | 2003-07-08 | 2007-10-30 | Hewlett-Packard Development Company, L.P. | Method and system for managing events |
US7984021B2 (en) | 2003-12-05 | 2011-07-19 | International Business Machines Corporation | Optimal use of triggers for detecting database events |
US8688634B2 (en) | 2004-02-27 | 2014-04-01 | International Business Machines Corporation | Asynchronous peer-to-peer data replication |
US7406477B2 (en) * | 2004-03-12 | 2008-07-29 | Sybase, Inc. | Database system with methodology for automated determination and selection of optimal indexes |
US20050222996A1 (en) | 2004-03-30 | 2005-10-06 | Oracle International Corporation | Managing event-condition-action rules in a database system |
US7945569B2 (en) * | 2004-03-31 | 2011-05-17 | Hewlett-Packard Development Company, L.P. | Method and apparatus for querying spatial data |
-
2002
- 2002-09-24 US US10/254,383 patent/US7127467B2/en not_active Expired - Lifetime
-
2003
- 2003-02-12 US US10/365,771 patent/US7107282B1/en not_active Expired - Lifetime
- 2003-04-17 US US10/418,882 patent/US7366713B2/en active Active
- 2003-05-08 AU AU2003249632A patent/AU2003249632B2/en not_active Expired
- 2003-05-08 EP EP03753016A patent/EP1504380A2/en not_active Ceased
- 2003-05-08 CN CNB038105705A patent/CN100428227C/en not_active Expired - Lifetime
- 2003-05-08 CA CA2484009A patent/CA2484009C/en not_active Expired - Lifetime
- 2003-05-08 JP JP2004505912A patent/JP2005525657A/en active Pending
- 2003-05-08 WO PCT/US2003/014892 patent/WO2003098479A2/en not_active Application Discontinuation
-
2006
- 2006-05-26 US US11/441,622 patent/US7590650B2/en not_active Expired - Lifetime
Also Published As
Publication number | Publication date |
---|---|
US20030212670A1 (en) | 2003-11-13 |
CN1653452A (en) | 2005-08-10 |
US20030212657A1 (en) | 2003-11-13 |
AU2003249632B2 (en) | 2008-07-10 |
JP2005525657A (en) | 2005-08-25 |
CN100428227C (en) | 2008-10-22 |
US20060218194A1 (en) | 2006-09-28 |
CA2484009C (en) | 2012-12-11 |
US7127467B2 (en) | 2006-10-24 |
WO2003098479A2 (en) | 2003-11-27 |
US7107282B1 (en) | 2006-09-12 |
US7366713B2 (en) | 2008-04-29 |
AU2003249632A1 (en) | 2003-12-02 |
WO2003098479A3 (en) | 2004-04-08 |
EP1504380A2 (en) | 2005-02-09 |
US7590650B2 (en) | 2009-09-15 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CA2484009A1 (en) | Managing expressions in a database system | |
US9870382B2 (en) | Data encoding and corresponding data structure | |
CA2562281C (en) | Partial query caching | |
JP2005525657A5 (en) | ||
US7761455B2 (en) | Loading data from a vertical database table into a horizontal database table | |
CA2751295C (en) | Analysis of object structures such as benefits and provider contracts | |
US20060206466A1 (en) | Evaluating relevance of results in a semi-structured data-base system | |
CN104462434A (en) | Data inquiring method and device | |
CN102054007A (en) | Searching method and searching device | |
CN101216837A (en) | Method and system for displaying search result based on matching user personalized configuration | |
US20120185461A1 (en) | Method, system and program product for rewriting structured query language (sql) statements | |
CN109684336A (en) | The system and method for tree data table efficient retrieval and ranking function is realized based on big data application | |
US20110153582A1 (en) | Handling of classification data by a search engine | |
CN106557499A (en) | HBase secondary indexs creation method and device | |
CA2461871A1 (en) | An efficient index structure to access hierarchical data in a relational database system | |
CN113515610B (en) | File management method based on object-oriented language processing | |
CN106649385B (en) | Data reordering method and device based on HBase database | |
CN106708946A (en) | Universal API table query method | |
KR101955376B1 (en) | Processing method for a relational query in distributed stream processing engine based on shared-nothing architecture, recording medium and device for performing the method | |
CN107633094A (en) | The method and apparatus of data retrieval in a kind of cluster environment | |
KR101052220B1 (en) | Skyline Query Execution Device and Method Including Search Terms | |
CN107577741A (en) | A kind of processing method and processing device of data query | |
CN108614900A (en) | A kind of data method for quickly retrieving and system | |
CN116821164B (en) | Searching method for realizing visual flexible combination dynamic configuration | |
CN113032400B (en) | High-performance TopN query method, system and medium for mass data |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
EEER | Examination request | ||
MKEX | Expiry |
Effective date: 20230508 |