DE102005014365A1 - Data e.g. text files, transferring method for electronic data processing system, involves directly loading export data of clients to transfer server, and determining recipient addresses from logical links between export and import objects - Google Patents

Abstract

The method involves directly loading export data of clients from a user environment to a common transfer server and assigning receivers for the server. Recipient addresses are determined from logical links between export and import objects of the clients, in the server. A download data packet (12) is provided for each receiver, where the packet is gathered from the loaded data of transmitters. The packet is read from the receiver to automatically update import tables and folders in the environment. The imported data are evaluated with local data to automatically execute specified actions. Independent claims are also included for the following: (1) a transfer server (2) a database component of a client server (3) logical links between export and import tables and/or export and import folders (4) a method for evaluation of imported data (5) a data export method (6) a method for update of data in a time table of receiver (7) a method for update of import tables of clients (8) a transfer channel (9) a data import method.

Description

1. Today's state of it

The Internet is used in virtually every company today. information On the internet you can basically sort into two categories: unstructured data (any files) and structured data (database tables) that are different Kind of be treated.

The Structured information on the internet today is in the databases stored on the WEB servers containing the contents of the databases in the browser. This principle is called client / server principle, where the client is always active and communicates with the WEB server. This principle has been well valued in local networks, where employees of the Company using common databases. Become this principle organized on the Internet the WEB shops, where the Internet users orders do.

The Databases are indispensable for Computer systems have become virtually common in all companies, the first on economic conditions are aligned. In the databases are the most valuable information stored by the companies (invoices, delivery notes, offers etc.), practically every day to be updated by specialists. The corresponding documents will be printed out and sent to the recipients who receive these documents again in his database system need to grasp what is a disadvantage is to be designated. And today's task of EDP is this double To avoid work.

databases who are present on the internet are operated by the internet server and any internet user can on these databases over access the browser. The browser is on the hard disk of the User saved, but is designed so that he himself no Can connect to the database systems on local machine. It is the main one Disadvantage of centrally created databases on the Internet. And the Internet users must regularly appropriate See tables, if he timely the important changes wants to remember in the internet tables.

Under Unstructured information is usually understood differently Files where the information is not presented in tabular form become. There are different files (eg text files with or without graphic elements, voice files, etc.) by the user or the corresponding user Programs are generated. The content of these files is easy do not place in a table.

By The Emaildienst instead of more ordinary Letters send simple text files. As attachments to an email can attached any files usually not structured and often graphic Include elements. Alternative to the email is the fax service, which usually transmits only unstructured files and can print out immediately. today However, the fax service is less and less used. The Internet users can from the Internet the unstructured files also from the FTP server download, more and more often is used. Today, more and more so-called language files exchanged between the Internet users, what the users of the typing work will relieve.

All Files that come from the Internet would and should normally read by the staff and in someplace in the local area be saved if useful Information includes.

The Evaluation of the files over download the email service or from the FTP server, takes time and therefore costs money. And the tendency is rising. This general disadvantage of all client-server systems used today to reduce, always new solutions are sought.

In D2 will be a system for Distribution of press releases. It is planned that in a package program parts, documents, etc. transmitted to clients so that the client can read the press release offline.

D3 describes a system for storing and treating patient medical documents. The information about patients and documents (document data) is stored in tables on the server. The documents themselves are stored as files on the server. The following important fields are created in this table except ordinary fields: "document origination date / time", "unique file identifier". The first field defines when the document file was created or changed, the other one Field refers to the file of the document. The client can retrieve data from specific patients. He can specify certain restrictions (eg last modified document of the client). The client gets a list of requested documents. The selected document is downloaded to the client. The document D3 is completely based on the client / server principle and therefore has practically the same disadvantages.

D4 describes a database platform that includes a client and a server component includes. The client and server components can be accessed through different network protocols including the internet protocol communicate with each other. applications under Lotus Notes are stored in the form of individual databases, the individual records within the databases are considered as documents. These records can be any Information contained in fields, as well as WWW links in form from so-called hotspots. For a Notes user to enter the data of a Database can also use without connection to the server becomes local when the user installs a copy of the database, which then uses the server via a timed or manually started mechanism (here replication called), the database on the server and the local copy brings the same state. The database platform in D4 is outstanding suitable for Companies where employees have common tasks to do and therefore use the same copies of the databases. The participants of the Internet usually do independent tasks and therefore their databases have different data structures. For this Reason are the ideas in D4 for the internet is not suitable.

Overall solutions described above have the following general disadvantage:
Every company has to install an Internet server, which is very complex in operation and can only be operated by qualified EDP specialists. There are also other costs (setting up the leased line, licenses for Internet servers, computers where only the Internet server has to be installed). Small companies and private individuals can not afford it.

In the D5 is a solution described where every user on the Internet with himself instead of the Internet server one Software (communication database) owns where all connections described to other Internet users in the form of transfer channels become. A transfer channel defines the destination table at the receiver and a source table at the sender. Furthermore, field pairs (source and target fields from corresponding tables) for the transfer channel. The table definitions are requested by the sender who be sent in the form of a table.

For each table, the for Data export or the data import is determined, must additionally an Field to be created where the time of last change of the data record is entered automatically. At every start of the Communication database will be the changed records The export tables are extracted and summarized in data packages. For the Extract will be the already mentioned Field for the time of the last change used. Therefore the definitions of the corresponding transfer channels are used, which are stored on his computer. The extracted data are referred to as destination packets through the Internet address Recipient be clearly identified. All destination packets are in a transmission packet summarized and sent to the transfer server. The transmission packet is reflected on the transfer server on appropriate destination packages divided up. Multiple destination packages for a receiver that come from other senders, are on the transfer server in one Download package summarized and so sent to the recipient. At the receiver becomes split the download package into update packages, the corresponding ones Tables of the recipient to update. For Updating becomes the key used in the definitions of the transfer channel.

• 1. Jeder Benutzer, um neue Importkanäle zu erstellen, muss die Datenstruktur bei allen potentiellen Sendern abrufen, was bei vielen Verbindungen zum beträchtlichen Zeitaufwand für den Benutzer führen wird.
• 2. Jeder Empfänger, der einen Transferkanal anlegen bzw. ändern will, kann die geänderte Datenstruktur bei dem Sender nicht abholen, falls sein Computer in diesem Moment abgeschaltet ist.
• 3. Jede Tabelle, die in der Kommunikationsdatenbank zu benutzen ist, muss ein spezielles Feld beinhalten, wohin der Zeitpunkt der letzen Datensatzänderung eingetragen wird. Diese Änderung muss in jeder Tabelle gemacht werden, sonst kann so eine Tabelle für die Kommunikation nicht verwendet werden. Dafür ist ein Eingriff in die Datenstruktur der bereits bestehenden Tabellen gemacht werden.
• 4. Wenn ein Benutzer im Internet seine Datenstruktur geändert hat, muss er diese Datenstruktur an alle vorhandene Sender und Empfänger verschicken, was das Internet unnötig belasten wird, und ist nur dann möglich, wenn der Empfänger momentan erreichbar ist.
• 5. In dem Prototyp werden die unstrukturierten Dateien überhaupt nicht behandelt.

This solution is taken as a prototype for the present patent application, which, however, has the following disadvantages:

• 1. Each user to create new import channels must retrieve the data structure from all potential senders, which will take a considerable amount of time on the user for many connections.
• 2. Any recipient who wants to create or change a transfer channel can not pick up the changed data structure at the sender if his computer is currently switched off.
• 3. Each table to be used in the communication database must contain a special field where the time of the last record change is entered. This change must be made in each table, otherwise a table can not be used for communication. For this an interference in the data structure of the already existing tables is to be made.
• 4. If a user has changed his data structure on the Internet, he must forward this data structure to everyone sending existing transmitters and receivers, which will burden the Internet unnecessarily, and is only possible if the receiver is currently available.
• 5. In the prototype, the unstructured files are not handled at all.

The mentioned Disadvantages of the prototype are overcome by the proposed solution.

Documents to the state of the art

• D1: WO 95 33236 A (Reisman Richard) December 7, 1995
• D2: WO 96 18952 A (ELCOM SYSTEMS INC). June 20, 1996
• D3: WO 96 41 275 A (E-SYSTEMS INC.) December 19, 1996
• D4: Lotus Notes Release 4.5: A Developer's Handbook. International Technical Support Organization.
• D5. PCT / DE 98/03284 (Dr. Schall) "Data Architecture and Data Transfer of structured information on the Internet "

Short explanations of the pictures

1 schematically shows the transfer of the structured information from the sender to the recipient, the client server ( 1 ) and via the browser ( 2 ) with the common transfer server ( 3 ) communicate. The data from the source tables ( 4 ) of the sender, which are stored in the user environment (own workstation and, if necessary, local area network), are stored with data records from corresponding export buffer tables ( 5 ) compared. This will determine the new, changed, and deleted records in the export buffer tables for which flags are set. Records from an export buffer table that are marked new, changed, or deleted form a data block called a data extract. Then the export buffer tables ( 5 ) updated by data from corresponding source tables. Data extracts from all export tables are processed by the data filter in the action component ( 70 ) and in an upload package ( 8th ), which is uploaded to the transfer server. The upload package is split on the transfer server to original data extracts. Each data extract is processed according to the transfer definitions ( 15 ) are attached to appropriate download packages that are created for each recipient. The download package, which may contain data extracts from various senders, is downloaded to the appropriate recipient. The download package is split at the receiver to the data blocks. Each data block is identified by the data filter in the action component ( 69 ) and then the import buffer tables ( 13 ) and finally the target tables ( 14 ) to update.

The imported data extracts are evaluated by the action component and, depending on the result of the evaluation, another program is started and / or the responsible employees ( 73 ), corresponding messages are sent via the intended medium.

2 shows the connections between system tables on the transfer server and on the client server.

3 shows the data flow when extracting from the source table (export table) of the user ( 4 ). It is checked for each record whether a record with the same key has already been created in the corresponding buffer. New records are sent to the corresponding buffer table ( 5 ) added. The list of buffer tables is from the system table ( 6 ) refer to. For each record of the export buffer table the following flags $$ new, $$ Change and $$ delete are created for new, changed and deleted records. For all records in the buffer, the $$ delete flag is set to true first. Then the flag $$ delete is set to false for all found and new records.

4 shows how the data extracts to the upload package ( 8th ), where the new data records are additionally filtered by the export filter.

5 shows how on the transfer server the data blocks (data extracts) from the upload package ( 8th ) by using the definitions of the transfer channels ( 9 ), User tables ( 10 ) and assignment of the source and target fields ( 11 ), to existing download packages ( 12 ) are added to appropriate recipients. The transfer channels ( 9 ), User table ( 10 ), Assignment of source and target fields ( 11 ) are on the 1 as transfer definitions ( 15 ) designated.

6 shows how the downloaded download package ( 12 ) is read in the client to the import buffer tables ( 13 ) whose list is in the system table ( 6 ) is defined. New records are added to the import buffer table and corresponding target table. The records with the flag $$ delete = true are removed from the import table and corresponding buffer table.

7 shows how the most recently updated and attached data in the import buffer table ( 13 ) the corresponding target table ( 14 ) on the computer or local network of the receiver. The list of target tables is from the system table ( 6 ) refer to. In the block ( 57 ), each record is checked for the data filter, which can be specified as a procedure or SQL statement. When updating ( 59 ) records are removed from the target table with the $$ delete = true flag.

8th shows how the most recently changed or new unstructured files from the export folders ( 65 ) of the transmitter in the translation module ( 67 ) are uploaded to the transfer server. For each uploaded file, an entry is made to the structured upload file ( 8th ), which is then uploaded to the transfer server (s. 1 ). On the transfer server, the recipient list is defined for each upload file. For this, the definitions of the unstructured transfer channels ( 68 ) used. The file can be translated into the specified language of the recipient, if provided and possible for the current data type. Before downloading, a corresponding entry is made to the structured download file ( 12 ) attached to the receiver (s. 1 ) is downloaded. At the receiver, each imported unstructured file in the action component is evaluated (eg, whether it is a new file or an existing file is being updated). Depending on which conditions are fulfilled, the action component can either start another program and / or the responsible employees ( 73 ) send appropriate messages via selected media. The imported files are saved in appropriate import folders or discarded (depending on the results of the evaluation).

2. Data transfer of the structured information about the Internet after the patent application

2.1 General presentation

Around Data about need to exchange the Internet according to the current state of the art both participants (sender and receiver) at perform various operations on each transaction. It means increased administrative costs for companies and for private Internet users unnecessary Loss of time.

In The proposed procedure will involve the exchange of data via a shared transfer server so organized that each participant last changed Data directly from own tables and common files from file folders to several recipients Automatically send and automatically receive from multiple stations can. Each participant can do their internal tasks completely autonomously Do that by providing necessary data early and automatically supplied to the internet. All registered on the transfer server Participants form so-called Internet-based Quasi Local Network (IQLN). The data transfer in an IQLN network always takes place via the Transfer server on the submitted texts translated into the language of the recipient become. The imported data is stored in designated database tables and file folders in the user environment of the recipient automatically stored and evaluated according to conditions specified by the customer, so that more user programs are started at the receiver and / or the employees receive corresponding multimedia messages. It clearly distinguish the project and work phases.

Project phase:

• 1. Each client transmits to the transfer server Data specifications of its data objects (database tables, file folders), the for the data export or data import are determined.
• 2. Each client assigns foreign export objects to its import objects to what's on the transfer server over the Browser is made. As a result, so-called transfer channels are formed

Work Phase:

• 1. Recent changes in export objects of the client are uploaded to the transfer server.
• 2. From the highly charged data will be on the transfer server Download packages for receiver educated. The recipients and their import objects to be updated using the transfer channels determined. When forming the download packages, the existing Texts translated into the language of the recipient.
• 3. When downloading the download package will be provided at the receiver Updated import objects.
• 4. The imported or updated data is evaluated at the receiver. As a result of the evaluation, the intended action (eg message send, start program, etc.) are executed automatically.

The proposed method has the following unique selling points:
The transfer server does not store any user data but only collects the specifications of the export and import objects (database tables and file folders) of all participants in the IQLN network, with which connections between data objects of the participants are defined.

One principle difference to all conventional communication technologies is still in the fact that not the transmitter, but the receiver sets determine what information is about him the Internet will be sent, which is the burden of the Internet Significantly reduce and the recipient of unwanted shipments protect becomes.

Everyone Participant can perfect his internal tasks for new technology Do it autonomously by providing necessary data early on and automatically powered from the Internet.

By Consistent dissemination of IQLN networks is emerging as a complement to the WORLD WIDE WEB A NEW WORLD WIDE DATA (Business Internet) That all for the Internet includes shared local data objects.

2.2 client server

At the start of the client server ( 1 ) are changed and new data from source tables (also called export tables) in the form of data packets ( 8th ) stored on your own hard disk (see paragraph 2.4). After that, the browser will automatically ( 2 ), which connects to the transfer server ( 3 ), where the data from other Internet users are imported to the client (see section 2.4). By using the definitions of the tables and transfer channels stored on the transfer server, new download packages (from the upload packages with data extracts) are created on the transfer server ( 12 ), which are downloaded to attractive recipients.

The download package is split into appropriate blocks of data at the client server to first retrieve the data in the import buffer tables ( 13 ) and finally the target tables ( 14 ) to update.

In the table OWNERTABLES ( 6 ) of the database of the client server are bound by the user from his user environment tables, which are determined for the data export or data import by setting the flags Export and Import to true or false in a list for each table. In the table OWNERTABLES ( 6 ) of the client server, the database system automatically stores only corresponding connection information for these tables.

Table 2.1 OWNERTABLES system table (6) for registering user tables

The user tables must contain one or more fields that together represent a unique key for records. The user tables use only numeric fields and text fields. Automatic transmission of image files and even large files over the Internet makes little sense, as they can be retrieved by the recipient at any time when they really need them. That's why these files are usually not sent. Instead, only URLs which are to be specified in a field of the table.

For each registered User table in the table 2.1 will also contain information about their Fields saved (see Table 2.2).

Table 2.2 OWNERFIELDS system table for user table fields

At the Start the client server and after the data export (see paragraph 2.3) the transfer server (Internet software) is called (see paragraph 2.2). Therefore The entries in the corresponding system table for system data entered.

Table 2.3 System Table SETTINGS for System Data

The Communication between the client server and the transfer server will by simple protocol-like Language handled. Therefore all system data (see tables 2.1, 2.2 and 2.3) are the user or the administrator in appropriate WWW page of the WEBAPP server. The transfer server is based on a database (see also section 2.3).

For each user table in the OWNERTABLES (see Table 1.1) that has the flag export = true, an export buffer table is created that is practically a copy of the source table, but in which the following additional fields are created:
$$ updatetime, where the time of the last modification of the record is saved;
$$ delete Flag set to true if the record does not exist in the source table;
$$ new Flag to set to true when the record is recreated;
$$ change Flag set to true if the data in the source table has changed since the last data transfer;
$$ key unique key in the buffer table, which is automatically incremented for each new record created;
$$ error Flag set to true if an error occurs while extracting the data from the source table.

For every user table in the table OWNERTABLES (see Table 1.1) with the flag import = true A copy of the target table is also created, where the additional ones mentioned above Fields are created. Furthermore is still a field $$ clientnr for Recording the client number used. The purpose of the buffer tables for export and import data is from the paragraphs See 2.4 and 2.6.

2.3 Transfer server

The transfer server is an Internet software that is developed on a database system and is operated by the WEBAPP server. Not only the data packets are stored temporarily on the transfer server, as in D5, but also the definitions of the user tables ( 6 ) and their fields ( 7 ) or the transfer channels for all users.

Everyone Internet subscribers are registered in the CLIENTS table.

Table 2.4 Most important fields of the system table CLIENTS

In the system table CLIENTTABLES (Table 2.5) are used for data transfer All approved user tables (see Tab. 1.1) registered on the Internet and in the system table CLIENTFIELDS (see Tab Fields saved (Table 2.6). The information will be at first Login of the client to the transfer server uploaded.

System table CLIENTTABLES Table 2.5

System table CLIENTFIELDS Table 2.6

• 1) Aus der Liste von seiner Tabellen wählt er die Zieltabelle.
• 2) Aus entsprechender Liste wird der Sender gewählt.
• 3) Aus der Liste der Tabellen des Senders, die für den Datenexport bestimmt sind, ist die Quellentabelle zu wählen. Dadurch wird der Transferkanal angelegt (Tabelle 2.7).
• 4) Für den gewählten Transferkanal ordnet der Benutzer in entsprechender ASP für jedes Feld der Empfängertabelle, das den Flag impotr=true hat, ein Feld aus der Quellentabelle mit gleichen type und size zu. Statt dessen kann er auch eine Konstante festlegen (s. Tabelle 2.8).

Based on the existing list of tables (see Table 2.5), each user or the administrator of the transfer server can define structured transfer channels between tables of the sender and recipient. For this purpose, corresponding ASPs (active server pages) are to be used on the transfer server, which each registered user can call. To create a new transfer channel, the user takes the following steps:

• 1) From the list of his tables he selects the destination table.
• 2) The station is selected from the corresponding list.
• 3) Select the source table from the list of sender tables that are to be exported. This creates the transfer channel (Table 2.7).
• 4) For the selected transfer channel, the user assigns a field from the source table with the same type and size for each field in the recipient table that has the flag impotr = true. Instead, he can also set a constant (see Table 2.8).

System table TRANSCANALS (9) Table 2.7

System table TRANSFIELDS (11) Table 2.8

In addition, on the transfer server system tables are kept (Table 2.9), which are of practical importance, but have little influence on the nature of the invention, so they are only briefly described in the following table (see also 2 ).

Additional system tables on the transfer server Table 2.9

The together the definitions of all tables and transfer channels on a transfer server, what in the prototype D5 is not provided facilitates much the creation of the transfer channels and gives the administrator of the system an overview of all export tables, transfer channels and clients the transfer server.

During installation of the transfer server, the following subdirectories are created in its installation directory:
the import directory for the upload of the upload packages ( 8th ) from the data transmitters where the last modified data is collected;
the directory for receiving the commands from the clients;
the directory where the data packets are stored with all commands to clients between;
the export directory where the download packages ( 12 ) are temporarily stored to the clients;
the directory where client table definitions are temporarily stored and retrieved from the transfer server.

• 1) Uploadpakete von den Datensendern aufzunehmen (Absatz 2.4).
• 2) Nach den Definitionen der Transferkanäle auf Grund der angekommenen Uploadpakete (8), die Downloadpakete (12) für die Empfänger zu erstellen, die in dem Exportverzeichnis des Transferservers temporär zu speichern sind (Absatz 2.5). In den Downloadpaketen werden strukturierte Daten (Tabellenextraakte) von mehreren Datensendern gesammelt. Wenn der entsprechende Empfänger bereits aktiv ist, wird ihm das Downloadpaket (12) sofort heruntergeladen.
• 3) Jedem Client des Benutzerkreises Importkanäle zu den potentiellen Datensendern aufbauen zu ermöglichen.
• 4) Bei den Clients ihre Datenstruktur anzufordern, die für Anlegen bzw. Korrektur der Transferkanäle benutzt werden.
• 5) Von den Clients Fehlermeldungen und Befehle aufzunehmen, bearbeiten und entsprechende Befehle zu den Clients zurückzuschicken.

The transfer server has the following important tasks and options:

• 1) to include upload packets from the data transmitters (paragraph 2.4).
• 2) According to the definitions of the transfer channels based on the uploaded upload packages ( 8th ), the download packages ( 12 ) for the recipients to be temporarily stored in the export directory of the transfer server (paragraph 2.5). The download packages collect structured data (spreadsheets) from multiple data senders. If the corresponding recipient is already active, the download package ( 12 ) downloaded immediately.
• 3) Allow each client of the user group to establish import channels to the potential data senders.
• 4) Ask the clients for their data structure, which will be used to create or correct the transfer channels.
• 5) Receive error messages and commands from the clients, edit them, and send commands back to the clients.

All download packages and the upload packages, which are destined for the transfer server to clients or are picked up by clients, get names according to the following pattern:
Package Name = Art & Client Num &"."& File extension
Where Art - is a combination of letters that designates the type of data packet (eg e- for export data (download packages) and i- for import data (upload packages);
Clientnumber - unique number of the client from the CLIENTS table;
File extension - file extension responsible for the transfer file (eg txt if the data packages are created in the form of text files).

functionality the transfer server and its collaboration with the clients in paragraphs 2.4, 2.5 and 2.6.

2.4 Export of the structured Information at the transmitter

The data export of the structured information is executed each time the client server is started. For each table in the system table OWNERTABLES, the corresponding buffer table for export data is updated with export = true ( 3 ).

Before the data export begins for the user table, the $$ delete field is set to true everywhere. Then the records ( 16 ) read the export table one by one. For each record, the key (also referred to as transkey) from the OWNERTABLES table ( 6 ), which is then searched for in the buffer table ( 17 and 18 ). If the key is in the export buffer table ( 5 ) is not found, the record from the source table ( 4 ) to the buffer table ( 5 ) ( 19 Otherwise, the record in the buffer table is updated by the record in the source table ( 20 ). In both cases, only the fields of the source table that have the flag export = true are used. It checks if the records in the source and in the buffer are the same ( 20 and 21 ). This is checked field by field. If all fields are the same, the records are the same. Similarly, the flags $$ change and $$ new are set ( 22 and 23 ). The new records are added to the buffer table only if they match the export conditions of the action component (see Chapter 4). For all found or newly created records in the buffer table, the $$ delete flag is set to false. The records in the buffer table, for which the flag $$ delete = true, are still treated as deleted. According to EOF ( 24 ), the next export table with the flag export = true from the table OWNERTABLES ( 6 ) or the export is terminated ( 27 ) if there are no export tables.

Of the Using the buffer table gives the possibility to simply use the user tables without changes which is not the case in the prototype D5, where every user table a field for Record the time of the last change. The Use of buffer tables triggers also the problem of deleted records in the Source table with the flag $$ delete = true in the buffer table are noted.

After updating the data in the buffer tables ( 5 ) their changed data (with flags $$ new = true and $$ change = true) is extracted and sent to the upload package ( 8th ) added. For this, only fields with the export = true ( 29 ) from the table OWNERFIELDS ( 7 ). The number of these fields (field count) and the number of changed records (record count) are also entered in the header of a data block. ( 30 ), which is created for an export table and consists of field names and corresponding lines that are sorted according to criteria ( 28 ) are filtered.

New records with the flag $$ new = true can only be sent to the upload package ( 8th ) are added ( 31 ), if they correspond to the export conditions of the action component (see section 4). When the data export from all export tables is finished ( 33 ), the browser is called ( 34 ), which starts the transfer server.

Normally, only changed records are always added because the criterion UpdateTime> loadexport in the ( 28 ) only has an effect if the time is forcibly reset. This also allows old data to be reset, which can be described as an additional backup option. In addition to the field names, three fields ($$ delete, $$ updatetime and $$ key) are provided in the upload package. The current time is entered in the field $$ updatetime. This package will consist of several data blocks, where each block contains extracted data (data extracts) from a source table. A data block consists of:
Details for table: clientnr, tabnr, fieldscount, recordcount;
Name of the table fields with the flag export = true;
Records from the export buffer table (number = recordcount).

The value tabnr is taken from the table OWNERTABLES ( 6 ) and the field definitions from the table OWNERFIELDS ( 7 ). In the upload package ( 8th ) records with the flag $$ delete = true taken at the receiver for deleting corresponding records in the import tables. After successful data export in the system table OWNERTABLES for tables for which the data export has taken place, the current time is entered in the field lastexport. All error messages that may occur during the data export are recorded by the protocol software and entered in a data package for error messages. Each error message is analyzed by the protocol software and, if necessary, a command is sent to the transfer server.

2.5. Distribution of structured data on the transfer server

After the client logs in to the transfer server, the download package ( 12 ) downloaded to the client, which may have the following parts:
Import data that has a unique file name for each client;
Commands to the client (eg to send table definitions);
changed entries for user table (eg flag export, import, exportfilter,
import filter u. Ä., Which are entered by the browser by the administrator or user and are intended for the client server.

Afterwards, the transfer server will upload the upload package ( 8th ), which may have the following parts:
Export data as described above;
Error messages generated by the client;
Commands to the transfer server;
new table definitions that are automatically generated on some error messages.

Each upload package ( 8th ) with the data of the receiver is uploaded by the transfer server, on blocks ( 35 ) divided and read. Each block contains data from an export table (see section 2.4). The user table is always uniquely identified by sendernr and sourcetabnr, which are entered in the header of the data block. After these numbers, the information for this table is found in the system table CLIENTTABLES (see Table 2.5). Each transfer channel according to the patent application is uniquely defined by Senderern, Sourcetabnr, Recipientnr and Targettabnr (see Table 2.7). In the table TRANSCANALS ( 9 ) export channels with sender and sourcetabnr are sorted out ( 36 ). This defines the recipient list for the current table. The sourcetabnr and sousretabnr are opposite the Recipientnr and Targettabnr ( 37 ).

For each recipient, a download package ( 12 ), which has the same data structure as the upload package ( 8th ) (see section 2.4). The download package gets a specific name, where the client number of the recipient (recipientnr) is also included (see section 2.4). The download package ( 12 ) is stored in the export directory of the transfer server. If the download package for the current recipient has already been created ( 38 . 39 ), the data is sent to the download package ( 12 ) just added. From the table TRANSFIELDS ( 11 ) (see table 2.8), the target fields (also known as import fields) are imported ( 40 ). The number of these fields is entered as field count in the header of the data block.

In the read-in data block, the sourcetab of the source table and targettabnr of the destination table is entered ( 41 ). The value of the senders remains unchanged. The field names for the download package are taken directly from table 2.8 (field targetfield) and the data from the corresponding data block ( 8th ) filtered out. The field $ updatetime of the upload package is used to filter out the records with $ updatime <lasttransfer. The value lasttransfer is taken from the table TRANSCANALS (see Table 10) for the current table and is overwritten by a new value (current time) after a successful data transfer. The number of filtered records is entered in the header of the data block as recordcount ( 41 ). The text in text fields may be translated to the language of the recipient if the translation is scheduled on the transfer server (transfer server option in the Translation field in the CLIENTS table). If the translation is on the transfer server, the fields Language in Table CLIENTS of the sender and the recipient are compared. The translation is carried out by a special translation program.

The filtered and translated data is sent to the download package ( 12 ) and if the corresponding recipient is still logged in, it is immediately downloaded to him, so his client server will immediately import this package (Section 2.5). All error messages that occur with the transfer server are entered in the corresponding table for error messages. Each error message is analyzed and, if necessary, a command is sent to the corresponding client (eg data structure request the tables). Various commands (Table 2.10) can be sent to the client by clicking on corresponding menus or buttons in the form.

Possible commands to client Table 2.10

The sent commands are checked by the client server. Possible error messages will be immediately in the corresponding ASP to see.

When all upload data has been read ( 42 ), the transfer server will wait for the data entry ( 43 ).

2.6 Import of structured Information at the receiver

When the client logs in, the download package intended for him ( 12 downloaded). Each download package consists of data blocks that can come from different senders. Each data block contains data from a sender table (source table) sent to the sender since the last data export.

The data from the download package ( 12 ) Unlike the prototype D5, the corresponding import buffer tables ( 13 ) To update. After the entered tabnr ( 44 ), the table name (tablename) of the import table is determined in the table OWNERTABLES (see Table 2.1). The actual name of the import table can be z. For example, they can be assembled from the table name with the prefix "imp_".

First, the field names of the destination table are read in ( 45 ). Thereafter, for each line of the data block, after the key ( 46 ) in the import buffer table ( 47 ). If for the destination table ( 13 ) the "Shared Update" mode (clientdataset) in Table 2.1, is set to true, the key is passed through the field keyfields of the table OWNERTABLES ( 6 ) Are defined. In addition, the client number is still used if clientdataset is set to true. If the shared update (clientdataset = false) of the records is provided, only the keyfields will define the key. Depending on the search result ( 48 . 49 . 50 ), the flags $$ change and $$ new in the buffer table ( 13 ) set. New records are added to the table with flag $$ new = true, but if the import conditions of the action component (see Chapter 4) are not violated. This preserves data integrity. When inserting new records or updating existing records, the text boxes are translated to the default language (Table 2.3), but if the translation is set to true and the default language is not the same as the language specified in the download package. If in the download package ( 12 ) the texts are in English and the field English (Table 2.3) is set to true, the English text will not be translated.

From the import buffer table ( 14 ) all records are read, the flags $$ change = true, $$ new = true and $$ delete = true, as well as records with $$ Updatetime> lastimport ( 54 ). Each time the key is determined ( 54 . 55 ), which may consist of several fields defined in the keyfields of the OWNERTABLES table. If the key in the destination table ( 14 ) is not found, this record is sent to the target table ( 14 ) if the import filter criterion is met ( 56 . 57 . 60 ).

For the found record ( 56 ) the record from the buffer table will update the corresponding record in the target table if $$ change = true. When all records are read from the import buffer ( 61 ), the next import buffer table is fetched ( 63 ) or the data import is terminated ( 64 ).

3. Transfer of the unstructured Files according to the invention

Around the file transfer for To realize the unstructured files will be in the database of the client server created the FILEORDNERS table, the following Structure has (see Table 3.1)

Table 3.1 Data structure of the FILEORDNERS table

During the project phase, each client uploads the list of all export and import directories to the transfer server, which are stored in the transfer server's FILEORDNERS table. This table has the same data structure as described in Table 3.1. In the table FILEORDNERS of the transfer server, all export and import directories are collated by all clients.

In In the project phase every client can export their export directories via the Browser in the FILEPERMIS table (see Table 2.9) which client may download the files which not. The However, only the client can list the import directories view who created this list.

Everyone Client allows to its import directories so-called unstructured transfer channels create (Table 3.2), which is also about the browser is made. Therefore must be the recipient select a station from the list of potential stations. After that becomes the recipient the selection of export directories of the selected station is shown, for which he owns the reading concept. The chosen one Export directory is assigned an import directory of the recipient. It can also ImportDateifilter z. For example, for the file type, by importing only files of a certain data type.

Table 3.2 Data structure of the FILETRANS table

After creating the upload package ( 8th ) for the export tables also the unstructured files are prepared for export. For this it is in the export directories ( 65 ) after the last modified or new files ( 66 ) by comparing the value in the Load transfer field in the SETTINGS table (see Table 2.3) with the time the file was last changed. In the action component (see chapter 4) each file is checked for export conditions. If the exported file is to be uploaded, a line will be added to the upload package with the following parameters: Senderr; "UPLOAD"; folder name; file path; UPDADATE; UPDATIME If all the filtered unstructured files are uploaded, the upload package ( 8th ) to upload. In the block ( 67 ) the recipient list is determined for each file. The unstructured transfer channels ( 68 ) used. The transfer server also checks if the uploaded file matches the target file type in the FILETRANS table.

Any file allowed to download can be specified in the specified language ( 67 ) of the recipient, if provided by the option in the table CLIENTS (field Server translation is set to "yes") on the transfer server. The translated file is saved in the transfer folder ( 69 ) are stored on the transfer server under a unique file name (Temp File Name field in Tab. 3.3). In the FILEDOWNLOAD table ( 74 ) (Table 3.3), the corresponding entry is made. The renamed file is immediately downloaded to the recipient if auto download is set to true in the CLIENTS table, otherwise this file will be downloaded the first time the recipient is contacted. If the file is to the If the recipient is successfully downloaded, an appropriate response is sent to the transfer server, which has the following parameters: Recipient no; Tempdateiname; download; true. The corresponding entry in the FILEDOWNLOAD ( 74 ) is removed. Even the file with tempfilename will only be deleted if this name no longer exists in the FILEDOWNLOAD table.

Table 3.3 Structure of the FILEDOWNLOAD table

each The downloaded file is saved by the action component (see chapters 4) of the receiver checked for import conditions. Any undelivered file will immediately be in the appropriate destination folder save. If not possible is z. B., because currently there is no network connection or for this File no destination folder has been specified or is not found This file is temporarily stored in the NotAcceptFiles folder. Any such File is temporarily registered in the NOTACCEPTFILES table (Table 3.4).

Table 3.4 Data structure of the NOTACCEPTFILES table

at every data transfer it tries to find the files in the table NOTACCEPTFILES in the destination folder. The entries for the transferred Files are deleted. For the Files due to wrong folder or missing connection not transferred are, corresponding error messages are generated. List of files, which can not have a destination folder be viewed by the administrator in a form to the destination folder enter.

4. Action component of the client server

By proposed technology can stationary Connections (transfer channels) be created to many suppliers, providers, partners, the many useful ones Provide information. This information arrives automatically and appears in corresponding import tables saved. Approximately according to the same principle, the unstructured files are also transferred.

at the export of the structured data as well as the unstructured ones Files can Filter conditions are specified to the number of exported records or unstructured files or unwanted information not release what also reduce the burden of the Internet becomes. From other side the receiver does not always want all imported Data extracts as well as not all imported unstructured Save files with you. In this case, import filter is for structured or unstructured information. It will also be one there is a need for practical use, the texts in the fields of the download package or in the unstructured files in the language of the recipient to translate.

All the above-mentioned operations are included in the action component ( 70 ) of the client server. If the action component has no code (that is, is empty), the import tables or import folders are updated in the simplest way without performing any actions. However, in practice, there will usually be a need to use any filters, translate texts, evaluate imported data, and perform appropriate actions after data import.

• 1. Modul für Filterfunktionen die einfachen SQL-Ausdrücke (Exportfilters, Importfilters in der Tabelle OWNERTABLES) auf jeden exportierten bzw. importierten Datensatz anwenden.
• 2. Modul für Funktionen, die unstrukturierte Dateien beim Export bzw. Import aussortieren, indem bzw. Exportdateifilters und Importdateifilters aus der Tabelle FILEORDNERS benutzt werden.
• 3. Modul für zusätzliche Filterfunktionen, die bei dem Exportieren aus den Tabellen bzw. beim Import in Tabellen eingesetzt werden (SupplementaryFilterExportTable, SupplementaryFilterImportTable). Diese Funktionen können mit komplexem Code belegt werden, die auch andere benutzerdefinierte Funktionen und Prozeduren aufrufen dürfen.
• 4. Modul für zusätzliche Filterfunktionen, die bei dem Exportieren bzw. bei dem Importieren der unstrukturierten Dateien eingesetzt werden (SupplementaryFilterExportOrdner, SupplementaryFilterImportOrdner). Diese Funktionen können mit komplexem Code belegt werden, die auch andere benutzerdefinierte Funktionen und Prozeduren aufrufen dürfen.
• 5. Modul für Ereignisfunktionen, die bei dem Exportieren aus den Tabellen eingesetzt werden. Standardfunktionen: BeforeExportFirstTable, BeforeExportTable; AfterExportTable; AfterExportAllTables. Diese Funktionen können mit komplexem Code belegt werden, die auch andere benutzerdefinierte Funktionen und Prozeduren aufrufen dürfen.
• 6. Modul für die Ereignisfunktionen, die bei dem Exportieren der Dateien aus den Exportverzeichnissen einzusetzen sind. Standardfunktionen: BeforeExportFirstOrdner; BeforeExportOrdner; AfterExportOrdner; AfterExportAllOrdners
• 7. Modul für die Ereignisfunktionen, die bei dem Importieren in die Importtabellen einzusetzen sind. Standardfunktionen: BeforeImportFirsttable; BeforeImportTable; AfterImportTable; AfterImportAllTables.
• 8. Modul für die Ereignisfunktionen, die beim Importieren der unstrukturierten Dateien einzusetzen sind. Standardfunktionen: BeforeImportFirstOrdner; BeforeImportOrdner; AfterImportOrdner; AfterImportAllOrdners.
• 9. Modul für die Übersetzung der Texte in den Textfeldern der importierten Datenextrakten so wie in den importierten Dateien.
• 10. Modul für Auswertung der importierten Daten und Dateien (s. weiter unter)

The action component is a buildable component that should at least consist of the following modules:

• 1. Module for filter functions that apply simple SQL expressions (export filters, import filters in table OWNERTABLES) to each exported or imported data set.
• 2. Module for functions that sort out unstructured files during export or import by using export file filters and import file filters from the FILEORDNERS table.
• 3. Module for additional filter functions, which when exporting from the tables or when importing to Ta (SupplementaryFilterExportTable, SupplementaryFilterImportTable). These functions can be assigned complex code, which may also call other user-defined functions and procedures.
• 4. Module for additional filter functions that are used when exporting or importing the unstructured files (SupplementaryFilterExportfolder, SupplementaryFilterImportfolder). These functions can be assigned complex code, which may also call other user-defined functions and procedures.
• 5. Module for event functions that are used when exporting from the tables. Standard functions: BeforeExportFirstTable, BeforeExportTable; After Export Table; AfterExportAllTables. These functions can be assigned complex code, which may also call other user-defined functions and procedures.
• 6. Module for the event functions to be used when exporting the files from the export directories. Standard functions: BeforeExportFirstfolder; Before export folder; After export folder; AfterExportAllOrdners
• 7. Module for the event functions to be used when importing into the import tables. Standard functions: BeforeImportFirsttable; Before Import Table; After Import Table; AfterImportAllTables.
• 8. Module for the event functions to be used when importing the unstructured files. Standard functions: BeforeImportFirstfolder; Before import folder; After Import folder; AfterImportAllOrdners.
• 9. Module for the translation of the texts in the text fields of the imported data extracts as well as in the imported files.
• 10. Module for evaluation of imported data and files (see below)

The Modules under numbers 1 and 2 contain simple functions that Automatically created by the client server after which the user has made corresponding entries in the special form. Manual changes in the generated code is not possible. Functions in all other modules may be complex Code included from where other custom modules called allowed to.

at The export or import of the structured information will be started by the Export filter and import filter in the OWNERTABLES table as the default filter used. These data filters are exclusively without programming in created a form. It can also additional SupplementaryFilter used in the appropriate functions where the code is to be entered manually.

For the unstructured Files will also be a standard filter import file filter from table FILEORDNERS used. It is z. B. for the search term in the searched for imported file. Depending on the search result, the file may be discarded or imported. It can also be very complex code from the field "artificial Intellect, which accurately evaluates the contents of the file.

• 1. Tabelle CLIENTUSERS, wo die Liste der Benutzer von dem Clientserver eingetragen wird, die Meldungen nach dem Import der Daten bekommen können. In dieser Tabelle werden übliche Angaben (Usernr, Name, Vorname, Standardmedium, Netzadresse, Email, Fax, Handy usw.) zu den Personen angegeben. Der private Anwender trägt in die Tabelle CLIENTUSERS sich selbst und eventuell auch seine Familienmitglieder ein.
• 2. Tabelle COMMANDS (Tab. 4.1), wo für die Importtabellen bzw. für die Ordner die Bedingungen für Meldungsausgaben bzw. Programmaufrufe festgelegt werden.
• 3. Tabelle PROTOCOLCOMMANDS (Tab. 4.2), wo die ausgeführten Befehle registriert werden

The import table in the company serves as a source of information for responsible employees. In addition, it will be possible to call another program if the corresponding condition is met. Therefore, it is important to inform the responsible employee about updating his tables. For this purpose, the following tables and forms are provided in the client server:

• 1. Table CLIENTUSERS, where the list of users is entered by the client server, which can receive messages after importing the data. In this table, usual information (user name, surname, first name, standard medium, network address, e-mail, fax, mobile phone, etc.) is given to the persons. The private user enters into the table CLIENTUSERS himself and possibly also his family members.
• 2. COMMANDS table (Table 4.1), where the conditions for message output or program calls are specified for the import tables or for the folders.
• 3. Table PROTOCOLCOMMANDS (Tab. 4.2), where the executed commands are registered

Table 4.1 COMMANDS table

Table 4.2 Table PROTOCOLCOMMANDS

Each time after updating the import table or folder, the action component ( 70 ) For each object (table, folder) the condition is checked in COMMANDS. If the condition is true, a message is generated for the user. If the corresponding message system is installed, this message is sent to the user ( 73 ) if the following time condition is correct:
Currently> load time + min time interval,
where is the current time;
Last time is the time of the last shipment to this employee;
MinTime Interval is the minimum allowed time interval between two subsequent transmissions for the Mitar -workers.

If this time condition is not met is, this message is first reset until this time condition will be true. It protects the users from being sent too often Messages. The generated messages are from a special shipping program to the recipients cleverly.

All sent or postponed messages stored in PROTOCOLCOMMANDS, so that every time you understand can whom and when the messages have been sent.

Of the Use of the action component can be practical for all companies as well as private People be useful. The messages can transmitted in any way become. It can z. B. texts or voice units over the computer network become. This will become the employee or the private user not forced to constantly check if the expected messages have come or not.

If no messaging system is installed, all messages are generated in a report to the client administrator.

Instead of to send a message, can automatically program provided be called.

5. Examples of possible applications the invention

5.1 Business Internet

One Transfer servers with all its clients are internet based Quasi Local Network (IQLN). For each participant (client) is the Client server installed, which is freely available on the Internet and therefore, the client server can download from a WWW page getting charged. The operators of the transfer server collect from the registered clients corresponding fees for the use of the transfer service. Because any Internet user can purchase the client server for free, it will lead to faster diffusion of the new technology. It will be shorter Time numerous IQLN networks arise.

Indeed Each client can also join multiple transfer servers at whose he has appropriate permission to log in as a client and to the same Act kind. Therefore the client has to sign up for each selected transfer server. It can the client servers have very different tables involved become.

By Registration with various transfer servers will be the barriers overcome between individual transfer servers. All transfer servers are registered separately in a central table TRANSFER LIST be that for every user to look over accessible to the browser have to be. From this list, every Internet user can use the find suitable transfer servers and register with him to let. He receives a message from the server administrator he is admitted as a client or not. As a result of the spread the IQLN networks and by the way if multiple transfer servers log in as a client that will Business Internet emerge.

The Table TRANSFER LIST must have the following main fields: Country; IP the transfer server; Clientele of the transfer server; Purpose of the Transfer server. This table must be accessible to every Internet user. When the WWW page of Business Internet is called, first the List of countries displayed, for the at least one transfer server has been registered. When clicking on a Landes, the list of transfer servers appears with the links the transfer servers. The list can be z. B. from two fields clientele and Purpose of the transfer server exist. By clicking on this link appears the start page of the transfer server, in which the password and log name. New client can refer to the transfer server as Guest log in by usual Enter details (company, name, first name, desired password, etc.). Of the Guest is in a table for Guests registered, which is checked by the administrator of the transfer server and the guest can then be registered as a client in the CLIENTS table become. It will be first no fees asked. Only after the specified time (year, quarter, month) will be the client on the browser sent a warning about the payment of fees. If the fee is not paid to this deadline, the data transfer for this Client locked.

All clients logged in to a transfer server have a unique name within the transfer server that is specified by the user (for example, company name). The export tables included in the Client servers also have a unique table name within the client server. Each export table must have a key field as well as one to uniquely identify the records within the table. All folders from the user environment (eg local area network), which are registered as export or import folders on the client server, also receive a unique name within the client server, which is assigned by the user. All files within a file folder are always unique. Each transfer server also has a unique URL on the Internet in the WEB.

The above-mentioned facts allow introduction especially for the business Internet of a new addressing scheme, according to which each record in the export table or each file in the export folder is uniquely identified worldwide. The address in Business Internet, also referred to as World Wide Data (WWD), is to be defined for a record as follows:
WWD address = URL transfer server / client name / table name / key value.

If the key consists of multiple fields, the key value is made up of individual values composed and indicated by the sign "|" separated.

The WWD address of a file in the export folder is specified as follows:
WWD address = URL transfer server / client name / folder name / file name.

By the proposed identification of the data objects (data records in export tables and files in the export folders) in the Business Internet can be z. B. in each advertisement or on the shelves of the department stores the WWD address of the record which contains the most important information for this product.

By The WWD address can be used to quickly create an import channel for the specified Create data record. Therefore the client gives the WWD address in the start form of the client server one. If the address is valid is, the transfer server is started displaying a list of import channels, in the corresponding export table as a data source for the current Client is used. Anyway, the client can import new channel form with this export table, where automatically a data filter submitted, the only specified in the WWD address record for the Data export releases. The client can do the mapping in the browser specify the fields of the export table and the selected import tables as in the client server necessary action conditions (eg condition for message and the text of the message). After that is regularly the elected Import table through the specified record in the export table updated by the sender with any notification of the client. Below are some important examples described by the Business Internet are to be realized.

5.2. Reduction of typing work in the office

Practically Every company produces structured documents (invoices, delivery notes, Material certificates, offers, etc.). There are usually different ones Database systems used to store the data in tables. Z. For example, an invoice usually has the header and bill items. In the header area are the general data of the sender and Recipient specified (bank account number, bank code, etc.). In the area for the invoice items usually the purchase items are entered (for example, product name, Unit price, number of purchases, purchase sum, etc.), so for each purchased If there is one line in the corresponding table of the database. The invoice will be printed out and sent to the appropriate recipient Mail or fax sent.

Of the receiver should be after conventional Procedure to capture the input documents in its database to to continue using them in appropriate applications. Not all Companies capture the incoming documents because it is laborious and personnel costs caused. By using the invention, the company can solve this problem economical to solve.

Around the possibilities of the proposed method will be the following example discussed. Of the receiver wants to have BILLS and INVOICING POSITIONS in its own tables (see table 5.2) corresponding data from the same table of the sender (s. Table 5.1). To realize it, must the transmitter and receiver register with a transfer server where they are in the client list and assigns each user name and password.

Information on the transmitter tables Table 5.1

Information on the tables of the beneficiary Table 5.2

The sender and receiver selects database tables in his PC or in the local network and integrates them in the database of the client server. Then it starts a special procedure that creates a list of included tables and places them in the OWNERTABLES ( 6 ). This list is displayed in a form where you can enter the status (export or import table) for each table. For this the flags export and import are provided. Each table can be both import and export. In addition, the field names in the table OWNERFIELDS ( 7 ).

Each time the client server starts up, the list of included tables (see Table 1.1) will be corrected if there are any changes in the data structure. In the latter case, the client server creates two subpackages, where the table list (see Table 2.1) and all data fields of all tables (see Table 2.2) are copied accordingly. These subpackages are uploaded as an upload package to the transfer server where the tables CLIENTTABLES, CLIENTFIELDS are updated (see also 2 ). The tables TRANSCANALS and TRANSFIELDS must match the corrected data, which is checked by the transfer server. All invalid transfer channels with non-existent tables, such as field pairs, in which one or both fields are of unknown origin, are automatically deleted by the transfer server and a message is entered in the system table for the affected user, which he can view in the browser.

In our case, the receiver can first create two transfer channels between tables of the same name (INVOICES and INVOICE POSITIONS). Two transfer channels are created (INVOICES - INVOICES and INVOICE POSITIONS - INVOICE POSITIONS), which will be referred to as INVOICES and INVOICE POSITIONS. The data sender is a customer for recipients to which a customer number is assigned in the CUSTOMERS table. This customer number must be specified in the field soursevalue (see table 2.8) as a constant for transfer channel INVOICES. In the transfer channel for INVOICE POSITIONS fields of the same name can be merged.

In The INVOICE POSITIONS table becomes the abstract article number stored at the receiver is useless. Instead, the recipient needs the article name.

• 1) Für nicht kompatibles Datenbanksystem muss eine Programmroutine geschrieben werden, die Daten aus der Benutzertabellen in kompatibles Datenformat (z. B. Textdatei) kopiert. Diese Operation ist praktisch für jedes existierendes Datenbanksystem möglich.
• 2) Die konvertierten Daten (Textdateien) in die Datenbank der Clientsoftware nach oben beschriebenem Prinzip als Benutzertabellen einzubinden.

If multiple database systems are used on the user's computer, some of which are incompatible with the client software database, then you should do the following:

• 1) For incompatible database system, a program routine must be written that copies data from the user tables into compatible data format (eg text file). This operation is possible for virtually any existing database system.
• 2) Include the converted data (text files) in the database of the client software according to the principle described above as user tables.

For each incompatible database system must have appropriate program routine to be written. Each time before starting the client server before the data transfer is executed will have to the mentioned Program routines for all incompatible database systems are started. Then be the stored copies (text files) by data from user data overwrite these database systems.

If all transfer channels over the If the browser is created, the user only has to intervals Click on the corresponding buttons on the Windows interface to see all tables bring up to date.

To updating the import tables will be sent to all relevant staff corresponding messages via sent the net.

5.3. Supply system and Information gathering about the Internet

in the Internet represent there are already many mail-order companies like Otto catalog, source and similar, the very big one Offer range of goods. The customer can get the goods today View on the Internet and order online by using the appropriate Filling in the form.

These Form of trade is convenient and to some extent attractive as the customer thereby save the journey. The private customer can, however, on the Internet look at the WWW pages of various department stores, prices and Compare the features of the goods you are looking for and then shop in the selected store or over to order the internet. But without shadows is this possibility not because the customer spend a lot of time on the computer and corresponding Telephone costs for Research on the Internet must pay. Even less attractive is this possibility for companies, usually very often different items, products, materials etc. at the suppliers research and order, since the companies still additional Labor costs for Need to carry online research.

Some transfer servers in the business Internet can unite customer groups (suppliers and customers of the production) from certain industry. Providers of production release the quotation tables as export tables by setting export = true for them (see Table 2.1). The potential customer, who is logged in to the same transfer server, creates transfer channels to several providers who supply the same production. There is also another possibility. A so-called Akkuclient is created, which collects data from all suppliers of production data in corresponding import tables. The ordinary client then has only to do with the Akkuclient. In any case, the client gets comparable information, which he can also automatically evaluate by filling the tables CLIENTUSERS and COMMANDS accordingly. According to this principle, all new and changed offers in the form of data records are automatically and regularly transferred to the collection table of the customers, so that the customer does not have to pay telephone fees for research with different suppliers. The images associated with the offers do not need to be downloaded to the client server. It is sufficient if a field is created in the import table or in the responsible form in which the Internet address of the image is to be entered. Clicking on the corresponding link displays the associated WWW page with this image in the browser. In terms of trade, it can be argued that the proposed principle can be described as new paperless and non-intrusive advertising. It is important that the offers for the recipient always in the desired language be displayed.

On Reason for the proposed procedure may be special business centers for corporate clients and private individuals are formed. In these centers will be the Akkuclient driven, in whose import tables offers of several Suppliers from an industry are collected. Then to these tables can the end user import channels build up. It spares the ordinary Clients the need to create transfer channels to several providers.

It can according to this principle regional, national and international business Centers are set up in whose qualified specialists from appropriate branch (not necessarily computer specialists!) Transfer channels between Include the import tables of the battery client and providers.

For each Offer that is shown in an advertising brochure or for each product very useful in the shopping mall will be the specification of the WWD addresses (see example above "Business Internet"), which is the client for comparable Can collect offers. Import channels are assigned to these WWD addresses import channels created to bring the comparable offers together. In the action component of the client server appropriate action conditions are entered so that competent staff z. B. receive messages or another program is started.

• 1) Der Anbieter bekommt neue billige Art von Werbung für seine Produktion (Shops, die nur für Clients des Transferservers bestimmt sind). Dadurch kann der Anbieter an anderen Werbungsarten (z. B. durch Verbreitung der Werbungsblätter) wesentlich sparen, was auch der Umwelt zugunsten kommen wird.
• 2) Der Anbieter bekommt ausführliche Informationen über Kundenwünsche, die der Kunde in Form der Importkanäle und des Importfilters (SQL-Ausdruckes) auf dem Transferserver hinterläßt. Diese Ausdrücke kann der Anbieter jederzeit auswerten (aber nicht ändern!).

For providers of information through new organization of advertising, the following advantages arise:

• 1) The provider gets new cheap way of advertising for its production (shops, which are intended only for clients of the transfer server). As a result, the provider can substantially save on other advertising types (eg by disseminating the advertising sheets), which will also benefit the environment.
• 2) The provider gets detailed information about customer requests, which leaves the customer in the form of import channels and the import filter (SQL expression) on the transfer server. The provider can evaluate these expressions at any time (but do not change them!).

• 1) Der Kunde bekommt regelmäßig Werbungsangebote von verschiedenen Anbietern ohne sich darüber Sorgen zu machen. Über besonders günstige Angebote kann er extra benachrichtigt werden (s. Abschnitt 2.7). Durch den Vergleich der Angebote bei verschiedenen Anbietern kann der Kunde günstiger einkaufen und dabei auch Reisekosten und Reisezeit etwas sparen.
• 2) Der Kunde braucht praktisch nichts für Online-Recherche zu zahlen und dafür viel weniger Zeit beim Computer zu verbringen, da über günstige Angebote wird er extra benachrichtigt.
• 3) Der Kunde bekommt ihre Daten in strukturierter Tabellenform, die in seinem System weiter benutzt werden können.

There are the following advantages for the customer:

• 1) The customer regularly receives advertising offers from different providers without worrying about it. He can be notified separately of special offers (see section 2.7). By comparing the offers at different providers, the customer can shop cheaper and also save travel expenses and travel time.
• 2) The customer does not need to pay anything for online research and spend much less time at the computer, as he is informed about favorable offers.
• 3) The customer gets their data in structured form, which can be used in his system.

Indeed for the Market economy, it will have a positive impact, since the competition harder between companies will be what finally lead to a reduction in purchase prices becomes.

5.4. Virtual directories for families and specialists

today in Germany there are about 38 million telephone lines. Practically in front of each phone lying by the way 2-3 directories, the be replaced after every six months. If it is believed that a pack of these directories With shipping costs more than 15 EUR, the relevant companies must (in the end, the end user) spend at least EUR 500 million per annum.

The Expenses for phone books can be drastically reduced if due to the patent application a transfer server is set up on which the table definitions from different address databases. It a special client (further referred to as accu client) is created which collects all the address data on a regular basis become.

Of the private users creates extra new user tables for recording the imported addresses are used. It also can do that already created user tables are used. These tables will be registered in the client server as import tables and their data specifications are transmitted to the transfer server. In the action component you can appropriate data filters are inserted and as desired various reports submitted. On the transfer server puts the Client transfer channels too the send tables of the battery.

The customer can see in his address tables in which the imported addresses are collected You can also manually create data records that are not overwritten when the new addresses are imported because the manually created data records do not have a key.

There the created telephone books updated regularly on the local machine It can save the professionals a lot of time looking for the directories today need to constantly to search the Internet for new customers, suppliers, etc.

There the created telephone books updated regularly on the local machine It can save the professionals a lot of time looking for the directories today need to constantly to search the Internet for new customers, suppliers, etc.

There The address data can be used very intensively in every company the time for companies drastically reduce the collection of addresses by themselves connect its address tables to the address databases through the transfer channels leave and appropriate import filters would install.

5.5. Shopping Guides for private Customers

The Business Internet can also help the end user with the search after cheap To afford goods. Therefore must be a special client (further called Akkuclient) log in to the appropriate transfer server. The battery terminal lays with himself for Each product has a table where the offers from different suppliers flow together would. It can z. Eg tables for Meat File, whole milk, low-fat milk, mineral water from certain Be source, etc. Each table will go through with appropriate shopping virtual transfer channels connected to the tables of the accu client.

The normal consumers next to the client server becomes so-called shopping guide offered free of charge, which is also a database program where appropriate Tables are created. At the first start of the shopping guide automatically tables are included in the client server.

If the project phase is completed, each successive Start the product offers downloaded, the corresponding tables to be updated at the purchasing advisor. Then calculated the shopping guide various shopping opportunities and shows a report with the following columns: shops and the purchase sum to be paid. In the list only shops displayed where all you want Goods guided become. For every business becomes priority assigned when sorting down) of the business list considered becomes. For elected business The customer can print out the shopping list. After the wish An electronic order of the selected goods can be sent.

By Using such a software, every family can be sure 5% of save the purchase sum, which is about 15-20 EUR per month becomes.

Of the Shopping guide is for cost the customer nothing. The customer only has to pay the annual fees for use pay the transfer server. The use of the transfer server is put corresponding pressure on the supplier prices, which is for the end user to be in favor.

5.6. Car of the future

cars More and more are being equipped with electronic devices. It is also necessary because people spend a lot of time in the car and the tendency is rising. And it is inevitable that with the time in all cars a computer is used, the motorist at the solution will help his problems.

In front a long tit and while the journey must be The driver can think about which hotel to stay in or where to stay park and refuel. While the ride must be Driver constantly listen to the traffic reports by radio to timely appropriate Making a decision when suddenly a traffic jam occurs on the way. However, the driver before driving z. B. by phone yourself inquire where the vacant rooms with reasonable rates are available free parking there and how big that Gasoline prices are. But it is awkward and rarely done. Therefore it is proposed to have appropriate information system Reason to develop the invention, the driver except Marschrute additional information will give in time.

Especially for motorists, a transfer server in the satellite must be used. First, so-called Akkuclient is logged in, the corresponding data from data transmitters in corresponding Importta bales accumulated.

On In addition, the autocomputer uses the client server for special car software Installed. The first time you start the autosoftware are in the client server appropriate tables created with the tables of the car software get connected. At every data transfer are in the driver z. For example, the following data is updated: Number of free rooms in hotels, Prices for overnight stay, prices for Gasoline, number of free parking spaces in public Garages, routes of the chosen Marschweges, where the traffic jams were created or dissolved. The driver gives before the trip for the car software, the destination of the trip, the place or the region, where to stay plans to park or park, how many miles he can drive without refueling. As a condition he can get the maximum accepted prices for accommodation, petrol, parking etc. enter. His computer gets the necessary information from the Akkuclient filtered by the entered conditions as described in section 2.7. Upon arrival the information that the driver considers important to the client server explained has, he is z. B. alerted by sound while driving. To avoid the jamming, the computer offers the driver change of the march path. For Hotels, gas stations or parking garages with low prices gets the Driver corresponding directions.

Further the navigation system can be consulted with the purchasing guide (see section 5.4). The driver gives on his home computer Before driving, enter the following information: which goods to buy on the way would like to and the desired one Time when he wants to be at the destination. The home computer created the shopping plan with consideration on travel expenses and gives the list of stores where to shop on the go. After the shopping plan, the target computer is defined by the car computer. requirement for Use of such software is the least nationwide distribution the proposed information technology.

5.7. Direct document exchange between clients

Everyone Client (company or private person) can have one or more directories for unstructured Create outgoing and incoming documents in their user environment, which would have unique WWD addresses worldwide (see example "Business Internet"). The directories for the Outgoing documents are called export directories and the input documents as import directories in the FILEORDNERS table in the client server created. When it comes to a company, you should also appropriate Subdirectories in export directories and import directories z. For example create the contact persons. For Each export directory is a list of clients created have the read right to the export directories. For that will be uses the tables FILEPERMIS in which these rights are set become.

Everyone potential recipient, who has received the read access from the sender can create import channels for himself. He can z. B. the permissible Enter file type so that only files of this type are transferred to the recipient become. In the corresponding input form it is entered which messages and to which staff are to spend when new files in imports the import directories or updates existing ones become. These messages can directly to the computer administrator or the responsible employees Messages are displayed on the screen. So depending on that what is provided in the table COMMANDS.

In You can also enter search terms on the action component checked and, depending on the result, corresponding actions automatically call. The action component can be replaced by new procedures and Functions supplemented be, z. B. analyze the contents of the files and depending on it call up intended actions. Furthermore, one can in the action component Program routines from the field "artificial Intellect "insert.

Advantages of direct Document exchange:

• 1. According to the invention, the receiver only needs Create the import channel once. After that, all documents are in the Export folder possibly with all subdirectories immediately in appropriate Import folder at the receiver saved, which will automatically receive appropriate message. In the Emaildienst need the attachments to email are manually copied to disk.
• 2. The input and receipt documents can strictly according to the folders in a clearer Form summarized and stored only once on the hard disk, which is the case of the Emaildienst it is not the case that all shipments or despatches of different Opponents in a poorly arranged list displays.

Claims (20)

The transfer of the data, which is available in a structured table form and in non-structured files in the local environment of the clients of a computer system and is exchanged between these clients, is characterized in that - the export data of the client changed from the given date directly from the user environment be uploaded to shared transfer server without assigning the recipient addresses; - the recipients for exported data are only assigned on the transfer server; - the recipient addresses, which are supplemented by specifying the recipient's data objects to be updated, are determined from the defined, logical links between export and import objects of the clients on the transfer server; - preparing for each recipient a data packet for download, which is composed of highly loaded data from multiple transmitters; - the download package is read by the recipient to automatically update intended import tables and folders in their own user environment; - Imported data in conjunction with other local data is evaluated at the receiver, so that actions are automatically executed. Transfer server according to claim 1, characterized that he has no database tables with user data, but instead only system tables with the list of logged in clients, definitions their export and import tables and export and import folders that for the Defining logical links between Export and import objects of the clients, as well as others Auxiliary tables, which are only for support the data transfer is necessary; all registered clients The transfer server form a quasi Local network, within which these clients exchange data with each other. The data exchange according to claim 1 is on the client side performed by the installed client server, by the following program components is characterized: Database component, the new and changed table extracts in the export tables and uploads to the transfer server as well as Down through import tables in the user environment of the client updated table extracts updated; File component that new and changed Files in the export folders are detected and uploaded to the transfer server loads like that like import folder updated by downloaded import files; intelligent Action component, the imported data according to specified criteria evaluates and carries out any actions envisaged. Database component of the client server according to claim 3, characterized in that in the project phase for each integrated user table ( 4 ), which is intended for data export or data import, for buffering the original data, a buffer table ( 5 ), in which all export or import fields of the user table are copied. Logical links between export and import tables or export and import folders according to claim 1, the business connections between clients are characterized by being only once in the project phase by the user directly on the transfer server specified and stored there. The data transfer of the structured information according to claim 1 is characterized in that the records from the export table overwrite the values are added in the same fields of the corresponding buffer table or to this buffer table, if such a key is not found, and every record in the export buffer table recorded as new, amended or unaltered; existing records in the export buffer table that were not overwritten are noted as deleted in this table; for each export buffer table ( 5 ) creates a temporary data block in the form of a table in which the names of the export table form columns and the data from the buffer table, which are noted as new, changed or deleted in the buffer table, form the records in the data block and there as well new, changed or deleted are noted; in the temporary data block, the current time of the update is entered in the corresponding field; Data blocks from all export tables in an upload package ( 8th ), in which the data blocks are identified by the sender number and table number of the source table; the upload package ( 8th ) at the next contact immediately uploaded to the transfer server and his Ko pie are deleted at the transmitter; the data blocks from the upload package ( 8th ) are read in by the transfer server one by one and assigned to corresponding recipients according to the definitions of the transfer channels by overwriting the table number of the source table to the table number of the destination table and replacing the field names of the export fields with corresponding import fields of the destination table; the records of the temporary data blocks that are noted as new, through the import filter of the target table ( 14 ) of the recipient; Data blocks intended for a receiver in a download package ( 12 ) and under a unique file name on the transfer server ( 3 ) are temporarily stored; the download packages ( 12 ) are identified by client number and downloaded to the appropriate recipients immediately or upon the next contact; after successful transmission the original download package ( 12 ) on the transfer server ( 3 ) is deleted; each data block in the download package updates import fields of the corresponding import buffer table ( 13 ) at the receiver so that each record is noted as being new, changed, unaltered or deleted; Records of the import buffer table ( 13 ) that are marked as changed or new overwrite the content in corresponding import fields of the target table ( 14 ) or attached to them; Records in the destination table ( 14 ), which have the same keys as the records in the import buffer table and are marked as deleted there, from the target table ( 14 ) are removed; after updating the data in the user tables ( 14 ) of the receiver starts on its computer corresponding program that evaluates the imported data and automatically starts another program or messages to appropriate employees ( 73 ) sends. The evaluation of the imported data according to claim 1 is characterized in that after updating the data in the import tables ( 14 ) or after saving the downloaded unstructured files the imported table extracts and unstructured files in the action component ( 70 ) and, depending on the results of the evaluation, another program is started and / or multimedia messages are sent to corresponding users of the client server ( 73 ). The data export according to claim 6 from the export table the sending, which is not a compatible data format with the database of the Client server, is characterized in that before the data export such user table of appropriate application on the machine of the data transmitter and stored under a specific name which is treated like all other user tables. Updating the data in the target table of the receiver according to claim 6, which is not a compatible data format with the client software has, is characterized in that it is first a copy of this target table It is necessary to upgrade through to a compatible data format converted the appropriate application, and then the updated Copy table in the original format, the destination table to be replaced. Transfer of the table data according to claim 6, in which unique keys and unique file names are to be used, characterized in that the definitions of the user tables and transfer channels ( 15 ), as well as the download packages ( 12 ) are additionally identified by a unique client number associated with each client of the transfer server. Transfer of the structured information according to claim 1, characterized in that in the temporary data block for the upload packet ( 8th ) also records data from export buffers table records that are noted as unmodified if the set time of the last data export is less than the record update date. Transfer of structured information according to claim 1 is characterized by having records that are new in the export buffer table are only included in the temporary data block if they are the condition of the set data filter for the export data fulfill. The updating of the import tables of the client according to claim 6 is characterized in that records from the data block of the download packet, which are noted as changed or not changed or deleted, update or delete corresponding records regardless of which data channels they are created; Records from the data block that are new or have not found a same key in the import buffer table are appended to the import buffer table, without any note of which data These records are created. Transfer channel according to claim 6, characterized that in their definitions instead of source fields assigned constants can be enter the corresponding field in all data records of the data block for recipients are. Transfer of the structured information according to claim 6 is characterized in that in the definitions of the transfer channel references to functions are entered instead of source fields that are executed at the receiver and return values in the corresponding field of the import buffer table ( 13 ). The import of the files according to claim 1, which is assigned to Client server are downloaded, but not there in the intended Import folder can be saved is characterized by that such files first in the folder for rejected imported files are stored, where they come from transfer the removal of the obstacle to the correct import folder are. Data transfer according to claim 1, characterized that the User registered as a client with multiple transfer servers and thereby exchanging data with their clients. The data import according to claim 1 is characterized that the Texts in the imported files as well as in the imported table extracts on its client server through a program in specified language translated by the recipient become. The data transfer according to claim 1 is characterized that the texts in the export files and exported data extracts in the language of the recipient be translated by a program on the transfer server. Summary of all transfer servers according to claim 2, which are installed on the Internet, form a new cyberbase WORLD WIDE DATA as a supplement to today's Internet, all export tables and export folders encompassed by all their clients, and characterized that every record in the export table just like every file in the export folder through the transfer server, client server, table name, or folder name and keys of the data set or the file in the export folder worldwide be identified.