CN110008264B - Data acquisition method and device of cost accounting system - Google Patents
Data acquisition method and device of cost accounting system Download PDFInfo
- Publication number
- CN110008264B CN110008264B CN201910161322.7A CN201910161322A CN110008264B CN 110008264 B CN110008264 B CN 110008264B CN 201910161322 A CN201910161322 A CN 201910161322A CN 110008264 B CN110008264 B CN 110008264B
- Authority
- CN
- China
- Prior art keywords
- data
- cost accounting
- external
- data domain
- domain
- 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
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/25—Integrating or interfacing systems involving database management systems
- G06F16/258—Data format conversion from or to a database
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The embodiment of the invention is suitable for the technical field of data processing, and provides a data acquisition method and a device of a cost accounting system, wherein the method comprises the following steps: determining an external system to be acquired, the external system having a plurality of external data fields; respectively identifying whether any external data domain has a corresponding cost accounting data domain in the cost accounting system; if so, importing the data in the external data domain into a corresponding cost accounting data domain; if not, identifying the data type corresponding to the external data domain, determining the cost accounting data domain corresponding to the external data domain based on the data type, and importing the data in the external data domain into the corresponding cost accounting data domain. The embodiment can realize the intellectualization, the automation and the standardization of the accounting mode without manual intervention, and greatly improves the accounting efficiency.
Description
Technical Field
The invention belongs to the technical field of data processing, and particularly relates to a data acquisition method of a cost accounting system, a data acquisition device of the cost accounting system, the cost accounting system and a computer readable storage medium.
Background
Cost accounting is an important component of cost management work, and means that various consumptions generated in the production and operation process of an enterprise are distributed and collected according to a certain object to calculate the total cost and the unit cost. Through cost accounting, the execution conditions of budget and cost plan can be checked, supervised and assessed, the cost level is reflected, the performance of cost control and the cost management level are checked and measured, the effectiveness of a cost management system is evaluated, the cost can be reduced in research, and continuous improvement is carried out.
Take a hospital as an example. Cost accounting in hospitals requires data collection from various external systems. For example, the HIS System (Hospital Information System), financial System, salary System, asset System, and materials management System. And then calculating according to the set apportionment method to form a cost correlation chart.
Since cost accounting requires data collection from multiple external systems, a data mapping relationship between the accounting system and the external systems must be established. However, due to the diversification of external systems, only a certain typical system can be referenced for simulation in the system design stage, and adjustment is performed when the system is implemented. When the data relationship between the cost accounting system and the external system is not a standard one-to-one or one-to-many relationship but a many-to-many relationship, the prior art cannot establish a clear mapping relationship between the cost accounting system and the external system, needs manual intervention, cannot realize intellectualization, automation and standardization of an accounting mode, and has low accounting efficiency.
Disclosure of Invention
In view of this, embodiments of the present invention provide a data acquisition method and apparatus for a cost accounting system, so as to solve the problem in the prior art that the cost accounting is low in automation degree.
A first aspect of an embodiment of the present invention provides a data acquisition method for a cost accounting system, including:
determining an external system to be acquired, the external system having a plurality of external data fields;
respectively identifying whether any external data domain has a corresponding cost accounting data domain in the cost accounting system;
if the external data domain has a corresponding cost accounting data domain in the cost accounting system, importing the data in the external data domain into the corresponding cost accounting data domain;
if the external data domain does not have the corresponding cost accounting data domain in the cost accounting system, identifying the data type corresponding to the external data domain, determining the cost accounting data domain corresponding to the external data domain based on the data type, and importing the data in the external data domain into the corresponding cost accounting data domain.
A second aspect of an embodiment of the present invention provides a data acquisition apparatus for a cost accounting system, including:
an external system determination module for determining an external system to be acquired, the external system having a plurality of external data fields;
the data domain identification module is used for respectively identifying whether any external data domain has a corresponding cost accounting data domain in the cost accounting system;
the first data importing module is used for importing the data in the external data domain into a corresponding cost accounting data domain if the external data domain has the corresponding cost accounting data domain in the cost accounting system;
and the second data importing module is used for identifying the data type corresponding to the external data domain if the external data domain does not have the corresponding cost accounting data domain in the cost accounting system, determining the cost accounting data domain corresponding to the external data domain based on the data type, and importing the data in the external data domain into the corresponding cost accounting data domain.
A third aspect of an embodiment of the present invention provides a cost accounting system, including a memory, a processor, and a computer program stored in the memory and executable on the processor, where the processor implements the steps of the data acquisition method of the cost accounting system when executing the computer program.
A fourth aspect of the embodiments of the present invention provides a computer-readable storage medium, which stores a computer program, and when the computer program is executed by a processor, the computer program implements the steps of the data acquisition method of the cost accounting system.
Compared with the prior art, the embodiment of the invention has the following advantages:
according to the embodiment of the invention, whether any external data domain has a corresponding cost accounting data domain is identified, and if the external data domain has the corresponding cost accounting data domain, data can be directly imported; if not, the data type of the external data field can be used as a parameter to search until the corresponding cost accounting data field is found. According to the embodiment, the intelligent, automatic and standardized accounting mode can be realized without manual intervention by establishing the mapping relation between the external data domain and the cost accounting data domain, and the accounting efficiency is greatly improved.
In a specific implementation process, the embodiment can implement the determination of the data domain mapping relationship by maintaining the content of the data domain mapping relationship table and the classification function based on the background database, thereby improving the universality and flexibility of the software system, and users can freely define the classification function without modifying source codes for different systems. Secondly, since the classification function is independent of the system, the service logic can be completely defined by the user, and the independence of the software system is correspondingly improved.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings used in the embodiments or the description of the prior art will be briefly described below. It is obvious that the drawings in the following description are only some embodiments of the invention, and that for a person skilled in the art, other drawings can be derived from them without inventive effort.
FIG. 1 is a schematic flow chart illustrating the steps of a data collection method of a cost accounting system according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a hospital cost accounting flow in accordance with one embodiment of the present invention;
FIG. 3 is a schematic diagram of data type identification according to an embodiment of the invention;
FIG. 4 is a diagram of determining a cost accounting data field based on data type according to one embodiment of the invention;
FIG. 5 is a flow diagram of a call classification function to determine a cost accounting data field according to one embodiment of the invention;
FIG. 6 is a schematic data collection flow diagram of a cost accounting system in accordance with one embodiment of the present invention;
FIG. 7 is a schematic diagram of a data acquisition device of a cost accounting system in accordance with one embodiment of the present invention;
FIG. 8 is a schematic diagram of a cost accounting system of one embodiment of the present invention.
Detailed Description
In the following description, for purposes of explanation and not limitation, specific details are set forth, such as particular system structures, techniques, etc. in order to provide a thorough understanding of the embodiments of the invention. It will be apparent, however, to one skilled in the art that the present invention may be practiced in other embodiments that depart from these specific details. In other instances, detailed descriptions of well-known systems, devices, circuits, and methods are omitted so as not to obscure the description of the present invention with unnecessary detail.
The technical solution of the present invention will be described below by way of specific examples.
Referring to fig. 1, a schematic flow chart illustrating steps of a data acquisition method of a cost accounting system according to an embodiment of the present invention is shown, which may specifically include the following steps:
s101, determining an external system to be acquired, wherein the external system is provided with a plurality of external data fields;
it should be noted that the method can be applied to cost accounting in various industries. Such as a business, school, hospital, etc., and the present embodiment is not limited thereto.
For the convenience of understanding, the following description will be made by taking cost accounting of a hospital as an example.
Fig. 2 is a schematic diagram of the hospital cost accounting process of the present invention. As can be seen from fig. 2, hospitals have a large number of external systems involved in performing cost accounting. For example, there are salary management systems, materials management systems, asset management systems, HIS systems, accounting systems, and so forth. For such a plurality of external systems, data processed by each system needs to be uniformly imported into a cost accounting system for accounting, so that a final apportionment result is calculated, a cost analysis table is formed, and the cost analysis table is used as a reference for medical staff bonus, performance and future budget.
In the embodiment of the present invention, when data of an external system is imported into the cost accounting system for accounting, it may be determined which external system is currently acquired.
As shown in fig. 3, it is assumed that data of the external system O needs to be imported into the cost accounting system C. Wherein the external system O comprises a plurality of external data fields O1、O2、O3、O4Etc., are uniformly set to OxThe cost accounting system comprises a plurality of cost accounting data fields C1、C2、C3、C4Etc., are uniformly set to Cx. A data field refers to a collection of specific data types, such as an "identification number" data field, within whichThe specific identification number is stored.
S102, respectively identifying whether any external data domain has a corresponding cost accounting data domain in the cost accounting system;
in the embodiment of the present invention, for any external data field, it may be determined first whether the data field has a corresponding cost accounting data field in the cost accounting system. If so, step S105 may be executed to directly import the data in the external data field into the corresponding cost accounting data field.
In a specific implementation, whether any external data domain has a corresponding cost accounting data domain in the data domain mapping relation table can be respectively identified by acquiring a preset data domain mapping relation table.
The data domain mapping table may be used to record the correspondence between the external system and the cost accounting system. As mentioned above, the data domain correspondence between the external system O and the cost accounting system C may refer to a certain data domain O of the external system OxWith a certain data field C in the cost accounting system CxThere is an equality or containment relationship.
As shown in Table one, is an example of a data domain mapping relationship table.
Table one:
| serial number | External data field | Cost accounting system data fields | Whether to classify a function |
| 1 | O1 | C1 | Whether or not |
| 2 | O2 | C1 | Whether or not |
| 3 | …… | …… | …… |
| 4 | On | F(x1,x2,……,xn) | Is that |
The external data field marked as "no" in the "classification function" column indicates that a corresponding data field exists in the cost accounting system data field. For example, the external data field O in Table I above1And cost accounting system data field C1Have corresponding relation, and the data type of the two is the same. Otherwise, the cost accounting data domain corresponding to the external data domain needs to be further identified by executing steps S103-S104.
S103, identifying a data type corresponding to the external data domain;
in the embodiment of the present invention, if the cost accounting data domain having a corresponding relationship with the external data domain is not found by searching the data domain mapping relationship table, the data type of the external data domain may be further identified.
As shown in fig. 4, the data field "drug fee" in the external system H cannot find a certain data field in the cost accounting system C because it may be "income of chinese medicine" or "income of western medicine". At this time, it may be determined that the data type of the data field of "drug fee" may be "drug classification" based on the predetermined basic material M. Then, according to the data type, the cost accounting data field corresponding to the 'drug cost' is continuously determined.
S104, determining a cost accounting data domain corresponding to the external data domain based on the data type;
in the embodiment of the present invention, after the data type of the external data field is determined, the corresponding cost accounting data field may be determined based on the data type.
In a specific implementation, a search path and a search target may be set in advance for each data type according to different data types, and after a data type of a certain external data domain is identified, the data type may be searched based on the search path and the search target to obtain a corresponding search result. Because each search result only has a unique cost accounting type, after the search result is obtained and the corresponding cost accounting type is determined, the cost accounting data field corresponding to the external data field can be determined according to the cost accounting type.
In the embodiment of the present invention, in order to determine the cost accounting data field corresponding to the cost accounting type, a data dictionary may be first established, and then the cost accounting data field corresponding to the cost accounting type in a preset data dictionary may be determined.
In the embodiment of the present invention, a plurality of cost accounting categories may be identified, and then a corresponding cost accounting data field of each cost accounting category in the cost accounting system is determined, and an association relationship between each cost accounting category and the corresponding cost accounting data field is established, so as to generate the data dictionary based on the association relationship.
As shown in table two, it is an example of a data dictionary according to the embodiment of the present invention.
Watch two
As an example of the present invention, the above search process may be implemented by performing a specific classification function. Fig. 5 is a schematic flow chart illustrating a process of determining a cost accounting data field by calling a classification function according to an embodiment of the present invention. According to the process shown in fig. 5, a classification function may be called by using a data type as a parameter, a meaning and a search path represented by the parameter are determined by searching a parameter mapping table, and a value corresponding to an actual parameter (generally, a parameter is given a specific numerical value and then referred to as an actual parameter) is searched according to a search target, and is set to V.
As shown in table three, this is an example of a parameter mapping table according to an embodiment of the present invention.
Table three:
| serial number | Function name | Parameter(s) | Searching for a path | Key word | Searching for objects | Search results |
| 1 | F1() | x1 | Server1.His.Tb_Medicines | Med_ID | Med_Class | Class of drug |
| 2 | F1() | x2 | Server2.Hrp.Tb_Dept | Dep_ID | Dep_Class | Department classification |
| 3 | …… | …… | …… | …… | …… | …… |
| 4 | Fn() | xn | Serverx.dbo.Tb_X | X_ID | X_Class | X_Class |
In the embodiment of the present invention, in order to find the cost accounting data field in the cost accounting system C corresponding to V, a pre-established data dictionary may be searched, and the data field recorded in the data dictionary may be used as the cost accounting data field corresponding to the external data field.
For example, in the above example, after obtaining V ═ western medicine "through the iteration parameter, the cost accounting data field corresponding to C may be obtained as" western medicine income C "according to the data dictionary7", and takes the result as the returned result of the classification function.
It should be noted that the external data field may include a plurality of data types. If the cost accounting type searched according to the method does not have the corresponding cost accounting data domain in the preset data dictionary, the search of other data types can be continued to obtain the corresponding search result until the cost accounting data domain corresponding to the external data domain is determined according to the search result, and the process is ended.
Of course, after the cost accounting data fields corresponding to the external data are obtained, the external data fields and the cost accounting data fields corresponding to the external data can be written into the preset data field mapping relation table, so that when data are subsequently imported, if an external system changes, system source codes do not need to be changed, and only the content of the data field mapping relation table needs to be updated.
After determining the cost accounting data domain corresponding to each external data domain, step S105 may be executed to import the data in the external data domain into the corresponding cost accounting data domain.
And S105, importing the data in the external data domain into a corresponding cost accounting data domain.
After the data in each external data domain is imported into the cost accounting system, the cost accounting system can perform cost accounting according to the imported data.
For ease of understanding, the data collection method of the cost accounting system of the present invention is described below as a complete example.
Fig. 6 is a schematic diagram of a data collection flow of the cost accounting system according to an embodiment of the present invention. In the example shown in FIG. 6, the cost accounting data field is determined by calling a classification function.
(1) A data domain mapping relation table L is established for registering the correspondence between the external system O and the cost accounting system C. As shown in table one.
(2) If for a certain data field OxThe corresponding data field C can be found in CxSo that there is an equality or containment relationship between the two, the data field O is directly setxData import C in (1)x(ii) a Otherwise, a classification function is called for further analysis.
(3) Classification function F (x)1,x2……xn) Is an application independent of the cost accounting system, where x1,x2……xnIs an input parameter of a function for being OxFinding definite CxThis determined CxIs the return value of the classification function.
In particular, the classification function F (x)1,x2……xn) Any parameter x can be determined by looking up a parameter mapping tablenAnd the represented meaning and the search path are set as V by searching a value corresponding to the actual parameter xn' according to the search target. The parameter mapping table is shown in table three.
(4) To find the data field in the cost accounting system C corresponding to V, a data dictionary D may be created, the format of which is shown in table two.
(5) If the V value does not find a corresponding value in the data dictionary D, the same operation is performed on the next parameter using an iterative algorithm.
(6) If iteration reaches a certain parameter, V is obtained as western medicine, and according to the data dictionary, a data field 'western medicine income C' corresponding to C is obtained7", as a classification function F (x)1,x2……xn) Returns the result.
(7) And repeating the steps for different external systems until all the data mapping relations are established. If the external system changes, only the content of the data domain mapping relation table needs to be updated without changing the system source code. After the content of the data field mapping relationship table is completed, data acquisition can be performed according to the flow shown in fig. 6.
In the embodiment of the invention, whether any external data domain has a corresponding cost accounting data domain is identified, and if the external data domain has the corresponding cost accounting data domain, the data can be directly imported; if not, the data type of the external data field can be used as a parameter to search until the corresponding cost accounting data field is found. According to the embodiment, the intelligent, automatic and standardized accounting mode can be realized without manual intervention by establishing the mapping relation between the external data domain and the cost accounting data domain, and the accounting efficiency is greatly improved. In a specific implementation process, the embodiment can implement the determination of the data domain mapping relationship by maintaining the content of the data domain mapping relationship table and the classification function based on the background database, thereby improving the universality and flexibility of the software system, and users can freely define the classification function without modifying source codes for different systems. Secondly, since the classification function is independent of the system, the service logic can be completely defined by the user, and the independence of the software system is correspondingly improved.
It should be noted that, the sequence numbers of the steps in the foregoing embodiments do not mean the execution sequence, and the execution sequence of each process should be determined by the function and the internal logic of the process, and should not constitute any limitation on the implementation process of the embodiments of the present invention.
Referring to fig. 7, a schematic diagram of a data acquisition device of a cost accounting system according to an embodiment of the present invention is shown, which may specifically include the following modules:
an external system determination module 701, configured to determine an external system to be acquired, where the external system has a plurality of external data fields;
a data domain identification module 702, configured to identify whether any external data domain has a corresponding cost accounting data domain in the cost accounting system;
a first data importing module 703, configured to import data in the external data domain into a corresponding cost accounting data domain if the external data domain has the corresponding cost accounting data domain in the cost accounting system;
a second data importing module 704, configured to identify a data type corresponding to the external data domain if the external data domain does not have a corresponding cost accounting data domain in the cost accounting system, determine, based on the data type, the cost accounting data domain corresponding to the external data domain, and import data in the external data domain into the corresponding cost accounting data domain.
In this embodiment of the present invention, the data domain identifying module 702 may specifically include the following sub-modules:
the mapping relation table acquisition submodule is used for acquiring a preset data domain mapping relation table;
and the data domain identification submodule is used for respectively identifying whether any external data domain has a corresponding cost accounting data domain in the data domain mapping relation table.
In this embodiment of the present invention, any data type has a corresponding search path and a corresponding search target, and the second data importing module 704 may specifically include the following sub-modules:
the data type searching submodule is used for searching the data type based on the searching path and the searching target to obtain a corresponding searching result, and the searching result has a unique cost accounting category;
and the data domain determining submodule is used for determining a cost accounting data domain corresponding to the external data domain according to the cost accounting type.
In this embodiment of the present invention, the data domain determining sub-module specifically includes the following units:
and the data field determining unit is used for determining the corresponding cost accounting data field of the cost accounting type in a preset data dictionary.
In the embodiment of the present invention, the data dictionary is generated by calling the following sub-modules:
the cost accounting type identification submodule is used for identifying a plurality of cost accounting types;
the incidence relation establishing submodule is used for determining corresponding cost accounting data fields of all cost accounting types in the cost accounting system and establishing incidence relations between all the cost accounting types and the corresponding cost accounting data fields;
and the data dictionary generating submodule is used for generating a data dictionary based on the incidence relation.
In the embodiment of the present invention, the data type search sub-module is further configured to, if the cost accounting type does not have a corresponding cost accounting data field in a preset data dictionary, search for another data type to obtain a corresponding search result until the cost accounting data field corresponding to the external data field is determined according to the search result.
In the embodiment of the present invention, the apparatus may further include the following modules:
and the corresponding relation writing module is used for writing the external data domain and the cost accounting data domain corresponding to the external data domain into a preset data domain mapping relation table.
For the apparatus embodiment, since it is substantially similar to the method embodiment, it is described relatively simply, and reference may be made to the description of the method embodiment section for relevant points.
Referring to FIG. 8, a schematic diagram of a cost accounting system of one embodiment of the present invention is shown. As shown in fig. 8, the cost accounting system 800 of the present embodiment includes: a processor 810, a memory 820, and a computer program 821 stored in the memory 820 and operable on the processor 810. The processor 810, when executing the computer program 821, implements the steps in the data acquisition method of the cost accounting system described above, such as the steps S101 to S105 shown in fig. 1. Alternatively, the processor 810, when executing the computer program 821, implements the functions of the modules/units in the device embodiments, such as the functions of the modules 701 to 704 shown in fig. 7.
Illustratively, the computer program 821 may be partitioned into one or more modules/units that are stored in the memory 820 and executed by the processor 810 to implement the present invention. The one or more modules/units may be a series of computer program instruction segments capable of performing certain functions, which may be used to describe the execution of the computer program 821 in the cost accounting system 800. For example, the computer program 821 may be divided into an external system determination module, a data domain identification module, a first data import module, and a second data import module, and each module has the following specific functions:
an external system determination module for determining an external system to be acquired, the external system having a plurality of external data fields;
the data domain identification module is used for respectively identifying whether any external data domain has a corresponding cost accounting data domain in the cost accounting system;
the first data importing module is used for importing the data in the external data domain into a corresponding cost accounting data domain if the external data domain has the corresponding cost accounting data domain in the cost accounting system;
and the second data importing module is used for identifying the data type corresponding to the external data domain if the external data domain does not have the corresponding cost accounting data domain in the cost accounting system, determining the cost accounting data domain corresponding to the external data domain based on the data type, and importing the data in the external data domain into the corresponding cost accounting data domain.
The cost accounting system 800 may be a desktop computer, a notebook, a palm top computer, a cloud server, or other computing devices. The cost accounting system 800 may include, but is not limited to, a processor 810, a memory 820. Those skilled in the art will appreciate that FIG. 8 is merely an example of a cost accounting system 800 and does not constitute a limitation of cost accounting system 800, and may include more or fewer components than shown, or some components in combination, or different components, e.g., cost accounting system 800 may also include input output devices, network access devices, buses, etc.
The Processor 810 may be a Central Processing Unit (CPU), other general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic device, discrete hardware component, or the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The storage 820 may be an internal storage unit of the cost accounting system 800, such as a hard disk or a memory of the cost accounting system 800. The memory 820 may also be an external storage device of the cost accounting system 800, 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 cost accounting system 800. Further, the memory 820 may also include both an internal storage unit and an external storage device of the cost accounting system 800. The memory 820 is used for storing the computer program 821 and other programs and data required by the cost accounting system 800. The memory 820 may also be used to temporarily store data that has been output or is to be output.
It will be apparent to those skilled in the art that the foregoing division of the functional units and modules is merely illustrative for the convenience and simplicity of description. In practical applications, the above function allocation may be performed by different functional units or modules as needed, that is, the internal structure of the apparatus/terminal device is divided into different functional units or modules, so as to perform all or part of the above described functions. Each functional unit and module in the embodiments may be integrated in one processing unit, or each unit may exist alone physically, or two or more units are integrated in one unit, and the integrated unit may be implemented in a form of hardware, or in a form of software functional unit. In addition, specific names of the functional units and modules are only for convenience of distinguishing from each other, and are not used for limiting the protection scope of the present invention. The specific working processes of the units and modules in the system may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
In the above embodiments, the descriptions of the respective embodiments have respective emphasis, and reference may be made to the related descriptions of other embodiments for parts that are not described or illustrated in a certain embodiment.
Those of ordinary skill in the art will appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware or combinations of computer software and electronic hardware. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
In the embodiments provided in the present invention, it should be understood that the disclosed apparatus/terminal device and method may be implemented in other ways. For example, the above-described embodiments of the apparatus/terminal device are merely illustrative, and for example, the division of the modules or units is only one logical division, and there may be other divisions when actually implemented, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. On the other hand, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated modules/units, if implemented in the form of software functional units and sold or used as separate products, may be stored in a computer readable storage medium. Based on such understanding, all or part of the flow in the method according to the above embodiments may be implemented by a computer program, which may be stored in a computer readable storage medium and used by a processor to implement the steps of the above embodiments of the method. Wherein the computer program comprises computer program code, which may be in the form of source code, object code, an executable file or some intermediate form, etc. The computer-readable storage medium may include: any entity or device capable of carrying the computer program code, recording medium, usb disk, removable hard disk, magnetic disk, optical disk, computer Memory, Read-Only Memory (ROM), Random Access Memory (RAM), electrical carrier wave signals, telecommunications signals, software distribution medium, and the like. It should be noted that the computer readable storage medium may contain content that is subject to appropriate increase or decrease as required by legislation and patent practice in jurisdictions, for example, in some jurisdictions, computer readable storage media that does not include electrical carrier signals and telecommunications signals in accordance with legislation and patent practice.
The above-mentioned embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same. Although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; such modifications and substitutions do not substantially depart from the spirit and scope of the embodiments of the present invention, and are intended to be included within the scope of the present invention.
Claims (8)
1. A method of data acquisition for a cost accounting system, comprising:
determining an external system to be acquired, the external system having a plurality of external data fields;
respectively identifying whether any external data domain has a corresponding cost accounting data domain in the cost accounting system;
if the external data domain has a corresponding cost accounting data domain in the cost accounting system, importing the data in the external data domain into the corresponding cost accounting data domain;
if the external data domain does not have a corresponding cost accounting data domain in the cost accounting system, identifying a data type corresponding to the external data domain, determining the cost accounting data domain corresponding to the external data domain based on the data type, and importing the data in the external data domain into the corresponding cost accounting data domain;
wherein any data type has a corresponding search path and a search target, and the step of determining the cost accounting data field corresponding to the external data field based on the data type comprises:
searching the data type based on the search path and the search target to obtain a corresponding search result, wherein the search result has a unique cost accounting category;
and determining a corresponding cost accounting data field of the cost accounting type in a preset data dictionary.
2. The method of claim 1, wherein the step of respectively identifying whether any external data field exists in the cost accounting system comprises:
acquiring a preset data domain mapping relation table;
and respectively identifying whether any external data domain has a corresponding cost accounting data domain in the data domain mapping relation table.
3. The method of claim 1, wherein the data dictionary is generated by:
identifying a plurality of cost accounting categories;
determining a corresponding cost accounting data domain of each cost accounting type in the cost accounting system and establishing an incidence relation between each cost accounting type and the corresponding cost accounting data domain;
and generating a data dictionary based on the incidence relation.
4. The method of claim 1, wherein the external data field corresponds to a plurality of data types, and the method further comprises:
and if the cost accounting type does not have the corresponding cost accounting data domain in the preset data dictionary, searching other data types to obtain a corresponding search result until the cost accounting data domain corresponding to the external data domain is determined according to the search result.
5. The method according to claim 1, wherein after the step of determining the cost accounting data field corresponding to the external data field according to the cost accounting category, the method further comprises:
and writing the external data domain and the corresponding cost accounting data domain into a preset data domain mapping relation table.
6. A data acquisition device for a cost accounting system, comprising:
an external system determination module for determining an external system to be acquired, the external system having a plurality of external data fields;
the data domain identification module is used for respectively identifying whether any external data domain has a corresponding cost accounting data domain in the cost accounting system;
the first data importing module is used for importing the data in the external data domain into a corresponding cost accounting data domain if the external data domain has the corresponding cost accounting data domain in the cost accounting system;
the second data import module is used for identifying the data type corresponding to the external data domain if the external data domain does not have the corresponding cost accounting data domain in the cost accounting system, determining the cost accounting data domain corresponding to the external data domain based on the data type and importing the data in the external data domain into the corresponding cost accounting data domain;
wherein any data type has a corresponding search path and a search target, and the second data import module comprises: the data type searching submodule is used for searching the data type based on the searching path and the searching target to obtain a corresponding searching result, and the searching result has a unique cost accounting category;
and the data domain determining submodule is used for determining the corresponding cost accounting data domain of the cost accounting category in a preset data dictionary.
7. A cost accounting system comprising a memory, a processor and a computer program stored in said memory and executable on said processor, characterized in that said processor when executing said computer program implements the steps of the data acquisition method of the cost accounting system according to any one of claims 1 to 5.
8. A computer-readable storage medium, in which a computer program is stored which, when being executed by a processor, carries out the steps of the data acquisition method of the cost accounting system according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910161322.7A CN110008264B (en) | 2019-03-04 | 2019-03-04 | Data acquisition method and device of cost accounting system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910161322.7A CN110008264B (en) | 2019-03-04 | 2019-03-04 | Data acquisition method and device of cost accounting system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110008264A CN110008264A (en) | 2019-07-12 |
| CN110008264B true CN110008264B (en) | 2020-12-25 |
Family
ID=67166302
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910161322.7A Active CN110008264B (en) | 2019-03-04 | 2019-03-04 | Data acquisition method and device of cost accounting system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110008264B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110675054B (en) * | 2019-09-23 | 2022-08-23 | 金蝶蝶金云计算有限公司 | Data processing method, data processing system and related equipment in ERP system |
Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5555409A (en) * | 1990-12-04 | 1996-09-10 | Applied Technical Sysytem, Inc. | Data management systems and methods including creation of composite views of data |
| EP1318463A1 (en) * | 2001-12-05 | 2003-06-11 | Design and Reuse | Electronic virtual components description import in intranet catalogs |
| CN101000612A (en) * | 2005-10-06 | 2007-07-18 | 阿瓦雅技术有限公司 | Data extensibility using external database table |
| CN105117431A (en) * | 2015-08-07 | 2015-12-02 | 北京思特奇信息技术股份有限公司 | Dynamic configuration method and system for external imported data |
| CN106776885A (en) * | 2016-11-29 | 2017-05-31 | 盐城工学院 | A kind of data export method and device |
| CN107577787A (en) * | 2017-09-15 | 2018-01-12 | 广东万丈金数信息技术股份有限公司 | The method and system of associated data information storage |
| CN108052601A (en) * | 2017-12-12 | 2018-05-18 | 福建中金在线信息科技有限公司 | Database building method, device and terminal |
| CN108241679A (en) * | 2016-12-26 | 2018-07-03 | 北京国双科技有限公司 | Data processing method and device |
| CN108335080A (en) * | 2018-01-25 | 2018-07-27 | 广州建衡工程咨询有限公司 | A kind of Construction Audit system and implementation method |
| CN108829759A (en) * | 2018-05-28 | 2018-11-16 | 沈文策 | A kind of collecting method, device, electronic equipment and storage medium |
| CN108921621A (en) * | 2018-07-16 | 2018-11-30 | 广州市幻速网络科技有限公司 | A kind of collecting method of economic big data |
| CN108984757A (en) * | 2018-07-18 | 2018-12-11 | 上海汉得信息技术股份有限公司 | A kind of data lead-in method and equipment |
-
2019
- 2019-03-04 CN CN201910161322.7A patent/CN110008264B/en active Active
Patent Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5555409A (en) * | 1990-12-04 | 1996-09-10 | Applied Technical Sysytem, Inc. | Data management systems and methods including creation of composite views of data |
| EP1318463A1 (en) * | 2001-12-05 | 2003-06-11 | Design and Reuse | Electronic virtual components description import in intranet catalogs |
| CN101000612A (en) * | 2005-10-06 | 2007-07-18 | 阿瓦雅技术有限公司 | Data extensibility using external database table |
| CN105117431A (en) * | 2015-08-07 | 2015-12-02 | 北京思特奇信息技术股份有限公司 | Dynamic configuration method and system for external imported data |
| CN106776885A (en) * | 2016-11-29 | 2017-05-31 | 盐城工学院 | A kind of data export method and device |
| CN108241679A (en) * | 2016-12-26 | 2018-07-03 | 北京国双科技有限公司 | Data processing method and device |
| CN107577787A (en) * | 2017-09-15 | 2018-01-12 | 广东万丈金数信息技术股份有限公司 | The method and system of associated data information storage |
| CN108052601A (en) * | 2017-12-12 | 2018-05-18 | 福建中金在线信息科技有限公司 | Database building method, device and terminal |
| CN108335080A (en) * | 2018-01-25 | 2018-07-27 | 广州建衡工程咨询有限公司 | A kind of Construction Audit system and implementation method |
| CN108829759A (en) * | 2018-05-28 | 2018-11-16 | 沈文策 | A kind of collecting method, device, electronic equipment and storage medium |
| CN108921621A (en) * | 2018-07-16 | 2018-11-30 | 广州市幻速网络科技有限公司 | A kind of collecting method of economic big data |
| CN108984757A (en) * | 2018-07-18 | 2018-12-11 | 上海汉得信息技术股份有限公司 | A kind of data lead-in method and equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110008264A (en) | 2019-07-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11194793B1 (en) | Dynamically materialized views for sheets based data | |
| CN112084269B (en) | Data quality calculation method, device, storage medium and server | |
| CN112115152B (en) | Data increment updating and inquiring method and device, electronic equipment and storage medium | |
| CN108090086A (en) | Paging query method and device | |
| CN111597177A (en) | Data governance method for improving data quality | |
| CN110765750A (en) | Report data entry method and terminal equipment | |
| CN110008264B (en) | Data acquisition method and device of cost accounting system | |
| CN113515544B (en) | Data attribute query method and data attribute query device | |
| CN111159183A (en) | Report generation method, electronic device and computer readable storage medium | |
| CN109947797B (en) | Data inspection device and method | |
| CN114022264A (en) | Method, device, equipment and storage medium for generating certificate | |
| CN110781235A (en) | Big data based purchase data processing method and device, terminal and storage medium | |
| CN110489394B (en) | Intermediate data processing method and device | |
| CN110705816B (en) | Task allocation method and device based on big data | |
| CN117114142A (en) | AI-based data rule expression generation method, apparatus, device and medium | |
| CN117390011A (en) | Report data processing method, device, computer equipment and storage medium | |
| CN111695077A (en) | Asset information pushing method, terminal equipment and readable storage medium | |
| CN116089417A (en) | Information acquisition method, information acquisition device, storage medium and computer equipment | |
| CN113901046A (en) | Virtual dimension table construction method and device | |
| CN110147813B (en) | User portrait construction method and device, storage medium and server | |
| CN113704236A (en) | Government affair system data quality evaluation method, device, terminal and storage medium | |
| CN111859044A (en) | Data query processing method, system and related equipment | |
| CN112667721A (en) | Data analysis method, device, equipment and storage medium | |
| CN113449232A (en) | Data processing method, device, equipment and storage medium | |
| CN112528100A (en) | Label strategy recommending and marking method, terminal equipment and storage medium |
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 |