RU2323471C1 - System for maintaining electronic files of personnel book-keeping - Google Patents

Abstract

FIELD: computer engineering, in particular, system for maintaining electronic files of personnel book-keeping of municipal structures.

SUBSTANCE: the system contains a block for receiving user requests, a block for selecting address of records in server database, block for identification of number of cycles of database record reading, block for selecting time limits of data records selection, block for forming signals for reading records of database, block for identification of database records, block for determining depth of data selection, block for accumulating addition of analytical data and a data dispensing block.

EFFECT: increased speed of system operation due to localization of range of data search addresses in database of system server.

10 dwg

Description

The invention relates to computer technology, in particular to a system for maintaining an electronic filing cabinet of personnel records management of municipalities.

In connection with building a new system of municipal administration, the issue of increasing the efficiency of municipal employees engaged in ensuring the implementation of municipal authority in the interests of the local community, which is directly related to the implementation of the organizational principles of municipal service, is of particular importance. The latter is a professional activity carried out on an ongoing basis in a municipal post that is not an elected one.

Ensuring the effectiveness of the municipal service involves targeted measures to carry out personnel work, attracting and selecting highly professional and competent personnel with the level of education and experience in meeting the established criteria and standards. The effectiveness of the activities of municipal authorities also depends on the functioning of the system of advanced training for municipal employees.

A decent level of professionalism and competence of municipal service personnel is concern and an important area of activity of municipal authorities, determined by the principle of professionalism of the municipal service, enshrined in law.

Professionalism and competence of personnel are ensured by the orderly promotion of municipal employees along the career ladder, subordinate to a well-thought-out plan of measures in this area, organization and functioning of the municipal service.

Personnel services of municipal authorities, based on the collection of relevant information and the conduct of personal files of municipal employees, take appropriate measures to maintain a level of qualification sufficient for municipal employees to fulfill their official duties. They are engaged in an analysis of the level of professional training of municipal employees: systematic professional training is a necessary element of municipal service in local governments.

The professionalism of the municipal employee is ensured as a result of a whole complex of measures, including the assessment of the level of professional training, training and retraining of the municipal employee. To implement such measures, the personnel services of municipal bodies should be equipped with the necessary technologies for conducting personnel work, and, in turn, should have highly professional personnel.

The peculiarity of the technical task to be solved is that the information-analytical system of personnel management of municipalities could fulfill not only the functions of issuing a certificate of an employee of a municipal formation, a record of whose registration data is stored in the system server database, but could also perform the issuing of problematic -oriented lists of employees according to specified address, age, educational, business and other criteria for assessing the personnel of municipal Azov.

The information-analytical system of personnel management of municipalities is based on a server database, the records of which use the attributes of employees recorded in the registration system:

- last name;

- name;

- patronymic;

- gender;

- citizenship;

- Date of Birth;

- Place of Birth;

- type and details of an identity document;

- address of the place of residence (or place of stay);

- education;

- business qualities;

- achievement list;

- date of entry of the latest information.

Known systems that could be used to solve the problem [1, 2].

The first of the known systems comprises 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 device is the impossibility of solving the problem of updating data stored in memory in the form of relevant documents at the same time as solving the problem of delivering the contents of these documents to users in real time.

Another system is known, comprising data receiving units whose outputs are connected to a memory unit and to a data processing unit, a time interval selection unit whose outputs are connected to a data receiving unit, to a user request receiving unit and to a memory unit and to a data processing unit, the outputs of which are connected to one of the inputs of the switching unit of the data output channels, the other inputs of which are connected to the selection of time intervals, and the outputs are the outputs of the system [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 search for the requested data is carried out throughout the database, which leads to unreasonable loss of time for issuing certificates, especially with large amounts of data stored in the system server.

The purpose of the invention is to improve system performance by eliminating the search for requested data throughout the database and localizing the search only by the characteristic features of an identifiable employee.

This goal is achieved by the fact that in a known system containing a block for receiving user requests, the information input of which is the first information input of the system for receiving codograms of requests for users of the system, the synchronizing input of the block for receiving user requests is the first synchronizing input of the system for receiving synchronizing signals entering codograms of user requests into the user request receiving unit, and the clock input of the request receiving unit of users is a clocking input of the system, intended for receiving clocking signals for synchronizing the operation of the system, a block for generating signals for reading database records, the first and second control inputs of which are connected to the first and second control outputs of the block for receiving user requests, respectively, the address output of the block for generating signals for reading base records data is the address output of the system, designed to provide a read address to the address input of the database server, the first the clock output of the database record reading signal generation block is the first system synchronization output for outputting control signals to the input of the first database server interrupt channel, and the second database record reading signal generation block is the second clock output of the system for signal output control on the input of the second channel of the database server interrupt, and the data output unit, the information output of which is I am the information output of the system intended for the delivery of the requested data to the user's workstation, a block for selecting the base address of entries in the server database is introduced, the first and second address inputs of which are connected to the first and second information outputs of the user request receiving block, respectively, the first and second synchronizing the inputs of the selection block of the base address of entries in the server database are connected to the first and second synchronizing outputs of the user request receiving unit respectively, while one information output of the selection block of the base address of the records in the server database is connected to the information input of the block for generating the read signals of the database records, and one synchronizing output of the selection block of the base address of records in the server database is connected to the first synchronizing input of the signal generation block reading database records, a unit for identifying server database records, the first information input of which is the second information input of the system, destined for receiving server database records, the second and third information inputs of the server database record identification block are connected to the third and fourth information outputs of the user request block, respectively, the first clock input of the server database record identification block is the second clock input of the system for receiving synchronizing signals for recording database records in the server database record identification block, the control input of the ide block ntification of server database records is connected to the first control output of the user requests reception unit, while the information output of the server database records identification block is connected to the first information input of the data output block, the first synchronizing output of the server database records identification block is connected to the counting input of the signal generation block reading database records, and the second synchronizing output of the server database record identification block is connected to the first synchronizing to it the input of the data output unit, the third synchronizing output of the server database record identification unit is connected to the first installation input of the user request receiving unit and to the second installation input of the database record read signal generation unit, the identification number of the database record read cycles, the information input of which is connected with the second information output of the selection block of the base address of entries in the server database, the first synchronizing input of the identification block of the number of cycles with the database record washer is connected to the second synchronizing output of the selection block of the base address of the records in the server database, the second synchronizing input of the identification unit of the number of read cycles of the database records is connected to the fourth synchronizing output of the identification block of the server database records, and the third synchronizing input of the number of cycles identification block reading database records is connected to the fifth synchronizing output of the server database record identification block, while the first output a unit for identifying the number of read cycles of database records is connected to a subtracting input of a unit for generating signals for reading database records and to a second installation input of a unit for identifying records of a database of a server, a block for selecting temporary boundaries of a sample of data records, an input of which is connected to a second output of a unit for identifying a number of read cycles database records, the first output of the block of selection of time boundaries of the selection of data records is connected to the subtracting input of the block for receiving user requests and to t to the first installation input of the server database record identification block, the second output of the time boundary selection block of the data record selection is connected to the third synchronizing input of the data output block, and the third output of the time boundary selection block of the data record selection is connected to the first installation input of the database record read signal generation block to the second installation input of the block for receiving user requests, to the third subtracting input of the identification block of the number of read cycles of database records and to the first installation input of the server database record identification unit, the data sampling depth determining unit, the first and second control inputs of which are the first and second control inputs of the system for receiving data sampling control signals, the third control input is connected to the second control output of the reception unit user requests, the first synchronizing input of the unit for determining the depth of data sampling is connected to the second synchronizing input of the system, the second synchronizing in the stroke of the block for determining the depth of data sampling is connected to the second output of the block for identifying the number of read cycles of database records, and the installation input of the block for determining the depth of sampling data is connected to the third output of the block for selecting the time limits of sampling data records, while the first output of the block for determining the depth of sampling of data records the second synchronizing input of the identification block of the server database records and with the second subtracting input of the identification block of the number of read cycles of the database records, and the second the output of the unit for determining the depth of data sampling is connected to the first subtracting input of the unit for identifying the number of read cycles of database records, the installation input of which is connected to the installation output of the data output unit, and the accumulating accumulation unit of analytical data, the first synchronizing input of which is connected to the second output of the depth determination unit data sampling, the second synchronizing input of the accumulating analytical data summing unit is connected to the fourth synchronizing output unit and for identifying server database records, the third synchronizing input of the accumulating analytic data summing unit is connected to the third output of the selection block of time boundaries of the selection of data records, and the fourth synchronizing input of the accumulating analytical data summing unit is connected to the second output of the identification unit of the number of read cycles of database records this one information output block accumulating summation of analytical data is connected to the second information input block cottages data, other information output collecting analytical data summation unit is connected to a third data input of the data output unit, and output timing collecting analytical data summation unit coupled to a second input timing data output unit.

The invention is illustrated by drawings, where Fig. 1 shows a structural diagram of a system, Fig. 2 shows an example of a specific structural embodiment of a block for receiving user requests, Fig. 3 is an example of a specific structural embodiment of a block for selecting a base address of records in a server database, in Fig. .4 - an example of a specific constructive implementation of the unit for identifying the number of read cycles of database records, Fig. 5 is an example of a specific constructive implementation of the block for selecting the time boundaries of the sample this data, Fig.6 is an example of a specific structural embodiment of a block for generating signals for reading database records, Fig.7 is an example of a specific structural embodiment of a block for identifying database records, Fig.8 is an example of a specific structural embodiment of a block for determining the depth of data sampling, figure 9 is an example of a specific structural embodiment of the block accumulating summation of analytical data, figure 10 is an example of a specific structural embodiment of the block data output.

The system (Fig. 1) contains a block 1 for receiving user requests, a block 2 for selecting addresses of records in the server database, a block 3 for identifying the number of cycles for reading database records, a block 4 for selecting time boundaries for sampling data records, a block 5 for generating signals for reading database records , block 6 for identifying database records, block 7 for determining the depth of data sampling, block 8 for accumulating summation of analytical data, block 9 for outputting data.

Figure 1 shows the first 11 and second 12 information inputs of the system, the first 13 and second 14 clock inputs of the system, clocking 15, the first 16 and second 17 control inputs of the system, as well as address 18 and information 19 outputs of the system, the first 20 and second 21 system synchronization outputs.

Block 1 receiving user requests (figure 2) contains a register 40, subtracting the counter 41, triggers 42, 43, elements 44, 45 AND, elements 46, 47 And the first and second groups, elements 48, 49 OR, elements 50, 51 delay . The drawing shows the information input 11, the synchronizing input 13, the control input 15, subtracting the input 52, the installation inputs 53, 54, as well as the information outputs 55-58, the synchronizing outputs 59, 61 and the control outputs 60, 62.

Block 2 selection of addresses of records in the server database (figure 3) contains decoders 63, 64, memory blocks 65, 66, made in the form of read-only memory devices, elements 67-72 AND, element 73 OR, group of elements 74 OR, elements 75 -77 delay. The drawing shows information 78, 79 and synchronizing 80-81 inputs, as well as information 82, 83 and synchronizing 84, 85 outputs.

Unit 3 for identifying the number of read cycles of database records (Fig. 4) contains an OR element 110, a register 111, a counter 112, a comparator 113, and an OR element 114. The drawing shows the information input 115, the first 116, the second 117, the third 118 clock inputs, the first 119, the second 120 and the third 121 subtracting inputs and installation 122 input, as well as the first 123 and second 124 outputs.

Block 4 selection of time boundaries of the selection of data records (figure 5) contains a counter 130, a register 131, a comparator 132, elements 133, 134 delay. The drawing shows the input 135, as well as the outputs 136-138.

Block 5 generating signals for reading database records (Fig. 6) contains a reverse counter 22, elements 23, 24 OR, elements 25, 26 AND, element 27 delays. The drawing shows the information input 28, the first 29 clock input, counting 30 input, subtracting 31 inputs, the first 32 and second 33 installation inputs, second 34 and third 35 clock inputs, as well as address 18, first 20 and second 21 outputs.

The database record identification unit 6 (Fig. 7) contains a register 36, a first 37 and a second 38 comparators, an AND element 39, an OR element 86, delay elements 87-89. The drawing shows the first information 12 input, the first synchronizing 14 input, the second 90 and third 91 information inputs, the control 92 input, the second 93 synchronizing input, the first 94, the second 95 and the third 96 installation inputs, as well as the information 97 output, the first 99, second 100, third 101, fourth 107 and fifth 108 synchronizing outputs.

Block 7 for determining the depth of data sampling (Fig) contains a counter 140, triggers 141, 142, 143, elements 144-149 AND, element 150 OR, element 151 delay. The drawing shows the first 152 and second 153 clock inputs, the first 154, second 155 and third 156 control inputs and installation 157 input, as well as the first 158 and second 159 outputs.

Block 8 of the accumulating summation of analytical data (Fig.9) contains the adder 160, the counter 161 and the element 162 OR. The drawing shows the first 163, second 164, third 165 and fourth 166 clock inputs, as well as the first 167 and second 168 information and clock 169 outputs.

The data output unit 9 (FIG. 10) comprises a buffer memory unit 170, an AND group 171, 172, a group of OR elements 182, delay elements 173, 174. The drawing shows the first 175, second 177 and third 178 information inputs, the first 176, second 179 and third 180 synchronization inputs, as well as information 19 and installation 181 outputs.

All nodes and elements of the system are made on standard potential-impulse elements.

Unlike well-known information-analytical systems, this system can work in two modes:

- in the mode of issuing certificates of employees of municipalities whose registration data in the form of records are stored in the relational database of the server,

- in the mode of issuing samples of records by groups of employees, in the form of problem-oriented lists compiled according to specified criteria.

To realize the possibility of the system working in the indicated modes, each of them has its own copy of the database on the database server.

The structure of records in the database of the first mode is as follows

Surname Name middle name Date of Birth Floor Attributes of the record, including both the registration data of the employee and his data on the passage of service as a public servant

All entries in the database of the first mode are sorted alphabetically.

The structure of records in the database of the second mode is as follows

Date of Birth Surname Name middle name Floor Attributes of the record, including both the registration data of the employee and his data on the passage of service as a public servant

All records in the database of the second mode are sorted by date of birth, which makes it possible to clearly record for each calendar year the total number of records for employees born in the specified year.

We consider the operation of the system, starting with the first mode, in which the system is in the initial state, fixed by the trigger 42 of block 1 (to simplify the drawing, the circuit for setting the system to its initial state is not shown in the drawing).

High potential from the inverted output of trigger 42 of block 1, firstly, is outputted to output 60 of block 1 and then to the corresponding control inputs of blocks 5, 6 and, secondly, it opens elements 46 and 44 And at one input, thereby connecting the information 11 and synchronizing 13 system inputs to the information and synchronizing inputs of the register 40.

To obtain an entry from the server database about a specific employee of the municipality, the system user at his workplace dials his last name, first name, middle name and date of birth. In addition, at the same workstation, a sign of the search for the record of this employee is automatically generated in the form of a code for the first three initial letters of his last name.

As a result, at the exit of the user's workplace, a codogram of the following form will be formed

The code of the first three letters of the surname, name and patronymic of the employee Surname Name middle name Date of Birth

The request codogram from the user's workstation from the system input 11 through the elements 46 AND of the group is entered into the register 40 of the block 1 by the synchronizing pulse from the input 13, which passes to the synchronizing input of the register 40 through the element 44 And, open at the second input with a high potential from the inverse output of the trigger 42 in the initial state.

From the output 55 of block 1, the code of the feature part of the codogram, consisting of the first three letters of the surname, through the input 78 of block 2 is fed to the information input of the decoder 63.

The decoder 63 of block 2 decrypts the code of the first three letters of the surname, giving out one of its outputs high potential. For definiteness, we assume that a high potential is received at one input of element 67 I.

In parallel with this, the synchronizing pulse from the output of element 44 AND of block 1 is delayed by element 50 for the time the code is entered into register 40 and the decoder 63 is activated, and then, firstly, through element 48, OR is transmitted to the single input of the trigger 43 of the lock, which, passing into a single state, locks the element 44 And with a low potential from the inverse output, thereby blocking the ability to record the next request in register 40.

Secondly, the same pulse from the output 59 of block 1 through the input 80 of block 2 interrogates the states of elements 67-69 I.

Considering the fact that only element And will be open on one input, then, having passed this element And, the clock pulse arrives, firstly, at the read input of a fixed memory cell of read-only memory 65, where the base address of the server’s memory cell with the first record is stored , in which the last name begins with the indicated three letters, and reads its contents through the elements 74 OR and output 82 to the information input 28 of the reverse counter 22 of block 5.

Secondly, the same read pulse is delayed by the delay element 75 for the time of reading the contents of the fixed ROM cell, and then through the OR element 73 and the output 84 of the block 2 is fed to the synchronizing 29 input of the reverse counter 22 of the block 5, fixing the base address of the first cell in the counter 22 memory in which the last name begins with the specified three letters.

Thirdly, the same impulse, having passed the OR element 24, is delayed by the element 27 for the time the base address is entered in the counter 22 and then goes to the same inputs of the elements 25 and 26 I.

Considering that a high resolution potential from input 34 is supplied to the input of element 25 AND, the synchronizing pulse passes through element 25 AND to the output 20 of block 5.

From the output 20 of the system, this pulse is fed to the server interrupt input (not shown in the drawing), to the address input of which the code of the base read address from the output 18 of block 5 is issued.

By this signal, the server switches to the subroutine for polling the contents of the cell record at the specified database address of the server of the first mode.

The contents of the base address of the selected memory cell is issued by the database server through the system input 12 to the information input of the register 36 of block 6, where it is entered by the server synchronizing pulse coming from the system input 14.

The contents of the register 36, which is the first record in which the last name begins with the three letters, goes to one input 102 of the comparator 38, the other inputs of which through input 90 from the output 56 of block 1 receives the code of the last name, first name and patronymic of the requested employee.

The comparator 38 compares the codes by the clock coming from input 14, which is then delayed by element 87 while the code is entered into register 36 and then passes through element 39 AND, which is open by high potential from the inverse output 60 of trigger 42 of block 1.

If the codes do not match, then the output 99 of the comparator 38 receives a pulse, which through the input 30 of block 5 is fed to the counting input of the reverse counter 22 of block 5, increasing the contents of the base address by one. Then the same impulse, passing element 24 OR, and delayed by element 27 for the duration of the operation of the reverse counter, again through element 25 AND is fed to the server interrupt input.

At this signal, the server goes to the subroutine for polling the contents of the cell record at the following address.

The contents of the address of the next memory cell is again issued by the database server through the system input 12 to the information input of the register 36 of block 6, where it is entered by the server synchronizing pulse coming from the system input 14.

The contents of register 36, which is the second record in which the employee's last name begins with the three letters, goes to one input of the comparator 38, the other inputs of which through the input 90 of block 6 from the output 56 of block 1 receives the code of the last name, first name and patronymic of the requested employee.

The comparator 38 again compares the codes according to the clock received from the input 14 of block 6. This pulse is delayed by element 87 while the code is entered into register 36 and then passes through element 39 AND, which is open by high potential from the inverse output 60 of trigger 42 of block 1.

If the codes do not match, then the output 99 of the comparator 38 reappears a pulse, which through the input 30 of block 5 again goes to the counting input of the reverse counter 22 of block 5, increasing the contents of the base address by one. Then the same impulse, having passed through the OR element 24, and delayed by the element 27 for the duration of the operation of the reverse counter, is again fed to the server interrupt input.

This procedure for viewing records continues until the comparator 38 records the fact that the codes of the requested last name, first name, middle name, and last name, first name, and middle name are in the record stored in the database.

The fact of the coincidence of the codes will be recorded at the time of the appearance of the pulse at the output 100 of block 6, which from the specified output goes to the input 176 of block 9 and then to one inputs of the elements 171 And groups, to the other inputs of which from the input 175 of block 9 the outputs of the register 36 are connected through the output 97 blocks 6.

The received impulse rewrites the contents of the register entry 36 through elements 171 AND and elements 182 OR groups to the output 19 of the system, from where it arrives at the user's workplace.

At this point, the procedure for issuing data about the requested individual ends, which is fixed by the pulse of the comparator 38, delayed by the delay element 89, which delays the pulse from output 100 during the polling and the issuance of the contents of register 36 to the output 19 of the system.

In addition, the same pulse from the output 101 of block 6, firstly, goes to the installation input 33 of block 5, where the OR element 23 passes and returns the counter 22 to its original state, preparing it for the next cycle of operation.

Secondly, the same pulse through the OR element 86 is supplied to the installation input of the register 36 and to the installation input 53 of the blocking trigger 43 of block 1, also returning them to their original state.

To obtain analytical information about the employees of the municipality in a given section, a signal is applied to the clocking input 15 of the system, which sets the trigger 42 of the mode of unit 1 to a single state, in which high potential is outputted to output 62 and low, blocking element 39 is outputted to output 60 And, and thereby the work of comparator 38 of block 6.

To obtain a selection from the server database in the form of a list of individuals according to one of the possible criteria, for example, age, the system user at his workplace collects a selection sign, for example, pensioners.

In this case, the reporting year of the sample is set at the user's workplace, for example, 2006, and, thus, the list of female pensioners will begin with female pensioners born in 1951, and the list of male pensioners will start from 1946 year of birth.

Considering the fact that the total number of employee data records in the database for each year is clearly defined, as a result, the following code will be generated at the output of the user's workplace

Sample reference year Gender sign 1951 Female

The choice of the "Pensioners" mode leads to the fact that from the input 16 of the system to the input 154 of block 7 a control signal is issued that sets the trigger 142 to a single state, in which a high potential from a single output opens the elements 144 I, 147 And one input.

According to the signal from the user's workplace, which arrives at the synchronizing input 13, the codogram code from input 11 through elements 47 AND of the group, opened by high potential from the direct output of the trigger 42 of the mode, is entered into the subtracting counter 41 of block 1 by the synchronizing pulse from input 13, which passes to the synchronizing input of the counter 41 through the element 45 And, open at the second input with high potential from the direct output of the trigger 42 mode.

From the output 57 of block 1, the code of the reference year of the sample through the input 79 of block 2 is fed to the information input of the decoder 64, which in our example decrypts 1951, giving out one of its outputs with high potential.

For definiteness, we assume that a high potential is received at one input of element 72 I.

In parallel with this, the synchronizing pulse from the output of element 45 AND of block 1 is delayed by element 51 for the duration of entering the code into counter 41 and the operation of decoder 64, and then, firstly, through element 48, OR is transmitted to the single input of trigger 43, which, passing into a single state, locks the element 45 And with a low potential from the inverse output, thereby blocking the possibility of the next request coming to the counter 41.

Secondly, the same pulse from the output 61 of block 1 through the input 81 of block 2 interrogates the states of elements 72-74 I.

Considering the fact that only element And will be open on one input, then, having passed this element And, the clock pulse arrives, firstly, at the read input of a fixed memory cell of read-only memory 66, where the base address of the server’s memory cell with the first record is stored 1951 and the total number of records in 1951, and reads the contents of the base address of the server’s memory cell with the first record of 1951 through the elements 74 OR groups and output 82 to the information input 28 of the reverse counter 22 of block 5, and the total number of Isei 1951 born from the output unit 83 2 is read at block 115 the entrance 3.

Secondly, the same read pulse is delayed by the delay element 76 for the duration of reading the contents of the fixed ROM cell, and then through the OR element 73, the output 84 goes to the synchronizing 29 input of the reverse counter 22 of block 5, fixing in the counter 22 the base address of the first memory cell with born in 1955.

Thirdly, the same impulse, having passed the OR element 24, is delayed by the 27 element while the base address is entered into the counter 22, and then through another element 26 AND then it passes through the output 21 of block 5 to the input of another server interrupt channel.

By this signal, the server goes to the subroutine for polling the contents of the second mode database cell, the address of which is issued from the output 18 of block 5.

By this signal, the server switches to the subroutine for polling the contents of the cell record at the specified address.

The contents of the base address of the selected memory cell is issued by the database server through the system input 12 to the information input of the register 36 of block 6, where it is entered by the server synchronizing pulse coming from the system input 14.

The contents of the register 36, which is the first entry in 1951, is fed to one of the inputs of the comparator 37, to the other inputs of which through the input 91 of the block 6 from the output 58 of the block 1 receives the female sign code.

In parallel with this, the pulse of writing the code to the register 36 from the input 14 of the system goes to the input 152 of block 7, is delayed by the element 151 for the time the data are entered into the register 36, and goes to one input of the element 146 AND, the other 156 input of which has high trigger potential 42 of the mode block 1. The delayed pulse of writing data to the register 36 from the output of the element 146 passes through the high potential of the trigger 142 element 147 And, and then goes to one input of the elements 145 and 148 And, the other inputs of which are potentials from the direct and inverse outputs of the trigger 141.

Considering that at the given moment the trigger 141 is in the initial state, then the I 148 element will be open from the inverse output with a high potential, and the data recording pulse from the output of the 147 element will pass through the 148 I element and then will be output to the output 158 of block 7. From the output 158 block 7, this pulse passes to the input 120 of block 3 and then through the element 110 OR enters the counting input of the counter 112 of the number of records.

In addition, the same pulse from the output 158 of block 7, passing through the input 93 of block 6, is delayed by element 88 while recording data in the counter 112 of the number of records. Then it goes to the synchronizing input 105 of the comparator 37, which compares the code of the specified female code with the gender code received as part of the record from the output of the register 36.

The comparator 37 compares the codes on the clock pulse coming from the input 93 of block 6.

If the codes do not match, i.e. If the read-out record belongs to a male individual, then an impulse appears at the output 107 of the comparator 37, which passes through the input 117 of block 3 and then through the element 114 OR to the synchronizing input of the comparator 113. The comparator 113 compares the codes of the number of records in register 111 to be read with the code of the already read the number of counter entries is 112.

If the comparison of the codes did not happen, then a signal is generated at the output 123, which, firstly, enters through the input 95 of block 6 and then the OR element 86 to the installation input of the register 36, returning it to its original state, and, secondly, it enters to the subtracting input 31 of the counter 22 of block 5, forming the next address for reading the next record from the database.

In addition, the same impulse, having passed the OR element 24, and delayed by the element 27 at the time of the operation of the reversible counter, is again supplied through the And element 26, and the output 21 to the server interrupt input.

At this signal, the server goes to the subroutine for polling the contents of the cell record at the following address.

The contents of the address of the next memory cell is again issued by the database server through the system input 12 to the information input of the register 36 of block 6, where it is entered by the server synchronizing pulse coming from the system input 14.

The contents of the register 36, which is the second entry in 1951, is fed to one input 103 of the comparator 37, the other inputs of which through the input 91 of block 6 from the output 58 of block 1 receive a female character code.

The comparator 37 again compares the codes for the clock pulse coming from the input 93 of block 6, and the process of polling the contents of the server database continues as described above.

This procedure for viewing records continues until the comparator 37 of block 6 records the coincidence of the female sign codes.

The fact of the coincidence of the codes will be recorded at the time of the appearance of the pulse at the output 108 of block 6, which immediately goes to the input 164 of block 8, where the OR element 162 passes, and, firstly, goes to the counting input of the counter 161, forming the address for recording the contents of the register 39 in block 170 of the buffer memory, whose code from the output 168 of block 8 is fed to the input 178 of block 9.

Secondly, the same pulse, having passed through the OR element 162, from the output 169 of the block 8 is supplied to the synchronizing input 179 of the block 9, where it is delayed by the element 173 for the duration of the operation of the counter 161, and then it enters the data recording control input from the output of the register 36 of the block 6 through the input 175 of block 9 to the buffer memory 170.

In parallel with this, the same pulse from the output 108 of block 6 goes to the input 118 of block 3, where the OR element 114 passes and again goes to the synchronizing input of the comparator 113, starting the next cycle of reading data records and checking them as described above.

The described process continues until all records of the database for 1951 are reviewed, which will be fixed by the comparator 113 of block 7, by issuing a pulse of the end of the annual records to the output 124 of block 3.

This pulse, firstly, through the input 165 of block 8 is fed to the synchronizing input of the accumulating adder 160, overwriting the readings of the counter 161 into it. As a result, the total number of reads is recorded at the output 167 of the adder 160.

Secondly, the same pulse is fed to input 157 of block 7 as a signal to end viewing records of the next year, resetting the trigger 142 and 143 to its original state.

And, finally, the same pulse goes to the input 135 of block 4 and then to the counting input of the counter 130 of the scanned years, the outputs of which are connected to one of the inputs of the comparator 132, the other inputs of which are connected to the outputs of the register 131. Any constants that define age limit for individuals. For example, a range of 100 years may serve as such a constant.

The comparator 132 of block 4 compares the codes according to the clock received from the input 135. This pulse is delayed by the element 133 for the duration of the counter 130 operation and then passes to the synchronizing input of the comparator 132.

If the codes do not match, then the output 136 of the comparator 132 of the block 4 appears a pulse, which through the input 52 of the block 1 is fed to the subtracting input of the counter 41 of the block 1, reducing the specified year by one. Then, the same impulse, having passed the OR element 49, and delayed by the element 51 for the time of the counter 41 operation, is output 61, again starting the process of reading the server database records described above now already in 1950.

Similarly, the process of polling the contents of the server database will proceed for individuals born in 1949, 1948 and 1947.

This fact will be recorded by the counter 140 of block 7, to the counting input of which, after viewing the database records of the previous year, pulses of the end of the year from the output of 124 block 3 are received.

A feature of connecting the counter 140 of block 7 is the fact that it works in the reverse code. In other words, when the counter 140 is set to its initial state, it stores a predetermined number of years, for example, five, in the reverse code.

This circumstance leads to the fact that when the fifth pulse arrives at the input of the counter 140 of block 7, which indicates the viewing of five annual records (from 1951 to 1947), a pulse appears at the transfer output of the counter 140, which sets the trigger 141 of block 7 to a single state, in which the element 148 And will be closed by low potential from the inverse output of the trigger 141, and the element 145 And will be opened by high potential from the direct output of the same trigger.

As a result of this, the path of the subsequent passage of the data recording pulse into the register 36 from the system input 12 through the input 152 of block 7 will now pass not through the AND element 148, but through the AND elements 150, 150 OR and then through the output 159, which will ensure reading and viewing of records databases for all senior citizens and men and women.

The end of the sampling procedure for all pensioners will be fixed at that time when the comparator 132 of block 4 will record the fact of comparing the codes of the counter 130 and register 131 by generating a pulse at the output 137 of the comparator 132 of block 4, which from the specified output goes to the input 180 of block 9 and further to one of the inputs of the elements 172 And, to the other inputs of which from the input 177 of block 9 the outputs 167 of the adder 160 of block 8 are connected.

The received impulse rewrites the contents of the adder 160 through the elements 172 AND and the elements 182 OR groups to the output 19 of the system, from where this data arrives at the user's workstation.

If it is necessary to select data according to any of the specified criteria and indicate the corresponding annual range, the control signal from the user's workplace does not arrive at the input 154 of block 7, as was the case with retirees, but at the input 155 of block 7, where it goes to the input of trigger 143, thanks why the synchronizing signal from the input 152 of block 7 will be issued to the output of block 7 through the elements 149 AND, 150 OR and then to the output 159 of block 7, providing the operation of the clock circuit to control the selection of records from the database of the HR office server wa.

Thus, the introduction of new nodes and blocks and new constructive connections made it possible to significantly increase the system’s speed by localizing the range of addresses for searching for personnel data of municipalities in the database of the HR administration server.

Information sources

1. US Patent No. 5455947A, 03/10/95

2. US patent No. 5713014A, 01/27/98 (prototype).

Claims (1)

A system for maintaining an electronic filing cabinet of personnel records management, containing a block for receiving user requests, the information input of which is the first information input of the system designed to receive codograms of requests from users of the system; users in the block receiving user requests, and the clock input of the block receiving user request is a clock input of the system designed to receive clock signals for synchronizing the operation of the system, the unit for generating signals for reading database records, the first and second control inputs of which are connected to the first and second control outputs of the unit for receiving user requests, respectively, the address output of the unit for generating signals for reading records database is the address output of the system, designed to provide a read address to the address input of the database server, The first synchronizing output of the database record reading signal generation block is the first system synchronizing output intended for issuing control signals to the input of the first database server interrupt channel, and the second synchronizing output of the database recording reading signal generating block is the second synchronizing output of the system control signals to the input of the second channel of the database server interrupt, and a data output unit, the information output of which is the information output of the system intended for the delivery of the requested data to the user's workstation, characterized in that the system comprises a selection unit for the base address of entries in the server database, the first and second address inputs of which are connected to the first and second information outputs of the user request receiving unit, respectively , the first and second synchronizing inputs of the selection block of the base address of entries in the server database are connected to the first and second synchronizing you odes of the block for receiving user requests, respectively, while one information output of the selection block of the base address of the records in the server database is connected to the information input of the block for generating the read signals of the database records, and one synchronizing output of the block of the selection of the base address of records in the server database is connected to the first synchronizing the input of the unit for generating signals for reading database records, the unit for identifying server database records, the first information input of which is the second information input of the system intended for receiving server database records, the second and third information inputs of the server database record identification block are connected to the third and fourth information outputs of the user request receiving block, respectively, the first synchronizing input of the server database record identification block is the second synchronizing input a system designed to receive synchronization signals for entering database records into the database record identification block server, the control input of the server database record identification unit is connected to the first control output of the user request receiving unit, while the information output of the server database record identification unit is connected to the first information input of the data output unit, the first synchronizing output of the server database record identification unit is connected with the counting input of the unit for generating signals for reading database records, and the second synchronizing output of the server database record identification unit Era is connected to the first synchronizing input of the data output unit, the third synchronizing output of the server database record identification unit is connected to the first installation input of the user request receiving unit and to the second installation input of the database record read signal generation block, the database record number identification cycle identification block, the information input of which is connected to the second information output of the selection block of the base address of entries in the server database, the first synchronizing in the course of the identification block of the number of read cycles of database records is connected to the second synchronizing output of the selection block of the base address of the records in the server database, the second synchronizing input of the identification block of the number of reading cycles of database records is connected to the fourth synchronizing output of the identification block of the server database records, and the third the input unit for identifying the number of read cycles of database records is connected to the fifth synchronizing output of the unit for identifying records ba server data, the first output of the identification unit of the number of read cycles of database records connected to the subtracting input of the generating unit of the read signals of the database records and to the second installation input of the identification unit of the database records of the server, the selection block of temporary boundaries of the selection of data records, the input of which is connected with the second output of the identification block of the number of read cycles of database records, the first output of the selection block of the temporal boundaries of the selection of data records is connected to the subtracting input of the block receiving user requests and to the third installation input of the server database record identification block, the second output of the time boundary selection block of the data record selection is connected to the third synchronizing input of the data output block, and the third output of the time boundary selection block of the data record selection is connected to the first installation input of the formation block read signals of database records, to the second installation input of the user request receiving unit, to the third subtracting input of the number identification unit and the read cycles of the database records and to the first installation input of the server database record identification block, the data sampling depth determination unit, the first and second control inputs of which are the first and second control inputs of the system, intended for receiving data sampling control signals, the third control input is connected with the second control output of the block for receiving user requests, the first synchronizing input of the block for determining the depth of data sampling is connected to the second synchronizing an ode to the system, the second synchronizing input of the unit for determining the depth of data sampling is connected to the second output of the unit for identifying the number of read cycles of database records, and the installation input of the unit for determining the depth of data sampling is connected to the third output of the unit for selecting the time limits of sampling data records, while the depth of data sampling is connected to the second synchronizing input of the identification block of the server database records and to the second subtracting input of the identification number of the cycle number reading records of the database, and the second output of the block for determining the depth of data sampling is connected to the first subtracting input of the identification block for the number of cycles of reading the records of the database, the installation input of which is connected to the installation output of the data output unit, and the accumulating accumulation unit of analytical data, the first synchronizing input of which is connected with the second output of the block for determining the depth of data sampling, the second clock input of the block accumulating summation of analytical data is connected to to the fourth synchronizing output of the server database record identification unit, the third synchronizing input of the accumulating analytic data summing unit is connected to the third output of the time limits selection block of the data records sampling, and the fourth synchronizing input of the accumulating analytical data summing block is connected to the second output of the identification unit of the number of read records of the database records data, while one information output block accumulating summation of analytical data is connected to about the second information input of the data output unit, another information output of the accumulating analytical data accumulation unit is connected to the third information input of the data output unit, and the synchronizing output of the accumulating analytical data accumulating unit is connected to the second synchronizing input of the data output unit.

Images