CN112085366A - Device and method for performing mesoTaiization processing on enterprise organization index data - Google Patents
Device and method for performing mesoTaiization processing on enterprise organization index data Download PDFInfo
- Publication number
- CN112085366A CN112085366A CN202010904885.3A CN202010904885A CN112085366A CN 112085366 A CN112085366 A CN 112085366A CN 202010904885 A CN202010904885 A CN 202010904885A CN 112085366 A CN112085366 A CN 112085366A
- Authority
- CN
- China
- Prior art keywords
- index
- field
- data
- model
- dimension
- 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.)
- Pending
Links
Images
Classifications
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
- G06Q10/063—Operations research, analysis or management
- G06Q10/0639—Performance analysis of employees; Performance analysis of enterprise or organisation operations
- G06Q10/06393—Score-carding, benchmarking or key performance indicator [KPI] analysis
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Abstract
The invention relates to a device and a method for performing mesoTaiwan processing on enterprise organization index data, belongs to the technical field of data mesoTaiwan processing, and solves the problems that the existing index data processing method is complicated and complex and index data is difficult to obtain. The device includes: the index model establishing module is used for establishing a corresponding index model according to the index type; the index definition module is used for setting the attribute of each index and establishing the corresponding relation between each index and the index model according to the type of each index, wherein the attribute comprises an index formula; the index service interface is used for receiving an index data request; and the index data acquisition module is used for determining corresponding indexes according to the index data requests, extracting corresponding data from the background database by using index models corresponding to the indexes, and calculating and acquiring the requested index data through an index formula. The device can more conveniently process and acquire index data by a method of defining indexes at one place and using the indexes at all places.
Description
Technical Field
The invention relates to the technical field of data staging, in particular to a device and a method for performing staging processing on enterprise organization index data.
Background
The enterprise or organization foreground is usually a client-oriented marketing, sales and service department or system, and the background is usually a two-line support part or system for technical support, research and development, finance, human resources, internal auditing and the like. The foreground and the background are frequently disconnected, the foreground complains that the background is disconnected from the service, the support and the service are not in place, and the background complains that the foreground is frequently changed and the information feedback is not timely. The capacity of the background department is repeatedly built, the sharing degree is low, the data islanding is realized, and the information transfer is not smooth.
Under the circumstance, in the prior art, index data of enterprises or organizations are usually managed in a distributed manner, and when different proscenums acquire the index data from a background system, different definition modes may be adopted for unified index data, which causes problems of repeated definition of indexes, inconsistent aperture of the index data, uneven definition of the indexes, difficulty in understanding the indexes, difficulty in acquiring the index data, difficulty in expanding the indexes, repeated storage of the background system data, and the like.
The contradiction between the front and the back of the enterprise in management obviously reflects the efficiency of quick response to the requirements of customers, and the business model and the value chain of the enterprise require partial service functions of the back of the enterprise to move forward, so that the requirements of the front and the customers can be better supported, and more and faster services can be quickly provided for the front. Therefore, the foreground requirement contact is well associated with the background system through the middle station transaction processing and service, so that the background can better provide service support for the foreground.
Disclosure of Invention
In view of the above analysis, the present invention is directed to provide a device and a method for performing staging processing on enterprise organization index data, so as to solve the problems of complicated and complicated index data processing and difficulty in acquiring index data caused by the existing decentralized management of index data.
In one aspect, the present invention provides an apparatus for performing staging processing on enterprise organization index data, including:
the index model establishing module is used for establishing a corresponding index model according to the index type;
the index definition module is used for setting the attribute of each index and establishing the corresponding relation between each index and the index model according to the type of each index, wherein the attribute comprises an index formula;
the index service interface is used for receiving an index data request;
and the index data acquisition module is used for determining corresponding indexes according to the index data requests, extracting corresponding data from a background database by using index models corresponding to the indexes, and calculating and acquiring the requested index data through the index formula.
Further, the index model comprises an analysis model and a dimension model; the dimension model is used for extracting dimension information from the background database, and the analysis model is used for extracting measurement data from the background database.
Further, the index model establishing module establishes the index model by the following method:
determining a first general field in a dimension model according to a basic information table corresponding to an index type in a background database, and establishing a first mapping relation between the first general field and corresponding information in the basic information table;
determining a field in an analysis model according to a digital fact table corresponding to an index type in a background database, and establishing a second mapping relation between the field and corresponding data in the digital fact table, wherein the field comprises a second general field and a measurement field;
and establishing a first incidence relation of the same general fields in the first general field and the second general field corresponding to the index type.
Furthermore, the index type corresponds to at least one basic information table, and each basic information table corresponds to a dimension model.
Further, the set attribute of the index also comprises index coding;
the data acquisition module specifically acquires the requested index data in the following way:
analyzing the index data request to obtain corresponding index codes and dimension information requirements, and further determining corresponding measurement fields, first general fields and second general fields;
extracting dimension information from a corresponding basic information table according to the determined first general field and the first mapping relation by using a dimension model corresponding to the index;
acquiring dimension information corresponding to a second general field from the dimension information extracted from the dimension model according to the first incidence relation;
determining a corresponding digital fact table according to the dimension information corresponding to the second general field and the measurement field;
extracting measurement data from a corresponding basic information table according to the measurement field and the second mapping relation by using an analysis model corresponding to the index;
and calculating to obtain index data by using an index formula corresponding to the index according to the measurement data.
Further, the determining the corresponding metric field, the first general field, and the second general field includes:
determining an index formula corresponding to the index according to the index code;
analyzing the index formula to determine a corresponding measurement field;
and determining a corresponding first general field and a second general field according to the dimension information requirement.
On the other hand, the invention provides a method for performing mesoTaiization processing on enterprise organization index data, which comprises the following steps of:
establishing a corresponding index model according to the index type;
setting the attribute of each index, and establishing the corresponding relation between each index and the index model according to the type of each index, wherein the attribute comprises an index formula;
and determining a corresponding index according to the index data request, extracting corresponding data from a background database by using an index model corresponding to the index, and calculating to obtain the requested index data through the index formula.
Further, the index model comprises an analysis model and a dimension model, the dimension model is used for extracting dimension information from the background database, and the analysis model is used for extracting measurement data from the background database;
establishing a corresponding index model according to the index type, comprising:
determining a first general field in a dimension model according to a basic information table corresponding to an index type in a background database, and establishing a first mapping relation between the first general field and corresponding information in the basic information table;
determining a field in an analysis model according to a digital fact table corresponding to an index type in a background database, and establishing a second mapping relation between the field and corresponding data in the digital fact table, wherein the field comprises a second general field and a measurement field;
establishing a first incidence relation of the same general field in the first general field and the second general field corresponding to the index type;
the index type corresponds to at least one basic information table, and each basic information table corresponds to one dimension model.
Further, the requested index data is obtained through the following process:
analyzing the index data request to obtain corresponding index codes and dimension information requirements, and further determining corresponding measurement fields, first general fields and second general fields;
extracting dimension information from a corresponding basic information table according to the determined first general field and the first mapping relation by using a dimension model corresponding to the index;
obtaining dimension information corresponding to a second general field according to the first incidence relation;
determining a corresponding digital fact table according to the dimension information corresponding to the second general field and the measurement field;
extracting measurement data from a corresponding basic information table according to the measurement field and the second mapping relation by using an analysis model corresponding to the index;
and calculating to obtain index data by using an index formula corresponding to the index according to the measurement data.
Further, the determining the corresponding metric field, the first general field, and the second general field includes:
determining an index formula corresponding to the index according to the index code;
analyzing the index formula to determine a corresponding measurement field;
determining a corresponding first general field and a second general field according to the dimension information requirement
Compared with the prior art, the invention can realize at least one of the following beneficial effects:
1. the device and the method for performing the mesonization processing on the enterprise organization index data establish the relation between the enterprise or organization foreground and the background through the mesonization processing of the index data, provide a uniform service interface for acquiring the index data, realize high sharing of the data and rapid information transfer, and enable the background to better provide data service support for the foreground.
2. The invention provides a device and a method for performing staging processing on enterprise organization index data, which are characterized in that firstly, corresponding index models are established according to index types, so that indexes of the same type can share the same index model, secondly, the index models comprise analysis models and dimension models, a mapping relation between the analysis models and relevant data of a digital fact table in a background database is established, a mapping relation between the dimension models and relevant information in a basic information table in the background database is established, corresponding index data can be extracted from the background database according to a standard model, and the defect of repeated storage of the index data in the background database is overcome.
3. The invention defines the indexes by setting the codes, names, measurement units, statistical periods, index formulas and associated standard models of the indexes, provides uniform, clear and easily understood index definitions for the foreground, and realizes the one-place definition and the everywhere use of the indexes. And the defects that index data are complex and complex to process and are difficult to obtain are overcome.
In the invention, the technical schemes can be combined with each other to realize more preferable combination schemes. Additional features and advantages of the invention will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. The objectives and other advantages of the invention will be realized and attained by the structure particularly pointed out in the written description and drawings.
Drawings
The drawings are only for purposes of illustrating particular embodiments and are not to be construed as limiting the invention, wherein like reference numerals are used to designate like parts throughout.
FIG. 1 is a schematic diagram of an apparatus for performing staging processing on enterprise organization index data according to an embodiment of the present invention;
fig. 2 is a flowchart of a method for performing staging processing on enterprise organizational index data according to an embodiment of the present invention.
Detailed Description
The accompanying drawings, which are incorporated in and constitute a part of this application, illustrate preferred embodiments of the invention and together with the description, serve to explain the principles of the invention and not to limit the scope of the invention.
Device embodiment
The invention discloses a device for performing mesoTaiization processing on enterprise organization index data. As shown in fig. 1, the apparatus includes an index model building module, an index defining module, an index service interface, and an index data obtaining module.
The index model establishing module is used for establishing a corresponding index model according to the index type. Illustratively, the indicator types may include revenue type indicators, liability rate indicators, quantity of inventory indicators, and sales indicators, among others. Other types of indexes can be included according to the requirements of different enterprises or organizations, and corresponding index models can be built.
And the index definition module is used for setting the attribute of each index and establishing the corresponding relation between each index and the established index model according to the type of each index, wherein the set attribute comprises an index formula and can also comprise index codes, index names, measurement units, statistical periods and the like. Specifically, the index code is the only identifier of the index; the measurement unit can be specifically set according to business requirements, and for example, a financial statement of an enterprise or organization needs to be issued monthly, and then statistics is performed monthly to issue, wherein the corresponding asset liability ratio (i.e. an index formula) is as follows:
the index service interface is used for receiving the index data request, namely receiving the index data request of the foreground; in order to adapt to data requests in other forms, the index service interface can also be in butt joint with other user terminals so as to realize data interaction between the other user terminals and the background. Specifically, different user terminals have different requests for the index data. Illustratively, the index data requests of the CEO of the enterprise are primarily revenue targets, the index data requests of the CFO of the enterprise are primarily asset liability rate targets, the index data requests of the salespersons are primarily gross sales targets, and the index data requests of the inventory clerks are primarily inventory quantities. The index data request comprises index codes and filtering conditions, wherein the filtering conditions are required index data dimensions.
And the index data acquisition module is used for determining corresponding indexes according to the index data requests, extracting corresponding data from the background database by using index models corresponding to the indexes, and calculating and acquiring the requested index data through an index formula. Specifically, the corresponding index is determined according to the index code in the index data request.
The system also comprises a JDBC interface which is used for the index data acquisition module to extract the requested index data from the background database. Specifically, the corresponding index data may also be extracted from the background database in a data service manner.
Preferably, the background database can comprise a plurality of databases, but all use the unified index definition and the unified data service interface.
Preferably, the index model includes an analysis model and a dimension model. The dimension model is used for extracting dimension information from the background database, and the analysis model is used for extracting measurement data from the background database.
Preferably, the index model establishing module establishes the index model specifically by the following method:
step 1, determining a first general field in the dimension model according to a basic information table corresponding to an index type in a background database, and establishing a first mapping relation between the first general field and corresponding information in the basic information table. And setting the code and the name of the dimension model, wherein the code of the dimension model is the unique identifier of the dimension model.
Specifically, the index type corresponds to at least one basic information table, which illustratively includes an organization basic information table, a customer basic information table, a product basic information table, and the like. Illustratively, a customer dimension model and a product dimension model need to be respectively established according to a customer basic information table and a product basic information table corresponding to the index of the sales volume class, and specifically, a first general field in the customer dimension model includes: the customer ID, the customer name, the area where the customer is located, whether the customer is a VIP, and the like, the fields corresponding to the information in the basic information table are not all required to be set in the corresponding dimension model, and specifically, the first general field of the dimension model may be set according to the index data requirement.
And 2, determining a field in the analysis model according to the digital fact table corresponding to the index type in the background database, and establishing a second mapping relation between the determined field and corresponding data in the digital fact table, wherein the field comprises a second general field and a measurement field. Specifically, the method further comprises the step of setting a code and a name of the analysis model, wherein the code of the analysis model is a unique identifier of the analysis model.
Specifically, for the index of the sales amount class, the corresponding digital fact table is the sales order, and the information contained in the sales order includes the customer ID, the product ID, the order quantity, the order amount, and the like. According to the index of the sales amount class, the second general fields of the analysis model can be determined to be the customer ID and the product ID, and the corresponding measurement fields are the order quantity and the order amount.
And 3, establishing a first association relation of the same general fields in the first general field and the second general field corresponding to the index type.
Illustratively, the second general field in the analysis model corresponding to the sales amount index is a customer ID and a product ID, the first general field in the corresponding customer dimension model includes the customer ID, and the first general field in the corresponding product dimension model includes the product ID, and then the association relationship between the analysis model and the field of the customer ID in the customer dimension model is established according to the customer ID, and the association relationship between the analysis model and the field of the product ID in the product dimension model is established according to the product ID.
In practical application, the digital fact table does not store corresponding data such as a customer ID, a product ID and the like, and only stores digital data such as order quantity, order amount and the like. The basic information table only stores basic archive data such as a client ID and a product ID, but the digital fact table and the basic information table are associated with each other, that is, the archive data and the digital data are associated with each other. Therefore, corresponding index data including dimension information and measurement data can be extracted from the background data through the dimension model associated with the analysis model.
Preferably, the data obtaining module obtains the requested index data specifically by:
step 1, analyzing the index data request to obtain corresponding index codes and dimension information requirements, and further determining corresponding measurement fields, first general fields and second general fields. Illustratively, if the request sent by the foreground is index data of total sales of product a for client B, the index code is determined to be the index code corresponding to the total sales, and the dimension information requirement is product a and client B.
Specifically, the method comprises the following steps:
step 101, determining an index formula corresponding to the index according to the index code, wherein the index formula corresponding to the index is determined according to the index of the total sales:
total sales equals unit sales price x number of sales.
102, analyzing the index formula to determine a corresponding measurement field, wherein the measurement field obtained by analyzing the index formula corresponding to the total sales index is sales unit price and sales quantity in an exemplary manner;
and 103, determining a corresponding first general field and a second general field according to the dimension information requirement. Illustratively, the first general field of the obtained customer dimension model is a customer ID, the first general field of the product dimension model is a product ID, and the second general field of the analysis model is a customer ID and a product ID.
And 2, extracting dimension information from a corresponding basic information table according to the determined first general field and the first mapping relation by using a dimension model corresponding to the index. Illustratively, the client dimension model extracts the ID information of the client B from the client basic information table according to the name of the client B and the mapping relation between the client ID information in the second general field and the client ID information in the client basic information table; in addition, the product dimension model extracts the ID information of the product A from the product basic information table according to the name of the product A and the mapping relation between the product ID of the second general field and the product ID information in the product basic information table.
And 3, acquiring the dimension information corresponding to the second general field from the dimension information extracted from the dimension model according to the first association relation, namely acquiring the ID information of the product A and the ID information of the customer B extracted from the product dimension model and the customer dimension model by the analysis model corresponding to the total sales amount according to the first association relation.
And 4, determining a corresponding digital fact table according to the dimension information and the measurement field corresponding to the second general field. Illustratively, the sales order for product A of customer B (i.e., the digital fact table) may include a plurality of sales orders, specifically, sales orders corresponding to different years or months, and thus all sales orders corresponding to the locator based on the ID information of customer B and the ID information of product A.
And 5, extracting measurement data from the corresponding basic information table by using the analysis model corresponding to the index according to the measurement field and the second mapping relation, and exemplarily extracting the sale unit price and the sale quantity of each positioned sale order (namely, the digital fact table).
And 6, calculating according to the measurement data by using an index formula corresponding to the index to obtain index data.
And after the corresponding index data is obtained, the index data is transmitted to a foreground or other clients through an index service interface so as to provide data service support.
Method embodiment
The present embodiment and the device embodiment are based on the same inventive concept, and for repeated description, reference may be made to the contents of the device embodiment.
The invention also discloses a method for performing mesoTaiization processing on the enterprise organization index data, which comprises the following steps:
step 1, establishing a corresponding index model according to the index type.
And 2, setting the attribute of each index, and establishing the corresponding relation between each index and the index model according to the type of each index, wherein the set attribute comprises an index formula, an index code, an index name, a metering unit, a statistical period and the like.
And 3, determining a corresponding index according to the index data request, extracting corresponding data from the background database by using an index model corresponding to the index, and calculating to obtain the requested index data through an index formula.
Preferably, the established index model comprises an analysis model and a dimension model, wherein the dimension model is used for extracting dimension information from the background database, and the analysis model is used for extracting measurement data from the background database.
Establishing a corresponding index model according to the index type, which specifically comprises the following steps:
step 101, determining a first general field in the dimension model according to a basic information table corresponding to the index type in the background database, and establishing a first mapping relation between the first general field and corresponding information in the basic information table.
And 102, determining a field in the analysis model according to the digital fact table corresponding to the index type in the background database, and establishing a second mapping relation between the field and corresponding data in the digital fact table, wherein the field comprises a second general field and a measurement field.
And establishing a first incidence relation of the same general fields in the first general field and the second general field corresponding to the index type.
The index type corresponds to at least one basic information table, and each basic information table corresponds to one dimension model.
Preferably, the requested index data is obtained by the following process:
step 301, analyzing the index data request to obtain the corresponding index code and the dimension information requirement, and further determining the corresponding measurement field, the first general field, and the second general field.
The method specifically comprises the following steps:
and determining an index formula corresponding to the index according to the index code.
The analytical index formula determines the corresponding metric field.
And determining a corresponding first general field and a second general field according to the requirement of the dimension information.
And step 302, extracting dimension information from the corresponding basic information table according to the determined first general field and the first mapping relation by using the dimension model corresponding to the index.
And 303, acquiring dimension information corresponding to the second general field according to the first association relation.
And step 304, determining a corresponding digital fact table according to the dimension information and the measurement field corresponding to the second general field.
305, extracting measurement data from a corresponding basic information table according to the measurement field and the second mapping relation by using an analysis model corresponding to the index;
and step 306, calculating according to the measurement data by using an index formula corresponding to the index to obtain index data.
And finally, after acquiring the corresponding index data, transmitting the index data to a foreground or other clients through an index service interface so as to provide data service support.
Compared with the prior art, the device and the method for performing mesoscopic processing on the enterprise organization index data, provided by the invention, firstly, the relation between the enterprise or organization foreground and the background is established through the mesoscopic processing of the index data, and a uniform service interface for acquiring the index data is provided, so that high sharing of data and rapid information transmission are realized, and the background can better provide data service support for the foreground. Secondly, a corresponding index model is established according to the index type, so that indexes of the same type can share the same index model, secondly, the index model comprises an analysis model and a dimension model, a mapping relation between the analysis model and relevant data of a digital fact table in a background database is established, a mapping relation between the dimension model and relevant information in a basic information table in the background database is established, corresponding index data can be extracted from the background database according to a standard model, and the defect of repeated storage of the index data in the background database is overcome. Finally, the invention defines the index by setting the code, name, measurement unit, statistical period, index formula and associated standard model of the index, provides uniform, clear and easily understood index definition for the foreground, and realizes the definition of the index at one place and the use at all places. And the defects that index data are complex and complex to process and are difficult to obtain are overcome.
Those skilled in the art will appreciate that all or part of the flow of the method implementing the above embodiments may be implemented by a computer program, which is stored in a computer readable storage medium, to instruct related hardware. The computer readable storage medium is a magnetic disk, an optical disk, a read-only memory or a random access memory.
The above description is only for the preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any changes or substitutions that can be easily conceived by those skilled in the art within the technical scope of the present invention are included in the scope of the present invention.
Claims (10)
1. An apparatus for performing staging processing on enterprise organizational index data, comprising:
the index model establishing module is used for establishing a corresponding index model according to the index type;
the index definition module is used for setting the attribute of each index and establishing the corresponding relation between each index and the index model according to the type of each index, wherein the attribute comprises an index formula;
the index service interface is used for receiving an index data request;
and the index data acquisition module is used for determining corresponding indexes according to the index data requests, extracting corresponding data from a background database by using index models corresponding to the indexes, and calculating and acquiring the requested index data through the index formula.
2. The apparatus of claim 1, wherein the metric model comprises an analytical model and a dimensional model; the dimension model is used for extracting dimension information from the background database, and the analysis model is used for extracting measurement data from the background database.
3. The apparatus for transnational processing according to claim 1 or 2, wherein the index model establishing module establishes the index model by:
determining a first general field in a dimension model according to a basic information table corresponding to an index type in a background database, and establishing a first mapping relation between the first general field and corresponding information in the basic information table;
determining a field in an analysis model according to a digital fact table corresponding to an index type in a background database, and establishing a second mapping relation between the field and corresponding data in the digital fact table, wherein the field comprises a second general field and a measurement field;
and establishing a first incidence relation of the same general fields in the first general field and the second general field corresponding to the index type.
4. The apparatus of claim 3, wherein the index type corresponds to at least one basic information table, and each basic information table corresponds to a dimension model.
5. The apparatus for transnational processing according to claim 3, wherein the set attribute of the index further comprises an index code;
the data acquisition module specifically acquires the requested index data in the following way:
analyzing the index data request to obtain corresponding index codes and dimension information requirements, and further determining corresponding measurement fields, first general fields and second general fields;
extracting dimension information from a corresponding basic information table according to the determined first general field and the first mapping relation by using a dimension model corresponding to the index;
acquiring dimension information corresponding to a second general field from the dimension information extracted from the dimension model according to the first incidence relation;
determining a corresponding digital fact table according to the dimension information corresponding to the second general field and the measurement field;
extracting measurement data from a corresponding basic information table according to the measurement field and the second mapping relation by using an analysis model corresponding to the index;
and calculating to obtain index data by using an index formula corresponding to the index according to the measurement data.
6. The apparatus of claim 5, wherein determining the corresponding metric field, the first common field, and the second common field comprises:
determining an index formula corresponding to the index according to the index code;
analyzing the index formula to determine a corresponding measurement field;
and determining a corresponding first general field and a second general field according to the dimension information requirement.
7. A method for performing staging processing on enterprise organization index data is characterized by comprising the following steps:
establishing a corresponding index model according to the index type;
setting the attribute of each index, and establishing the corresponding relation between each index and the index model according to the type of each index, wherein the attribute comprises an index formula;
and determining a corresponding index according to the index data request, extracting corresponding data from a background database by using an index model corresponding to the index, and calculating to obtain the requested index data through the index formula.
8. The method of claim 7, wherein the metric model comprises an analytical model and a dimensional model, the dimensional model is used for extracting dimensional information from the background database, and the analytical model is used for extracting metric data from the background database;
establishing a corresponding index model according to the index type, comprising:
determining a first general field in a dimension model according to a basic information table corresponding to an index type in a background database, and establishing a first mapping relation between the first general field and corresponding information in the basic information table;
determining a field in an analysis model according to a digital fact table corresponding to an index type in a background database, and establishing a second mapping relation between the field and corresponding data in the digital fact table, wherein the field comprises a second general field and a measurement field;
establishing a first incidence relation of the same general field in the first general field and the second general field corresponding to the index type;
the index type corresponds to at least one basic information table, and each basic information table corresponds to one dimension model.
9. The method of transtage processing according to claim 8, wherein the requested index data is obtained by the following process:
analyzing the index data request to obtain corresponding index codes and dimension information requirements, and further determining corresponding measurement fields, first general fields and second general fields;
extracting dimension information from a corresponding basic information table according to the determined first general field and the first mapping relation by using a dimension model corresponding to the index;
obtaining dimension information corresponding to a second general field according to the first incidence relation;
determining a corresponding digital fact table according to the dimension information corresponding to the second general field and the measurement field;
extracting measurement data from a corresponding basic information table according to the measurement field and the second mapping relation by using an analysis model corresponding to the index;
and calculating to obtain index data by using an index formula corresponding to the index according to the measurement data.
10. The method of transrating a process according to claim 9, wherein the determining the corresponding metric field, the first generic field, and the second generic field comprises:
determining an index formula corresponding to the index according to the index code;
analyzing the index formula to determine a corresponding measurement field;
and determining a corresponding first general field and a second general field according to the dimension information requirement.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010904885.3A CN112085366A (en) | 2020-09-01 | 2020-09-01 | Device and method for performing mesoTaiization processing on enterprise organization index data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010904885.3A CN112085366A (en) | 2020-09-01 | 2020-09-01 | Device and method for performing mesoTaiization processing on enterprise organization index data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112085366A true CN112085366A (en) | 2020-12-15 |
Family
ID=73732914
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010904885.3A Pending CN112085366A (en) | 2020-09-01 | 2020-09-01 | Device and method for performing mesoTaiization processing on enterprise organization index data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112085366A (en) |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102982416A (en) * | 2012-12-05 | 2013-03-20 | 山东浪潮齐鲁软件产业股份有限公司 | Universal implementation model for performance assessment |
| CN110427434A (en) * | 2019-06-28 | 2019-11-08 | 苏宁云计算有限公司 | A kind of multidimensional data query method and device |
| CN110647549A (en) * | 2019-09-29 | 2020-01-03 | 北京卓信智恒数据科技股份有限公司 | Data index analyzing and executing method and device based on business dynamic modeling |
| CN110689452A (en) * | 2019-09-26 | 2020-01-14 | 佰聆数据股份有限公司 | Clustering algorithm-based power market business center service center planning method |
| CN111008197A (en) * | 2019-11-20 | 2020-04-14 | 王锦志 | Data center design method for power marketing service system |
| CN111045656A (en) * | 2020-03-12 | 2020-04-21 | 大汉软件股份有限公司 | Method and system for constructing platform system infrastructure in government affair service |
| CN111159157A (en) * | 2019-12-31 | 2020-05-15 | 远光软件股份有限公司 | Method and device for indexing processing of enterprise report data |
-
2020
- 2020-09-01 CN CN202010904885.3A patent/CN112085366A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102982416A (en) * | 2012-12-05 | 2013-03-20 | 山东浪潮齐鲁软件产业股份有限公司 | Universal implementation model for performance assessment |
| CN110427434A (en) * | 2019-06-28 | 2019-11-08 | 苏宁云计算有限公司 | A kind of multidimensional data query method and device |
| CN110689452A (en) * | 2019-09-26 | 2020-01-14 | 佰聆数据股份有限公司 | Clustering algorithm-based power market business center service center planning method |
| CN110647549A (en) * | 2019-09-29 | 2020-01-03 | 北京卓信智恒数据科技股份有限公司 | Data index analyzing and executing method and device based on business dynamic modeling |
| CN111008197A (en) * | 2019-11-20 | 2020-04-14 | 王锦志 | Data center design method for power marketing service system |
| CN111159157A (en) * | 2019-12-31 | 2020-05-15 | 远光软件股份有限公司 | Method and device for indexing processing of enterprise report data |
| CN111045656A (en) * | 2020-03-12 | 2020-04-21 | 大汉软件股份有限公司 | Method and system for constructing platform system infrastructure in government affair service |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Ballard et al. | Data modeling techniques for data warehousing | |
| US7457807B2 (en) | Data migration and analysis | |
| US6687560B2 (en) | Processing performance data describing a relationship between a provider and a client | |
| US7266566B1 (en) | Database management system | |
| US9466063B2 (en) | Cluster processing of an aggregated dataset | |
| US20020062241A1 (en) | Apparatus and method for coding electronic direct marketing lists to common searchable format | |
| US10824614B2 (en) | Custom query parameters in a database system | |
| CN109784715A (en) | Shops's management system | |
| US20080288522A1 (en) | Creating and storing a data field alteration datum using an analytic platform | |
| CN108701154B (en) | Data source system agnostic fact category partitioning information repository and methods for inserting and retrieving data using the same | |
| US6850866B2 (en) | Managing performance metrics describing a relationship between a provider and a client | |
| CN113064866A (en) | Power business data integration system | |
| CN111639983A (en) | Intelligent farmer market information management system based on one cloud and multiple ends | |
| CN111310032A (en) | Resource recommendation method and device, computer equipment and readable storage medium | |
| CN112508671A (en) | Enterprise financial data processing method, system, device and medium | |
| Bhaskara et al. | Data warehouse implemantation to support batik sales information using MOLAP | |
| KR20170094935A (en) | System for providing enterprise information and method | |
| US20030061006A1 (en) | Evaluating performance data describing a relationship between a provider and a client | |
| CN112085366A (en) | Device and method for performing mesoTaiization processing on enterprise organization index data | |
| CN215729854U (en) | Customer management system | |
| CN112000723B (en) | Enterprise information management device and application thereof | |
| CN113961649A (en) | Multi-source data fusion method and system | |
| Davis | Right-Time Business Intelligence: Optimizing the Business Decision Cycle | |
| CN113988945A (en) | Management system for multidimensional data trend accurate marketing | |
| US20070226085A1 (en) | System and method for automated mapping of data in a multi-valued data structure |
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 |