WO2002021327A2 - Verfahren und computerprogramm zur erzeugung von dateien für ein datenbanksystem für ein betriebswirtschaftliches anwendungsprogramm - Google Patents
Verfahren und computerprogramm zur erzeugung von dateien für ein datenbanksystem für ein betriebswirtschaftliches anwendungsprogramm Download PDFInfo
- Publication number
- WO2002021327A2 WO2002021327A2 PCT/DE2001/003467 DE0103467W WO0221327A2 WO 2002021327 A2 WO2002021327 A2 WO 2002021327A2 DE 0103467 W DE0103467 W DE 0103467W WO 0221327 A2 WO0221327 A2 WO 0221327A2
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- database
- database object
- data
- computer
- index
- Prior art date
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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99942—Manipulating data structure, e.g. compression, compaction, compilation
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99943—Generating database or data structure, e.g. via user interface
Definitions
- the present invention relates to computer-implemented database systems and in particular to a method of file creation to improve the manageability Syste for a database system for business' applications.
- Databases are computerized systems for storing and retrieving information.
- a relational database management system (RDBMS) is a database management system (DBMS) that uses relational techniques to store and retrieve data. Relational databases are organized in tables that consist of data rows and columns.
- a database typically contains many tables, and each table typically contains multiple tuples and multiple columns that consist of individual data fields.
- the tables are usually stored on Direct Access Storage Devices (DASD), such as magnetic or optical 1 disk drives for semi-permanent storage.
- DASD Direct Access Storage Devices
- An index is a table type or data field type that is used to access data in a table that contains data that is to be accessed (for example, employee data or financial data for a business application program). To distinguish between an index and a table with data to be accessed, a Table that contains data to be accessed is referred to as "data table”.
- Data tables and indexes are types of database objects that are stored in a database. There are many different application programs
- An application system is a system that supports different and multiple application programs on a single relational database system.
- Each of the supported application programs requires at least one or more data tables and indexes.
- all the necessary data tables and indexes are usually generated in the database system for each of the supported application programs. For example, if an application system supports three application programs (one human resource management program, one
- Application system generate 30,000 data tables and indexes during implementation.
- ERP Enterprise Resource Planning
- An enterprise resource planning system is an enterprise management system that integrates various aspects of an enterprise, such as human resources, finance, production and logistics.
- Software systems have been developed to implement ERP systems.
- an application system that supports various application programs (a human resource management program, a financial application program, and a production application program) can form an ERP system.
- a typical ERP system uses a database, which usually contains several thousand data tables and contains indexes.
- a database usually contains several thousand data tables and contains indexes.
- the database would still be created with 30,000 data tables and indexes.
- B. 20,000 data tables and indexes for the human resource management program and the financial application program would be included, but are not required.
- users have no knowledge of whether and which data tables and indexes are in use or not. Nevertheless, the hardware means such. B.
- the file creation process is the process of allocating and allocating space from, for example, DASD. This file creation process is generally slow. For example, in computer systems known in the art, it takes approximately 0.1-0.3 seconds to generate a single file with a * data table.
- the invention describes a method, an apparatus and a computer program for a method implemented by computers for generating and setting up files as required which improves system manageability for a database system.
- database objects are generated by means of a computer which is connected to a data storage device.
- a command to create a database object is received at the beginning.
- a database object definition is saved for this database object.
- a data table is accessed for data transfer, a file for the database object is generated on a storage medium from this specific database object definition.
- the advantage of this method lies in the fact that storage space only has to be made available when data are available for storage in the intended data table. Another advantage is that the implementation phase of the database system takes less time.
- FIG. 1 shows an example of a computer hardware environment that can be used in accordance with the invention
- FIG. 2 is a flowchart describing a process performed by the deferred file creation system.
- FIG. 3 shows a flowchart describing a process performed by the deferred file creation system in one embodiment.
- FIG. 1 shows an example of a computer hardware environment that can be used in accordance with the invention.
- a computer system 102 consists of one or more processors connected to one or more data storage devices 104 and 106 on which one or more relational databases are stored, such as a hard disk drive, a floppy disk drive, and one CD-ROM drive, a tape drive, or other device.
- a standard operator interface 108 is used to send electrical signals to and from the computer system 102, the commands to perform various Display search and retrieval functions, so-called queries, on the databases.
- these queries correspond to the known structural query language standard (SQL) and call known functions which are carried out by a data management component which supports transactions (ie work units; an application program can carry out several transactions), such as relational database management system software (RDBMS software).
- SQL structural query language standard
- RDBMS software relational database management system software
- the SQL interface has become a standard language for RDBMS software and has been adopted as such by the American National Standards Institute (ANSI) and the International Standards Organization (ISO).
- a data management component which supports transactions comprises a database system for a mainframe computer with a known operating system.
- the invention can be applied to any RDBMS software, regardless of whether the RDBMS software SQL is used or not.
- the computer system has three major components: the Internal Resource Lock Manager (IRLM) 110, the system service module 112, and the database service module 114.
- the IRLM 110 handles locking services for the database system, which treats data as a shared resource, so that any many users can access the same data at the same time. Therefore, a parallel Control is needed to isolate users and maintain data integrity.
- the system service module 112 controls the entire database execution environment, including the management of LOG log files 106, the compilation of statistics, the handling of system start and shutdown, and the provision of administrative support.
- the core of the database system is the database service module 114.
- the database service module 114 contains several sub-modules, including the relational database system (RDS) 116, the data manager 118, the buffer manager 120, the system for deferred file generation 124 and other components 122, such as an SQL compiler / interpreter. These sub-modules support the functions of the well-known language SQL, i.e. Definition, access control, interpretation, compilation, database retrieval and updating of user and system data.
- the deferred file creation system 124 works in conjunction with the other sub-modules to restore the balance of partitioned data.
- the invention is typically implemented using SQL statements that are executed under the control of the database service module 114.
- the database service module 114 invokes or receives the SQL statements, the SQL statements generally being stored in a text file on the data storage devices 104 and 106 or entered interactively by a user working on a monitor 126 into the computer system 102 via a user interface 108 become.
- the database service module 114 then derives or creates commands for execution by the computer system 102 from the SQL instructions.
- the RDBMS software, the SQL statements and the commands derived therefrom are implemented in a machine-readable medium, for example in one or more of the data storage devices 104 and 106.
- the RDBMS software, the SQL statements, and the commands derived from them all consist of commands that, when read and executed by the computer system 102, cause the computer system 102 to take the necessary steps for implementation and / or Use of the invention.
- the RDBMS software, the SQL instructions and the program commands derived therefrom are loaded from the data storage devices 104 and 106 into a memory of the computer system 102 for use during actual computer operations.
- production article (or also "computer program product”) as used here is intended to include a computer program that is accessible from any computer-readable device, carrier or medium.
- Alternative hardware environments can be used to implement the invention.
- Database system for delaying file generation 124 For an application system such as an ERP system, the system for delaying file generation 124 controls the generation of the underlying files from data tables and indexes for Application programs. In order to equalize the time of the file generation 124, the system initially only writes data table and index definitions for the data tables and indexes that may be required at a later time in a database catalog. The storage space required for this database catalog and the creation time required for this are much less than for the correspondingly required data tables. The system only generates 124 files for a specific data table or a specific index for equalizing the time of the file generation when data are to be entered in this specific data table or this specific index (ie when the first data record is entered in this data table or this index ). The user can install z. B. determine by parameter selection whether the file creation should be deferred or whether the data table with its files should be created initially.
- the user of a database system can create an employee table with columns for the name, address and social security number of the employee and delay the file creation with the following known example SQL statements:
- DEFINE can be replaced by another keyword.
- a user uses the CREATE INDEX keywords followed by an index name, a data table name for which to create the index, and an index column list that defines the list of columns in the index.
- a user enters DEFINE NO to delay file creation and DEFINE YES to not delay file creation.
- a user can create an employee index on the table with a column for a social security number and delay file creation with the following example SQL statement:
- the user specifies the DEFINE YES or DEFINE NO option for the CREATE TABLE / INDEX SQL statements. If the DEFINE NO option is specified, the file generation delaying system 124 registers all data table and index schema definitions in the database catalog without generating the underlying files for any data tables or indexes until a first data record is entered in the data table or in the index.
- the system When a record is first entered into a data table or index that is in an UNDEFINED state, the system creates the underlying files to delay file creation 124.
- FIG. 2 shows a flow diagram of a process performed by the file creation delay system 124.
- the file creation delay system 124 receives a CREATE TABLE or CREATE INDEX statement to create a table or index with a DEFINE NO clause.
- the file creation delay system 124 defines a data table or index.
- the file generation delay system 124 creates a file for this data table or index when data is to be entered into a data table or index.
- the file creation delay system 124 treats the undefined data tables or indexes as logically empty
- the system for delaying file creation 124 does not generate the underlying files for the undefined tables or indexes. Instead, the file creation delay system 124 returns an indication that the database object must not be modified.
- the LOAD utility is the only database utility that can run on an undefined data table.
- the file generation delay system 124 in one embodiment returns an indication when operations on an undefined data table are requested and that the database is not may be modified.
- the system for delaying file creation 124 issues an informational message indicating that the database utility has not been executed and ignores the requested operation.
- the file creation delay system 124 when a database utility is started with a number of defined and undefined data tables, allows a user to decide whether to define the undefined data tables, defines any undefined data tables if that User has requested that they be defined and then executes the requested utility on the defined tables.
- FIG. 3 shows a flowchart describing a process performed by the file creation delay system 124 in one embodiment.
- the file creation delay system 124 determines whether a request to execute an INSERT statement or a LOAD utility has been received. If so, the file generation 124 delay system continues to block 402; otherwise, the file generation 124 system continues to block 410.
- the file creation delay system 124 determines whether an undefined data table or an undefined index is affected. If so, the file creation delay system 124 proceeds to block 404; otherwise, the file creation 124 system continues to block 406.
- the system for delaying file generation 124 creates an underlying file for the affected data table or the affected index.
- the file creation delay system 124 enters data in the data table or index.
- the file creation delay system 124 determines whether a request to perform a SELECT, UPDATE, or DELETE operation has been received. If so, the file generation delayed system 124 continues to block 412; otherwise, the file generation 124 delayed system continues to block 420.
- the system for delaying file generation 124 determines whether an undefined data table or an undefined index is affected. If so, the file creation delay system 124 proceeds to block 414; otherwise, the file creation 124 system continues to block 416.
- the file generation delay system 124 returns a row not found message.
- the file creation delay system 124 performs the requested operation.
- the file creation delay system 124 determines whether a request to perform a utility (other than LOAD) has been received. If so, the file creation delay system 124 proceeds to block 422; otherwise, the file creation 124 delay system proceeds to block 422
- the file creation delay system 124 determines whether an undefined data table or index is affected. If so, the file creation delayed system 124 continues to block 424; otherwise, the file generation 124 delayed system continues to block 426. At block 424, the file creation delay system 124 returns an indication that the utility cannot be executed. In block 426, the system leads to the deceleration file creation 124 executes the requested utility (ie, starts the utility).
- the invention can be used on different types of computers, such as, for example, mainframe computers, minicomputers or personal computers, or any computer configuration, such as, for example, the Internet, a local area network or a multimedia information system distributed worldwide.
- computers such as, for example, mainframe computers, minicomputers or personal computers, or any computer configuration, such as, for example, the Internet, a local area network or a multimedia information system distributed worldwide.
Abstract
Description
Claims
Priority Applications (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
AU2002212080A AU2002212080A1 (en) | 2000-09-11 | 2001-09-10 | Method and computer program for generating files for a database system for a business management user program |
DE10193778T DE10193778D2 (de) | 2000-09-11 | 2001-09-10 | Verfahren und Computerprogramm zur Erzeugung von Dateien für ein Datenbanksystem für ein betriebswirtschaftliches Anwendungsprogramm |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US09/659,252 | 2000-09-11 | ||
US09/659,252 US6775676B1 (en) | 2000-09-11 | 2000-09-11 | Defer dataset creation to improve system manageability for a database system |
Publications (2)
Publication Number | Publication Date |
---|---|
WO2002021327A2 true WO2002021327A2 (de) | 2002-03-14 |
WO2002021327A3 WO2002021327A3 (de) | 2004-04-01 |
Family
ID=24644679
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/DE2001/003467 WO2002021327A2 (de) | 2000-09-11 | 2001-09-10 | Verfahren und computerprogramm zur erzeugung von dateien für ein datenbanksystem für ein betriebswirtschaftliches anwendungsprogramm |
Country Status (5)
Country | Link |
---|---|
US (1) | US6775676B1 (de) |
EP (1) | EP1195693A3 (de) |
AU (1) | AU2002212080A1 (de) |
DE (1) | DE10193778D2 (de) |
WO (1) | WO2002021327A2 (de) |
Families Citing this family (20)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US6944630B2 (en) | 2000-11-22 | 2005-09-13 | Bmc Software | Database management system and method which monitors activity levels and determines appropriate schedule times |
GB2382890B (en) * | 2001-12-06 | 2005-04-20 | Ibm | Computer storage subsystem, method, software program and data carrier |
US7664798B2 (en) * | 2003-09-04 | 2010-02-16 | Oracle International Corporation | Database performance baselines |
US7673291B2 (en) * | 2003-09-05 | 2010-03-02 | Oracle International Corporation | Automatic database diagnostic monitor architecture |
US20060069679A1 (en) * | 2004-09-10 | 2006-03-30 | Percey Michael F | System for creating associative records |
US7941620B2 (en) * | 2005-09-12 | 2011-05-10 | International Business Machines Corporation | Double-allocation data-replication system |
US20070073761A1 (en) * | 2005-09-29 | 2007-03-29 | International Business Machines Corporation | Continual generation of index advice |
US8838573B2 (en) * | 2006-06-09 | 2014-09-16 | International Business Machines Corporation | Autonomic index creation |
US8838574B2 (en) * | 2006-06-09 | 2014-09-16 | International Business Machines Corporation | Autonomic index creation, modification and deletion |
US20070288489A1 (en) * | 2006-06-09 | 2007-12-13 | Mark John Anderson | Apparatus and Method for Autonomic Index Creation, Modification and Deletion |
US8990811B2 (en) * | 2007-10-19 | 2015-03-24 | Oracle International Corporation | Future-based performance baselines |
US8239417B2 (en) * | 2008-08-07 | 2012-08-07 | Armanta, Inc. | System, method, and computer program product for accessing and manipulating remote datasets |
US8905771B2 (en) * | 2013-04-28 | 2014-12-09 | Chang Fu Tsai | Structure of tree-shaped lighting decoration |
US20160147852A1 (en) * | 2014-11-21 | 2016-05-26 | Arndt Effern | System and method for rounding computer system monitoring data history |
US9552162B2 (en) | 2014-12-08 | 2017-01-24 | Sap Se | Splitting-based approach to control data and storage growth in a computer system |
US10366079B1 (en) | 2015-01-26 | 2019-07-30 | Microstrategy Incorporated | Enterprise connectivity |
US10503706B2 (en) * | 2015-06-01 | 2019-12-10 | Sap Se | Deferred data definition statements |
US10452656B2 (en) | 2016-03-31 | 2019-10-22 | Sap Se | Deep filter propagation using explicit dependency and equivalency declarations in a data model |
US11030241B2 (en) * | 2017-03-07 | 2021-06-08 | Imperva, Inc. | Query usage based organization for very large databases |
US10402405B2 (en) | 2017-04-05 | 2019-09-03 | Sap Se | Explicit declaration of associations to optimize grouping of elements by large data objects |
Family Cites Families (13)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5555409A (en) | 1990-12-04 | 1996-09-10 | Applied Technical Sysytem, Inc. | Data management systems and methods including creation of composite views of data |
US5579515A (en) | 1993-12-16 | 1996-11-26 | Bmc Software, Inc. | Method of checking index integrity in a DB2 database |
US5745895A (en) | 1994-06-21 | 1998-04-28 | International Business Machines Corporation | Method for association of heterogeneous information |
US6223227B1 (en) * | 1994-12-07 | 2001-04-24 | Next Software, Inc. | Method for providing stand-in objects |
US5835915A (en) * | 1995-01-24 | 1998-11-10 | Tandem Computer | Remote duplicate database facility with improved throughput and fault tolerance |
US5950210A (en) * | 1996-01-29 | 1999-09-07 | Nelson; Paul M. | Database row version differentiation process |
US5778390A (en) * | 1996-06-07 | 1998-07-07 | Electronic Data Systems Corporation | Method and systems for creating duplicating, and archiving database files |
US5905987A (en) * | 1997-03-19 | 1999-05-18 | Microsoft Corporation | Method, data structure, and computer program product for object state storage in a repository |
US6047284A (en) * | 1997-05-14 | 2000-04-04 | Portal Software, Inc. | Method and apparatus for object oriented storage and retrieval of data from a relational database |
US6016497A (en) * | 1997-12-24 | 2000-01-18 | Microsoft Corporation | Methods and system for storing and accessing embedded information in object-relational databases |
US6304867B1 (en) * | 1999-02-25 | 2001-10-16 | Electronic Data Systems Corporation | System and method for enhanced performance of a relational database management system through the use of application-specific memory-resident data |
US6598037B1 (en) * | 1999-07-26 | 2003-07-22 | Microsoft Corporation | Data table object interface for datastore |
US6662199B1 (en) * | 2000-01-04 | 2003-12-09 | Printcafe Systems, Inc. | Method and apparatus for customized hosted applications |
-
2000
- 2000-09-11 US US09/659,252 patent/US6775676B1/en not_active Expired - Lifetime
-
2001
- 2001-09-10 AU AU2002212080A patent/AU2002212080A1/en not_active Abandoned
- 2001-09-10 DE DE10193778T patent/DE10193778D2/de not_active Expired - Fee Related
- 2001-09-10 WO PCT/DE2001/003467 patent/WO2002021327A2/de active Application Filing
- 2001-09-10 EP EP01000439A patent/EP1195693A3/de not_active Ceased
Non-Patent Citations (2)
Title |
---|
P. BRUNI ET AL: "DB2 UDB Server for OS/390 Version 6 - Technical Update" Juni 2000 (2000-06), INTERNATIONAL BUSINESS MACHINES CORP. , XP002268442 Gefunden im Internet: <URL:ibm.com/redbooks> Seite 173, Zeile 1 - letzte Zeile * |
ROGER MILLER: "What's New in DB2 for OS/390 Version 6 - Recent Enhancements" SHARE IN BOSTON, PRACTICAL EDUCATION FOR IT PROFESSIONALS, 23. Juli 2000 (2000-07-23), - 28. Juli 2000 (2000-07-28) Seiten 1-30, XP002268441 BOSTON, MASSACHUSSETS, USA * |
Also Published As
Publication number | Publication date |
---|---|
AU2002212080A1 (en) | 2002-03-22 |
EP1195693A3 (de) | 2004-03-31 |
DE10193778D2 (de) | 2003-07-31 |
WO2002021327A3 (de) | 2004-04-01 |
EP1195693A2 (de) | 2002-04-10 |
US6775676B1 (en) | 2004-08-10 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
WO2002021327A2 (de) | Verfahren und computerprogramm zur erzeugung von dateien für ein datenbanksystem für ein betriebswirtschaftliches anwendungsprogramm | |
JP2768433B2 (ja) | 物理データベース設計システム | |
DE112012000280B4 (de) | Organisation von Tabellen mit reduzierten Indizes | |
DE102012216022B4 (de) | Verwaltung einer Zeitpunktkopie-Beziehung für platzsparende Datenträger | |
DE60306674T2 (de) | Verfahren und systeme zur regelung des zugriffs auf ein datenobjekt mittels sperren | |
EP1088280B1 (de) | Verfahren und system zur schnellen speicherresidenten verarbeitung von transaktionsdaten | |
DE69333408T2 (de) | Ein Computer-System und Verfahren zum interaktiven Verwalten eines verteilten Datenbanksystems | |
DE69533193T2 (de) | Paralleles verarbeitungssystem zum durchlaufen einer datenbank | |
US7174345B2 (en) | Methods and systems for auto-partitioning of schema objects | |
US6480848B1 (en) | Extension of data definition language (DDL) capabilities for relational databases for applications issuing DML and DDL statements | |
EP0633538A2 (de) | Relationales Datenbankverwaltungssystem | |
DE202015009875U1 (de) | Transparente Entdeckung eines semistrukturierten Datenschemas | |
US6289355B1 (en) | Fast log apply | |
DE19926116A1 (de) | Mehr-Teilprozeß-Protokollierung in einer Konfigurationsdatenbank | |
DE112012004099T5 (de) | Transaktionsverarbeitungssystem, Verfahren und Programm | |
DE10113577A1 (de) | Verfahren, Computerprogrammprodukt und Computersystem zur Unterstützung mehrerer Anwendungssysteme mittels eines einzelnen Datenbank-Systems | |
JP2003505766A (ja) | クエリー最適化プラン用インデックスに対する変化の効果を観察するためのデータベースシステム | |
DE202019005716U1 (de) | Nachverfolgen von Änderungen bei Datenbankdaten | |
DE102013215009A1 (de) | Verfahren und System zur Optimierung der Datenübertragung | |
DE19534819B4 (de) | Verfahren und Vorrichtung zum Konfigurieren einer Datenbank | |
DE102021125630A1 (de) | Datensynchronisation in einem datenanalysesystem | |
EP1276056B1 (de) | Verfahren zum Verwalten einer Datenbank | |
DE60223546T2 (de) | Verfahren und system zur neuorganisierung eines "tablespace" in einer datenbank | |
DE10063512B4 (de) | Technik zum Einrichten eines Konsistenzpunktes in einem System zum parallelen Laden einer Datenbank | |
US6453322B1 (en) | Extension of data definition language (DDL) capabilities for relational databases for applications issuing multiple units of work |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
AK | Designated states |
Kind code of ref document: A2 Designated state(s): AE AG AL AM AT AU AZ BA BB BG BR BY BZ CA CH CN CO CR CU CZ DE DK DM DZ EC EE ES FI GB GD GE GH GM HR HU ID IL IN IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MA MD MG MK MN MW MX MZ NO NZ PH PL PT RO RU SD SE SG SI SK SL TJ TM TR TT TZ UA UG UZ VN YU ZA ZW |
|
AL | Designated countries for regional patents |
Kind code of ref document: A2 Designated state(s): GH GM KE LS MW MZ SD SL SZ TZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE TR BF BJ CF CG CI CM GA GN GQ GW ML MR NE SN TD TG |
|
121 | Ep: the epo has been informed by wipo that ep was designated in this application | ||
DFPE | Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101) | ||
REF | Corresponds to |
Ref document number: 10193778 Country of ref document: DE Date of ref document: 20030731 Kind code of ref document: P |
|
WWE | Wipo information: entry into national phase |
Ref document number: 10193778 Country of ref document: DE |
|
122 | Ep: pct application non-entry in european phase | ||
NENP | Non-entry into the national phase |
Ref country code: JP |