CN118103812A

CN118103812A - Method and device for determining electronic billboard

Info

Publication number: CN118103812A
Application number: CN202280003320.5A
Authority: CN
Inventors: 陈韵; 雷秀东; 梁峥峥; 高俊; 吴建波; 鲍国庆; 吴建民; 王洪
Original assignee: BOE Technology Group Co Ltd; Beijing Zhongxiangying Technology Co Ltd
Current assignee: BOE Technology Group Co Ltd; Beijing Zhongxiangying Technology Co Ltd
Priority date: 2022-09-28
Filing date: 2022-09-28
Publication date: 2024-05-28
Also published as: WO2024065338A1

Abstract

A method for determining an electronic signage is applied to determining an electronic device of the electronic signage. The method comprises: 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. Displaying the target component in the electronic signage.

Description

Method and device for determining electronic billboard

Technical Field

The disclosure relates to the technical field of data processing, and in particular relates to a method and a device for determining an electronic billboard.

Background

With the continuous development of technology, electronic signs are increasingly being widely used. For example, in the manufacturing industry, the electronic billboard can display the data analysis result of the production data in a report form in a visual manner according to the requirements of users, so that the users or the management staff can know the current production situation in time based on the data analysis result.

In the prior art, users can manufacture electronic signboards to be displayed through software tools configured by the electronic signboards. However, the development operation of the electronic billboard needs to have a certain code development foundation and experience, and the development difficulty of the electronic billboard is increased.

Disclosure of Invention

In one aspect, a method of determining an electronic billboard is provided. The method is applied to the electronic equipment, the electronic equipment is used for managing the electronic billboard, and the method comprises the following steps: determining a target data source for acquiring target service data; and responding to the first operation, acquiring a first component model, and configuring attribute information of the first component model to obtain a target component model. And responding to the second operation, acquiring target service data from a target data source, and associating the target service data with a target component model to obtain a target component for reflecting the distribution condition of the target service data. The target assembly is displayed in an electronic billboard.

In some embodiments, the target data source includes a target database or an offline file, the second operation is a second configuration operation or a second uploading operation, and the method for "obtaining the target service data from the target data source in response to the second operation" specifically includes: in response to the second configuration operation, obtaining target business data from a target database associated with the electronic device; or responding to the second uploading operation, obtaining an offline file, and analyzing the offline file to obtain the target service data.

In some embodiments, the target data source is a target database, the method comprising: and acquiring a first link for indicating the target database, and establishing connection with the target database according to the first link.

In some embodiments, the target data source is an offline file, the method further comprising: in response to the third configuration operation, the target data source is set as an offline file.

In some embodiments, the first operation includes a first selection operation or a first call operation, and the method for acquiring the first component model in response to the first operation specifically includes: in response to a first selection operation, acquiring a first component model from a plurality of component models preconfigured by the electronic equipment; or responding to the first calling operation, acquiring the program code for generating the first component model, and running the program code to obtain the first component model.

In some embodiments, the target database stores a plurality of data; the plurality of data are data after the original data are processed by using a preset tool, and the plurality of data comprise target business data.

In some embodiments, processing the raw data using the preset tool refers to an extract-transform-load (ETL) process of the raw data.

In some embodiments, the method further comprises: acquiring user information including an account number of a user and a corresponding password; in case that the user information has authority to upload the offline file, a comma separated value (comma-SEPARATED VALUES, csv) file for uploading the csv file including the target service data is displayed. The method for acquiring the target service data from the target data source specifically comprises the following steps: and acquiring the csv file through uploading the page, and acquiring the target service data from the csv.

In some embodiments, the method further comprises: receiving and storing a plurality of offline files determined according to a preset file template; information of a plurality of offline files is displayed through an electronic billboard.

In some embodiments, the method further comprises: determining a first component for reflecting the distribution of the first service data; and in response to the third operation, establishing an association relationship between the target component and the first component. The method for displaying the target component in the electronic billboard specifically comprises the following steps: and displaying the target component and the first component in the electronic billboard according to the association relation between the target component and the first component.

In another aspect, a determination apparatus for an electronic billboard is provided. The method is applied to the electronic equipment. The electronic device is used for determining an electronic billboard. The processing device comprises: the device comprises a determining unit, an acquiring unit and a processing unit.

A determination unit configured to: a target data source for acquiring target traffic data is determined.

An acquisition unit configured to: and responding to the first operation, acquiring a first component model, and configuring attribute information of the first component model to obtain a target component model.

An acquisition unit further configured to: and responding to the second operation, acquiring target service data from a target data source, and associating the target service data with a target component model to obtain a target component for reflecting the distribution condition of the target service data.

And the display unit is used for displaying the target component in the electronic billboard.

In some embodiments, 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, and the obtaining unit is specifically configured to: in response to the second configuration operation, obtaining target business data from a target database associated with the electronic device; or responding to the second uploading operation, obtaining an offline file, and analyzing the offline file to obtain the target service data.

In some embodiments, the apparatus further comprises a processing unit, the target data source comprises a target database or an offline file, the obtaining unit is further configured to: a first link indicating a target database is obtained. A processing unit configured to: and establishing a connection with the target database according to the first link.

In some embodiments, the target data source is an offline file, and the processing unit is configured to: in response to the third configuration operation, the target data source is set as an offline file.

In some embodiments, the first operation includes a first selection operation or a first call operation, the obtaining unit being specifically configured to: in response to a first selection operation, acquiring a first component model from a plurality of component models preconfigured by the electronic equipment; or responding to the first calling operation, acquiring the program code for generating the first component model, and running the program code to obtain the first component model.

In some embodiments, the acquisition unit is further configured to: acquiring user information including an account number of a user and a corresponding password; in case the user information has the right to upload the offline file, the csv file is displayed for uploading the csv file, which includes the target service data. An acquisition unit further configured to: and acquiring the csv file through uploading the page, and acquiring the target service data from the csv.

In some embodiments, the determining unit is further configured to: determining a first component for reflecting the distribution of the first service data; and in response to the third operation, establishing an association relationship between the target component and the first component. A display unit specifically configured to: and displaying the target component and the first component in the electronic billboard according to the association relation between the target component and the first component.

In yet another aspect, a determination apparatus for an electronic billboard is provided that includes a processor and a communication interface. The communication interface is coupled to the processor. The processor is configured to execute a computer program or instructions to implement the first aspect or the determining method of any embodiment of the first aspect.

In yet another aspect, a computer-readable storage medium is provided. The computer readable storage medium stores computer program instructions that, when run on a computer (e.g., an electronic device), cause the computer to perform a method of determining as described in any of the embodiments above.

In yet another aspect, a computer program product is provided. The computer program product comprises computer program instructions which, when executed on a computer (e.g. an electronic device), cause the computer to perform a method of determining as described in any of the embodiments above.

In yet another aspect, a computer program is provided. The computer program, when executed on a computer (e.g., an electronic device), causes the computer to perform the determination method as described in any of the embodiments above.

Drawings

In order to more clearly illustrate the technical solutions of the present disclosure, the drawings that need to be used in some embodiments of the present disclosure will be briefly described below, and it is apparent that the drawings in the following description are only drawings of some embodiments of the present disclosure, and other drawings may be obtained according to these drawings to those of ordinary skill in the art. Furthermore, the drawings in the following description may be regarded as schematic diagrams, not limiting the actual size of the products, the actual flow of the methods, the actual timing of the signals, etc. according to the embodiments of the present disclosure.

FIG. 1 is a block diagram of an electronic billboard development system in accordance with some embodiments;

FIG. 2 is a schematic diagram of an electronic billboard development page in accordance with some embodiments;

FIG. 3 is a schematic diagram of user demand information according to some embodiments;

FIG. 4 is a block diagram of an electronic billboard development system in accordance with some embodiments;

FIG. 5 is a schematic diagram of an electronic device according to some embodiments;

FIG. 6 is a flow chart of a method of determining an electronic billboard in accordance with some embodiments;

FIG. 7 is a flowchart illustration of a task execution according to some embodiments;

FIG. 8 is a flow diagram of task extraction according to some embodiments;

FIG. 9 is a schematic diagram of a task extraction according to some embodiments;

FIG. 10 is a schematic diagram of an assembly according to some embodiments;

FIG. 11 is a schematic diagram of an electronic billboard development page in accordance with some embodiments;

FIG. 12 is a schematic diagram of another electronic billboard development page in accordance with some embodiments;

FIG. 13 is a schematic diagram of another electronic billboard development page in accordance with some embodiments;

FIG. 14 is a schematic structural view of a determining device of an electronic billboard in accordance with some embodiments;

Fig. 15 is a schematic structural view of a determining device of an electronic billboard according to some embodiments.

Detailed Description

The following description of the embodiments of the present disclosure will be made clearly and fully with reference to the accompanying drawings, in which it is evident that the embodiments described are only some, but not all, of the embodiments of the present disclosure. All other embodiments obtained by one of ordinary skill in the art based on the embodiments provided by the present disclosure are within the scope of the present disclosure.

Throughout the specification and claims, unless the context requires otherwise, the word "comprise" and its other forms such as the third person referring to the singular form "comprise" and the present word "comprising" are to be construed as open, inclusive meaning, i.e. as "comprising, but not limited to. In the description of the specification, the terms "one embodiment", "some embodiments (some embodiments)", "exemplary embodiment (exemplary embodiments)", "example (example)", "specific example (some examples)", etc. are intended to indicate that a particular feature, structure, material, or characteristic associated with the embodiment or example is included in at least one embodiment or example of the present disclosure. The schematic representations of the above terms do not necessarily refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics may be combined in any suitable manner in any one or more embodiments or examples.

The terms "first" and "second" are used below for descriptive purposes only and are not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defining "a first" or "a second" may explicitly or implicitly include one or more such feature. In the description of the embodiments of the present disclosure, unless otherwise indicated, the meaning of "a plurality" is two or more.

In describing some embodiments, expressions of "coupled" and "connected" and their derivatives may be used. For example, the term "connected" may be used in describing some embodiments to indicate that two or more elements are in direct physical or electrical contact with each other. As another example, the term "coupled" may be used in describing some embodiments to indicate that two or more elements are in direct physical or electrical contact. However, the term "coupled" or "communicatively coupled (communicatively coupled)" may also mean that two or more elements are not in direct contact with each other, but yet still cooperate or interact with each other. The embodiments disclosed herein are not necessarily limited to the disclosure herein.

At least one of "A, B and C" has the same meaning as at least one of "A, B or C" and includes the following combinations of A, B and C: a alone, B alone, C alone, a combination of a and B, a combination of a and C, a combination of B and C, and a combination of A, B and C.

"A and/or B" includes the following three combinations: only a, only B, and combinations of a and B.

As used herein, the term "if" is optionally interpreted to mean "when … …" or "at … …" or "in response to a determination" or "in response to detection" depending on the context. Similarly, the phrase "if determined … …" or "if a [ stated condition or event ] is detected" is optionally interpreted to mean "upon determination … …" or "in response to determination … …" or "upon detection of a [ stated condition or event ]" or "in response to detection of a [ stated condition or event ], depending on the context.

The use of "adapted" or "configured to" herein is meant to be an open and inclusive language that does not exclude devices adapted or configured to perform additional tasks or steps.

In addition, the use of "based on" is intended to be open and inclusive in that a process, step, calculation, or other action "based on" one or more of the stated conditions or values may be based on additional conditions or beyond the stated values in practice.

The following explains terms related to the embodiments of the present application, so as to facilitate the understanding of readers.

Electronic billboard: the method can also be called as an electronic data billboard and an electronic data report, is a data visualization display mode, and is widely applied to production and management of manufacturing factories. The electronic data billboard can display the data analysis result in a visual mode according to the requirements of specific application scenes of users. For example, the content of the electronic data sign may include a plurality of components. The component is associated with data. For example, the types of components may include form class components, image class components (e.g., bar graphs, line graphs, etc.), bulletin type components (e.g., bulletin boards, notification boards, etc.). The electronic billboard can also update data in real time to facilitate the user's understanding and analysis of the production of the product. For example, the electronic device can vividly display the data analysis result in forms of tables, tree diagrams, components, line drawings and the like.

In one example, an electronic data sign may employ a process that may include collection of data, processing and storage of data, visual presentation of data (or visual presentation of components). The following embodiments describe the application process in detail, and are not described here again.

In one possible implementation, the electronic data sign may be provided with software tools (e.g., TIBCO Spotfire, fineReport, etc.). However, the users of these software need to have code development bases and experience, that is, high demands on users, and increase the use bases. Furthermore, the development difficulty of the electronic data billboard is increased. Therefore, the design of the electronic data signboard has low development difficulty, and is used for expanding the application scene of the electronic data signboard.

In one embodiment, as shown in fig. 1, an electronic billboard system is provided in an embodiment of the 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, respectively.

1. And a frame layer.

The framework layer may be in communication with the cloud platform, e.g., the framework layer may perform business processes through the cloud platform. The framework layer may include terminals, hardware resources, virtualization platforms, and virtual desktops. The framework layer may be used for security maintenance (e.g., document protection and behavior management), management of virtual desktops, hardware resources, etc. The frame layer may include a front end frame and a rear end frame.

The front-end framework can use a Vue framework or an Angular framework to realize visualization and separation of data and structures.

The back-end framework may use a Spring Boot framework or a Spring model view control layer (Model Views Controller, MVC) framework or a Mybatis framework. Wherein SPRING MVC is a software design specification, codes can be organized by business logic, data, display separation methods.

Wherein, model: the data model provides the data to be presented, and thus contains data and behavior, namely the Dao layer and the Service layer.

View (View) is responsible for model presentation, typically what we see, is the user interface we see.

Controller (Controller): receiving a user request comprising data, and inputting the data into a preset model for processing (state change) to obtain a corresponding data processing result; and returning the data processing result to the view for displaying the view.

SPRINGMVC features: the weight is light, and the method is simple and easy to learn; an efficient, request response based MVC framework; good compatibility with Spring, and seamless combination; the convention is better than the configuration; powerful functions. Spring's web framework is designed around DISPATCHERSERVLET (schedule Servlet).

2. And a data layer.

The data layer is used for realizing data collection of the equipment end (or the data source) and managing the database.

Wherein, data acquisition can be through the ETL tool. The type of database may include oracle, mySQL, postgerSQL, etc.

The data layers may include a manufacturing execution system (manufacturing execution system, MES) database, an operations data layer (operational data store, ODS) database, a manufacturing data warehouse (manufacturing data warehouse, MDW) database.

Wherein the MES database can be in communication with the production facility. The MES database can be used to store manufacturing data for the production facility, such as product quantity, product yield, production efficiency, etc.

It should be noted that, in order to ensure the security and reliability of the data, the MES database may be provided with rights or protection measures. That is, the MES database cannot perform operations such as adding, deleting, modifying, querying and the like on stored data under the condition that an operator has no authority.

The ODS database can be used to store raw data. The data in the ODS database is consistent with the data produced by the source system. For example, ODS data can be extracted from the MES database and stored. Data in the production and manufacturing process is summarized, stored and analyzed. That is, the ODS database can backup data in the MES database. Thus, the problem of abnormal data caused when the data of the MES database is lost and tampered can be avoided. In addition, since the data in the ODS database cannot be added, deleted, modified and queried, if the MES database and the MDW database are directly connected, the data may still be unprocessed when entering the MDW database, so that the problem of data disorder occurs when the data is acquired from the MDW database later, and therefore, by setting the ODS database between the MES database and the MDW database, the data can be summarized and analyzed in the ODS database, and then the summarized and analyzed data is stored in the MDW database, so that the data stored in the MEW database is summarized and analyzed data, and the related data can be quickly queried when the electronic billboard generating assembly is generated later.

And the MDW database is used for summarizing, storing and analyzing data in the production and manufacturing process. That is, the MDW database may sort and aggregate the data in response to the user's operation, resulting in a plurality of types of data tables. The data in the data table may be used for subsequent data sources and data bases.

3. And a service layer.

The service layer is mainly used for managing functional interfaces, data sources, development of components, user information and the like.

The data sources may include databases and CSV files, among others. The user information may include rights of the user, account information of the user (such as account number and password). The programming language for the development of the components may be java, SQL, etc.

The service layer may also be implemented to provide communication services. For example, the service layer may employ transmission control protocol/Internet protocol (transmission control protocol/internet protocol, TCP/IP). The device-to-database communication may employ high-speed messaging services (HIGH SPEED MESSAGE SERVICES, HSMS), tibco, file transfer protocol (FILE TRANSFER protocol, FTP), and the like.

In one example, a service layer may be provided with a development page. The above-described functions of the service layer can be implemented based on the development page.

For example, as shown in fig. 2 a, a development page is provided in an embodiment of the present application. The development page may include large screen development, data source management, decision platform management, user management, role management, system setup.

The large screen development can respond to the operation of a developer to manage the electronic billboard. For example, the operations may include operations of creating, editing, previewing, copying, downloading, publishing, deleting electronic signs, and the like.

Data source management may manage data sources in response to developer operations. Such as establishing a connection with a database, editing a connection with a database (e.g., modifying a link to an associated database, etc.), managing a CSV file, etc.

The decision platform management may manage the electronic signage in response to a policy entered by the developer. For example, an electronic device displaying an electronic billboard, a duration of the electronic billboard display, etc. may be determined.

User management may be used to manage information of users. For example, it may be used to manage the user's account and rights.

Role management can be used to configure the rights of a user. Different users may configure different rights. The rights may include whether the offline file may be uploaded, whether the electronic billboard may be modified, and so forth.

The system settings may be used to set the general functions of the electronic sign. For example, a title display effect of an electronic billboard or the like may be provided.

In yet another example, as shown in b of fig. 2, an electronic billboard development page is provided in an embodiment of the application. The electronic billboard development page may be a page that the electronic device displays in response to clicking on the "large screen development" operation in fig. 2 a. The electronic billboard development page may be used to develop components.

As shown in b of fig. 2, the electronic billboard development page may include a plurality of regions, each region corresponding to a different function. For example, the plurality of regions may include a component region, a layer region, a development region, a configuration region, an interaction region, a control region. The functions of these areas are described below, respectively.

1. Component area. The component area may be used to display multiple component models. For example, the component model may include an icon component, a text component, and the like.

In one example, an electronic device may display a plurality of component models in a component area in response to a drag operation on the component models in a development area and display names of the component models in a layer area.

2. Layer region. The layer area may be used to manage components in the development area. For example, when a component in a development area is selected or clicked on, a layer area may expose information for the component. The layer region may rename components, rank the hierarchical relationship of components, copy components, delete components, etc., in response to an operation.

3. Development area. The development area may be used to display the model of the component/style of the component. The development area can also modify and configure the component model.

4. The region is configured. The configuration area may be used to configure the component. For example, the properties of the components (properties in the correspondence map), the data of the components (data in the correspondence map), and interactions between the components (interactions in the correspondence map) may be modified, and so on. The specific content displayed by different components is different, and the content displayed by the components can be set through the configuration area.

The attribute is mainly used for setting the position and the size of the component in the electronic billboard, the style attribute of the component, the configured data and the like.

The data is mainly used for setting data source types, data and data formats of the components, API call background interfaces, CSV file use imported data sources and the like.

In one example, the electronic billboard may obtain data from a database via SQL and associate the data with the component. For example, an input box may be provided under the data in the configuration area, which may be used to input SQL.

The interaction is mainly used for setting according to the functions of the components.

5. Interaction area. The interaction area can manage a component area, a layer area and a configuration area. For example, the interaction area may be provided with buttons for component pickup, layer pickup, configuration pickup, etc. In response to clicking the button, the electronic billboard development page may collapse or expand the area corresponding to the button. For example, when an electronic billboard develops a page display component area, the component area may not be displayed in response to clicking component stowage. Next, in response to clicking the component charge again, the electronic development page may redisplay the component area.

Further, the interaction region may also be used to enable interactions between multiple components. For example, the electronic device may dynamically display the target business data obtained by the electronic device including screening conditions (product name, production time), that is, the electronic device may dynamically display the data through a broken line bar graph. For example, the electronic device may associate the filter box with the polyline bar graph in response to a user's association operation in the interaction region. That is, after the electronic billboard displays the screening frame, the polyline bar graph corresponding to the product name in the screening frame can be automatically displayed. The polyline bar graph may be composed of product names and corresponding production times (e.g., product names on the horizontal axis and production times on the vertical axis).

6. And (5) controlling the area. The control area may be used to manage the content of the electronic development page. The control area may be provided with buttons for return, preview, publish, etc. Wherein in response to the click return, the electronic device may return to the page shown in a of fig. 2. In response to clicking on the preview, the electronic device may display a preview page. The preview page may display components of the development area. In response to clicking on the post, the electronic device may display a window that determines whether to post.

4. An application layer.

The application layer may be used to manage the application scenarios of the electronic signage. For example, the application layer may enable development and management of electronic signs through development tools. The development tool may refer to the following description, and will not be described herein.

For example, as shown in fig. 3, for a manufacturing plant, actual business requirements of the manufacturing plant may include user requirements for various aspects of personnel (e.g., plant park management, vendor management, employee management, etc.), machines (e.g., equipment alarm handling, equipment maintenance and spare part management, equipment generation status management, equipment utilization monitoring, etc.), materials (e.g., end product management, warehouse location management, log management, etc.), methods (e.g., production plans and actual results, sales plans and actual results, SPC systems, ex-pass management, etc.), loops (e.g., water-gas stability, water-gas usage, green product management, etc.), measurements (e.g., failure analysis, yield daily, process control, OQA shipment inspection, etc.), manufacturing (e.g., investment, output, discard, control (hold), etc. (etcetera, etc.) out, work in progress, WIP), movement (Movement), ETC. Correspondingly, the electronic billboard can set an application scene and display components of the corresponding type of the application scene according to the requirements of users. Such as text boxes, drop-down boxes, polyline bar graphs, tables, pie charts, radar charts, and the like.

Where hold may refer to retention at the current site because of the risk of the product. Movement may refer to the quantity of product produced by a site over a period of time. WIP refers to the currently manufactured product, the products that are put in and not scrapped, and the products that are produced are all in-process. ETC out refers to other uses. For example, because of analytical verification, it is necessary to apply for products to be taken out of the production line.

The following describes embodiments of the present application in detail with reference to the drawings.

As shown in fig. 4, an electronic billboard development system provided in an embodiment of the application may include a data source, a component development platform, and an electronic billboard development platform. The component development platform is connected with the electronic billboard development platform. For example, the component development platform may be provided with a functional interface. The functional interface can be connected with an electronic billboard development platform.

Wherein the data source is the data source and basis of the electronic billboard development system. The data source may be coupled to a database. The database may store processed data. In particular, reference may be made to the above description, which is not repeated. Offline files may refer to data that is not stored to a database and that needs to be passed through an electronic billboard.

For example, the data sources may include databases, storage devices for storing offline files/interfaces for retrieving offline files, and the like. For the description of the database, reference may be made to the description of the database below.

It should be noted that, in the embodiment of the present application, the components may include complex components and simple components. Wherein, simple components can be realized by SQL in an electronic billboard development page. The complex components cannot be realized in the electronic billboard development page through SQL, and are required to be developed through a development component platform.

Component development platforms can be used for the development of complex components. For example, the development platform may obtain data associated with the component from a database in response to the entered code, thereby generating a corresponding component. Component development can also be used to verify the functionality of a component through interface testing. The component development platform may also send complex components to the electronic billboard development platform via the functional interface.

The electronic billboard development platform, which may also be referred to as an electronic billboard system platform, may be used to develop electronic billboards.

In one example, as shown in FIG. 4, the electronic billboard development platform may include an electronic billboard development page, a data source management module, a rights management model, a user management module.

The electronic billboard development page may include the pages shown in fig. 2a and b, among others. The data source management module may be used to manage databases and offline files. The rights management module may be used to manage the rights of the user. The user management module may be used to manage information about the user (e.g., the user's account number and password, etc.).

In some embodiments, as shown in fig. 5, fig. 5 is a schematic structural diagram of an electronic device according to an embodiment of the present application. The electronic device may have a display 510 and a processor 520, a graphics processor (graphics processing unit, GPU) 530. Display 510 may be communicatively coupled to processor 520, GPU 530. For example, the display 510 and the processor 520 may be connected by a system bus 530. Processor 520 may be communicatively coupled to a GPU.

Wherein the display 510 may include a display screen/screen or the like. The display 510 may be used to display an electronic billboard. For example, the display may be a Liquid Crystal Display (LCD) CRYSTAL DISPLAY, an organic light-emitting diode (OLED) display, or the like.

The processor 520 may include one or more central processing units (Central Processing Unit, CPU), among others. The CPU may be used to process data and perform operations of the electronic device in embodiments of the present application. For example, operations on electronic signage development pages, and the like.

The following describes a management method of an electronic billboard provided in an embodiment of the present application with reference to an electronic device shown in fig. 5.

As shown in fig. 6, the method for managing an electronic billboard according to the embodiment of the application can be applied to the electronic device shown in fig. 5. The method may include S601 to S604.

S601, determining a target data source.

Wherein the target data source may be used to obtain target business data. The target business data may be data that is to be presented in an electronic billboard. For example, the target business data may be data of a manufacturing plant. Such as worker data, equipment data, material data, manufacturing data, inspection data, environmental data, and the like.

In one example, the target data source may include a database, an offline file. The target service data may be data in a database or may be data in an offline file uploaded by the user.

For example, the electronic device may obtain the target service data from the associated target database, or may obtain an offline file in response to the uploading operation, and parse the offline file to obtain the target service data.

The target database may store a plurality of data, which may be processed data. The data in the target database may be processed data. The processed data may refer to the data processed using the ETL tool described above. The target database may be an MDW database.

ETL may be used to describe the process of extracting, converting, and loading data from a data source to a destination. For example, the electronic device may use the ETL tool to extract the desired data from different data sources (which may be production devices), clean and convert the extracted data, and then load the cleaned and converted data into a database. The ETL tool can perform the functions of the ETL. For example, the ETL tool can be an application program, or can be a device that can perform the function, without limitation.

It should be noted that, in the embodiment of the present application, after the electronic device obtains the offline file uploaded by the user, the offline file may be stored. For example, the data may be stored in a database (such as a target database), or may be stored in a configured memory (such as a hard disk, a memory, etc.).

In connection with a of fig. 2, the electronic device may determine a target data source in response to clicking on the data source management.

In one example, if the target data source is a target database, the electronic device may obtain a first link for indicating the target database, and establish a connection with the target database according to the first link.

Wherein the first link may be used to indicate a name, address, etc. of the target database. The first link may be a link edited by a user at an input box of the data source. For example, the first connection may include a name, identification, number, etc. of the target database.

In yet another example, if the target data source is an offline file, the electronic device may set the target data source to the offline file in response to the third configuration operation.

Wherein the offline file may include target business data. For example, the offline file may be a csv file. The third configuration operation may be an operation of a type of data source selected by a user at an input box of the data source.

In one example, in connection with the system shown in fig. 1, the target database may be an MDW database in the data layer. The process of storing the target business data into the MDW database may include two extraction processes of extracting the production data stored in the MES database into the ODS database and extracting the data in the ODS database into the MDW on demand.

The extraction of data may include real-time data synchronization extraction and timing data extraction.

In one example, to enable extraction of data, an ogg+kafka approach may be used for real-time data synchronization extraction. An ETL tool may be used for timing data extraction. Ogg+kafka can be referred to the prior art and will not be described in detail. The ETL tool may refer to the description of the ETL described above, and will not be repeated.

In one example, the manner in which the electronic device uses the ETL tool to extract data is described by taking the example in which the data layer includes the MES database, the ODS database, and the MDW database.

In one possible embodiment, when the plurality of databases are applied to the production system, the electronic device may use the ETL tool to extract the production data stored in the MES database, and then process the production data and store the extracted production data in the ODS database. Then, the electronic device can continue to store the integrated production data of the ODS database into the MDW database in an ETL mode and the like, so that the process from production operation to data analysis of the production data is completed.

It should be noted that, in the embodiment of the present application, the electronic device may be communicatively connected according to a plurality of databases of the data layer. For example, the electronic device may monitor the storage status of multiple databases.

In one example, the ETL tools may include Pentaho Kettle tools, data integration platform (Informatica PowerCenter) tools.

The process of data extraction by the electronic device using these two tools will be described below.

1. The electronic device uses Pentaho Kettle tools for data extraction.

Wherein Pentaho Kettle tools may be used to perform the extraction tasks of table inputs and table outputs. For example, as shown in fig. 7, the process may include: start task→task execution (including deleting task, executing task) →task success.

Wherein the electronic device may set the timed task before starting the task. The timed task may have a unique task name. For example, the timed task may run in the form of a database ETL timed scheduled task table. The task table may be used for the content of the database ETL timing schedule.

As shown in fig. 8a, is a schematic diagram of one operational process of the tool.

As shown in fig. 8 b, an interface is provided for the tool. The setup interface may be used to set up step names, database names (database connections), input structured query language (Structured Query Language, SQL).

As shown in fig. 8 c, an interface is provided for the tool. The setup interface may be used to set up task names, database names (database connections), SQL (SQL file names), SQL, etc. in the task table.

The task table may also include the time of data extraction, the frequency of data extraction, and the status of the task.

When the electronic device executes the timed task, a start time and an end time of the task in the task table may be obtained from the task table. In running a task, the electronic device may extract data during a period of time between a start time and an end time. After the task is successfully executed, the electronic device can update the time, state and other contents of the task table for executing the timing task next time.

In one example, the electronic device, when performing data extraction, may include both full extraction and incremental extraction. The electronic device can set the timing task according to the number of the service data of the task and the real-time requirement. For example, summary data may be extracted on an hourly, daily, specified time period basis.

2. The electronic device uses Informatica PowerCenter tools for data extraction.

Wherein Informatica PowerCenter tool is a tool for extracting enterprise-level big data.

As shown in fig. 9 a, powerCenter Designer tool can select a database driver and source configuration to import tables from the database and connect to the database setup ODBC data source according to the setup, and import the required source tables and target tables according to the development requirements.

The Informatica PowerCenter tool is also used to create a Mapping (Mapping). For example, informatica PowerCenter tools may move the source and target tables to MAPPING DESIGNER workspaces and establish links to fields in response to the operations.

Wherein the source SQ component in Informatica PowerCenter tool can be used to write SQL for data extraction. If the ETL scheduling task is timed, time parameters need to be created in Mapping, and parameter filtering is used in SQL to realize increment extraction.

For example, the "attribute" - "Pre SQL" of each Mapping target component in Informatica PowerCenter tools may be used to configure time parameters, delete target table corresponding interval data. In this way, repeated writing of data can be avoided. The "attribute" - "Post SQL" of each Mapping target component in Informatica PowerCenter tools may be used to configure field data updates for the ETL job table. The per Session (Session) attributes of the Informatica PowerCenter tool may be used to configure the read path of the parameter file.

Based on the above operations, the electronic device may save mapping, generating a workflow.

As shown in b of fig. 9, informatica PowerCenter tool may conduct a Session (Session) configuration in response to a first operation by the user.

For example, the first operation may include opening a Workflow Manager (Workflow Manager), dragging the created session into Task development (Task development), editing an attribute input parameter file address of the session, configuring connection information of the source and the target, and the like.

As shown in b of fig. 9, informatica PowerCenter tool may also create a Workflow (Workflow) in response to a second operation by the user.

Wherein the second operation may include opening a Workflow designer (Workflow Designer), creating a Workflow, linking a "Start" with a dragged "session" to be run in a Workflow workspace, and the like.

As shown in fig. 9 c, informatica PowerCenter tool may also run the workflow in response to a third operation by the user.

Wherein the third operation may include clicking on "launch Workflow", opening a Workflow Monitor (Workflow Monitor). Monitor can be used to display workflow, session execution, log information, data statistics.

The electronic device may also display log information in response to a user clicking on "get session log" to facilitate the user's view of specific error information.

S602, responding to a first operation, acquiring a first component model, and configuring attribute information of the first component model to obtain a target component model.

Wherein the first operation may include a first selection operation or a first call operation. The first selecting operation may refer to an operation of selecting a component model satisfying a user's demand from among a plurality of component models. The first call operation may refer to an operation of acquiring program code for generating the first component model. The first component model may be preconfigured for the electronic device, for example, may be a component model in the component area in b of fig. 2 (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) that the electronic device generates by invoking and running program code.

In one example, when the target data source is a database, the electronic device may obtain a first component model from a plurality of component models preconfigured by the electronic device in response to the first selection operation.

For example, in connection with the electronic billboard development page shown in b of FIG. 2, the plurality of component models may be a plurality of component models displayed in a component area. Invoking the operation may refer to an operation of dragging the component model in the component area to the value component development area. The first component model may be a component model in a component area.

In yet another example, when a component model in a component area fails to meet a demand, such as a component model in a component area, there is no component model in a certain data format. For example, there is no component model for a time state diagram showing device utilization. The electronic device may obtain program code for generating the first component model in response to the first call operation, and run the program code to obtain the first component model.

For example, in connection with the system shown in FIG. 4, the electronic device may obtain program code from the component development platform for generating the first component model.

It should be noted that, the equipment utilization rate refers to that the component requirement displays different utilization states of each production equipment according to time sequence. The electronic device needs to acquire the start and end times of the production device in different states and arrange them in time order.

Wherein, the attribute information of the first component model may include a position, a size, a margin, a parameter, etc. of the first component model in the electronic billboard. The parameters may be in the form of lines or patterns of the component model, etc. For example, parameters of the fold bar graph may include line color, line thickness, line solidity, pattern fill color, pattern shape (e.g., histogram, etc.) of the fold bar graph. Parameters of the coordinate axes may include patterns of the X-axis and the Y-axis (e.g., shape of arrow, thickness of line, color, etc.).

In a possible implementation manner, in conjunction with the electronic billboard development page shown in b of fig. 2, the electronic device may respond to the setting operation on the attribute item in the configuration area, and may implement configuration on attribute information of the component model, to obtain the target component model.

In one example, the target business data is power data. And when the user demands, the electric quantity in the plurality of time periods is displayed in the electronic billboard through the line graph. In connection with the electronic billboard development page of fig. 2b, the electronic device may display a multi-line drawing in the component development area in response to the drag operation. Meanwhile, the name of the multi-line graph may be displayed in the layer area. The electronic device may display configuration information (attributes, data, interactions) of the multi-line graph in the configuration area in response to an operation of clicking on the multi-line graph of the development area. Further, the electronic device may adjust attribute information (e.g., display position, margin, title, scale, etc.) of the multi-line graph in response to an adjustment operation of the attribute in the configuration region. Thus, a target component model corresponding to the electric quantity data can be obtained.

S603, responding to the second operation, obtaining target service data from a target data source, and associating the target service data 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 developing page configuration call code through the electronic billboard. The second uploading operation may refer to an operation of uploading the offline file. The target component may be configured to reflect the distribution of the target business data.

In one example, when the target data source is a database, the second configuration operation may be an operation to input SQL. For example, in connection with the electronic development page shown in b of fig. 2, the second configuration operation may refer to an operation of inputting SQL through an input box under the data of the setting area. In response to the second configuration operation, 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.

In still another example, when the target data is an offline file, the second uploading operation may refer to an operation of uploading the offline file. For example, in connection with the electronic development page shown in b of fig. 2, the second uploading operation may refer to an operation of uploading an offline file through an uploading frame under the data of the setting area. For example, the electronic device may display an upload page in response to clicking on the upload frame, which may be used to upload an offline file. After the electronic device obtains the offline file, the electronic device can analyze the offline file to obtain target service data, and associate the target service data with the target component model to obtain the target component.

Further, in order to ensure the security of the offline file, the offline file may be an encrypted file. After the electronic device obtains the encrypted file, the electronic device can decrypt according to the configured decryption key to obtain the target service data.

In yet another example, the electronic device may obtain user information. For example, in response to a login operation, the user may enter the user's account and password through a login interface. In the case that it is determined that the user information has authority to upload the offline file, the electronic device may display the upload page. The upload page may be used to upload csv files or offline files. In response to the upload operation, the electronic device may obtain a csv file including the target business data.

Wherein the csv file may be determined from a file of a pre-model. That is, the electronic device may first output a file in a preset format, for the user to fill in the service data according to the preset format of the file. After completion of the filling, the user may upload the csv file including the target service data through the upload page. After receiving the csv file, the electronic device may store the csv file in a database or other memory.

Wherein, the electronic device associating the target service data with the target component model may refer to configuring the target component model by using the target service data as a configuration parameter. For example, the target component model is a group histogram. The abscissa of the grouped histograms is the attribute name represented by each histogram, and the ordinate represents the data corresponding to the attribute.

In one example, in combination with the example in S602, the power data is power usage for a plurality of months. For example, the power data may be the data shown in table 1. The power data may include power usage for each of 1-6 months. The attribute name of the electric quantity data is month, and the data corresponding to the attribute is the electric quantity corresponding to each month.

TABLE 1

Month of month	1 Month	2 Months of	3 Months of	4 Months of	5 Months of	6 Months of
Electricity consumption	600	610	700	720	720	710

It should be noted that the data in table 1 is only exemplary, and other data may be used without limitation.

In connection with the electronic billboard development page in fig. 2 b, the first component model is a bar graph. The electronic device can drag the grouped histogram in the component area to the component development area in response to the invoking operation. The electronic device may display the names of the grouped histograms in the layer area and the attribute information (attribute, data, interaction) of the grouped histograms in the setting area in response to an operation of clicking the grouped histograms in the development area.

The electronic device modifies the names of the group bar charts in the layer areas (such as the power consumption of 1-6 months) in response to the modification operation, and modifies the attribute information of the group bar charts (such as the number of bar charts, the month corresponding to each bar chart, the width of each bar chart, the filling color, the position of each bar chart on the X axis, the numerical distribution of the Y axis and the like) in response to the operation in the setting area.

The electronic device obtains SQL in response to an operation of SQL input by an input box under data in the configuration area. The electronic device runs SQL and can adjust the height of each bar graph in the grouped bar graphs. The value of the Y period corresponding to the height of the adjusted bar graph is the electricity consumption of the month. For example, the adjusted group histogram (i.e., target component) may be as shown in FIG. 10.

In another example, when the target data source is an offline file, the electronic device may parse the offline file after obtaining the offline file to obtain target service data, and associate the target service data with the target component model to obtain the target component.

For example, if the target component model is a bulletin board, after the electronic device obtains the target service data from the stored csv file, the electronic device may modify the name field of the bulletin board into the name of the target service data, and display the target service data in the display frame of the bulletin board, so as to obtain the bulletin board component.

In yet another example, when the target business data includes multiple types of data, that is, the target business data corresponds to multiple component models, the multiple component models may be the same or different in type. In this case, the electronic device may separately determine components to which each type of data corresponds.

In the case that the plurality of types of data have an association relationship, the electronic device may also set a hierarchical relationship or an association relationship of components corresponding to the plurality of types of data in response to the interactive operation.

Wherein, the hierarchical relationship may refer to a hierarchical relationship of a plurality of components on the electronic billboard. The association relationship may refer to an order in which the electronic device displays the plurality of components. For example, component 1 is associated with component 2. The electronic device may display the component 2 in a pop-up window in response to clicking on the component 1 or a certain data in the component 1.

In one example, in connection with the electronic billboard development page shown in b of fig. 2, the electronic device may set the association between the target component and the other components in response to an operation under the interaction of clicking the configuration area.

For example, the electronic device may determine the first component. The method for determining the first component may refer to the method for determining the target component, which is not described in detail. The first component includes traffic data that is different from the data of the target component. The type of the first component may be the same as or different from the type of the target component. The electronic device may establish an association relationship between the target component and the first component in response to the association operation. The association operation may be an operation in which the user establishes an association relationship between the target component and the first component through interaction of the configuration area in the electronic billboard development page shown in b of fig. 2.

For another example, the electronic device can set a hierarchical relationship between the first component and the target component in the interaction region after determining the first component. Wherein the hierarchical relationship may refer to a display order of the target component and the first component. For example, the target component is located at an upper layer of the first component. The electronic billboard may display the target component after displaying the first component, and the display position of the target component is located above the first component. For example, the target component may overlay the first component or overlay a portion of the first component.

S604, the electronic device displays the target component in the electronic billboard.

Wherein after obtaining the target component, the electronic device may display the target component in an electronic billboard, or the electronic device may display an electronic billboard, which may include the target component. Of course, the electronic sign may also be provided with other components.

In one possible implementation, in connection with the electronic billboard development page shown in b of fig. 2, the electronic device may display an electronic billboard including target components in response to the click-to-post operation.

Further, in order to view the display effect of the generated target component in the electronic billboard, the electronic device may generate a preview page of the electronic billboard in response to the operation of clicking the preview. Based on the preview page, the user can see if the electronic billboard meets the requirements. Under the condition that the electronic billboard does not meet the requirements or has problems, the electronic equipment can respond to the adjustment operation to continuously adjust the components in the electronic billboard until the electronic billboard meeting the requirements of users is obtained.

In one example, the electronic device may also dynamically update the electronic billboard. For example, for dynamically changing production data, the electronic device may acquire updated production data from the target database according to a preset period, and adjust, according to the updated production data, a component for representing a distribution situation of the production data, where the adjusted component can reflect the distribution situation of the updated production data.

For example, for the component with the power consumption pair of fig. 10, when the power consumption in the target database is updated (for example, the power consumption of 7 months is increased), the electronic device may adjust the field of the component model for generating the component, where the adjusted component model includes a bar chart corresponding to 7 months. The electronic device may generate a new component based on the adjusted component model and the updated power usage.

For another example, the electronic device may directly adjust the component, for example, add a bar chart corresponding to 7 months to the component of fig. 10, and the bar chart is located after 6 months, and adjust the bar chart corresponding to 7 months to a corresponding height according to the value of the ordinate. In this way, the electronic device can obtain a new component.

In yet another example, when the target component and the first component have an association, the electronic device displays the target component and the first component according to the association. For example, after a field of a target component is clicked, the first component may be displayed.

In yet another example, when the target component and the first component have a hierarchical relationship, the electronic device may determine a display order and a display position of the target component and the first component according to the hierarchical relationship.

Of course, in the embodiment of the application, the electronic billboard may also comprise more components. For example, bulletin boards may be included. Bulletin boards may be used to display the content of the offline files. The plurality of components may be displayed on the electronic billboard dynamically or statically.

In yet another possible implementation, the electronic device, after determining the components of the electronic billboard, may send the electronic billboard to other display devices for display. For example, the electronic device may display the production data corresponding to the production plant to a display device of the production plant. The display device of the production plant may display the electronic sign after receiving the electronic sign from the electronic device.

It should be noted that, in the embodiment of the present application, the electronic device may further configure a display effect of the electronic billboard. For example, the electronic device may determine a background color, pattern, etc. of the electronic billboard based on the background configuration operation. For another example, the electronic device may also determine a dynamic display effect of the electronic billboard based on the animation configuration operation. For another example, the electronic device may also determine the voice of the electronic billboard based on the voice configuration operation.

Based on the technical solution of fig. 9, after the electronic device obtains the target service data, the electronic device may call the component model meeting the requirement from a plurality of pre-configured component models in response to the operation of the user. Then, the electronic device can adjust the attribute information of the component model to obtain a target component model, and further, the electronic device can respond to the association operation of the user to associate the target business data with the target component model to obtain the target component. Finally, the electronic device may display the target component in the electronic billboard. That is, according to the technical scheme provided by the embodiment of the application, the user can develop the component only by requiring simple operation, and the user can avoid the need of code development foundation and experience, thereby reducing the development difficulty of the electronic billboard.

In some embodiments, to avoid that component models of the component area do not exist for meeting the requirements, the electronic device may invoke code to enable development of the component models.

In one example, a development platform may be configured with development tools. The development tool may be used to develop components. For example, the development tools may include a primary development tool (e.g., maven, eclipse, STS, IDEA) and a secondary development tool (e.g., GIT for version control, postman for debugging interface data, resource tree for code management (Sourcetree), DBeaver for testing SQL).

Specifically, based on the development tool, the development flow of the component model may include:

1. background code development using Eclipse development tools.

1-1, Interface development-dao. The service (service) operates database queries by invoking dao-level methods, mainly annotating the corresponding dao with a @ Mapper (Mapper) and @ Component (Component).

1-2, Service (Service). Controllor when the Service method is called, the class written is annotated with @.

1-3, Controller (Controller). The user can determine the accessed link according to the service, and splice the path by Request Mapping (Request Mapping) +get (POST) Mapping.

Wherein the variable parameters of the address bar of the fac in (getInPutByMonth) (STRING FAC) are obtained in terms of month. The variable parameter may need to be added or modified.

1-4, Extensible markup language (eXtensible Markup Language, xml) file-sql. Identification (Identity document, id) in xml corresponds to one method of dao. Wherein xml has a unique id. The parameters of the page and method are replaced here.

2. Code and interface debugging.

Code is run in Eclipse through Debug mode, and Postman tools are used to enter the contents of the local test interface, parameter names, parameter values, etc. If the debugging operation has errors, the contents of the errors are checked and read in Eclipse, and codes are debugged and modified by a breakpoint adding method.

Looking at Postman the obtained data results, a HiJson tool can also be used to format the data results into json strings to see if the obtained data and structure meet the data structure requirements of the front page component.

3. Code submission and release deployment.

Code is pulled and submitted using Sourcetree tools. Code release may use Jenkins tools. After the local codes are packed and uploaded, the script can be executed to realize independent deployment.

4. Page development and data configuration.

In the electronic billboard development page, in response to the drag operation, the component is moved to the development area, and the attribute, data of the component are configured using an application programming interface (application programming interface, API), input interface. After the attribute information of the component is configured, data can be obtained from a database through background codes and interfaces, and the effect of the component is displayed on a page.

The method for determining the electronic billboard provided by the embodiment of the application is described below with reference to specific examples.

Example 1, the target business data is chart-like data.

In order to reduce development difficulty, the electronic device may establish a connection with the database in response to the configuration operation, and obtain SQL through the electronic billboard development page to obtain data from the database. And finally, the electronic equipment realizes the development of the chart component on the development page according to the fields of the chart component.

In particular, the electronic device may enable the development of an electronic billboard that includes a chart component through the following process.

2-1, As shown in fig. 11, the electronic device may establish a connection with the database in response to operation of the data source management interface at the electronic billboard.

Further, in response to the configuration operation, the electronic device may further configure information such as a name, a type of the data source, a data source address, a port number, a database name, a user name, and a password.

2-2, In response to the editing operation, the electronic device may configure attribute information of the component model in the component development area.

Wherein, 2-2 can refer to the description of the above embodiments, and will not be repeated.

2-3, The electronic equipment acquires SQL, acquires data from a data source according to the SQL, and configures the data into the component model.

Further, to detect SQL, the SQL editor may be tested for correctness and whether the obtained data is correct.

2-4, The electronic device may associate a plurality of components in response to the interaction.

For example, the control component displays and hides, and the drop-down box component parameters query conditions and chart results interactions.

Example 2 data source management of offline form class data.

As shown in fig. 12, for offline form class data, the electronic device may manage configuration csv files at the data source and assign user rights. In the electronic billboard development page, the data source uses csv files and configures data fields on the components.

The specific implementation flow is as follows:

3-1, preparing a data source. The electronic device may assign user rights in the electronic billboard development page. For authorized users, the file can be uploaded on a csv file management page managed by a data source. The csv file may be an encrypted file.

3-2, Developing component functions. The electronic device responds to the operation, moves the form component to a component development area, adjusts the position, the size and other attribute information of the form component model according to the configuration, and associates the target business data with the form component model to obtain a target component (namely, the target component is included). Wherein, the column key of the table group is the column name of the csv file.

3-3, Displaying the form component. The electronic device may display an effect of the form component in response to the preview operation. In the event that the form component meets the requirements, the electronic device may publish the form component. That is, the electronic device displays the form component on the electronic billboard.

Example 3, file import and interface presentation of bulletin boards.

As shown in fig. 13, the offline file uploaded by multiple users does not set user rights, and the universal function of file uploading is realized through the background code.

The specific embodiment flow is as follows:

and 4-1, acquiring an offline file. The offline file is a file determined according to a predetermined template. For example, the electronic device may 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.

4-2, In response to the uploading operation, the electronic device may obtain the offline file and include in the database in the parsing. The offline file may be an encrypted file.

4-4, The electronic device may present the uploaded file content in response to a refresh operation after generating the bulletin board.

It should be noted that, the embodiments of the present application may refer to or refer to each other, for example, the same or similar steps, and the method embodiment, the system embodiment and the device embodiment may refer to each other, which is not limited.

The embodiment of the present application may divide the functional modules or functional units of the determining apparatus according to the above method example, for example, each functional module or functional unit may be divided corresponding to each function, or two or more functions may be integrated in one processing module. The integrated modules may be implemented in hardware, or in software functional modules or functional units. The division of the modules or units in the embodiment of the present application is schematic, which is merely a logic function division, and other division manners may be implemented in practice.

Fig. 14 is a schematic structural diagram of a determining device for an electronic billboard according to an embodiment of the application, where the determining device is applied to an electronic device. The electronic device is used for determining an electronic billboard. The determining device includes: a determination unit 1401, an acquisition unit 1402, and a display unit 1403.

A determination unit 1401 configured to: a target data source for acquiring target traffic data is determined.

An acquisition unit 1402 configured to: and responding to the first operation, acquiring a first component model, and configuring attribute information of the first component model to obtain a target component model.

The acquisition unit 1402 is further configured to: and responding to the second operation, acquiring target service data from a target data source, and associating the target service data with a target component model to obtain a target component for reflecting the distribution condition of the target service data.

A display unit 1403 for displaying the target component in the electronic billboard.

In some embodiments, 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, and the obtaining unit 1402 is specifically configured to: in response to the second configuration operation, obtaining target business data from a target database associated with the electronic device; or responding to the second uploading operation, obtaining an offline file, and analyzing the offline file to obtain the target service data.

In some embodiments, as shown in fig. 14, the apparatus further comprises a processing unit 1404, the target data source comprises a target database or offline file, the obtaining unit 1402 is further configured to: a first link indicating a target database is obtained. A processing unit 1404 configured to: and establishing a connection with the target database according to the first link.

In some embodiments, the target data source is an offline file, and the processing unit 1404 is configured to: in response to the third configuration operation, the target data source is set as an offline file.

In some embodiments, the first operation includes a first selection operation or a first call operation, the obtaining unit 1402 is specifically configured to: in response to a first selection operation, acquiring a first component model from a plurality of component models preconfigured by the electronic equipment; or responding to the first calling operation, acquiring the program code for generating the first component model, and running the program code to obtain the first component model.

In some embodiments, processing the raw data using a preset tool refers to ETL processing the raw data.

In some embodiments, the acquisition unit 1402 is further configured to: acquiring user information including an account number of a user and a corresponding password; in case the user information has the right to upload the offline file, the csv file is displayed for uploading the csv file, which includes the target service data. An acquisition unit further configured to: and acquiring the csv file through uploading the page, and acquiring the target service data from the csv.

In some embodiments, the determining unit 1401 is further configured to: determining a first component for reflecting the distribution of the first service data; and in response to the third operation, establishing an association relationship between the target component and the first component. The display unit 1403 is specifically configured to: and displaying the target component and the first component in the electronic billboard according to the association relation between the target component and the first component.

In implementation, 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. A specific implementation is shown in fig. 15.

Fig. 15 shows a schematic structural diagram of still another possible communication device of the determination device involved in the above-described embodiment. The communication device includes: a processor 1502 and a communication interface 1503. The processor 1502 is configured to control and manage actions of the devices, for example, to perform the steps performed by the determining unit 1401 and the processing unit 1404 described above, and/or to perform other processes of the techniques described herein. The communication interface 1503 is used to support communication between the device and other network entities, for example, to perform the steps performed by the acquisition unit 1402 described above. The apparatus may also include a memory 1501 and a bus 1504, the memory 1501 storing the program codes and data of the apparatus.

Wherein the memory 1501 may be a memory or the like in the apparatus, which may include a volatile memory such as a random access memory; the memory may also include non-volatile memory, such as read-only memory, flash memory, hard disk or solid state disk; the memory may also comprise a combination of the above types of memories.

The processor 1502 may be a variety of exemplary logic blocks, modules, and circuits that implement or perform the description of the various embodiments described in connection with the present disclosure. 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 device, a transistor logic device, a hardware component, or any combination thereof. Which may implement or perform the various exemplary logic blocks, modules and circuits described in connection with this disclosure. The processor may also be a combination that performs the function of a computation, e.g., a combination comprising one or more microprocessors, a combination of a DSP and a microprocessor, etc.

Bus 1504 may be an extended industry standard architecture (Extended Industry Standard Architecture, EISA) bus or the like. The bus 1504 may be divided into an address bus, a data bus, a control bus, and the like. For ease of illustration, only one thick line is shown in fig. 15, but not only one bus or one type of bus.

The device in fig. 15 may also be a chip. The chip includes one or more (including two) processors 1502 and a communication interface 1503.

Optionally, the chip further includes a memory 1501, and the memory 1501 may include a read-only memory and a random access memory, and provides operating instructions and data to the processor 1502. A portion of the memory 1501 may also include non-volatile random access memory (non-volatile random access memory, NVRAM).

In some implementations, the memory 1501 stores elements, execution modules or data structures, or a subset thereof, or an extended set thereof.

In the embodiment of the present application, 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 stored therein computer program instructions that, when run on a computer (e.g., an electronic device), cause the computer to perform a method of determining an electronic textbook as described in any of the above embodiments.

By way of example, the computer-readable storage media described above can include, but are not limited to: magnetic storage devices (e.g., hard Disk, floppy Disk or magnetic strips, 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), card, stick, key drive, etc.). Various computer-readable storage media described in this disclosure may represent one or more devices and/or other machine-readable storage media for storing information. The term "machine-readable storage medium" can include, without being limited to, wireless channels and various other media capable of storing, containing, and/or carrying instruction(s) and/or data.

Some embodiments of the present disclosure also provide a computer program product, for example, stored on a non-transitory computer readable storage medium. The computer program product comprises computer program instructions which, when executed on a computer (e.g. an electronic device), cause the computer to perform the method of determining an electronic textbook as described in the above embodiments.

Some embodiments of the present disclosure also provide a computer program. The computer program, when executed on a computer (e.g., an electronic device), causes the computer to perform the method of determining an electronic textbook as described in the above embodiments.

The beneficial effects of the computer readable storage medium, the computer program product and the computer program are the same as those of the method for determining an electronic textbook according to some embodiments, and are not described herein.

In the several embodiments provided by the present application, it should be understood that the disclosed systems, devices, and methods may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is merely a logical function division, and there may be additional divisions when actually implemented, for example, multiple units or components may be combined or integrated into another system, or some features may be omitted or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be through some interface, indirect coupling or communication connection of devices or units, electrical, mechanical, or other form.

The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.

In addition, each functional unit in the embodiments of the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit.

The foregoing is merely a specific embodiment of the disclosure, but the protection scope of the disclosure is not limited thereto, and any person skilled in the art who is skilled in the art will recognize that changes or substitutions are within the technical scope of the disclosure. Therefore, the protection scope of the present disclosure shall be subject to the protection scope of the claims.

Claims

A method for determining an electronic signage, wherein an electronic device is used to manage the electronic signage, the method comprising:

Determine a target data source, where the target data source is used to obtain target business data;

In response to the first operation, a first component model is acquired, and attribute information of the first component model is configured to obtain a target component model;

In response to the second operation, the target business data is acquired from the target data source, and the target business data is associated with the target component model to obtain a target component, where the target component is used to reflect the distribution of the target business data;

The target component is displayed in the electronic signage.

The method according to claim 1, wherein the target data source includes a target database or an offline file, the second operation includes a second configuration operation or a second upload operation, and the acquiring the target business data from the target data source in response to the second operation includes:

In response to the second configuration operation, acquiring the target service data from a target database associated with the electronic device; or,

In response to the second upload operation, the offline file is obtained, and the offline file is parsed to obtain the target business data.

The method according to claim 2, wherein the target data source is the target database, and the method further comprises:

Acquire a first link, where the first link is used to indicate the target database;

According to the first link, a connection with the target database is established.

The method according to claim 2, wherein the target data source is the offline file, and the method further comprises:

In response to a third configuration operation, the target data source is set to the offline file.

The method according to any one of claims 1 to 4, wherein the first operation comprises a first selection operation or a first call operation, and the acquiring the first component model in response to the first operation comprises:

In response to the first selection operation, acquiring the first component model from a plurality of component models pre-configured in the electronic device; or,

In response to the first calling operation, a program code for generating the first component model is acquired, and the program code is executed to obtain the first component model.

According to the method according to claim 2 or 3, the target database stores multiple data; the multiple data are data obtained by processing the original data using a preset tool, and the multiple data include the target business data.

The method according to claim 6, wherein the processing of the original data using a preset tool refers to performing an Extraction-Transformation-Loading (ETL) process on the original data.

The method according to any one of claims 1 to 7, wherein the method further comprises:

Obtaining user information, wherein the user information includes the user's account number and corresponding password;

In the case where the user information has the permission to upload offline files, an upload page is displayed, where the upload page is used to upload a csv file, and the csv file includes the target business data;

The acquiring the target business data from the target data source includes:

Obtain the csv file through the upload page, and obtain the target business data from the csv.

The method according to any one of claims 1 to 8, wherein the method further comprises:

Receiving and storing a plurality of offline files, wherein the plurality of offline files are determined according to a preset file template;

The information of the multiple offline files is displayed through the electronic signboard.

The method according to any one of claims 1 to 9, wherein the method further comprises:

Determine a first component, where the first component is used to reflect the distribution of first business data;

In response to a third operation, establishing an association relationship between the target component and the first component;

The displaying of the target component in the electronic signboard includes:

According to the association relationship between the target component and the first component, the target component and the first component are displayed in the electronic signboard.

A device for determining an electronic signage, wherein the device is applied to an electronic device, the electronic device is used to manage the electronic signage, and the device comprises a determining unit, an acquiring unit, and a display unit;

The determining unit is configured to: determine a target data source, where the target data source is used to obtain target business data;

The acquisition unit is configured to: in response to a first operation, acquire a first component model, and configure attribute information of the first component model to obtain a target component model;

The acquisition unit is further configured to: in response to a second operation, acquire the target business data from the target data source, and associate the target business data with the target component model to obtain a target component, wherein the target component is used to reflect the distribution of the target business data;

The display unit is configured to display the target component in the electronic signage.

The device according to claim 11, wherein the target data source includes a target database or an offline file, the second operation includes a second configuration operation or a second upload operation, and the acquisition unit is specifically configured to:

The device according to claim 12, wherein the device further comprises a processing unit, the target data source is the target database,

The acquisition unit is further configured to: acquire a first link, where the first link is used to indicate the target database;

The processing unit is configured to: establish a connection with the target database according to the first link.

The device according to claim 12, wherein the device further comprises a processing unit, the target data source is the offline file,

The processing unit is configured to: in response to a third configuration operation, set the target data source to the offline file.

The apparatus according to any one of claims 11 to 14, wherein the first operation includes a first selection operation or a first call operation, and the acquisition unit is specifically configured to:

The device according to claim 12 or 13, wherein the target database stores multiple data; the multiple data are data obtained by processing the original data using a preset tool, and the multiple data include the target business data.

The apparatus according to claim 16, wherein the processing of the raw data using a preset tool refers to performing ETL processing on the raw data.

The device according to any one of claims 11 to 17, wherein:

The acquisition unit is further configured to: in response to acquiring user information, wherein the user information includes the user's account number and corresponding password;

The display unit is further configured to: display an upload page when the user information has the authority to upload offline files, the upload page is for a csv file, and the csv file includes the target business data;

The acquisition unit is specifically configured to: acquire the csv file through the upload page, and acquire the target business data from the csv.

The device according to any one of claims 11 to 18, wherein:

The acquisition unit is further configured to: receive and store a plurality of offline files, wherein the plurality of offline files are determined according to a preset file template;

The display unit is further configured to display information of the multiple offline files through the electronic signage.

The device according to any one of claims 11 to 19, wherein:

The determining unit is further configured to: determine a first component, where the first component is used to reflect the distribution of the first business data;

A processing unit is configured to: establish an association relationship between the target component and the first component in response to a third operation;

The display unit is further configured to: display the target component and the first component in the electronic signage according to the association relationship between the target component and the first component.

A device for determining an electronic billboard, comprising: a processor and a communication interface; the communication interface is coupled to the processor, and the processor is used to run a computer program or instruction to implement the method described in any one of claims 1-10.

A computer-readable storage medium, wherein instructions are stored in the computer-readable storage medium, and when a computer executes the instructions, the computer executes the method described in any one of claims 1 to 10.