RU80038U1 - AUTOMATED CITIZENS MIGRATION FLOW DATA STORAGE MANAGEMENT SYSTEM - Google Patents

Abstract

The utility model relates to computing, in particular, to an automated data warehouse management system for the migration flow of citizens.

The technical result is to increase the speed of the system by localizing the addresses of the requested data of citizens by identifiers of their initial letters of surname, name, patronymic.

The technical result is achieved by the fact that the system comprises a block for receiving input messages, a block for selecting base addresses of border checkpoints of citizens, a block for selecting intervals for recording and sampling data, a block for modifying addresses for recording data, a memory block, a block for selecting intervals for reconciling data, and a unit for presenting data for reconciliation , a block for selecting a reference address for reading a server database, a block for determining the boundaries of a sample of server database data, a block for generating read and write signals for a server database, a reception unit ma server database records, identity data identification unit. 10 ill.

Description

The utility model relates to computing, in particular, to an automated data warehouse management system for the migration flow of citizens.

The geopolitical situation that has changed recently has left its mark on the activities of border services in the post-Soviet space. As a result of the collapse of the USSR, the newly-formed states appeared borders with the so-called "near abroad", and the corresponding services - the task of controlling the movement of people and goods across these borders.

In addition, the fall of the Iron Curtain and the growing integration of the former Soviet republics into the world economy have dramatically increased the passenger-and-freight exchange with distant foreign countries.

As a result, the load on the border services, in particular, on the checkpoints (checkpoints) of airports, sea stations, railways and roads, has multiplied.

In this situation, hardware and software tools for automating border control are of particular importance, which would increase the throughput of the checkpoint and provide the personnel with the necessary information support.

Based on the tasks facing the border services and the conditions of their activity, software systems for automation of the checkpoint should satisfy a number of requirements, from which we can distinguish:

- functional completeness;

- high performance in the conditions of significant volumes of data and a large number of simultaneously working users;

- the ability to work with technical tools used to speed up registration;

- the ability to work both in stationary conditions and at mobile checkpoints;

- the ability to combine automation systems of individual checkpoints into a single, centralized system.

The problem of integrated accounting of the movement of citizens through checkpoints (checkpoints) of airports, sea stations, railways and highways has become especially urgent.

Known systems that could be used to solve the problem (1, 2).

The first of the known systems contains data reception and storage units connected to control and data processing units, search and selection units connected to data storage and display units, the synchronizing inputs of which are connected to the outputs of the control unit (1).

A significant drawback of this system is the impossibility of solving the problem of online updating of data stored in memory in the form of relevant documents in real time.

Another system is known, containing a telecommunication network of data processing units, the information inputs of which are connected to data and control units, and the outputs are connected to the first group of memory units, the central processor, the inputs of which are connected to the outputs of the memory units of the first group and data processing units, and the outputs are connected to the inputs of the memory blocks of the second group and data display units (2).

The last of the above technical solutions is closest to the described.

Its disadvantage is the low speed of the system, due to the fact that the procedure for updating the data collected from geographically distributed checkpoints on a telecommunications data network is implemented through the procedure for searching them over the entire volume of the system database, followed by processing updated data central

processor, which with large amounts of database system data inevitably leads to a large investment of time.

The purpose of the invention is to improve the system’s speed by localizing the addresses of the updated data of the migration flow of citizens in an integrated database of the data warehouse using the identifiers of the initial letters of the surname, name, patronymic of citizens.

This goal is achieved by the fact that in a known system containing an input messages receiving unit, an input messages receiving unit, the information and synchronizing inputs of which are the first information and synchronizing inputs of the system, while the information input of the input messages receiving unit is designed to receive messages from citizens at border checkpoints and the synchronizing input of the input message receiving unit is designed to receive the synchronizing signals of entering the input messages into the input receiving unit of messages, the memory unit, the address input of which is connected to the information output of the data recording address modification block, the memory control recording input is connected to the first synchronizing output of the data recording address modification block, and the information output of the memory block is connected to the information input of the data presentation unit for reconciliation, a unit for receiving records of a server database, the information input of which is the second information input of the system, designed to receive citizens' data from the server database system, a first clock input receiving unit records the second base is a synchronizing input data server system for receiving a system clock signal Server

for entering citizen data into the server database record receiving unit, the second synchronizing input of the server database recording receiving unit is the third system synchronizing input for receiving synchronizing data input signals from the expert workstation, a unit for generating read and write server database signals, the information output of which is the address output of the system designed to provide the write address and read data to the address input of the base server yes ny, one clock output of the server database read and write signal generation unit is the first system output, intended for issuing control signals to the input of the first database server interrupt channel, and the other clock output of the server database read and write signal generation unit is the second clock a system output intended for issuing control signals to the input of the second channel of the database server interrupt, a selection block for basic addresses of border checkpoints of citizens, the information input of which is connected to the first output of the input message receiving unit, the synchronizing input of the selection block of base addresses of border checkpoints of citizens is connected to the first synchronizing output of the block of reception of input messages, the information output of the selection block of base addresses of citizens of border crossing points is connected to the first information input of the data entry address modification block, and the synchronizing output of the base address selection block is citizens border checkpoint connected to the first synchronizing

the input of the data recording address modification block, the second synchronizing input of which is connected to the second synchronizing output of the input message receiving block, the recording and sampling interval selection unit, the information input of which is connected to the second information output of the input message receiving block, the counting input of the recording and sampling interval block the data is connected to the first synchronizing output of the block for modifying the data recording addresses, and the synchronizing input of the block for selecting the recording and sampling intervals connected to the second synchronizing output of the data recording address modification block, the information output of the recording and sampling interval selection unit is connected to the second information input of the data recording address modification block, the first synchronizing output of the recording and data sampling interval block is the control output of the system issuing signals to control the presentation of new records from the codogram of input messages, the second synchronizing output of the interval selection block data recording and sampling is connected to the data reading control input of the memory unit, and the third synchronizing output of the data recording and sampling interval selection unit is connected to the synchronizing input of the data presentation unit for reconciliation, the selection block of the reference reading address of the server database, the information input of which is connected to the first information the output of the data presentation unit for reconciliation, the synchronizing input of the selection block of the reference read address of the server database is connected to the third synchronizing mu output block selection intervals

recording and sampling data, while the first information output of the selection block of the reference address for reading the server database is connected to the information input of the block for generating the read and write signals of the server database, and the synchronizing output of the selection block of the reference address for reading the server database is connected to the first synchronizing input of the formation block read and write signals of the server database, a block for determining the boundaries of the selection of server database data, the information input of which is connected to the second the output of the selection block of the reference address for reading the server database, and the synchronizing input of the block for determining the boundaries of the sample data of the server database is connected to the synchronizing output of the block for the selection of the reference address for reading the server database, while one output of the block for determining the boundaries of the sample database server data is connected to the second the synchronizing input of the unit for generating signals for reading and writing the server database, and the other output of the unit for determining the boundaries of the selection of server database data by it is connected to the third synchronizing input of the server database read and write signal generation unit, the fourth synchronizing input of which is the control input of the system, the data verification interval selection unit, the information input of which is connected to the second information output of the input message receiving unit, the counting input of the data verification interval selection block connected to the control input of the system, one output of the block for selecting intervals of data reconciliation is connected to the third synchronizing input of the modif block katsii data write address and the other the output selection block

of data verification intervals is the first signal output of the system intended for issuing signals of the end of the data verification procedure, an identity data identification unit, one information input of which is connected to a second information output of the presentation data presentation unit for reconciliation, the other information input of the identity data identification unit is connected to the first information output unit for receiving records of the server database, the synchronizing input of the identity data identification unit is connected to the synchronizing output m of the unit for presenting data for reconciliation, the first output of the unit for identifying personality data is connected to the counting input of the unit for determining the boundaries of the sample data of the server database, and the second output of the unit for identifying data of the person is the second signal output of the system designed to provide a signal for presenting the data of verification to the workstation expert, while the third information output of the input message receiving unit is connected to the information input of the memory unit, the third information output of the unit is presented the occurrence of data for reconciliation is the first information output of the system intended for the issuance of citizens' received data to the expert's workstation, and the second information output of the server database records receiving unit is the second information output of the system intended for the output of server database data to the expert's workstation .

The invention is illustrated by drawings, where Fig. 1 is a structural diagram of a system, Fig. 2 is a structural diagram of a block for receiving input messages, Fig. 3 is a block diagram of a selection block of base addresses of border crossing points of citizens, Fig. 4 is a block diagram block selection intervals for recording and sampling data, Fig. 3 is a structural diagram of a block for modifying intervals for reconciling data, Fig. 6 is a block diagram for a block for selecting intervals for reconciling data, Fig. 7 is a block diagram for a block for selecting a reference address for reading bases s of server data, Fig. 8 is a structural diagram of a block for determining the boundaries of a sample of server database data, Fig. 9 is a structural diagram of a block for determining a boundary for sampling server database data, Fig. 10 is a block diagram of a block for generating read and write signals server data.

The system (Fig. 1) comprises a block 1 for receiving input messages, a block 2 for selecting base addresses of border checkpoints, a block 3 for selecting intervals for recording and sampling data, a block 4 for modifying the addresses for recording data, a block 5 for memory, a block 6 for selecting intervals for reconciling data, block 7 for presenting data for reconciliation, block 8 for selecting a reference address for reading the server database, block 9 for determining the boundaries of the sample data for the server database, block 10 for generating read and write signals for the server database, block 11 for receiving database records erver, block 12 of identification data of the person.

Figure 1 shows the first 21 and second 22 information inputs of the system, the first 24, second 25 and third 26 synchronizing inputs of the system, clocking 27 the input of the system, as well as the address output 30,

the first 31 and second 32 information outputs of the system, the first 33 and second 34 synchronizing outputs of the system, control 35 system output, the first 36 and second 37 signal outputs of the system.

Block 1 receiving input messages (figure 2) contains registers 40, 41, trigger 42, elements 43, 44 AND, element 45 OR, and element 46 delays. The drawing shows information 21 and clock 24 inputs, as well as the first 49, second 50 and third 51 information outputs, the first 52 and second 53 clock outputs.

Block 2 (figure 3) selection of base addresses of border checkpoints of citizens contains a permanent storage device 55, a decoder 56, a register 57, elements 58-60 And, elements 61, 62 delay. The drawing shows information 64 and synchronizing 65 inputs, as well as information 66 and synchronizing 67 outputs.

Block 3 (Fig. 4) of the selection of the recording and data sampling intervals comprises a reverse counter 70, a comparator 71, an OR element 72, delay elements 73, 74. The drawing shows information 75, counting 76 and synchronizing 77 inputs, as well as information 78, and the first 79, second 80 and third 81 synchronizing outputs.

Block 4 (FIG. 5) comprises an adder 82, OR elements 83, 84, delay elements 85-1 and 85-2. The drawing shows the first 86 and second 87 information inputs, the first 88, second 89 and third 90 clock inputs, as well as information 91 and first 92 and second 93 clock outputs.

Block 5 (Fig. 1) of memory is made in the form of random access memory having an address input 155, an information input 156, an input 157 for recording data, an input 158 for controlling data reading, and an information output 159.

Block 6 (Fig.6) selection of intervals for reconciling data contains a comparator 98, a counter 99 and a delay element 100. The drawing shows information 101 and counting 102 inputs, as well as outputs 103, 104.

Block 7 (figure 1) is made in the form of a register having information 105 and synchronizing 106 inputs, as well as first 107, second 108 and third 109 information outputs.

Block 8 (Fig.7) selection of the reference read address of the server database contains read only memory 110, decoder 111, elements 112-114 AND, elements 115-1 and 115-2 of the delay. The drawing shows information 116 and synchronizing 117 inputs, as well as the first 118 and second 119 information and synchronizing 120 outputs.

Block 9 (Fig. 8) for determining the boundaries of the sample data of the server database contains a register 121, a counter 122, a comparator 123, and a delay element 124. The drawing shows information 125, synchronizing 126 odd 127 inputs, as well as outputs 128, 129.

Block 10 (Fig.9) generating signals for reading and writing the server database contains a counter 130, elements 131-133 OR, elements 134, 135 delay. The drawing shows information 136 and synchronizing 137-140 inputs, as well as address 30 and the first 33 and second 34 synchronizing outputs.

Block 11 (FIG. 10) of receiving server database records contains a register 142, an OR element 143, a delay element 144. The drawing shows information 22 and synchronizing 25, 26 inputs, as well as information 145, 146 and synchronizing 147 outputs.

All nodes and elements of the system are made on standard potential-impulse elements. To simplify the drawing, the chains of the initial installation of nodes and blocks are not shown.

The system is based on the concept of two types of expert control: operational control of information coming from other databases as part of messages, and delayed control to identify people with a similar surname, name, middle name and / or date of birth. The first type of control is called the message preview, and the second - the search for doubles.

In the database structure of the system for identifying citizens, two keys are provided - primary (used for links between database tables) and alternative (for searching at the request of an expert).

The primary key consists of an attribute with a short calculated value, the formation algorithm of which ensures its uniqueness in time and over the entire set of the system database.

The alternate key is a person’s semantic key formed from four attributes: last name, first name, middle name (it may be absent), and date of birth. If the identification information about the candidate and the deputy is correctly entered into different databases, his semantic key in these databases will coincide, while the primary key will have different values.

Personal data of citizens in the database structure are separated from information about their movement through border control points, which helps to avoid duplication in cases where citizens had a partial change in personal data. Changes in personal data lead to the accumulation of records in the database, united in the concept of "history of information." The record key in the history of information is formed from the primary key of the person and the date of the first message in which the changed information was recorded.

To issue information about a citizen according to their state for the period of crossing the state border, records are selected from the history stack according to the criterion of proximity of the date of submission of information to the date of departure.

The system operates as follows.

The structure of the codogram of messages from border checkpoints of citizens is as follows:

the code the code the code the code ID of the border checkpoint that sent the input message The number of citizens whose data are contained in the input message Identification data of the identity of citizens; surname; name; patronymic; Date of Birth OTHER ATTRIBUTES OF INFORMATION ABOUT THIS CITIZEN

The entire codogram of the input message is received at the input of the system and recorded in the buffer memory of the system (not shown in the drawing), and the first record of the input codogram goes to the information input 21 of the system and then goes to the information inputs of registers 40 and 41 of block 1.

To enter the codes of the first record in the registers 40 and 41, a synchronizing pulse is supplied to the system input 24, which is fed to one of the inputs of the elements 43, 44 AND, the other inputs of which are controlled by the output potentials of the trigger 42. Given the fact that the trigger 42 of block 1 before starting work system was set to its original state, then the high potential from the inverted output of the trigger 42 element 43 And will be open, and the low potential from the direct output of the trigger 42 element 44 And will be closed.

As a result of this, the synchronizing pulse from input 24 passes element 43 And, and, firstly, it directly goes to the synchronizing input of register 40, entering in it the identifier code of the border checkpoint of citizens who sent the input message, and the code of the number of citizens whose data are contained in this post.

Secondly, the synchronizing pulse from the output of the AND element 43 passes through the OR element 45, and enters the synchronization input of the register 41, entering into it the identity data of the first citizen and all other attributes of the transmitted information.

Thirdly, the synchronizing pulse from the output of element 43 AND is delayed by element 46 for the duration of entering the codes of the input message into registers 40, 41, and then it is issued both to the single input of trigger 42, setting it to a single state, and to the output 52 of block 1.

Turning to a single state, the trigger 42 low potential from the inverse output closes the element 43 And high potential from the direct output opens the element 44 And, preparing another circuit for the passage of the next synchronizing pulse from input 24.

From the exit 49 of block 1, the code of the identifier of the border checkpoint of citizens who sent the input message is sent to the input 64 of block 2, from where it is fed to the input of the decoder 56, which decrypts the code of the identifier of the border pass of citizens and opens one of the elements 58-60 one element at a time And, corresponding to the identifier code.

At the same time, the synchronizing pulse from the output 52 of block 1 goes to the input 65 of block 2, where it passes through the corresponding element 58-60 AND to the input of the corresponding fixed memory cell ROM 55, which stores the base address of the memory zone allocated in block 5 to this border to the citizens checkpoint for documenting the data of the input message, and reads it to the information input of the register 57.

In parallel with this, the synchronizing pulse from the input 65 of block 2 is delayed by the element 61 for the duration of reading the base address from the ROM 55 and arrives at the synchronizing input of the register 57, entering the code of the base address, which from the output 66 of the block 2 through the input 86 of the block 4 is fed to one information input of adder 82 of block 4. To another information input 87 of adder 82 of block 4 is connected the output 78 of counter 70 of block 3, which is currently in the initial state, and therefore the input code will be zero at the information input 87 of block 4.

The synchronizing pulse from the output of element 61 of block 2 is delayed by element 62 for the time the code is entered in register 57, and then from the output 67 of block 2, through the first synchronizing input 88 of block 4 and element 83, OR is fed to the synchronizing input of adder 82, ensuring that the code is entered into adder 82 the base address of the border checkpoint of citizens, which from the output of 91 block 4 goes to the input 155 of the memory block 5.

In parallel with this process, the synchronizing pulse from input 88 passes through the OR element 84, is delayed by element 85-1 at the time of generating the code at the output 91 of block 4 and then from the output 92 of block 4 it enters the input 157 of the data recording control of the first citizen, which is output 51 unit 1 are fed to the information input 156 of unit 5, entering them into a memory cell with a given base address.

At the same time, the control pulse of recording the input data from the output 92 of block 4 goes to the counting input 76 of block 3, and then goes to the input of the counter 70, counting the number of records in block 5. This is the number of records of the counter 70, firstly, it is output 78 of block 3, and, secondly, it goes to one information input of the comparator 71, to the other information input 75 of which, from the output 50 of block 1, a code is given for the number of candidates whose information should be entered in memory block 5.

The same control pulse data recording from the input 76 of block 3 is delayed by the element 73 for the duration of the counter 70, and then fed to the synchronizing input of the comparator 71.

If the number of records of the counter 70 will be less than the number of citizens who are to be documented in block 5, then the output 79 of block 3 generates a signal that arrives at the control output 35 of the system as a signal for entering the next record of the input codegram in block 1.

According to this signal, the next record of the input codogram arriving at input 21 of block 1 is read out from the buffer memory of the system through input 21.

Data containing information about the next citizen will be entered only in register 41, since the synchronizing pulse from input 24 now passes through the element 44 AND, then the element 45 OR and then to the synchronizing input of the register 41, entering the input data into it.

At the same time, the pulse from the output of element 44 AND through the output 53 of block 1 enters the second synchronizing input 89 of block 4, where after passing the element 83 OR it enters the synchronizing input of the adder 82, providing the addition of the base number of the election address of the election commission to the counter 70 block 3, thereby forming the next address for recording the input data of the next citizen in block 5.

In parallel with this process, the synchronizing pulse from input 89 passes through the OR element 84, is delayed by the element 85-1 at the time of generating the code at the output 91 of block 4 and then from the output 92 of block 4 it goes to the input 157 for recording information about the next citizen, which from the output 51 blocks 1 are fed to the information input 156 of block 5, entering them into a memory cell with a given base address.

At the same time, the control pulse of recording the input data from the output 92 of block 4 is again fed to the counting input 76 of block 3, and then it is fed to the input of the counter 70, counting the number of records in block 5. This number of records of the counter 70 is again fed to one information input of the comparator 71, to another information input 75 of which, from the output 50 of block 1, a code is given for the number of citizens whose information should be entered in memory block 5.

The same data recording control pulse from input 76 of block 3 is delayed by element 73 for the duration of counter 70 operation, and then arrives at the synchronizing input of comparator 71. If the number of records in counter 70 will be less than the number of candidates to be documented in block 5, then output 79 of block 3, a signal is again generated, which arrives at the control output 35 of the system as a signal for recording in block 1 the next record of the input codogram.

According to this signal, the next record of the input codogram arriving at input 21 of block 1 is again read from the system’s buffer memory through input 21. This process will continue until the readings of counter 70 become equal to the number of citizens to be entered into the system’s memory. In this case, by the synchronizing signal from the output of the delay element 73, the comparator 71 generates a pulse at its second output.

From this output of the comparator 71, the pulse passes through the element 72 OR and is immediately output to the output 80 of block 3 as a signal for the end of the process of entering the input data into the memory block 5 and the beginning of the control of reading the received data for presentation to the reconciliation with data on citizens stored in the integrated system database.

Taking into account that at this point in time the output 91 of block 4 will be fixed to the address at which the last record of input data was made, then with the read pulse coming in to input 158, the data of the last record is read from the output 159 of block 5 and goes to the information input 105 of block 7 At the same time, the synchronizing pulse from the output of the OR element 72 of block 3 is delayed by the element 74 for the duration of reading data from block 5, and from the output 81 of block 3 is fed to the input 106 of block 7, bringing the read data from the memory block 5 into it.

The data structure at the outputs of block 7 will have the following form:

THE CODE THE CODE THE CODE Code combination formed by the initial letters of the SURNAME, NAME, NAME
citizen SURNAME, NAME, PATTERN, Date of birth of a citizen ATTRIBUTES OF OTHER CITIZEN INFORMATION Exit 107 Exit 108 Exit 109

From the output 107 of block 7, the code combination formed by the initial letters of the surname, name, patronymic of the citizen enters the information input 116 of block 8, and the synchronizing pulse from the output 81 of block 3 goes to the input 117 of block 8.

From input 116, the code combination of the initial letters of the Surname, First Name, Patronymic of the citizen enters the input of the decoder 111. The decoder 111 decodes the input code combination and opens one input of one of the elements 112-114 AND corresponding to the input identification attribute. Assume that such an element is element 112 I.

In parallel, the synchronizing pulse from the input 117 of block 8 is delayed by element 115-1 for the time the code is entered in block 8 and the decoder 111 is triggered, and given the fact that only 112 AND will be open at one input, then passing this AND element, first, the clock pulse is fed to the read input of a fixed memory cell of the permanent storage device 110, where the reference address of the memory zone of the database of the system is stored, in which all records about citizens with the same initial letters of the surname, name, ETS corresponding codeword initial letters of names, the first, middle of recording input overheads.

The code of the reference address of the memory zone of the database of the system is read to the information output 118 of block 8, and the code of the number of such records in the database of the system is read to the output 119 of block 8.

In this case, the code of the reference address of the database memory zone from the output 118 of the block 8 is fed to the information input 136 of the block 10, and the code of the number of records with the same code combination of the initial letters of the Last Name, First Name, Patronymic, and the date of birth of those in the database of the system, from the output 119 block 8 is fed to the information input 125 of block 9.

Next, the reference address code from the input 136 of block 10 is supplied to the information input of the counter 130, and the code of the number of records in the database from the input 125 of block 9 is sent to the information input of the register 121.

Secondly, the same read pulse from the output of the delay element 115-1 of the block 8 is delayed by the delay element 115-2 for the time of reading the contents of the fixed ROM cell and then from the output 120 of the block 8 it acts as a clock input 137 of the block 10, entering into the counter 130 the reference address code, and to the synchronizing input 126 of block 9, and then to the synchronizing input of the register 121, entering the code of the number of records into it.

In this case, the reference address code from the output of the counter 130 of block 10 is output to the output 30 of the system.

In addition, the same synchronizing pulse from the input 137 of block 10 passes through the OR element 132, is delayed by the element 134 while the reference address code is entered into the counter 130, and then through the first synchronizing output 33 of the system it enters the input of the first channel of the database server interrupt.

By this signal, the server goes to the subroutine for reading the contents of the database cell at the specified address, issuing it to the system information input 22 and entering the contents of the database cell into the register 142 of block 11 with a synchronizing pulse from the server to input 25 and through the OR element 143 to the synchronizing input register 142 block 11.

The identification part of the codogram of the read database record from the output 145 of the register 142 of the block 11 is fed to the input 150 of the comparator 12, to the other 149 input of which the identity data of the citizen from the output 108 of the block 7 is supplied.

At the same time, the synchronizing pulse from input 25 is delayed by the element 144 for the time of recording the read record of the identity information of the candidate in the register 142, goes to the synchronizing input 151 of the comparator 12, comparing the input values of the identity of the person in block 7 with the identity of the citizen coming from system database.

If a comparison of the input codes has not occurred, then the comparator 12 at the output 152 generates a synchronization signal, which through the input 127 of block 9 is fed to the counting input of the counter 122, fixing the fact of viewing the first record of the identity data from the number of records stored in the system database.

The output code of the counter 122 goes to one input of the comparator 123, to the other information of which from the output of the register 121 a code of the number of records of identification data of the person with a given combination of the initial letters of the last name, first name, middle name stored in the database of the system is supplied.

In parallel with this, the synchronizing pulse from the input 127 of block 9 is delayed by the element 124 for the duration of the counter 122 operation and arrives at the synchronizing input of the comparator 123.

According to the synchronizing signal supplied to its synchronizing input, the comparator 123 compares the number of scanned citizens identification data records with a fixed number of records of similar records in the database having the same initial letters of the last name, first name, and middle name.

If the comparison of numbers did not happen, then a signal is generated at the output 128 of block 9, which passes through the OR element 138 through the input 138 of the block 10 and arrives at the counting input of the counter 130. At this pulse, the counter 130 adds the first unit to the reference address, and the newly formed address with the output of the counter 130 is issued to the address output 30 of the system.

Simultaneously with this process, the synchronizing pulse from the input 138 of block 10 passes through the OR element 132, is delayed by the element 134 for the duration of the counter 130 operation, and then through the first synchronizing output 33 of the system it is again fed to the input of the first interrupt channel of the database server.

By this signal, the server again switches to the subroutine for reading the contents of the next database cell at the specified address, issuing it to the system information input 22 and entering the contents of the database cell into the register 142 of block 11 with a synchronizing pulse from the server to input 25.

The described process of reconciling the input record with the records stored in the database continues until the input record is reconciled with all the records in the database that have the same initial letters of the last name, first name, and middle name.

If as a result of such a verification no coincidence of the input record with any database record is recorded, then the comparator 123, by issuing a signal to the output 129 of block 9, will record the fact of viewing all database records and confirm the absence of a citizen identification system in the database.

In this case, the signal from the output 129 of block 9, first, passes to the input 139 of block 10, passes the OR element 131, and enters the counting input of the counter 130. At this pulse, the counter 130 adds one to the last address recorded in it, and the newly formed address from the output of the counter 130 is issued to the address output 30 of the system.

Secondly, the synchronizing pulse from the input 139 of the block 10 is delayed by the element 135 for the duration of the counter 130 operation, the OR element 133 passes, and then through the second synchronizing output 34 of the system it enters the input of the second channel of the database server interrupt.

By this signal, the server goes to the subroutine for recording the input identification data of the person from system output 31 to the specified address at system output 30.

If the comparator 12 fixes the fact that the input identification signs are equal at inputs 149 and 150, then its output 153 generates a signal “Provide citizen data for verification to the expert workstation”, according to which information about the corresponding citizen from the outputs 31 and 32 of the system is issued to an automated workstation place of an expert.

Only those categories of personal data are displayed in the synchronization window for which discrepancies were detected in at least one of the category attributes, and for multi-attribute categories (for example, an identity document structured in the form of six attributes), the values of all attributes are displayed to create for analyzing the context context of interrelated values.

In the process of reconciling the data, the expert from his automated workplace can make the necessary editorial changes to the candidates' data, for which the experts to be clarified are sent to the information input 22 of the system and entered into the block register 142 by a synchronizing pulse from input 26.

At the end of the reconciliation of data and entering the necessary refinements, the expert from his workstation gives a signal “Verification of the candidate data is completed”, which is fed to the input 27 of the system and then, firstly, fed to the input 140 of block 10, where the OR element 133 passes and from the output 34 the system is issued to the input of the second channel of the database server interrupt. By this signal, the server goes to the subroutine for recording information edited by the expert from the output 32 of the system at the address generated at the input 30 of the system.

Secondly, the signal from input 27 through input 102 of block 6 is fed to the counting input of counter 99, which records the number of candidate information viewed and verified by an expert.

From the output of the counter, its readings go to one input of comparator 98, the other input of which receives the number of citizens whose information needs to be verified.

If the number of citizens whose information has been verified by an expert is less than the specified number of citizens to be reconciled, then at the output 103 of block 6 a read signal is generated from block 5 of the data of the next candidate.

This signal from the output 103 of block 6 goes to the input 90 of block 4, from where it passes the OR element 83 and goes to the synchronizing input of the adder 82, which forms the next read address by adding the base address of the election commission and the readings of the counter 70 of block 3, reduced by one.

In addition, this synchronizing pulse is delayed by element 85-2 for the duration of the next citizen's data reading address formation and from the output 93 of block 4 goes to the input 77 of block 3, where the OR element 72 passes and through the output 80 of block 3 it is issued to the data reading control input 158 block 5, and after a delay by element 74 while reading data from block 5, it enters both the subtracting input of the reversible counter, decreasing its readings by one, and from the output 81 of block 3 it enters the synchronizing input of block 7, recording TED citizen of unit 5.

Further operation of the system will be continued in the manner described above until the comparator 98 of block 6 fixes the fact of the completion of reconciliation of data of all citizens by issuing a signal to the output 104 of block 6, which is issued to the output of the system as a signal of completion of the data verification procedure.

By the same signal, all the nodes and blocks of the system are set to their initial state, after which the system is ready to receive and verify data from other border crossing points of citizens.

Thus, the introduction of new nodes and blocks made it possible to significantly increase the speed of the system by localizing the addresses of the requested data of citizens in the database of the system by their identifiers of the initial letters of the surname, name, patronymic.

The solution of the task of reconciling personal data of citizens allows to ensure the updating of data in the system data warehouse, as well as to identify and eliminate inconsistencies between the identification data on citizens received from various border checkpoints, to achieve their consistency and consistency.

Sources of information taken into account when drawing up the description of the application:

1. US Patent No. 0,005,651 M. cl. G06F 13/40, 13/38, 1992

2. US Patent No. 05129083 M. cl. G06F 12/00, 15/40, 1992 (prototype).

Claims (1)

An automated system for managing the data warehouse of the migratory flow of citizens, containing an input messages receiving unit, the information and synchronizing inputs of which are the first information and synchronizing inputs of the system, while the information input of the input messages receiving unit is designed to receive messages from citizens at border crossing points, and the synchronizing input of the receiving unit of input messages is intended for receiving synchronizing signals of entering input messages into the input receiving unit messages, the memory unit, the address input of which is connected to the information output of the data recording address modification block, the memory control recording input is connected to the first synchronizing output of the data recording address modification block, and the information output of the memory block is connected to the information input of the data presentation unit for reconciliation, block receiving records of the server database, the information input of which is the second information input of the system, designed to receive citizens data from the server database with of the system, the first synchronizing input of the server database record receiving unit is the second system synchronizing input for receiving system server synchronizing signals for entering citizen data into the server database recording receiving unit, the second synchronizing input of the server database recording receiving unit is the third synchronizing system input intended for receiving synchronizing signals for entering data from an automated workstation of an expert, a signal generation unit with washing and writing the server database, the information output of which is the address output of the system, designed to provide the write and read addresses to the address input of the database server, one synchronizing output of the unit for generating read and write signals of the server database is the first synchronizing output of the system, intended for issuing control signals to the input of the first channel of the database server interrupt, and the other synchronizing output of the base for generating signals for reading and writing the database server data is the second synchronizing output of the system, intended for issuing control signals to the input of the second channel of the database server interrupt, characterized in that the system contains a selection block of base addresses of border crossing points of citizens, the information input of which is connected to the first output of the input message receiving unit, synchronizing the input of the selection block of the base addresses of the border checkpoints of citizens is connected to the first synchronizing output of the input messages receiving block, info the output of the selection block of the base addresses of border checkpoints of citizens is connected to the first information input of the block of modification of addresses of data recording, and the synchronizing output of the selection of base addresses of points of border checkpoints of citizens is connected to the first synchronizing input of the block of modification of addresses of data recording, the second synchronizing input of which is connected to the second the synchronizing output of the input message receiving unit, the unit for selecting the recording and data sampling intervals, the information input of which It is connected to the second information output of the input message receiving unit, the counting input of the unit for recording and sampling data intervals is connected to the first synchronizing output of the unit for modifying data recording addresses, and the synchronizing input of the unit for selecting intervals for recording and sampling data is connected to the second synchronizing output of the unit for modifying recording addresses data, while the information output of the unit for selecting intervals of recording and data sampling is connected to the second information input of the address modification unit data recording, the first synchronizing output of the block for selecting intervals of recording and sampling data is the control output of the system designed to issue signals to control the presentation of new records from the input message codogram, the second synchronizing output of the block for selecting intervals of recording and sampling data is connected to the control input for reading data from the memory block and the third synchronizing output of the unit for selecting intervals of recording and data sampling is connected to the synchronizing input of the unit for presenting data for reconciliation, a selection block of a reference address for reading a database of the server, the information input of which is connected to the first information output of a block for presenting data for reconciliation, the synchronizing input of a block for selecting a reference address for reading a database of a server is connected to a third synchronizing output of a block for selecting recording and data collection intervals, while the first information output of the selection block of the reference read address of the server database is connected to the information input of the read signal generating unit writing the server database, and the synchronizing output of the selection block of the reference address of reading the database of the server is connected to the first synchronizing input of the block for generating signals for reading and writing the server database, the block for determining the boundaries of the sample data of the server database, the information input of which is connected to the second information output of the selection block the reference address of the server database reading, and the synchronizing input of the block for determining the boundaries of the sample database server data is connected to the synchronizing the output of the selection block of the reference address for reading the server database, one output of the block determining the boundaries of the sample data of the server database is connected to the second clock input of the block for generating the read and write signals of the server database, and the other output of the block for determining the boundaries of the selection of server database data is connected the third synchronizing input of the unit for generating read and write signals of the server database, the fourth synchronizing input of which is the control input of the system, the block the data of the intervals for reconciling data, the information input of which is connected to the second information output of the block for receiving input messages, the counting input of the block for selecting intervals of the reconciliation of data is connected to the control input of the system, one output of the block for selecting the intervals for reconciling data is connected to the third synchronizing input of the block for modifying the addresses of data records, and the other output of the data reconciliation interval selection unit is the first signal output of the system intended for issuing signals of the end of the data reconciliation procedure , an identity data identification unit, one information input of which is connected to a second information output of a presentation data presentation unit, another information input of an identity data identification unit is connected to a first information output of a server database record receiving unit, a synchronization input of an identity data identification unit is connected to a synchronization output unit for presenting data for reconciliation, the first output of the unit for identifying personality data is connected to the counting input of the unit for determining boundaries sampling the server database data, and the second output of the personality data identification unit is the second signal output of the system, intended for issuing a signal for the presentation of reconciliation data to the expert's workstation, while the third information output of the input message receiving unit is connected to the information input of the memory unit, the third information the output of the unit for presenting data for reconciliation is the first information output of the system intended for the issuance of citizens' received data to an automatic machine the expert’s workstation, and the second information output of the server database records receiving unit is the second information output of the system intended for issuing server database data to the expert’s automated workstation.