CN-121979911-A - Database construction, database processing and information reporting methods and devices, storage medium, program product and computer equipment

Abstract

The application discloses a method and a device for constructing a database, processing the database and reporting information, a storage medium, a program product and computer equipment, wherein a main table corresponding to an inquired object is determined; the method comprises the steps of obtaining a plurality of intermediate tables based on identification information related to the inquired object, carrying out association processing on the plurality of intermediate tables to obtain at least one service intermediate table, and configuring a preset distributed file system as an intermediate database model based on the main table and the at least one service intermediate table, so that the efficiency of the constructed database in subsequent updating and/or inquiring can be improved, and efficient updating and/or outputting of data can be realized.

Inventors

• LI DAQUN
• WAN YAPING
• LIN PENG
• JI XINYUE
• WANG ZHAOSHAN

Assignees

• 中国移动通信集团广东有限公司
• 中国移动通信集团有限公司

Dates

Publication Date

20260505

Application Date

20251229

Claims (15)

1. 1. A database construction method, comprising: Determining a main table corresponding to the queried object; Acquiring a plurality of intermediate tables based on identification information related to the queried object; Performing association processing on the plurality of intermediate tables to obtain at least one business intermediate table; And configuring a preset distributed file system as an intermediate database model based on the main table and the at least one business intermediate table.
2. 2. The method of claim 1, wherein the step of determining the position of the substrate comprises, The identification information includes at least one of an identification of the queried object, an identification of a product related to the queried object, an identification of a product management attribute related to the queried object.
3. 3. The method of claim 1, wherein the step of determining the position of the substrate comprises, At least part of the plurality of intermediate tables is adapted to characterize at least one of product attribute information related to policy and charging control, PCC, product attribute information related to access point name, APN.
4. 4. The method of claim 1, wherein the associating the plurality of intermediate tables to obtain at least one service intermediate table comprises: And performing dimension-based association processing on the plurality of intermediate tables to obtain the at least one service intermediate table, wherein the service intermediate table is formed by splicing intermediate tables with matched dimensions in the plurality of intermediate tables.
5. 5. A database processing method, comprising: acquiring external demand information; converting the at least one business middle table in the middle database model pre-constructed by the method according to any one of claims 1-4 into information to be output based on the external demand information; and writing the information to be output into a result table of the intermediate database model to obtain a target database model.
6. 6. The method of claim 5, wherein after the obtaining the target database model, the method further comprises: Performing self-checking processing on at least part of data in the target database model; Wherein, the The self-checking processing comprises at least one of checking the necessary filling of the word segments, checking the condition necessary filling of the word segments, checking the enumeration value, checking the compliance of the content, checking the real-name sales state and checking the compliance of the business; And/or the number of the groups of groups, The self-checking process is realized through multi-column field checking and/or data checking; And/or the number of the groups of groups, The external demand information comprises at least one of a telecom operator service demand and a telecom operator information reporting demand.
7. 7. The information reporting method is characterized by comprising the following steps: determining a target database model, wherein the target database model is derived based on the method of any of claims 5-6; And according to a preset reporting rule, reporting information based on at least part of information in the result table of the target database model.
8. 8. The information reporting method is characterized by comprising the following steps: Acquiring reporting requirement information and determining an intermediate database model, wherein the intermediate database model is pre-constructed according to the method of any one of claims 1-4; Based on the reporting demand information, converting at least part of the business intermediate table in the intermediate database model into information to be output; and reporting information based on the information to be output and the reporting requirement information.
9. 9. A database construction apparatus, comprising: the main table determining module is used for determining a main table corresponding to the inquired object; The middle table determining module is used for acquiring a plurality of middle tables based on the identification information related to the inquired object; The business middle table determining module is used for carrying out association processing on the plurality of middle tables to obtain at least one business middle table; The model building module is used for configuring a preset distributed file system into an intermediate database model based on the main table and the at least one business intermediate table.
10. 10. A database processing apparatus, comprising: the external demand acquisition module is used for acquiring external demand information; A first conversion module, configured to convert, based on the external requirement information, the at least one service intermediate table in the intermediate database model pre-constructed according to the method of any one of claims 1 to 4 into information to be output; and the model updating module is used for writing the information to be output into a result table of the intermediate database model to obtain a target database model.
11. 11. An information reporting apparatus, comprising: A target database determining module for determining a target database model, wherein the target database model is derived based on the method of any one of claims 5-6; And the first reporting module is used for reporting information based on at least part of information in the result table of the target database model according to a preset reporting rule.
12. 12. An information reporting apparatus, comprising: the reporting requirement acquisition module is used for acquiring reporting requirement information and determining an intermediate database model, wherein the intermediate database model is pre-constructed according to the method of any one of claims 1-4; the second conversion module is used for converting at least part of the business intermediate tables in the intermediate database model into information to be output based on the reporting requirement information; And the second reporting module is used for reporting information based on the information to be output and the reporting requirement information.
13. 13. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the method of any of claims 1-8.
14. 14. A computer program product comprising computer instructions which, when executed by a processor, implement the method of any of claims 1-8.
15. 15. A computer device comprising a processor, a memory and a computer program stored in the memory and configured to be executed by the processor, the processor implementing the method of any of claims 1-8 when the computer program is executed.

Description

Database construction, database processing and information reporting methods and devices, storage medium, program product and computer equipment Technical Field The present application relates to the field of data processing technologies, and in particular, to a method and apparatus for constructing a database, processing the database, and reporting information, a storage medium, a program product, and a computer device. Background In many scenarios, it is often necessary to query the required information from a database with a huge amount of data, so that subsequent related operations can be completed by using the queried information, for example, the queried information can be sent/reported to other end sides, and also can be presented to the user. In the related art, OLTP (On-Line Transaction Processing, online transaction process) based databases (e.g., ORACLE databases) are typically used to store the relevant data. However, during the construction of the database, the data associated with the queried object is assembled into the object set according to different conditional branches, and accordingly, when the database is called to query, query judgment related to different conditional branches is generally required to be performed, so that the database needs to be completed based on different conditional branches during subsequent updating and/or querying, and thus the updating and/or querying efficiency is not high. Disclosure of Invention In order to solve the technical problems, the embodiments of the present application provide a method and apparatus for constructing a database, processing the database, reporting information, a storage medium, a program product, and a computer device, which can improve the efficiency of the constructed database during subsequent updating and/or querying, and realize efficient updating and/or outputting of data. In a first aspect, an embodiment of the present application provides a database construction method, including: Determining a main table corresponding to the queried object; Acquiring a plurality of intermediate tables based on identification information related to the queried object; Performing association processing on the plurality of intermediate tables to obtain at least one business intermediate table; And configuring a preset distributed file system as an intermediate database model based on the main table and the at least one business intermediate table. Optionally, the identification information comprises at least one of identification of the queried object, identification of a product related to the queried object, and identification of a product management attribute related to the queried object. Optionally at least part of the plurality of intermediate tables is adapted to characterize at least one of product attribute information related to policy and charging control, PCC, product attribute information related to access point name, APN. Optionally, the performing association processing on the plurality of intermediate tables to obtain at least one service intermediate table includes: And performing dimension-based association processing on the plurality of intermediate tables to obtain the at least one service intermediate table, wherein the service intermediate table is formed by splicing intermediate tables with matched dimensions in the plurality of intermediate tables. In a second aspect, an embodiment of the present application provides a database processing method, including: acquiring external demand information; Converting the at least one business middle table in the middle database model pre-constructed by the method according to any one of the first aspect into information to be output based on the external demand information; and writing the information to be output into a result table of the intermediate database model to obtain a target database model. Optionally, after the obtaining the target database model, the method further includes: and performing self-checking processing on at least part of data in the target database model. Optionally, the self-checking process comprises at least one of checking a necessary field, checking a conditional necessary field, checking an enumeration value, checking content compliance, checking a real-name sales state and checking business compliance; And/or the number of the groups of groups, The self-checking process is implemented by multi-column field checking and/or row data checking. Optionally, the external requirement information comprises at least one of a telecom operator service requirement and a telecom operator information reporting requirement. In a third aspect, an embodiment of the present application provides an information reporting method, including: Determining a target database model, wherein the target database model is obtained based on the method of any one of the second aspects; And according to a preset reporting rule, reporting information based on at least part of inf