[go: up one dir, main page]

WO2008063596A3 - Method and system for defining data analysis queries - Google Patents

Method and system for defining data analysis queries Download PDF

Info

Publication number
WO2008063596A3
WO2008063596A3 PCT/US2007/024154 US2007024154W WO2008063596A3 WO 2008063596 A3 WO2008063596 A3 WO 2008063596A3 US 2007024154 W US2007024154 W US 2007024154W WO 2008063596 A3 WO2008063596 A3 WO 2008063596A3
Authority
WO
WIPO (PCT)
Prior art keywords
query
syntax
data analysis
techniques
defining data
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.)
Ceased
Application number
PCT/US2007/024154
Other languages
French (fr)
Other versions
WO2008063596A9 (en
WO2008063596A2 (en
Inventor
Mohan S Shetye
Amol A Salunkhe
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
INTEGRAL INFORMATION SYSTEMS LLC
INTEGRAL INFORMATION SYSTEMS L
Original Assignee
INTEGRAL INFORMATION SYSTEMS LLC
INTEGRAL INFORMATION SYSTEMS L
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by INTEGRAL INFORMATION SYSTEMS LLC, INTEGRAL INFORMATION SYSTEMS L filed Critical INTEGRAL INFORMATION SYSTEMS LLC
Publication of WO2008063596A2 publication Critical patent/WO2008063596A2/en
Publication of WO2008063596A3 publication Critical patent/WO2008063596A3/en
Publication of WO2008063596A9 publication Critical patent/WO2008063596A9/en
Anticipated expiration legal-status Critical
Ceased legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/24—Querying
    • G06F16/242—Query formulation
    • G06F16/2423—Interactive query statement specification based on a database schema

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

Methods and systems for formulating an On-Line Analytical Processing type query for a relational database without requiring the user to understand or learn a complex syntax are provided. Some embodiments provide a graphical user interface, eliminating a need for a query builder to know the syntax. The techniques define the query as comprising connectors, working relations, organizers, selectors, criteria evaluators, arithmetic calculators, validators and result viewer. A query structured according to these techniques can be executed using any suitable programming language and/or directly from different representations of the query, including graphical, textual, and/or hybrid representations.
PCT/US2007/024154 2006-11-20 2007-11-16 Method and system for defining data analysis queries Ceased WO2008063596A2 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US86658006P 2006-11-20 2006-11-20
US60/866,580 2006-11-20

Publications (3)

Publication Number Publication Date
WO2008063596A2 WO2008063596A2 (en) 2008-05-29
WO2008063596A3 true WO2008063596A3 (en) 2008-10-23
WO2008063596A9 WO2008063596A9 (en) 2008-12-31

Family

ID=39430355

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2007/024154 Ceased WO2008063596A2 (en) 2006-11-20 2007-11-16 Method and system for defining data analysis queries

Country Status (1)

Country Link
WO (1) WO2008063596A2 (en)

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5428737A (en) * 1991-10-16 1995-06-27 International Business Machines Corporation Comprehensive bilateral translation between SQL and graphically depicted queries
US20050004911A1 (en) * 2002-09-25 2005-01-06 Oracle International Corporation Graphical condition builder for facilitating database queries
US20060004740A1 (en) * 2004-06-10 2006-01-05 International Business Machines Corporation Dynamic graphical database query interface

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5428737A (en) * 1991-10-16 1995-06-27 International Business Machines Corporation Comprehensive bilateral translation between SQL and graphically depicted queries
US20050004911A1 (en) * 2002-09-25 2005-01-06 Oracle International Corporation Graphical condition builder for facilitating database queries
US20060004740A1 (en) * 2004-06-10 2006-01-05 International Business Machines Corporation Dynamic graphical database query interface

Also Published As

Publication number Publication date
WO2008063596A9 (en) 2008-12-31
WO2008063596A2 (en) 2008-05-29

Similar Documents

Publication Publication Date Title
CN107832229B (en) NLP-based system test case automatic generation method
US10817527B1 (en) Systems and methods of using natural language processing for visual analysis of a data set
KR102128659B1 (en) System and Method for Extracting Keyword and Generating Abstract
CN101464897A (en) Word matching and information query method and device
WO2008088722A3 (en) Querying data and an associated ontology in a database management system
CN102254038A (en) System and method for analyzing network comment relevance
CN104657346A (en) Question matching system and question matching system in intelligent interaction system
EP4575458A3 (en) Systems and methods for panel design in flow cytometry
WO2008070744A3 (en) Centralized web-based software solution for search engine optimization
WO2008066637A3 (en) Generation of a multidimensional dataset from an associative database
CN104657393A (en) Public opinion analysis method and corresponding device
WO2010014981A3 (en) Method and apparatus for detection and optimization of presumably parallel program regions
WO2012126015A3 (en) Xbrl database mapping system and method
MX2008014893A (en) System and method for organizing, processing and presenting information.
WO2007075417A3 (en) System and method for analyzing communications using multi-dimensional hierarchical structures
CN104699667A (en) Semantic dictionary-based improved word similarity calculating method and device
CN102193940A (en) Method of carrying out characteristic analysis and data extraction on two-dimensional table
Saad et al. OLAP Manipulations on RDF Data following a Constellation Model.
CN104298657A (en) Evaluation index analysis system based on expression
US20150187011A1 (en) Computerized system and method of evaluating insurance product underwriting and rating data
WO2008063596A3 (en) Method and system for defining data analysis queries
CN103744844A (en) Data mining method based on PMML
CN116306590A (en) Knowledge-driven standpoint analysis method for specific topics
CN102521239B (en) Question-answering information matching system and method based on OWL (web ontology language) for Internet
Tairas Clone detection and refactoring

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 07853131

Country of ref document: EP

Kind code of ref document: A2

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 07853131

Country of ref document: EP

Kind code of ref document: A2