CN112084246B - Financial software information acquisition method - Google Patents
Financial software information acquisition method Download PDFInfo
- Publication number
- CN112084246B CN112084246B CN202010926238.2A CN202010926238A CN112084246B CN 112084246 B CN112084246 B CN 112084246B CN 202010926238 A CN202010926238 A CN 202010926238A CN 112084246 B CN112084246 B CN 112084246B
- Authority
- CN
- China
- Prior art keywords
- database
- financial software
- information
- financial
- software
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 12
- 230000009191 jumping Effects 0.000 claims abstract description 8
- 238000013500 data storage Methods 0.000 claims description 2
- 230000007547 defect Effects 0.000 description 1
- 238000000605 extraction Methods 0.000 description 1
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/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
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Business, Economics & Management (AREA)
- Finance (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Accounting & Taxation (AREA)
- General Engineering & Computer Science (AREA)
- Software Systems (AREA)
- Development Economics (AREA)
- Computer Security & Cryptography (AREA)
- General Health & Medical Sciences (AREA)
- Bioethics (AREA)
- Health & Medical Sciences (AREA)
- Data Mining & Analysis (AREA)
- Computer Hardware Design (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Stored Programmes (AREA)
Abstract
The invention relates to a financial software information acquisition method. The method comprises the following steps: step 1, judging the type of a financial software database and connecting the types; step 2, extracting a user name and a table under the user name; step 3, the acquired information is stored in a preset support database, and the name of the financial software database is used as the table name of the support database; step 4, providing a preset tMenu table; step 5, comparing the n pieces of financial software interface information in the tMenu table with the names of the support databases and the information in the support databases in the step 3 respectively, and jumping to the step 6 when the types of the compared databases and the names of the databases are matched, otherwise jumping to the step 7; step 6, the information in the financial software database is acquired according to the interface code; and 7, ending the collection of the information in the financial software database. The invention can effectively determine the information of the financial business software and improve the reliability of the information acquisition of the financial software.
Description
Technical Field
The invention relates to a collection method, in particular to a collection method of financial software information.
Background
At present, the same computer or server is provided with a plurality of financial service software, and due to different setting conditions of different financial service software and the like, only one financial service software or less financial service software which can be found on the surface can be obtained when the information of the financial service software is acquired, and the problem of missing or less financial service software can be caused when the data is extracted.
In addition, there may be a case where only the database is backed up and there is no software name, and for the case where the software name information cannot be determined, how to obtain the data of the financial service software cannot be determined, and the actual data acquisition requirement cannot be satisfied.
Disclosure of Invention
The invention aims to overcome the defects in the prior art and provide a method for acquiring financial software name information, which can effectively determine the information of financial business software and improve the reliability of financial software information acquisition.
According to the technical scheme provided by the invention, the acquisition method of the financial software information comprises the following steps:
step 1, providing a financial software database to be subjected to data acquisition, judging the type of the financial software database and connecting the types of the financial software database;
step 2, extracting user names contained in the connected financial software database and a table under the extracted user names from the connected financial software database;
step 3, acquiring information in a financial software database, storing the acquired information in a preset support database, and taking the name of the financial software database as the table name of a data table in the support database;
step 4, providing a preset tMenu table, wherein the tMenu table comprises n pieces of financial software interface information, and the financial software interface information comprises a serial number ID, an interface code, a database type and a financial software data table name;
step 5, comparing n pieces of financial software interface information in the tMenu table with the names of the support databases in step 3 and the information in the support databases respectively, recording the number of interface codes and corresponding interface codes when the types of the compared databases and the names of the databases are matched, and jumping to step 6, otherwise jumping to step 7;
step 6, outputting and recording financial software names corresponding to the interface codes, and acquiring information in a financial software database according to the interface codes;
and 7, prompting that the database of the financial software is unknown financial software, and ending the collection of the information in the database of the financial software.
In step 1, the financial software database is a single-board database or a network-board database, and the types of the financial software databases are an ACCESS database, a SQLServer database, a Sybase database, an Oracle database, a DBaseIII database, an Anywhite database, an intersase database, a DB2 database, a foxprop database, a Paradox database, a SQLLite database, or a Firebard database.
In step 3, the information in the accounting software database is obtained including user, table, dbtype, dbconnect, dbuser, and dbkey.
The invention has the advantages that: the information of the financial business software can be effectively determined, and the reliability of information acquisition of the financial software is improved.
Drawings
FIG. 1 is a flow chart of the present invention.
Detailed Description
The invention will be further described with reference to the following specific drawings and examples.
As shown in fig. 1: in order to effectively determine the information of financial business software and improve the reliability of the information acquisition of the financial business software, the acquisition method of the invention comprises the following steps:
step 1, providing a financial software database to be subjected to data acquisition, judging the type of the financial software database and connecting the types of the financial software database;
specifically, the provided accounting software database refers to the situation that only the database is backed up and no accounting software name exists, or other accounting software databases which do not specifically provide accounting software names exist, the accounting software database is a single-board accounting software database or a network-board accounting software database, the single-board accounting software database such as an access database, that is, a file of mdb is normally stored on a billing computer, and the network-board accounting software database can be accessed and connected through a network protocol, and the storage position is generally on a database server.
The financial software database is of the type ACCESS database, SQLServer database, sybase database, oracle database, DBaseIII database, anyWhere database, interBase database, DB2 database, foxProv database, paradox database, SQLLite database or Firebard database. Normally, the type of the financial software database can be confirmed according to the file suffix name or the direct inquiry technology responsible person, and the connection can be sequentially tried according to the type of the financial software database.
In the embodiment of the invention, to establish connection with the financial software database, connection parameters of the financial software database, such as the sql server financial software database, must be confirmed, to establish connection with the financial software database, ip address, port number, instance name, user name and password must be confirmed, and other databases can establish connection only by finding the corresponding data file and accessed user name and password without needing so many parameters, such as the anysphere financial software database, so that access to the financial software database is realized. After obtaining the type of the financial software database, the implementation of the connection with the financial software database is well known to those skilled in the art, and will not be described here again.
Step 2, extracting user names contained in the connected financial software database and a table under the extracted user names from the connected financial software database;
in the embodiment of the invention, when the financial software database is normally accessed, the corresponding user name and password are needed, and the table under the user name is the table owned by the login user name. In the implementation, the user name and the table under the user name are extracted to play a role in positioning, and the required data storage position can be accurately found according to the information. According to the type of financial software database, the user name and the table under the user name can be extracted by the teacher's brother by adopting the technical means commonly used in the technical field, and the specific extraction process is well known to the person skilled in the technical field and is not repeated here. Generally, the specific contents of the table under the user name are related to the financial software database, and are well known to those skilled in the art, and will not be described herein.
Step 3, acquiring information in a financial software database, storing the acquired information in a preset support database, and taking the name of the financial software database as the table name of a data table in the support database;
according to the embodiment of the invention, the information in the financial software database can be obtained according to the extracted user name and the positioning function of the table under the user name. The information in the acquisition finance software database comprises a user (user in the database), a table, a dbtype, a dbconnect (connection string of the database), a dbuser (user name of the connection database) or a dbkey (password of the connection database).
After connecting with the financial software database, the name of the financial software database can be determined. When the name of the financial software database is used as the table name of the support database, the distinction between different financial software databases can be realized when the different financial software databases are verified.
Step 4, providing a preset tMenu table, wherein the tMenu table comprises n pieces of financial software interface information, and the financial software interface information comprises a serial number ID, an interface code, a database type and a table name of financial software data;
in the embodiment of the present invention, n pieces of financial software interface information are set in the tMenu table, where each piece of financial software interface information includes a serial number ID, an interface code, a database type, and a table name of financial software data, and the specific size of the number n of financial software interface information can be selected according to actual needs, which is well known to those skilled in the art and will not be repeated herein. The required association and positioning can be realized through the serial number ID.
Step 5, comparing n pieces of financial software interface information in the tMenu table with the names of the support databases in step 3 and the information in the support databases respectively, recording the number of interface codes and corresponding interface codes when the types of the compared databases and the names of the databases are matched, and jumping to step 6, otherwise jumping to step 7;
in the embodiment of the invention, only when the type of the database and the name of the database are matched, the number of the interface codes is recorded, and corresponding interface code information is recorded, wherein the interface code information can comprise the type of the database, the name of the database and the like, and can be specifically selected according to the needs.
Step 6, outputting and recording financial software names corresponding to the interface codes, and acquiring information in a financial software database according to the interface codes;
in the embodiment of the invention, when the number of the recorded interface codes is not 0, the information such as the financial software name of the financial software database to be collected can be confirmed, so that the collection of the information in the financial software database can be realized according to the existing common technical means, and the specific information collection mode and the like are consistent with the existing information, and are well known to the person skilled in the art and are not repeated herein.
And 7, prompting that the database of the financial software is unknown financial software, and ending the collection of the information in the database of the financial software.
In the embodiment of the invention, when the number of the recorded interface codes is 0, specific information of the financial software database to be acquired by information, such as names of the financial software database and corresponding interface information during acquisition, can not be confirmed after comparison, and at this time, the acquisition of the information in the financial software database can not be directly realized.
Naturally, after the above steps 6 and 7, deleting the data table database using the financial software database as the table name in step 3, and ending the whole information collection process.
Claims (2)
1. The acquisition method of the financial software information is characterized by comprising the following steps:
step 1, providing a financial software database to be subjected to data acquisition, judging the type of the financial software database and connecting the types of the financial software database;
the financial software database is a financial software database with only database backup and no financial software name or a financial software database without specific financial software name;
step 2, extracting user names contained in the connected financial software database and a table under the extracted user names for the connected financial software database so as to play a role in positioning based on the extracted user names and the table under the user names, and finding out the required data storage position;
step 3, acquiring information in a financial software database, storing the acquired information in a preset support database, and taking the name of the financial software database as the table name of a data table in the support database;
in step 3, the information in the financial software database comprises a user, a table, a database type dbtype, a connection character string dbconnect of the database, a user name dbuser connected with the database or a password dbkey connected with the database;
step 4, providing a preset tMenu table, wherein the tMenu table comprises n pieces of financial software interface information, and the financial software interface information comprises a serial number ID, an interface code, a database type and a financial software data table name;
step 5, comparing the n pieces of financial software interface information in the tMenu table with the names of the support databases and the information in the support databases in step 3 respectively, recording the number of interface codes and corresponding interface codes based on the n pieces of financial software interface information in the tMenu table when the types of the compared databases and the names of the databases are matched, and jumping to step 6, otherwise jumping to step 7;
step 6, outputting and recording financial software names corresponding to the interface codes, and acquiring information in a financial software database according to the interface codes;
and 7, prompting that the database of the financial software is unknown financial software, and ending the collection of the information in the database of the financial software.
2. The method for collecting financial software information according to claim 1, wherein: in step 1, the financial software database is a single-board database or a network-board database, and the types of the financial software databases are an ACCESS database, a SQLServer database, a Sybase database, an Oracle database, a DBaseIII database, an Anywhite database, an intersase database, a DB2 database, a foxprop database, a Paradox database, a SQLLite database, or a Firebard database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010926238.2A CN112084246B (en) | 2020-09-07 | 2020-09-07 | Financial software information acquisition method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010926238.2A CN112084246B (en) | 2020-09-07 | 2020-09-07 | Financial software information acquisition method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112084246A CN112084246A (en) | 2020-12-15 |
| CN112084246B true CN112084246B (en) | 2024-03-08 |
Family
ID=73732874
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010926238.2A Active CN112084246B (en) | 2020-09-07 | 2020-09-07 | Financial software information acquisition method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112084246B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113326308B (en) * | 2021-06-16 | 2023-04-07 | 黑龙江八一农垦大学 | Intelligent integration method and device for financial data and processor |
| CN115757595B (en) * | 2022-12-09 | 2023-12-12 | 深圳市聚聚科技有限公司 | Financial software information acquisition method |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109697202A (en) * | 2018-12-29 | 2019-04-30 | 中国联合网络通信集团有限公司 | Account management method and equipment |
-
2020
- 2020-09-07 CN CN202010926238.2A patent/CN112084246B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109697202A (en) * | 2018-12-29 | 2019-04-30 | 中国联合网络通信集团有限公司 | Account management method and equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112084246A (en) | 2020-12-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110879813B (en) | Binary log analysis-based MySQL database increment synchronization implementation method | |
| US8312150B2 (en) | System and method for flexible data transfer | |
| CN1184561C (en) | Method, device and program for structure actuation environment and computer readable medium | |
| CN110569214B (en) | Index construction method and device for log file and electronic equipment | |
| US7200624B2 (en) | Systems and methods for versioning based triggers | |
| CN112084246B (en) | Financial software information acquisition method | |
| CN106815326B (en) | System and method for detecting consistency of data table without main key | |
| JP2002523835A5 (en) | ||
| CN108563535B (en) | Recovery method for MySQL database whole database | |
| CN106445476B (en) | Code change information determination method and device and electronic equipment | |
| CN110941629B (en) | Metadata processing method, apparatus, device and computer readable storage medium | |
| US20020143794A1 (en) | Method and system for converting data files from a first format to second format | |
| CN112328631A (en) | Production fault analysis method and device, electronic equipment and storage medium | |
| US8788460B2 (en) | Exploring attached and unattached content databases | |
| CN107609151A (en) | The method that XBRL instance documents caching is realized based on Redis | |
| CN117539849A (en) | Data migration method and device of heterogeneous database, storage medium and electronic device | |
| CN117112408A (en) | Method, device and medium for generating automatic test case script | |
| CN103150207A (en) | Collaborative processing method and system for engineering exploration data computer | |
| KR101024494B1 (en) | Extraction method of modified data using meta data | |
| CN108090095B (en) | Method and device for reconstructing database in batches | |
| CN117349356A (en) | Data information acquisition method | |
| CN112764740B (en) | Shell-based processing method applied to file interaction between systems | |
| CN118277381A (en) | Aeroengine parameter storage method based on zipper structure | |
| TWI590084B (en) | Method and system for accessing database | |
| CN113362007B (en) | Zero inventory record processing method |
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 |