CN116028568A

CN116028568A - Financial service data export method and device and electronic equipment

Info

Publication number: CN116028568A
Application number: CN202310305018.1A
Authority: CN
Inventors: 洪麟; 曾纪才; 王仲; 郭德龙; 张永雷
Original assignee: Beijing Ctj Info Tech Co ltd
Current assignee: Beijing Ctj Info Tech Co ltd
Priority date: 2023-03-27
Filing date: 2023-03-27
Publication date: 2023-04-28

Abstract

The disclosure provides a financial service data export method and device and electronic equipment, and relates to the technical field of databases. The method comprises the following specific steps: creating a logic library, and sorting financial service data according to the logic library to generate a service table; acquiring the service table identifier selected by a user and acquiring the query condition configured by the user; and screening a target service table corresponding to the service table identifier according to the query condition, determining data to be exported, and generating an export command corresponding to the data to be exported. According to the method and the device, the data is screened according to the service table identification and the query condition selected by the user to generate the export command, so that screening and export of the data are realized, and convenience in data export is improved.

Description

Financial service data export method and device and electronic equipment

Technical Field

The disclosure relates to the technical field of databases, and in particular relates to a financial service data export method, a financial service data export device and electronic equipment.

Background

In the related technology, in the implementation process of the financial system, system business data are required to be exported to an auditing department when the financial data are externally examined, and the financial data are required to be exported according to certain business rules and technical standards because of strong business property. When the operator does not know the relation between the service table structure and the tables, the operator cannot write the export command of the target data to be exported, and cannot use the client tool to export the target data, so that the efficiency of exporting the data is low.

Disclosure of Invention

The disclosure provides a financial service data export method, a financial service data export device and electronic equipment, so as to at least solve the problem of low data export efficiency in the related technology. The technical scheme of the present disclosure is as follows:

according to a first aspect of an embodiment of the present disclosure, there is provided a financial service data export method, including:

creating a logic library, and sorting financial service data according to the logic library to generate a service table;

acquiring a service table identifier selected by a user and acquiring a query condition configured by the user;

and screening a target service table corresponding to the service table identifier according to the query condition, determining data to be exported, and generating an export command corresponding to the data to be exported.

Optionally, the creating a logical library table, and the step of sorting financial service data according to the logical library to generate a service table specifically includes:

acquiring the association among the fields, the table names and the tables according to a preset database specification, and creating the logic library;

and generating a physical library according to the financial service data, and creating an association between a logic table in the logic library and a physical table in the physical library.

Optionally, the query condition includes at least one of:

a target field;

target financial divisions.

Optionally, the step of screening the target service table corresponding to the service table identifier according to the query condition specifically includes:

inquiring the association between a logic library and the target business table;

responding to the target service table not belonging to the logic library, and throwing an exception;

and responding to the target service table belonging to the logic library, acquiring a target physical library corresponding to the target service table and a financial region corresponding to the target physical library, and acquiring the data to be exported according to the financial region corresponding to the target physical library and the target financial region.

Optionally, the step of generating the export command according to the financial region corresponding to the target physical library and the target financial region specifically includes:

responding to that the financial region corresponding to the target physical library is not the target financial region, and throwing an abnormality;

and responding to the financial region corresponding to the target physical library as the target financial region, and screening the data in the target physical library according to the target field to acquire the data to be exported.

Optionally, the step of screening the data in the target physical library according to the target field to obtain the data to be exported specifically includes:

acquiring a target field in the query condition;

determining the data corresponding to the target business table in the target physical library as the data to be exported in response to the query condition that the target field is not included;

and responding to the query condition comprising the target field, querying the target field in the target service table according to the target field, and acquiring the data to be exported.

Optionally, the step of querying the target field in the target service table according to the target field and acquiring the data to be exported specifically includes:

in response to the target service table not containing the target field, throwing an exception;

and determining the data containing the target field in the target service table as the data to be exported in response to the target field contained in the target service table.

Optionally, before the step of obtaining the query condition configured by the user, the method further includes:

and acquiring a storage path and a target file name configured by a user.

Optionally, the step of generating the export command corresponding to the data to be exported specifically includes:

and generating the export command according to the storage path, the target file name and the data to be exported.

According to a second aspect of the embodiments of the present disclosure, there is provided a financial service data deriving apparatus comprising:

the creation module is used for creating a logic library, and sorting financial service data according to the logic library to generate a service table;

the query module is used for acquiring the service table identifier selected by the user and acquiring the query condition configured by the user;

and the export module is used for screening the target service table corresponding to the service table identifier according to the query condition, determining data to be exported, and generating an export command corresponding to the data to be exported.

According to a third aspect of the embodiments of the present disclosure, there is provided an electronic device, including:

a processor;

a memory for storing the processor-executable instructions;

wherein the processor is configured to execute the instructions to implement the method of any of the first aspects.

According to a fourth aspect of embodiments of the present disclosure, there is provided a computer readable storage medium, which when executed by a processor of an electronic device, causes the electronic device to perform the method of any one of the first aspects.

The technical scheme provided by the embodiment of the disclosure at least brings the following beneficial effects:

and screening the data according to the service table identification selected by the user and the query condition to generate the export command. And the data can be exported according to the export command, so that automatic data export is realized, and the efficiency and convenience of data export are improved.

It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.

Drawings

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the disclosure and together with the description, serve to explain the principles of the disclosure and do not constitute an undue limitation on the disclosure.

FIG. 1 is a flow chart illustrating a method of financial transaction data export, according to an exemplary embodiment.

FIG. 2 is a flow chart illustrating a method of financial transaction data export, according to an exemplary embodiment.

FIG. 3 is a flow chart illustrating a method of financial transaction data export, according to an exemplary embodiment.

FIG. 4 is a flowchart illustrating a method of financial transaction data export, according to an exemplary embodiment.

FIG. 5 is a flowchart illustrating a method of financial transaction data export, according to an exemplary embodiment.

FIG. 6 is a schematic diagram illustrating a financial transaction data export interface, according to an example embodiment.

FIG. 7 is a schematic diagram illustrating a financial transaction data export interface, according to an example embodiment.

FIG. 8 is a schematic diagram illustrating a financial transaction data export interface, according to an example embodiment.

Fig. 9 is a block diagram illustrating a financial transaction data derivation device, according to an example embodiment.

Fig. 10 is a block diagram of an apparatus according to an example embodiment.

Fig. 11 is a block diagram of an apparatus according to an example embodiment.

Detailed Description

In order to enable those skilled in the art to better understand the technical solutions of the present disclosure, the technical solutions of the embodiments of the present disclosure will be clearly and completely described below with reference to the accompanying drawings.

It should be noted that the terms "first," "second," and the like in the description and claims of the present disclosure and in the foregoing figures are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that the embodiments of the disclosure described herein may be capable of operation in sequences other than those illustrated or described herein. The implementations described in the following exemplary examples are not representative of all implementations consistent with the present disclosure. Rather, they are merely examples of apparatus and methods consistent with some aspects of the disclosure as detailed in the accompanying claims.

The user information (including but not limited to user equipment information, user personal information, etc.) related to the present disclosure is information authorized by the user or sufficiently authorized by each party.

In the implementation process of the financial system, when the financial data is externally examined, system business data is needed to be exported to an audit department, and under the condition that the business table structure and the relation between tables are not clear, an implementation and maintenance person cannot write out sql sentences of target data to be exported, and the target data cannot be exported by using a client tool without correct sql sentences.

Because of the high business nature of financial data, it is necessary to export the data according to a variety of criteria. For example: the data table to be exported is exported according to the table specified in the technical standard 4.2 logical library table of the financial department, the data table to be exported according to the financial tenant or the financial year, the data table to be exported according to a certain business rule (constraint condition), and the like. Where tenant is an administrator identity description of a financial compartment, the tenant ID is typically identified using a compartment code.

Based on the above needs, there is a need to develop a specific financial business data export tool that can be used to generate sql statements that can export target data for the operators to export the final data through the database client tool.

FIG. 1 is a flow chart illustrating a method of financial transaction data export, as depicted in FIG. 1, according to an exemplary embodiment, the method comprising the steps of:

step 101, creating a logic library, and sorting financial service data according to the logic library to generate a service table.

In this embodiment, a logical library is first created with reference to a technical specification, where the logical library is a virtual library that is used to classify and design a database to implement unified management, but the logical library does not refer to a specific storage space. And according to the logic library, the financial service data can be arranged to generate a plurality of service tables, and each service table contains specific fields.

In one possible embodiment, the logical library is created with reference to the specification of the financial technical standard with respect to the logical library table and logical library table elements. The logical library table comprises an asset basic information table and an asset extension information table. The table name of the ASSET basic information table is BAS_ASSET_INFO, and is used for storing basic information, financial information, use information and disposal information of ASSET information. The table name of the ASSET expansion information table is BAS_ASSET_EXT, and is used for storing the characteristic information and the standby information of the ASSET information card.

The contents of the part contained in the asset basic information table are shown in table 1:

TABLE 1

The asset extension information table contains the partial contents as shown in table 2:

TABLE 2

The logical library table segments are arranged and de-duplicated to form logical library table elements, element information is refined from the aspects of value fields, field descriptions, reference sources and the like, and part of the logical library table elements are shown in table 3:

TABLE 3 Table 3

In one possible embodiment, after creating the logical library, the operator needs to sort the tables, and maintain all service tables according to the specification categories. The maintained tables are divided into three categories of service tables, configuration tables and basic tables, and the on-site operation and maintenance can modify the classification of the tables according to on-site conditions.

Step 102, obtaining the service table identification selected by the user and obtaining the query condition configured by the user.

And step 103, screening a target service table corresponding to the service table identifier according to the query condition, determining data to be exported, and generating an export command corresponding to the data to be exported.

In this embodiment, since the amount of data exported is large in the financial business data field, the data cannot be exported by sql or Excel, and the dmp file can be exported by using the Oracle export tool. Since the application server does not install the Oracle client tool, and particularly, there is generally not enough storage in the container environment, the dmp file cannot be directly exported by the service program, so that the data needs to be exported by the Oracle client tool after the Oracle export command is generated. The dmp file is a storage file exported by the oracle database, and the database can be backed up through the dmp file.

When specific data in a specific service table needs to be exported, a user is required to select a service table identifier to be exported, and a query condition is configured. The program can determine a corresponding target service table according to the service table identification, inquire a physical library corresponding to the target service table, and screen data in the physical library according to the inquiry condition to obtain data to be exported. And generating a export command according to the data to be exported, namely exporting the data to be exported according to the export command.

Optionally, in step 101 in fig. 1, creating a logical library table, and the step of sorting financial service data according to the logical library to generate a service table specifically includes:

The single-library list is the simplest application system architecture, only one physical library and one physical list are needed at this time, and an application server side is directly connected with a database for access. When the data quantity is too large, one database cannot meet the performance requirement, and then the database and table division design is needed.

Under the design of splitting and table splitting, one data table (physical table) needs to be split into a plurality of databases (physical libraries), the data table is split into a plurality of tables, and the plurality of tables are distributed into the plurality of databases. The application server cannot directly connect with the database at this time, and needs to perform routing query data through middleware supporting database distribution sub-tables. Because of the existence of the database middleware, the access process of the application server to the database is changed into the process of inquiring the logic table in the logic database, and the corresponding physical table is inquired through the database middleware according to the relation between the logic table and the physical table in the physical database.

Virtual libraries are ideal libraries for designs, but do not exist in reality, and physical libraries are specific implementations of ideal libraries for designs by designers, exist in reality.

Optionally, the query condition includes at least one of:

a target field;

target financial divisions.

In this embodiment, the financial division is an area divided based on administrative division and combined with the budget hierarchical management situation. The financial division is further arranged on the basis of the administrative division, and the special areas such as part of economic functional areas are inconsistent with the administrative division, but budget management is required to be carried out according to the special areas such as the economic functional areas as basic units. Screening financial business data may require screening by financial section.

FIG. 2 is a flow chart of a method of financial business data export, as shown in FIG. 2, and step 103 in FIG. 1 specifically includes the steps of:

step 201, inquiring the association between a logic library and the target business table;

step 202a, if the target service table does not belong to the logic library, an exception is thrown;

step 202b, in response to the target service table belonging to the logical library, acquiring a target physical library corresponding to the target service table and a financial region corresponding to the target physical library, and acquiring the data to be exported according to the financial region corresponding to the target physical library and the target financial region.

In this embodiment, after the service table identifier selected by the user and the query condition configured by the user are obtained, it is first confirmed whether the target service table corresponding to the service table identifier selected by the user exists in the logic library, if not, it is indicated that there is no logic table corresponding to the service table selected by the user, and of course, there is no corresponding physical table, the query cannot be continued, and the exception is thrown out.

FIG. 6 is a schematic diagram illustrating a financial transaction data export interface, according to an example embodiment. As shown in fig. 6, the interface of the data deriving tool is shown in fig. 6, the logic library and the logic library table therein are shown on the left side, the plurality of service tables contained in the selected logic library table are shown on the right side, each row corresponds to one service table, and the target service table selected by the user is marked at the leftmost position of each row.

FIG. 7 is a schematic diagram illustrating a financial transaction data export interface, according to an example embodiment. As shown in fig. 7, clicking the "data-out" button by the user on the basis of the operation in fig. 6 pops up the page in fig. 7, requiring the user to fill in the storage absolute path, file name, financial section, and constraints. The absolute path, namely the storage path, is stored for the dmp file generated after the data to be exported is exported, the file name is the name of the generated dmp file, the financial region and the limiting condition are the query conditions, and the absolute path and the file name are the contents which need to be filled in. After filling, clicking the 'confirm' button, the data export tool obtains the service list identification and the inquiry condition configured by the user, and inquires the logic library and the physical library.

FIG. 3 is a flow chart of a method of financial business data export, as shown in FIG. 3, and step 202b of FIG. 2 specifically includes the steps of:

step 203a, in response to the financial compartment corresponding to the target physical library not being the target financial compartment, throwing an exception;

and step 203b, in response to the financial region corresponding to the target physical library being the target financial region, screening the data in the target physical library according to the target field to obtain the data to be exported.

In this embodiment, after determining that the target service table belongs to the logical library, data screening is performed according to the financial regions first, so as to obtain a target physical library corresponding to the target service table and a financial region corresponding to the target physical library, and if the financial region corresponding to the target physical library does not belong to the target financial region, data in the target physical library does not need to be derived. If the financial region corresponding to the target physical library does not belong to the target financial region, further screening of the data in the target physical library is required according to the target field.

FIG. 4 is a flow chart of a financial business data export method, as shown in FIG. 4, according to an exemplary embodiment, step 202b in FIG. 3 specifically includes the steps of:

step 204, obtaining a target field in the query condition;

step 205a, determining the data corresponding to the target service table in the target physical library as the data to be exported in response to the query condition not including the target field;

and step 205b, responding to the query condition to contain the target field, and querying the target field in the target service table according to the target field and acquiring the data to be exported.

In this embodiment, the target field in the query condition is not necessarily a filling option, and if the query condition does not include the target field, all data in the target financial region needs to be exported, that is, the data corresponding to the target service table in the target physical library is exported. If the query condition contains the target field, further screening of the data in the target physical library is required according to the target field.

FIG. 5 is a flow chart of a financial business data export method, as shown in FIG. 5, according to an exemplary embodiment, where step 205b in FIG. 4 specifically includes the steps of:

step 206a, in response to the target service table not including the target field, throwing an exception;

and step 206b, in response to the target field being included in the target service table, determining the data including the target field in the target service table as the data to be exported.

and acquiring a storage path and a target file name configured by a user.

FIG. 8 is a schematic diagram illustrating a financial transaction data export interface, according to an example embodiment. As shown in fig. 8, after screening the physical library corresponding to the target service table according to the query condition, if the data to be exported is determined, the export tool can generate an export command in the graph; if an exception is thrown, a export command cannot be generated, and an exception prompt is displayed instead. After the export command is obtained, an operator can input the export command into an Oracle client and execute the export command, namely, a data file can be exported, the name of the data file is the target file name, and the export position is the storage path.

Fig. 9 is a block diagram of a financial transaction data derivation device, according to an example embodiment. Referring to fig. 9, the apparatus 300 includes:

a creation module 310, configured to create a logic library, and sort financial service data according to the logic library to generate a service table;

a query module 320, configured to obtain the service table identifier selected by the user, and obtain a query condition configured by the user;

and the export module 330 is configured to screen the target service table corresponding to the service table identifier according to the query condition, determine data to be exported, and generate an export command corresponding to the data to be exported.

The specific manner in which the various modules perform the operations in the apparatus of the above embodiments have been described in detail in connection with the embodiments of the method, and will not be described in detail herein.

Fig. 10 is a block diagram illustrating an apparatus 800 according to an example embodiment. For example, apparatus 800 may be a mobile phone, computer, digital broadcast terminal, messaging device, game console, tablet device, medical device, exercise device, personal digital assistant, or the like.

Referring to fig. 10, apparatus 800 may include one or more of the following components: a processing component 802, a memory 804, a power component 806, a multimedia component 808, an audio component 810, an input/output (I/O) interface 812, a sensor component 814, and a communication component 816.

The processing component 802 generally controls overall operation of the apparatus 800, such as operations associated with display, telephone calls, data communications, camera operations, and recording operations. The processing component 802 may include one or more processors 820 to execute instructions to perform all or part of the steps of the methods described above. Further, the processing component 802 can include one or more modules that facilitate interactions between the processing component 802 and other components. For example, the processing component 802 can include a multimedia module to facilitate interaction between the multimedia component 808 and the processing component 802.

The memory 804 is configured to store various types of data to support operations at the device 800. Examples of such data include instructions for any application or method operating on the device 800, contact data, phonebook data, messages, pictures, videos, and the like. The memory 804 may be implemented by any type or combination of volatile or nonvolatile memory devices such as Static Random Access Memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic or optical disk.

The power supply component 806 provides power to the various components of the device 800. The power components 806 may include a power management system, one or more power sources, and other components associated with generating, managing, and distributing power for the device 800.

The multimedia component 808 includes a screen between the device 800 and the user that provides an output interface. In some embodiments, the screen may include a Liquid Crystal Display (LCD) and a Touch Panel (TP). If the screen includes a touch panel, the screen may be implemented as a touch screen to receive input signals from a user. The touch panel includes one or more touch sensors to sense touches, swipes, and gestures on the touch panel. The touch sensor may sense not only the boundary of a touch or slide action, but also the duration and pressure associated with the touch or slide operation. In some embodiments, the multimedia component 808 includes a front camera and/or a rear camera. The front camera and/or the rear camera may receive external multimedia data when the device 800 is in an operational mode, such as a shooting mode or a video mode. Each front camera and rear camera may be a fixed optical lens system or have focal length and optical zoom capabilities.

The audio component 810 is configured to output and/or input audio signals. For example, the audio component 810 includes a Microphone (MIC) configured to receive external audio signals when the device 800 is in an operational mode, such as a call mode, a recording mode, and a voice recognition mode. The received audio signals may be further stored in the memory 804 or transmitted via the communication component 816. In some embodiments, audio component 810 further includes a speaker for outputting audio signals.

The I/O interface 812 provides an interface between the processing component 802 and peripheral interface modules, which may be a keyboard, click wheel, buttons, etc. These buttons may include, but are not limited to: homepage button, volume button, start button, and lock button.

The sensor assembly 814 includes one or more sensors for providing status assessment of various aspects of the apparatus 800. For example, the sensor assembly 814 may detect an on/off state of the device 800, a relative positioning of the components, such as a display and keypad of the apparatus 800, the sensor assembly 814 may also detect a change in position of the apparatus 800 or one component of the apparatus 800, the presence or absence of user contact with the apparatus 800, an orientation or acceleration/deceleration of the apparatus 800, and a change in temperature of the apparatus 800. The sensor assembly 814 may include a proximity sensor configured to detect the presence of nearby objects without any physical contact. The sensor assembly 814 may also include a light sensor, such as a CMOS or CCD image sensor, for use in imaging applications. In some embodiments, the sensor assembly 814 may also include an acceleration sensor, a gyroscopic sensor, a magnetic sensor, a pressure sensor, or a temperature sensor.

The communication component 816 is configured to facilitate communication between the apparatus 800 and other devices, either in a wired or wireless manner. The device 800 may access a wireless network based on a communication standard, such as WiFi, an operator network (e.g., 2G, 3G, 4G, or 5G), or a combination thereof. In one exemplary embodiment, the communication component 816 receives broadcast signals or broadcast related information from an external broadcast management system via a broadcast channel. In one exemplary embodiment, the communication component 816 further includes a Near Field Communication (NFC) module to facilitate short range communications. For example, the NFC module may be implemented based on Radio Frequency Identification (RFID) technology, infrared data association (IrDA) technology, ultra Wideband (UWB) technology, bluetooth (BT) technology, and other technologies.

In an exemplary embodiment, the apparatus 800 may be implemented by one or more Application Specific Integrated Circuits (ASICs), digital Signal Processors (DSPs), digital Signal Processing Devices (DSPDs), programmable Logic Devices (PLDs), field Programmable Gate Arrays (FPGAs), controllers, microcontrollers, microprocessors, or other electronic elements for executing the methods described above.

In an exemplary embodiment, a storage medium is also provided, such as a memory 804 including instructions executable by processor 820 of apparatus 800 to perform the above-described method. Alternatively, the storage medium may be a non-transitory computer readable storage medium, which may be, for example, ROM, random Access Memory (RAM), CD-ROM, magnetic tape, floppy disk, optical data storage device, and the like.

Fig. 11 is a block diagram illustrating an apparatus 900 according to an example embodiment. For example, apparatus 900 may be provided as a server. Referring to FIG. 11, apparatus 900 includes a processing component 922 that further includes one or more processors, and memory resources represented by memory 932, for storing instructions, such as applications, executable by processing component 1922. The application programs stored in memory 932 may include one or more modules that each correspond to a set of instructions. Further, processing component 922 is configured to execute instructions to perform the above-described methods.

The apparatus 900 may also include a power component 926 configured to perform power management of the apparatus 900, a wired or wireless network interface 950 configured to connect the apparatus 900 to a network, and an input output (I/O) interface 958. The device 900 may operate based on an operating system stored in memory 932, such as Windows Server, mac OS XTM, unixTM, linuxTM, freeBSDTM, or the like.

Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure disclosed herein. This application is intended to cover any adaptations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.

It is to be understood that the present disclosure is not limited to the precise arrangements and instrumentalities shown in the drawings, and that various modifications and changes may be effected without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.

Claims

1. A method for deriving financial business data, comprising:

2. The method of claim 1, wherein creating a logical library table, and organizing financial business data according to the logical library to generate a business table comprises:

3. The method of claim 2, wherein the query conditions include at least one of:

a target field;

target financial divisions.

4. The method of claim 3, wherein the step of screening the target service table corresponding to the service table identifier according to the query condition specifically includes:

5. The method of claim 4, wherein the step of generating the export command based on the financial compartment corresponding to the target physical library and the target financial compartment specifically comprises:

6. The method of claim 5, wherein the step of screening the data in the target physical library according to the target field to obtain the data to be exported specifically comprises:

acquiring a target field in the query condition;

7. The method of claim 6, wherein the step of querying the target field in the target service table according to the target field and obtaining the data to be exported specifically comprises:

8. The method according to any one of claims 1-7, wherein the step of obtaining user-configured query conditions is preceded by the step of:

and acquiring a storage path and a target file name configured by a user.

9. The method of claim 8, wherein the step of generating the export command corresponding to the data to be exported specifically includes:

10. A financial business data export apparatus comprising:

11. An electronic device, comprising:

a processor;

a memory for storing the processor-executable instructions;

wherein the processor is configured to execute the instructions to implement the method of any one of claims 1 to 9.

12. A computer readable storage medium, which when executed by a processor of an electronic device, causes the electronic device to perform the method of any of claims 1 to 9.