CN110457368B - Visualization method, system and storage medium for supply chain - Google Patents
Visualization method, system and storage medium for supply chain Download PDFInfo
- Publication number
- CN110457368B CN110457368B CN201910687420.4A CN201910687420A CN110457368B CN 110457368 B CN110457368 B CN 110457368B CN 201910687420 A CN201910687420 A CN 201910687420A CN 110457368 B CN110457368 B CN 110457368B
- Authority
- CN
- China
- Prior art keywords
- data
- thematic
- displayed
- interface
- report
- 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
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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2465—Query processing support for facilitating data mining operations in structured databases
-
- 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/24—Querying
- G06F16/248—Presentation of query results
-
- 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/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/604—Tools and structures for managing or administering access control systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
- G06F21/6227—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database where protection concerns the structure of data, e.g. records, types, queries
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
- G06F21/6245—Protecting personal data, e.g. for financial or medical purposes
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
- G06F3/0486—Drag-and-drop
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2221/00—Indexing scheme relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F2221/21—Indexing scheme relating to G06F21/00 and subgroups addressing additional information or applications relating to security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F2221/2141—Access rights, e.g. capability lists, access control lists, access tables, access matrices
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Bioethics (AREA)
- Health & Medical Sciences (AREA)
- Software Systems (AREA)
- General Health & Medical Sciences (AREA)
- Computer Security & Cryptography (AREA)
- Computer Hardware Design (AREA)
- Data Mining & Analysis (AREA)
- Computational Linguistics (AREA)
- Probability & Statistics with Applications (AREA)
- Automation & Control Theory (AREA)
- Human Computer Interaction (AREA)
- Mathematical Physics (AREA)
- Fuzzy Systems (AREA)
- Medical Informatics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a visualization method, a system and a storage medium of a supply chain, wherein the method comprises the following steps: mining the commonality of data among different systems by using a BI technology, and collecting and integrating the data of the different system databases; data of different system databases are processed in ETL, unified modeling is carried out through an SQL Server database, the data are summarized into a Power BI data set, further analysis and integration are carried out on the data to be displayed through DAX, and finally the required data are displayed in a report; dividing a background thematic interface into a plurality of square grids, dragging and selecting a plurality of continuous square grids as a self-defined display module, and customizing the content and layout displayed by the thematic interface according to the requirement; setting user access settings and distributing thematic viewing rights of different users. The invention can integrate various forms of data, customize the content and layout displayed by each interface according to the user demand, and improve the system customization; the privacy and security of data are enhanced by configuring user rights.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a method, a system, and a storage medium for visualizing a supply chain.
Background
In big data age, the data is grasped and just equivalent to the throat that grasps the fate, but the data in the enterprise's hand is dead, and the flexibility is lower, only through the data in the hand of certain technique carrying out arrangement analysis and follow-up, can flexible use, perspectives hidden in the data, then makes the decision more accurately to promote the development of enterprise, improve the competitiveness of enterprise. Enterprises generally realize data acquisition, data transmission, data storage, data analysis and processing, data display and the like by establishing a visual platform system.
However, in the research and practice process of the prior art, the inventor discovers that the prior art has a certain limitation on the display of data, and cannot dynamically customize a data report according to the thought of a user, and in terms of functions, only the display of the data is supported, and the visual display of other aspects such as video monitoring, vehicle monitoring, temperature monitoring and the like cannot be realized; in terms of data processing, the prior art part of data is in different primary keys with different cases in a database, but DAX language does not support the case distinction, and the primary key of the original data cannot be directly used as the unique identification of the piece of data. Thus, there is a need for a visualization system that can customize the layout of content presented by an interface as desired, supporting multiple forms of data.
Disclosure of Invention
The invention aims to solve the technical problem of providing a visual method, a visual system and a visual storage medium for a supply chain, which can integrate various system data and customize the content and layout displayed on each interface according to the requirement.
To solve the above problems, one embodiment of the present invention provides a method for visualizing a supply chain, which is adapted to be executed in a computing device, and includes the steps of:
mining the commonality of data among different systems by using a BI technology, and collecting and integrating the data of the different system databases;
data of the different system databases are processed in the ETL, unified modeling is carried out through the SQL Server database, the data are summarized into a Power BI data set, further analysis and integration are carried out on the data to be displayed through the DAX, and finally the data to be displayed are displayed in a report;
dividing a background thematic interface into a plurality of square grids, dragging and selecting a plurality of continuous square grids as a self-defined display module, and customizing the content and layout displayed by the thematic interface according to the requirement;
setting user access settings and distributing thematic viewing rights of different users.
Further, the method for visualizing the supply chain further comprises:
and calling a Power BI related data report form from the Power BI data set through an API interface, and displaying the Power BI related data report form to the thematic interface.
Further, the collecting and integrating the data of the different system databases further includes: and the data of the databases of different systems are extracted and converted by adopting a data interface provided by the application integration gateway and then are loaded into a target data warehouse.
Further, the thematic interface includes a camera container, a BI container, a map container, and a link container, wherein,
the camera container comprises base attribute information, warehouse information and default equipment information;
the BI container includes a same family name, password, client ID, workspace ID, and report ID.
Another embodiment of the present invention provides a supply chain visualization system comprising:
the data acquisition module is used for mining the commonality of the data among different system databases by utilizing the BI technology and acquiring and integrating the data of the different system databases;
the data processing module is used for carrying out data processing on the data of the different system databases in the ETL, summarizing the data into a Power BI data set after unified modeling through the SQL Server database, carrying out further analysis and integration on the data to be displayed through the DAX, and finally displaying the required data in a report;
the self-defining module is used for dividing a background thematic interface into a plurality of square grids, dragging and selecting a plurality of continuous square grids as a self-defining display module, and customizing the content and layout displayed by the thematic interface according to the requirement;
the setting module is used for setting user access settings and distributing thematic viewing rights of different users.
Further, the supply chain visualization system further comprises:
and calling a Power BI related data report form from the Power BI data set through an API interface, and displaying the Power BI related data report form to the thematic interface.
Further, the collecting and integrating the data of the different system databases further includes: and the data of the databases of different systems are extracted and converted by adopting a data interface provided by the application integration gateway and then are loaded into a target data warehouse.
Further, the thematic interface includes a camera container, a BI container, a map container, and a link container, wherein,
the camera container comprises base attribute information, warehouse information and default equipment information;
the BI container includes a same family name, password, client ID, workspace ID, and report ID.
An embodiment of the present invention further provides a computer readable storage medium, where the computer readable storage medium includes a stored computer program, where the computer program when executed controls a device in which the computer readable storage medium is located to perform a method for visualizing a supply chain as described above.
The embodiment of the invention has the following beneficial effects:
the embodiment of the invention provides a method, a system and a storage medium for visualizing a supply chain, wherein the method comprises the following steps: mining the commonality of data among different systems by using a BI technology, and collecting and integrating the data of the different system databases; data of the different system databases are processed in the ETL, unified modeling is carried out through the SQL Server database, the data are summarized into a Power BI data set, further analysis and integration are carried out on the data to be displayed through the DAX, and finally the data to be displayed are displayed in a report; dividing a background thematic interface into a plurality of square grids, dragging and selecting a plurality of continuous square grids as a self-defined display module, and customizing the content and layout displayed by the thematic interface according to the requirement; setting user access settings and distributing thematic viewing rights of different users. The invention can integrate various forms of data, customize the content and layout displayed by each interface for the user according to the requirement of each user, and improve the system customization; by configuring the user permission, the privacy and the safety of the data are enhanced; meanwhile, the system also has certain extensibility by accessing related intelligent hardware.
Drawings
FIG. 1 is a flow diagram of a method for visualizing a supply chain in accordance with one embodiment of the present invention;
FIG. 2 is a flow chart of integrating data according to an embodiment of the present invention;
FIG. 3 is a schematic diagram of a thematic interface according to an embodiment of the invention;
fig. 4 is a schematic structural diagram of a system for visualizing a supply chain according to an embodiment of the invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
First embodiment of the invention
Please refer to fig. 1-3.
As shown in fig. 1, the method for visualizing a supply chain provided in this embodiment is suitable for being executed in a computing device, and includes the following steps:
s101, mining the commonality of data among different systems by utilizing a BI technology, and collecting and integrating the data of the different system databases;
specifically, for step S101, the commonality of data between each system is mined by using the existing BI technology, and data of different systems are integrated, where the data visualized by the supply chain is from databases of systems inside each node enterprise in the supply chain, or data such as EDI, XML files, etc. of transactions between node enterprises.
S102, carrying out data processing on the data of the different system databases in an ETL, summarizing the data into a Power BI data set after unified modeling through an SQL Server database, further analyzing and integrating the data to be displayed through DAX, and finally displaying the required data in a report;
specifically, for step S102, as shown in fig. 2, data processing is performed on data of different systems in ETL, including extraction, cleaning and conversion of data and loading the data into a data warehouse, unified modeling is performed through an SQL Server database, then the data is summarized to a Power BI, and finally, a corresponding report is displayed through a visual management system. At present, partial data is divided into primary keys with different cases in a database, but DAX language does not support case division, so that the primary key of original data cannot be directly used as a unique identifier of the piece of data.
S103, dividing a background thematic interface into a plurality of square grids, dragging and selecting a plurality of continuous square grids as a self-defined display module, and customizing the content and layout displayed by the thematic interface according to the requirement;
specifically, for step S103, in order to be compatible with the presentation of different modules on the thematic interface, the system divides the thematic interface of the background into 16 panes, and the system administrator can drag and select continuous panes at will to present the custom modules, such as the video module, the report module and the link module, so that the administrator can customize the content and the layout presented on each interface for the user according to the needs of each user. The topics merge 4 different types of containers, namely a camera container, a BI container, a map container and a link container, and each container is provided with corresponding proportion and parameters in the background, for example: the attributes contained in the camera container include a base, a warehouse and default equipment, so that an API between the system and a camera interface is opened, and data related to the camera are skillfully integrated into the system. The BI container comprises attributes including a user name, a password, a client ID, a job ID and a report ID, a Power BI related data report is called through an API interface, and finally the report is displayed on a thematic interface through certain adjustment. As shown in fig. 3, the effect of configuring a camera container, a BI container, and a link container in one thematic interface is shown.
Meanwhile, the system reserves a sufficient expansion space, provides a certain expansion possibility for the access and management of subsequent intelligent hardware, such as temperature monitoring, vehicle tracking, goods distribution, access control management and the like, and has a certain extensibility. For example: the system is integrated with a video viewing technology by using net as a basic programming language, and a user can view each monitoring video within the authority range of the user so as to view the operation condition of the warehouse in real time; and the data of the past vehicles are extracted, the vehicle data can be analyzed and interpreted, a related data report is generated, and great convenience is provided for related personnel of a company to check and analyze the data.
S104, setting user access settings and distributing thematic viewing rights of different users.
Specifically, for step S104, after the topics are configured, the topics of different users are allocated with the topic viewing rights through the setting of "accessible person", and the accessible user can view the topics in the foreground after the background issues the topics. By configuring the authorities, data and contents seen by different users are distinguished, the privacy of the data is managed in an enhanced mode, and the safety of each item of data is effectively controlled.
In a preferred embodiment, the method of visualizing a supply chain further comprises:
and calling a Power BI related data report form from the Power BI data set through an API interface, and displaying the Power BI related data report form to the thematic interface.
In a specific embodiment, a Power BI tool is introduced, data are displayed through various vivid visual objects, the data are drilled layer by layer, and linkage analysis is carried out on the data in all aspects, so that a user can be more conveniently helped to carry out analysis decision, the data appointed by the user can be conveniently and rapidly exported, and meanwhile, a data report can be defined according to the own needs of the user.
In a preferred embodiment, the collecting and integrating data of different system databases further comprises: and the data of the databases of different systems are extracted and converted by adopting a data interface provided by the application integration gateway and then are loaded into a target data warehouse.
Specifically, various data interfaces provided by the application integration gateway are utilized to extract, convert and load the data interfaces into a target data warehouse; establishing a multidimensional data set aiming at a visual object, carrying out online analysis and processing, organizing and summarizing data in a data warehouse by utilizing the multidimensional data set and a data aggregation technology, and rapidly evaluating the data by using online analysis and visual tools; finally, the visual information is visually displayed in various chart modes by using a front-end display tool, so that the user can conveniently analyze and decide.
In a preferred embodiment, the thematic interface includes a camera container, a BI container, a map container, and a link container, wherein,
the camera container comprises base attribute information, warehouse information and default equipment information;
the BI container includes a same family name, password, client ID, workspace ID, and report ID.
The invention provided by the embodiment discloses a visualization method of a supply chain, which comprises the following steps: mining the commonality of data among different systems by using a BI technology, and collecting and integrating the data of the different system databases; data of the different system databases are processed in the ETL, unified modeling is carried out through the SQL Server database, the data are summarized into a Power BI data set, further analysis and integration are carried out on the data to be displayed through the DAX, and finally the data to be displayed are displayed in a report; dividing a background thematic interface into a plurality of square grids, dragging and selecting a plurality of continuous square grids as a self-defined display module, and customizing the content and layout displayed by the thematic interface according to the requirement; setting user access settings and distributing thematic viewing rights of different users. The invention can integrate various forms of data, customize the content and layout displayed by each interface for the user according to the requirement of each user, and improve the system customization; by configuring the user permission, the privacy and the safety of the data are enhanced; meanwhile, the system also has certain extensibility by accessing related intelligent hardware.
Second embodiment of the invention
Please refer to fig. 2-4.
As shown in fig. 4, a visualization system for a supply chain provided in this embodiment includes:
the data acquisition module 100 is configured to mine commonalities of data between different system databases by using BI technology, and collect and integrate data of the different system databases;
specifically, for the data acquisition module 100, the existing BI technology is utilized to mine the commonality of data between the systems, and integrate the data of different systems, where the data visualized by the supply chain is from the database of the system inside each node enterprise in the supply chain, or the data such as EDI, XML files, etc. of transactions between the node enterprises.
The data processing module 200 is configured to perform data processing on the data of the different system databases in the ETL, collect the data into a Power BI data set after unified modeling through the SQL Server database, perform further analysis and integration on the data to be displayed through the DAX, and finally display the required data in a report;
specifically, as shown in fig. 2, for the data processing module 200, data of different systems are processed in ETL, including extraction, cleaning conversion and loading of the data to a data warehouse, unified modeling is performed through an SQL Server database, then the data is summarized to a Power BI, and finally the corresponding report is displayed through a visual management system. At present, partial data is divided into primary keys with different cases in a database, but DAX language does not support case division, so that the primary key of original data cannot be directly used as a unique identifier of the piece of data.
The custom module 300 is used for dividing a background thematic interface into a plurality of grids, dragging and selecting a plurality of continuous grids as a custom display module, and customizing the content and layout displayed by the thematic interface according to the requirement;
specifically, for the custom module 300, in order to be compatible with the presentation of different modules on the thematic interface, the system divides the thematic interface of the background into 16 panes, and the system administrator can drag and select continuous panes at will to present custom modules, such as a video module, a report module and a link module, so that the administrator can customize the content and the layout presented on each interface for the user according to the requirements of each user. The topics merge 4 different types of containers, namely a camera container, a BI container, a map container and a link container, and each container is provided with corresponding proportion and parameters in the background, for example: the attributes contained in the camera container include a base, a warehouse and default equipment, so that an API between the system and a camera interface is opened, and data related to the camera are skillfully integrated into the system. The BI container comprises attributes including a user name, a password, a client ID, a job ID and a report ID, a Power BI related data report is called through an API interface, and finally the report is displayed on a thematic interface through certain adjustment. As shown in fig. 3, the effect of configuring a camera container, a BI container, and a link container in one thematic interface is shown.
The setting module 400 is configured to set user access settings and allocate topic viewing rights of different users.
Specifically, for the setting module 400, after the topics are configured, the topics of different users are allocated with the topic viewing rights through the setting of accessible people, and the users accessible after the topics are released by the background can view the topics in the foreground. By configuring the authorities, data and contents seen by different users are distinguished, the privacy of the data is managed in an enhanced mode, and the safety of each item of data is effectively controlled.
In a preferred embodiment, the supply chain visualization system further comprises:
and calling a Power BI related data report form from the Power BI data set through an API interface, and displaying the Power BI related data report form to the thematic interface.
In a specific embodiment, a Power BI tool is introduced, data are displayed through various vivid visual objects, data are drilled layer by layer, and linkage analysis is carried out on the data in all aspects, so that a user can be more conveniently helped to carry out analysis decision, the data appointed by the user can be conveniently and rapidly exported, and meanwhile, a data report can be defined according to the own needs of the user.
In a preferred embodiment, the collecting and integrating data of different system databases further comprises: and the data of the databases of different systems are extracted and converted by adopting a data interface provided by the application integration gateway and then are loaded into a target data warehouse.
Specifically, various data interfaces provided by the application integration gateway are utilized to extract, convert and load the data interfaces into a target data warehouse; establishing a multidimensional data set aiming at a visual object, carrying out online analysis and processing, organizing and summarizing data in a data warehouse by utilizing the multidimensional data set and a data aggregation technology, and rapidly evaluating the data by using online analysis and visual tools; finally, the visual information is visually displayed in various chart modes by using a front-end display tool, so that the user can conveniently analyze and decide.
In a preferred embodiment, the thematic interface includes a camera container, a BI container, a map container, and a link container, wherein,
the camera container comprises base attribute information, warehouse information and default equipment information;
the BI container includes a same family name, password, client ID, workspace ID, and report ID.
The present embodiment provides a visualization system for a supply chain, including: the data acquisition module is used for mining the commonality of the data among different system databases by utilizing the BI technology and acquiring and integrating the data of the different system databases; the data processing module is used for carrying out data processing on the data of the different system databases in the ETL, summarizing the data into a Power BI data set after unified modeling through the SQL Server database, carrying out further analysis and integration on the data to be displayed through the DAX, and finally displaying the required data in a report; the self-defining module is used for dividing a background thematic interface into a plurality of square grids, dragging and selecting a plurality of continuous square grids as a self-defining display module, and customizing the content and layout displayed by the thematic interface according to the requirement; the setting module is used for setting user access settings and distributing thematic viewing rights of different users. The invention can integrate various forms of data, customize the content and layout displayed by each interface for the user according to the requirement of each user, and improve the system customization; by configuring the user permission, the privacy and the safety of the data are enhanced; meanwhile, the system also has certain extensibility by accessing related intelligent hardware.
Another embodiment of the present invention also provides a computer readable storage medium, where the computer readable storage medium includes a stored computer program, where the computer program when executed controls a device in which the computer readable storage medium is located to perform a method for visualizing a supply chain as described above.
The embodiment of the invention provides a method, a system and a storage medium for visualizing a supply chain, wherein the method comprises the following steps: mining the commonality of data among different systems by using a BI technology, and collecting and integrating the data of the different system databases; data of the different system databases are processed in the ETL, unified modeling is carried out through the SQL Server database, the data are summarized into a Power BI data set, further analysis and integration are carried out on the data to be displayed through the DAX, and finally the data to be displayed are displayed in a report; dividing a background thematic interface into a plurality of square grids, dragging and selecting a plurality of continuous square grids as a self-defined display module, and customizing the content and layout displayed by the thematic interface according to the requirement; setting user access settings and distributing thematic viewing rights of different users. The invention can integrate various forms of data, customize the content and layout displayed by each interface for the user according to the requirement of each user, and improve the system customization; by configuring the user permission, the privacy and the safety of the data are enhanced; meanwhile, the system also has certain extensibility by accessing related intelligent hardware.
In the foregoing embodiments of the present invention, the descriptions of the embodiments are emphasized, and for a portion of this disclosure that is not described in detail in this embodiment, reference is made to the related descriptions of other embodiments.
In the several embodiments provided in the present application, it should be understood that the disclosed technology content may be implemented in other manners. The system embodiments described above are merely exemplary, and for example, the modules may be divided into a logic function, and another division may be implemented in practice, for example, a plurality of modules or components may be combined or integrated into another system, or some features may be omitted or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be through some interfaces, units or modules, or may be in electrical or other forms.
The modules described as separate components may or may not be physically separate, and components shown as modules may or may not be physical modules, i.e., may be located in one place, or may be distributed over a plurality of modules. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional module in each embodiment of the present invention may be integrated into one processing module, or each module may exist alone physically, or two or more modules may be integrated into one module. The integrated modules may be implemented in hardware or in software functional modules.
While the foregoing is directed to the preferred embodiments of the present invention, it should be noted that modifications and variations could be made by those skilled in the art without departing from the principles of the present invention, and such modifications and variations are to be regarded as being within the scope of the invention.
Those skilled in the art will appreciate that implementing all or part of the above-described methods in accordance with the embodiments may be accomplished by way of a computer program stored on a computer readable storage medium, which when executed may comprise the steps of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), or the like.
Claims (3)
1. A method of visualizing a supply chain, adapted to be executed in a computing device, comprising the steps of:
mining the commonality of data among different systems by using a BI technology, and collecting and integrating the data of the different system databases; the database is a database of an internal system of each node enterprise in the supply chain;
data of the different system databases are processed in the ETL, unified modeling is carried out through the SQL Server database, the data are summarized into a Power BI data set, further analysis and integration are carried out on the data to be displayed through the DAX, and finally the data to be displayed are displayed in a report; wherein, the data to be displayed is further analyzed and integrated by DAX, which comprises:
traversing the original data character string by adopting a data combination method through a custom function and a storage process, converting the original data character string into capital letters corresponding to "@" when encountering the capital letters, and then combining other character strings to form a new primary key;
dividing a background thematic interface into a plurality of square grids, dragging and selecting a plurality of continuous square grids as a self-defined display module, and customizing the content and layout displayed by the thematic interface according to the requirement; the self-defined display module comprises a video module, a report module and a link module; the thematic interface includes a camera container, a BI container, a map container, and a link container, wherein,
the camera container comprises base attribute information, warehouse information and default equipment information;
the BI container comprises a same family name, a password, a client ID, a working area ID and a report ID;
setting user access settings and distributing thematic viewing rights of different users;
wherein, the data of different system databases is gathered and integrated, still include:
the method comprises the steps of extracting and converting data of different system databases by adopting a data interface provided by an application integration gateway, and loading the data into a target data warehouse, wherein the method specifically comprises the following steps:
the data of different system databases are extracted, converted and loaded into a target data warehouse by utilizing various data interfaces provided by an application integration gateway; establishing a multidimensional data set aiming at a visual object, carrying out online analysis and processing, organizing and summarizing data in a data warehouse by utilizing a multidimensional data set and data aggregation technology, evaluating the data by utilizing online analysis and visual tools, and intuitively displaying visual information in various chart modes by utilizing a front-end display tool;
the method further comprises the steps of:
accessing and managing intelligent hardware, integrating a video viewing technology by taking net as a basic programming language, and viewing each monitoring video within the authority range of a user by the user, and viewing the operation condition of a warehouse in real time;
extracting data of a past vehicle, analyzing and reading the data, and generating a related data report;
the method specifically comprises the steps of calling a Power BI related data report form from the Power BI data set through an API interface, and displaying the Power BI related data report form to the thematic interface, wherein the method specifically comprises the following steps:
the Power BI tool is introduced, the data are displayed through visual objects with various vivid images, the data are drilled layer by layer, the data in all aspects are subjected to linkage analysis, a user is helped to make analysis decisions, the data appointed by the user are exported, and a data report is defined according to the user's own requirements.
2. A supply chain visualization system capable of performing the supply chain visualization method of claim 1, comprising:
the data acquisition module is used for mining the commonality of the data among different system databases by utilizing the BI technology and acquiring and integrating the data of the different system databases; the database is a database of an internal system of each node enterprise in the supply chain;
the data processing module is used for carrying out data processing on the data of the different system databases in the ETL, summarizing the data into a Power BI data set after unified modeling through the SQL Server database, carrying out further analysis and integration on the data to be displayed through the DAX, and finally displaying the required data in a report; wherein, the data to be displayed is further analyzed and integrated by DAX, which comprises:
traversing the original data character string by adopting a data combination method through a custom function and a storage process, converting the original data character string into capital letters corresponding to "@" when encountering the capital letters, and then combining other character strings to form a new primary key;
the self-defining module is used for dividing a background thematic interface into a plurality of square grids, dragging and selecting a plurality of continuous square grids as a self-defining display module, and customizing the content and layout displayed by the thematic interface according to the requirement; the self-defined display module comprises a video module, a report module and a link module; the thematic interface includes a camera container, a BI container, a map container, and a link container, wherein,
the camera container comprises base attribute information, warehouse information and default equipment information;
the BI container includes a same family name, a password, a client ID, a workspace ID, and a report ID
The setting module is used for setting user access settings and distributing thematic viewing rights of different users;
wherein, the data of different system databases is gathered and integrated, still include: the method comprises the steps of extracting and converting data of different system databases by adopting a data interface provided by an application integration gateway, and loading the data into a target data warehouse, wherein the method specifically comprises the following steps:
the data of different system databases are extracted, converted and loaded into a target data warehouse by utilizing various data interfaces provided by an application integration gateway; establishing a multidimensional data set aiming at a visual object, carrying out online analysis and processing, organizing and summarizing data in a data warehouse by utilizing a multidimensional data set and data aggregation technology, evaluating the data by utilizing online analysis and visual tools, and intuitively displaying visual information in various chart modes by utilizing a front-end display tool;
the system further comprises:
accessing and managing intelligent hardware, integrating a video viewing technology by taking net as a basic programming language, and viewing each monitoring video within the authority range of a user by the user, and viewing the operation condition of a warehouse in real time;
extracting data of a past vehicle, analyzing and reading the data, and generating a related data report;
the method specifically comprises the steps of calling a Power BI related data report form from the Power BI data set through an API interface, and displaying the Power BI related data report form to the thematic interface, wherein the method specifically comprises the following steps:
the Power BI tool is introduced, the data are displayed through visual objects with various vivid images, the data are drilled layer by layer, the data in all aspects are subjected to linkage analysis, a user is helped to make analysis decisions, the data appointed by the user are exported, and a data report is defined according to the user's own requirements.
3. A computer readable storage medium, characterized in that the computer readable storage medium comprises a stored computer program, wherein the computer program, when run, controls a device in which the computer readable storage medium is located to perform the method of visualizing a supply chain as claimed in claim 1.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910687420.4A CN110457368B (en) | 2019-07-26 | 2019-07-26 | Visualization method, system and storage medium for supply chain |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910687420.4A CN110457368B (en) | 2019-07-26 | 2019-07-26 | Visualization method, system and storage medium for supply chain |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110457368A CN110457368A (en) | 2019-11-15 |
| CN110457368B true CN110457368B (en) | 2023-07-21 |
Family
ID=68483827
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910687420.4A Active CN110457368B (en) | 2019-07-26 | 2019-07-26 | Visualization method, system and storage medium for supply chain |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110457368B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111273839B (en) * | 2020-01-13 | 2024-06-04 | 平安国际智慧城市科技股份有限公司 | Data processing method and device for chart, computer equipment and storage medium |
| CN113672594A (en) * | 2021-06-08 | 2021-11-19 | 厦门锐特信息技术有限公司 | BI report system suitable for logistics supply chain business |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101477526A (en) * | 2008-12-31 | 2009-07-08 | 中兴通讯股份有限公司 | Method and system for implementing statistical forms customization |
| CN102325177A (en) * | 2011-09-05 | 2012-01-18 | 太原理工大学 | Coal mine production three-dimensional visualization information system based on Internet of things |
| CN103458033A (en) * | 2013-09-04 | 2013-12-18 | 北京邮电大学 | System for providing services of event-driven service-oriented internet of things and working method thereof |
| CN103984755A (en) * | 2014-05-28 | 2014-08-13 | 中国地质大学（北京） | Multidimensional model based oil and gas resource data key system implementation method and system |
| CN106022560A (en) * | 2016-05-05 | 2016-10-12 | 四川铁安达科技有限公司 | Subway shield segment attitude monitoring and management system based on Internet of Things and cloud computing |
| US9563608B1 (en) * | 2016-01-29 | 2017-02-07 | International Business Machines Corporation | Data analysis results authoring and peer review |
| CN109284330A (en) * | 2018-09-04 | 2019-01-29 | 福建奇点时空数字科技有限公司 | A kind of Internet of Things big data management system for garden |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6963920B1 (en) * | 1993-11-19 | 2005-11-08 | Rose Blush Software Llc | Intellectual asset protocol for defining data exchange rules and formats for universal intellectual asset documents, and systems, methods, and computer program products related to same |
| US7848889B2 (en) * | 2004-08-02 | 2010-12-07 | Bioarray Solutions, Ltd. | Automated analysis of multiplexed probe-target interaction patterns: pattern matching and allele identification |
| US10042636B1 (en) * | 2017-04-11 | 2018-08-07 | Accenture Global Solutions Limited | End-to end project management platform with artificial intelligence integration |
| CN108512691A (en) * | 2018-02-07 | 2018-09-07 | 复旦大学 | Cloud automatic early-warning O＆M monitoring system based on Hadoop |
| CN108628608A (en) * | 2018-04-16 | 2018-10-09 | 朗新科技股份有限公司 | A kind of method and device of data visualization |
| CN109446221B (en) * | 2018-10-29 | 2021-04-30 | 北京百分点科技集团股份有限公司 | Interactive data exploration method based on semantic analysis |
-
2019
- 2019-07-26 CN CN201910687420.4A patent/CN110457368B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101477526A (en) * | 2008-12-31 | 2009-07-08 | 中兴通讯股份有限公司 | Method and system for implementing statistical forms customization |
| CN102325177A (en) * | 2011-09-05 | 2012-01-18 | 太原理工大学 | Coal mine production three-dimensional visualization information system based on Internet of things |
| CN103458033A (en) * | 2013-09-04 | 2013-12-18 | 北京邮电大学 | System for providing services of event-driven service-oriented internet of things and working method thereof |
| CN103984755A (en) * | 2014-05-28 | 2014-08-13 | 中国地质大学（北京） | Multidimensional model based oil and gas resource data key system implementation method and system |
| US9563608B1 (en) * | 2016-01-29 | 2017-02-07 | International Business Machines Corporation | Data analysis results authoring and peer review |
| CN106022560A (en) * | 2016-05-05 | 2016-10-12 | 四川铁安达科技有限公司 | Subway shield segment attitude monitoring and management system based on Internet of Things and cloud computing |
| CN109284330A (en) * | 2018-09-04 | 2019-01-29 | 福建奇点时空数字科技有限公司 | A kind of Internet of Things big data management system for garden |
Non-Patent Citations (1)
| Title |
|---|
| 基于物联网的煤矿可视化系统研究;刘西青等;煤矿机械;253-254 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110457368A (en) | 2019-11-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Akhtar et al. | Data analytics and visualization using Tableau utilitarian for COVID-19 (Coronavirus) | |
| US10235533B1 (en) | Multi-user access controls in electronic simultaneously editable document editor | |
| US9740675B1 (en) | Communications between a customer relationship management (CRM) application and an electronic worksheet to automatically generate a pivot table object | |
| CN107704608A (en) | A kind of OLAP multidimensional analyses and data digging system | |
| US8417734B2 (en) | Systems and methods for managing sets of model objects via unified management interface | |
| US5787412A (en) | Object oriented data access and analysis system | |
| US8180795B2 (en) | Apparatus and method for distribution of a report with dynamic write-back to a data source | |
| CN107247788A (en) | A kind of method of the comprehensive regulation service based on government data | |
| CN110807015A (en) | Big data asset value delivery management method and system | |
| CN108351883A (en) | The display of dynamic context hinge network analysis | |
| US7991838B2 (en) | Apparatus and method for report sharing within an instant messaging framework | |
| CN103678468B (en) | The system and method for improved consumption model for profiling | |
| US9442618B2 (en) | Mobile device interface generator | |
| US10448227B2 (en) | Mobile database access application development system and method | |
| CN101821709A (en) | System, method and graphical user interface for workflow generation, deployment and/or execution | |
| CN101821710A (en) | System, method and graphical user interface for workflow generation, deployment and/or execution | |
| CN110457368B (en) | Visualization method, system and storage medium for supply chain | |
| CN110249356B (en) | Sharing method and system for user-defined ERP function | |
| US9608869B2 (en) | Enterprise applications navigation using tile characteristics that change with applications data | |
| CN106709017A (en) | Big data-based aid decision making method | |
| US10783214B1 (en) | Adaptive and dynamic user interface with linked tiles | |
| CN114218309A (en) | Data processing method, system and computer equipment | |
| CN113157947A (en) | Knowledge graph construction method, tool, device and server | |
| US9904452B2 (en) | Building user specific user interface instances | |
| US8832601B2 (en) | ETL tool utilizing dimension trees |
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 |