EP2460094A4 - Selectivity-based optimized-query-plan caching - Google Patents

Selectivity-based optimized-query-plan caching

Info

Publication number: EP2460094A4
Authority: EP; European Patent Office
Prior art keywords: query; selectivity; based optimized; plan caching; caching
Prior art date: 2009-07-31
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

Application number

EP09847948.8A

Other languages

German (de)

French (fr)

Other versions

EP2460094A1 (en

EP2460094B1 (en

Inventor

Awny K Al-Omari

Qifan Chen

Tom C Reyes

Robert M Wehrmeister

Ahmed K Ezzat

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.)

Hewlett Packard Enterprise Development LP

Original Assignee

Hewlett Packard Development Co 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.)

2009-07-31

Filing date

2009-12-14

Publication date

2014-04-30

2009-12-14 Application filed by Hewlett Packard Development Co LP filed Critical Hewlett Packard Development Co LP

2012-06-06 Publication of EP2460094A1 publication Critical patent/EP2460094A1/en

2014-04-30 Publication of EP2460094A4 publication Critical patent/EP2460094A4/en

2019-05-08 Application granted granted Critical

2019-05-08 Publication of EP2460094B1 publication Critical patent/EP2460094B1/en

Status Not-in-force legal-status Critical Current

2029-12-14 Anticipated expiration legal-status Critical

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/245—Query processing
- G06F16/2452—Query translation
- G06F16/24524—Access plan code generation and invalidation; Reuse of access plans
- 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

Landscapes

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

EP09847948.8A 2009-07-31 2009-12-14 Selectivity-based optimized-query-plan caching Not-in-force EP2460094B1 (en)

Applications Claiming Priority (2)

Application Number	Priority Date	Filing Date	Title
US12/533,365 US8224806B2 (en)	2009-07-31	2009-07-31	Selectivity-based optimized-query-plan caching
PCT/US2009/067849 WO2011014214A1 (en)	2009-07-31	2009-12-14	Selectivity-based optimized-query-plan caching

Publications (3)

Publication Number	Publication Date
EP2460094A1 EP2460094A1 (en)	2012-06-06
EP2460094A4 true EP2460094A4 (en)	2014-04-30
EP2460094B1 EP2460094B1 (en)	2019-05-08

Family

ID=43527954

Family Applications (1)

Application Number	Title	Priority Date	Filing Date
EP09847948.8A Not-in-force EP2460094B1 (en)	2009-07-31	2009-12-14	Selectivity-based optimized-query-plan caching

Country Status (3)

Country	Link
US (1)	US8224806B2 (en)
EP (1)	EP2460094B1 (en)
WO (1)	WO2011014214A1 (en)

Families Citing this family (55)

* Cited by examiner, † Cited by third party
Publication number	Priority date	Publication date	Assignee	Title
US8200660B2 (en) *	2009-10-22	2012-06-12	Hewlett-Packard Development Company, L.P.	System and method for executing queries
US9514243B2 (en) *	2009-12-03	2016-12-06	Microsoft Technology Licensing, Llc	Intelligent caching for requests with query strings
US8874547B2 (en) *	2010-01-04	2014-10-28	Microsoft Corporation	Parameter-sensitive plans
US8250064B1 (en) *	2010-04-06	2012-08-21	Teradata Us, Inc.	Caching execution plans for queries that use timestamps
US9129000B2 (en)	2010-04-30	2015-09-08	International Business Machines Corporation	Method and system for centralized control of database applications
US8818963B2 (en)	2010-10-29	2014-08-26	Microsoft Corporation	Halloween protection in a multi-version database system
US9020969B2 (en) *	2011-07-13	2015-04-28	Sap Se	Tracking queries and retrieved results
US8914353B2 (en) *	2011-12-20	2014-12-16	Sap Se	Many-core algorithms for in-memory column store databases
US8812489B2 (en) *	2012-10-08	2014-08-19	International Business Machines Corporation	Swapping expected and candidate affinities in a query plan cache
US10102248B2 (en) *	2012-10-10	2018-10-16	TmaxData Co., Ltd.	Join type for optimizing database queries
US9087085B2 (en) *	2012-12-10	2015-07-21	International Business Machines Corporation	Pre-assimilation values and post-assimilation values in hardware instance identifiers
US9773041B2 (en)	2013-03-06	2017-09-26	Oracle International Corporation	Methods and apparatus of shared expression evaluation across RDBMS and storage layer
US9195712B2 (en)	2013-03-12	2015-11-24	Microsoft Technology Licensing, Llc	Method of converting query plans to native code
CN104216891B (en) *	2013-05-30	2018-02-02	国际商业机器公司	The optimization method and equipment of query statement in relevant database
US9588978B2 (en)	2013-09-30	2017-03-07	International Business Machines Corporation	Merging metadata for database storage regions based on overlapping range values
US9898383B2 (en) *	2013-10-09	2018-02-20	Salesforce.Com, Inc.	Techniques and mechanisms for managing and analyzing database query activities
US9922088B2 (en) *	2013-12-31	2018-03-20	Sybase, Inc.	Cardinality estimation using spanning trees
US9569492B2 (en)	2014-01-07	2017-02-14	International Business Machines Corporation	Coalescing operation for query processing
US10474645B2 (en)	2014-02-24	2019-11-12	Microsoft Technology Licensing, Llc	Automatically retrying transactions with split procedure execution
US9519687B2 (en)	2014-06-16	2016-12-13	International Business Machines Corporation	Minimizing index maintenance costs for database storage regions using hybrid zone maps and indices
US10042887B2 (en) *	2014-12-05	2018-08-07	International Business Machines Corporation	Query optimization with zone map selectivity modeling
US9600524B2 (en) *	2014-12-22	2017-03-21	Blackberry Limited	Method and system for efficient feature matching
US9519679B2 (en) *	2015-01-19	2016-12-13	Sas Institute Inc.	Techniques for query homogenization in cache operations
US11023443B2 (en) *	2015-02-13	2021-06-01	Teradata Us, Inc.	Collaborative planning for accelerating analytic queries
US20160259825A1 (en) *	2015-03-06	2016-09-08	Dell Products L.P.	Discovery of potential problematic execution plans in a bind-sensitive query statement
US10300240B2 (en) *	2015-05-07	2019-05-28	Aladdin Dreamer, Inc.	Lucid dream stimulator, systems, and related methods
US9922080B2 (en)	2015-06-11	2018-03-20	Hewlett Packard Enterprise Development Lp	Query plan determination
US10503734B2 (en) *	2015-07-14	2019-12-10	Sap Se	External offline query optimization
KR102385908B1 (en)	2015-08-11	2022-04-13	삼성전자주식회사	Method for searching data from storage device
US9892161B2 (en)	2015-08-27	2018-02-13	International Business Machines Corporation	Adaptive intersect query processing
US11341132B2 (en) *	2015-09-01	2022-05-24	Sybase, Inc.	Generating a producer-driven execution plan from a consumer-driven iterator-based execution plan
US10031940B2 (en) *	2015-09-24	2018-07-24	Futurewei Technologies, Inc.	System and method for database query
SG11201804544QA (en) *	2015-11-30	2018-06-28	Huawei Tech Co Ltd	Data query method and apparatus, and database system
CN109313640B (en)	2016-03-31	2022-03-04	慧咨环球有限公司	Method and system for database optimization
AU2016202911A1 (en) *	2016-03-31	2017-10-19	Wisetech Global Limited	Methods and Systems for Database Optimisation
US10983966B2 (en)	2016-04-22	2021-04-20	International Business Machines Corporation	Database algebra and compiler with environments
US11249995B2 (en) *	2016-12-30	2022-02-15	Salesforce.Com, Inc.	Techniques and architectures for providing and operating an application-aware database environment with predictive execution of queries and query flows
US10534773B2 (en) *	2017-03-30	2020-01-14	Microsoft Technology Licensing, Llc	Intelligent query parameterization of database workloads
US10685020B2 (en)	2017-05-12	2020-06-16	Microsoft Technology Licensing, Llc	Re-costing for on-line optimization of parameterized queries with guarantees
US10459889B2 (en) *	2017-06-06	2019-10-29	Sap Se	Multi-user database execution plan caching
US11144548B2 (en) *	2018-04-24	2021-10-12	Dremio Corporation	Optimized data structures of a relational cache with a learning capability for accelerating query execution by a data system
US11727289B2 (en) *	2018-05-04	2023-08-15	International Business Machines Corporation	Iterative generation of top quality plans in automated plan generation for artificial intelligence applications and the like
US11829363B2 (en) *	2018-10-06	2023-11-28	Microsoft Technology Licensing, Llc	Multi-step query execution in SQL server
US12135712B2 (en) *	2018-11-13	2024-11-05	Teradata Us, Inc.	System and method for sharing database query execution plans between multiple parsing engines
CN109871338B (en) *	2019-03-15	2021-01-29	北京思特奇信息技术股份有限公司	Data storage method and device and computer equipment
US11556537B2 (en) *	2019-03-29	2023-01-17	Sap Se	Query plan generation and execution based on single value columns
EP3977308B1 (en) *	2019-05-24	2023-11-22	Huawei Technologies Co., Ltd.	Learning-based query plan cache for capturing low-cost query plan
US11347736B2 (en) *	2019-10-30	2022-05-31	Boray Data Technology Co. Ltd.	Dynamic query optimization
US11748349B2 (en) *	2020-03-31	2023-09-05	Sap Se	Customizable filtering for query plan stability in database systems using abstract query plans
US11314740B1 (en) *	2021-01-29	2022-04-26	Snowflake Inc.	Responsive plan stability
US20220300513A1 (en) *	2021-03-19	2022-09-22	International Business Machines Corporation	Asynchronous query optimization using spare hosts
US11947535B2 (en) *	2021-05-04	2024-04-02	Bank Of America Corporation	Multicomputer system with machine learning engine for query optimization and dynamic data reorganization
US11461327B1 (en) *	2022-04-08	2022-10-04	Snowflake Inc.	Query plan caching for networked database systems
US11803545B1 (en) *	2022-06-24	2023-10-31	Sap Se	Runtime statistics feedback for query plan cost estimation
US11893016B1 (en) *	2022-10-26	2024-02-06	Snowflake Inc.	Secure predicate derivation of queries using metadata

Citations (3)

* Cited by examiner, † Cited by third party
Publication number	Priority date	Publication date	Assignee	Title
US6275818B1 (en) *	1997-11-06	2001-08-14	International Business Machines Corporation	Cost based optimization of decision support queries using transient views
US6356887B1 (en) *	1999-06-28	2002-03-12	Microsoft Corporation	Auto-parameterization of database queries
US20040117359A1 (en) *	2001-03-01	2004-06-17	Snodgrass Richard Thomas	Adaptable query optimization and evaluation in temporal middleware

Family Cites Families (15)

* Cited by examiner, † Cited by third party
Publication number	Priority date	Publication date	Assignee	Title
US5469568A (en) *	1993-01-07	1995-11-21	International Business Machines Corporation	Method for choosing largest selectivities among eligible predicates of join equivalence classes for query optimization
US6434545B1 (en) *	1998-12-16	2002-08-13	Microsoft Corporation	Graphical query analyzer
US6466931B1 (en)	1999-07-30	2002-10-15	International Business Machines Corporation	Method and system for transparently caching and reusing query execution plans efficiently
US6801905B2 (en) *	2002-03-06	2004-10-05	Sybase, Inc.	Database system providing methodology for property enforcement
US20050289098A1 (en)	2004-06-24	2005-12-29	International Business Machines Corporation	Dynamically selecting alternative query access plans
US7882100B2 (en) *	2005-01-24	2011-02-01	Sybase, Inc.	Database system with methodology for generating bushy nested loop join trees
US7640230B2 (en)	2005-04-05	2009-12-29	Microsoft Corporation	Query plan selection control using run-time association mechanism
US7734615B2 (en) *	2005-05-26	2010-06-08	International Business Machines Corporation	Performance data for query optimization of database partitions
US20070250470A1 (en) *	2006-04-24	2007-10-25	Microsoft Corporation	Parallelization of language-integrated collection operations
US20080091642A1 (en) *	2006-10-12	2008-04-17	Robert Joseph Bestgen	Advising the generation of a maintained index over a subset of values in a column of a table
US20080140622A1 (en) *	2006-12-12	2008-06-12	Bestgen Robert J	Displaying Explain Data for a SQL Query of a Database
US20080183684A1 (en) *	2007-01-26	2008-07-31	Bestgen Robert J	Caching an Access Plan for a Query
US20080195577A1 (en) *	2007-02-09	2008-08-14	Wei Fan	Automatically and adaptively determining execution plans for queries with parameter markers
US7984043B1 (en) *	2007-07-24	2011-07-19	Amazon Technologies, Inc.	System and method for distributed query processing using configuration-independent query plans
US20100306188A1 (en) *	2009-06-01	2010-12-02	Microsoft Corporation	Persistent query plans

2009
- 2009-07-31 US US12/533,365 patent/US8224806B2/en not_active Expired - Fee Related
- 2009-12-14 EP EP09847948.8A patent/EP2460094B1/en not_active Not-in-force
- 2009-12-14 WO PCT/US2009/067849 patent/WO2011014214A1/en active Application Filing

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number	Priority date	Publication date	Assignee	Title
US6275818B1 (en) *	1997-11-06	2001-08-14	International Business Machines Corporation	Cost based optimization of decision support queries using transient views
US6356887B1 (en) *	1999-06-28	2002-03-12	Microsoft Corporation	Auto-parameterization of database queries
US20040117359A1 (en) *	2001-03-01	2004-06-17	Snodgrass Richard Thomas	Adaptable query optimization and evaluation in temporal middleware

Non-Patent Citations (1)

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

Also Published As

Publication number	Publication date
EP2460094A1 (en)	2012-06-06
US20110029508A1 (en)	2011-02-03
EP2460094B1 (en)	2019-05-08
WO2011014214A1 (en)	2011-02-03
US8224806B2 (en)	2012-07-17

Publication	Publication Date	Title
EP2460094A4 (en)	2014-04-30	Selectivity-based optimized-query-plan caching
DK3023438T3 (en)	2020-05-11	Anti-gitr-antistoffer
DK2457337T3 (en)	2020-12-07	Specialtilpasset impuls-burst
ZA201202612B (en)	2013-09-25	Combination
EP2266043A4 (en)	2012-02-29	Cache optimzation
EP2462514A4 (en)	2013-05-01	Greenbooks
EP2515891A4 (en)	2013-06-05	3-keto-n-propargyl-1-aminoindan
IL219103A0 (en)	2012-06-28	Combination
EP2519921A4 (en)	2014-03-26	Call-tracking
DK2464943T3 (en)	2020-07-13	Systemintegration
IL219786A0 (en)	2012-07-31	Combination
ZA201202494B (en)	2012-12-27	Combination
ZA201202173B (en)	2012-11-28	Combination
ZA201202495B (en)	2013-01-30	Combination
ZA201202258B (en)	2012-10-31	Combination
IL218801A0 (en)	2012-06-28	Combination
EP2510125A4 (en)	2014-03-05	Hyperprimers
AU4926P (en)	2014-09-22	Bonscalib Scaevola aemula
AU4924P (en)	2014-09-22	Bonscablue Scaevola aemula
AU4925P (en)	2014-09-22	Bonscawi Scaevola aemula
AU4240P (en)	2011-05-12	Tuckerbox xTriticosecale
EG26256A (en)	2013-06-03	Oxyga
GB0901391D0 (en)	2009-03-11	Combination
GB0906696D0 (en)	2009-06-03	Combination
AU329913S (en)	2010-03-12	Cupcan

Legal Events

Date	Code	Title	Description
2012-05-04	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
2012-06-06	17P	Request for examination filed	Effective date: 20120117
2012-06-06	AK	Designated contracting states	Kind code of ref document: A1 Designated state(s): 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 SE SI SK SM TR
2012-11-07	DAX	Request for extension of the european patent (deleted)
2014-04-30	A4	Supplementary search report drawn up and despatched	Effective date: 20140402
2014-04-30	RIC1	Information provided on ipc code assigned before grant	Ipc: G06F 17/30 20060101AFI20140327BHEP
2016-06-22	RAP1	Party data changed (applicant data changed or rights of an application transferred)	Owner name: HEWLETT PACKARD ENTERPRISE DEVELOPMENT L.P.
2018-05-25	STAA	Information on the status of an ep patent application or granted ep patent	Free format text: STATUS: EXAMINATION IS IN PROGRESS
2018-06-27	17Q	First examination report despatched	Effective date: 20180524
2018-12-04	GRAP	Despatch of communication of intention to grant a patent	Free format text: ORIGINAL CODE: EPIDOSNIGR1
2018-12-04	STAA	Information on the status of an ep patent application or granted ep patent	Free format text: STATUS: GRANT OF PATENT IS INTENDED
2019-01-02	INTG	Intention to grant announced	Effective date: 20181205
2019-03-29	GRAS	Grant fee paid	Free format text: ORIGINAL CODE: EPIDOSNIGR3
2019-04-05	GRAA	(expected) grant	Free format text: ORIGINAL CODE: 0009210
2019-04-05	STAA	Information on the status of an ep patent application or granted ep patent	Free format text: STATUS: THE PATENT HAS BEEN GRANTED
2019-05-08	AK	Designated contracting states	Kind code of ref document: B1 Designated state(s): 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 SE SI SK SM TR
2019-05-08	REG	Reference to a national code	Ref country code: GB Ref legal event code: FG4D
2019-05-15	REG	Reference to a national code	Ref country code: CH Ref legal event code: EP Ref country code: AT Ref legal event code: REF Ref document number: 1131297 Country of ref document: AT Kind code of ref document: T Effective date: 20190515
2019-05-23	REG	Reference to a national code	Ref country code: DE Ref legal event code: R096 Ref document number: 602009058307 Country of ref document: DE
2019-05-29	REG	Reference to a national code	Ref country code: IE Ref legal event code: FG4D
2019-06-19	REG	Reference to a national code	Ref country code: NL Ref legal event code: FP
2019-09-25	REG	Reference to a national code	Ref country code: LT Ref legal event code: MG4D
2019-10-31	PG25	Lapsed in a contracting state [announced via postgrant information from national office to epo]	Ref country code: FI Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508 Ref country code: LT Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508 Ref country code: HR Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508 Ref country code: SE Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508 Ref country code: NO Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190808 Ref country code: PT Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190908 Ref country code: ES Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508
2019-11-29	PG25	Lapsed in a contracting state [announced via postgrant information from national office to epo]	Ref country code: BG Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190808 Ref country code: LV Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508 Ref country code: GR Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190809
2019-12-15	REG	Reference to a national code	Ref country code: AT Ref legal event code: MK05 Ref document number: 1131297 Country of ref document: AT Kind code of ref document: T Effective date: 20190508
2020-01-31	PG25	Lapsed in a contracting state [announced via postgrant information from national office to epo]	Ref country code: RO Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508 Ref country code: SK Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508 Ref country code: EE Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508 Ref country code: DK Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508 Ref country code: AT Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508 Ref country code: CZ Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508
2020-02-11	REG	Reference to a national code	Ref country code: DE Ref legal event code: R097 Ref document number: 602009058307 Country of ref document: DE
2020-02-28	PG25	Lapsed in a contracting state [announced via postgrant information from national office to epo]	Ref country code: SM Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508 Ref country code: IT Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508
2020-03-13	PLBE	No opposition filed within time limit	Free format text: ORIGINAL CODE: 0009261
2020-03-13	STAA	Information on the status of an ep patent application or granted ep patent	Free format text: STATUS: NO OPPOSITION FILED WITHIN TIME LIMIT
2020-03-31	PG25	Lapsed in a contracting state [announced via postgrant information from national office to epo]	Ref country code: TR Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508
2020-04-15	26N	No opposition filed	Effective date: 20200211
2020-05-01	PG25	Lapsed in a contracting state [announced via postgrant information from national office to epo]	Ref country code: PL Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508
2020-05-29	PG25	Lapsed in a contracting state [announced via postgrant information from national office to epo]	Ref country code: SI Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508
2020-07-31	REG	Reference to a national code	Ref country code: CH Ref legal event code: PL
2020-08-27	REG	Reference to a national code	Ref country code: BE Ref legal event code: MM Effective date: 20191231
2020-08-31	PG25	Lapsed in a contracting state [announced via postgrant information from national office to epo]	Ref country code: MC Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508
2020-10-30	PG25	Lapsed in a contracting state [announced via postgrant information from national office to epo]	Ref country code: LU Free format text: LAPSE BECAUSE OF NON-PAYMENT OF DUE FEES Effective date: 20191214 Ref country code: IE Free format text: LAPSE BECAUSE OF NON-PAYMENT OF DUE FEES Effective date: 20191214
2020-11-30	PG25	Lapsed in a contracting state [announced via postgrant information from national office to epo]	Ref country code: BE Free format text: LAPSE BECAUSE OF NON-PAYMENT OF DUE FEES Effective date: 20191231 Ref country code: CH Free format text: LAPSE BECAUSE OF NON-PAYMENT OF DUE FEES Effective date: 20191231 Ref country code: LI Free format text: LAPSE BECAUSE OF NON-PAYMENT OF DUE FEES Effective date: 20191231
2020-12-31	PGFP	Annual fee paid to national office [announced via postgrant information from national office to epo]	Ref country code: NL Payment date: 20201125 Year of fee payment: 12
2021-01-29	PGFP	Annual fee paid to national office [announced via postgrant information from national office to epo]	Ref country code: GB Payment date: 20201123 Year of fee payment: 12 Ref country code: FR Payment date: 20201120 Year of fee payment: 12
2021-05-31	PG25	Lapsed in a contracting state [announced via postgrant information from national office to epo]	Ref country code: CY Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508
2021-06-30	PG25	Lapsed in a contracting state [announced via postgrant information from national office to epo]	Ref country code: IS Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190908
2021-07-30	PG25	Lapsed in a contracting state [announced via postgrant information from national office to epo]	Ref country code: HU Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT; INVALID AB INITIO Effective date: 20091214 Ref country code: MT Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508
2022-06-30	PG25	Lapsed in a contracting state [announced via postgrant information from national office to epo]	Ref country code: MK Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT Effective date: 20190508
2022-08-03	REG	Reference to a national code	Ref country code: NL Ref legal event code: MM Effective date: 20220101
2022-08-24	GBPC	Gb: european patent ceased through non-payment of renewal fee	Effective date: 20211214
2022-09-30	PG25	Lapsed in a contracting state [announced via postgrant information from national office to epo]	Ref country code: NL Free format text: LAPSE BECAUSE OF NON-PAYMENT OF DUE FEES Effective date: 20220101
2022-10-31	PG25	Lapsed in a contracting state [announced via postgrant information from national office to epo]	Ref country code: GB Free format text: LAPSE BECAUSE OF NON-PAYMENT OF DUE FEES Effective date: 20211214
2022-10-31	PGFP	Annual fee paid to national office [announced via postgrant information from national office to epo]	Ref country code: DE Payment date: 20220630 Year of fee payment: 13
2022-11-30	PG25	Lapsed in a contracting state [announced via postgrant information from national office to epo]	Ref country code: FR Free format text: LAPSE BECAUSE OF NON-PAYMENT OF DUE FEES Effective date: 20211231
2023-07-01	REG	Reference to a national code	Ref country code: DE Ref legal event code: R119 Ref document number: 602009058307 Country of ref document: DE
2023-10-31	PG25	Lapsed in a contracting state [announced via postgrant information from national office to epo]	Ref country code: DE Free format text: LAPSE BECAUSE OF NON-PAYMENT OF DUE FEES Effective date: 20230701