A SYSTEM AND METHOD FOR ENSURING DATABASE SECURITY IN GEOGRAPHICALLY REDUCED ANALYTICAL SYSTEMS.

Abstract

The invention relates to a system and method that enables the synchronization of databases (2) holding all information in analytical systems (1) established in two different geographical regions and configured with geographical redundancy, and to provide synchronous service in terms of data. Database synchronization units (3) that connect to the database (2) of both analytical systems (1) and compare the indexes and documents in the database (2) perform data synchronization by retrieving and saving the missing or correct document from the database (2) of the analytical system (1) on the other side if there is a difference.

Description

1 TARIFF DATA IN GEOGRAPHICALLY BACKUP CONFIGURATIOND ANALYTICAL SYSTEMS A system and method that ensures the equalization of the base. Technical Area The invention relates to analytical systems established in two different geographical regions and configured with geographical redundancy. synchronization of databases that hold all the information in the systems and in terms of data. It relates to a system and method that enables them to provide services synchronously. 10 State of the Art In analytical systems found in critical systems such as communication systems, emergency call systems are used. Because important records such as these are contained and reports are generated from these records, these 15 Installing systems in a geographically redundant manner ensures uninterrupted service. This is extremely important for them to be able to continue. It is established with geographical redundancy. The information in the databases of the analytical systems must be the same in both systems, and Updating it while keeping it the same is important for the continuity of the service as well as for the production. This is also extremely critical in terms of the accuracy and consistency of the content of the reports. has. In analytical systems that operate with geographical redundancy, the information in the databases the existing system that ensures equalization and the continuous maintenance of this equality In one of the methods, databases in geographically redundant systems are in active-standby mode. It is configured in such a way as to be synchronized. In application number US2013132946A1, synchronization is required. The system and methods for active-passive application failover are described. In this method, while the database in one system is actively working, the data in the other system is working. The database is operating in standby mode. All data changes in the active database After being transmitted to the database in standby mode via various log files, 30 It is processed and reflected in the database in standby mode. This model works because the amount of data is small. This is especially true when working effectively in analytical systems with large amounts of data. failover, which can occur in large communication systems. It cannot function properly in these scenarios. Furthermore, a failover process is not fully functional. A second failover scenario that could occur before completion would affect both databases. 35 2 it can render the system inoperable and cause the information in the databases to become inconsistent with each other. This can lead to them becoming like this. This situation makes this system and method especially important. preferred by operators of communication systems with high data flow. This leads to it not being done. Another method currently being followed is to activate the database in both analytical systems. After configuring it to work, each of the input files coming to the analytical systems The goal is to ensure the same thing on both sides. Various checks and file transfers between the two systems. In this method, where the input files of the two systems are synchronized, both analytical... The system is also installed with the same hardware and software, and uses the same input files to process the same data. The goal is for them to create these reports and ultimately produce the same reports. This method is the main one. Although it is a successful method in terms of providing the same outputs as the lines, from the systems any temporary or permanent software or hardware problem that may occur in one of them The error lies in the data in the databases of both systems, and consequently in the reports and visuals they produce. This can lead to discrepancies in the graphs. This situation is particularly noticeable in the reports. In communication systems where reliability and consistency must be very high, this This raises concerns about the use of the method. In conclusion, due to the negative aspects described above and the current solutions, the subject matter... Due to its shortcomings, an improvement in the relevant technical field is necessary. 20 It has been observed. The purpose of the invention The invention aims to solve problems in existing methods by developing analytical systems and 25 The databases in these systems are set up to operate in an active-active manner, and both analytics The system periodically updates the indexes in its databases and the documents contained within those indexes. By checking and correcting different parts, the content of both databases will be updated accordingly. It proposes a system and method that ensures equalization. The method proposed by the invention involves analytical systems used with geographical redundancy, and these Databases on the systems will be actively operational in both geographic regions. They are set up and configured in this way. In other words, both systems receive input files. After processing, the data is stored only in the database located on their own system. They record the input files coming to geographically redundant systems, the existing system and 35 3 They can be configured to synchronize, as in the methods. However, in the systems, this Even without a synchronization structure for input files, both systems can still synchronize themselves. It processes incoming input files and saves them to the database. The input files are synchronized. In this case, although the processed and recorded data are highly likely to be the same, As previously stated, due to possible temporary or permanent software or hardware errors, 5 There is a possibility that the data in the databases of both systems may not be the same. The invention proposes a system and method to eliminate this possibility, again through the invention itself. The database synchronization unit proposed by [company name] is activated. It is active on both systems. The database synchronization unit, which is located there, runs periodically, both its own 10 from both the local database and the database belonging to the system on the other side. It retrieves the index list from the (remote) database. Then, each index found in the list... The document comparison process is initiated. If an index exists in both databases... If the number of documents and their content are exactly the same, then that's the case for the relevant index. No operation is required in the loop. If two data points with the same index are 15 If there is a difference between the content in the database, then the database synchronization unit detects this difference. It checks the source. If a document is not found in the local database index, then... In this case, the database synchronization unit connects to the database on the other side and completes the missing data. It retrieves the document and adds it to its own database. The local data of the document... If it exists in the database but not in the database of the other system, then 20 is running on the local side. The database synchronization unit does not need to perform any action because in this case The database synchronization unit working on the other side's system has transferred the missing document to its side. This will allow you to pull and equalize. If the document exists in the indexes on both sides, but the content of both documents differs by 25 If they are different, then the document found in the database index on one side is correct. It is accepted as such, and the database on the other side is synchronized accordingly. Invention In this case, it is recommended that the document with the most recent date be accepted as correct. Data The base equalization unit also performs the comparison and matching process of the desired indices. It allows for exclusion. The main reason for this is that the input files coming into the system contain 30 not responsible for maintaining the data but for holding confidential information belonging to the database the attempt to synchronize the created indexes and a related problem The goal is to prevent it from happening. 4 The invention relates to indexing and document comparison performed by a database synchronization unit. to avoid performance issues during the cycle, in as little as an hour It recommends repeating the process. This will help prevent potential issues from arising between the two databases. The goal is for the difference to be much smaller, but if this value is desired, the system's resource status... Alternatively, it can be configured with different values ​​depending on the amount of data in the system. 5 In addition, the invention enables the comparison of the database synchronization unit in the database index. Instead of all the documents found, only those produced within a specific time period or He recommends that they do this by looking at the updated documentation. The main reason for this is that the work done... to prevent any performance problems that may occur during the comparison process It is passing. The invention suggests a time interval of one day, but this period is still 10 with different values ​​depending on the system's density and available resources. It is configurable. The comparison process, based on this setting proposed by the invention, is a final day. This is done on documents that have been produced or updated within it. Found in indexes. The documents from previous dates are in the state of the database synchronization unit in previous cycles. Since they have already been checked and equalized if necessary, a recheck is not required for them. There is no need. In this way, input files arriving at geographically redundant analytical systems regardless of whether the systems are synchronized or not This ensures that the databases in the system are synchronized in terms of content. The invention proposes 20 Thanks to this system and method, even if the input files are the same, errors that may occur in the system can be prevented. differences that may arise due to any software or hardware errors Potential errors are prevented thanks to databases that are structured in an active-active manner. database resulting from failover operations that may occur in these situations This will also prevent problems from occurring. 25 The structural and characteristic features and all the advantages of the invention are given in the figures below. This becomes clearer thanks to the detailed explanation written with references to these figures. It will be understood. Explanation of the Figures Figure 1 is a schematic view of the system described in the invention. Figure 2 shows the flowchart of the method described in the invention. 35 The drawings do not necessarily need to be scaled and are useful for understanding the invention. Unnecessary details may have been omitted. Explanation of Part References 1. Analytical system 2. Database 3. Database synchronization unit 1001. The analytical systems (1) that are installed redundantly in two different geographic regions and these 10 databases (2) built on systems (1) will work in an active-active manner structuring 1002. Database that operates in a specific period and is located on the analytical system (1). The synchronization unit (3) connects to both analytical systems (1) and to the database (2) Comparing the index list and the documents in the indexes 15 1003. Database synchronization unit (3), index list and documents in the indexes evaluating the result of the comparison process 1004. As a result of the comparison, a document in an index in the database (2) data In the analytic system where the base equalization unit (3) is located, (1) is not found, but other If it is in the analytical system (1), the database synchronization unit of the relevant document is 20 (3) retrieved from the database (1) of the other analytical system (2) and local analytical (2) recording in the (1) database in the system 1005. As a result of the comparison process, both analytical values ​​of a document in an index... In the case where (1) is also in the system but there is a difference in content, the most The document with the most recent date will be accepted as correct, and the relevant document will be considered older than 25. (1) updating the database (2) in the analytical system that has the document 1006. After the comparison process, the index in the database (2) is found all documents are identical in both analytical systems in terms of number and content (1) In this case, the database synchronization unit confirms that the comparison was successfully performed. (3) reported and put on hold for the next comparison process 30 1007. Database synchronization unit (3), index list and document comparison reporting all successful and unsuccessful outcomes in the processes 6 Detailed Description of Find In this detailed explanation, the preferred configurations of the invention are not merely for better understanding the subject. in order to facilitate understanding and without imposing any limiting effects It is explained. 5 The system in question is an analytical system installed redundantly in different geographical regions (1) databases located on it and configured to work in an active-active manner (2) It ensures equalization. Analytical systems (1) are found in communication and information systems. It reads and processes numerous input files sent to it, then saves them and creates the necessary 10 These are systems that generate reports and visual graphics. Input to the analytical system (1) after being processed from the files, to be used in necessary reports and visual graphics. All recorded data and system configuration information are stored in databases (2) is kept. The system also connects to the database (2) of both analytical systems (1). Comparing the indexes and documents in the database (2) and finding a difference 15 In case of missing or incorrect document, the data of the analytical system on the other side (1) Database synchronization unit (3) which performs data synchronization by taking and saving from the base (2) It is located there. The invention concerns the workflow in the method, which involves analytical systems established redundantly in two different geographical regions. active-active systems (1) and databases (2) built on these systems (1) It starts with configuring it to work (1001). After the systems are installed, different After the input files from the sources are read and processed by the analytical system (1) then the database (2) located on the analytical system (1) that performs the operation They are recorded and thus data is in both databases (2) which work in an active-active manner. It starts to accumulate. After that, the database that runs for a certain period and is on the analytical system (1) The synchronization unit (3) connects to both analytical systems (1) and indexes in the database (2). compares the list and the documents in the indexes (1002). 30 included in the comparison process unwanted and related to the settings of the database (2) and specific to the database (2) Indexes containing documents are determined during the setup phase of the analytical system (1) and a is saved to the configuration file. Thus, the database synchronization unit (3) saves these indexes to the configuration file. It does not include it in the comparison process. In the next step, the database synchronization unit (3), 7 the index list and the result of the process of comparing the documents in the indexes evaluates (1003). As a result of the comparison, a document in an index in the database (2) is in the database The equalization unit (3) is not found in the analytic system (1) but is found in the other analytic system 5 (1) In the case where it is located, the relevant document database synchronization unit (3) by the other retrieved from the (1) database of the analytical system (2) and transferred to the (1) database in the local analytical system (2) is recorded (1004). As a result of the comparison process, each of the documents in an index In the case where (1) it exists in both analytical systems but there is a difference in content, The document with the most recent date is considered correct, and the relevant document is rejected as the incorrect document. The database (2) in the analytical system (1) is updated (1005). After the comparison process, all of the indexes in the database (2) If the documents are identical in both analytical systems in terms of number and content (1), 15 by the database synchronization unit (3) where the comparison was successfully made It is reported and put on hold for the next comparison process (1006). Finally, database synchronization unit (3), index list and document comparison operations Reports of all successful and unsuccessful cases (1007). These reports are given to system administrators. (1) Performance and health of both analytical systems operating in geographical redundancy It also provides an opportunity to evaluate their status. For example, both analytical 20 input files If it is sent to the system (1) in the same way, in an analytical system (1) continuously document loss occurs and this loss is always retrieved from the database on the other side (2) If this is resolved, this situation is addressed in the relevant analytical system (1) file processing and saving. This indicates that there may be a software or hardware error during the process. Thus, it has been established with geographical redundancy to provide uninterrupted service, and both both themselves and the databases on them (2) will work actively. synchronization of data in both databases (2) in structured analytical systems (1) This has been done and the reports and visuals produced by both systems (1) This ensures the consistency of the statistics in the graphs. This proposed method and system 30 Thanks to this, they are installed at the same level in terms of software and hardware and use the same input files. Despite receiving them, they have different data due to various software and hardware problems. As data synchronization is ensured in analytical systems (1), some input files due to restrictions or inadequacies it can only be sent to one system (1) In these situations, especially in systems with a large amount of data, failover operations are necessary. 35 8 The database (2) needs to be configured in active-standby mode, which creates problems. Without this, the data in both analytical systems (1) are synchronized.

Claims

9 REQUESTS 1. Analytical systems (1) that are installed redundantly in different geographic regions and the method of synchronizing databases (2) configured to work in an active-active manner. and its feature is; 5  data located on analytical systems (1) and working in a specific period The base equalization unit (3) connects to both analytic systems (1) to provide data. Comparing the index list (2) and the documents in the indexes in its base,  database synchronization unit (3), index list and documents in the indexes As a result of the comparison; 10 a document in an index in that database (2) database synchronization (1) is not in the analytical system where unit (3) is located, other analytical If the relevant document is in the system (1), the database synchronization unit (3) by other analytical system (1) data taken from the base (2) and transferred to the database (1) in the local analytical system (2) 15 recording, a document in an index is found in both analytical systems (1) However, in case of discrepancies in content, refer to the most recent date. the document in question is accepted as correct and the related document is incorrect in the database (2) 20 in the analytical system (1) that has the document updating, the number of all documents in an index (2) in that database If the content is the same in both analytical systems (1), Database synchronization confirms that the comparison was successfully completed. reported by unit (3) and 25 for the next comparison process. going into waiting mode,  Database synchronization unit (3), index list and document comparison It is the process of reporting both successful and unsuccessful outcomes in its operations.

2. The 30 analytical systems (1) that are installed redundantly in different geographic regions synchronization of databases (2) configured to work in an active-active manner It is a system that provides; its feature is that it has databases (2) belonging to both analytical systems (1) by connecting and comparing the indexes and documents in the database (2) In case of discrepancies, the missing or correct document should be sent to the analytics side. the database that performs data synchronization by retrieving (1) data from (2) the system database It contains the equalization unit (3).

Images