Method, system and equipment for detecting database naming specifications and medium

Abstract

The invention discloses a method, system and device for detecting database naming specifications and a medium. The method comprises the steps that meta-information is synchronized, and the meta-information is synchronized from a database of a service system; standard vocabulary query: querying whether the description information has a corresponding English name in a standard vocabulary library; performing word segmentation processing, namely performing word segmentation processing on the description information of which the corresponding English name is not found by using a word segmentation device; vocabulary filtering and translating: filtering the segmented vocabularies, obtaining English abbreviations corresponding to the vocabularies, and splicing the English abbreviations into field name candidates; result comparison and judgment: comparing results after word segmentation of each word segmentation device; and naming specification judgment and translation failure processing. By means of the method, it can be ensured that table names and field names in the database follow the unified naming specification, the standardization level of the whole data warehouse or database is improved, data consistency and interoperability between different systems can be achieved, and element names in the data warehouse are clearer and more significant due to the unified naming specification.

Description

Technical Field

[0001] The present invention belongs to the field of data management and data governance, and relates to a method, system, device and medium for detecting database naming specifications. Background Art

[0002] With the continuous deepening of enterprise informatization construction, various business systems have increased rapidly, and the demand for data interaction and sharing between systems has become increasingly urgent. As the core platform for enterprise big data processing and analysis, the importance of data warehouse is self-evident. However, when extracting, integrating and processing data from different business systems, data warehouses face many challenges, especially the problem of non-standard data field naming. The development teams of various business systems often name database fields based on their own habits and understanding, which leads to the fact that even fields describing the same entity or attribute may have completely different names in different systems. This inconsistency in field naming has brought multiple difficulties to the construction and management of data warehouses.

[0003] Unstandardized field naming directly increases the difficulty for data warehouse developers to understand the meaning of fields. It not only requires developers to have extensive business knowledge and deep database skills, but also takes a lot of time to communicate and confirm between systems, which significantly reduces development efficiency. In the data integration stage, faced with huge differences in field naming between different systems, developers have to take complex logic and additional steps to identify and map these fields, which greatly increases the complexity and cost of data integration. Unstandardized field naming makes it difficult to track data quality issues, especially when data errors or anomalies occur, it is difficult to quickly locate the source of the problem, affecting the accuracy and reliability of the data. In the data conversion process, due to the ambiguity and inconsistency of field naming, incorrect data mapping and conversion are prone to occur, which in turn affects the accuracy of subsequent data analysis and decision-making. When building a data model, unstandardized field naming increases the uncertainty and complexity of model design, affects the quality and performance of the data model, and reduces the overall effectiveness of the data warehouse. Data governance is a systematic project, including data standardization, metadata management and other aspects. Unstandardized field naming significantly increases the difficulty and complexity of data governance and increases the management cost of the enterprise. Inappropriate field naming reduces the discoverability and accessibility of data, making it difficult for users to quickly find the data resources they need, thus affecting the reuse value of data.

[0004] In order to meet these challenges, there are some technical attempts on the market, such as script-based field naming format detection methods and simple field translation tools. However, these methods have obvious limitations: the former can only detect the format standardization of field naming, and cannot solve the problem of inconsistent naming from a semantic level; although the latter provides certain translation functions, it lacks real-time and dynamic performance, and is difficult to adapt to complex business scenario changes.

[0005] Therefore, it is necessary to develop a more advanced and comprehensive technical solution to solve the problem of inconsistent field naming in data warehouse construction. Summary of the invention

[0006] The purpose of the present invention is to solve the problem of inconsistent field naming in data warehouse construction in the prior art, and to provide a method, system, device and medium for detecting database naming specifications.

[0007] In order to achieve the above object, the present invention adopts the following technical solutions: A method for detecting a database naming specification comprises the following steps: Synchronize meta information, including table name, field name, table description information and field description information in the database, from the business system database; Standard vocabulary query, query the preset standard vocabulary library to see whether the obtained table description information and field description information have corresponding English names. If the corresponding English name is found, determine the naming standard of the table name or field name; if not found, continue to execute the subsequent steps; Word segmentation: Use multiple word segmenters to segment the description information for which no corresponding English name is found; Vocabulary filtering and translation: filter the segmented words, obtain the English abbreviations corresponding to the words by querying the maintained dictionary database, and assemble them into field name candidates according to preset rules; Compare and judge the results. Compare the results of each word segmenter and use the number of Chinese characters in the result as the judging standard. If the word segmentation result does not contain Chinese characters, the translation is considered successful and the naming standard determination step is entered; otherwise, the translation failure processing step is entered; Naming standard determination: compare the successfully translated field name candidates with the existing field names. If they are inconsistent, the field will be marked as non-standardly named and recorded and reviewed; Translation failure processing: If the translation results contain unmatched Chinese words, the field name, Chinese description of the field, word segmentation results, translation results, and Chinese words that are not matched in the dictionary are recorded.

[0008] The synchronization meta information is specifically: Table information extraction: query the system table or information model table of the database to extract the names and description information of all user-defined tables; Field information extraction: for each table, query its field information, including field name, data type, length limit and field description information; Meta-information organization and storage: the extracted table names, field names, table description information, and field description information are organized in a format and synchronized.

[0009] The standard vocabulary query is specifically: Prepare a standard vocabulary database, and establish a standard vocabulary database containing Chinese field names and their corresponding English names; Obtain the description information to be queried, and extract the table name, field name and their corresponding description information from the database of the business system; Perform a query operation, for each description information, perform a query operation in the standard vocabulary database to find out whether there is an English name that completely matches it or has a similarity that reaches a certain threshold; Determine the naming standard. If the query result finds the corresponding English name in the standard vocabulary, then the naming of the table name or field name is determined to be in compliance with the standard and the matching result is recorded. Handle the situation where the query result fails to find the corresponding English name in the standard vocabulary library, which means that the naming of the table name or field name may not comply with the specification, or its description information is not included in the standard vocabulary library. In this case, continue to execute the subsequent steps.

[0010] The word segmentation processing specifically includes: Multiple word segmenters work together to perform word segmentation processing. The description information for which no corresponding English name is found is simultaneously input into multiple preset word segmenters. Each word segmenter performs word segmentation processing on the input information and generates its own word segmentation result list. Vocabulary filtering and translation: perform vocabulary filtering and translation operations on the word segmentation results, and remove words that do not meet the requirements, including stop words and words without practical meaning, according to the preset vocabulary filtering rules; match the filtered words with the maintained dictionary database to obtain the English abbreviation or complete English word corresponding to each word; and assemble the translated English words into a field name candidate list; Compare and judge the candidate field name lists generated by each word segmenter, and compare the word segmentation results processed by each word segmenter and their corresponding field name candidates; use whether the field name candidates contain Chinese characters as the evaluation criterion. If all candidate field names do not contain Chinese characters, it is considered that the translation is successful and enters the naming standard determination; if any candidate field name contains Chinese characters, it is considered that the translation failed and enters the translation failure processing step.

[0011] The method also includes a manual review step, in which maintenance personnel review and confirm the record information; the maintenance personnel directly translate the Chinese description of the field that failed to be translated into standard vocabulary and update it to the standard vocabulary database, or translate the unmatched segmentation words into dictionary vocabulary and update it to the dictionary database.

[0012] The word segmenters include Ansj word segmenter, Hanlp word segmenter and Jieba word segmenter.

[0013] A system for detecting database naming specifications, comprising the following modules: A meta information synchronization module is used to synchronize meta information from a database of a business system, wherein the meta information includes table names, field names, table description information, and field description information in the database; A standard vocabulary query module is connected to the meta information synchronization module and is used to query the table description information and field description information in a preset standard vocabulary library to see whether there is a corresponding English name. If a corresponding English name is found, the naming specification of the table name or field name is determined; if not found, the word segmentation processing module is triggered; A word segmentation processing module, used for receiving the description information of the English name not found from the standard vocabulary query module, and performing word segmentation processing on the description information using multiple word segmenters; A vocabulary filtering and translation module, connected to the word segmentation processing module, is used to filter the words after word segmentation, obtain the English abbreviations corresponding to the words by querying the maintained dictionary database, and assemble them into field name candidates according to preset rules; The result comparison and evaluation module is used to compare the results of each word segmentation device, and the number of Chinese characters in the result is used as the evaluation standard. If the word segmentation result does not contain Chinese characters, it is considered that the translation is successful, and the naming standard determination module is triggered; if the word segmentation result contains Chinese characters, it is considered that the translation fails, and the translation failure processing module is triggered; A naming standard determination module, connected to the result comparison and evaluation module, is used to compare the successfully translated field name candidates with the existing field names. If they are inconsistent, the field is marked as non-standardly named, and recorded and reviewed; The translation failure processing module is used to handle the situation where the translation results contain unmatched Chinese words, record the field name, field Chinese description, word segmentation result, translation result and Chinese words that are not matched to the dictionary.

[0014] The system also includes a notification and reminder module: when the system detects a field with irregular naming or a translation failure, it sends notifications and reminders to the staff via email, SMS, or system messages; the reminder content includes problem details and handling suggestions.

[0015] A device comprises a memory, a processor and a computer program stored in the memory and executable on the processor, wherein the processor implements the steps of the method as described in any one of the preceding items when executing the computer program.

[0016] A computer-readable storage medium stores a computer program, wherein the computer program, when executed by a processor, implements the steps of the method described in any one of the preceding items.

[0017] Compared with the prior art, the present invention has the following beneficial effects: The present invention provides a method for detecting database naming specifications, by which the table names, field names and other elements in the database can be ensured to follow a unified naming specification, thereby improving the standardization level of the entire data warehouse or database, and helping to achieve data consistency and interoperability between different systems and different teams. The unified naming specification makes the element names in the data warehouse clearer and more meaningful. Whether for data analysts, developers or business users, they can understand and use data more quickly and reduce the cost of understanding.

[0018] Naming standards are an important part of data governance. The application of this method can promote the standardization of data governance, reduce confusion and conflicts in data management, and improve the efficiency and effectiveness of data governance. Improve data maintainability. Consistent naming methods are helpful for data management and maintenance. When changing the database, migrating data, or checking data quality, elements that follow naming standards are easier to track and manage, reducing maintenance costs and risks.

[0019] Optimize data storage and query efficiency. Standardized naming not only reduces data redundancy, but also optimizes data storage structure. At the same time, reasonable naming standards can improve the efficiency of data query, making data access faster and more accurate. Unified naming reduces the possibility of data misunderstanding and incorrect use due to inconsistent naming. It is essential to ensure the accuracy and reliability of data, especially in complex data environments.

[0020] Different naming habits are a major obstacle to team collaboration. Through the application of this method, obstacles can be eliminated, data sharing and collaboration across teams can be promoted, and the overall efficiency and innovation ability of the team can be improved.

[0021] Improve data quality control, naming standards are an important part of data quality control. Through this method, we can ensure that the data meets the quality requirements at the naming level, laying a solid foundation for subsequent data processing and analysis.

[0022] Supporting data standardization processes, this method can be embedded in data standardization processes as part of automated checks or manual reviews. This helps ensure that newly created database elements follow naming conventions from the beginning, thus maintaining consistency throughout the data lifecycle. BRIEF DESCRIPTION OF THE DRAWINGS

[0023] In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings required for use in the embodiments are briefly introduced below. It should be understood that the following drawings only show certain embodiments of the present invention and therefore should not be regarded as limiting the scope. For ordinary technicians in this field, other related drawings can be obtained based on these drawings without creative work.

[0024] Figure 1 The present invention is a flow chart of the method for detecting database naming specifications. DETAILED DESCRIPTION

[0025] In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Generally, the components of the embodiments of the present invention described and shown in the drawings here can be arranged and designed in various different configurations.

[0026] Therefore, the following detailed description of the embodiments of the present invention provided in the accompanying drawings is not intended to limit the scope of the invention claimed for protection, but merely represents selected embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0027] It should be noted that similar reference numerals and letters denote similar items in the following drawings, and therefore, once an item is defined in one drawing, further definition and explanation thereof is not required in subsequent drawings.

[0028] The present invention is further described in detail below in conjunction with the accompanying drawings: See also Figure 1 , is a method for detecting database naming specifications in the present invention, which specifically includes the following steps: S1, synchronize meta information, synchronize meta information from the database of the business system, including table name, field name, table description information and field description information in the database.

[0029] S1.1, table information extraction, query the system table or information model table of the database, and extract the names and description information of all user-defined tables.

[0030] S1.2, field information extraction, for each table, query its field information, including field name, data type, length limit and field description information.

[0031] S1.3, metadata organization and storage, formatting and synchronizing the extracted table names, field names, table description information, and field description information.

[0032] S2, standard vocabulary query, queries the preset standard vocabulary library to see whether the obtained table description information and field description information have corresponding English names. If the corresponding English name is found, the naming standard of the table name or field name is determined; if not found, continue to execute the subsequent steps.

[0033] S2.1, prepare a standard vocabulary library, and establish a standard vocabulary library containing Chinese field names and their corresponding English names. The vocabulary library should be designed as a queryable data structure, such as a database table, a key-value pair collection, or an index file, etc., to facilitate fast retrieval.

[0034] S2.2, obtain the description information to be queried, extract the table name, field name and its corresponding description information from the database of the business system. The description information will be used as the basis for querying the standard vocabulary library.

[0035] S2.3, perform a query operation, for each description information, perform a query operation in the standard vocabulary to find out whether there is an English name that completely matches it or has a similarity that reaches a certain threshold. The completeness of the description information and the keyword matching strategy should be considered during the query to improve the accuracy and efficiency of the query.

[0036] S2.4, determine the naming standards. If the query result finds the corresponding English name in the standard vocabulary library, it is determined that the naming of the table name or field name complies with the standards and the matching result is recorded.

[0037] S2.5, handle the situation where no name is found. If the query result fails to find the corresponding English name in the standard vocabulary library, it means that the naming of the table name or field name may not comply with the specification, or its description information is not included in the standard vocabulary library. At this time, continue to execute the subsequent steps.

[0038] S3, word segmentation processing, uses multiple word segmenters to perform word segmentation on the description information for which no corresponding English name is found.

[0039] Multiple word segmenters work together to perform word segmentation processing. The description information for which no corresponding English name is found is simultaneously input into multiple preset word segmenters. Each word segmenter performs word segmentation processing on the input information and generates its own word segmentation result list.

[0040] S4, vocabulary filtering and translation, filters the segmented vocabulary, obtains the English abbreviations corresponding to the vocabulary by querying the maintained dictionary database, and assembles them into field name candidates according to preset rules.

[0041] Vocabulary filtering and translation: perform vocabulary filtering and translation operations on the word segmentation results. According to the preset vocabulary filtering rules, remove words that do not meet the requirements, including stop words and words without practical meaning; match the filtered words with the maintained dictionary database to obtain the English abbreviation or complete English word corresponding to each word; and assemble the translated English words into a field name candidate list.

[0042] S5, result comparison and evaluation, compare the results of each word segmenter, and use the number of Chinese characters in the result as the evaluation standard. If the word segmentation result does not contain Chinese characters, it is considered a successful translation and enters the naming standard determination step; otherwise, it enters the translation failure processing step. Word segmenters include Ansj word segmenter, Hanlp word segmenter, Jieba word segmenter, etc.

[0043] Compare and judge the candidate field name lists generated by each word segmenter, and compare the word segmentation results processed by each word segmenter and their corresponding field name candidates; use whether the field name candidates contain Chinese characters as the evaluation criterion. If all candidate field names do not contain Chinese characters, it is considered that the translation is successful and enters the naming standard determination; if any candidate field name contains Chinese characters, it is considered that the translation failed and enters the translation failure processing step.

[0044] S6, naming standard determination, compares the successfully translated field name candidates with the existing field names. If they are inconsistent, the field is marked as non-standardly named and recorded and reviewed.

[0045] S7, translation failure processing, if the translation result contains unmatched Chinese words, record the field name, field Chinese description, word segmentation result, translation result and Chinese words that are not matched to the dictionary.

[0046] S8, manual review step, maintenance personnel review and confirm the record information; maintenance personnel directly translate the Chinese description of the field that failed to translate into standard vocabulary and update it to the standard vocabulary database, or translate the unmatched segmentation words into dictionary vocabulary and update it to the dictionary database.

[0047] An embodiment of the present invention is a system for detecting database naming specifications, which specifically includes the following modules: The meta information synchronization module is used to synchronize meta information from the database of the business system, wherein the meta information includes table names, field names, table description information and field description information in the database.

[0048] The standard vocabulary query module is connected to the meta-information synchronization module and is used to query whether the table description information and field description information have corresponding English names in the preset standard vocabulary library. If the corresponding English name is found, the naming specification of the table name or field name is determined; if not found, the word segmentation processing module is triggered.

[0049] The word segmentation processing module is used to receive the description information for which no corresponding English name is found from the standard vocabulary query module, and perform word segmentation processing on the description information using multiple word segmenters.

[0050] The vocabulary filtering and translation module is connected to the word segmentation processing module and is used to filter the words after word segmentation, obtain the English abbreviations corresponding to the words by querying the maintained dictionary database, and assemble them into field name candidates according to preset rules.

[0051] The result comparison and evaluation module is used to compare the results of word segmentation by each word segmenter, and the number of Chinese characters in the result is used as the evaluation criterion. If the word segmentation result does not contain Chinese characters, it is considered that the translation is successful and the naming standard determination module is triggered; if the word segmentation result contains Chinese characters, it is considered that the translation fails and the translation failure processing module is triggered.

[0052] The naming standard determination module is connected to the result comparison and evaluation module and is used to compare the successfully translated field name candidates with the existing field names. If they are inconsistent, the field is marked as non-standardly named and recorded and reviewed.

[0053] The translation failure processing module is used to handle the situation where the translation results contain unmatched Chinese words, record the field name, field Chinese description, word segmentation result, translation result and Chinese words that are not matched to the dictionary.

[0054] Notification and reminder module: When the system detects fields with irregular naming or translation failure, it sends notifications and reminders to staff via email, SMS, and system messages; the reminder content includes problem details and handling suggestions.

[0055] An embodiment of the present invention provides a terminal device. The terminal device of this embodiment includes: a processor, a memory, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the steps in the above-mentioned method embodiments are implemented. Alternatively, when the processor executes the computer program, the functions of the modules / units in the above-mentioned device embodiments are implemented.

[0056] The computer program may be divided into one or more modules / units, and the one or more modules / units are stored in the memory and executed by the processor to accomplish the present invention.

[0057] The device / terminal equipment may be a computing device such as a desktop computer, a notebook, a palm computer, a cloud server, etc. The device / terminal equipment may include, but is not limited to, a processor and a memory.

[0058] The processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc.

[0059] The memory may be used to store the computer programs and / or modules, and the processor implements various functions of the apparatus / terminal device by running or executing the computer programs and / or modules stored in the memory and calling the data stored in the memory.

[0060] If the module / unit integrated in the device / terminal equipment is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the present invention implements all or part of the processes in the above-mentioned embodiment method, and can also be completed by instructing the relevant hardware through a computer program. The computer program can be stored in a computer-readable storage medium. When the computer program is executed by the processor, the steps of the above-mentioned method embodiments can be implemented. Among them, the computer program includes computer program code, and the computer program code can be in source code form, object code form, executable file or some intermediate form. The computer-readable medium may include: any entity or device that can carry the computer program code, recording medium, U disk, mobile hard disk, disk, optical disk, computer memory, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), electric carrier signal, telecommunication signal and software distribution medium. It should be noted that the content contained in the computer-readable medium can be appropriately increased or decreased according to the requirements of legislation and patent practice in the jurisdiction. For example, in some jurisdictions, according to legislation and patent practice, computer-readable media do not include electric carrier signals and telecommunication signals.

[0061] The above are only preferred embodiments of the present invention and are not intended to limit the present invention. For those skilled in the art, the present invention may have various modifications and variations. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

Claims

1. A method for detecting database naming conventions, characterized in that: The following steps are involved: Synchronize meta information, including table name, field name, table description information and field description information in the database, from the business system database; Standard vocabulary query, query the preset standard vocabulary library to see whether the obtained table description information and field description information have corresponding English names. If the corresponding English name is found, determine the naming standard of the table name or field name; if not found, continue to execute the subsequent steps; Word segmentation: Use multiple word segmenters to segment the description information for which no corresponding English name is found; Vocabulary filtering and translation: filter the segmented words, obtain the English abbreviations corresponding to the words by querying the maintained dictionary database, and assemble them into field name candidates according to preset rules; Compare and judge the results. Compare the results of each word segmenter and use the number of Chinese characters in the result as the judging standard. If the word segmentation result does not contain Chinese characters, the translation is considered successful and the naming standard determination step is entered; otherwise, the translation failure processing step is entered; Naming standard determination: compare the successfully translated field name candidates with the existing field names. If they are inconsistent, the field will be marked as non-standardly named and recorded and reviewed; Translation failure processing: If the translation results contain unmatched Chinese words, the field name, Chinese description of the field, word segmentation results, translation results, and Chinese words that are not matched in the dictionary are recorded.

2. A method for detecting database naming conventions as claimed in claim 1, characterized in that: The synchronization meta information is specifically: Table information extraction: query the system table or information model table of the database to extract the names and description information of all user-defined tables; Field information extraction: for each table, query its field information, including field name, data type, length limit and field description information; Meta-information organization and storage: the extracted table names, field names, table description information, and field description information are organized in a format and synchronized.

3. A method for detecting database naming conventions as claimed in claim 1, characterized in that: The standard vocabulary query is specifically: Prepare a standard vocabulary database, and establish a standard vocabulary database containing Chinese field names and their corresponding English names; Obtain the description information to be queried, and extract the table name, field name and their corresponding description information from the database of the business system; Perform a query operation, for each description information, perform a query operation in the standard vocabulary database to find out whether there is an English name that completely matches it or has a similarity that reaches a certain threshold; Determine the naming standard. If the query result finds the corresponding English name in the standard vocabulary, then the naming of the table name or field name is determined to be in compliance with the standard and the matching result is recorded. Handle the situation where the query result fails to find the corresponding English name in the standard vocabulary library, which means that the naming of the table name or field name may not comply with the specification, or its description information is not included in the standard vocabulary library. In this case, continue to execute the subsequent steps.

4. A method for detecting database naming conventions as claimed in claim 1, characterized in that: The word segmentation processing specifically includes: Multiple word segmenters work together to perform word segmentation processing. The description information for which no corresponding English name is found is simultaneously input into multiple preset word segmenters. Each word segmenter performs word segmentation processing on the input information and generates its own word segmentation result list. Vocabulary filtering and translation: perform vocabulary filtering and translation operations on the word segmentation results, and remove words that do not meet the requirements, including stop words and words without practical meaning, according to the preset vocabulary filtering rules; match the filtered words with the maintained dictionary database to obtain the English abbreviation or complete English word corresponding to each word; and assemble the translated English words into a field name candidate list; Compare and judge the candidate field name lists generated by each word segmenter, and compare the word segmentation results processed by each word segmenter and their corresponding field name candidates; use whether the field name candidates contain Chinese characters as the evaluation criterion. If all candidate field names do not contain Chinese characters, it is considered that the translation is successful and enters the naming standard determination; if any candidate field name contains Chinese characters, it is considered that the translation failed and enters the translation failure processing step.

5. A method for detecting database naming conventions as claimed in claim 1, characterized in that: The method also includes a manual review step, in which maintenance personnel review and confirm the record information; the maintenance personnel directly translate the Chinese description of the field that failed to be translated into standard vocabulary and update it to the standard vocabulary database, or translate the unmatched segmentation words into dictionary vocabulary and update it to the dictionary database.

6. A method for detecting database naming conventions as claimed in claim 1, characterized in that: The word segmenters include Ansj word segmenter, Hanlp word segmenter and Jieba word segmenter.

7. A system for detecting database naming conventions, characterized in that: Includes the following modules: A meta information synchronization module is used to synchronize meta information from a database of a business system, wherein the meta information includes table names, field names, table description information, and field description information in the database; A standard vocabulary query module is connected to the meta information synchronization module and is used to query the table description information and field description information in a preset standard vocabulary library to see whether there is a corresponding English name. If a corresponding English name is found, the naming specification of the table name or field name is determined; if not found, the word segmentation processing module is triggered; A word segmentation processing module, used for receiving the description information of the English name not found from the standard vocabulary query module, and performing word segmentation processing on the description information using multiple word segmenters; A vocabulary filtering and translation module, connected to the word segmentation processing module, is used to filter the words after word segmentation, obtain the English abbreviations corresponding to the words by querying the maintained dictionary database, and assemble them into field name candidates according to preset rules; The result comparison and evaluation module is used to compare the results of each word segmentation, and the number of Chinese characters in the result is used as the evaluation standard. If the word segmentation result does not contain Chinese characters, it is considered that the translation is successful and the naming standard determination module is triggered; If the word segmentation result contains Chinese characters, it is considered a translation failure and the translation failure processing module is triggered; A naming standard determination module, connected to the result comparison and evaluation module, is used to compare the successfully translated field name candidates with the existing field names. If they are inconsistent, the field is marked as non-standardly named, and recorded and reviewed; The translation failure processing module is used to handle the situation where the translation results contain unmatched Chinese words, record the field name, field Chinese description, word segmentation result, translation result and Chinese words that are not matched to the dictionary.

8. A system for detecting database naming standards as claimed in claim 7, characterized in that: The system also includes a notification and reminder module: when the system detects a field with irregular naming or a translation failure, it sends notifications and reminders to the staff via email, SMS, or system messages; The reminder includes problem details and handling suggestions.

9. A device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the steps of the method according to any one of claims 1 to 6 are implemented.

10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 6 are implemented.

Images