A design method of bi data interface
A design method and data interface technology, applied in the direction of structured data retrieval, database management system, etc., can solve problems that affect the normal work of business departments, unsuccessful update of BI system data, wrong data in business systems, etc.
Active Publication Date: 2019-08-27
FOCUS TECH
View PDF4 Cites 0 Cited by
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
[0005] 3. The data update of the BI system is not successful, but the business system has already taken the data, that is, the business system may take the wrong data
[0006] If the BI system data cannot be transmitted to the business system in an accurate and timely manner, it may affect the normal work of the business department, which may seriously affect the customer's perception of the company and even customer loyalty
Method used
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View moreImage
Smart Image Click on the blue labels to locate them in the text.
Smart ImageViewing Examples
Examples
Experimental program
Comparison scheme
Effect test
Embodiment Construction
[0023] figure 1 A flowchart showing a BI data interface design method and system according to an embodiment of the present invention.
[0024] Such as figure 1 , the specific steps of the BI data interface design method and system of the embodiment of the present invention include:
[0025] Step 1: Determine the data table required by the foreground system, that is, the business system, that is, the BI interface table, and add the BI interface table to the interface configuration table; create an interface configuration table to store the relevant information of the interface table, including the following fields:
[0026] (1) Project name: PROJECT_NAME;
[0027] (2) Interface table name: TABLE_NAME;
[0028] (3) Interface table adding time: ADD_TIME, refers to when this task is added to the configuration table;
[0029] (4) Data update time field: DATE_TYPE, refers to the time storage type, such as NUMBER type or DATE type, this field is for monitoring the daily data volu...
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More PUM
Login to View More Abstract
The invention discloses a design method of a BI data interface. The method comprises the steps that an interface configuration table is configured; in the whole design process of BI interface tables, it needs to be determined first that which data tables are needed for a service system, and the data tables needed by a service department are configured into the interface configuration table; data updating logs are recorded; in order to detect whether updating of interface table data in the interface configuration table is completed or not, a data updating log table needs to be designed and created to be used for recording the updating time, data volume and the like of each BI interface table every day; the data quality of the interface tables is monitored; the service system draws the data and records the logs according to the data quality of the interface tables; reports are sent at fixed time to form statement exhibition.
Description
technical field [0001] The present invention relates to the field of business intelligence data interface, specifically, a BI data interface design method and system. Background technique [0002] Most enterprises have gradually accumulated a large amount of data in the course of operation. In order to ensure the performance of the business system, the business system is usually separated from the business intelligence (BI) data system, and the historical data is stored in the BI data system while only the current data is kept in the business system. The BI department analyzes the historical data, mines the potential value, discovers the knowledge in the data and feeds this knowledge back to the business department. This involves the business system fetching data from the BI system. During this process, the following problems may arise: [0003] 1. The data in the BI system has not been updated, but the business system has already started fetching data, that is, the busin...
Claims
the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More Application Information
Patent Timeline
Login to View More Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/25
Inventor 邹凤莲陈静唐宇波
Owner FOCUS TECH