EP2992447A4 - Database table column annotation - Google Patents

Database table column annotation

Info

Publication number
EP2992447A4
EP2992447A4 EP13883528.5A EP13883528A EP2992447A4 EP 2992447 A4 EP2992447 A4 EP 2992447A4 EP 13883528 A EP13883528 A EP 13883528A EP 2992447 A4 EP2992447 A4 EP 2992447A4
Authority
EP
European Patent Office
Prior art keywords
database table
table column
column annotation
annotation
database
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
EP13883528.5A
Other languages
German (de)
French (fr)
Other versions
EP2992447A1 (en
Inventor
Hoa Binh Nga Tran
Lakshmikant Shrinivas
Kanti Marita Mann
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.)
Micro Focus LLC
Original Assignee
Hewlett Packard Enterprise Development LP
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 Hewlett Packard Enterprise Development LP filed Critical Hewlett Packard Enterprise Development LP
Publication of EP2992447A1 publication Critical patent/EP2992447A1/en
Publication of EP2992447A4 publication Critical patent/EP2992447A4/en
Ceased legal-status Critical Current

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/22—Indexing; Data structures therefor; Storage structures
    • G06F16/221—Column-oriented storage; Management thereof
    • 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/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/284—Relational 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/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
    • G06F16/211—Schema design and management
    • 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/23—Updating
    • G06F16/2379—Updates performed during online database operations; commit processing
    • 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/245—Query processing
    • G06F16/2453—Query optimisation
    • G06F16/24534—Query rewriting; Transformation
    • G06F16/24542—Plan optimisation
    • G06F16/24545—Selectivity estimation or determination
    • 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/245—Query processing
    • G06F16/2455—Query execution
    • G06F16/24564—Applying rules; Deductive queries
    • G06F16/24565—Triggers; Constraints

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Computational Linguistics (AREA)
  • Operations Research (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
EP13883528.5A 2013-04-30 2013-04-30 Database table column annotation Ceased EP2992447A4 (en)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
PCT/US2013/038842 WO2014178843A1 (en) 2013-04-30 2013-04-30 Database table column annotation

Publications (2)

Publication Number Publication Date
EP2992447A1 EP2992447A1 (en) 2016-03-09
EP2992447A4 true EP2992447A4 (en) 2016-09-21

Family

ID=51843813

Family Applications (1)

Application Number Title Priority Date Filing Date
EP13883528.5A Ceased EP2992447A4 (en) 2013-04-30 2013-04-30 Database table column annotation

Country Status (4)

Country Link
US (1) US10248620B2 (en)
EP (1) EP2992447A4 (en)
CN (1) CN105408883B (en)
WO (1) WO2014178843A1 (en)

Families Citing this family (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9645986B2 (en) * 2011-02-24 2017-05-09 Google Inc. Method, medium, and system for creating an electronic book with an umbrella policy
US10169418B2 (en) * 2014-09-24 2019-01-01 International Business Machines Corporation Deriving a multi-pass matching algorithm for data de-duplication
US10817504B2 (en) * 2018-03-29 2020-10-27 Sap Se Constraint satisfaction software tool for database tables
JP7077181B2 (en) * 2018-08-24 2022-05-30 株式会社日立製作所 Equipment analysis support device, equipment analysis support method, and equipment analysis system
US10942908B2 (en) * 2019-01-14 2021-03-09 Business Objects Software Ltd. Primary key determination

Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5995957A (en) * 1997-02-28 1999-11-30 International Business Machines Corporation Query optimization through the use of multi-column statistics to avoid the problems of column correlation
US20030014390A1 (en) * 2001-07-12 2003-01-16 Finlay Ian R. Method and system for unordered relational database retrieval returning distinct values
US20050131913A1 (en) * 2003-12-11 2005-06-16 International Business Machines Corporation Database range constraint that is dynamically limited by data in the database
US20050198048A1 (en) * 2004-03-04 2005-09-08 International Business Machines Corporation Database relationship constraint
US7328212B2 (en) * 2001-05-31 2008-02-05 Oracle International Corporation Generalized method for modeling complex ordered check constraints in a relational database system
US20090150421A1 (en) * 2002-06-10 2009-06-11 International Business Machines Corporation Incremental cardinality estimation for a set of data values
US20100114869A1 (en) * 2008-10-27 2010-05-06 Vinay Deolalikar Generating a query plan for estimating a number of unique attributes in a database
US8229917B1 (en) * 2011-02-24 2012-07-24 International Business Machines Corporation Database query optimization using clustering data mining

Family Cites Families (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5546576A (en) 1995-02-17 1996-08-13 International Business Machines Corporation Query optimizer system that detects and prevents mutating table violations of database integrity in a query before execution plan generation
CA2146171C (en) * 1995-04-03 2000-01-11 Bernhard Schiefer Method for estimating cardinalities for query processing in a relational database management system
US6212514B1 (en) * 1998-07-31 2001-04-03 International Business Machines Corporation Data base optimization method for estimating query and trigger procedure costs
KR100494856B1 (en) * 1999-12-30 2005-06-14 주식회사 케이티 Realization method to guarantee unique data on database
US6662175B1 (en) 2001-05-08 2003-12-09 Ncr Corporation Semantic query optimization using value correlation
AU2002334721B2 (en) * 2001-09-28 2008-10-23 Oracle International Corporation An index structure to access hierarchical data in a relational database system
US20040243555A1 (en) * 2003-05-30 2004-12-02 Oracle International Corp. Methods and systems for optimizing queries through dynamic and autonomous database schema analysis
US8027969B2 (en) * 2005-12-29 2011-09-27 Sap Ag Efficient calculation of sets of distinct results in an information retrieval service
US20080077552A1 (en) * 2006-09-27 2008-03-27 Ronald Sanborn Systems and methods for analyzing multiple states in one or more groups of data
US20080140696A1 (en) * 2006-12-07 2008-06-12 Pantheon Systems, Inc. System and method for analyzing data sources to generate metadata
US8027972B2 (en) * 2007-09-26 2011-09-27 International Business Machines Corporation Nodal data normalization
US8443189B2 (en) * 2008-10-24 2013-05-14 International Business Machines Corporation Trust event notification and actions based on thresholds and associated trust metadata scores
CN102567434B (en) * 2010-12-31 2013-04-10 百度在线网络技术（北京）有限公司 Data block processing method
US8856085B2 (en) * 2011-07-19 2014-10-07 International Business Machines Corporation Automatic consistent sampling for data analysis
US9613074B2 (en) * 2013-12-23 2017-04-04 Sap Se Data generation for performance evaluation
US9760593B2 (en) * 2014-09-30 2017-09-12 International Business Machines Corporation Data dictionary with a reduced need for rebuilding

Patent Citations (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5995957A (en) * 1997-02-28 1999-11-30 International Business Machines Corporation Query optimization through the use of multi-column statistics to avoid the problems of column correlation
US7328212B2 (en) * 2001-05-31 2008-02-05 Oracle International Corporation Generalized method for modeling complex ordered check constraints in a relational database system
US20030014390A1 (en) * 2001-07-12 2003-01-16 Finlay Ian R. Method and system for unordered relational database retrieval returning distinct values
US20090150421A1 (en) * 2002-06-10 2009-06-11 International Business Machines Corporation Incremental cardinality estimation for a set of data values
US20050131913A1 (en) * 2003-12-11 2005-06-16 International Business Machines Corporation Database range constraint that is dynamically limited by data in the database
US20050198048A1 (en) * 2004-03-04 2005-09-08 International Business Machines Corporation Database relationship constraint
US20100114869A1 (en) * 2008-10-27 2010-05-06 Vinay Deolalikar Generating a query plan for estimating a number of unique attributes in a database
US8229917B1 (en) * 2011-02-24 2012-07-24 International Business Machines Corporation Database query optimization using clustering data mining

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
See also references of WO2014178843A1 *

Also Published As

Publication number Publication date
EP2992447A1 (en) 2016-03-09
WO2014178843A1 (en) 2014-11-06
US20160078070A1 (en) 2016-03-17
CN105408883B (en) 2018-09-11
CN105408883A (en) 2016-03-16
US10248620B2 (en) 2019-04-02

Similar Documents

Publication Publication Date Title
GB201321539D0 (en) Redundant parallel positioning table
AU354827S (en) Tubing set
EP2965227A4 (en) Template metadata
EP2973356A4 (en) Content creation tool
PL2777671T3 (en) Patient table
HK1215314A1 (en) Querying one or more databases
EP2972840A4 (en) Co-processor-based array-oriented database processing
IL247622B (en) Vertical-based query optionalizing
PL3003240T3 (en) Operating table system
GB201301066D0 (en) Polymorh table with shared columns
EP2992447A4 (en) Database table column annotation
PL2823731T3 (en) Vertically adjustable table construction
GB201309088D0 (en) Database registration
GB201321587D0 (en) Indexing presentation slides
GB201309392D0 (en) Portable table
GB201306280D0 (en) BBQ table
GB2535947B (en) A table
PT2832260T (en) Table
SG10201403600SA (en) Chromatography column
AU354617S (en) Tool stand
AU352790S (en) Bedside table
AU352792S (en) Bedside table
AU356443S (en) Rack column
AU351929S (en) Workbench
AU356504S (en) Linear cutter

Legal Events

Date Code Title Description
PUAI Public reference made under article 153(3) epc to a published international application that has entered the european phase

Free format text: ORIGINAL CODE: 0009012

17P Request for examination filed

Effective date: 20151022

AK Designated contracting states

Kind code of ref document: A1

Designated state(s): AL AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HR HU IE IS IT LI LT LU LV MC MK MT NL NO PL PT RO RS SE SI SK SM TR

AX Request for extension of the european patent

Extension state: BA ME

RIN1 Information on inventor provided before grant (corrected)

Inventor name: SHRINIVAS, LAKSHMIKANT

Inventor name: TRAN, HOA BINH NGA

Inventor name: MANN, KANTI MARITA

RAP1 Party data changed (applicant data changed or rights of an application transferred)

Owner name: HEWLETT PACKARD ENTERPRISE DEVELOPMENT LP

DAX Request for extension of the european patent (deleted)
A4 Supplementary search report drawn up and despatched

Effective date: 20160819

RIC1 Information provided on ipc code assigned before grant

Ipc: G06F 17/30 20060101ALI20160815BHEP

Ipc: G06F 17/00 20060101AFI20160815BHEP

17Q First examination report despatched

Effective date: 20171012

RAP1 Party data changed (applicant data changed or rights of an application transferred)

Owner name: ENTIT SOFTWARE LLC

REG Reference to a national code

Ref country code: DE

Ref legal event code: R003

STAA Information on the status of an ep patent application or granted ep patent

Free format text: STATUS: THE APPLICATION HAS BEEN REFUSED

18R Application refused

Effective date: 20181218