blank Quick help
blank Maintenance news

Scheduled maintenance

Regular maintenance outages:
between 05.00 and 05.15 hrs CET (Monday to Sunday).

Other outages
Availability

2022.02.11

More...
blank News flashes

Italy joins the Federated Register

Click here for more information on the Federated Register.

2025-06-12

More...
blank Related links

Release notes
European Patent Register Assistant
European Patent Register User Manual
European Patent Register – pocket guide
FAQ - European Patent Register
Federated Register (Flyer)
Global Dossier (Flyer)
Register events
Deep link coverage
Federated Register content
The Patent Information Tour
Fair use charter

Extract from the Register of European Patents

EP About this file: EP1193618

EP1193618 - Cost based materialized view selection for query optimization [Right-click to bookmark this link]
StatusNo opposition filed within time limit
Status updated on  02.11.2018
Database last updated on 11.04.2026
FormerThe patent has been granted
Status updated on  24.11.2017
FormerGrant of patent is intended
Status updated on  18.07.2017
Most recent event   Tooltip05.06.2020Lapse of the patent in a contracting state
New state(s): PT		published on 08.07.2020  [2020/28]
Applicant(s)For all designated states
Microsoft Technology Licensing, LLC
One Microsoft Way
Redmond, WA 98052 / US
[2015/12]
Former [2002/14]For all designated states
MICROSOFT CORPORATION
One Microsoft Way
Redmond, WA 98053 / US
Inventor(s)01 / Galindo-Legaria, Cesar
16141 NE 44th Ct.
Redmond, WA 98052 / US
02 / Joshi, Milind M.
4763 148th Avenue
NE, Apt. P202
Bellevue, WA 98007 / US
 [2017/52]
Former [2002/14]01 / Galindo-Legaria, Cesar
16141 NE 44th Ct.
Redmond, WA 98052 / US
02 / Joshi, Milind M.
4763 148th Avenue, NE, Apt. P202
Bellevue, WA 98007 / US
Representative(s)Grünecker Patent- und Rechtsanwälte PartG mbB
Leopoldstraße 4
80802 München / DE
[2017/52]
Former [2002/14]Grünecker, Kinkeldey, Stockmair & Schwanhäusser Anwaltssozietät
Maximilianstrasse 58
80538 München / DE
Application number, filing date01123065.326.09.2001
[2002/14]
Priority number, dateUS2000067145827.09.2000         Original published format: US 671458
[2002/14]
Filing languageEN
Procedural languageEN
PublicationType: A2 Application without search report 
No.:EP1193618
Date:03.04.2002
Language:EN
[2002/14]
Type: A3 Search report 
No.:EP1193618
Date:16.11.2005
[2005/46]
Type: B1 Patent specification 
No.:EP1193618
Date:27.12.2017
Language:EN
[2017/52]
Search report(s)(Supplementary) European search report - dispatched on:EP29.09.2005
ClassificationIPC:G06F17/30
[2002/14]
CPC:
G06F16/24539 (EP,US); G06F16/24542 (EP,US); G06F16/2458 (EP);
Y10S707/99932 (US); Y10S707/99943 (US)
Designated contracting statesAT,   BE,   CH,   CY,   DE,   DK,   ES,   FI,   FR,   GB,   GR,   IE,   IT,   LI,   LU,   MC,   NL,   PT,   SE,   TR [2017/52]
Former [2002/14]AT,  BE,  CH,  CY,  DE,  DK,  ES,  FI,  FR,  GB,  GR,  IE,  IT,  LI,  LU,  MC,  NL,  PT,  SE,  TR 
TitleGerman:Kostenbasierte Auswahl von materialisierten Ansichten zur Optimierung von Anfragen[2002/14]
English:Cost based materialized view selection for query optimization[2002/14]
French:Sélection de vues matérialisées pour l'optimisation d'interrogation basée sur le coût[2002/14]
Examination procedure04.05.2006Examination requested  [2006/24]
28.08.2006Despatch of a communication from the examining division (Time limit: M06)
07.03.2007Reply to a communication from the examining division
19.02.2008Despatch of a communication from the examining division (Time limit: M06)
28.08.2008Reply to a communication from the examining division
16.03.2011Date of oral proceedings
20.04.2011Despatch of communication that the application is refused, reason: substantive examination {1}
20.04.2011Minutes of oral proceedings despatched
19.07.2017Communication of intention to grant the patent
09.11.2017Fee for grant paid
09.11.2017Fee for publishing/printing paid
09.11.2017Receipt of the translation of the claim(s)
Appeal following examination30.06.2011Appeal received No.  T1965/11
29.08.2011Statement of grounds filed
24.03.2017Result of appeal procedure: remittal for grant
24.03.2017Date of oral proceedings
30.03.2017Minutes of oral proceedings despatched
Divisional application(s)The date of the Examining Division's first communication in respect of the earliest application for which a communication has been issued is  28.08.2006
Opposition(s)28.09.2018No opposition filed within time limit [2018/49]
Fees paidRenewal fee
12.09.2003Renewal fee patent year 03
14.09.2004Renewal fee patent year 04
14.09.2005Renewal fee patent year 05
11.09.2006Renewal fee patent year 06
12.09.2007Renewal fee patent year 07
31.03.2008Renewal fee patent year 08
11.09.2009Renewal fee patent year 09
14.09.2010Renewal fee patent year 10
29.09.2011Renewal fee patent year 11
26.09.2012Renewal fee patent year 12
09.09.2013Renewal fee patent year 13
08.09.2014Renewal fee patent year 14
11.09.2015Renewal fee patent year 15
13.09.2016Renewal fee patent year 16
11.09.2017Renewal fee patent year 17
Opt-out from the exclusive  Tooltip
competence of the Unified
Patent Court		 See the Register of the Unified Patent Court for opt-out data
Responsibility for the accuracy, completeness or quality of the data displayed under the link provided lies entirely with the Unified Patent Court.
Lapses during opposition  TooltipAT27.12.2017
CY27.12.2017
DK27.12.2017
ES27.12.2017
FI27.12.2017
IT27.12.2017
MC27.12.2017
PT27.12.2017
SE27.12.2017
TR27.12.2017
GR28.03.2018
IE26.09.2018
LU26.09.2018
[2020/28]
Former [2020/16]AT27.12.2017
CY27.12.2017
DK27.12.2017
ES27.12.2017
FI27.12.2017
IT27.12.2017
MC27.12.2017
SE27.12.2017
TR27.12.2017
GR28.03.2018
IE26.09.2018
LU26.09.2018
Former [2019/33]AT27.12.2017
CY27.12.2017
DK27.12.2017
ES27.12.2017
FI27.12.2017
IT27.12.2017
MC27.12.2017
SE27.12.2017
GR28.03.2018
IE26.09.2018
LU26.09.2018
Former [2019/30]AT27.12.2017
CY27.12.2017
DK27.12.2017
ES27.12.2017
FI27.12.2017
IT27.12.2017
MC27.12.2017
SE27.12.2017
GR28.03.2018
LU26.09.2018
Former [2019/24]AT27.12.2017
CY27.12.2017
DK27.12.2017
ES27.12.2017
FI27.12.2017
IT27.12.2017
MC27.12.2017
SE27.12.2017
GR28.03.2018
Former [2018/51]AT27.12.2017
CY27.12.2017
DK27.12.2017
ES27.12.2017
FI27.12.2017
IT27.12.2017
SE27.12.2017
GR28.03.2018
Former [2018/39]AT27.12.2017
CY27.12.2017
ES27.12.2017
FI27.12.2017
IT27.12.2017
SE27.12.2017
GR28.03.2018
Former [2018/37]CY27.12.2017
ES27.12.2017
FI27.12.2017
SE27.12.2017
GR28.03.2018
Former [2018/24]FI27.12.2017
SE27.12.2017
GR28.03.2018
Former [2018/22]FI27.12.2017
Documents cited:Search[X] WO9950762  (INFORMIX SOFTWARE INC et al.) [X] 1-41 * the whole document *
 [X] US6026390  (ROSS KENNETH A et al.) [X] 1-41 * the whole document *
 [X] US5897632  (DAR SHAUL et al.) [X] 1-41 * the whole document *
 [X] WO9950732  (RED BRICK SYSTEMS INC et al.) [X] 1,9,17,26-28,39-41 * abstract * * page 7, line 5 - page 8, line 3 * * page 14, line 17 - page 19, line 22 *
 [X]   GUPTA A ET AL: "Aggregate-query processing in data warehousing environments", VLDB '95. PROCEEDINGS OF THE 21ST INTERNATIONAL CONFERENCE ON VERY LARGE DATA BASES MORGAN KAUFMANN SAN FRANCISCO, CA, USA, 1995, pages 358 - 369, XP002344674 [X] 1-41 * the whole document *
 [A]   JAE-YOUNG CHANG ET AL: "An extended query reformulation technique using materialized views", DATABASE AND EXPERT SYSTEMS APPLICATIONS, 1998. PROCEEDINGS. NINTH INTERNATIONAL WORKSHOP ON VIENNA, AUSTRIA 26-28 AUG. 1998, LOS ALAMITOS, CA, USA,IEEE COMPUT. SOC, US, 26 August 1998 (1998-08-26), pages 931 - 936, XP010296640, ISBN: 0-8186-8353-8 [A] 1-41 * the whole document *

DOI:   http://dx.doi.org/10.1109/DEXA.1998.707517
 [A]   CHUAN ZHANG ET AL: "Evolving Materialized Views in Data Warehouse", PROC. OF IEEE CONGRESS ON EVOLUTIONARY COMPUTATION (CEC'99),WASHINGTON D.C., USA, vol. 2, 6 July 1999 (1999-07-06), pages 823 - 829, XP010344489 [A] 1-41 * the whole document *
The EPO accepts no responsibility for the accuracy of data originating from other authorities; in particular, it does not guarantee that it is complete, up to date or fit for specific purposes.