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
Application number
PCT/US2007/024154
Other languages
French (fr)
Other versions
WO2008063596A9 (en
WO2008063596A2 (en
Inventor
Mohan S Shetye
Amol A Salunkhe
Original Assignee
Integral Information Systems L
Mohan S Shetye
Amol A Salunkhe
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 L, Mohan S Shetye, Amol A Salunkhe filed Critical Integral Information Systems L
Publication of WO2008063596A2 publication Critical patent/WO2008063596A2/en
Publication of WO2008063596A3 publication Critical patent/WO2008063596A3/en
Publication of WO2008063596A9 publication Critical patent/WO2008063596A9/en

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/24—Querying
    • G06F16/242—Query formulation
    • G06F16/2423—Interactive query statement specification based on a database schema

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 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 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
WO2007076080A3 (en) Analyzing content to determine context and serving relevant content based on the context
CN104657346A (en) Question matching system and question matching system in intelligent interaction system
WO2007075417A3 (en) System and method for analyzing communications using multi-dimensional hierarchical structures
WO2008027765A3 (en) Apparatus and method for processing queries against combinations of data sources
WO2008085857A3 (en) Processing text with domain-specific spreading activation methods
WO2010014981A3 (en) Method and apparatus for detection and optimization of presumably parallel program regions
CN103246641A (en) Text semantic information analyzing system and method
CN105677716A (en) Computer data acquisition, processing and analysis system
CN104699667A (en) Semantic dictionary-based improved word similarity calculating method and device
Saad et al. OLAP Manipulations on RDF Data following a Constellation Model.
WO2008063596A3 (en) Method and system for defining data analysis queries
CA2519604A1 (en) Master-detail provider and method of providing master-detail functionality
CN103744844A (en) Data mining method based on PMML
Tairas Clone detection and refactoring
CN116306590B (en) Knowledge-driven standpoint analysis method for specific topics
TW200802044A (en) Method and system of identifying an ideographic character
CN103443766A (en) Apparatus for setting affecting extent of program, and method of specifying affecting extent and method of extracting affecting program using same
Scharffe et al. Towards Correspondence Patterns for Ontology Mediation.
Li et al. Evaluation and Improvement of Shifting Quality of the Vehicle Gearbox from the Perspective of Sustainable Development in China’s Vehicle Industry
Houska et al. SPOTPY: A python tool for sensitivity and uncertainty analysis of environmental models
Ellis et al. Collective ontology alignment.
AU2011313859A8 (en) Standardized database access system and method
WO2005093601A3 (en) Multi-agent text analysis
Lonergan et al. Equity, equality, and justice: Mapping concept to technical representations in energy system models

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