CN111459933A - GDB data dynamic expansion method, device and storage medium - Google Patents
GDB data dynamic expansion method, device and storage medium Download PDFInfo
- Publication number
- CN111459933A CN111459933A CN202010170076.4A CN202010170076A CN111459933A CN 111459933 A CN111459933 A CN 111459933A CN 202010170076 A CN202010170076 A CN 202010170076A CN 111459933 A CN111459933 A CN 111459933A
- Authority
- CN
- China
- Prior art keywords
- gdb
- data
- database
- report system
- calling
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to the technical field of big data platforms, and provides a dynamic GDB data expansion method, a dynamic GDB data expansion device and a storage medium, wherein the method comprises the following steps: establishing a report system database corresponding to a GDB database by selecting a development mode, wherein the report system database comprises a GDB database table and a data table corresponding to the GDB database table; the development mode comprises a selection mode of a general interface of the GDB gathering processor, a calling mode of a database table and a calling mode of a storage process; the report system database calls data of the GDB database by taking the data table as a unit based on the development mode, and obtains logical operation data through the called data of the GDB database; and presenting the acquired logic operation data on a terminal interface. The invention establishes the report system database by the self-defined factory agent mode, reduces JAVA code processing links, simplifies the development process and lightens the pressure of the server.
Description
Technical Field
The invention relates to the technical field of big data platforms, in particular to a dynamic GDB data expansion method, a dynamic GDB data expansion device and a storage medium.
Background
The enterprise report billboard system can help enterprises access, format data, and present data information to users in a safe and reliable manner. The existing enterprise report billboard system needs dimension combination and calculation on multi-dimensional index data.
The existing enterprise report form billboard system imports data as a data source through an Execl table and stores data information in a large data platform in a centralized manner; when the data needs to be displayed, the data needs to be acquired from a big data platform. The specific method for acquiring the data comprises the steps that the data are transmitted to a reporting system through a data interface provided by a big data platform, the reporting system develops the data interface to enable the data to fall to a database, then logical operation is conducted, and finally the reporting system displays the calculated data on a client side or a foreground page. The disadvantages are as follows:
1) both a report system and a data platform need to be developed, so that the workload is huge;
2) when the reporting system is on line, the reporting system and the data platform are required to be matched with the data platform to be on line, so that unpredictable risks are increased for the on line;
3) when the report system needs new types of service data, new data customization needs to be performed on the report system and the data platform at the same time, so that the workload is high, and development and debugging risks of a new interface need to be faced.
Therefore, a GDB data extension method with high scalability and high stability is needed.
Disclosure of Invention
The invention provides a GDB data dynamic expansion method, an electronic device and a computer readable storage medium, which mainly reduce JAVA code processing links, simplify development processes and reduce server pressure by customizing a factory agent mode.
In order to achieve the above object, the present invention further provides a GDB data dynamic expansion method applied to an electronic device, where the method includes:
s110, establishing a report system database corresponding to a GDB database by selecting a development mode, wherein the report system database comprises a GDB database table and a data table corresponding to the GDB database table; the development mode comprises a selection mode of a general interface of the GDB summarizing processor, a calling mode of a data table and a calling mode of a storage process;
s120, the report system database calls the data of the GDB database by taking the data table as a unit based on the development mode, and obtains logical operation data through the called data of the GDB database;
and S130, presenting the acquired logic operation data on a terminal interface.
Further, preferably, the method for calling GDB database data in step S120 includes:
s210, the database of the report system stores and stores the process according to the index of the report system;
s220, based on the GDB summarizing processor general interface method of the development mode, the realization class of the GDB summarizing processor interface corresponds to the data table and the storage process one by one;
and S230, calling a corresponding storage process by the report system database according to the implementation class.
Further, preferably, the storage process writes a SQ L statement set containing logical operation data in a unit of database table for the GDB database.
Further, preferably, a new user is created on the database server for the GDB database, and the new user is granted the write right to the report system database. .
Further, preferably, the process of acquiring the logical operation data in step S120 further includes a write-back process, where the write-back process includes:
s310, writing the obtained logical operation data back to the report system database;
and S320, displaying the logic operation data on a terminal interface by the report system database.
In order to achieve the above object, the present invention provides a GDB data dynamic expansion system, which includes a report system database establishing unit, a logical operation data obtaining unit and a logical operation data presenting unit; the report system database establishing unit is used for establishing a report system database corresponding to the GDB database by selecting a development mode; the report system database comprises a GDB database table and a data table corresponding to the GDB database table; the development mode comprises a selection mode of a general interface of the GDB gathering processor, a calling mode for calling a data table and a calling mode of a storage process; the logical operation data acquisition unit is used for calling the data of the GDB database by the report system database based on the development mode by taking the data table as a unit and acquiring logical operation data by the called data of the GDB database; and the logic operation data presentation unit is used for presenting the acquired logic operation data on a terminal interface. Further, preferably, the logic operation data obtaining unit includes a data calling module and a logic operation data obtaining module of the GDB database; the data calling module of the GDB database is used for calling the data of the GDB database by the report system database based on the development mode by taking the data table as a unit; and the logic operation data acquisition module is used for acquiring logic operation data through the data of the called GDB database. Further, preferably, the data calling module of the GDB database includes a storage procedure storage sub-module, a storage procedure corresponding sub-module, and a storage procedure calling sub-module; the storage process storage submodule is used for storing the storage process corresponding submodule according to the index of the report system through the report system database, and is used for carrying out one-to-one correspondence on the implementation class of the GDB summary processor interface, the data table and the storage process through the GDB summary processor total interface method based on the development mode; and the storage process calling submodule is used for calling the corresponding storage process according to the implementation class through the report system database.
To achieve the above object, the present invention provides an electronic device, comprising: the GDB dynamic data expansion program comprises a memory and a processor, wherein the memory stores a GDB dynamic data expansion program, and the GDB dynamic data expansion program realizes the following steps when being executed by the processor: s110, establishing a report system database corresponding to a GDB database by selecting a development mode, wherein the report system database comprises a GDB database table and a data table corresponding to the GDB database table; the development mode comprises a selection mode of a general interface of the GDB summarizing processor, a calling mode of a data table and a calling mode of a storage process; s120, the report system database calls the data of the GDB database by taking the data table as a unit based on the development mode, and obtains logical operation data through the called data of the GDB database; and S130, presenting the acquired logic operation data on a terminal interface.
In addition, to achieve the above object, the present invention further provides a computer readable storage medium, in which a computer program is stored, where the computer program includes a GDB data dynamic expansion program, and when the GDB data dynamic expansion program is executed by a processor, the steps of the GDB data dynamic expansion method are implemented.
The GDB data dynamic expansion method, the electronic device and the computer readable storage medium provided by the invention establish the report system database through the user-defined factory proxy mode, then use the report system database to call the data of the GDB database and obtain the logic calculation data, and finally present the obtained logic calculation data on the terminal interface; the beneficial effects are as follows:
(1) according to the invention, data interaction is not required through an API (application programming interface), and data directly enter a system database, so that the development process is simplified;
(2) the logical operation of the data reduces a JAVA code processing link and an API interface interaction link, the logical operation directly occurs in a database, the pressure of the server is reduced, the code amount is reduced, and the reasonable application of server resources is realized;
(3) when a new service module is needed, only data needs to be inserted into the database, and the API interface development link is reduced.
Drawings
FIG. 1 is a flow chart of a GDB data dynamic expansion method according to a preferred embodiment of the present invention;
FIG. 2 is a flowchart illustrating a preferred embodiment of the report system database invoking GDB database data according to the present invention;
FIG. 3 is a schematic diagram illustrating a GDB data dynamic expansion method according to the present invention;
FIG. 4 is a schematic structural diagram of a GDB data dynamic expansion system according to the present invention;
FIG. 5 is a schematic structural diagram of an electronic device according to a preferred embodiment of the invention;
the implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention.
The method comprises the steps of establishing a report system database through a user-defined factory agent mode, calling data of a GDB database by using the report system database, acquiring logic calculation data, and finally presenting the acquired logic calculation data on a terminal interface; data interaction is not needed through an API (application programming interface), only new business data are needed to be inserted into a database table corresponding to the report system database, and GDB (graphics data base) data directly enter the system database (namely the report system database), so that the development process is simplified, and the pressure of a server is relieved.
The invention provides a dynamic GDB data expansion method. FIG. 1 shows the flow of the GDB data dynamic expansion method according to the present invention. Referring to fig. 1, the method may be performed by an apparatus, which may be implemented by software and/or hardware.
In this embodiment, the GDB data dynamic expansion method includes: step S110-step 130.
S110, establishing a report system database corresponding to the GDB database by selecting a development mode, wherein the report system database comprises a GDB database table and a data table corresponding to the GDB database table.
Specifically, the development modes comprise a selection mode of a general interface of the GDB summary processor, a calling mode of a database table, a calling mode of a stored procedure, a front operation method and a back operation method. The development mode in the application is a factory agent mode, and can also be a development mode in other forms; the factory agent mode comprises selecting a GDB summary processor interface and a GDB processor factory, and then adding a stored procedure method for calling GDB summary.
And S120, calling the data of the GDB database by taking the data table as a unit based on the development mode by the report system database, and acquiring logic operation data through the called data of the GDB database.
The specific process of obtaining the logical operation data through the called data of the GDB database comprises the steps that after the GDB database receives a data request sent by the report system database, the GDB database generates a database script for the required data, then the report system database is called remotely, and the database script is executed, so that the logical operation data are stored in the report system database.
In a specific embodiment, if the timing task (data request) of the report system database fails to be executed, the GDB database manually initiates a data processing task, then generates a corresponding database script, and then remotely calls the report system database and executes the database script to store the logical operation data in the report system database.
It should be further noted that before the storage process of the GDB database is called, the GDB database needs to be authorized for writable rights. That is, a new user of the database with the authority of 'adding, deleting, modifying and checking' is created for the GDB database on the database server, and the new user is granted the writing authority of the report system database.
The method for calling GDB database data in the step S120 includes steps S210 to S230.
FIG. 2 shows a flow of the preferred embodiment of the report system database calling GDB database data according to the present invention. As shown with reference to figure 2 of the drawings,
and S210, storing the storage process by the database of the report system according to the index of the report system, wherein the storage process is a storage process for writing logical operation data by the GDB database by taking the database table as a unit.
The storage process is an important object in a database, and in a large database system, the storage process is stored in the database as a group of SQ L statement sets for completing a specific function, the storage process is called again after first compiling without compiling again, and a user executes the storage process by specifying the name of the storage process and giving parameters (if the storage process has the parameters).
The storage process can be executed for multiple times only by compiling once, so that the performance can be improved by executing the storage process.
S220, based on the GDB summarizing processor general interface method of the development mode, the realization type of the GDB summarizing processor interface is in one-to-one correspondence with the data table and the storage process.
It should be noted that the GDB summary processor interface may correspond to many implementation classes, and then each implementation class is in one-to-one correspondence with the data table and the storage process; in other words, each implementation class corresponds to one data table and one stored procedure.
And S230, calling a corresponding storage process by the report system database according to the implementation class.
It should be noted that the stored procedure can be regarded as a batch, but its role is not limited to batch processing. The storage process encapsulates complex content into units which are easy to use, thereby simplifying complex operation; in addition, the complex content in the storage process is not required to be established repeatedly, so that the integrity of the content data is ensured. That is, if all developers and applications use the same stored procedure, the code used is the same, thus avoiding the problem of more steps being performed and the greater the chance of making an error.
The logical operation data in the storage process can be obtained only by calling the corresponding storage process by the report system database according to the implementation class. The logic operation data are acquired by calling the storage process, so that the server pressure is reduced, the code amount is reduced, and the reasonable application of server resources is realized; but also ensures the accuracy of the data.
In a word, a storage process is required to be stored according to indexes of a report system, wherein the storage process is a storage process for writing logical operation data in a GDB database by taking a database table as a unit; the implementation class of the GDB gathering processor interface is in one-to-one correspondence with the data table and the storage process; and the report system database calls a corresponding storage process according to the implementation class so as to obtain the logical operation data in the storage process.
And S130, presenting the acquired logic operation data on a terminal interface.
Specifically, the report system database calls data of the GDB database by taking the data table as a unit, the report system database acquires logical operation data through the called data of the GDB database, then writes the acquired logical operation data back to the report system database, and the report system database displays the logical operation data.
It should be noted that, the process of obtaining the logical operation data in step S120 further includes a write-back process, where the write-back process includes: s310, writing the obtained logical operation data back to a report system database; and S320, displaying the logical operation data on a terminal interface by the report system database.
Furthermore, the data fields needing special processing are subjected to pre-operation or post-operation. It should be noted that the pre-operation and the post-operation refer to methods that are automatically called before and after a certain operation method is executed.
In summary, the invention establishes the report system database corresponding to the GDB database by defining the development mode, wherein the report system database comprises a GDB database table and a data table corresponding to the GDB database table; the report system database calls the data of the GDB database by taking the data table as a unit; the report system database acquires logical operation data through the called data of the GDB database; and presenting the acquired logic operation data on a terminal interface.
The called storage process is corresponding to the business module, and the burden brought by the circular traversal of the database is reduced. After the GDB data is pushed to the report system at the appointed time, the corresponding report system service module calls the corresponding storage process through a factory mode to carry out calculation, and then writes the calculated number back to the service data table to be displayed on a terminal interface. API development calls between the systems are reduced, and the risk between the two systems in interaction is reduced.
FIG. 3 shows a schematic diagram of a GDB data dynamic expansion method according to the present invention; referring to fig. 3, a report system database is established in a custom factory agent mode, the implementation class of a GDB summary processor interface corresponds to a data table and a storage process one by one, the report system database calls the corresponding storage process according to the implementation class, so that logical operation data in the storage process is obtained, the logical operation data is obtained through the called data of the GDB database, and then the obtained logical operation data is presented on a terminal interface. As shown in fig. 3, in the specific implementation process, the step of establishing the report system database includes the following steps:
1. the method comprises the steps of defining a GDB summarizing processor interface, 2 defining a GDB processor factory, 3 increasing a storage process method for calling GDB summarizing by a Service layer, 4 increasing a method for calling a DAO layer on the DAO layer, 5 writing calling SQ L in an xml file of a domain name corresponding to mybatis, and 6 corresponding to each Service field to realize the GDB summarizing processor interface.
1. And defining a GDB summary processor interface, and realizing by JAVA project engineering. Wherein, defining interface class includes corresponding to the corresponding service module of the system, a certain table of GDB, and a certain storage process in database; that is, according to the related report field, the corresponding GDB data table is found. Furthermore, the method also comprises the steps of calling a preposed method before the storage process and calling a postpositional method after the storage process; it should be noted that, invoking the pre-method before the storage process is a pre-summary operation, which means whether a certain service logic needs to be specified before calculating and processing data; the post method after the storage process is called is the operation after the summary, which means whether a certain specific service package is needed to be carried out on the calculation result after the data is calculated and processed.
2. The process of defining the GDB processor factory comprises the steps of firstly defining a processing factory class, and loading all implementation classes for realizing GDBCollectHandler interfaces (summary processor interfaces) into L ist through Spring after Spring dependency injection.
Specifically, the GDB factory processor implements classes, implemented in JAVA; the method comprises the steps of firstly realizing an ApplicationContextAware automatic assembly interface in a Spring framework and serializing the type, loading an implementation type for realizing the interface (GDB summary processor abstract interface) in the automatic assembly method, storing the implementation type in a Map, and when GDB data needs to be processed, enabling a corresponding GDB data table to correspond to a method name of a correspondingly processed storage process. And then defining a callback function for business processing, and finally adding an annotation of @ Component to the implementation class, and then delivering the class to a spring framework for hosting.
3. The storage process method for adding and calling GDB collection by the Service layer comprises the following steps: a method for calling data sql is well defined in a system DAO layer, and a corresponding method name of a storage process is transmitted, and required parameters are added.
Specifically, the processing class corresponding to the GDB table is realized through JAVA; firstly, the interface defined in the front (namely the abstract interface of the GDB summary processor) is realized, the field to which the GDB table data belongs is set, the name of the corresponding storage process is set, and a certain service logic is specially appointed before the summary and a certain service operation is specially appointed after the summary are defined. Then, in the report system and the corresponding business data processing method, the callback function in the factory processing class is used, and the GDB data table name which corresponds to the needed processing is transmitted, so that the data processing can be started.
4. Adding a method for calling the DAO layer in the DAO layer; adding a database calling interface on a project DAO layer; i.e. a method calling the DAO layer. Specifically, this step is to implement the call between databases through JAVA. Firstly, when a project is established, mybatis is integrated in a Spring project, an interface for calling a storage process is defined, the interface receives parameters such as a storage method name and the like transmitted by the above factory processing class, and the storage process in a database is called.
It should be further noted that @ Service and @ Component annotations are added to the GDB process engineering and each implementation class.
When the server is started, the server is loaded by Spring. When the GDB data is pushed to the system database, computation is triggered, and then a processing factory can load all Handler implementation classes to perform operation processing and database calling of corresponding business logic.
In a specific embodiment, when a new service requirement exists, a new data table of the report system database needs to be added, and an implementation class and a storage process corresponding to the data table need to be added, so that new report data can be displayed in the foreground.
After the system is on line, if the data algorithm of the report system is changed, the data algorithm of the report system can be changed by modifying the storage process stored in the database and then updating the database of the report system, so that the change of the data algorithm of the report system is realized, the newly added system database is avoided, and the unstable risk caused by the on-line of a new system is avoided.
In summary, the GDB data dynamic extension method provided by the present invention establishes the report system database through the custom factory proxy mode, then calls the data of the GDB database by using the report system database and obtains the logical calculation data, and then writes back the obtained logical operation data to the report system database, and the report system database presents the obtained logical calculation data on the terminal interface. According to the invention, data interaction is not required through an API (application programming interface), and data directly enter a system database, so that the development process is simplified; the logical operation of the data reduces a JAVA code processing link and an API interface interaction link, the logical operation directly occurs in a database, the pressure of the server is reduced, the code amount is reduced, and the reasonable application of server resources is realized; when a new service module is needed, only data needs to be inserted into the database, and the API interface development link is reduced.
The invention provides a GDB data dynamic expansion system. FIG. 4 shows the structure of the preferred embodiment of the GDB data dynamic expansion system according to the present invention.
Referring to fig. 4, in order to achieve the above object, the present invention provides a GDB data dynamic expansion system, which includes a report system database establishing unit 41, a logical operation data obtaining unit 42, and a logical operation data presenting unit 43.
The report system database establishing unit 41 is configured to establish a report system database corresponding to the GDB database by selecting a development mode; the report system database comprises a GDB database table and a data table corresponding to the GDB database table; the development mode comprises a selection mode of a general interface of the GDB gathering processor, a calling mode for calling a data table and a calling mode of a storage process;
and a logical operation data obtaining unit 42, configured to call, by the reporting system database, data of the GDB database in units of the data table based on the development mode, and obtain logical operation data by the called data of the GDB database.
And a logical operation data presentation unit 43, configured to present the acquired logical operation data on a terminal interface.
The logical operation data obtaining unit 42 includes a data calling module 421 and a logical operation data obtaining module 422 of the GDB database; the data calling module 421 of the GDB database is configured to call, by the report system database, data of the GDB database in units of the data table based on the development mode; the logic operation data obtaining module 422 is configured to obtain logic operation data through the called data of the GDB database.
The data calling module 421 of the GDB database includes a storage procedure storage sub-module, a storage procedure corresponding sub-module, and a storage procedure calling sub-module.
The storage process storage submodule is used for storing the storage process corresponding submodule according to the index of the report system through the report system database, and is used for carrying out one-to-one correspondence on the implementation class of the GDB summary processor interface, the data table and the storage process through the GDB summary processor total interface method based on the development mode; and the storage process calling submodule is used for calling the corresponding storage process according to the implementation class through the report system database.
The invention provides a dynamic GDB data expansion method, which is applied to an electronic device 5. FIG. 5 shows an application environment of the GDB data dynamic expansion method according to the preferred embodiment of the present invention.
Referring to fig. 5, in the present embodiment, the electronic device 5 may be a terminal device having an arithmetic function, such as a server, a smart phone, a tablet computer, a portable computer, or a desktop computer.
The electronic device 5 includes: a processor 52, a memory 51, a communication bus 53, and a network interface 54.
The memory 51 includes at least one type of readable storage medium. The at least one type of readable storage medium may be a non-volatile storage medium such as a flash memory, a hard disk, a multimedia card, a card-type memory 51, and the like. In some embodiments, the readable storage medium may be an internal storage unit of the electronic device 5, such as a hard disk of the electronic device 5. In other embodiments, the readable storage medium may also be an external memory 51 of the electronic device 5, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like, provided on the electronic device 5.
In this embodiment, the readable storage medium of the memory 51 is generally used for storing the GDB data dynamic expansion program 50 installed in the electronic device 5. The memory 51 may also be used to temporarily store data that has been output or is to be output.
The processor 52 may be a Central Processing Unit (CPU), microprocessor or other data Processing chip in some embodiments, and is used for executing program codes stored in the memory 51 or Processing data, such as executing the GDB data dynamic expansion program 50.
The communication bus 53 is used to realize connection communication between these components.
The network interface 54 may optionally include a standard wired interface, a wireless interface (e.g., a WI-FI interface), and is typically used to establish a communication link between the electronic apparatus 5 and other electronic devices.
Fig. 5 only shows the electronic device 5 with components 51-54, but it is to be understood that not all of the shown components are required to be implemented, and that more or fewer components may alternatively be implemented.
Optionally, the electronic device 5 may further include a user interface, which may include an input unit such as a Keyboard (Keyboard), a voice input device such as a microphone (microphone) or other devices with voice recognition function, a voice output device such as a sound box, a headset, etc., and optionally may also include a standard wired interface or a wireless interface.
In some embodiments, the electronic device 5 may be an L ED display, a liquid crystal display, a touch-sensitive liquid crystal display, an Organic light-Emitting Diode (O L ED) touch screen, or the like.
Optionally, the electronic device 5 may further include a Radio Frequency (RF) circuit, a sensor, an audio circuit, and the like, which are not described in detail herein.
In the apparatus embodiment shown in fig. 5, the memory 51, which is a kind of computer storage medium, may include therein an operating system, and a GDB data dynamic extension program 50; the following steps are implemented when the processor 52 executes the GDB data dynamic expansion program 50 stored in the memory 51: s110, establishing a report system database corresponding to a GDB database by defining a development mode, wherein the report system database comprises a GDB database table and a data table corresponding to the GDB database table; the development mode comprises a selection mode of a general interface of the GDB gathering processor, a calling mode of a database table and a calling mode of a storage process; s120, the report system database calls the data of the GDB database by taking the data table as a unit based on the development mode, and obtains logical operation data through the called data of the GDB database; and S130, presenting the acquired logic operation data on a terminal interface.
In other embodiments, the GDB data dynamic extension program 50 may also be divided into one or more modules, and the one or more modules are stored in the memory 51 and executed by the processor 52 to implement the present invention. The modules referred to herein are referred to as a series of computer program instruction segments capable of performing specified functions. The GDB data dynamic extension program 50 may be divided into a report system database creation unit, a logical operation data acquisition unit, and a logical operation data presentation unit.
In addition, the present invention also provides a computer-readable storage medium, where the computer-readable storage medium includes a GDB data dynamic extension program, and when executed by a processor, the GDB data dynamic extension program implements the following operations: s110, establishing a report system database corresponding to a GDB database by defining a development mode, wherein the report system database comprises a GDB database table and a data table corresponding to the GDB database table; the development mode comprises a selection mode of a general interface of the GDB gathering processor, a calling mode of a database table and a calling mode of a storage process; s120, the report system database calls the data of the GDB database by taking the data table as a unit based on the development mode, and obtains logical operation data through the called data of the GDB database; and S130, presenting the acquired logic operation data on a terminal interface.
The embodiment of the computer readable storage medium of the present invention is substantially the same as the embodiment of the GDB data dynamic expansion method and the electronic device, and will not be described herein again.
In summary, the GDB data dynamic expansion method of the present invention establishes a report system database through a user-defined factory agent mode, then uses the report system database to call the data of the GDB database and obtain the logic calculation data, and finally presents the obtained logic calculation data on a terminal interface; according to the invention, data interaction is not required through an API (application programming interface), and data directly enter a system database, so that the development process is simplified; the logical operation of the data reduces a JAVA code processing link and an API interface interaction link, the logical operation directly occurs in a database, the pressure of the server is reduced, the code amount is reduced, and the reasonable application of server resources is realized; when a new service module is needed, only data needs to be inserted into the database, and the API interface development link is reduced.
It should be noted that, in this document, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, apparatus, article, or method that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, apparatus, article, or method. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other like elements in a process, apparatus, article, or method that includes the element.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments. Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium (e.g., ROM/RAM, magnetic disk, optical disk) as described above and includes instructions for enabling a terminal device (e.g., a mobile phone, a computer, a server, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (10)
1. A GDB data dynamic expansion method applied to an electronic device is characterized by comprising the following steps:
s110, establishing a report system database corresponding to a GDB database by selecting a development mode, wherein the report system database comprises a GDB database table and a data table corresponding to the GDB database table; the development mode comprises a selection mode of a general interface of the GDB gathering processor, a calling mode for calling a data table and a calling mode of a storage process;
s120, the report system database calls the data of the GDB database by taking the data table as a unit based on the development mode, and obtains logical operation data through the called data of the GDB database;
and S130, presenting the acquired logic operation data on a terminal interface.
2. The GDB data dynamic expansion method of claim 1, wherein the method for calling GDB database data in step S120 includes:
s210, the database of the report system stores and stores the process according to the index of the report system;
s220, based on the GDB summarizing processor general interface method of the development mode, the realization class of the GDB summarizing processor interface corresponds to the data table and the storage process one by one;
and S230, calling a corresponding storage process by the report system database according to the implementation class.
3. The GDB data dynamic expansion method according to claim 2, wherein the stored procedure writes a SQ L statement set containing logical operation data for GDB database in database table unit.
4. The GDB data dynamic expansion method of claim 2, wherein a new user is created for the GDB database on a database server, and the new user is granted write authority to the reporting system database.
5. The GDB data dynamic expansion method of claim 1, wherein the process of obtaining logical operation data in the step S120 further comprises a write-back process, the write-back process comprising:
s310, writing the obtained logical operation data back to the report system database;
and S320, displaying the logical operation data on a terminal interface by the report system database.
6. A GDB data dynamic expansion system is characterized by comprising a report system database establishing unit, a logical operation data acquisition unit and a logical operation data presentation unit; wherein the content of the first and second substances,
the report system database establishing unit is used for establishing a report system database corresponding to the GDB database by selecting a development mode; the report system database comprises a GDB database table and a data table corresponding to the GDB database table; the development mode comprises a selection mode of a general interface of the GDB gathering processor, a calling mode for calling a data table and a calling mode of a storage process;
the logical operation data acquisition unit is used for calling the data of the GDB database by the report system database based on the development mode by taking the data table as a unit and acquiring logical operation data by the called data of the GDB database;
and the logic operation data presentation unit is used for presenting the acquired logic operation data on a terminal interface.
7. The GDB data dynamic expansion system of claim 6, wherein the logical operation data acquisition unit includes a data call module and a logical operation data acquisition module of a GDB database;
the data calling module of the GDB database is used for calling the data of the GDB database by the report system database based on the development mode by taking the data table as a unit;
and the logic operation data acquisition module is used for acquiring logic operation data through the data of the called GDB database.
8. The GDB data dynamic expansion system of claim 7, wherein the data call module of the GDB database includes a stored procedure storage sub-module, a stored procedure corresponding sub-module and a stored procedure call sub-module; wherein the content of the first and second substances,
the storage process storage submodule is used for storing the storage process according to the index of the report system through the database of the report system
The storage process corresponding submodule is used for carrying out one-to-one correspondence on the implementation class of the GDB summarizing processor interface, the data table and the storage process through a GDB summarizing processor total interface method based on the development mode;
and the storage process calling submodule is used for calling the corresponding storage process according to the implementation class through the report system database.
9. An electronic device, comprising: the GDB dynamic data expansion program comprises a memory and a processor, wherein the memory stores a GDB dynamic data expansion program, and the GDB dynamic data expansion program realizes the following steps when being executed by the processor:
s110, establishing a report system database corresponding to a GDB database by selecting a development mode, wherein the report system database comprises a GDB database table and a data table corresponding to the GDB database table; the development mode comprises a selection mode of a general interface of the GDB summarizing processor, a calling mode of a data table and a calling mode of a storage process;
s120, the report system database calls the data of the GDB database by taking the data table as a unit based on the development mode, and obtains logical operation data through the called data of the GDB database;
and S130, presenting the acquired logic operation data on a terminal interface.
10. A computer-readable storage medium, wherein a computer program is stored in the computer-readable storage medium, and the computer program comprises a GDB data dynamic extension program, and when the GDB data dynamic extension program is executed by a processor, the GDB data dynamic extension program implements the steps of the GDB data dynamic extension method according to any one of claims 1 to 5.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010170076.4A CN111459933B (en) | 2020-03-12 | 2020-03-12 | GDB data dynamic expansion method, device and storage medium |
| PCT/CN2020/125104 WO2021179636A1 (en) | 2020-03-12 | 2020-10-30 | Method for dynamic expansion of gdb data, device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010170076.4A CN111459933B (en) | 2020-03-12 | 2020-03-12 | GDB data dynamic expansion method, device and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111459933A true CN111459933A (en) | 2020-07-28 |
| CN111459933B CN111459933B (en) | 2023-06-06 |
Family
ID=71685861
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010170076.4A Active CN111459933B (en) | 2020-03-12 | 2020-03-12 | GDB data dynamic expansion method, device and storage medium |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN111459933B (en) |
| WO (1) | WO2021179636A1 (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2021179636A1 (en) * | 2020-03-12 | 2021-09-16 | 平安科技（深圳）有限公司 | Method for dynamic expansion of gdb data, device and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7984073B1 (en) * | 2004-07-09 | 2011-07-19 | Crossroads Systems, Inc. | System and method for providing service management in a distributed database system |
| CN103020158A (en) * | 2012-11-26 | 2013-04-03 | 中兴通讯股份有限公司 | Report form creation method, device and system |
| CN106598871A (en) * | 2016-12-29 | 2017-04-26 | 山东鲁能智能技术有限公司 | Automatic analysis method and system for collapse file under Linux |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111459933B (en) * | 2020-03-12 | 2023-06-06 | 平安科技（深圳）有限公司 | GDB data dynamic expansion method, device and storage medium |
-
2020
- 2020-03-12 CN CN202010170076.4A patent/CN111459933B/en active Active
- 2020-10-30 WO PCT/CN2020/125104 patent/WO2021179636A1/en active Application Filing
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7984073B1 (en) * | 2004-07-09 | 2011-07-19 | Crossroads Systems, Inc. | System and method for providing service management in a distributed database system |
| CN103020158A (en) * | 2012-11-26 | 2013-04-03 | 中兴通讯股份有限公司 | Report form creation method, device and system |
| CN106598871A (en) * | 2016-12-29 | 2017-04-26 | 山东鲁能智能技术有限公司 | Automatic analysis method and system for collapse file under Linux |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2021179636A1 (en) * | 2020-03-12 | 2021-09-16 | 平安科技（深圳）有限公司 | Method for dynamic expansion of gdb data, device and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111459933B (en) | 2023-06-06 |
| WO2021179636A1 (en) | 2021-09-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11656859B2 (en) | Data model API for live applications in a cloud collaboration platform | |
| CN108388622B (en) | API interface dynamic generation method and device, computer equipment and storage medium | |
| US9471345B2 (en) | Runtime generation and injection of java annotations | |
| CN106055368B (en) | application updating method and device | |
| US8924914B2 (en) | Application creation tool toolkit | |
| US20060095332A1 (en) | System and method for providing access to an application through a common interface for application extensions | |
| CN109710220B (en) | Relational database query method, relational database query device, relational database query equipment and storage medium | |
| CN111414350A (en) | Service generation method and device | |
| CN112364083A (en) | Data dictionary management method, system and storage medium based on configuration file | |
| US9606844B2 (en) | Remotely-hosted interactive client-server session | |
| US11645070B1 (en) | Documentation enforcement during compilation | |
| US9141353B2 (en) | Dynamically building locale objects at run-time | |
| CN111459933B (en) | GDB data dynamic expansion method, device and storage medium | |
| CN113485927A (en) | Test data generation method, device, equipment and storage medium | |
| CN113760733A (en) | Unit testing method and device | |
| US9298473B2 (en) | System and method for a generic object access layer | |
| CN114780497B (en) | Batch file processing method, apparatus, computer device, medium, and program product | |
| CN115080114B (en) | Application program transplanting processing method, device and medium | |
| CN113434582B (en) | Service data processing method and device, computer equipment and storage medium | |
| CN114489674A (en) | Data verification method and device of dynamic data model | |
| CN114819631A (en) | Multitask visualization method and device, computer equipment and storage medium | |
| CN114510334A (en) | Class instance calling method and device, electronic equipment and automatic driving vehicle | |
| CN113535565A (en) | Interface use case generation method, device, equipment, medium and program product | |
| CN112068814A (en) | Method, device, system and medium for generating executable file | |
| CN115766419B (en) | Digital serial number generation method and device in distributed environment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |