JP2011133925A - Data processing apparatus and method - Google Patents

Data processing apparatus and method Download PDF

Info

Publication number
JP2011133925A
JP2011133925A JP2009289970A JP2009289970A JP2011133925A JP 2011133925 A JP2011133925 A JP 2011133925A JP 2009289970 A JP2009289970 A JP 2009289970A JP 2009289970 A JP2009289970 A JP 2009289970A JP 2011133925 A JP2011133925 A JP 2011133925A
Authority
JP
Japan
Prior art keywords
processing
data
task
query description
query
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.)
Granted
Application number
JP2009289970A
Other languages
Japanese (ja)
Other versions
JP5351746B2 (en
Inventor
Tetsuhiro Kyo
Itsuhou Sho
哲浩 姜
イツホウ 蒋
Original Assignee
Yahoo Japan Corp
ヤフー株式会社
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 Yahoo Japan Corp, ヤフー株式会社 filed Critical Yahoo Japan Corp
Priority to JP2009289970A priority Critical patent/JP5351746B2/en
Publication of JP2011133925A publication Critical patent/JP2011133925A/en
Application granted granted Critical
Publication of JP5351746B2 publication Critical patent/JP5351746B2/en
Application status is Active legal-status Critical
Anticipated expiration legal-status Critical

Links

Images

Abstract

<P>PROBLEM TO BE SOLVED: To provide a technology for a database, allowing combined use of processing systems without being conscious on a use-side, of difference in a specification between the processing systems different from each other. <P>SOLUTION: The data processing apparatus includes: a task reception means 10 receiving a task from the individual systems U1, U2 that are user side devices; a decision means 20 deciding query description corresponding to identification information and the kind of the processing system for executing the query description by referring to a correspondence storage means 25 based on the identification information included in the received task; and management means (30, 40) each making the decided kind of processing system execute the decided query description, and each managing a job of the execution. <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  The present invention relates to a technique for using a plurality of types of data processing systems in combination.

  Conventionally, various database systems (hereinafter also referred to as “databases”) have been used as information processing techniques specialized for large volume data processing. A database in a broad sense is composed of a narrow sense database (hereinafter referred to as “DB”) that is a data set that systematically stores data and a DBMS (database management system) that processes data in the DB. Is done.

  In such a broad database, the processing to be performed, that is, specifications such as an instruction set and a format for describing a query are different from each other depending on the type of system. For example, in a representative example of a widely used relational database, query description is performed in SQL.

  By the way, with regard to the environment in which various queries are generated from various departments and systems in the organization, such as data related to ordering and display of web advertisements on large-scale websites, the applicant has to We planned to improve the efficiency of data processing by combining multiple processing systems that differ from each other and using them from the user side such as individual systems.

JP-A-8-235112

  When different processing systems are used together as described above, each task must be used when designing tools or user interfaces on the user side of individual systems that use these systems, or when using them directly from the terminal. It may be possible to write a query in consideration of the difference in specifications between processing systems after determining which processing system to use, but such a response is problematic in that it is burdensome and impractical. It was.

  Although there is a proposal for distributing the same type of load between the same types of processing systems (see, for example, Patent Document 1), the database is not related to the combination of different types of processing systems.

  The present invention solves the problems of the prior art as described above, and its purpose is a database that allows the use of each system without being aware of the difference in specifications between different processing systems on the user side. Is to provide technology.

  Based on the above object, one aspect (1) of the present invention is a data processing apparatus that processes data stored in a database, and includes a plurality of types of processing systems that process the data. A query storage means for storing a query description to be executed by the processing system, and which query description is to be executed for the task identification information transmitted from the user side device and the process corresponding to the query description By referring to the correspondence storage unit based on the identification information included in the received task, the correspondence storage unit that stores the type of the system in association with each other, the task reception unit that receives the task from the user side device, A query description corresponding to the identification information, and a determination means for determining the type of the processing system that executes the query description; Was judged the query description, together to execute the processing system is determined the type, characterized in that it has a management unit configured to manage job execution, the.

  The above aspect (4) is a data processing apparatus that processes data stored in a database and that is realized by a computer, and is a processing system that processes the data. Multiple types of processing systems, query storage means for storing query descriptions executed by the processing systems, and which query descriptions should be executed for the task identification information transmitted from the user side device and the queries In a data processing method executed by a data processing device, the task receiving step of receiving a task from a user side device, in a data processing method executed by a data processing device having correspondence storage means that stores the type of the processing system corresponding to the description in association with each other, Based on the identification information included in the received task, the computer stores the correspondence storage device. By referring to the query description corresponding to the identification information, the determination step of determining the type of the processing system that executes the query description, and the computer determines the determined query description of the determined type A management step of causing the processing system to execute and managing a job of the execution.

  In the present invention, as described above, the query description module corresponding to the identification information included in the data processing task from the user side is executed by the processing system corresponding to the module, and depending on the processing characteristics of the query description such as real time or batch. Job management is also provided. This makes it possible to realize a platform that hides differences in specifications such as the data format between different systems from the user side. Therefore, when designing tools and user interfaces on the user side, identification information according to user operations is incorporated. By simply sending tasks to the platform, heterogeneous systems can be used together without being aware of the differences in their specifications. As a result, it is possible to construct a rational data processing mechanism that utilizes a combination of characteristics for each system.

  According to another aspect (2) of the present invention, in any of the above aspects, the plurality of processing systems are a relational database system and a large-scale distributed database system realized by a large-scale distributed calculation framework. It is characterized by.

  In this way, as a multiple processing system, a relational database excellent in multi-function and high speed and suitable for real-time data processing, and a large-scale distributed database particularly suitable for distributed processing of large-capacity data such as large-scale log analysis, By combining processing systems having different characteristics complementary to each other, it becomes possible to realize a data processing platform capable of satisfying a wider variety of data processing demands.

  According to another aspect (3) of the present invention, in any one of the aspects described above, conversion to a database of each format corresponding to each of the plurality of processing systems and reflection of an update difference are performed using an external predetermined database as an original. It has a synchronization means (process) to perform.

  In this way, even if the database to be processed is in any data format, or even if you do not want to further increase the access load by this device due to the operational load of other business such as log accumulation, such a database is used as the original By converting and synchronizing to individual data formats corresponding to each processing system of this device, it is possible to conceal (wrap) differences in specifications such as the data format according to the type of processing system from the user side. In addition, conflicts with the operational load of other businesses can be avoided, and processing efficiency will not be reduced by format conversion during data processing.

  Note that categories different from the above-described aspects (programs for methods, methods for apparatuses, and the like) and more specific aspects described below are also included in the present invention.

  According to the present invention, it is possible to provide a database technology that enables the use of each system without being aware of the difference in specifications between different processing systems.

The functional block diagram which shows the structure of embodiment of this invention. The figure which illustrates each information (data) in the embodiment of the present invention. The flowchart which shows the process sequence in embodiment of this invention. The figure which shows an example of the screen display in embodiment of this invention. The figure which shows an example of the screen display in embodiment of this invention. The figure which shows an example of the screen display in embodiment of this invention.

  Next, modes for carrying out the present invention (referred to as “embodiments”) will be described with reference to the drawings. It should be noted that assumptions common to those already described in the background art and problems are omitted as appropriate.

[1. Constitution〕
The present embodiment relates to a data processing apparatus (hereinafter also referred to as “this apparatus”) that processes data stored in a database, and includes a plurality of types of processing systems that process the data. . In this embodiment, the plurality of types of processing systems are large-scale distributed database systems realized by a relational database system such as Oracle (registered trademark) and a large-scale distributed computing framework such as Hadoop.

  More specifically, a database system generally includes processing means implemented mainly by software and a data set to be processed. As shown in the configuration diagram of FIG. As a processing system of the relational database system, there is a real-time processing means R represented by RDBMS or the like (also referred to as a processing system R). This real-time processing means R is a data set D1 in a format corresponding to the relational database system. A relational database system is realized with it. Further, the apparatus 1 has a distributed DB processing means H (such as hBASE) represented by HIVE or the like as a processing means of the large-scale distributed database system, and this distributed DB processing means H (processing System H) implements the large-scale distributed database system together with a data set D2 in a format corresponding to the large-scale distributed database system.

  The apparatus 1 includes, as a general computer configuration, at least an arithmetic control unit 5 such as a CPU, an external storage device (HDD or the like), a storage device 6 such as a main memory, and a communication network (not shown). Communication means 7 (such as a LAN adapter). The apparatus 1 is a platform that provides data processing functions on the server side to the individual systems U1 and U2 on the user side (lower left side in FIG. 1). Furthermore, these individual systems U1 and U2 provide a web for inputting data processing requests and displaying results to a user terminal T (also simply referred to as “terminal T”) such as a personal computer (PC) or a mobile phone terminal device. It has a role of providing an interface such as a page on the server side, and is also referred to as a “user side device”.

  Further, in the present apparatus 1, a predetermined computer program (not shown) stored (installed) in advance in the storage device 6 controls the arithmetic control unit 5 so that elements (20, 30, etc.) shown in FIG. Is realized.

  Among these elements, the information storage means can be realized in any format such as various files, variables such as arrays, system setting values, etc. in the storage device 6. Among these storage means, the query storage means 50 is a means for storing the query descriptions a1, a2,... Executed by the processing system R and the query descriptions b1, b2... Executed by the processing system H (FIG. 1). .

  In addition, as illustrated in FIG. 2, the correspondence storage unit 25 determines which query description should be executed on the task identification information transmitted from the user side device (individual system U1, U2) and the query description. This is means for storing the corresponding processing system R or H type in association with each other. Note that each means other than the storage means is a processing means that implements and executes the functions and operations of information processing described below.

[2. Action)
The processing procedure in the present embodiment configured as described above is shown in the flowchart of FIG. That is, first, the synchronization means DX (FIG. 1) at the beginning of the operation of the present apparatus uses the predetermined external database S (for example, advertising plans, products, projects, results, etc.) as the original data as the original data. As a database of each format corresponding to each of the above, a copy obtained by converting the whole is generated (step S01). After the operation is started, the database of each format is stored at a predetermined timing such as at night (step S02: “ YES ”) Update difference is reflected (step S03).

  More specifically, the synchronization means DX is based on the original database S, a data set D1 in a format corresponding to the relational database system (FIG. 1), and a data set D2 in a format corresponding to the large-scale distributed database system. Are generated (step S01) and are subject to update difference reflection (step S03).

  Then, the task receiving means 10 receives a task from the user side device by means such as an API (step S04). Examples of the user-side device are the individual systems U1 and U2 (FIG. 1) as described above. These individual systems U1 and U2 can perform data extraction and the like on the terminal T through a user interface such as a web page. Receive tasks and provide processing results.

  For example, FIG. 4 shows a condition designation screen as an example of a web page in which a user side device receives a task from the terminal T. In the example of this screen, the user selects “standard output” or “individual output” by selecting the radio button B1 with the mouse cursor C. In the “standard output”, predetermined initial values are selected for the extraction conditions and output items for data extraction, and after the selection, the “execute” button B2 may be operated as it is.

  In the case of “individual output”, the extraction condition is designated in the first column P1 and the output item is designated in the second column P2 by a text box or a check box for each individual task, and the “execute” button B2 is operated. . When the “execute” button B2 is operated, the condition confirmation screen illustrated in FIG. 5 is displayed, and the reception confirmation screen illustrated in FIG. 6 is displayed. The individual systems U1 and U2 indicate the tasks received in this manner as APIs or the like. Is transmitted to the data processing apparatus (this apparatus) 1.

The API in this case combines task identification information, parameters such as extraction conditions and output items, etc. with the necessary domain name, function name to be called, etc.

http: //○○○.co.jp/api/○○addata? queryid = ○○ & arg1 = ・ ・ ・

A character string of an HTTP request is conceivable as shown in FIG.

  When the task is received in this way (step S04), the determination unit 20 refers to the correspondence storage unit 25 based on the identification information included in the received task, so that the query description stored in the query storage unit 50 is stored. Among them, the query description corresponding to the identification information and the type of the processing system that executes the query description are determined (step S05), and according to the determined type (step S06), the batch job management unit 30 as the management unit is determined. Alternatively, the real-time job management unit 40 causes the processing system R or H of the determined type to execute the determined query description, and manages the execution job (steps S07 and S08).

  More specifically, for example, when the task identification information is “0011”, based on the information stored in the correspondence storage unit 25 (FIG. 2), the determination unit 20 uses the query description “a1”. It is determined that the type of the processing system that executes the query description a1 is “1” meaning the real-time processing means R (steps S05 and S06). In this case, in response to this determination, the real-time job management unit 40 causes the real-time processing unit R, which is the processing system of the determined type, to execute the determined query description a1 and generate a necessary monitoring process. The execution job is managed (step S07).

  On the other hand, when the task identification information is “0012”, for example, based on the information stored in the correspondence storage unit 25 (FIG. 2), the determination unit 20 executes the query description b2 with the query description “b2”. The type of the processing system to be determined is “2” meaning the distributed DB processing means H (steps S05 and S06). In this case, in response to this determination, the batch job management unit 30 causes the distributed DB processing unit H, which is the processing system of the determined type, to execute the determined query description b2, as well as for system configuration and the like. Accordingly, the execution job is managed (step S08).

A SQL (Structured Query Language) used for query description of a relational database is well known and will not be described. Then, HQL (HIVE Query Language) similar to SQL is used. As its description

SELECT m.service_name, m.operator
FROM data1 m JOIN data2 y ON (m.xxid = y.xxid);

Examples can be given.

  The result of the data processing as described above is provided to the terminal T that has issued the task by the result providing means 80 directly from the apparatus 1 or through the individual systems U1 and U2, but the manner of providing the data processing is arbitrary. For example, in the case of real-time processing using a relational database or the like, it is conceivable that a transition is made from a screen for accepting or confirming tasks as shown in FIGS. 4 and 5 to a screen displaying results on the spot.

  In the case of batch processing using a large-scale distributed database or the like, the resulting file is stored in the predetermined directory in the LAN as shown in the example of FIG. It is conceivable that the mode is acquired by the user, or that the processing result can be browsed when the user logs in to the individual system U1 or U2 with a user ID or the like after a predetermined waiting time. If the external interface means 70 is provided for each processing system to exchange data with an appropriate external system, a wider variety of data utilization is possible.

[3. effect〕
As described above, in the present embodiment, the query description module corresponding to the identification information included in the data processing task from the user side is executed by the corresponding processing system, and the processing characteristics of the query description such as real time or batch are set. Responding job management is also provided. This makes it possible to realize a platform that hides differences in specifications such as the data format between different systems from the user side. Therefore, when designing tools and user interfaces on the user side, identification information according to user operations is incorporated. By simply sending tasks to the platform, heterogeneous systems can be used together without being aware of the differences in their specifications. As a result, it is possible to construct a rational data processing mechanism that utilizes a combination of characteristics for each system.

  In particular, in this embodiment, as a plurality of processing systems, a relational database that is excellent in multi-function and high speed and suitable for real-time data processing, and a large scale that is particularly suitable for distributed processing of large-capacity data such as large-scale log analysis. By combining processing systems having different characteristics complementary to each other such as a distributed database, it becomes possible to realize a data processing platform capable of satisfying more diverse data processing demands.

  Further, in the present embodiment, even if the database to be processed is in any data format, and even if it is not desired to further increase the access load due to the operation load of other business such as log accumulation, such a database. The original data is converted into individual data formats corresponding to each processing system of this equipment and processed in synchronization, thereby concealing differences in specifications such as the data format according to the type of processing system from the user side (wrapping) In addition, it is possible to avoid conflicts with the operational load of other businesses, and there is no decrease in processing efficiency due to format conversion during data processing.

[4. Other embodiments]
In addition, said each embodiment is only an illustration, and this invention includes what is illustrated below and other embodiment other than that. For example, the elements such as each unit described in the above embodiment may be realized by other information processing mechanisms such as an electronic circuit based on a wired logic or the like without being limited to a computer control unit. In addition, each configuration diagram, data diagram, flowchart diagram, description of the order of processing and operations, etc. are merely examples, and the presence / absence and order of each element, the execution order of each processing step, and specific contents can be changed as appropriate. It is.

For example, the data processing system is not limited to a database system, and may be any type of electronic information processing organization that processes data. The means for accepting a task from the user side is not limited to the API,

ClientProxy proxy = new ClientProxy ();
String [] args = {"apiname", "arg1 = xxx",
"arg2 = yyy zzz", "arg3 = abcd"};
ClientResponse res = proxy.call (args);

A TCP request or the like may be used.

  The apparatus of the present invention (the apparatus 1) may be realized by a plurality of server computers. Depending on the function, an external platform or the like may be called by an API (Application Program Interface) or network computing. The configuration can be changed flexibly. The present invention can also be understood as the entire system including the terminal T, an information processing method or a computer program corresponding to the entire system.

1 Data processing device (this device)
5 Arithmetic Control Unit 6 Storage Device 7 Communication Unit 10 Task Acceptance Unit 20 Determination Unit 25 Corresponding Storage Unit 30 Batch Job Management Unit 40 Real-Time Job Management Unit 50 Query Storage Units a1, a2, b1, b2 Query Description B1 Radio Button B2 “Execute ”Button C mouse cursor D1, D2 data set DX synchronization means H distributed DB processing means P1 first column P2 second column R real-time processing means T user terminal (terminal)
U1, U2 Individual system

Claims (4)

  1. In a data processing apparatus for processing data stored in a database,
    A processing system for processing the data, comprising a plurality of different processing systems,
    Query storage means for storing a query description executed by the processing system;
    Corresponding storage means that stores which query description to be executed and the type of the processing system corresponding to the query description in association with the task identification information transmitted from the user side device;
    Task accepting means for accepting a task from the user side device;
    A query description corresponding to the identification information by referring to the correspondence storage means based on the identification information included in the received task, and a determination means for determining the type of the processing system that executes the query description;
    Management means for causing the processing system of the determined type to execute the determined query description and managing a job of the execution;
    A data processing apparatus comprising:
  2. The plurality of processing systems include:
    Relational databases,
    A large-scale distributed database system realized by a large-scale distributed computing framework;
    The data processing apparatus according to claim 1, wherein:
  3.   3. The data according to claim 1, further comprising: a synchronization unit that converts an external predetermined database into a database of each format corresponding to each of the plurality of processing systems and reflects an update difference. Processing equipment.
  4. A data processing device that is realized by a computer and processes data stored in a database,
    A plurality of processing systems for processing the data and different from each other;
    Query storage means for storing a query description executed by the processing system;
    Corresponding storage means that stores which query description to be executed and the type of the processing system corresponding to the query description in association with the task identification information transmitted from the user side device;
    In a data processing method executed by a data processing apparatus having
    A task receiving step in which the computer receives a task from the user side device;
    A step in which the computer refers to the correspondence storage means based on the identification information included in the received task, thereby determining a query description corresponding to the identification information and a type of a processing system that executes the query description; ,
    A management step for causing the processing system of the determined type to execute the determined query description and managing a job of the execution;
    A data processing method comprising:
JP2009289970A 2009-12-22 2009-12-22 Data processing apparatus and method Active JP5351746B2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
JP2009289970A JP5351746B2 (en) 2009-12-22 2009-12-22 Data processing apparatus and method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
JP2009289970A JP5351746B2 (en) 2009-12-22 2009-12-22 Data processing apparatus and method

Publications (2)

Publication Number Publication Date
JP2011133925A true JP2011133925A (en) 2011-07-07
JP5351746B2 JP5351746B2 (en) 2013-11-27

Family

ID=44346633

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2009289970A Active JP5351746B2 (en) 2009-12-22 2009-12-22 Data processing apparatus and method

Country Status (1)

Country Link
JP (1) JP5351746B2 (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2015094179A1 (en) * 2013-12-17 2015-06-25 Hewlett-Packard Development Company, L.P. Abstraction layer between a database query engine and a distributed file system
KR101542299B1 (en) 2013-02-18 2015-08-07 단국대학교 산학협력단 Method for processing query based on hadoop

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH1049410A (en) * 1996-08-07 1998-02-20 Matsushita Electric Ind Co Ltd Different type data base accessing device
JPH11250092A (en) * 1998-03-04 1999-09-17 Ntt Communication Ware Kk Shared database, shared databse system, method for extracting data from shared database and medium recording data extraction program from shared databse
JP2000222430A (en) * 1999-02-03 2000-08-11 Osaka Gas Co Ltd Virtual database management system
JP2007095059A (en) * 2005-09-29 2007-04-12 Nhn Corp Method and system for transmitting query to database

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH1049410A (en) * 1996-08-07 1998-02-20 Matsushita Electric Ind Co Ltd Different type data base accessing device
JPH11250092A (en) * 1998-03-04 1999-09-17 Ntt Communication Ware Kk Shared database, shared databse system, method for extracting data from shared database and medium recording data extraction program from shared databse
JP2000222430A (en) * 1999-02-03 2000-08-11 Osaka Gas Co Ltd Virtual database management system
JP2007095059A (en) * 2005-09-29 2007-04-12 Nhn Corp Method and system for transmitting query to database

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR101542299B1 (en) 2013-02-18 2015-08-07 단국대학교 산학협력단 Method for processing query based on hadoop
WO2015094179A1 (en) * 2013-12-17 2015-06-25 Hewlett-Packard Development Company, L.P. Abstraction layer between a database query engine and a distributed file system

Also Published As

Publication number Publication date
JP5351746B2 (en) 2013-11-27

Similar Documents

Publication Publication Date Title
JP4405812B2 (en) Method and apparatus for synchronizing between a first data storage unit and a second data storage unit
US7565381B2 (en) Smart synchronization using created manifest
US7240327B2 (en) Cross-platform development for devices with heterogeneous capabilities
EP3096250B1 (en) System and method for distributed database query engines
US6332130B1 (en) System and process for inter-domain planning analysis and optimization using model agents as partial replicas of remote domains
US8023934B2 (en) Synchronizing communications and data between mobile devices and servers
US6222533B1 (en) System and process having a universal adapter framework and providing a global user interface and global messaging bus
US8396881B2 (en) Method and system for automatically generating web page transcoding instructions
US9262763B2 (en) Providing attachment-based data input and output
JP2005516272A (en) Computing system and method for implicitly committing non-saved data for world wide web applications
EP2174434B1 (en) Unwired enterprise platform
US20140351233A1 (en) System and method for continuous analytics run against a combination of static and real-time data
US20050055698A1 (en) Server-driven data synchronization method and system
US7814404B2 (en) System and method for applying workflow of generic services to component based applications for devices
US7509649B2 (en) System and method for conversion of generic services&#39; applications into component based applications for devices
US8914807B2 (en) Method, system, and program for generating a program capable of invoking a flow of operations
US8577960B2 (en) Providing status information for components in a distributed landscape
JP5200721B2 (en) Control method, control device, and program
JP2005259138A (en) Integration architecture for non-integrated tools
US20180082254A1 (en) Techniques to manage remote events
US20080263007A1 (en) Managing archived data
US20110231592A1 (en) Mashup Infrastructure with Learning Mechanism
TWI317503B (en) System and method for remote installation of application programs in mobile derices
WO2007047900A2 (en) System and method for displaying data on a thin client
US9081837B2 (en) Scoped database connections

Legal Events

Date Code Title Description
A977 Report on retrieval

Free format text: JAPANESE INTERMEDIATE CODE: A971007

Effective date: 20120913

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20121002

RD02 Notification of acceptance of power of attorney

Free format text: JAPANESE INTERMEDIATE CODE: A7422

Effective date: 20121106

A521 Written amendment

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20121127

A02 Decision of refusal

Free format text: JAPANESE INTERMEDIATE CODE: A02

Effective date: 20130319

A521 Written amendment

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20130619

A911 Transfer of reconsideration by examiner before appeal (zenchi)

Free format text: JAPANESE INTERMEDIATE CODE: A911

Effective date: 20130701

TRDD Decision of grant or rejection written
A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

Effective date: 20130730

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20130823

R150 Certificate of patent or registration of utility model

Ref document number: 5351746

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150

Free format text: JAPANESE INTERMEDIATE CODE: R150

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

S531 Written request for registration of change of domicile

Free format text: JAPANESE INTERMEDIATE CODE: R313531

R350 Written notification of registration of transfer

Free format text: JAPANESE INTERMEDIATE CODE: R350

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

S533 Written request for registration of change of name

Free format text: JAPANESE INTERMEDIATE CODE: R313533