Unavailability of PATSTAT Online May 26th - June 8th 2015

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

mkracker
Posts: 114
Joined: Wed Sep 04, 2013 6:17 am
Location: Vienna

Unavailability of PATSTAT Online May 26th - June 8th 2015

Post by mkracker » Mon May 18, 2015 3:49 pm

Due to a larger maintenance and re-installation effort, PATSTAT Online will not be available from May 26th - June 8th 2015. Among others, the database management system which is currently MySQL will be replaced by MS SQL Server. Because their SQL dialects differ slightly, you may have to adapt your existing queries. Slides 14 - 21 from the PATSTAT SQL self-study course (downloadable from (http://www.epo.org/searching/subscripti ... nline.html) might help you to do that.

Thereafter, the data of the 2015 Autumn Edition will be available as usual. Also, it will still be possible to register for a free 2-month trial on the EPO home page (http://www.epo.org/searching/subscripti ... nline.html).

I apologize for any inconvenience.
-------------------------------------------
Martin Kracker / EPO


nico.rasters
Posts: 140
Joined: Wed Jul 08, 2009 5:51 pm
Contact:

Re: Unavailability of PATSTAT Online May 26th - June 8th 201

Post by nico.rasters » Fri May 22, 2015 2:46 pm

Just curious. Why the switch from MySQL to MS SQL Server? What are the advantages of MS SQL Server, or what was the problem with MySQL?
________________________________________
Nico Doranov
Data Manager

Daigu Academic Services & Data Stewardship
http://www.daigu.nl/


mkracker
Posts: 114
Joined: Wed Sep 04, 2013 6:17 am
Location: Vienna

Re: Unavailability of PATSTAT Online May 26th - June 8th 201

Post by mkracker » Fri May 29, 2015 3:14 pm

We switched to MS SQL Server for a couple of technical reasons:
  • • It is in line with our IT strategy.
  • • The data preparation process for PATSTAT raw data is also based on MS SQL Server.
  • • PATSTAT Online is an application on top of the DBMS. In this architecture, the JDBC driver is of crucial importance. In this respect, the JDBC driver of MS SQL is more powerful, which saves a lot of ugly code we needed for various work arounds.
  • • The query optimizer seems to be more efficient. PATSTAT Online has to serve all kind of queries and users with varying experience. We cannot optimize it for certain types of queries, so we let the query optimizer take care of this.
  • • In our environment tests have shown that we may gain a 3-fold performance increase on average.
By no means I want to indicate that MySQL is not sufficient to run PATSTAT data. According to a survey we did last year, more than 1/3 of the users are using MySQL, about ¼ MS SQL Server, both followed by STATA, Oracle, PostgreSQL and several others.
-------------------------------
Martin Kracker / EPO PATSTAT
-------------------------------------------
Martin Kracker / EPO


liuxia0510
Posts: 4
Joined: Sun May 31, 2015 7:13 pm

Re: Unavailability of PATSTAT Online May 26th - June 8th 201

Post by liuxia0510 » Tue Jun 09, 2015 10:37 am

it is June 9th already, still not available, some other problems? thanks


mkracker
Posts: 114
Joined: Wed Sep 04, 2013 6:17 am
Location: Vienna

Re: Unavailability of PATSTAT Online May 26th - June 8th 201

Post by mkracker » Wed Jun 10, 2015 7:27 am

Yes, there was a slight delay. Since noon yesterday, PATSTAT Online is up and running again.

Martin Kracker / EPO PATSTAT
-------------------------------------------
Martin Kracker / EPO


Post Reply