WO2024065338A1 - 电子看板的确定方法及装置 - Google Patents

电子看板的确定方法及装置 Download PDF

Info

Publication number
WO2024065338A1
WO2024065338A1 PCT/CN2022/122344 CN2022122344W WO2024065338A1 WO 2024065338 A1 WO2024065338 A1 WO 2024065338A1 CN 2022122344 W CN2022122344 W CN 2022122344W WO 2024065338 A1 WO2024065338 A1 WO 2024065338A1
Authority
WO
WIPO (PCT)
Prior art keywords
target
data
component
electronic
response
Prior art date
Application number
PCT/CN2022/122344
Other languages
English (en)
French (fr)
Inventor
陈韵
雷秀东
梁峥峥
高俊
吴建波
鲍国庆
吴建民
王洪
Original Assignee
京东方科技集团股份有限公司
北京中祥英科技有限公司
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by 京东方科技集团股份有限公司, 北京中祥英科技有限公司 filed Critical 京东方科技集团股份有限公司
Priority to CN202280003320.5A priority Critical patent/CN118103812A/zh
Priority to PCT/CN2022/122344 priority patent/WO2024065338A1/zh
Publication of WO2024065338A1 publication Critical patent/WO2024065338A1/zh

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00—Arrangements for software engineering
    • G06F8/30—Creation or generation of source code
    • G06F8/34—Graphical or visual programming
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F8/00—Arrangements for software engineering
    • G06F8/30—Creation or generation of source code
    • G06F8/38—Creation or generation of source code for implementing user interfaces

Definitions

  • the present disclosure relates to the field of data processing technology, and in particular to a method and device for determining an electronic billboard.
  • electronic billboards are gradually being widely used.
  • electronic billboards can display the data analysis results of production data in the form of visualization reports according to user needs, so that users or managers can understand the current production situation in a timely manner based on the data analysis results.
  • a method for determining an electronic kanban is provided. Applied to an electronic device, the electronic device is used to manage an electronic kanban, the method comprising: determining a target data source for obtaining target business data; in response to a first operation, obtaining a first component model, and configuring the attribute information of the first component model to obtain a target component model. In response to a second operation, obtaining target business data from the target data source, and associating the target business data with the target component model to obtain a target component for reflecting the distribution of the target business data. The target component is displayed in the electronic kanban.
  • the target data source includes a target database or an offline file
  • the second operation is a second configuration operation or a second upload operation
  • the above-mentioned method of "obtaining target business data from the target data source in response to the second operation" specifically includes: in response to the second configuration operation, obtaining the target business data from the target database associated with the electronic device; or, in response to the second upload operation, obtaining an offline file, and parsing the offline file to obtain the target business data.
  • the target data source is a target database
  • the method includes: acquiring a first link indicating the target database, and establishing a connection with the target database according to the first link.
  • the target data source is an offline file
  • the method further includes: in response to a third configuration operation, setting the target data source to an offline file.
  • the first operation includes a first selection operation or a first call operation
  • the above-mentioned method of "obtaining a first component model in response to the first operation" specifically includes: in response to the first selection operation, obtaining the first component model from multiple component models pre-configured in the electronic device; or, in response to the first call operation, obtaining a program code for generating the first component model, and running the program code to obtain the first component model.
  • the target database stores multiple data; the multiple data are data processed from original data using preset tools, and the multiple data include target business data.
  • processing the raw data using a preset tool refers to performing extract-transform-load (ETL) processing on the raw data.
  • ETL extract-transform-load
  • the method further includes: obtaining user information including a user account and a corresponding password; and displaying a function for uploading a comma-separated values (csv) file when the user information has permission to upload offline files, wherein the csv file includes target business data.
  • the above-mentioned method of "obtaining the target business data from the target data source" specifically includes: obtaining a csv file through an upload page, and obtaining the target business data from the csv.
  • the method further includes: receiving and storing a plurality of offline files determined according to a preset file template; and displaying information of the plurality of offline files through an electronic signboard.
  • the method further includes: determining a first component for reflecting the distribution of the first business data; and establishing an association relationship between the target component and the first component in response to a third operation.
  • the above-mentioned method of "displaying the target component in an electronic kanban” specifically includes: displaying the target component and the first component in the electronic kanban according to the association relationship between the target component and the first component.
  • a device for determining an electronic billboard is provided.
  • the device is applied to an electronic device.
  • the electronic device is used to determine the electronic billboard.
  • the device includes a determining unit, an acquiring unit, and a processing unit.
  • the determination unit is configured to: determine a target data source for acquiring target business data.
  • the acquisition unit is configured to: in response to the first operation, acquire the first component model, and configure the attribute information of the first component model to obtain the target component model.
  • the acquisition unit is further configured to: in response to the second operation, acquire target business data from the target data source, and associate the target business data with the target component model to obtain a target component for reflecting the distribution of the target business data.
  • the display unit is used to display the target component in the electronic signage.
  • the target data source includes a target database or an offline file
  • the second operation is a second configuration operation or a second upload operation
  • the acquisition unit is specifically configured to: in response to the second configuration operation, acquire target business data from a target database associated with the electronic device; or, in response to the second upload operation, acquire an offline file, and parse the offline file to acquire the target business data.
  • the device further comprises a processing unit
  • the target data source comprises a target database or an offline file
  • the acquisition unit is further configured to: acquire a first link indicating the target database.
  • the processing unit is configured to: establish a connection with the target database according to the first link.
  • the target data source is an offline file
  • the processing unit is configured to: in response to the third configuration operation, set the target data source to an offline file.
  • the first operation includes a first selection operation or a first calling operation
  • the acquisition unit is specifically configured to: in response to the first selection operation, acquire the first component model from a plurality of component models pre-configured in the electronic device; or, in response to the first calling operation, acquire a program code for generating the first component model, and run the program code to obtain the first component model.
  • the target database stores multiple data; the multiple data are data processed from original data using preset tools, and the multiple data include target business data.
  • processing the raw data using a preset tool refers to performing extract-transform-load (ETL) processing on the raw data.
  • ETL extract-transform-load
  • the acquisition unit is further configured to: acquire user information including a user account and a corresponding password; and if the user information has permission to upload offline files, display a command for uploading a csv file, the csv file including target business data.
  • the acquisition unit is further configured to: acquire the csv file through the upload page, and acquire the target business data from the csv.
  • the method further includes: receiving and storing a plurality of offline files determined according to a preset file template; and displaying information of the plurality of offline files through an electronic signboard.
  • the determination unit is further configured to: determine a first component for reflecting the distribution of the first business data; and in response to the third operation, establish an association relationship between the target component and the first component.
  • the display unit is specifically configured to: display the target component and the first component in the electronic signboard according to the association relationship between the target component and the first component.
  • a device for determining an electronic signage comprising a processor and a communication interface.
  • the communication interface is coupled to the processor.
  • the processor is configured to run a computer program or instruction to implement the determination method of the first aspect or any embodiment of the first aspect.
  • a computer-readable storage medium stores computer program instructions, and when the computer program instructions are executed on a computer (eg, an electronic device), the computer executes the determination method as described in any of the above embodiments.
  • a computer program product comprising computer program instructions, and when the computer program instructions are executed on a computer (eg, an electronic device), the computer program instructions cause the computer to execute the determination method as described in any of the above embodiments.
  • a computer program is provided.
  • the computer program When the computer program is executed on a computer (e.g., an electronic device), the computer program enables the computer to execute the determination method described in any one of the above embodiments.
  • FIG1 is a structural diagram of an electronic signage development system according to some embodiments.
  • FIG2 is a schematic diagram of an electronic signage development page according to some embodiments.
  • FIG3 is a schematic diagram of user demand information according to some embodiments.
  • FIG4 is a structural diagram of an electronic signage development system according to some embodiments.
  • FIG5 is a schematic diagram of the structure of an electronic device according to some embodiments.
  • FIG6 is a flow chart of a method for determining an electronic signage according to some embodiments.
  • FIG7 is a flowchart illustrating an example of a task execution process according to some embodiments.
  • FIG8 is a schematic diagram of a task extraction process according to some embodiments.
  • FIG9 is a schematic diagram of a task extraction according to some embodiments.
  • FIG10 is a schematic diagram of an assembly according to some embodiments.
  • FIG11 is a schematic diagram of an electronic signage development page according to some embodiments.
  • FIG12 is a schematic diagram of another electronic signage development page according to some embodiments.
  • FIG13 is a schematic diagram of another electronic signage development page according to some embodiments.
  • FIG14 is a schematic diagram of the structure of a device for determining an electronic billboard according to some embodiments.
  • FIG. 15 is a schematic diagram of the structure of a device for determining an electronic billboard according to some embodiments.
  • first and second are used for descriptive purposes only and are not to be understood as indicating or implying relative importance or implicitly indicating the number of the indicated technical features.
  • a feature defined as “first” or “second” may explicitly or implicitly include one or more of the features.
  • plural means two or more.
  • the expressions “coupled” and “connected” and their derivatives may be used.
  • the term “connected” may be used to indicate that two or more components are in direct physical or electrical contact with each other.
  • the term “coupled” may be used to indicate that two or more components are in direct physical or electrical contact.
  • the term “coupled” or “communicatively coupled” may also refer to two or more components that are not in direct contact with each other, but still cooperate or interact with each other. The embodiments disclosed herein are not necessarily limited to the contents of this document.
  • At least one of A, B, and C has the same meaning as “at least one of A, B, or C” and both include the following combinations of A, B, and C: A only, B only, C only, the combination of A and B, the combination of A and C, the combination of B and C, and the combination of A, B, and C.
  • a and/or B includes the following three combinations: A only, B only, and a combination of A and B.
  • the term “if” is optionally interpreted to mean “when” or “upon” or “in response to determining” or “in response to detecting,” depending on the context.
  • the phrases “if it is determined that” or “if [a stated condition or event] is detected” are optionally interpreted to mean “upon determining that” or “in response to determining that” or “upon detecting [a stated condition or event]” or “in response to detecting [a stated condition or event],” depending on the context.
  • Electronic kanban It can also be called electronic data kanban or electronic data report. It is a data visualization display method, which is widely used in the production and management of manufacturing plants.
  • Electronic data kanban can display data analysis results in a visual way according to the needs of the user's specific application scenario.
  • the content of the electronic data kanban can include multiple components.
  • Components are related to data.
  • the types of components can include table components, image components (such as bar charts, line graphs, etc.), and announcement type components (such as bulletin boards, notification boards, etc.).
  • Electronic kanban can also update data in real time to facilitate users to understand and analyze product production.
  • electronic devices can display data analysis results in a vivid way in the form of tables, tree diagrams, components, line graphs, etc.
  • the application process of the electronic data dashboard may include data collection, data processing and storage, and data visualization (or component visualization).
  • data visualization or component visualization
  • the electronic data dashboard can be provided with software tools (such as TIBCO Spotfire, FineReport, etc.).
  • software tools such as TIBCO Spotfire, FineReport, etc.
  • the users of these software need to have a code development foundation and experience, that is, the requirements for users are high and the usage foundation is improved.
  • the development difficulty of the electronic data dashboard is increased. Therefore, designing a set of low-development difficulty to expand the application scenarios of the electronic data dashboard has become a technical problem that needs to be solved urgently.
  • an electronic signage system is provided in an embodiment of the present application.
  • the system may include a framework layer, a data layer, a service layer, and an application layer.
  • the framework layer, the data layer, the service layer, and the application layer are described below.
  • the framework layer can be connected to the cloud platform.
  • the framework layer can process business through the cloud platform.
  • the framework layer can include terminals, hardware resources, virtualization platforms, and virtual desktops.
  • the framework layer can be used for security maintenance (such as document protection and behavior management) and management of virtual desktops, hardware resources, etc.
  • the framework layer can include front-end frameworks and back-end frameworks.
  • the front-end framework can use the Vue framework or the Angular framework to achieve visualization and separation of data and structure.
  • the backend framework can use Spring Boot framework or Spring Model View Controller (MVC) framework or Mybatis framework.
  • MVC Spring Model View Controller
  • Spring MVC is a software design specification that can organize code by separating business logic, data, and display.
  • Model data model, provides data to be displayed, so it contains data and behavior, which is the Dao layer and Service layer.
  • View is responsible for displaying the model. It is generally the user interface we see and what the customer wants to see.
  • Controller Receives user requests including data, and inputs the data into a preset model for processing (state change) to obtain the corresponding data processing results; returns the data processing results to the view for display.
  • SpringMVC lightweight, easy to learn; efficient, request-response-based MVC framework; good compatibility with Spring, seamless integration; convention over configuration; powerful.
  • Spring's web framework is designed around DispatcherServlet (dispatching Servlet).
  • the data layer is used to collect data from the device side (or data source) and manage the database.
  • the types of databases can include Oracle, MySQL, PostgreSQL, etc.
  • the data layer may include a manufacturing execution system (MES) database, an operational data store (ODS) database, and a manufacturing data warehouse (MDW) database.
  • MES manufacturing execution system
  • ODS operational data store
  • MDW manufacturing data warehouse
  • the MES database can be connected to the production equipment.
  • the MES database can be used to store the manufacturing data of the production equipment, such as product quantity, product qualification rate, production efficiency, etc.
  • the MES database can be set with permissions or protection measures. That is, if the operator does not have permission, the MES database cannot add, delete, modify, query, etc. the stored data.
  • the ODS database can be used to store raw data.
  • the data in the ODS database is consistent with the data manufactured by the source system.
  • ODS data can extract data from the MES database and store it. Summarize, store, and analyze data in the manufacturing process. That is, the ODS database can back up the data in the MES database. In this way, it can avoid the problem of data anomalies when data loss or data tampering occurs in the MES database.
  • the data in the ODS database cannot be added, deleted, modified, or queried, if the MES database and the MDW database are directly connected, the data may still be unprocessed when entering the MDW database, resulting in the problem of data clutter when the data is subsequently obtained from the MDW database.
  • the data can be summarized and analyzed in the ODS database, and then the summarized and analyzed data can be stored in the MDW database, so that the data stored in the MEW database can be summarized and analyzed data, which can facilitate the subsequent rapid query of related data when generating components in the electronic billboard.
  • the MDW database is used to aggregate, store, and analyze data in the manufacturing process. That is, the MDW database can respond to user operations, organize and aggregate data, and obtain multiple types of data tables.
  • the data in the data table can be used as a subsequent data source and data foundation.
  • the service layer is mainly used to manage functional interfaces, data sources, component development, user information, etc.
  • the data source may include a database and a CSV file.
  • the user information may include the user's authority and the user's account information (such as account number and password, etc.).
  • the programming language for component development may be Java, SQL, etc.
  • the service layer can also provide communication services.
  • the service layer can use transmission control protocol/internet protocol (TCP/IP).
  • TCP/IP transmission control protocol/internet protocol
  • Device-to-database communication can use high-speed message services (HSMS), Tibco, file transfer protocol (FTP), etc.
  • HSMS high-speed message services
  • Tibco Tibco
  • FTP file transfer protocol
  • the service layer may be provided with a development page. Based on the development page, the above functions of the service layer may be implemented.
  • the development page may include large screen development, data source management, decision platform management, user management, role management, and system settings.
  • the large screen development can manage the electronic signage in response to the operation of the developer.
  • the operation can include creating, editing, previewing, copying, downloading, publishing, deleting the electronic signage and other operations.
  • Data source management can manage data sources in response to the operations of developers, such as establishing a connection with a database, editing a connection with a database (such as modifying the link of an associated database, etc.), managing CSV files, etc.
  • the decision platform management can respond to the policies input by the developer to manage the electronic signage, for example, it can determine the electronic device that displays the electronic signage, the duration of the electronic signage display, etc.
  • User management can be used to manage user information. For example, it can be used to manage user accounts and permissions.
  • Role management can be used to configure user permissions. Different users can be assigned different permissions. The permissions can include whether to upload offline files, whether to modify the electronic dashboard, etc.
  • System settings can be used to set general functions of the electronic billboard. For example, you can set the title display effect of the electronic billboard.
  • an electronic signage development page is provided in an embodiment of the present application.
  • the electronic signage development page may be a page displayed by the electronic device in response to clicking the “large screen development” operation in a of FIG. 2 .
  • the electronic signage development page may be used to develop components.
  • the electronic signage development page may include multiple areas, each area corresponding to a different function.
  • the multiple areas may include a component area, a layer area, a development area, a configuration area, an interaction area, and a control area. The functions of these areas are described below.
  • the component area can be used to display multiple component models.
  • the component model can include icon components, text components, etc.
  • the electronic device in response to a drag operation on multiple component models in the component area, may display the component models in the development area and display the names of the component models in the layer area.
  • the layer area can be used to manage components in the development area. For example, when a component in the development area is selected or clicked, the layer area can display the information of the component.
  • the layer area can respond to operations by renaming components, sorting the hierarchical relationship of components, copying components, deleting components, etc.
  • development area can be used to display component models/component styles.
  • the development area can also modify and configure component models.
  • the configuration area can be used to configure components. For example, you can modify the properties of the component (corresponding to the properties in the diagram), the data of the component (corresponding to the data in the diagram), and the interaction between components (corresponding to the interaction in the diagram). Different components display different specific contents, and the content displayed by the component can be set in the configuration area.
  • the properties are mainly used to set the position, size, style properties, configuration data, etc. of the components on the electronic billboard.
  • Data is mainly used to set the data source type, the component's own data and data format, API call background interface, CSV file import data source, etc.
  • the electronic signage can obtain data from a database through SQL and associate the data with a component.
  • an input box can be provided under the data in the configuration area, and the input box can be used to input SQL.
  • Interaction mainly used to set according to the function of the component.
  • the interaction area can manage component areas, layer areas, and configuration areas.
  • the interaction area can be provided with buttons such as component collection, layer collection, and configuration collection.
  • the electronic kanban development page can collapse or expand the area corresponding to the button.
  • the component area can be hidden in response to clicking the component collapse. Then, in response to clicking the component collection again, the electronic development page can redisplay the component area.
  • the interactive area can also be used to implement interaction between multiple components.
  • the target business data acquired by the electronic device includes filtering conditions (product name, production time), that is, the electronic device can dynamically display the data through a line bar graph.
  • the electronic device can associate the filter box and the line bar graph in response to the user's associated operation in the interactive area. That is, after the electronic billboard displays the filter box, the line bar graph corresponding to the product name in the filter box can be automatically displayed.
  • the line bar graph can consist of the product name and the corresponding production time (such as the horizontal axis is the product name and the vertical axis is the production time).
  • Control area can be used to manage the content of the electronic development page.
  • the control area can be provided with buttons such as return, preview, and publish.
  • return the electronic device can return to the page shown in a of Figure 2.
  • preview the electronic device can display a preview page.
  • the preview page can display components of the development area.
  • publish the electronic device can display a window to confirm whether to publish.
  • the application layer can be used to manage the application scenarios of the electronic signage.
  • the application layer can realize the development and management of the electronic signage through development tools.
  • the development tools can refer to the subsequent description and will not be described here.
  • the actual business needs of the manufacturing factory may include people (such as factory park management, manufacturer management, employee management, etc.), machines (such as equipment alarm processing, equipment maintenance and spare parts management, equipment generation status management, equipment operation monitoring, etc.), materials (such as finished product management, warehouse location management, raw material management, etc.), methods (such as production plans and performance, sales plans and performance, SPC system, abnormal communication management, etc.), environment (such as water, electricity and gas stability, water, electricity and gas usage, green product management, etc.), measurement (such as defect analysis, daily yield report, process control, OQA shipment inspection, etc.), production (such as input, output, scrap, hold, etc., etc., etc.), etc.) and other aspects of user needs.
  • the electronic billboard can set the application scenario and display the components of the corresponding type of the application scenario according to the needs of the user. For example, components such as text boxes, drop-down boxes, line bar charts, tables, pie charts, radar charts, etc.
  • Hold can refer to a product that is stranded at the current site because of a risk. Movement can refer to the number of products produced by a site over a period of time. WIP refers to products that are currently being produced, products that have been put into production and not scrapped, and products that have been produced are all work in progress. ETC out refers to products that are used for other purposes. For example, due to analysis and verification, it is necessary to apply to take products out of the production line.
  • an electronic kanban development system may include a data source, a component development platform, and an electronic kanban development platform.
  • the component development platform is connected to the electronic kanban development platform.
  • the component development platform may be provided with a functional interface.
  • the functional interface may be connected to the electronic kanban development platform.
  • the data source is the data source and basis of the electronic billboard development system.
  • the data source can be connected to a database.
  • the database can store processed data.
  • Offline files can refer to data that is not stored in the database and needs to be accessed through the electronic billboard.
  • the data source may include a database, a storage device for storing offline files/an interface for acquiring offline files, etc.
  • a database for the description of the database, reference may be made to the following description of the database.
  • components may include complex components and simple components.
  • simple components can be implemented through SQL on the electronic kanban development page.
  • Complex components cannot be implemented through SQL on the electronic kanban development page and need to be developed through the development component platform.
  • the component development platform can be used to develop complex components. For example, the development platform can obtain data associated with the component from a database in response to the input code, and then generate the corresponding component. Component development can also be used to verify the function of the component through interface testing. The component development platform can also send complex components to the electronic signage development platform through the functional interface.
  • the electronic kanban development platform also known as the electronic kanban system platform, can be used to develop electronic kanbans.
  • the electronic kanban development platform may include an electronic kanban development page, a data source management module, a permission management model, and a user management module.
  • the electronic signage development page may include the pages shown in a and b of FIG. 2.
  • the data source management module may be used to manage databases and offline files.
  • the authority management module may be used to manage user authority.
  • the user management module may be used to manage user information (such as user account and password, etc.).
  • FIG5 is a schematic diagram of the structure of an electronic device provided in an embodiment of the present application.
  • the electronic device may have a display 510, a processor 520, and a graphics processing unit (GPU) 530.
  • the display 510 may be communicatively connected with the processor 520 and the GPU 530.
  • the display 510 and the processor 520 may be connected via a system bus 530.
  • the processor 520 may be communicatively connected with the GPU.
  • the display 510 may include a display screen or a screen.
  • the display 510 may be used to display an electronic signage.
  • the display may be a liquid crystal display (LCD), an organic light-emitting diode (OLED) display, or the like.
  • LCD liquid crystal display
  • OLED organic light-emitting diode
  • the processor 520 may include one or more central processing units (CPUs).
  • the CPU may be used to process data and perform operations of the electronic device in the embodiment of the present application. For example, operations on the development page of the electronic billboard, etc.
  • an electronic signage management method provided in an embodiment of the present application is provided, and the method can be applied to the electronic device shown in Fig. 5.
  • the method can include S601 to S604.
  • the target data source may be used to obtain target business data.
  • the target business data may be data that needs to be displayed in the electronic signboard.
  • the target business data may be data of a manufacturing plant.
  • it may be worker data, equipment data, material data, manufacturing data, test data, environmental data, etc.
  • the target data source may include a database or an offline file.
  • the target business data may be data in the database or data in an offline file uploaded by a user.
  • the electronic device may obtain the target business data from an associated target database, or may obtain an offline file in response to an upload operation and parse the offline file to obtain the target business data.
  • the target database may store a plurality of data, and the plurality of data may be processed data.
  • the data in the target database may be processed data.
  • the processed data may refer to the data processed by the ETL tool.
  • the target database may be an MDW database.
  • ETL can be used to describe the process of extracting, transforming, and loading data from a data source to a destination.
  • an electronic device can use an ETL tool to extract required data from different data sources (which can be production equipment), clean and transform the extracted data, and then load the cleaned and transformed data into a database.
  • the ETL tool can perform the function of ETL.
  • the ETL tool can be an application or a device that can perform this function, without limitation.
  • the electronic device can store the offline file, for example, in a database (such as a target database) or in a configured storage (such as a hard disk, memory, etc.).
  • a database such as a target database
  • a configured storage such as a hard disk, memory, etc.
  • the electronic device may determine a target data source in response to clicking on data source management.
  • the electronic device may obtain a first link indicating the target database, and establish a connection with the target database according to the first link.
  • the first link may be used to indicate the name, address, etc. of the target database.
  • the first link may be a link edited by the user in the input box of the data source.
  • the first link may include the name, identifier, number, etc. of the target database.
  • the electronic device may set the target data source as an offline file in response to the third configuration operation.
  • the offline file may include target business data.
  • the offline file may be a csv file.
  • the third configuration operation may be an operation of selecting the type of data source in the input box of the data source.
  • the target database may be an MDW database in the data layer.
  • the process of storing the target business data in the MDW database may include extracting the production data stored in the MES database into the ODS database, and extracting the data in the ODS database into the MDW according to the requirements.
  • the data extraction may include real-time data synchronization extraction and timed data extraction.
  • OGG+Kafka can be used for real-time data synchronization extraction.
  • ETL tools can be used for scheduled data extraction.
  • OGG+Kafka can refer to the existing technology and will not be described in detail.
  • ETL tools can refer to the description of ETL above and will not be described in detail.
  • the data layer including the MES database, the ODS database and the MDW database is taken as an example to illustrate the method of extracting data from the electronic device using the ETL tool.
  • the electronic device when the above-mentioned multiple databases are applied to the production system, the electronic device can use the ETL tool to extract the production data stored in the MES database, and then store it in the ODS database after processing. Then, the electronic device can continue to store the production data integrated by the ODS database in the MDW database through ETL and other methods, thereby completing the process of production data from production operation to data analysis.
  • the electronic device can communicate with multiple databases of the data layer.
  • the electronic device can monitor the storage status of multiple databases.
  • ETL tools may include Pentaho Kettle tools and data integration platform (Informatica PowerCenter) tools.
  • the Pentaho Kettle tool can be used to perform table input and table output extraction tasks.
  • the process may include: start task ⁇ task execution (including deleting task, executing task) ⁇ task success.
  • the electronic device Before starting a task, the electronic device can set a scheduled task.
  • the scheduled task can have a unique task name.
  • the scheduled task can be run in the form of a task table for database ETL scheduled scheduling.
  • the task table can be used for the content of database ETL scheduled scheduling.
  • FIG8 it is a schematic diagram of an operation process of the tool.
  • this is a setting interface of the tool.
  • the setting interface can be used to set the step name, database name (database connection), and input Structured Query Language (SQL).
  • SQL Structured Query Language
  • the setting interface can be used to set the task name, database name (database connection), SQL (SQL file name), SQL, etc. in the task table.
  • the task table may also include the time of data extraction for the task, the frequency of data extraction, and the status of the task.
  • the start time and end time of the task in the task table can be obtained from the task table.
  • the electronic device can extract data in the time period between the start time and the end time.
  • the electronic device can update the time, status, and other contents of the task table for the next execution of the scheduled task.
  • the electronic device when it performs data extraction, it can include two extraction methods: full extraction and incremental extraction.
  • the electronic device can set a scheduled task according to the amount of business data and real-time requirements of the task. For example, summary data can be extracted every hour, every day, or at a specified time period.
  • Informatica PowerCenter tool is a tool used to extract enterprise-level big data.
  • the PowerCenter Designer tool can choose to import tables from the database according to the settings, connect to the database to set the database driver and source configuration of the ODBC data source, and import the required source tables and target tables according to development requirements.
  • Informatica PowerCenter tools are also used to create mappings.
  • Informatica PowerCenter tools can respond to operations by moving source and target tables to the Mapping Designer workspace and linking fields.
  • the source SQ component in the Informatica PowerCenter tool can be used to write SQL for data extraction. If it is a scheduled ETL scheduling task, you need to create time parameters in Mapping and use parameter filtering in SQL to achieve incremental extraction.
  • the "Pre SQL” of the target component "Properties” of each Mapping in the Informatica PowerCenter tool can be used to configure time parameters and delete the corresponding interval data of the target table. In this way, duplicate data writing can be avoided.
  • the "Post SQL” of the target component "Properties” of each Mapping in the Informatica PowerCenter tool can be used to configure the field data update of the ETL task table.
  • the properties of each session of the Informatica PowerCenter tool can be used to configure the reading path of the parameter file.
  • the electronic device can save the mapping and generate a workflow.
  • the Informatica PowerCenter tool can perform session configuration in response to the user's first operation.
  • the first operation may include opening the Workflow Manager, dragging the created session into the Task Developer, editing the properties of the session, entering the parameter file address, configuring the connection information of the source and target, etc.
  • the Informatica PowerCenter tool can also create a workflow in response to the user's second operation.
  • the second operation may include opening the workflow designer, creating a workflow, linking "Start” in the workflow workspace with the dragged "session” that needs to be run, etc.
  • the Informatica PowerCenter tool can also run the workflow in response to a third operation by the user.
  • the third operation may include clicking "Start Workflow" to open the Workflow Monitor.
  • the Monitor can be used to display workflow, session execution status, log information, and data statistics.
  • the electronic device may also display log information in response to the user clicking on the "get session log” operation, so that the user can view specific error information.
  • S602 In response to the first operation, obtain a first component model, and configure the attribute information of the first component model to obtain a target component model.
  • the first operation may include a first selection operation or a first call operation.
  • the first selection operation may refer to an operation of selecting a component model that meets user needs from a plurality of component models.
  • the first call operation may refer to an operation of obtaining a program code for generating a first component model.
  • the first component model may be pre-configured for the electronic device, for example, it may be a component model in the component area in b of FIG. 2 (which may be referred to as a simple component model).
  • the first component model may also be a target model (which may be referred to as a complex component model) generated by the electronic device by calling and running a program code.
  • the electronic device may obtain a first component model from a plurality of component models pre-configured in the electronic device in response to a first selection operation.
  • the multiple component models may be multiple component models displayed in the component area.
  • the call operation may refer to an operation of dragging a component model in the component area to the component development area.
  • the first component model may be a component model in the component area.
  • the component model in the component area cannot meet the requirements, such as the component model in the component area does not exist in a certain data format. For example, there is no component model for displaying a time state diagram of the equipment utilization rate.
  • the electronic device can obtain a program code for generating a first component model in response to the first calling operation, and run the program code to obtain the first component model.
  • the electronic device may obtain program code for generating the first component model from the component development platform.
  • the equipment utilization rate refers to the component requirement to display the different utilization states of each production equipment in chronological order. Electronic equipment needs to obtain the start and end time of the production equipment in different states and arrange them in chronological order.
  • the attribute information of the first component model may include the position, size, margin, parameters, etc. of the first component model in the electronic signboard.
  • the parameters may be the line or pattern form of the component model.
  • the parameters of the discount bar chart may include the line color, line thickness, line virtuality, pattern fill color, pattern shape (such as histogram, cylinder chart, etc.) of the broken line bar chart.
  • the parameters of the coordinate axis may include the styles of the X-axis and the Y-axis (such as the shape of the arrow, the thickness and color of the line, etc.).
  • the electronic device in combination with the electronic billboard development page shown in b of FIG. 2 , can configure the attribute information of the component model in response to the setting operation of the attribute items in the configuration area to obtain the target component model.
  • the target business data is electricity data.
  • the electricity in the multiple time periods is displayed in the electronic kanban through a line graph.
  • the electronic device can display a multi-line graph in the component development area in response to a drag operation.
  • the name of the multi-line graph can be displayed in the layer area.
  • the electronic device can display the configuration information (attributes, data, interactions) of the multi-line graph in the configuration area in response to the operation of clicking on the multi-line graph in the development area.
  • the electronic device can adjust the attribute information of the multi-line graph (such as display position, margin, title, zoom ratio, etc.) in response to the adjustment operation of the attributes in the configuration area. In this way, the target component model corresponding to the electricity data can be obtained.
  • target business data is acquired from a target data source, and the target business data is associated with a target component model to obtain a target component.
  • the second operation may include a second configuration operation or a second upload operation.
  • the second configuration operation may refer to an operation of configuring a call code through an electronic kanban development page.
  • the second upload operation may refer to an operation of uploading an offline file.
  • the target component may be used to reflect the distribution of target business data.
  • the second configuration operation may be an operation of inputting SQL.
  • the second configuration operation may refer to an operation of inputting SQL through an input box under the data in the setting area.
  • the electronic device may obtain target data from the target database, and associate the component model with the target data to obtain the target component.
  • the second upload operation may refer to an operation of uploading an offline file.
  • the second upload operation may refer to an operation of uploading an offline file through an upload box under the data in the setting area.
  • the electronic device may display an upload page, which may be used to upload an offline file.
  • the electronic device may parse it to obtain the target business data, and associate the target business data with the target component model to obtain the target component.
  • the offline files can be encrypted files.
  • the electronic device can decrypt them according to the configured decryption key to obtain the target business data.
  • the electronic device can obtain user information. For example, in response to a login operation, the user can enter the user's account and password through the login interface. When it is determined that the user information has the authority to upload offline files, the electronic device can display an upload page. The upload page can be used to upload a csv file or an offline file. In response to the upload operation, the electronic device can obtain a csv file including target business data.
  • the csv file can be determined according to a file of a pre-model. That is, the electronic device can first output a file in a preset format for the user to fill in the business data according to the preset format of the file. After the user completes the filling, the csv file including the target business data can be uploaded through the upload page. After receiving the csv file, the electronic device can store the csv file in a database or other storage device.
  • the electronic device associating the target business data with the target component model may refer to configuring the target component model using the target business data as a configuration parameter.
  • the target component model is a grouped bar chart.
  • the horizontal axis of the grouped bar chart is the attribute name represented by each bar chart, and the vertical axis represents the data corresponding to the attribute.
  • the power data is the power consumption of multiple months.
  • the power data may be the data shown in Table 1.
  • the power data may include the power consumption of each month from January to June.
  • the attribute name of the power data is month, and the data corresponding to the attribute is the power consumption corresponding to each month.
  • the first component model is a bar chart.
  • the electronic device can, in response to the call operation, drag the grouped bar chart in the component area to the component development area.
  • the electronic device can display the name of the grouped bar chart in the layer area and display the attribute information (attributes, data, interaction) of the grouped bar chart in the setting area.
  • the electronic device responds to the modification operation by modifying the name of the grouped bar chart in the layer area (such as changing it to electricity consumption from January to June), and responds to the operation in the setting area by modifying the attribute information of the grouped bar chart (such as the number of bars, the month corresponding to each bar, the width of each bar, the fill color, the position of each bar on the X-axis, the numerical distribution on the Y-axis, etc.).
  • the electronic device responds to the operation of the SQL input in the input box under the data in the configuration area, and obtains the SQL.
  • the electronic device runs the SQL and can adjust the height of each bar in the grouped bar chart.
  • the value of the Y cycle corresponding to the height of the adjusted bar chart is the electricity consumption of the month.
  • the adjusted grouped bar chart i.e., the target component
  • the electronic device can parse the offline file to obtain target business data, and associate the target business data with a target component model to obtain a target component.
  • the target component model is a bulletin board
  • the electronic device after the electronic device obtains the target business data from the stored csv file, it can modify the name field of the bulletin board to the name of the target business data and display the target business data in the display box of the bulletin board, thus obtaining a bulletin board component.
  • the types of the multiple component models may be the same or different.
  • the electronic device may determine the component corresponding to each type of data respectively.
  • the electronic device may also set a hierarchical relationship or an associative relationship of components corresponding to the multiple types of data in response to an interactive operation.
  • the hierarchical relationship may refer to the hierarchical relationship of multiple components on the electronic signage.
  • the association relationship may refer to the order in which the electronic device displays multiple components. For example, component 1 is associated with component 2.
  • the electronic device may display component 2 in a pop-up window in response to a click on component 1 or a data in component 1.
  • the electronic device in combination with the electronic signage development page shown in b of FIG. 2 , can set the association relationship between the target component and other components in response to the interactive operation of clicking the configuration area.
  • the electronic device can determine the first component.
  • the method for determining the first component can refer to the method for determining the target component, which will not be described in detail.
  • the business data included in the first component is different from the data of the target component.
  • the type of the first component can be the same as or different from the type of the target component.
  • the electronic device can establish an association relationship between the target component and the first component in response to an association operation.
  • the association operation may refer to an operation in which a user establishes an association relationship between the target component and the first component through interaction with the configuration area in the electronic kanban development page shown in b of Figure 2.
  • the electronic device can set a hierarchical relationship between the first component and the target component in the interactive area.
  • the hierarchical relationship may refer to the display order of the target component and the first component.
  • the target component is located on the upper layer of the first component.
  • the electronic signage can display the target component after displaying the first component, and the display position of the target component is located above the first component.
  • the target component can cover the first component or cover part of the first component.
  • S604 The electronic device displays the target component on the electronic signboard.
  • the electronic device may display the target component in an electronic signboard, or the electronic device may display an electronic signboard, which may include the target component.
  • the electronic signboard may also be provided with other components.
  • the electronic device may display an electronic board including a target component in response to a click-to-publish operation.
  • the electronic device can generate a preview page of the electronic kanban in response to a click preview operation. Based on the preview page, the user can view whether the electronic kanban meets the requirements. In the case where the electronic kanban does not meet the requirements or has problems, the electronic device can continue to adjust the components in the electronic kanban in response to the adjustment operation until an electronic kanban that meets the user's requirements is obtained.
  • the electronic device can also dynamically update the electronic dashboard. For example, for dynamically changing production data, the electronic device can obtain updated production data from the target database according to a preset period, and adjust the components used to represent the distribution of the production data according to the updated production data, so that the adjusted components can reflect the distribution of the updated production data.
  • the electronic device can adjust the field of the component model used to generate the component, and the adjusted component model includes a bar chart corresponding to July.
  • the electronic device can generate a new component based on the adjusted component model and the updated power consumption.
  • the electronic device can directly adjust the component, for example, add a bar graph corresponding to July to the component in FIG10, and the bar graph is located after June, and the bar graph of July is adjusted to a corresponding height according to the value of the ordinate. In this way, the electronic device can obtain a new component.
  • the electronic device displays the target component and the first component according to the association relationship. For example, when a field of the target component is clicked, the first component may be displayed.
  • the electronic device may determine the display order and display position of the target component and the first component according to the hierarchical relationship.
  • the electronic signage may further include more components.
  • a bulletin board may be included.
  • the bulletin board may be used to display the content of offline files.
  • the multiple components may be displayed on the electronic signage dynamically or statically.
  • the electronic device may send the electronic billboard to other display devices for display. For example, corresponding to the production data of a production workshop, the electronic device may send the production data to the display device of the production workshop. After receiving the electronic billboard from the electronic device, the display device of the production workshop may display the electronic billboard.
  • the electronic device can also configure the display effect of the electronic billboard.
  • the electronic device can determine the background color, pattern, etc. of the electronic billboard according to the background configuration operation.
  • the electronic device can also determine the dynamic display effect of the electronic billboard according to the animation configuration operation.
  • the electronic device can also determine the voice of the electronic billboard according to the voice configuration operation.
  • the electronic device can, in response to the user's operation, call a component model that meets the requirements from a plurality of pre-configured component models. Then, the electronic device can adjust the attribute information of the component model to obtain the target component model, and then, the electronic device can associate the target business data with the target component model in response to the user's association operation to obtain the target component. Finally, the electronic device can display the target component in the electronic billboard. That is, with the technical solution provided in the embodiment of the present application, the user only needs simple operations to realize the development of components, and the user does not need code development foundation and experience, which reduces the difficulty of developing electronic billboards.
  • the electronic device in order to avoid the situation where there is no component model that meets the requirements in the component area, the electronic device can call the code to realize the development of the component model.
  • the development platform may be configured with development tools.
  • the development tools may be used to develop components.
  • the development tools may include primary development tools (such as Maven, Eclipse, STS, IDEA) and auxiliary development tools (such as GIT for version control, Postman for debugging interface data, Sourcetree for code management, DBeaver for testing SQL).
  • primary development tools such as Maven, Eclipse, STS, IDEA
  • auxiliary development tools such as GIT for version control, Postman for debugging interface data, Sourcetree for code management, DBeaver for testing SQL).
  • the development process of the component model may include:
  • Interface development - dao The service calls the dao layer method to operate the database query, mainly annotating the corresponding dao with @Mapper and @Component.
  • Controller Users can determine the link to be accessed based on the business, and splice the path through request mapping + GET (POST) mapping.
  • variable parameter of the address bar of fac in getInPutByMonth (String fac) is obtained according to the month.
  • the variable parameter may need to be added or modified.
  • Extensible Markup Language (xml) file - sql Extensible Markup Language (xml) file - sql.
  • the identity document (id) in xml corresponds to a method of dao. Among them, xml has a unique id. The parameters of the page and method are replaced here.
  • the code is pulled and submitted using Sourcetree.
  • the code can be released using Jenkins. After the local code is packaged and uploaded, the script can be executed to achieve independent deployment.
  • Example 1 The target business data is chart data.
  • the electronic device can establish a connection with the database in response to the configuration operation, and obtain SQL through the electronic board development page to obtain data from the database. Finally, the electronic device uses the obtained data according to the fields of the chart component to implement the development of the chart component on the development page.
  • the electronic device can implement the development of an electronic dashboard including a chart component through the following process.
  • the electronic device in response to an operation on the data source management interface of the electronic signage, the electronic device may establish a connection with the database.
  • the electronic device may also configure information such as the name, type, data source address, port number, database name, user name and password of the data source.
  • the electronic device may configure the attribute information of the component model in the component development area.
  • the electronic device obtains SQL, obtains data from the data source according to the SQL, and configures the data into the component model.
  • the electronic device may associate multiple components.
  • control the display and hiding of components the interaction between the parameter query conditions of the drop-down box component and the chart results.
  • Example 2 Data source management of offline table data.
  • the electronic device can configure the csv file in the data source management and assign user permissions.
  • the data source uses the csv file and configures the data field on the component.
  • the csv file can be an encrypted file.
  • the electronic device moves the table component to the component development area, and adjusts the location, size and other attribute information of the table component model according to the configuration, and associates the target business data with the table component model to obtain the target component (that is, including the table component).
  • the column key of the table group is the column name of the csv file.
  • the electronic device may display the effect of the table component in response to the preview operation. If the table component meets the requirements, the electronic device may publish the table component. That is, the electronic device displays the table component on the electronic signage.
  • Example 3 File import and interface display of the bulletin board.
  • offline files uploaded by multiple users do not set user permissions, and the general function of file uploading is implemented through background code.
  • the offline file is a file determined according to a pre-set template.
  • the electronic device can input a file of a preset template.
  • the fields of the file are preset fields, and based on the file, the user can modify and fill in the business data.
  • the electronic device may obtain the offline file and include it in the database during analysis.
  • the offline file may be an encrypted file.
  • the electronic device can display the uploaded file content in response to a refresh operation.
  • the embodiment of the present application can divide the determination device into functional modules or functional units according to the above method example.
  • each functional module or functional unit can be divided corresponding to each function, or two or more functions can be integrated into one processing module.
  • the above integrated module can be implemented in the form of hardware or in the form of software functional modules or functional units.
  • the division of modules or units in the embodiment of the present application is schematic, which is only a logical function division. There may be other division methods in actual implementation.
  • FIG14 it is a schematic diagram of the structure of a device for determining an electronic billboard provided in an embodiment of the present application, and the device is applied to an electronic device.
  • the electronic device is used to determine an electronic billboard.
  • the device comprises: a determining unit 1401 , an acquiring unit 1402 , and a display unit 1403 .
  • the determining unit 1401 is configured to: determine a target data source for acquiring target business data.
  • the acquisition unit 1402 is configured to: in response to the first operation, acquire the first component model, and configure the attribute information of the first component model to obtain the target component model.
  • the acquisition unit 1402 is further configured to: in response to the second operation, acquire target business data from the target data source, and associate the target business data with the target component model to obtain a target component for reflecting the distribution of the target business data.
  • the display unit 1403 is used to display the target component in the electronic signage.
  • the target data source includes a target database or an offline file
  • the second operation is a second configuration operation or a second upload operation
  • the acquisition unit 1402 is specifically configured to: in response to the second configuration operation, obtain target business data from a target database associated with the electronic device; or, in response to the second upload operation, obtain an offline file, and parse the offline file to obtain the target business data.
  • the device further includes a processing unit 1404, the target data source includes a target database or an offline file, and the acquisition unit 1402 is further configured to: acquire a first link indicating the target database.
  • the processing unit 1404 is configured to: establish a connection with the target database according to the first link.
  • the target data source is an offline file
  • the processing unit 1404 is configured to: in response to the third configuration operation, set the target data source to an offline file.
  • the first operation includes a first selection operation or a first call operation
  • the acquisition unit 1402 is specifically configured to: in response to the first selection operation, acquire the first component model from multiple component models pre-configured in the electronic device; or, in response to the first call operation, acquire program code for generating the first component model, and run the program code to obtain the first component model.
  • the target database stores multiple data; the multiple data are data processed from original data using preset tools, and the multiple data include target business data.
  • processing the raw data using a preset tool refers to performing ETL processing on the raw data.
  • the acquisition unit 1402 is further configured to: acquire user information including a user account and a corresponding password; if the user information has the permission to upload offline files, display a csv file for uploading, the csv file includes the target business data.
  • the acquisition unit is further configured to: acquire the csv file through the upload page, and acquire the target business data from the csv.
  • the method further includes: receiving and storing a plurality of offline files determined according to a preset file template; and displaying information of the plurality of offline files through an electronic signboard.
  • the determination unit 1401 is further configured to: determine a first component for reflecting the distribution of the first business data; and in response to a third operation, establish an association relationship between the target component and the first component.
  • the display unit 1403 is specifically configured to: display the target component and the first component in the electronic signboard according to the association relationship between the target component and the first component.
  • the acquisition unit 1402 in the embodiment of the present application may be integrated on a communication interface, and the determination unit 1401 and the processing unit 1404 may be integrated on a processor.
  • FIG15 shows a schematic diagram of the structure of another possible communication device of the determination device involved in the above embodiment.
  • the communication device includes: a processor 1502 and a communication interface 1503.
  • the processor 1502 is used to control and manage the actions of the device, for example, to execute the steps performed by the above determination unit 1401 and the processing unit 1404, and/or to execute other processes of the technology described herein.
  • the communication interface 1503 is used to support the communication between the device and other network entities, for example, to execute the steps performed by the above acquisition unit 1402.
  • the device may also include a memory 1501 and a bus 1504, and the memory 1501 is used to store program codes and data of the device.
  • the memory 1501 can be a memory in the device, etc., and the memory can include a volatile memory, such as a random access memory; the memory can also include a non-volatile memory, such as a read-only memory, a flash memory, a hard disk or a solid-state drive; the memory can also include a combination of the above types of memory.
  • a volatile memory such as a random access memory
  • the memory can also include a non-volatile memory, such as a read-only memory, a flash memory, a hard disk or a solid-state drive
  • the memory can also include a combination of the above types of memory.
  • the processor 1502 may be a processor that implements or executes various exemplary logic blocks, modules, and circuits described in conjunction with the disclosure of the present application.
  • the processor may be a central processing unit, a general-purpose processor, a digital signal processor, an application-specific integrated circuit, a field programmable gate array, or other programmable logic devices, transistor logic devices, hardware components, or any combination thereof.
  • the processor may implement or execute various exemplary logic blocks, modules, and circuits described in conjunction with the disclosure of the present application.
  • the processor may also be a combination that implements computing functions, such as a combination of one or more microprocessors, a combination of a DSP and a microprocessor, and the like.
  • the bus 1504 may be an Extended Industry Standard Architecture (EISA) bus, etc.
  • EISA Extended Industry Standard Architecture
  • the bus 1504 may be divided into an address bus, a data bus, a control bus, etc.
  • FIG15 is represented by only one thick line, but it does not mean that there is only one bus or one type of bus.
  • the device in FIG15 may also be a chip, which includes one or more (including two) processors 1502 and a communication interface 1503 .
  • the chip further includes a memory 1501, which may include a read-only memory and a random access memory, and provides operation instructions and data to the processor 1502.
  • a portion of the memory 1501 may also include a non-volatile random access memory (NVRAM).
  • NVRAM non-volatile random access memory
  • the memory 1501 stores the following elements, execution modules or data structures, or a subset thereof, or an extended set thereof.
  • the corresponding operation is performed by calling the operation instruction stored in the memory 1501 (the operation instruction may be stored in the operating system).
  • Some embodiments of the present disclosure provide a computer-readable storage medium (e.g., a non-transitory computer-readable storage medium) having computer program instructions stored therein.
  • a computer e.g., an electronic device
  • the computer executes the method for determining an electronic textbook as described in any of the above embodiments.
  • the above-mentioned computer-readable storage media may include, but are not limited to: magnetic storage devices (e.g., hard disks, floppy disks or magnetic tapes, etc.), optical disks (e.g., CD (Compact Disk), DVD (Digital Versatile Disk), etc.), smart cards and flash memory devices (e.g., EPROM (Erasable Programmable Read-Only Memory), cards, sticks or key drives, etc.).
  • the various computer-readable storage media described in the present disclosure may represent one or more devices and/or other machine-readable storage media for storing information.
  • the term "machine-readable storage medium" may include, but is not limited to, wireless channels and various other media capable of storing, containing and/or carrying instructions and/or data.
  • Some embodiments of the present disclosure also provide a computer program product, for example, the computer program product is stored on a non-transitory computer-readable storage medium.
  • the computer program product includes computer program instructions, and when the computer program instructions are executed on a computer (for example, an electronic device), the computer program instructions cause the computer to execute the method for determining an electronic textbook as described in the above embodiments.
  • Some embodiments of the present disclosure further provide a computer program.
  • the computer program When the computer program is executed on a computer (eg, an electronic device), the computer program enables the computer to execute the method for determining an electronic textbook as described in the above embodiments.
  • the disclosed systems, devices and methods can be implemented in other ways.
  • the device embodiments described above are only schematic.
  • the division of the units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed.
  • Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be through some interfaces, indirect coupling or communication connection of devices or units, which can be electrical, mechanical or other forms.
  • the units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
  • each functional unit in each embodiment of the present application may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit.

Landscapes

  • Engineering & Computer Science (AREA)
  • Software Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Human Computer Interaction (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

一种电子看板的确定方法，应用于确定电子看板的电子设备。该方法包括：确定用于获取目标业务数据的目标数据源。响应于第一操作，获取第一组件模型，并对第一组件模型的属性信息进行配置，得到目标组件模型。响应于第二操作，从目标数据源获取目标业务数据，并将目标业务数据与目标组件模型关联，得到目标组件。在电子看板中显示目标组件。

Description

电子看板的确定方法及装置 技术领域
本公开涉及数据处理技术领域，尤其涉及一种电子看板的确定方法及装置。
背景技术
随着技术的不断发展，电子看板逐渐得到广泛应用。比如，在制造业领域，电子看板可以根据用户的需求，通过可视化以报表的方式展示生产数据的数据分析结果，以便于用户或管理人员可以基于该数据分析结果及时了解当前的生产情况。
现有的各类电子看板，用户可以通过电子看板配置的软件工具，制作需要展示的电子看板。但是，电子看板的开发操作需要有一定的代码开发基础和经验，增加了电子看板的开发难度。
发明内容
一方面，提供一种电子看板的确定方法。应用于电子设备，所述电子设备用于管理电子看板，该方法包括：确定用于获取目标业务数据的目标数据源；响应于第一操作，获取第一组件模型，并对第一组件模型的属性信息进行配置，得到目标组件模型。响应于第二操作，从目标数据源获取目标业务数据，并将目标业务数据与目标组件模型进行关联，得到用于反映目标业务数据的分布情况的目标组件。在电子看板中显示该目标组件。
在一些实施例中，目标数据源包括目标数据库或离线文件，第二操作为第二配置操作或第二上传操作，上述“响应于第二操作，从目标数据源获取目标业务数据”的方法具体包括：响应于第二配置操作，从与电子设备关联的目标数据库中获取目标业务数据；或者，响应于第二上传操作，获取离线文件，并所述离线文件进行解析，获取所述目标业务数据。
在一些实施例中，目标数据源为目标数据库，该方法包括：获取用于指示目标数据库的第一链接，并根据第一链接，建立与目标数据库之间的连接。
在一些实施例中，目标数据源为离线文件，该方法还包括：响应于第三配置操作，将目标数据源设置为离线文件。
在一些实施例中，第一操作包括第一选择操作或第一调用操作，上述“响应于第一操作，获取第一组件模型”的方法具体包括：响应于第一选择操作， 从电子设备预先配置的多个组件模型中获取第一组件模型；或者，响应于第一调用操作，获取用于生成第一组件模型的程序代码，并运行程序代码，得到第一组件模型。
在一些实施例中，目标数据库存储有多个数据；多个数据为使用预设工具对原始数据进行处理后的数据，多个数据包括目标业务数据。
在一些实施例中，使用预设工具对原始数据进行处理是指原始数据进行抽取-转换-加载(extract-transform-load，ETL)处理。
在一些实施例中，该方法还包括：获取包括用户的账号及对应的密码的用户信息；在用户信息具有上传离线文件的权限的情况下，显示用于上传逗号分隔值(comma-separated values，csv)文件，csv文件包括目标业务数据。上述“从目标数据源获取所述目标业务数据”的方法具体包括：通过上传页面获取csv文件，并从csv中获取目标业务数据。
在一些实施例中，该方法还包括：接收并存储多个根据预设文件模板确定的离线文件；通过电子看板显示多个离线文件的信息。
一些实施例中，该方法还包括：确定用于反映第一业务数据的分布情况的第一组件；响应于第三操作，建立目标组件与第一组件之间的关联关系。上述“在电子看板中显示目标组件”的方法具体包括：根据目标组件与第一组件之间的关联关系，在所述电子看板中显示目标组件和第一组件。
另一方面，提供一种电子看板的确定装置。应用于电子设备。该电子设备用于确定电子看板。该处理装置包括：确定单元、获取单元和处理单元。
确定单元，被配置为：确定用于获取目标业务数据的目标数据源。
获取单元，被配置为：响应于第一操作，获取第一组件模型，并对第一组件模型的属性信息进行配置，得到目标组件模型。
获取单元，还被配置为：响应于第二操作，从目标数据源获取目标业务数据，并将目标业务数据与目标组件模型进行关联，得到用于反映目标业务数据的分布情况的目标组件。
显示单元，用于在电子看板中显示该目标组件。
在一些实施例中，目标数据源包括目标数据库或离线文件，第二操作为第二配置操作或第二上传操作，获取单元，具体被配置为：响应于第二配置操作，从与电子设备关联的目标数据库中获取目标业务数据；或者，响应于第二上传操作，获取离线文件，并所述离线文件进行解析，获取所述目标业务数据。
在一些实施例中，该装置还包括处理单元，目标数据源包括目标数据库 或离线文件，获取单元，还被配置为：获取用于指示目标数据库的第一链接。处理单元，被配置为：根据第一链接，建立与目标数据库之间的连接。
在一些实施例中，目标数据源为离线文件，处理单元，被配置为：响应于第三配置操作，将目标数据源设置为离线文件。
在一些实施例中，第一操作包括第一选择操作或第一调用操作，获取单元，具体被配置为：响应于第一选择操作，从电子设备预先配置的多个组件模型中获取第一组件模型；或者，响应于第一调用操作，获取用于生成第一组件模型的程序代码，并运行程序代码，得到第一组件模型。
在一些实施例中，目标数据库存储有多个数据；多个数据为使用预设工具对原始数据进行处理后的数据，多个数据包括目标业务数据。
在一些实施例中，使用预设工具对原始数据进行处理是指原始数据进行抽取-转换-加载(extract-transform-load，ETL)处理。
在一些实施例中，获取单元，还被配置为：获取包括用户的账号及对应的密码的用户信息；在用户信息具有上传离线文件的权限的情况下，显示用于上传csv文件，csv文件包括目标业务数据。获取单元，还被配置为：通过上传页面获取csv文件，并从csv中获取目标业务数据。
在一些实施例中，该方法还包括：接收并存储多个根据预设文件模板确定的离线文件；通过电子看板显示多个离线文件的信息。
一些实施例中，确定单元，还被配置为：确定用于反映第一业务数据的分布情况的第一组件；响应于第三操作，建立目标组件与第一组件之间的关联关系。显示单元，具体被配置为：根据目标组件与第一组件之间的关联关系，在所述电子看板中显示目标组件和第一组件。
又一方面，提供一种电子看板的确定装置，包括处理器和通信接口。通信接口和处理器耦合。处理器用于运行计算机程序或指令，以实现第一方面或第一方面任一实施例的确定方法。
再一方面，提供一种计算机可读存储介质。所述计算机可读存储介质存储有计算机程序指令，所述计算机程序指令在计算机(例如，电子设备)上运行时，使得所述计算机执行如上述任一实施例所述的确定方法。
又一方面，提供一种计算机程序产品。所述计算机程序产品包括计算机程序指令，在计算机(例如，电子设备)上执行所述计算机程序指令时，所述计算机程序指令使计算机执行如上述任一实施例所述的确定方法。
又一方面，提供一种计算机程序。当所述计算机程序在计算机(例如，电子设备)上执行时，所述计算机程序使计算机执行如上述任一实施例所述 的确定方法。
附图说明
为了更清楚地说明本公开中的技术方案，下面将对本公开一些实施例中所需要使用的附图作简单地介绍，显而易见地，下面描述中的附图仅仅是本公开的一些实施例的附图，对于本领域普通技术人员来讲，还可以根据这些附图获得其他的附图。此外，以下描述中的附图可以视作示意图，并非对本公开实施例所涉及的产品的实际尺寸、方法的实际流程、信号的实际时序等的限制。
图1为根据一些实施例的一种电子看板开发***的结构图；
图2为根据一些实施例的一种电子看板开发页面的示意图；
图3为根据一些实施例的一种用户需求信息的示意图；
图4为根据一些实施例的一种电子看板开发***的结构图；
图5为根据一些实施例的一种电子设备的结构示意图；
图6为根据一些实施例的一种电子看板的确定方法的流程图；
图7为根据一些实施例一种任务执行的流程示例图；
图8为根据一些实施例的一种任务抽取的流程示意图；
图9为根据一些实施例的一种任务抽取的示意图；
图10为根据一些实施例的一种组件的示意图；
图11为根据一些实施例的一种电子看板开发页面的示意图；
图12为根据一些实施例的另一种电子看板开发页面的示意图；
图13为根据一些实施例的另一种电子看板开发页面的示意图；
图14为根据一些实施例的一种电子看板的确定装置的结构示意图；
图15为根据一些实施例的一种电子看板的确定装置的结构示意图。
具体实施方式
下面将结合附图，对本公开一些实施例中的技术方案进行清楚、完整地描述，显然，所描述的实施例仅仅是本公开一部分实施例，而不是全部的实施例。基于本公开所提供的实施例，本领域普通技术人员所获得的所有其他实施例，都属于本公开保护的范围。
除非上下文另有要求，否则，在整个说明书和权利要求书中，术语“包括(comprise)”及其其他形式例如第三人称单数形式“包括(comprises)”和现在分词形式“包括(comprising)”被解释为开放、包含的意思，即为“包含，但不限于”。在说明书的描述中，术语“一个实施例(one embodiment)”、“一些实施例(some embodiments)”、“示例性实施例(exemplary  embodiments)”、“示例(example)”、“特定示例(specific example)”或“一些示例(some examples)”等旨在表明与该实施例或示例相关的特定特征、结构、材料或特性包括在本公开的至少一个实施例或示例中。上述术语的示意性表示不一定是指同一实施例或示例。此外，所述的特定特征、结构、材料或特点可以以任何适当方式包括在任何一个或多个实施例或示例中。
以下，术语“第一”、“第二”仅用于描述目的，而不能理解为指示或暗示相对重要性或者隐含指明所指示的技术特征的数量。由此，限定有“第一”、“第二”的特征可以明示或者隐含地包括一个或者更多个该特征。在本公开实施例的描述中，除非另有说明，“多个”的含义是两个或两个以上。
在描述一些实施例时，可能使用了“耦接”和“连接”及其衍伸的表达。例如，描述一些实施例时可能使用了术语“连接”以表明两个或两个以上部件彼此间有直接物理接触或电接触。又如，描述一些实施例时可能使用了术语“耦接”以表明两个或两个以上部件有直接物理接触或电接触。然而，术语“耦接”或“通信耦合(communicatively coupled)”也可能指两个或两个以上部件彼此间并无直接接触，但仍彼此协作或相互作用。这里所公开的实施例并不必然限制于本文内容。
“A、B和C中的至少一个”与“A、B或C中的至少一个”具有相同含义，均包括以下A、B和C的组合：仅A，仅B，仅C，A和B的组合，A和C的组合，B和C的组合，及A、B和C的组合。
“A和/或B”，包括以下三种组合：仅A，仅B，及A和B的组合。
如本文中所使用，根据上下文，术语“如果”任选地被解释为意思是“当……时”或“在……时”或“响应于确定”或“响应于检测到”。类似地，根据上下文，短语“如果确定……”或“如果检测到[所陈述的条件或事件]”任选地被解释为是指“在确定……时”或“响应于确定……”或“在检测到[所陈述的条件或事件]时”或“响应于检测到[所陈述的条件或事件]”。
本文中“适用于”或“被配置为”的使用意味着开放和包容性的语言，其不排除适用于或被配置为执行额外任务或步骤的设备。
另外，“基于”的使用意味着开放和包容性，因为“基于”一个或多个所述条件或值的过程、步骤、计算或其他动作在实践中可以基于额外条件或超出所述的值。
以下，对本申请实施例涉及的名词进行解释，以方便读者理解。
电子看板：也可以称为电子数据看板、电子数据报表，是数据可视化的显示方式，广泛应用于制造工厂的生产和管理中。电子数据看板可以根据用 户的具体应用场景的需求，将数据分析结果以可视化的方式展示。例如，电子数据看板的内容可以包括多个组件。组件与数据相关。例如，组件的类型可以包括表格类组件、图像类组件(如柱状图、线条图等)、公告类型组件(如公告栏、通知栏等)。电子看板还可以实时更新数据，以便于用户对产品的生产进行了解和分析。例如，电子设备可以通过表格、树状图、组件、线条图等形式，形象的展示数据分析结果。
一种示例中，电子数据看板可以应用过程可以包括数据的采集、数据的处理和存储、数据的可视化展示(或者组件的可视化展示)。后续实施例对该应用过程进行详细说明，此处不予赘述。
一种可能的实现方式中，电子数据看板可以设置有软件工具(如TIBCO Spotfire、FineReport等)。但是，这些软件的使用人员需要具有代码开发基础和经验，也即，对用户的要求较高，提高使用基础。进而，增加了电子数据看板的开发难度。因此，如此设计一套开发难度低，用以扩大电子数据看板的应用场景成为亟待解决的技术问题。
一种实施例中，如图1所示，为本申请实施例提供的一种电子看板***。该***可以包括框架层、数据层、服务层和应用层。下面分别对框架层、数据层、服务层以及应用层进行说明。
一、框架层。
框架层可以与云平台进行联通，例如，框架层可以通过云平台进行业务处理。框架层可以包括终端、硬件资源、虚拟化平台和虚拟桌面。框架层可以用于安全维护(如文档保护和行为管理)以及管理虚拟桌面、硬件资源等。框架层可以包括前端框架和后端框架。
其中，前端框架可以使用Vue框架或Angular框架，实现可视化以及数据与结构的分离。
后端框架可以使用Spring Boot框架或Spring模型视图控制层(Model Views Controller，MVC)框架或Mybatis框架。其中，Spring MVC是一种软件设计规范，可以通过业务逻辑、数据、显示分离的方法来组织代码。
其中，模型(Model)：数据模型，提供要展示的数据，因此包含数据和行为，就是Dao层和Service层。
视图(View)，用于负责进行模型的展示，一般就是我们见到的用户界面，客户想看到的东西。
控制器(Controller)：接收包括数据的用户请求，并将数据输入预设模型进行处理(状态改变)得到对应的数据处理结果；将数据处理结果返回给视图， 用于视图进行显示。
SpringMVC的特点：轻量级、简单易学；高效、基于请求响应的MVC框架；与Spring兼容性好，无缝结合；约定优于配置；功能强大。Spring的web框架围绕DispatcherServlet(调度Servlet)设计。
二、数据层。
数据层用于实现对设备端(或者数据源)的数据采集以及管理数据库。
其中，数据采集可以通过上述ETL工具。数据库的类型可以包括oracle、MySQL、postgerSQL等。
该数据层可以包括制造执行***(manufacturing execution system，MES)数据库、操作数据层(operational data store，ODS)数据库、制造数据仓库(manufacturing data warehouse，MDW)数据库。
其中，MES数据库可以与生产设备联通。MES数据库可以用于存储生产设备的制造数据，比如产品数量、产品合格率、生产效率等。
需要说明的是，为了保证数据的安全性和可靠性，MES数据库可以设置有权限或者保护措施。也即，MES数据库在操作人员没有权限的情况下，无法对存储的数据进行增加、删除、修改、查询等操作。
ODS数据库可以用于存储原始数据。ODS数据库中的数据与源***制造的数据一致。例如，ODS数据可以从MES数据库中抽取数据并进行存储。汇总、存储、分析生产制造过程中的数据。也即，ODS数据库可以备份MES数据库中的数据。如此，可以避免当MES数据库出现数据丢失、数据被篡改时，导致数据异常的问题。另外，由于ODS数据库中的数据无法进行增加、删除、修改、查询，因此，若MES数据库和MDW数据库直接连接，则可能会使得数据在进入MDW数据库时，仍然是没有经处理的数据，从而导致后续在从MDW数据库中获取数据时，出现数据杂乱的问题，因此，通过在MES数据库和MDW数据库之间设置ODS数据库，可以现在ODS数据库中对数据进行汇总和分析，再将汇总和分析后的数据存储至MDW数据库中，可以使得MEW数据库中存储的数据为汇总和分析好的数据，可以便于后续在电子看板生成组件时能够快速的查询到关联的数据。
MDW数据库，用于汇总、存储、分析生产制造过程中的数据。也即，MDW数据库可以响应于用户的操作，对数据进行整理、汇总，得到多个类型的数据表。该数据表中的数据可以用于后续的数据源和数据基础。
三、服务层。
服务层主要用于管理功能接口、数据源、组件的开发、用户信息等。
其中，数据源可以包括数据库和CSV文件。用户信息可以包括用户的权限以及用户的账号信息(如账号和密码等)。组件的开发的编程语言可以为java、SQL等。
服务层还可以实现提供通讯服务。例如，服务层可以采用传输控制协议/网际协议(transmission control protocol/internet protocol，TCP/IP)。设备端到数据库通讯可以采用高速消息服务(high speed message services，HSMS)、Tibco、文件传输协议(file transfer protocol，FTP)等。
一种示例中，服务层可以设置有开发页面。基于该开发页面可以实现服务层的上述功能。
例如，如图2的a所示，为本申请实施例提供的一种开发页面。该开发页面可以包括大屏开发、数据源管理、决策平台管理、用户管理、角色管理、***设置。
其中，大屏开发可以响应于开发人员的操作，对电子看板进行管理。例如，该操作可以包括新建、编辑、预览、复制、下载、发布、删除电子看板等操作。
数据源管理可以响应于开发人员的操作，管理数据源。比如，建立与数据库之间的连接、编辑与数据库之间的连接(如修改关联数据库的链接等)、管理CSV文件等。
决策平台管理可以响应于开发人员的输入的策略，管理电子看板。比如，可以确定显示电子看板的电子设备、电子看板显示的时长等。
用户管理可以用于管理用户的信息。比如，可以用于管理用户的账号和权限。
角色管理可以用于配置用户的权限。不同的用户可以配置不同的权限。该权限可以包括是否可以上传离线文件、是否可以修改电子看板等。
***设置可以用于设置电子看板的通用功能。比如，可以设置电子看板的标题展示效果等。
又一种示例中，如图2的b所示，为本申请实施例提供的一种电子看板开发页面。该电子看板开发页面可以为电子设备响应于点击图2的a中的“大屏开发”的操作显示的页面。该电子看板开发页面可以用于开发组件。
如图2的b所示，该电子看板开发页面可以包括多个区域，每个区域对应不同的功能。比如，该多个区域可以包括组件区域、图层区域、开发区域、配置区域、交互区域、控制区域。下面分别对这些区域的功能进行说明。
1、组件区域。组件区域可以用于显示多个组件模型。例如，该组件模型 可以包括图标组件、文本组件等。
一种示例中，电子设备可以响应于对组件区域中的多个组件模型的拖拽操作，在开发区域显示该组件模型，并在图层区域显示该组件模型的名称。
2、图层区域。图层区域可以用于对开发区域中的组件进行管理。例如，当开发区域中的组件被选中或被点击时，图层区域可以展示该组件的信息。图层区域可以响应于操作，对组件进行重命名、组件的层级关系进行排序、复制组件、删除组件等。
3、开发区域。开发区域可以用于显示组件模型/组件的样式。开发区域还可以对组件模型进行修改、配置。
4、配置区域。配置区域可以用于对组件进行配置。例如，可以修改组件的属性(对应图中的属性)、组件的数据(对应图中的数据)以及组件之间的交互(对应图中的交互)等。不同组件展示的具体内容不同，组件展示的内容可以通过配置区域进行设置。
其中，属性主要用于设置组件在电子看板的位置、大小、组件的样式属性、配置的数据等。
数据，主要用于设置数据源类型、组件自身的数据和数据格式、API调用后台接口、CSV文件使用导入的数据源等。
一种示例中，电子看板可以通过SQL从数据库中获取数据，并将该数据与组件进行关联。比如，配置区域中数据下可以设置有输入框，该输入框可以用于输入SQL。
交互，主要用于根据组件的功能进行设置。
5、交互区域。交互区域可以管理组件区域、图层区域、配置区域。例如，交互区域可以设置有组件收取、图层收取、配置收取等按钮。响应于点击按钮的操作，电子看板开发页面可以收起或展开按钮对应的区域。例如，在电子看板开发页面显示组件区域时，响应于点击组件收起可以不显示组件区域。接着，响应于再次点击组件收取，电子开发页面可以重新显示组件区域。
进一步的，交互区域还可以用于实现多个组件之间的交互。例如，电子设备在获取到的目标业务数据包括筛选条件(产品名称、生产时间)，也即，电子设备可以通过折线柱状图将该数据动态的展示。比如，电子设备可以响应于用户在交互区域的关联操作，将筛选框和折线柱状图关联。也即，当电子看板显示筛选框之后，可以自动显示筛选框中产品名称对应的折线柱状图。该折线柱状图可以有产品名称以及对应的生产时间构成(如横轴为产品名称，纵轴为生产时间)。
6、控制区域。控制区域可以用于对电子开发页面的内容进行管理。该控制区域可以设置有返回、预览、发布等按钮。其中，响应于点击返回，电子设备可以返回到图2的a所示的页面。响应于点击预览，电子设备可以显示预览页面。该预览页面可以显示开发区域的组件。响应于点击发布，电子设备可以显示是否确定发布的窗口。
四、应用层。
应用层可以用于管理电子看板的应用场景。例如，应用层可以通过开发工具实现电子看板的开发和管理。开发工具可以参照后续的描述，此处不予赘述。
例如，如图3所示，对于制造业工厂，制造业工厂的实际业务需求可以包括人(如工厂园区管理、厂商管理、员工管理等)、机(如设备报警处理、设备保养和备件管理、设备生成状态管理、设备稼动监控等)、料(如成品管理、库房库位管理、原材管理等)、法(如生产计划和实绩、销售计划和实绩、SPC***、异发通管理等)、环(如水电气稳定性、水电气用量、绿色产品管理等)、测(如不良分析、良率日报、制程控制、OQA出货检查等)、制(如投入、产出、报废、控制(hold)、等等(etcetera，ETC)out、在制品(work in progress，WIP)、移动(Movement)等)等多个方面的用户需求。相应的，电子看板可以根据用户的需求，设置应用场景以及显示该应用场景对应类型的组件。例如，文本框、下拉框、折线柱状图、表格、饼图、雷达图等组件。
其中，hold可以是指因为产品存在风险，滞留在当前站点。Movement可以是指站点在一段时间内产出的产品数量。WIP是指当前正在生产的产品、已投入且未报废、产出的产品均为在制品。ETC out是指其他用途领用。例如，因为分析验证，需要申请将产品领出生产线。
下面将结合说明书附图，对本申请实施例的实施方式进行详细描述。
如图4所示，为本申请实施例提供的一种电子看板开发***，该***可以包括数据源、组件开发平台、电子看板开发平台。组件开发平台与电子看板开发平台连接。比如，组件开发平台可以设置有功能接口。该功能接口可以与电子看板开发平台连接。
其中，数据源是电子看板开发***的数据来源和基础。该数据源可以与数据库连接。该数据库可以存储有处理后的数据。具体的，可以参照上述描述，不予赘述。离线文件可以是指没有存储至数据库，且需要通过电子看板的数据。
例如，数据源可以包括数据库、用于存储离线文件的存储设备/用于获取离线文件的接口等。数据库的描述，可以参照下述数据库的描述。
需要说明的是，本申请实施例中，组件可以包括复杂组件和简单组件。其中，简单组件可以通过在电子看板开发页面通过SQL实现。复杂组件无法在电子看板开发页面通过SQL实现，需要通过开发组件平台进行开发。
组件开发平台可以用于复杂组件的开发。例如，开发平台可以响应于输入的代码，从数据库中获取与组件关联的数据，进而生成对应的组件。组件开发还可以用于通过接口测试对组件的功能进行验证。组件开发平台还可以通过功能接口向电子看板开发平台发送复杂组件。
电子看板开发平台，也可以称为电子看板***平台，可以用于开发电子看板。
一种示例中，如图4所示，电子看板开发平台可以包括电子看板开发页面、数据源管理模块、权限管理模型、用户管理模块。
其中，电子看板开发页面可以包括图2的a和b所示的页面。数据源管理模块可以用于管理数据库和离线文件。权限管理模块可以用于管理用户的权限。用户管理模块可以用于管理用户的信息(如用户的账号和密码等)。
一些实施例中，如图5所示，图5为本申请实施例提供的一种电子设备的结构示意图。该电子设备可以具有显示器510及处理器520、图形处理器(graphics processing unit，GPU)530。显示器510与处理器520、GPU530可以通信连接。例如，显示器510与处理器520可以通过***总线530连接。处理器520可以与GPU通信连接。
其中，显示器510可以包括显示屏/屏幕等。显示器510可以用于显示电子看板。例如，显示器可以为液晶显示器(liquid crystal display，LCD)、有机发光二极管(organic light-emitting diode，OLED)显示器等。
其中，处理器520，可以包括一个或多个中央处理器(Central Processing Unit，CPU)。CPU可以用于对数据进行处理以及执行本申请实施例中电子设备的操作。例如，对电子看板开发页面的操作等。
下面结合图5所示的电子设备，对本申请实施例提供的电子看板的管理方法进行说明。
如图6所示，为本申请实施例提供的一种电子看板的管理方法，该方法可以应用于图5所示的电子设备。该方法可以包括S601～S604。
S601、确定目标数据源。
其中，目标数据源可以用于获取目标业务数据。目标业务数据可以为需 要在电子看板中展示的数据。例如，目标业务数据可以为制造工厂的数据。比如可以为工人数据、设备数据、物资数据、制造数据、检测数据、环境数据等。
一种示例中，目标数据源可以包括数据库、离线文件。则目标业务数据可以为数据库中的数据，也可以为用户上传的离线文件中的数据。
例如，电子设备可以从关联的目标数据库中获取目标业务数据，或者，可以响应于上传操作，获取离线文件，并对离线文件进行解析得到目标业务数据。
其中，目标数据库可以存储有多个数据，该多个数据可以为处理后的数据。目标数据库中的数据可以为处理后的数据。处理后的数据可以是指上述使用ETL工具处理后的数据。该目标数据库可以为MDW数据库。
ETL可以用于描述将数据从数据源中经过抽取、转换和加载至目的端的过程。例如，电子设备可以使用ETL工具从不同数据源(可以为生产设备)中抽取出所需的数据，将所抽取的数据进行数据清洗和转换，再将清洗和转换后的数据加载到数据库中。该ETL工具可以执行ETL的功能。例如，该ETL工具可以为应用程序，也可以为可以执行该功能的器件，不予限制。
需要说明的是，本申请实施例中，电子设备在获取到用户上传的离线文件之后，可以存储该离线文件。比如，可以存储至数据库(如目标数据库)中，也可以存储至配置的存储器(如硬盘、内存等)中。
结合图2的a，电子设备可以响应于点击数据源管理，确定目标数据源。
一种示例中，若目标数据源为目标数据库，则电子设备可以获取用于指示目标数据库的第一链接，并根据第一链接，建立与目标数据库的连接。
其中，第一链接可以用于指示目标数据库的名称、地址等。该第一链接可以为用户在数据源的输入框编辑的链接。例如，第一连接可以包括目标数据库的名称、标识、编号等。
又一种示例中，若目标数据源为离线文件，则电子设备可以响应于第三配置操作，将目标数据源设置为离线文件。
其中，离线文件可以包括目标业务数据。例如离线文件可以为csv文件。第三配置操作可以为用户在数据源的输入框选择的数据源的类型的操作。
一种示例中，结合图1所示的***，目标数据库可以为数据层中的MDW数据库。目标业务数据存储至MDW数据库的过程可以包括将MES数据库存储的生产数据抽取到ODS数据库中，以及将ODS数据库中的数据按照需求抽取到MDW两个抽取过程。
其中，数据的抽取可以包括实时的数据同步抽取和定时数据抽取。
一种示例中，为了实现数据的抽取，对于实时的数据同步抽取可以使用OGG+Kafka的方式。对于定时数据抽取可以使用ETL工具。OGG+Kafka可以参照现有技术，不予赘述。ETL工具可以参照上述ETL的描述，不予赘述。
一种示例中，以上述数据层包括MES数据库、ODS数据库以及MDW数据库为例，对电子设备使用ETL工具进行数据抽取的方式进行说明。
一种可能的实施例中，当上述多个数据库应用于生产***中，电子设备可以使用ETL工具将MES数据库中存储的生产数据抽取出来，然后，进行处理后存储至ODS数据库。然后，电子设备可以继续将ODS数据库整合好的生产数据通过ETL等方式存储至MDW数据库中，进而完成生产数据从生产操作到数据分析的过程。
需要说明的是，本申请实施例中，电子设备可以根据数据层的多个数据库通信连接。例如，电子设备可以监控多个数据库的存储状态。
一种示例中，ETL工具可以包括Pentaho Kettle工具、数据整合平台(Informatica PowerCenter)工具。
下面分别对电子设备使用这两种工具进行数据抽取的过程进行说明。
一、电子设备使用Pentaho Kettle工具进行数据抽取。
其中，Pentaho Kettle工具可以用于执行表输入和表输出的抽取任务。例如，如图7所示，该过程可以包括：开始任务→任务执行(包括删除任务、执行任务)→任务成功。
其中，在开始任务之前，电子设备可以设置定时任务。该定时任务可以具有唯一的任务名称。例如，该定时任务可以以数据库ETL定时调度的任务表的形式运行。该任务表可以用于数据库ETL定时调度的内容。
如图8的a所示，为该工具的一种运行过程的示意图。
如图8的b所示，为该工具的一种设置界面。该设置界面可以用于设置步骤名称、数据库名称(数据库连接)、输入结构化查询语言(Structured Query Language，SQL)。
如图8的c所示，为该工具的一种设置界面。该设置界面可以用于设置任务表中的任务名称、数据库名称(数据库连接)、SQL(SQL文件名)、SQL等。
任务表中还可以包括该任务的数据抽取的时间、数据抽取的频率、任务的状态。
在电子设备执行该定时任务时，可以从任务表获取任务表中任务的开始 时间和结束时间。在运行任务时，电子设备可以在开始时间和结束时间之间的时间段内抽取数据。当任务执行成功后，电子设备可以更新该任务表下一次执行该定时任务的时间、状态等内容。
一种示例中，电子设备在执行数据抽取时，可以包括全量抽取和增量抽取两种抽取方式。电子设备可以根据任务的业务数据的数量和实时性的要求，设置定时任务。例如，可以按照每小时、每天、指定时间段抽取汇总数据。
二、电子设备使用Informatica PowerCenter工具进行数据抽取。
其中，Informatica PowerCenter工具是一种用于抽取企业级大数据的工具。
如图9的a所示，PowerCenter Designer工具可以根据设置，选择从数据库导入表，并连接到数据库设置ODBC数据源的数据库驱动和源配置，以及根据开发需求导入所需要的源表和目标表。
Informatica PowerCenter工具还用于创建映射(Mapping)。例如，Informatica PowerCenter工具可以响应于操作，将源表和目标表移动至Mapping Designer工作区，并建立字段的链接。
其中，Informatica PowerCenter工具中的源SQ组件可以用于写入数据抽取的SQL。如果是定时的ETL调度任务，需要在Mapping中创建时间参数，并在SQL中使用参数过滤，实现增量抽取。
例如，Informatica PowerCenter工具中的每个Mapping的目标组件“属性”-“Pre SQL”可以用于配置时间参数、删除目标表对应区间数据。如此，可以避免数据重复写入。Informatica PowerCenter工具中的每个Mapping的目标组件“属性”-“Post SQL”可以用于配置ETL任务表的字段数据更新。Informatica PowerCenter工具的每个会话(Session)的属性可以用于配置参数文件的读取路径。
基于上述操作，电子设备可以保存映射mapping，生成工作流。
如图9的b所示，Informatica PowerCenter工具可以响应于用户的第一操作，进行会话(Session)配置。
例如，第一操作可以包括打开工作流管理器(Workflow Manager)，将创建的会话拖入到任务开发(Task Developer)中，编辑会话的属性输入参数文件地址，配置源和目标的连接信息等。
如图9的b所示，Informatica PowerCenter工具还可以响应于用户的第二操作，创建工作流(Workflow)。
其中，第二操作可以包括打开工作流设计器(Workflow Designer)，创建工作流，在Workflow工作区中“开始(Start)”与拖拽的需要运行的“会 话”链接起来等。
如图9的c所示，Informatica PowerCenter工具还可以响应于用户的第三操作，运行工作流。
其中，第三操作可以包括点击“启动工作流”，打开工作流监视器(Workflow Monitor)。Monitor可以用于显示工作流、会话执行情况、日志信息、数据统计信息。
电子设备还可以响应于用户点击“获取会话日志”的操作，显示日志信息，以便于用户查看具体的错误信息。
S602、响应于第一操作，获取第一组件模型，并对第一组件模型的属性信息进行配置，得到目标组件模型。
其中，第一操作可以包括第一选择操作或第一调用操作。第一选择操作可以是指从多个组件模型中选择满足用户需求的组件模型的操作。第一调用操作可以是指获取用于生成第一组件模型的程序代码的操作。第一组件模型可以为电子设备预先配置的，例如，可以为图2的b中的组件区域中的组件模型(可以称为简单组件模型)。第一组件模型也可以为电子设备通过调用并运行程序代码，生成的目标模型(可以称为复杂组件模型)。
一种示例中，当目标数据源为数据库，则电子设备可以响应于第一选择操作，从电子设备预先配置的多个组件模型中获取第一组件模型。
例如，结合图2的b所示的电子看板开发页面，多个组件模型可以为组件区域中显示的多个组件模型。调用操作可以是指将组件区域中的组件模型拖拽值组件开发区域的操作。第一组件模型可以为组件区域中的组件模型。
又一种示例中，当组件区域中的组件模型不能满足需求时，如组件区域中的组件模型不存在某个数据格式的组件模型。例如，不存在用于展示设备稼动率的时间状态图的组件模型。电子设备可以响应于第一调用操作，获取用于生成第一组件模型的程序代码，并运行该程序代码，得到第一组件模型。
例如，结合图4所示的***，电子设备可以从组件开发平台获取用于生成第一组件模型的程序代码。
需要说明的是，设备稼动率是指组件需求按照时间顺序展示每台生产设备不同稼动状态。电子设备需要获取生产设备在不同状态的开始和结束时间，并按照时间的顺序排列。
其中，第一组件模型的属性信息可以包括第一组件模型在电子看板中的位置、大小、边距、参数等。参数可以组件模型的线条或图案形式等。例如，折现柱状图的参数可以包括折线柱状图的线条颜色、线条粗度、线条虚实、 图案填充颜色、图案形状(如直方图、圆柱图等)。坐标轴的参数可以包括X轴和Y轴的样式(如箭头的形状、线条的粗度、颜色等)。
一种可能的实现方式中，结合图2的b所示的电子看板开发页面，电子设备可以响应于对配置区域中的属性项的设置操作，可以实现对组件模型的属性信息的配置，得到目标组件模型。
一种示例中，目标业务数据为电量数据。用户的需求时通过折线图将该多个时间段内的电量展示在电子看板中。结合图2的b的电子看板开发页面，电子设备可以响应于拖拽操作，在组件开发区域显示多折线图。同时，可以在图层区域显示多折线图的名称。电子设备可以响应于点击开发区域的多折线图的操作，可以在配置区域显示该多折线图的配置信息(属性、数据、交互)。进一步的，电子设备可以响应于对配置区域中的属性的调整操作，对多折线图的属性信息进行调整(如显示位置、边距、标题、缩放比例等)。如此，可以得到电量数据对应的目标组件模型。
S603、响应于第二操作，从目标数据源获取目标业务数据，并将目标业务数据与目标组件模型进行关联，得到目标组件。
其中，第二操作可以包括第二配置操作或第二上传操作。第二配置操作可以是指通过电子看板开发页面配置调用代码的操作。第二上传操作可以是指上传离线文件的操作。目标组件可以用于反映目标业务数据的分布情况。
一种示例中，当目标数据源为数据库，第二配置操作可以为输入SQL的操作。例如，结合图2的b所示的电子开发页面，第二配置操作可以是指通过设置区域的数据下的输入框输入SQL的操作。响应于该第二配置操作，电子设备可以从目标数据库中获取目标数据，并将组件模型与目标数据关联，得到目标组件。
又一种示例中，当目标数据为离线文件，第二上传操作可以是指上传离线文件的操作。例如，结合图2的b所示的电子开发页面，第二上传操作可以是指通过设置区域的数据下的上传框，上传离线文件的操作。比如，电子设备可以响应于点击上传框，可以显示上传页面，该上传页面可以用于上传离线文件。电子设备在获取到离线文件之后，可以进行解析，得到目标业务数据，并将目标业务数据与目标组件模型关联，得到目标组件。
进一步的，为了保证离线文件的安全，离线文件可以为加密的文件。电子设备在获取到加密的文件之后，可以根据配置的解密密钥进行解密，得到目标业务数据。
又一种示例中，电子设备可以获取用户信息。例如，响应于登录操作， 用户可以通过登录界面输入用户的账号和密码。当确定用户信息具有上传离线文件的权限的情况下，电子设备可以显示上传页面。该上传页面可以用于上传csv文件或离线文件。响应于上传操作，电子设备可以获取包括目标业务数据的csv文件。
其中，该csv文件可以为根据预先模型的文件确定的。也即，电子设备可以先输出预设格式的文件，用于用户根据该文件的预设格式填写业务数据。用户在填写完成之后，可以通过上传页面上传包括目标业务数据的csv文件。电子设备在接收到该csv文件之后，可以将该csv文件存储至数据库或其他存储器中。
其中，电子设备将目标业务数据与目标组件模型关联可以是指将目标业务数据作为配置参数对目标组件模型进行配置。例如，目标组件模型为分组柱状图。该分组柱状图的横坐标为每个柱状图表示的属性名称，纵坐标表示属性对应的数据。
一种示例中，结合S602中的示例，电量数据为多个月份的用电量。比如，电量数据可以为表1所示的数据。该电量数据可以包括1-6月份中每个月份的用电量。其中，该电量数据的属性名称为月份，属性对应的数据为每个月份对应的用电量。
表1
月份 1月 2月 3月 4月 5月 6月
用电量 600 610 700 720 720 710
需要说明的是，表1中的数据仅为示例性的，还可以为其他数据，不予限制。
结合图2的b中的电子看板开发页面，第一组件模型为柱状图。电子设备可以响应于调用操作，将组件区域中的分组柱状图拖拽至组件开发区域。电子设备响应于点击开发区域中的分组柱状图的操作，可以在图层区域显示分组柱状图的名称，并在设置区域显示分组柱状图的属性信息(属性、数据、交互)。
电子设备响应于修改操作，修改分组柱状图的在图层区域的名称(如修改为1-6月的用电量)，并响应于在设置区域中的操作，修改分组柱状图的属性信息(如条形图的数量、每个条形图对应的月份、每个条形图的宽度、填充颜色、每个条形图在X轴的位置，Y轴的数值分布等)。
电子设备响应于在配置区域中的数据下的输入框输入的SQL的操作，获取SQL。电子设备运行SQL，可以调整分组柱状图中每个条形图的高度。调 整后的条形图的高度对应的Y周期的数值为该月份的用电量。例如，调整后的分组柱状图(也即目标组件)可以如图10所示。
又一种示例中，当目标数据源为离线文件时，电子设备在获取到离线文件之后，可以解析该离线文件，得到目标业务数据，并将目标业务数据与目标组件模型关联，得到目标组件。
例如，目标组件模型为公告栏，则电子设备在从存储的csv文件中获取到目标业务数据之后，可以将公告栏的名称字段修改为目标业务数据的名称，并将目标业务数据在公告栏的显示框内显示，如此可以得到公告栏组件。
又一种示例中，当目标业务数据包括多个类型的数据，也即目标业务数据对应多个组件模型，该多个组件模型的类型可以相同，也可以不同。在这种情况下，电子设备可以分别确定每个类型的数据对应的组件。
在该多个类型的数据具有关联关系的情况下，电子设备还可以响应于交互操作，设置该多个类型的数据对应的组件的层级关系或关联关系。
其中，层级关系可以是指多个组件在电子看板上的层级关系。关联关系可以是指电子设备在显示多个组件时的顺序。例如，组件1与组件2关联。电子设备可以响应于点击组件1或组件1中某个数据的操作，以弹窗的方式显示组件2。
一种示例中，结合图2的b所示的电子看板开发页面，电子设备可以响应于点击配置区域的交互下的操作，设置目标组件和其他组件之间的关联关系。
例如，电子设备可以确定第一组件。第一组件的确定方法可以参照目标组件的确定方法，不予赘述。第一组件包括的业务数据与目标组件的数据不同。第一组件的类型可以与目标组件的类型相同，也可以不同。电子设备可以响应于关联操作，建立目标组件和第一组件之间的关联关系。该关联操作可以是指用户通过图2的b所示的电子看板开发页面中的配置区域的交互，建立目标组件和第一组件的关联关系的操作。
又例如，电子设备可以在确定第一组件之后，可以在交互区域设置第一组件和目标组件之间的层级关系。其中，层级关系可以是指目标组件和第一组件的显示顺序。例如，目标组件位于第一组件的上层。则电子看板可以在显示完第一组件之后，再显示目标组件，且目标组件的显示位置位于第一组件的上面。比如，目标组件可以覆盖第一组件或覆盖第一组件的部分。
S604、电子设备在电子看板中显示目标组件。
其中，在得到目标组件之后，电子设备可以将在电子看板中显示目标组 件，或者电子设备可以显示电子看板，该电子看板可以包括目标组件。当然，该电子看板还可以设置有其他组件。
一种可能实现方式中，结合图2的b所示的电子看板开发页面，电子设备可以响应于点击发布的操作，显示包括目标组件的电子看板。
进一步的，为了查看生成的目标组件在电子看板中的显示效果，电子设备可以响应于点击预览的操作，生成电子看板的预览页面。基于该预览页面，用户可以查看电子看板是否满足需求。在电子看板不满足需求或存在问题的情况下，电子设备可以响应于调整操作，继续对电子看板中的组件进行调整，直至得到满足用户需求的电子看板。
一种示例中，电子设备还可以动态的更新电子看板。例如，对于动态变化的生产数据，电子设备可以按照预设周期从目标数据库中获取更新后生产数据，并根据更新后的生产数据，对用于表示生产数据的分布情况的组件进行调整，调整后的组件能够反映更新后的生产数据的分布情况。
例如，对于结合上述图10的用电量对于的组件，当目标数据库中的用电量更新时(如新增了7月份的用电量)时，电子设备可以对用于生成该组件的组件模型的字段进行调整，调整后的组件模型包括7月份对应的条形图。电子设备可以根据调整后的组件模型与更新的用电量，生成新的组件。
又例如，电子设备可以对组件直接进行调整，例如，在图10的组件上增加7月份对应的条形图，且该条形图位于6月份之后，并根据纵坐标的数值，将7月份的条形图调整为对应的高度。如此，电子设备可以得到新的组件。
又一种示例中，当目标组件和第一组件具有关联关系时，电子设备根据该关联关系，显示目标组件和第一组件。例如，当目标组件的某个字段被点击之后，可以显示第一组件。
又一种示例中，当目标组件和第一组件具有层级关系时，电子设备可以根据该层级关系，确定目标组件和第一组件的显示顺序以及显示位置。
当然，本申请实施例中，电子看板还可以包括更多的组件。比如，可以包括公告栏。公告栏可以用于显示离线文件的内容。该多个组件可以动态或静态的在电子看板上显示。
又一种可能的实现方式中，电子设备在确定电子看板的组件之后，可以将电子看板发送给其他显示设备进行显示。例如，对应生产车间的生产数据，电子设备可以向生产车间的显示设备。生产车间的显示设备在接收到来自电子设备的电子看板之后，可以显示该电子看板。
需要说明的是，本申请实施例中，电子设备还可以对电子看板的显示效 果进行配置。例如，电子设备可以根据背景配置操作，确定电子看板的背景颜色、图案等。又例如，电子设备还可以根据动画配置操作，确定电子看板的动态显示效果。又例如，电子设备还可以根据语音配置操作，确定电子看板的语音。
基于图9的技术方案，电子设备在获取到目标业务数据之后，可以响应于用户的操作，从多个预先配置好的组件模型中，调用满足需求的组件模型。接着，电子设备可以对该组件模型的属性信息进行调整，得到目标组件模型，进而，电子设备可以响应于用户的关联操作，将目标业务数据与目标组件模型进行关联，得到目标组件。最后，电子设备可以在电子看板中显示该目标组件。也即，本申请实施例提供的技术方案，用户只需求简单操作，便可以实现组件的开发，用户可以不需要代码开发基础和经验，降低了电子看板的开发难度。
一些实施例中，为了避免出现组件区域的组件模型不存在满足需求的组件模型，电子设备可以调用代码，实现组件模型的开发。
一种示例中，开发平台可以配置有开发工具。该开发工具可以用于开发组件。例如，开发工具可以包括主开发工具(如Maven、Eclipse、STS、IDEA)和辅助开发工具(如，用于版本控制的GIT、用于调试接口数据的Postman、用于代码管理的资源树(Sourcetree)、用于测试SQL的DBeaver)。
具体的，基于上述开发工具，组件模型的开发流程可以包括：
1、使用Eclipse开发工具后台代码开发。
1-1、接口开发-dao。服务(service)在调用dao层方法来操作数据库查询，主要将相应的dao进行注解@映射器(Mapper)和@组成部分(Component)。
1-2、服务(Service)。Controllor调用Service的方法时，所写的类要加注解通过@来添加。
1-3、控制器(Controller)。用户可以根据业务，确定访问的链接，并通过请求映射(Request Mapping)+GET(POST)Mapping拼接路径。
其中，按照月份获取(getInPutByMonth)(String fac)中fac的地址栏的可变参数。该可变参数可以需要添加或者修改。
1-4、可扩展标记语言(eXtensible Markup Language，xml)文件-sql。xml中的标识(Identity document，id)对应dao的一个方法。其中，xml具有唯一的id。页面和方法的参数，在此处替换。
2、代码和接口调试。
在Eclipse中通过Debug模式运行代码，使用Postman工具输入本地测试 接口、参数名称和参数值等内容。如果调试运行有报错，在Eclipse查阅报错的内容，通过加断点的方法调试和修改代码。
查看Postman获取的数据结果，还可以使用HiJson工具将数据结果格式化json字符串，查看获取的数据和结构是否满足前端页面组件的数据结构要求。
3、代码提交和发布部署。
代码使用Sourcetree工具拉取和提交。代码的发布可以使用Jenkins工具。本地代码打包并上传后，可以执行脚本实现独立部署。
4、页面开发和数据配置。
在电子看板开发页面中，响应于拖拽操作，将组件移动至开发区域，并配置组件的属性、数据使用应用程序编程接口(application programming interface，API)、输入接口。在组件的属性信息配置之后，可以通过后台代码和接口从数据库获取数据，并在页面展示组件的效果。
下面结合具体的示例，对本申请实施例提供的电子看板的确定方法进行说明。
示例1、目标业务数据为图表类数据。
为了减低开发难度，电子设备可以响应于配置操作，与数据库建立连接，并通过电子看板开发页面获取SQL，用以从数据库中获取数据。最后，电子设备将获取到的数据根据图表组件的字段，在开发页面上实现图表组件的开发。
具体的，电子设备可以通过以下过程实现包括图表组件的电子看板的开发。
2-1、如图11所示，响应于在电子看板的数据源管理界面的操作，电子设备可以建立与数据库之间的连接。
进一步的，响应于配置操作，电子设备还可以配置数据源的名称、类型、数据源地址、端口号、数据库名称、用户名和密码等信息。
2-2、响应于编辑操作，电子设备可以在组件开发区域对组件模型的属性信息进行配置。
其中，2-2可以参照上述实施例的描述，不予赘述。
2-3、电子设备获取SQL，并根据该SQL从数据源中获取数据，并将数据配置到组件模型中。
进一步的，为了检测SQL，可以在SQL编辑器测试SQL的正确性以及检测获取到的数据是否正确。
2-4、响应于交互操作，电子设备可以将多个组件进行关联。
例如，控制组件的显示和隐藏，下拉框组件的参数查询条件和图表结果的交互。
示例2、离线表格类数据的数据源管理。
如图12所示，对于离线的表格类数据，电子设备可以在数据源管理配置csv文件，并分配用户权限。在电子看板开发页面，数据源使用csv文件，并在组件上配置数据字段。
具体的实施流程如下：
3-1、准备数据源。电子设备可以通过电子看板开发页面中分配用户权限。对于有权限的用户，可以在数据源管理的csv文件管理页面，上传文件。该csv文件可以为加密文件。
3-2、组件功能开发。电子设备响应于操作，将表格组件移动至到组件开发区域，并根据配置，调整表格组件模型的位置、大小等属性信息，以及将目标业务数据与表格组件模型关联，得到目标组件(也即包括表格组件)。其中，表格组将的列key为csv文件的列名。
3-3、显示表格组件。电子设备可以响应于预览操作，显示表格组件的效果。在表格组件满足需求的情况下，电子设备可以发布表格组件。也即，电子设备在电子看板上显示表格组件。
示例3、公告栏的文件导入和界面展示。
如图13所示，多用户上传的离线文件，不设置用户权限，通过后台代码实现文件上传的通用功能。
具体的实施例流程如下：
4-1、获取离线文件。该离线文件为根据预先模板确定的文件。例如，电子设备可以输入预设模板的文件。该文件的字段为预设字段，基于该文件，用户可以进行修改并填写业务数据。
4-2、响应于上传操作，电子设备可以获取离线文件，并在解析中，包括在数据库中。该离线文件可以为加密的文件。
4-4、电子设备在生成公告栏之后，可以响应于刷新操作，展示上传的文件内容。
需要指出的是，本申请各实施例之间可以相互借鉴或参考，例如，相同或相似的步骤，方法实施例、***实施例和装置实施例之间，均可以相互参考，不予限制。
本申请实施例可以根据上述方法示例对确定装置进行功能模块或者功能 单元的划分，例如，可以对应各个功能划分各个功能模块或者功能单元，也可以将两个或两个以上的功能集成在一个处理模块中。上述集成的模块既可以采用硬件的形式实现，也可以采用软件功能模块或者功能单元的形式实现。其中，本申请实施例中对模块或者单元的划分是示意性的，仅仅为一种逻辑功能划分，实际实现时可以有另外的划分方式。
如图14所示，为本申请实施例提供的一种电子看板的确定装置的结构示意图，该确定装置应用于电子设备。该电子设备用于确定电子看板。该确定装置包括：确定单元1401、获取单元1402和显示单元1403。
确定单元1401，被配置为：确定用于获取目标业务数据的目标数据源。
获取单元1402，被配置为：响应于第一操作，获取第一组件模型，并对第一组件模型的属性信息进行配置，得到目标组件模型。
获取单元1402，还被配置为：响应于第二操作，从目标数据源获取目标业务数据，并将目标业务数据与目标组件模型进行关联，得到用于反映目标业务数据的分布情况的目标组件。
显示单元1403，用于在电子看板中显示该目标组件。
在一些实施例中，目标数据源包括目标数据库或离线文件，第二操作为第二配置操作或第二上传操作，获取单元1402，具体被配置为：响应于第二配置操作，从与电子设备关联的目标数据库中获取目标业务数据；或者，响应于第二上传操作，获取离线文件，并所述离线文件进行解析，获取所述目标业务数据。
在一些实施例中，如图14所示，该装置还包括处理单元1404，目标数据源包括目标数据库或离线文件，获取单元1402，还被配置为：获取用于指示目标数据库的第一链接。处理单元1404，被配置为：根据第一链接，建立与目标数据库之间的连接。
在一些实施例中，目标数据源为离线文件，处理单元1404，被配置为：响应于第三配置操作，将目标数据源设置为离线文件。
在一些实施例中，第一操作包括第一选择操作或第一调用操作，获取单元1402，具体被配置为：响应于第一选择操作，从电子设备预先配置的多个组件模型中获取第一组件模型；或者，响应于第一调用操作，获取用于生成第一组件模型的程序代码，并运行程序代码，得到第一组件模型。
在一些实施例中，目标数据库存储有多个数据；多个数据为使用预设工具对原始数据进行处理后的数据，多个数据包括目标业务数据。
在一些实施例中，使用预设工具对原始数据进行处理是指原始数据进行 ETL处理。
在一些实施例中，获取单元1402，还被配置为：获取包括用户的账号及对应的密码的用户信息；在用户信息具有上传离线文件的权限的情况下，显示用于上传csv文件，csv文件包括目标业务数据。获取单元，还被配置为：通过上传页面获取csv文件，并从csv中获取目标业务数据。
在一些实施例中，该方法还包括：接收并存储多个根据预设文件模板确定的离线文件；通过电子看板显示多个离线文件的信息。
一些实施例中，确定单元1401，还被配置为：确定用于反映第一业务数据的分布情况的第一组件；响应于第三操作，建立目标组件与第一组件之间的关联关系。显示单元1403，具体被配置为：根据目标组件与第一组件之间的关联关系，在所述电子看板中显示目标组件和第一组件。
实现时，本申请实施例中的获取单元1402可以集成在通信接口上，确定单元1401和处理单元1404可以集成在处理器上。具体实现方式如图15所示。
图15示出了上述实施例中所涉及的确定装置的又一种可能的通信装置的结构示意图。该通信装置包括：处理器1502和通信接口1503。处理器1502用于对装置的动作进行控制管理，例如，执行上述确定单元1401和处理单元1404执行的步骤，和/或用于执行本文所描述的技术的其它过程。通信接口1503用于支持装置与其他网络实体的通信，例如，执行上述获取单元1402执行的步骤。该装置还可以包括存储器1501和总线1504，存储器1501用于存储装置的程序代码和数据。
其中，存储器1501可以是该装置中的存储器等，该存储器可以包括易失性存储器，例如随机存取存储器；该存储器也可以包括非易失性存储器，例如只读存储器，快闪存储器，硬盘或固态硬盘；该存储器还可以包括上述种类的存储器的组合。
上述处理器1502可以是实现或执行结合本申请公开内容所描述的各种示例性的逻辑方框，模块和电路。该处理器可以是中央处理器，通用处理器，数字信号处理器，专用集成电路，现场可编程门阵列或者其他可编程逻辑器件、晶体管逻辑器件、硬件部件或者其任意组合。其可以实现或执行结合本申请公开内容所描述的各种示例性的逻辑方框，模块和电路。该处理器也可以是实现计算功能的组合，例如包含一个或多个微处理器组合，DSP和微处理器的组合等。
总线1504可以是扩展工业标准结构(Extended Industry Standard Architecture，EISA)总线等。总线1504可以分为地址总线、数据总线、控制 总线等。为便于表示，图15中仅用一条粗线表示，但并不表示仅有一根总线或一种类型的总线。
图15中的装置还可以为芯片。该芯片包括一个或两个以上(包括两个)处理器1502和通信接口1503。
可选的，该芯片还包括存储器1501，存储器1501可以包括只读存储器和随机存取存储器，并向处理器1502提供操作指令和数据。存储器1501的一部分还可以包括非易失性随机存取存储器(non-volatile random access memory，NVRAM)。
在一些实施方式中，存储器1501存储了如下的元素，执行模块或者数据结构，或者他们的子集，或者他们的扩展集。
在本申请实施例中，通过调用存储器1501存储的操作指令(该操作指令可存储在操作***中)，执行相应的操作。
本公开的一些实施例提供了一种计算机可读存储介质(例如，非暂态计算机可读存储介质)，该计算机可读存储介质中存储有计算机程序指令，计算机程序指令在计算机(例如，电子设备)上运行时，使得计算机执行如上述实施例中任一实施例所述的电子课本的确定方法。
示例性的，上述计算机可读存储介质可以包括，但不限于：磁存储器件(例如，硬盘、软盘或磁带等)，光盘(例如，CD(Compact Disk，压缩盘)、DVD(Digital Versatile Disk，数字通用盘)等)，智能卡和闪存器件(例如，EPROM(Erasable Programmable Read-Only Memory，可擦写可编程只读存储器)、卡、棒或钥匙驱动器等)。本公开描述的各种计算机可读存储介质可代表用于存储信息的一个或多个设备和/或其它机器可读存储介质。术语“机器可读存储介质”可包括但不限于，无线信道和能够存储、包含和/或承载指令和/或数据的各种其它介质。
本公开的一些实施例还提供了一种计算机程序产品，例如，该计算机程序产品存储在非瞬时性的计算机可读存储介质上。该计算机程序产品包括计算机程序指令，在计算机(例如，电子设备)上执行该计算机程序指令时，该计算机程序指令使计算机执行如上述实施例所述的电子课本的确定方法。
本公开的一些实施例还提供了一种计算机程序。当该计算机程序在计算机(例如，电子设备)上执行时，该计算机程序使计算机执行如上述实施例所述的电子课本的确定方法。
上述计算机可读存储介质、计算机程序产品及计算机程序的有益效果和上述一些实施例所述的电子课本的确定方法的有益效果相同，此处不再赘述。
在本申请所提供的几个实施例中，应该理解到，所揭露的***、设备和方法，可以通过其它的方式实现。例如，以上所描述的设备实施例仅仅是示意性的，例如，所述单元的划分，仅仅为一种逻辑功能划分，实际实现时可以有另外的划分方式，例如多个单元或组件可以结合或者可以集成到另一个***，或一些特征可以忽略，或不执行。另一点，所显示或讨论的相互之间的耦合或直接耦合或通信连接可以是通过一些接口，设备或单元的间接耦合或通信连接，可以是电性，机械或其它的形式。
所述作为分离部件说明的单元可以是或者也可以不是物理上分开的，作为单元显示的部件可以是或者也可以不是物理单元，即可以位于一个地方，或者也可以分布到多个网络单元上。可以根据实际的需要选择其中的部分或者全部单元来实现本实施例方案的目的。
另外，在本申请各个实施例中的各功能单元可以集成在一个处理单元中，也可以是各个单元单独物理存在，也可以两个或两个以上单元集成在一个单元中。
以上所述，仅为本公开的具体实施方式，但本公开的保护范围并不局限于此，任何熟悉本技术领域的技术人员在本公开揭露的技术范围内，想到变化或替换，都应涵盖在本公开的保护范围之内。因此，本公开的保护范围应以所述权利要求的保护范围为准。

Claims (22)

  1. 一种电子看板的确定方法，其中，应用电子设备，所述电子设备用于管理所述电子看板，该方法包括：
    确定目标数据源，所述目标数据源用于获取目标业务数据；
    响应于第一操作，获取第一组件模型，并对所述第一组件模型的属性信息进行配置，得到目标组件模型；
    响应于第二操作，从所述目标数据源获取所述目标业务数据，并将所述目标业务数据与所述目标组件模型进行关联，得到目标组件，所述目标组件用于反映所述目标业务数据的分布情况；
    在所述电子看板中显示所述目标组件。
  2. 根据权利要求1所述的方法，其中，所述目标数据源包括目标数据库或离线文件，所述第二操作包括第二配置操作或第二上传操作，所述响应于第二操作，从所述目标数据源获取所述目标业务数据，包括：
    响应于所述第二配置操作，从与所述电子设备关联的目标数据库中获取所述目标业务数据；或者，
    响应于所述第二上传操作，获取所述离线文件，并对所述离线文件进行解析，获取所述目标业务数据。
  3. 根据权利要求2所述的方法，其中，所述目标数据源为所述目标数据库，所述方法还包括：
    获取第一链接，所述第一链接用于指示所述目标数据库；
    根据所述第一链接，建立与所述目标数据库的连接。
  4. 根据权利要求2所述的方法，其中，所述目标数据源为所述离线文件，所述方法还包括：
    响应于第三配置操作，将所述目标数据源设置为所述离线文件。
  5. 根据权利要求1-4任一项所述的方法，其中，所述第一操作包括第一选择操作或第一调用操作，所述响应于第一操作，获取第一组件模型，包括：
    响应于所述第一选择操作，从所述电子设备预先配置的多个组件模型中获取所述第一组件模型；或者，
    响应于所述第一调用操作，获取用于生成所述第一组件模型的程序代码，并运行所述程序代码，得到所述第一组件模型。
  6. 根据权利要求2或3所述的方法，其中，所述目标数据库存储有多个数据；所述多个数据为使用预设工具对原始数据进行处理后的数据，所述多个数据包括所述目标业务数据。
  7. 根据权利要求6所述的方法，其中，所述使用预设工具对原始数据进 行处理是指所述原始数据进行抽取-转换-加载ETL处理。
  8. 根据权利要求1-7任一项所述的方法，其中，所述方法还包括：
    获取用户信息，其中，所述用户信息包括所述用户的账号及对应的密码；
    在所述用户信息具有上传离线文件的权限的情况下，显示上传页面，所述上传页面用于上传csv文件，且所述csv文件包括所述目标业务数据；
    所述从所述目标数据源获取所述目标业务数据，包括：
    通过所述上传页面获取所述csv文件，并从所述csv中获取所述目标业务数据。
  9. 根据权利要求1-8任一项所述的方法，其中，所述方法还包括：
    接收并存储多个离线文件，所述多个离线文件为根据预设文件模板确定；
    通过所述电子看板显示所述多个离线文件的信息。
  10. 根据权利要求1-9任一项所述的方法，其中，所述方法还包括：
    确定第一组件，所述第一组件用于反映第一业务数据的分布情况；
    响应于第三操作，建立所述目标组件与所述第一组件之间的关联关系；
    所述在所述电子看板中显示所述目标组件，包括：
    根据所述目标组件与所述第一组件之间的关联关系，在所述电子看板中显示所述目标组件和所述第一组件。
  11. 一种电子看板的确定装置，其中，应用于电子设备，所述电子设备用于管理所述电子看板，所述装置包括确定单元、获取单元和显示单元；
    所述确定单元，被配置为：确定目标数据源，所述目标数据源用于获取目标业务数据；
    所述获取单元，被配置为：响应于第一操作，获取第一组件模型，并对所述第一组件模型的属性信息进行配置，得到目标组件模型；
    所述获取单元，还被配置为：响应于第二操作，从所述目标数据源获取所述目标业务数据，并将所述目标业务数据与所述目标组件模型进行关联，得到目标组件，所述目标组件用于反映所述目标业务数据的分布情况；
    所述显示单元，被配置为：在所述电子看板中显示所述目标组件。
  12. 根据权利要求11所述的装置，其中，所述目标数据源包括目标数据库或离线文件，所述第二操作包括第二配置操作或第二上传操作，所述获取单元，具体被配置为：
    响应于所述第二配置操作，从与所述电子设备关联的目标数据库中获取所述目标业务数据；或者，
    响应于所述第二上传操作，获取所述离线文件，并对所述离线文件进行 解析，获取所述目标业务数据。
  13. 根据权利要求12所述的装置，其中，所述装置还包括处理单元，所述目标数据源为所述目标数据库，
    所述获取单元，还被配置为：获取第一链接，所述第一链接用于指示所述目标数据库；
    所述处理单元，被配置为：根据所述第一链接，建立与所述目标数据库的连接。
  14. 根据权利要求12所述的装置，其中，所述装置还包括处理单元，所述目标数据源为所述离线文件，
    所述处理单元，被配置为：响应于第三配置操作，将所述目标数据源设置为所述离线文件。
  15. 根据权利要求11-14任一项所述的装置，其中，所述第一操作包括第一选择操作或第一调用操作，所述获取单元，具体被配置为：
    响应于所述第一选择操作，从所述电子设备预先配置的多个组件模型中获取所述第一组件模型；或者，
    响应于所述第一调用操作，获取用于生成所述第一组件模型的程序代码，并运行所述程序代码，得到所述第一组件模型。
  16. 根据权利要求12或13所述的装置，其中，所述目标数据库存储有多个数据；所述多个数据为使用预设工具对原始数据进行处理后的数据，所述多个数据包括所述目标业务数据。
  17. 根据权利要求16所述的装置，其中，所述使用预设工具对原始数据进行处理是指对所述原始数据进行ETL处理。
  18. 根据权利要求11-17任一项所述的装置，其中，
    所述获取单元，还被配置为：响应于获取用户信息，其中，所述用户信息包括所述用户的账号及对应的密码；
    所述显示单元，还被配置为：在所述用户信息具有上传离线文件的权限的情况下，显示上传页面，所述上传页面用于csv文件，且所述csv文件包括所述目标业务数据；
    所述获取单元，具体被配置为：通过所述上传页面获取所述csv文件，并从所述csv中获取所述目标业务数据。
  19. 根据权利要求11-18任一项所述的装置，其中，
    所述获取单元，还被配置为：接收并存储多个离线文件，所述多个离线文件为根据预设文件模板确定；
    所述显示单元，还被配置为：通过所述电子看板显示所述多个离线文件的信息。
  20. 根据权利要求11-19任一项所述的装置，其中，
    所述确定单元，还被配置为：确定第一组件，所述第一组件用于反映第一业务数据的分布情况；
    处理单元，被配置为：响应于第三操作，建立所述目标组件与所述第一组件之间的关联关系；
    所述显示单元，还被配置为：根据所述目标组件与所述第一组件之间的关联关系，在所述电子看板中显示所述目标组件和所述第一组件。
  21. 一种电子看板的确定装置，包括：处理器和通信接口；所述通信接口和所述处理器耦合，所述处理器用于运行计算机程序或指令，以实现如权利要求1-10任一项所述的方法。
  22. 一种计算机可读存储介质，其中，所述计算机可读存储介质中存储有指令，当计算机执行所述指令时，所述计算机执行上述权利要求1-10任一项所述的方法。
PCT/CN2022/122344 2022-09-28 2022-09-28 电子看板的确定方法及装置 WO2024065338A1 (zh)

Priority Applications (2)

Application Number Priority Date Filing Date Title
CN202280003320.5A CN118103812A (zh) 2022-09-28 2022-09-28 电子看板的确定方法及装置
PCT/CN2022/122344 WO2024065338A1 (zh) 2022-09-28 2022-09-28 电子看板的确定方法及装置

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
PCT/CN2022/122344 WO2024065338A1 (zh) 2022-09-28 2022-09-28 电子看板的确定方法及装置

Publications (1)

Publication Number Publication Date
WO2024065338A1 true WO2024065338A1 (zh) 2024-04-04

Family

ID=90475364

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2022/122344 WO2024065338A1 (zh) 2022-09-28 2022-09-28 电子看板的确定方法及装置

Country Status (2)

Country Link
CN (1) CN118103812A (zh)
WO (1) WO2024065338A1 (zh)

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105956016A (zh) * 2016-04-21 2016-09-21 成都数联铭品科技有限公司 关联信息可视化处理***
CN106951534A (zh) * 2017-03-22 2017-07-14 北京数猎天下科技有限公司 一种大数据可视化数据关联关系的图形化处理方法和装置
CN108038246A (zh) * 2017-12-28 2018-05-15 重庆南华中天信息技术有限公司 用于生成可视化视图的方法及装置
CN110083346A (zh) * 2018-01-25 2019-08-02 阿里巴巴集团控股有限公司 基于数据可视化界面的筛选配置方法及装置
EP3582034A1 (en) * 2018-06-15 2019-12-18 Siemens Aktiengesellschaft Method and apparatus, in the field of automation technology, of updating processing data

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105956016A (zh) * 2016-04-21 2016-09-21 成都数联铭品科技有限公司 关联信息可视化处理***
CN106951534A (zh) * 2017-03-22 2017-07-14 北京数猎天下科技有限公司 一种大数据可视化数据关联关系的图形化处理方法和装置
CN108038246A (zh) * 2017-12-28 2018-05-15 重庆南华中天信息技术有限公司 用于生成可视化视图的方法及装置
CN110083346A (zh) * 2018-01-25 2019-08-02 阿里巴巴集团控股有限公司 基于数据可视化界面的筛选配置方法及装置
EP3582034A1 (en) * 2018-06-15 2019-12-18 Siemens Aktiengesellschaft Method and apparatus, in the field of automation technology, of updating processing data

Also Published As

Publication number Publication date
CN118103812A (zh) 2024-05-28

Similar Documents

Publication Publication Date Title
CN105700888B (zh) 一种基于jbpm工作流引擎的可视化快速开发平台
US8904342B2 (en) System and method for rapid development of software applications
US7594181B2 (en) Prototyping graphical user interfaces
KR101572509B1 (ko) 웹 기반의 어플리케이션 구축을 위한 사용자 인터페이스 프레임워크 운용 방법
US20040221258A1 (en) Method and apparatus for generating custom status display
US20100180260A1 (en) Method and system for performing an automated quality assurance testing
US7925977B2 (en) Architecture solution map builder
CN106445536B (zh) 自动化业务设计管理***
CN110807015A (zh) 一种大数据资产价值交付管理方法及***
JP2008511935A (ja) データ統合システムのためのユーザ・インターフェース
US20150199180A1 (en) Method and system of editing workflow logic and screens with a gui tool
US20080086716A1 (en) Method and apparatus for information display with intermediate datasource access
US11468229B2 (en) Describing changes in a workflow based on changes in structured documents containing workflow metadata
US20170185612A1 (en) Dynamically designing web pages
CN103150624A (zh) 基于工艺流程图的设备管理监控***
US10338894B2 (en) Generating applications based on data definition language (DDL) query view and application page template
CN103942722A (zh) 一种基于工作流的网络化数据协同报送统计***及方法
US20140229223A1 (en) Integrated erp based planning
CN109981692A (zh) 一种新型工业物联网架构及其实现方法
CN111782651A (zh) 数据关联关系的可视化编辑方法、装置、设备及存储介质
CN116382643A (zh) 一种基于低代码平台的运行***
WO2024065338A1 (zh) 电子看板的确定方法及装置
CN108132802B (zh) 一种配置模型在***开发中的应用方法
CN111381811A (zh) 一种适应于多类信息***集成的软件资源整合平台
CN114116686A (zh) 用于实现数据大屏的数据可视化方法

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 22959981

Country of ref document: EP

Kind code of ref document: A1