Unlock instant, AI-driven research and patent intelligence for your innovation.

Intelligent data accounting method, system, device and medium

A data and intelligent technology, applied in data processing applications, electrical digital data processing, natural language data processing, etc., can solve problems such as inconvenient accounting process, EXCEL direct connection database data security, etc., to achieve convenient accounting process and improve security Effect

Pending Publication Date: 2022-03-11
PING AN PENSION INSURANCE
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] In view of this, the purpose of the embodiment of the present invention is to provide an intelligent data accounting method, system, computer equipment and computer-readable storage medium, to solve the problem that the accounting process in the prior art is not convenient enough, and there is data security in the EXCEL direct connection database

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Intelligent data accounting method, system, device and medium
  • Intelligent data accounting method, system, device and medium
  • Intelligent data accounting method, system, device and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0040] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0041] The terms "first", "second", "third", "fourth", etc. (if any) in the description and claims of the present invention and the above drawings are used to distinguish similar objects, and It is not necessarily used to describe a particular order or sequence. It is to be understood that the terms so used are interchangeable under appropriate circumstances such that the embodiments descri...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The embodiment of the invention provides an intelligent data accounting method, which is applied to an intelligent data accounting system and comprises the following steps: when a table importing instruction or a table creating instruction input by a first user is obtained, importing or creating a table and displaying the table; obtaining service data corresponding to SQL information from a preset database by using the pre-configured SQL information, and filling the table with the service data; and performing data accounting on the business data by using a preset accounting method. According to the invention, the access of the database and the business data accounting are integrated in the same system, so that the problem that the accounting process is not convenient enough due to the isolation of an accounting tool EXCEL and the business data is solved. The service data is obtained through the system, so that a user is prevented from directly accessing a database, and the safety of the service data is greatly improved. Meanwhile, complex business data accounting is completed in the system, and the data access process is combined with business data accounting logic, so that the accounting process is more convenient.

Description

technical field [0001] The embodiments of the present invention relate to the field of computer data processing, and in particular to an intelligent data accounting method, system, computer equipment, and computer-readable storage medium. Background technique [0002] In banking, insurance and other financial industries, a large amount of business data is generated every month, accompanied by complicated business data accounting. At present, most of the data accounting relies on EXCEL to complete, but most of the business data is stored in various databases, such as: Oracle, DB2, PostGres, etc. When business personnel calculate business data, they need to extract data from the database into an EXCEL file, and then edit the formula for calculation. [0003] For business data accounting, the existing solutions have the following problems: [0004] EXCEL itself provides the function of exporting data from the database by configuring the data source and fetching SQL, but in ac...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/242G06F40/174G06Q10/10
CPCG06F16/2433G06F40/174G06Q10/10
Inventor 陈海安
Owner PING AN PENSION INSURANCE