Information system data dictionary translation sequencing method and apparatus

Abstract

The application provides an information system data dictionary translation and sorting method and device, which is applied to a server. The server obtains a query result according to a query request of a client, and sorts the query result according to a sorting rule. The server reads a cached data dictionary. The server translates and labels a field by using the cached data dictionary, and obtains a translated field. The server returns the translated field and the labeled field to the client. The existing information system data dictionary design has the problems of low query efficiency and difficulty in sorting when the query result is large. The application translates by using the cached data dictionary, reduces the use of the data dictionary of the database, and reduces the performance pressure of the database. The application also supports a Chinese pinyin sorting rule and a dictionary maintenance time sorting rule, is more in line with the user query habit, and takes into account the ease of use and flexibility.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of translation sorting, in particular to an information system data dictionary translation sorting method and device. BACKGROUND

[0002] At present, the common information system data dictionary design on the market is to keep the data dictionary in the database, associate the data dictionary table through database join table query, translate the dictionary items into business description for display, or read the value of the dictionary table into the application for translation at the application level.

[0003] However, when the query result is large, the method of using database join table query will cause the query efficiency to be reduced and the response time to be prolonged. SUMMARY

[0004] In view of the above-mentioned shortcomings of the prior art, the present application provides an information system data dictionary translation sorting method and device, which further improves the translation and query efficiency.

[0005] The first aspect of the present application provides an information system data dictionary translation sorting method, comprising:

[0006] The server obtains the query result according to the query request of the client, and sorts the query result according to a sorting rule; wherein the cached data dictionary and the data dictionary of the database are synchronized;

[0007] The server reads the cached data dictionary; wherein the cached data dictionary and the data dictionary of the database are synchronized;

[0008] The server translates the marked field using the cached data dictionary, obtains the translated field, and saves the translated marked field and the translated field;

[0009] The server returns the translated field in the cache and the marked dictionary to the client;

[0010] Optionally, the sorting of the query result according to the sorting rule comprises:

[0011] The server sorts the query result according to a Chinese pinyin sorting rule;

[0012] Alternatively,

[0013] The server sorts the query result according to a dictionary maintenance time sorting rule;

[0014] Optionally, the information system data dictionary translation sorting method further comprises:

[0015] The server generates a new dictionary item according to a new request of the client; wherein a dictionary item code of the new dictionary item corresponds to information carried by the new request;

[0016] The server saves the new dictionary item in the database;

[0017] The server synchronously updates the new dictionary item in the database to the cache.

[0018] Optionally, the server synchronously updates the new dictionary item and the dictionary item code in the database to the cache, comprising:

[0019] The server triggers the stream computing engine to synchronously update the new dictionary item and the dictionary item code in the database to the cache.

[0020] The second aspect of the present application provides a device for information system data dictionary translation and sorting, comprising:

[0021] A sorting unit is configured to obtain the query result according to the query request of the client, and sort the query result according to a sorting rule; wherein the query result comprises at least one marked field;

[0022] A reading unit is configured to read the cached data dictionary of the server; wherein the cached data dictionary is synchronized with the data dictionary of the database;

[0023] A translation unit is configured to translate the marked field using the cached data dictionary to obtain a translated field;

[0024] A returning unit is configured to return the translated field and the marked field to the client;

[0025] A maintenance unit is configured to maintain the data dictionary.

[0026] Optionally, when the sorting unit sorts the query result according to the sorting rule, it is specifically configured to:

[0027] Sort the query result using a Chinese pinyin sorting rule;

[0028] Or,

[0029] Sort the query result using a dictionary maintenance time sorting rule.

[0030] Optionally, the maintenance unit maintains the data dictionary, and is specifically configured to:

[0031] The server generates a new dictionary item according to a new request of the client; wherein the dictionary item code of the new dictionary item corresponds to information carried by the new request;

[0032] The server saves the new dictionary item in the database;

[0033] The server synchronously updates the new dictionary item in the database to the cache.

[0034] Optionally, when the maintenance unit synchronously updates the new dictionary item in the database to the cache, it is specifically used for:

[0035] The server triggers the stream computing engine to synchronously update the new dictionary item in the database to the cache.

[0036] The application provides an information system data dictionary translation and sorting method and device, the method comprising: the server obtains the query result according to the user query request, and sorts the query result according to the sorting rule; wherein the data dictionary of the cache and the data dictionary of the database are synchronized; the server reads the data dictionary of the cache; wherein the data dictionary of the cache and the data dictionary of the database are synchronized; the server translates and labels the field using the data dictionary of the cache, obtains the translated field, and saves the translated and labeled field and the translated field; and the server returns the translated field in the cache and the labeled dictionary to the client. The present scheme can use the cached data dictionary for translation, reduce the number of database accesses, and further improve the efficiency of translation and query by providing a Chinese pinyin sorting method. BRIEF DESCRIPTION OF DRAWINGS

[0037] In order to more clearly illustrate the technical solutions in the embodiments of the present application or the prior art, the drawings needed to be used in the embodiments or prior art description will be briefly introduced. Obviously, the drawings in the following description are only embodiments of the present application, and those skilled in the art can obtain other drawings according to the provided drawings without creative labor.

[0038] Figure 1 A flowchart of an information system data dictionary translation and sorting method provided by the embodiments of the present application;

[0039] Figure 2 A general design diagram of a data dictionary system provided by the embodiments of the present application;

[0040] Figure 3 A flowchart of another information system data dictionary translation and sorting method provided by the embodiments of the present application;

[0041] Figure 4 The flowchart of the data dictionary maintenance provided by the embodiment of the present application;

[0042] Figure 5 The schematic diagram of the marked field provided by the embodiment of the present application;

[0043] Figure 6 The structural schematic diagram of the device for information system data dictionary translation and sorting provided by the embodiment of the present application. DETAILED DESCRIPTION

[0044] The technical solutions in the embodiments of the present application will be described clearly and completely below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, rather than all the embodiments of the present application. Based on the embodiments in the present application, all the other embodiments obtained by those skilled in the art without creative work fall within the protection scope of the present application.

[0045] Please refer to Figure 1 The flowchart of the information system data dictionary translation and sorting method provided by the embodiment of the present application.

[0046] In order to facilitate the understanding of the method provided by the present embodiment, the system for implementing the method will be briefly introduced, please refer to Figure 2 The overall design diagram of the data dictionary system for implementing the method. The system includes a client, a server, the server includes a database, a cache and a stream computing engine.

[0047] Among them, the client and the server realize information interaction, the server can use the data dictionary of the database and the cache for translation and sorting, and the data dictionary of the database and the cache can realize data synchronization through the stream computing engine.

[0048] The method includes the following steps.

[0049] S101, the server obtains the query result according to the query request of the client, and sorts the query result according to the sorting rule.

[0050] Among them, the query result includes at least one marked field.

[0051] The client sends a query request to the server, requesting to obtain the related query result, wherein the query result includes at least one marked field. Please refer to Table 1, in the present embodiment, the query result can be transaction data, the marked field can be the trader in the transaction data, and the specific content of the marked field can be ZS00001.

[0052] Table 1

[0053]

[0054]

[0055] Each row of data in Table 1 corresponds to a dictionary item, and it can be seen that a dictionary item in the embodiment can include a dictionary code, a dictionary item code, a Chinese abbreviation, a Chinese full name, and a maintenance date, etc. The maintenance date can be understood as the date when the dictionary item was last updated.

[0056] After the client initiates a query, the server sorts the query results according to the sorting rule information carried in the query request. When the query request requires the query results to be sorted using the Chinese pinyin sorting rule, the server encodes and sorts the dictionary items according to the Chinese pinyin sorting rule.

[0057] For ease of illustration, it is assumed that the query results include the dictionary item codes corresponding to the names of the traders, for example, LS00001, LS00002, and ZS00001, respectively. It can be understood that the query sorting method of the example can be applied to multiple data, and the embodiment is not limited. According to the Chinese pinyin sorting rule, the data to be queried is sorted, and the sorting result is: LS00001, LS00002, and ZS00001.

[0058] When the query request requires the query results to be sorted using the dictionary maintenance time sorting rule, the server queries the database to obtain the statistical information of the dictionary items involved in the query results, and sorts them from new to old according to the dictionary maintenance time, which is shown as the maintenance date in Table 1.

[0059] For example, it is assumed that the query results still include LS00001, LS00002, and ZS00001. According to the dictionary maintenance time sorting rule, the data to be queried is sorted, and the sorting result is: ZS00001, LS00002, and LS00001.

[0060] The above-mentioned sorting of the query results by the server using the Chinese pinyin sorting rule and the dictionary maintenance time sorting rule has the advantage that the Chinese pinyin sorting rule is more in line with user query habits and has better usability.

[0061] S102, the server reads the cached data dictionary.

[0062] The cached data dictionary and the data dictionary of the database are synchronized.

[0063] When the client accesses the newly added function of the data dictionary provided by the server, the server will maintain the data dictionary, and the process diagram of the dictionary maintenance is as follows: Figure 4The service end maintains the data dictionary, which can specifically include that the service end adds a dictionary item in the data dictionary, or deletes or modifies the dictionary item, etc.

[0064] The process of adding a dictionary item in the data dictionary by the service end can include:

[0065] Dictionary maintenance. That is, the service end receives an addition request for adding a dictionary item from the client;

[0066] Generating a dictionary item code. That is, the service end generates an added dictionary item according to the addition request of the client; wherein the dictionary item code of the added dictionary item corresponds to the information carried in the addition request;

[0067] Data dictionary warehousing. That is, the service end saves the added dictionary item in the database;

[0068] Synchronous update of cache, that is, the service end synchronously updates the added dictionary item in the database to the cache.

[0069] The specific implementation of generating an added dictionary item by the service end according to the addition request of the client can be:

[0070] The addition request of the client contains the Chinese full name of the added dictionary item, according to the dictionary item code generation rule, the service end will take the first N letters of the Chinese full name of the added dictionary item as the prefix of the dictionary item code of the added dictionary item, and then fill in M digits after the prefix, when the prefixes of multiple dictionary item codes are the same, the digits of these dictionary item codes are incremented one by one.

[0071] Exemplarily, N can be set to 2, and M can be set to 5, or can also be set to other positive integers according to needs, which is not limited in the embodiment.

[0072] Exemplarily, as shown in Table 1, it is assumed that the Chinese full names of the added dictionary items are respectively Zhang San, Li Si and Li Si, according to the dictionary item code generation rule, the prefixes of the dictionary item codes of the added dictionary items are respectively ZS, LS and LS, since the prefixes of Li Si and Li Si are the same, the digits of the dictionary item codes corresponding to Li Si and Li Si are respectively determined as 00001 and 00002, so the dictionary item codes after filling in the digits are respectively ZS00001, LS00001 and LS00002, and the digits after the prefixes are incremented to distinguish the dictionary items with the same prefix.

[0073] After determining the dictionary item code, the service end determines the dictionary item code, the corresponding Chinese full name and other information as an added dictionary item.

[0074] The service end saves the generated added dictionary item in the database, and triggers the stream computing engine to synchronize the added dictionary item to the cache, and the cache can adopt memory or redis, which is not limited in the embodiment.

[0075] When the client accesses the data dictionary deletion, modification, and query functions provided by the server, the stream computing engine will listen to the data dictionary in the database in real time. When the data dictionary in the database changes due to the client accessing the deletion, modification, and query functions provided by the server, the stream computing engine will synchronously update the changed part to the cache.

[0076] For example, it is assumed that the client needs to delete the dictionary item of Zhang San in Table 1 or modify some information in the dictionary item of Zhang San. The stream computing engine listens to the information that the dictionary item is deleted or modified in the data dictionary in the database and synchronously updates it to the cache in real time, so that the data dictionary in the cache and the data dictionary in the database are kept synchronized.

[0077] The advantage of the above-mentioned server reading the cached data dictionary for dictionary translation is that the number of times of accessing the data dictionary in the database can be reduced by accessing the cached data dictionary, thereby reducing the pressure on the database and improving the efficiency of data dictionary translation and server query.

[0078] In S103, the server translates the marked field using the cached data dictionary to obtain a translated field and saves the marked field and the translated field.

[0079] The server responds to the query request of the client, marks the field using the cached data dictionary in the application layer, and the subsequent application layer translates the corresponding field according to the marking information.

[0080] In this embodiment, the marking method is taken as an example of a java project, and the specific marking method is not limited.

[0081] For example, the server sets a marked field and a translated field in the application layer and annotates the marked field to mark the source of the data dictionary and the corresponding field after translation. Specifically, as shown in Figure 5 , vluSex is the marked field, the value queried from the database is saved to the field, vluSexNam saves the translated data, and the @AutoTranslate annotation and parameter mark which dictionary is translated according to.

[0082] The server parses the marked field in the application layer and translates the marked field using the cached data dictionary.

[0083] For example, it is assumed that the result of the query of the client is transaction data, the marked field is the trader in the transaction data, and the specific content of the marked field is ZS00001. The server translates the specific content ZS00001 of the marked field into Zhang San using the cached data dictionary.

[0084] The server puts the translation result into the translated field and saves the marked field and the translated field in the cache.

[0085] In S104, the server returns the translated field and the marked field to the client.

[0086] The server returns the translated and sorted query result to the client in response to the query request of the client, and the client provides an interface to display the query result returned by the server.

[0087] See Figure 3 Another flowchart of the information system data dictionary translation and sorting method provided in the embodiments of the present application is shown in FIG. 2. The method includes the following steps.

[0088] In S201, the client initiates a query request.

[0089] The query request includes a sorting rule. In the embodiments, the query request can include any one of the Chinese pinyin sorting rule and the dictionary maintenance time sorting rule. In other optional embodiments, the query request can include other sorting rules different from the two sorting rules, which are not limited in the embodiments.

[0090] In S202, the server queries the number distribution of the dictionary items involved in the query result set.

[0091] The result set includes the query result, and the query result includes the dictionary item code in the involved dictionary item.

[0092] Taking Table 1 as an example, the query result involves the first dictionary item in Table 1, and correspondingly, the query result includes the dictionary item code of the first dictionary item in Table 1, i.e., ZS00001.

[0093] The server queries the database according to the query request of the client to obtain the information of the dictionary items involved in the query result.

[0094] For example, taking the trader dictionary in Table 1 as an example, it can be assumed that the query result involves the dictionary items to which ZS00001, LS00001 and LS00002 belong, wherein ZS00001 has 8 data, LS00002 has 5 data, and LS00001 has 7 data. The type and data amount of the dictionary items are set to other positive integers, which are not limited in the embodiments.

[0095] In S203, the server reads the maintenance time of the involved dictionary items and sorts the dictionary items according to the maintenance time.

[0096] The server reads the maintenance time of the involved dictionary items and sorts the dictionary items according to the dictionary maintenance time sorting rule. The specific way of sorting the dictionary items according to the dictionary maintenance time sorting rule can be referred to step S101.

[0097] S204, the server paginates the query results involved.

[0098] The server paginates the query results, and can set the current data page size, such as setting one page to store 10 data, or can be set to other positive integers according to the needs, and the embodiment is not limited.

[0099] Continuing the example of step S202, the first page should be composed of 8 ZS00001 dictionary item data and 2 LS00002 data, and the second page stores data composed of 3 LS00002 dictionary item data and 7 LS00001 dictionary item data remaining in the first page.

[0100] S205, the server translates the dictionary items involved.

[0101] The server uses the cached data dictionary to translate the dictionary items involved, and the translation method is as described in step S103.

[0102] S206, the server adds the dictionary items involved to the result set and caches at the same time.

[0103] The server adds the sorted, paginated and translated dictionary items to the result set and caches at the same time.

[0104] S207, the server sorts the dictionary items involved according to the dictionary item code.

[0105] The server reads the dictionary item code of the dictionary items involved, and sorts the dictionary items involved according to the Chinese pinyin sorting rule, which is as described in step S101.

[0106] S208, the server reads the sorted dictionary items involved.

[0107] The server reads the sorted dictionary items involved according to the query request of the client.

[0108] S209, the server parses the annotation field.

[0109] The server parses the annotation field of the application layer.

[0110] S210, the server reads the cached data dictionary according to the annotation field.

[0111] The server reads the cached data dictionary according to the annotation field.

[0112] S211, the server translates the annotation field and saves it to the translated field.

[0113] The server translates the label field using the cached data dictionary, the translation method being as described in step S103, and saves the translated result in the translated field.

[0114] The server returns the query result to the client.

[0115] The server returns the translated and sorted query result to the client, and the client provides an interface to display the query result returned by the server.

[0116] Figure 1 The S101 step includes the S201 to S204 and S207 to S208 steps of Figure 3 . The S102 step includes the S209 to S210 steps of . The S103 step includes the S205 to S206 and S211 steps of

[0117] . The S104 step includes the S212 step of Figure 1 . The S105 step includes the S213 step of Figure 3 . The S106 step includes the S214 step of . The S107 step includes the S215 step of

[0118] . The S108 step includes the S216 step of Figure 1 . The S109 step includes the S217 step of Figure 3 . The S110 step includes the S218 step of . The S111 step includes the S219 step of

[0119] . The S112 step includes the S220 step of Figure 1 . The S113 step includes the S221 step of Figure 3 . The S114 step includes the S222 step of . The S115 step includes the S223 step of

[0120] . The present application provides an information system data dictionary translation and sorting method, which comprises the following steps: a server acquires a query result according to a user query request and sorts the query result according to a sorting rule; wherein a cached data dictionary and a database data dictionary are synchronized; the server reads the cached data dictionary; wherein the cached data dictionary and the database data dictionary are synchronized; the server translates a label field using the cached data dictionary, obtains a translated field, and saves the translated label field and the translated field; and the server returns the translated field in the cache and the label dictionary to the client. The present application can use the cached data dictionary for translation, reduces the number of times of accessing the database, and further improves the efficiency of translation and query by providing a Chinese pinyin sorting method.

[0121] According to the information system data dictionary translation and sorting method provided in the embodiments of the present application, the embodiments of the present application further provide an information system data dictionary translation and sorting device, which is shown in Figure 6 , which is a structural schematic diagram of the device. The device can include the following units.

[0122] The sorting unit 601 is configured to acquire a query result according to a query request of a client and sort the query result according to a sorting rule; wherein the query result includes at least one label field.

[0123] The reading unit 602 is configured to read the cached data dictionary by the server; wherein the cached data dictionary and the data dictionary of the database are synchronized;

[0124] The translating unit 603 is configured to translate the annotation field by using the cached data dictionary by the server, to obtain a translated field;

[0125] The returning unit 604 is configured to return the translated field and the annotation field to the client by the server;

[0126] The maintaining unit 605 is configured to maintain the data dictionary by the server.

[0127] Optionally, when the sorting unit 601 sorts the query result according to the sorting rule, the sorting unit 601 is specifically configured to:

[0128] sort the query result according to a Chinese pinyin sorting rule;

[0129] or,

[0130] sort the query result according to a dictionary maintenance time sorting rule.

[0131] Optionally, the maintaining unit 605 maintains the data dictionary, and the maintaining unit 605 is specifically configured to:

[0132] generate a new dictionary item by the server according to a new request of the client; wherein the dictionary item code of the new dictionary item corresponds to the information carried by the new request;

[0133] save the new dictionary item in the database by the server;

[0134] update the new dictionary item in the database to the cache by the server.

[0135] Optionally, when the maintaining unit 605 updates the new dictionary item in the database to the cache, the maintaining unit 605 is specifically configured to:

[0136] trigger the stream computing engine to update the new dictionary item in the database to the cache by the server.

[0137] The information system data dictionary translation and sorting device provided in the embodiment can refer to the related steps in the information system data dictionary translation and sorting method provided in any embodiment of the present application for its specific working principle, which will not be repeated here.

[0138] The application provides an information system data dictionary translation and sorting device, which comprises a sorting unit 601, a reading unit 602, a translation unit 603, a returning unit 604 and a maintenance unit 605. The sorting unit 601 is used for obtaining a query result according to a query request of a client and sorting the query result according to a sorting rule. The query result comprises at least one marked field. The reading unit 602 is used for reading a cached data dictionary by a server. The cached data dictionary is synchronized with a data dictionary of a database. The translation unit 603 is used for translating the marked field by using the cached data dictionary to obtain a translated field. The returning unit 604 is used for returning the translated field and the marked field to the client by the server. The maintenance unit 605 is used for maintaining the data dictionary by the server. The data dictionary can be translated by using the cached data dictionary, the number of times of accessing the database is reduced, a Chinese pinyin sorting method is provided, and the translation and query efficiency is further improved.

[0139] Finally, it should be noted that the relational terms herein, such as first and second, are used solely to distinguish one from another entity or action without necessarily requiring or implying any actual relationship or order between such entities or actions. Moreover, the terms "comprises", "comprising", or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but can include other elements not expressly listed or inherent to such process, method, article, or apparatus. An element proceeded by "comprises... a" does not, without more constraints, exclude the existence of additional identical elements in the process, method, article, or apparatus that comprises the element.

[0140] It should be noted that the terms "first", "second", and the like in the specification and claims of this application are used only to distinguish one entity or action from another, and do not necessarily require or imply any actual relationship or order between such entities or actions. Moreover, the terms "comprises", "comprising", or any other variation thereof are intended to cover non-exclusive inclusion, so that a process, method, article, or apparatus that includes a list of elements does not include only those elements, but also includes other elements not expressly listed or inherent to such process, method, article, or apparatus. An element preceded by "comprises a" does not exclude the existence of additional identical elements in the process, method, article, or apparatus that includes the element.

[0141] A person skilled in the art can implement or use the present application. Various modifications to these embodiments will be apparent to those skilled in the art, and the general principles defined herein can be implemented in other embodiments without departing from the spirit or scope of the application. Therefore, the present application will not be limited to the embodiments shown herein, but will conform to the widest scope consistent with the principles and novel features disclosed herein.

Claims

1. A method for translating and sorting data dictionaries in an information system, characterized in that, Applied to the server side, the information system includes a client, a database, a server, and a cache, and the method includes: The server obtains query results based on the client's query request, wherein the query results include at least one annotation field; the query results contain any one of the sorting rules between Chinese Pinyin sorting rules and dictionary maintenance time sorting rules; the query results include dictionary item codes of the relevant dictionary items; If the sorting rule in the query results is Chinese Pinyin sorting rule: The server reads the dictionary entry codes of the relevant dictionary entries and sorts the relevant dictionary entries according to the Chinese Pinyin sorting rules; The server reads the sorted dictionary entries based on the client's query request; The server parses the annotation fields of the application layer and reads the cached data dictionary based on the annotation fields; the cached data dictionary and the database data dictionary are synchronized. The server uses the cached data dictionary to translate the labeled fields, obtains the translated fields, and saves the labeled fields and the translated fields. The server returns the translated fields and the labeled fields to the client. If the sorting rule in the query results is dictionary maintenance time sorting rule: The server queries the database based on the client's query request to obtain information about dictionary items involved in the query results; The server reads the maintenance time of the relevant dictionary items and sorts them according to the maintenance time. The server then paginates the sorted query results. The server reads the cached data dictionary; The server uses the cached data dictionary to translate the labeled fields, obtains the translated fields, and saves the labeled fields and the translated fields. The server returns the translated fields and the labeled fields to the client.

2. The method according to claim 1, characterized in that, Also includes: The server generates new dictionary entries based on the client's new request; wherein the dictionary entry code of the new dictionary entry corresponds to the information carried in the new request; The server stores the newly added dictionary entries in the database; The server synchronizes the newly added dictionary entries in the database to the cache.

3. The method according to claim 2, characterized in that, The server synchronizes the newly added dictionary entries in the database to the cache, including: The server-side trigger stream computing engine synchronously updates the cache with newly added dictionary entries from the database.

4. A data dictionary translation and sorting device for an information system, characterized in that, include: A sorting unit is used by the server to obtain query results based on the client's query request. If the sorting rule in the query results is a Chinese Pinyin sorting rule: the server reads the dictionary item codes of the involved dictionary items and sorts the involved dictionary items according to the Chinese Pinyin sorting rule; if the sorting rule in the query results is a dictionary maintenance time sorting rule: the server queries the database based on the client's query request to obtain information about the involved dictionary items in the query results; reads the maintenance time of the involved dictionary items and sorts them according to the maintenance time; wherein, the query results include at least one annotation field; the query results contain any one of the sorting rules of Chinese Pinyin sorting rule and dictionary maintenance time sorting rule; the query results include the dictionary item codes of the involved dictionary items; The reading unit is configured to: if the sorting unit performs Chinese Pinyin sorting: the server reads the sorted dictionary entries based on the client's query request; parses the application layer annotation fields and reads the cached data dictionary based on the annotation fields; if the sorting unit performs dictionary maintenance time sorting: the server paginates the sorted query results; and reads the cached data dictionary; wherein the cached data dictionary is synchronized with the database data dictionary; The translation unit is used by the server to translate the labeled fields using the cached data dictionary to obtain the translated fields; The return unit is used by the server to return the translated fields and the labeled fields to the client; A maintenance unit is used by the server to maintain the data dictionary.

5. The apparatus according to claim 4, characterized in that, The maintenance unit maintains the data dictionary, specifically for the following purposes: The server generates new dictionary entries based on the client's new request; wherein the dictionary entry code of the new dictionary entry corresponds to the information carried in the new request; The server stores the newly added dictionary entries in the database; The server synchronizes the newly added dictionary entries in the database to the cache.

6. The apparatus according to claim 4, characterized in that, The maintenance unit is also used for: The server-side trigger stream computing engine synchronously updates the cache with newly added dictionary entries from the database.

Images