JP2005251061A - Data processing system, terminal, data processing method, program and recording medium - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a data processing system, etc. by which data are more easily transferred. <P>SOLUTION: A control part 401 of a terminal 103 reads an input text file 502 of target information acquired from an information database 301-1 at a transfer origin and an initial setting file 501 in which processing information 521 required in the case of transferring the data is set via a server 101 by a text fetching processing part 131 by starting a data processing means 121, performs data processing of input text 522 based on the processing information 521 by a character string processing part 132, outputs and holds an output text file 503 which registers the input text 522 in a data processed information database 301-2 by a text output processing part 133. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to a data processing system, a terminal device, a data processing method, and the like that perform data processing when data is transferred between different databases.

  In recent years, when creating catalogs, with the spread of computers, product data to be put on catalogs has been used as a database. Collaborating with a database, catalog creation work is performed by desktop publishing (DTP) or the like, and the efficiency has been improved. For example, there are several data processing systems including a database that stores product information, a server that manages database information, and provides functions such as database input / output, search, and browsing, and a plurality of user terminal devices. Exists (for example, Patent Document 1).

  Many companies generally own a plurality of databases and manage product information according to their purposes. For example, Company A manages the product information separately for the purpose of “database T” for proposing new product information and “database G” for catalog production. The process of selecting from “T” and registering in “Database G” is followed.

JP 2002-32383 A

  However, the conventional data migration method between different databases requires complicated text processing to register the text output from the migration source database in the migration destination database each time as preparation before migration. There was a problem that it took a lot of work.

  The present invention has been made in view of the above points, and an object of the present invention is to provide a data processing system or the like that enables easier data transfer between different databases.

  In order to achieve the above-described object, the first invention is a system in which a terminal device of a registered user and one or more servers having one or more databases are connected via a network, The terminal device is a reading means for reading, as information text, an initial setting text composed of processing information for performing data processing when data is transferred from the database to another database, and information on the database to be data processed from the server Data processing means for processing the information text to create output information text based on the initial setting text, and holding means for holding the output information text that can be transferred to another database. It is a data processing system characterized by doing.

  In the first invention, the terminal device has an initial setting text composed of processing information for performing data processing when data is transferred from the database to another database. Read as text, process the information text based on the default text, create an output information text, and hold the output information text that can be transferred to another database.

The second invention is a terminal device connected via a network to one or a plurality of servers having one or a plurality of databases, and performs data processing when data is transferred from the database to another database An initial setting text consisting of information, a reading means for reading the information of the database to be processed from the server as information text, and an output information text by processing the information text based on the initial setting text A data processing means for creating the output information, and a holding means for holding the output information text that can be transferred to another database.
The second invention relates to a terminal device used in the data processing system of the first invention.

A third invention is a data processing method used in a system in which a terminal device of a registered user and one or more servers having one or more databases are connected via a network, from the database An initial setting text consisting of processing information for data processing when data is transferred to another database, a reading process for reading information of the database to be data processed from the server as information text, and the initial setting text And a data processing step for generating output information text by processing the information text, and a holding step for holding the output information text that can be transferred to another database. It is a processing method.
The third invention relates to a data processing method used in the data processing system of the first invention.

“Initial setting text” is a text file (.ini) including processing information for data processing when data is transferred from one database to another database, and is set in advance.
The “processing information” includes information such as output item specification, output order specification, and character string processing by function.
The “function” has functions such as acquisition, replacement, extraction, division, combination and conversion of character strings.
“Information text” is text data in CSV (Comma Separated Value) format, for example, acquired from the database that is the data processing target of the migration source.
“Output information text” is text data that can be registered in the transfer destination output by the data processing.

A fourth invention is a program for causing a computer to function as the terminal device of the second invention.
A fifth invention is a recording medium on which a program for causing a computer to function as the terminal device of the second invention is recorded.

  The above-mentioned program may be held and distributed on a recording medium such as a CD-ROM, or the program can be transmitted and received via a communication line.

  The present invention can provide a data processing system or the like that enables easier data transfer between different databases.

  Hereinafter, preferred embodiments of a data processing system and the like according to the present invention will be described in detail with reference to the accompanying drawings. In the following description and the accompanying drawings, the same reference numerals are given to components having substantially the same functional configuration, and redundant description will be omitted.

  FIG. 1 is a diagram showing a schematic configuration of a data processing system 100 according to the present embodiment of the present invention.

As shown in FIG. 1, the data processing system 100 is configured by connecting a server 101, terminal devices 103 of a plurality of users 104, and the like via a network 109. The data processing system 100 is a configuration diagram in the case where the data processing system 100 is realized by using WWW (World Wide Web) technology.
The network 109 is a network such as the Internet, a local area network (LAN), or an in-house LAN, and may be wired or wireless.

  The server 101 is a server computer or the like, and includes a WWW server 110, a database operation unit 111, a database server management unit 112, a database management unit 113, and the like. The database operation unit 111 is called from the WWW server 110, and searches a plurality of information databases 301-1, 301-2,. The database server management unit 112 performs system operation and management such as registration of the user 104 and various settings. The database management means 113 is a database engine or the like, and performs corresponding processing for various requests such as search, reference, registration, and deletion to the database.

  The user 104 is a user who uses the information database 301 and is registered in advance in the server 101, and has a terminal device 103. The terminal device 103 includes a WWW browser 120, data processing means 121, and the like. The terminal device 103 accesses the WWW server 110 of the server 101 via the WWW browser 120 by the data processing unit 121, reads information acquired from the information database 301 as input text, and transfers data between different information databases 301. Data processing required for The terminal device 103 is a personal computer, a personal digital assistant, or the like.

  Next, the hardware configuration of the server 101 will be described. FIG. 2 is a hardware configuration diagram of the server 101.

  2, the server 101 includes a control unit 201, a storage device 202 (hard disk), a media input / output unit 203 (CD-ROM), a communication control unit 204 (communication control device, communication port, etc.), an input unit 205. (Keyboard, mouse, etc.), printing unit 206 (printer), display unit 207 (display) and the like are connected via a bus 209.

  The control unit 201 includes a CPU, a ROM, a RAM, and the like, and drives and controls each device connected via the bus 209 in accordance with a program stored in the storage device 202 as a large-capacity storage medium.

  The storage device 202 stores a control program 311 for driving and controlling each component, an application program 312, and a plurality of information databases 301-1, 301-2,.

  Each of these program codes is read by the control unit 201 as necessary, transferred to the RAM, read by the CPU, and executed as various means.

  The media input / output unit 203 (CD-ROM drive device) is used to upgrade the program and information stored in the ROM of the control unit 201 and the storage device 202, and make settings such as device settings.

  The communication control unit 204 is a communication control device, a communication port, and the like, and performs communication control between the server 101 and the terminal device 103 via the network 109.

The input unit 205 is a keyboard, a mouse, and the like, and performs operation guidance, various processes, and operations displayed on the display unit 207 (display).
A printing unit 206 is a printer and performs print output processing.

  Next, a file layout related to the data processing system in the storage device 202 will be described. FIG. 3 shows a file layout related to the data processing system in the storage device 202. As shown in FIG. 3, the storage device 202 stores a plurality of information databases 301-1, 301-2,..., A control program 311, an application program 312 and the like.

  Product information is stored in each of the information databases 301-1, 301-2,. For example, the server 101 manages information databases 301-1, 301-2,... According to uses, such as an information database 301-1 for proposing new product information, an information database 301-2 for catalog production, and the like.

The control program 311 is a program that drives and controls each component of the server 101.
The application program 312 is an executable program, and corresponds to the WWW server 110, the database operation unit 111, the database server management unit 112, the database management unit 113, and the like.

  Next, the hardware configuration of the terminal device 103 will be described. FIG. 4 is a hardware configuration diagram of the terminal device 103.

  As shown in FIG. 4, the terminal device 103 includes a control unit 401, a storage device 402 (hard disk, external memory), a media input / output unit 403 (CD-ROM), a communication control unit 404 (communication control device, communication port, etc.). An input unit 405 (keyboard, mouse, etc.), a printing unit 406 (printer), a display unit 407 (display), etc. are connected via a bus 409.

  The control unit 401 includes a CPU, a ROM, a RAM, and the like, and drives and controls each device connected via the bus 409 according to a program stored in the storage device 402 as a large-capacity storage medium.

  The storage device 402 (hard disk) stores a program for driving and controlling each component, application programs such as a WWW browser 120 and a data processing program 513, an initial setting file 501, an input text file 502, an output text file 503, and the like. ing.

  Each of these program codes is read by the control unit 401 as necessary, transferred to the RAM, read by the CPU, and executed as various means.

  The media input / output unit 403 (CD-ROM drive device) stores an input text file 502 acquired from the information database 301, an output text file 503 for registration in a different information database 301, and the like as necessary. The media input / output unit 403 is used when upgrading the program or information stored in the ROM of the control unit 401 or the storage device 402 and setting the device settings.

  The communication control unit 404 is a communication control device, a communication port, and the like, and performs communication control between the terminal device 103 and the server 101 via the network 109.

The input unit 405 is a keyboard, a mouse, and the like, and performs operation guidance, various processes, and operations displayed on the display unit 407 (display).
A printing unit 406 is a printer and performs print output processing.

  Next, the file arrangement related to the data processing system in the storage device 402 will be described. FIG. 5 shows a file layout related to the data processing system in the storage device 402. As shown in FIG. 5, the storage device 402 stores an initial setting file 501, an input text file 502, an output text file 503, etc., a control program 511, an application program 512, and the like.

  The initial setting file 501 is a text file (.ini) including processing information 521 that is a processing pattern of necessary data processing processing when data is transferred between different information databases 301. The processing information 521 is setting information such as designation of output items (columns), designation of output order, and processing of character strings by functions when data is transferred.

  The input text file 502 is, for example, a CSV (Comma Separated Value) format file that stores the input text 522 that is the information text acquired from the migration source information database 301.

The output text file 503 is a text file (.txt) that stores an output text 523 that is information text registered in the migration destination information database 301 output by the data processing unit 121.
The text contents of the initial setting file 501, the input text file 502, the output text file 503, etc. will be described in detail later.

The control program 511 is a program that drives and controls each component of the terminal device 103.
The application program 512 is an executable program, such as a program corresponding to the WWW browser 120, a data processing program 513 corresponding to the data processing means 121, and the like.

  Next, the configuration and processing contents of the data processing unit 121 that performs data processing will be described. FIG. 6 shows the configuration and processing contents of the data processing means 121 that performs data processing.

  As shown in FIG. 6, the data processing unit 121 includes a text capture processing unit 131, a character string processing unit 132, a text output processing unit 133, a log write processing unit 134, and the like.

The text capture processing unit 131 reads text data such as the processing information 521 of the initial setting file 501 and the input text 522 of the input text file 502.
For example, when data is migrated from the migration source information database 301-1 to the migration destination information database 301-2, the user 104 initially sets the processing information 521 for necessary data processing on the storage device 402 in advance. A file 501 is created. The control unit 401 outputs the target product information acquired from the migration source information database 301-1 as the input text 521 to the input text file 502 via the server 101.

The character string processing unit 132 processes the input text 522 based on the read processing information 521.
The text output processing unit 133 holds the output text file 503 storing the output text 523 that can be registered in the information database 301-2 that has been subjected to the data processing, at the designated output destination.
The log write processing unit 134 writes a log when an error occurs in the data processing process.

  Next, the flow of the processing procedure of the data processing system 100 will be described with reference to FIG. 7, FIG. 8, and FIG. 7, 8, and 9 are flowcharts showing the processing procedure of the data processing system 100.

  The control unit 401 of the terminal device 103 activates an executable data processing program 513 corresponding to the data processing unit 121 (step 701).

  The control unit 401 displays the login screen 10 for accessing and logging in to the server 101 that performs database operations (step 702). FIG. 10 shows the login screen 10. As shown in FIG. 10, the login screen 10 includes a server name 31, a user ID 32, a password 33, a login button 21, and the like.

The user 104 inputs the server name 31, the login ID 32, the password 33, and the like of the information database 301 to be data processed, and presses the login button 21 (step 703). The control unit 401 accesses the server 101 corresponding to the designated server name 31, and transmits a login ID 32, a password 33, and the like (step 704).
The control unit 201 of the server 101 receives the user ID 32, the password 33, and the like input on the login screen 10 from the terminal device 103 via the WWW server 110, and performs user authentication (step 705).
Thereafter, transmission / reception of data between the terminal device 103 and the server 101 is performed via the WWW browser 120 and the WWW server 110.

When the user authentication is correctly performed, the control unit 201 transmits item list data for selecting the information database 301 to be connected to the terminal device 103 (step 706), and the control unit 401 of the terminal device 103 displays the item list screen 11. (Step 707). FIG. 11 shows the item list screen 11. As shown in FIG. 11, the item list screen 11 includes a plurality of item names 34 indicating product information in the information database 301, an OK button 22, and the like.
The user 104 selects the item name 34 (for example, “item name A”) of the product information to be data processed, presses the OK button 22, and the control unit 401 transmits the item name 34 (step 708). .

  The control unit 201 connects the information database 301-1 corresponding to the designated item name 34, and sets and transmits the product information of the item name 34 (step 709). For example, the information database 301-1 having the product information of the designated item name 34 “item name A” is connected, and the product information of the item name 34 “item name A” is transmitted.

  The control unit 401 of the terminal device 103 outputs the product information in the information database 301-1 to be data processed as text data to the input text file (.csv) 502 (step 710). For example, the product information of “item name A” is stored in a predetermined folder such as the storage device 402 or the media input / output unit 403 (CD-ROM) with the file name: “perfect_data.csv”.

The control unit 401 displays the initial setting file reading screen 12 (step 801). FIG. 12 shows the initial setting file reading screen 12.
As shown in FIG. 12, the initial setting file reading screen 12 includes an input field for an initial setting file name 35, a next button 23, a return button 24, a reference button 25, and the like.
In the input field of the initial setting file name 35, the file name of the initial setting file 501 in which the processing information 521 for necessary data processing is set is designated.
When the reference button 25 is pressed, the control unit 401 displays a file reading screen (not shown) including a file name list, and the user 104 searches for and selects the initial setting file name 35. For example, the initial setting file name 35: “C: ¥ DBTtoDBG ¥ INT ¥ cov01.ini” is selected.

  Next, when the button 23 is pressed, the control unit 401 reads the processing information 521 which is the content of the initial setting file 501 of the initial setting file name 35 specified using the reference button 25 or the like ((Step 802). The initial setting file name 35: “C: ¥ DBTtoDBG ¥ INT ¥ cov01.ini” is read.

The control unit 401 displays the text reading screen 13 (step 803). FIG. 13 shows the text reading screen 13.
As shown in FIG. 13, the text reading screen 13 includes an input field of an input text file name 36, a next button 23, a back button 24, a reference button 25, and the like.
In the input field of the input text file name 36, the file name of the input text file (.csv) 502 is designated.
When the reference button 25 is pressed, the control unit 401 displays a file reading screen (not shown) including a list of file names, and the user 104 searches for and selects the input text file name 36. For example, the input text file name 36: “C: ¥ DBTtoDBG ¥ single product ¥ perfect_data.csv” is selected.

  Next, when the button 23 is pressed, the control unit 401 reads the input text 522 which is the content of the input text file 502 of the input text file name 36 designated using the reference button 25 or the like (step 804). For example, the contents of the specified input text file name 36: “C: ¥ DBTtoDBG ¥ single product ¥ perfect_data.csv” are read.

The control unit 401 displays the output destination designation screen 14 (step 805). FIG. 14 shows the output destination designation screen 14.
As shown in FIG. 14, the output destination designation screen 14 includes an input field for an output destination folder name 37, a next button 23, a return button 24, a reference button 25, and the like.
In the input field of the output destination folder name 37, the name of the folder holding the output text file 503 is designated.
When the reference button 25 is pressed, the control unit 401 displays a folder reference screen (not shown) including a folder name list, and the user 104 searches for and selects the output destination folder name 37. For example, output folder name 37: “C: ¥ Documents
and Settings \ yinokuti. Select "CHIGAGO \ Desktop".

  Next, when the button 23 is pressed, the control unit 401 sets the output destination folder name 37 specified by using the reference button 25 or the like (step 806).

The control unit 401 displays a text output confirmation screen 15 for confirming the input / output file (step 807). FIG. 15 shows a text output destination confirmation screen 15.
As shown in FIG. 15, the text output destination confirmation screen 15 includes an initial setting file name 35, an input text file name 36, an output destination folder name 37, an output confirmation button 26, a return button 24, and the like.
After confirming the initial setting file name 35, the input text file name 36, the output destination folder name 37, etc., the user 104 presses the output confirmation button 26 (step 808).

  The control unit 401 processes the input text 522 based on the processing information 521 (output item (column) specification, output order specification, character string processing formula by function, etc.) in the initial setting file 501 (step 901). .

The control unit 401 outputs the output text 523 obtained by processing the data to a specified output destination folder in a predetermined file name: “product structure name_yymmddhhmm (year / month / day / time) .txt” (for example, “item A_0401281926.txt”). Is stored and held as an output text file 503 (step 902). The product structure name is an identification name of the product structure, and the product structure indicates, for example, a data structure of a product unit, and is represented by a product name (personal computer, television, kitchen, etc.). The structure is not limited to the product name, and may be a name such as “electrical appliance” or “accessory” classified into the product category, for example.
The output text 523 of the output text file 503 is text data that can be registered as information in the migration destination information database 301-2.

The control unit 401 displays the end confirmation screen 16 (step 903). FIG. 16 shows an end confirmation screen 16.
As shown in FIG. 16, the end confirmation screen 16 is displayed from the output destination folder name 37, the output text file name 38, etc. of the output text 523 after the data processing, the log display button 27, the continue processing button 28, the end button 29, etc. Become. The user 104 checks the output destination folder name 37, the output text file name 38, etc. of the output text 523.
When the log display button 27 is pressed, the control unit 401 displays and outputs the error log created by the log writing processing unit.

When continuing the data processing, the control unit 401 proceeds to step 707 by pressing the continue button 28, and continues the data processing (Yes in step 904).
When the process is to be ended, the end button 29 is pressed, and the control unit 401 ends the data processing (No in step 904).

  Next, data processing of the input text 522 based on the processing information 521 of the initial setting file 501 in step 901 will be described in detail using a specific example with reference to FIGS. 17 and 18. FIG. 17 shows the processing information 521 of the initial setting file 501. FIG. 18 shows the output results of the input text 522 and the output text 523.

  The output text 523 shown in FIG. 18 is an output result obtained by processing the input text 522 based on the processing information 521 of the initial setting file 501 shown in FIG. The processing information 521 includes a plurality of processing formulas 41-1, 41-2,..., And the control unit 401 sequentially processes the input text 522 according to the processing formulas 41-1, 41-2,. Output text 523 is created.

The processing formula 41-1 “Info1_media = 1” is input text data i1 in the first column of the input text 522 → output text data o1 in the first column of the output text 523. For example, it is assumed that the input text data i1-1 “catalog spring issue” of 1 row-1 column → output text data o1-1 “catalog spring issue” of 1 row-1 column.
The processing formula 41-2 “Info2_media = Concatenate (“ G ”, 4)” combines the input text data i4 in the fourth column with the character string “G” → the output text data o2 in the second column. For example, “G” and the input text data i1-2 “1234567” in the 1st row and the 2nd column are combined → the output text data o1-2 “G1234567” in the 1st row and the 2nd column.
The processing formula 41-3 “Info3_media = Substate (5,“ − ”,“ _ ”)” replaces “−” included in the input text data i5 in the fifth column with “_” → the third column The output text data is o3. For example, “−” in the input text data i1-5 “1-23-4567” in the first row and the fifth column is replaced with “_” → the output text data o1-3 “1 — 23 — 4567” in the first row and the third column.
Similarly, the control unit 401 performs data processing according to the processing formula 41-4 to the processing formula 41-9, and the generated output text 523 is, for example, “catalog name” for the output text data o1, and for the output text data o2 “Registration No.” and output text data o3 are data of items representing “article number” and the like, and their arrangement, and are processed into information text that can be registered in the information database 301-2.

Next, typical character string conversion functions that can be used are shown.
Left (STRING, StartPos, Len) A function that acquires a character string.
Right (STRING, StartPos, Len) A function that acquires a character string.
Substate (STRING, TargetString, ReplaceString) A function that replaces a character string.
Divide (STRING, StartDir, Len, InsertString) A function that divides a character string.
Concatenate (STRING, [STRING, ...]) A function that combines character strings.
Position (STRING, TargetString, StartPos, Time) A function for acquiring the start character position of a character string.
Length (STRING) A function that gets the number of characters in a string.
Trim (STRING) A function that deletes spaces before and after a character string.
RomanZenkaku (STRING) A function that converts Roman characters to full-width.
Roman Hankaku (STRING) A function that converts Roman characters into half-width characters.
Upper (STRING) A function that converts Roman letters to upper case.
Lower (STRING) A function that converts Roman letters to lower case.
KanaZenkaku (STRING) A function that converts half-width katakana to full-width katakana.
Kana Hankaku (STRING) A function that converts full-width katakana to half-width katakana.
PatternCount (STRING, TargetString) A function for acquiring the number of occurrences of a character string.
Mod (Num, Rem) A function that obtains the remainder when a numerical value is divided by a divisor.
IF (Expression, TrueValue, FalseValue) A function that performs condition determination.

  As described above, according to the embodiment of the present invention, when data is migrated from the migration source information database 301-1 to the migration destination information database 301-2, the user 104 is stored in advance on the storage device 402. An initial setting file 501 in which processing information 521 for necessary data processing is set is created. The control unit 401 of the terminal device 103 activates an executable program corresponding to the data processing unit 121, thereby the object acquired from the migration source information database 301-1 by the text import processing unit 131 via the server 101. The input text file 502 and the initial setting file 501 of the information to be read are read, the character string processing unit 132 processes the input text 522 based on the processing information 521, and the text output processing unit 133 performs data processing. The output text file 503 that can be registered in the information database 301-2 is output and held.

  Thereby, in data transfer between different databases, the burden of text processing is reduced, and product information can be transferred more easily. As in the past, as preparation before migration, there is no need to perform complicated text processing to register the text output from the migration source database in the migration destination database each time. Can be migrated.

Further, by using a processing pattern (processing formula) such as a character string conversion function as required in advance, the user can freely perform data processing in data migration.
Furthermore, by making it possible to easily transfer product information, it is possible to further utilize and develop the information stored in the database for other uses.

  In this embodiment, the information database 301 that stores product information and the like is used as the database, but the present invention is not limited to product information and the like.

  In the present embodiment, the WWW technology is used. However, the terminal device 103 can be realized without using the WWW technology by providing a dedicated user program.

  In this embodiment, the initial setting file 501, the input text file 502, the output text file 503, and the like are stored in the storage device 402. However, between the different databases using the input / output medium 403 (CD-ROM or the like). May be migrated.

  In the present embodiment, a plurality of terminal devices 103 and a server 101 having a plurality of information databases 301-1, 301-2,... Are connected and have different information databases 301-1 and 301-2. The server 101 performs data processing in data migration between the information databases 301-1, 301-2, and includes a plurality of terminal devices 103 and one or a plurality of information databases 301-1, 301-2,. A plurality of servers 101-1, 101-2,... Are connected. For example, data in data migration between the server 101-1 having the information database 301-1 and the server 101-2 having the information database 301-2. Processing may be performed.

  Furthermore, in the present embodiment, each terminal device 103 performs data processing by installing and starting an executable program corresponding to the data processing unit 121 by some method, but the data processing unit on the server side. A data processing server corresponding to 121 may be included, and the data processing server may be accessed from a plurality of terminal devices to perform data processing.

  Note that the program for performing the processing shown in FIGS. 7, 8, 9 and the like may be distributed on a recording medium such as a CD-ROM, or the program may be transmitted and received via a communication line.

  The preferred embodiments of the data processing system and the like according to the present invention have been described above with reference to the accompanying drawings, but the present invention is not limited to such examples. It will be apparent to those skilled in the art that various changes and modifications can be conceived within the scope of the technical idea disclosed in the present application, and these are naturally understood to belong to the technical scope of the present invention. Is done.

The figure which shows schematic structure of the data processing system 100 which concerns on this Embodiment. Hardware configuration diagram of server 101 The figure which shows the data processing system related file in the memory | storage device 202 Hardware configuration diagram of the terminal device 103 The figure which shows the data processing system related file in the memory | storage device 402 The figure which shows the structure and process content of the data processing means 121 Flow chart showing processing procedure of data processing system 100 Flow chart showing processing procedure of data processing system 100 Flow chart showing processing procedure of data processing system 100 Diagram showing login screen 10 The figure which shows the item list screen 11 The figure which shows the initial setting file reading screen 12 The figure which shows the text reading screen 13 The figure which shows the output destination designation | designated screen 14 The figure which shows the text output confirmation screen 15 The figure which shows the completion confirmation screen 16 The figure which shows the process information 521 of the initialization file 501 The figure which shows the output result of the input text 522 and the output text 523

Explanation of symbols

DESCRIPTION OF SYMBOLS 100 ......... Data processing system 101 ......... Server 103 ......... Terminal device 104 ......... User 109 ......... Network 110 ......... WWW server 111 ......... Database operation means 112 ......... Database server management means 113 ......... Database management means 120 ......... WWW browser 121 ......... Data processing means 201, 401 ......... Control section 202, 402 ......... Storage device 501 ......... Initial setting file 502 ......... Input text file 503 ......... Output text file 521 ......... Processing information 522 ......... Input text 523 ......... Output text

Claims (9)

A system in which a terminal device of a registered user and one or more servers having one or more databases are connected via a network,
The terminal device
Initial setting text consisting of processing information for data processing when data is transferred from the database to another database;
Reading means for reading the information of the database to be data processed from the server as information text;
Data processing means for processing the information text to create an output information text based on the initial setting text;
Holding means for holding the output information text that can be transferred to another database;
A data processing system comprising: The processing information is
The data processing system according to claim 1, comprising at least one of information such as designation of an output item, designation of an output order, and character string processing by a function. The function is
The data processing system according to claim 2, comprising at least one function of obtaining, replacing, extracting, dividing, combining, and converting character strings. A terminal device connected via a network to one or more servers having one or more databases,
Initial setting text consisting of processing information for data processing when data is transferred from the database to another database;
Reading means for reading the information of the database to be data processed from the server as information text;
Data processing means for processing the information text to create an output information text based on the initial setting text;
Holding means for holding the output information text that can be transferred to another database;
A terminal device comprising: The processing information is
The terminal device according to claim 4, wherein the terminal device includes at least one piece of information such as designation of an output item, designation of an output order, and character string processing by a function. The function is
The terminal device according to claim 5, comprising at least one function of character string acquisition, replacement, extraction, division, combination, conversion, and the like. A data processing method used in a system in which a terminal device of a registered user and one or more servers having one or more databases are connected via a network,
Initial setting text consisting of processing information for data processing when data is transferred from the database to another database;
From the server, the reading process of reading the information of the database to be processed data as information text,
Based on the initial setting text, a data processing step of processing the information text to create an output information text;
A holding step for holding the output information text that can be transferred to another database;
The data processing method characterized by comprising. The program which functions a computer as a terminal device in any one of Claims 4-6. A recording medium storing a program for causing a computer to function as the terminal device according to claim 4.

Images