Data display method and device applied to semiconductor manufacturing process
By creating configuration information for target query tasks and result display tasks in the semiconductor manufacturing process, the problem of fixed data display methods in traditional CIM systems is solved, flexible and efficient data query and display are achieved, and user experience and system adaptability are improved.
Patent Information
- Application Number
- CN202411102079.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-12
- Publication Date
- 2025-10-17
AI Technical Summary
Existing computer-integrated manufacturing systems have fixed data query and display methods during the semiconductor manufacturing process and are unable to adapt to changes in data type and quantity, resulting in poor user experience and complex maintenance.
By creating the configuration information of the target query task and the configuration information of the result display task, users can flexibly configure the columns and data display on the interface, and support dynamic adjustment and customization of SQL query statements.
It enables flexible and efficient query and display of data in the semiconductor manufacturing process, improves user experience and system adaptability, and reduces maintenance costs.
Smart Images

Figure CN120804166A_ABST
Abstract
Description
TECHNICAL FIELD
[0001] The present application belongs to the technical field of computer technology, and particularly relates to a data display method and device applied to a semiconductor manufacturing process. BACKGROUND
[0002] With the rapid development of the semiconductor industry, data management and analysis in the semiconductor manufacturing process become more and more important. The computer integrated manufacturing (CIM) system is the core management system in the semiconductor manufacturing process, which needs to process, analyze and display a large amount of data.
[0003] At present, after the computer integrated manufacturing system is developed and put into operation, the contents available for query and the ways of displaying data in the interface are fixed. For example, a fixed column is generally used for display, that is, the columns on the interface are pre-set. With the continuous progress of semiconductor manufacturing technology and the continuous optimization of process flow, the types and quantities of data generated in the manufacturing process are also changing. The current method needs to modify the computer integrated manufacturing system to change the contents available for query and the data columns for displaying data in the interface, so as to adapt to the changes in the types and quantities of data, which is very inconvenient, and the process is complex and tedious, and the efficiency is very low. Therefore, how to flexibly and efficiently query and display the data generated in the semiconductor manufacturing process has become a technical problem to be solved in the field. SUMMARY
[0004] The present application aims to at least solve one of the technical problems existing in the prior art. To this end, the present application provides a data display method and device applied to a semiconductor manufacturing process, which can flexibly and efficiently query and display the data generated in the semiconductor manufacturing process.
[0005] In a first aspect, the present application provides a data display method applied to a semiconductor manufacturing process, which comprises:
[0006] creating first configuration information of a target query task in response to a first input to a first interface; the target query task is used to query data in the semiconductor manufacturing process; the first configuration information comprises an ID of the target query task and a SQL statement used to execute the target query task;
[0007] creating second configuration information of a result display task corresponding to the target query task in response to a second input to a second interface;
[0008] executing the target query task based on the first configuration information and displaying the query result of the target query task based on the second configuration in response to a third input to a third interface.
[0009] According to the data display method applied to the semiconductor manufacturing process, by creating the first configuration information of the target query task and the second configuration information of the result display task corresponding to the target query task, the data generated in the semiconductor manufacturing process can be flexibly and efficiently queried and displayed based on the first configuration information and the second configuration information.
[0010] According to an embodiment of the present application, the first configuration information of the target query task is created in response to the first input to the first interface, comprising:
[0011] Based on the first input, the ID of the target query task and the SQL statement are stored as a first record in the first configuration information table;
[0012] The SQL statement is parsed to generate at least one second record associated with the first record in the second configuration table; each second record is used to store the target information of a result field returned by executing the SQL statement; the target information includes name and type.
[0013] According to an embodiment of the present application, the second configuration information of the result display task corresponding to the target query task is created in response to the second input to the second interface, comprising:
[0014] Based on the second input, the ID of the result display task is bound to the ID of the target query task, and the ID of the result display task is stored as a third record in the third configuration table, and at least one fourth record associated with the third record in the fourth configuration table is generated; each fourth record is used to store the display attribute of the result field; the display attribute includes the order of display and whether to hide; the fourth record corresponds to the second record one by one.
[0015] According to an embodiment of the present application, the target query task is executed based on the first configuration information in response to the third input to the third interface, and the query result of the target query task is displayed based on the second configuration, comprising:
[0016] Based on the ID of the target query task carried by the third input, the first record is determined, and the SQL statement is called to obtain the query result;
[0017] Based on each result field of the query result, the second record and the fourth record corresponding to the result field are determined respectively;
[0018] Based on the ID of the target query task, the result display task corresponding to the target query task is determined and executed, and the query result is displayed according to the fourth record corresponding to each result field.
[0019] According to one embodiment of the present application, the displaying the query result according to the fourth record corresponding to each result field comprises:
[0020] The columns of the target table are rendered based on the display attribute of the result field in the fourth record corresponding to each result field, and the value of each result field with the display attribute of not hidden is filled into the corresponding column of the target table.
[0021] According to one embodiment of the present application, after the executing the target query task based on the first configuration information and the displaying the query result of the target query task based on the second configuration in response to the third input to the third interface, the method further comprises:
[0022] In response to a fourth input to the third interface, the display attribute of at least one result field is changed, and the target table is updated based on the changed display attribute to redisplay the query result.
[0023] In a second aspect, the present application provides a data display device applied in a semiconductor manufacturing process, which comprises:
[0024] A first configuration module is configured to create first configuration information of a target query task in response to a first input to a first interface, wherein the target query task is used to query data in the semiconductor manufacturing process, and the first configuration information comprises an ID of the target query task and an SQL statement used to execute the target query task.
[0025] A second configuration module is configured to create second configuration information of a result display task corresponding to the target query task in response to a second input to a second interface.
[0026] A query display module is configured to execute the target query task based on the first configuration information and display the query result of the target query task based on the second configuration in response to a third input to a third interface.
[0027] According to the data display device applied in the semiconductor manufacturing process of the present application, the first configuration information of the target query task and the second configuration information of the result display task corresponding to the target query task are created, so that the data generated in the semiconductor manufacturing process can be flexibly and efficiently queried and displayed based on the first configuration information and the second configuration information.
[0028] In a third aspect, the present application provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the computer program to implement the data display method applied in the semiconductor manufacturing process according to the first aspect.
[0029] In a fourth aspect, the present application provides a non-transitory computer readable storage medium, having a computer program stored thereon, wherein the computer program is executable by a processor to implement the data display method applied in the semiconductor manufacturing process according to the first aspect.
[0030] In a fifth aspect, the present application provides a chip, comprising a processor and a communication interface, wherein the communication interface is coupled to the processor, and the processor is configured to execute a program or an instruction to implement the data display method applied in the semiconductor manufacturing process according to the first aspect.
[0031] In a sixth aspect, the present application provides a computer program product, comprising a computer program, wherein the computer program is executable by a processor to implement the data display method applied in the semiconductor manufacturing process according to the first aspect.
[0032] Additional aspects and advantages of the present application will be in part apparent and in part pointed out hereinafter. BRIEF DESCRIPTION OF DRAWINGS
[0033] The above and / or additional aspects and advantages of the present application will become apparent and be readily appreciated from the following description, including the appended drawings.
[0034] Figure 1 is a flowchart of the data display method applied in the semiconductor manufacturing process according to an embodiment of the present application;
[0035] Figure 2 is a structural diagram of the data display device applied in the semiconductor manufacturing process according to an embodiment of the present application;
[0036] Figure 3 is a structural diagram of the electronic device according to an embodiment of the present application. DETAILED DESCRIPTION
[0037] The technical solutions in the embodiments of the present application will be clearly described below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are some of the embodiments of the present application, but not all of the embodiments of the present application. Based on the embodiments in the present application, all other embodiments obtained by a person of ordinary skill in the art belong to the scope of protection of the present application.
[0038] The terms "first", "second", etc. in the specification and claims of the present application are used to distinguish similar objects, and are not used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged under appropriate circumstances, so that the embodiments of the present application can be implemented in an order other than those illustrated or described herein, and the objects distinguished by "first", "second", etc. are generally a class, not limited to the number of objects, for example, the first object can be one or more. In addition, "and / or" in the specification and claims indicates at least one of the connected objects, and the character " / ", generally indicates that the objects before and after are in a "or" relationship.
[0039] In the related art, there are some defects in the data query of the traditional CIM system and the display of its results, such as fixed interface, single query mode and inflexible data display, etc. The above defects limit the application range and user experience of the CIM system.
[0040] The system interface of the traditional semiconductor CIM system often displays the results of data query in a fixed column display mode. That is, the columns on the interface are pre-set according to the customer's demand table before the development of the CIM system. The required data is returned by the code, and the fixed columns are displayed according to the demand table. However, after the CIM system goes online, users cannot flexibly adjust according to actual needs. The above-mentioned mode cannot adapt to the diversified needs of different users and different scenarios. For example, some users may pay more attention to the running state of the equipment and the process parameters, while others may be more concerned about the product quality and the production progress. The fixed column display mode cannot meet the above different needs at the same time, resulting in inconvenience for users in the use process.
[0041] In addition, with the continuous progress of semiconductor manufacturing technology and the continuous optimization of process flow, the types and quantities of data generated in the manufacturing process are also changing. The fixed column display mode cannot timely adapt to the above changes, resulting in a large deviation between the data display on the interface and the actual needs, which not only affects the understanding and analysis of the data by the user, but also may cause potential risks to the normal operation of the production line.
[0042] The data involved in the semiconductor manufacturing process is diverse, and the relationship between the data is complex. The system interface of the traditional CIM system often cannot meet the diversified query needs of users, resulting in the need for users to spend a lot of time and effort on data query and sorting. Moreover, with the continuous progress of semiconductor manufacturing technology, the system interface of the traditional CIM system often needs a lot of custom development work to continuously adapt to new processes and flows.
[0043] Below, in conjunction with the accompanying drawings, the data display method applied to the semiconductor manufacturing process, the data display device applied to the semiconductor manufacturing process, the electronic device and the readable storage medium provided in the embodiments of the present application are described in detail through specific embodiments and their application scenarios.
[0044] Among them, the data display method applied in the semiconductor manufacturing process can be applied to a terminal, and can be specifically executed by hardware or software in the terminal.
[0045] The terminal includes, but is not limited to, a portable communication device such as a mobile phone or tablet computer having a touch-sensitive surface (e.g., a touch screen display and / or a touch pad). It should also be understood that, in some embodiments, the terminal may not be a portable communication device, but a desktop computer having a touch-sensitive surface (e.g., a touch screen display and / or a touch pad).
[0046] In the following embodiments, a terminal including a display and a touch-sensitive surface is described. However, it should be understood that the terminal may include one or more other physical user interface devices such as a physical keyboard, a mouse, and a joystick.
[0047] The data display method applied to the semiconductor manufacturing process provided in the embodiment of the present application may be executed by an electronic device or a functional module or functional entity in the electronic device that can implement the data display method applied to the semiconductor manufacturing process. The electronic devices mentioned in the embodiment of the present application include but are not limited to mobile phones, tablet computers, computers, cameras, and wearable devices. The data display method applied to the semiconductor manufacturing process provided in the embodiment of the present application is described below using an electronic device as an example of the execution subject.
[0048] like Figure 1 As shown, the data display method applied in the semiconductor manufacturing process includes: step 110, step 120 and step 130.
[0049] The data display method provided in this application for use in the semiconductor manufacturing process is based on the urgent need for data management and query in the semiconductor manufacturing process, as well as the limitations and challenges of traditional CIM system data query methods and result displays.
[0050] The data display method for semiconductor manufacturing process provided by the embodiments of the present application can be applied to the CIM system, and can also be applied to a manufacturing execution system (MES), a recipe management system (PMS), a yield management system (YMS), a quality management system (QMS), a warehouse management system (WMS), a statistical process control (SPC) system, and the like. The data display method for semiconductor manufacturing process provided by the embodiments of the present application can be used in the above systems, and can flexibly configure columns and data sources of data to be displayed, and better meet the customized requirements of customers.
[0051] In step 110, first configuration information of a target query task is created in response to first input to a first interface; the target query task is used to query data in a semiconductor manufacturing process; the first configuration information includes an ID of the target query task and a SQL statement used to execute the target query task.
[0052] In actual implementation, a user can create the first configuration information of the target query task by inputting in the first interface. The input in the above process is the first input. The first input can carry information such as the ID of the target query task and the SQL statement used to execute the target query task. It should be noted that the target query task can be used to query data in the semiconductor manufacturing process.
[0053] In step 120, second configuration information of a result display task corresponding to the target query task is created in response to second input to a second interface.
[0054] In actual implementation, a user can create the second configuration information of the result display task corresponding to the target query task by inputting in the second interface. The result display task corresponding to the target query task refers to a task of displaying a query result obtained by executing the target query task. The input in the above process is the second input. The second input can carry display attributes of each result field in the query result.
[0055] In step 130, the target query task is executed based on the first configuration information in response to third input to a third interface, and a query result of the target query task is displayed based on the second configuration.
[0056] In actual execution, the user can trigger execution of the target query task by inputting in the third interface. The input in the above process is the third input. The third input can carry the ID of the target query task and the query condition and the like.
[0057] Based on the third input carrying the ID of the target query task and the first configuration information, the SQL statement for executing the target query task can be determined; after the SQL statement for executing the target query task is determined, the SQL statement can be executed to obtain the query result of the target query task; after the query result of the target query task is obtained, each field in the query result can be displayed based on the display attribute of each result field in the second configuration.
[0058] According to the data display method applied in the semiconductor manufacturing process provided in the embodiments of the present application, by creating the first configuration information of the target query task and the second configuration information of the result display task corresponding to the target query task, the data generated in the semiconductor manufacturing process can be flexibly and efficiently queried and displayed based on the first configuration information and the second configuration information.
[0059] It should be noted that the data display method applied in the semiconductor manufacturing process provided in the embodiments of the present application allows the user to flexibly configure the columns on the interface according to actual needs, including display, hiding, sorting and the like of the columns. In this way, the user can customize a personalized data display interface according to his own concerns and needs, improving the efficiency of data viewing and analysis. Moreover, the data display method applied in the semiconductor manufacturing process provided in the embodiments of the present application can adapt to changes in the semiconductor manufacturing process. In the case where the type and / or quantity of data changes, the user can update the column display mode on the interface through simple configuration operations, ensuring the accuracy and real-time performance of data display. The interface can be quickly customized and updated through simple configuration and adjustment, reducing the maintenance cost and time cost of the system.
[0060] It should be noted that the data display method applied in the semiconductor manufacturing process provided in the embodiments of the present application allows the user to flexibly construct an SQL query statement according to his own needs, realizing accurate query and display of data.
[0061] Based on the above two aspects, the limitations of the traditional CIM system in displaying fixed columns and returning data can be overcome, bringing a more flexible and efficient data query and display method for the semiconductor CIM system, improving the application range and user experience of the system, and providing strong support for the rapid development of the semiconductor manufacturing industry.
[0062] The data display method applied in the semiconductor manufacturing process provided in the embodiments of the present application can have the following advantages, but is not limited to the following advantages:
[0063] Improve data processing flexibility. A visual interface or programming interface can be provided to allow users to directly manipulate the column structure of the table. When a user needs to add a new column, the corresponding column structure can be automatically generated based on the user-specified column name, data type, and other attributes; when a column needs to be deleted or modified, the column structure can be updated based on the user's operation. This dynamic configuration method allows the table structure to adapt to the changing needs of the business at any time.
[0064] Simplify the operation process. A simple and easy-to-use operation interface and programming interface can be provided to allow users to operate without professional front-end knowledge. Users can complete the dynamic configuration of the column structure by simply clicking and configuring. This simplified operation process can reduce the learning cost and difficulty of use, and improve work efficiency.
[0065] Improve query flexibility. Allow users to dynamically build SQL query statements through a friendly interface without modifying the code. Users can flexibly select table names, fields, filtering conditions, etc. according to business needs to write query statements that meet their needs. This flexibility allows users to easily handle various complex query scenarios and can improve query efficiency and accuracy.
[0066] Reduce maintenance costs. Dynamically building SQL query statements through a friendly interface can reduce code modification and testing costs due to changes in business requirements.
[0067] Improve system adaptability. By adopting a universal query construction mechanism, it can be compatible with different database systems and data structures. Regardless of how the underlying database changes, users can configure and operate through a unified interface. In addition, it also supports custom extensions and plug-in mechanisms, allowing users to add new query elements and configuration options as needed to meet specific business requirements.
[0068] The data display method applied in the semiconductor manufacturing process provided by the embodiments of the present application can realize a dynamic configurable table technology dedicated to the semiconductor field, ensuring high accuracy and industry adaptability of the technology. The data display method applied in the semiconductor manufacturing process provided by the embodiments of the present application can also realize an interface dynamic configurable SQL technology dedicated to the semiconductor field, ensuring high accuracy and industry adaptability of the technology.
[0069] In some embodiments, in response to a first input to the first interface, first configuration information of a target query task is created, including: based on the first input, storing the ID and SQL statement of the target query task as a first record in a first configuration information table.
[0070] In actual implementation, a Query (target query task) can be created in a configuration interface, a custom name is input for QueryId (ID of the target query task), and SQL (SQL statement used for executing the target query task) is flexibly written according to requirements. A return result set name is used for returning a field name by the backend according to the SQL, and if a column name needs to be customized, an alias can be taken for the return field. The configured SQL can also realize dynamic parameter passing, and a parameter value only needs to satisfy a matching rule of "+custom parameter name".
[0071] For example, if a Query of device information needs to be configured, a SQL statement for querying related table data can be written in the first interface; for a query condition, for example, if data is filtered according to machineName, the parameter value can be machineName.
[0072] The SQL statement is parsed, and at least one second record associated with the first record in the second configuration table is generated; each second record is used to store target information of one result field returned by executing the SQL statement; the target information includes a name and a type.
[0073] In actual implementation, a QueryDef table (the first configuration table) and a QueryModelDef table (the second configuration table) can be established in a database, and the relationship between the two tables is that one piece of QueryDef table data corresponds to multiple pieces of QueryModelDef table data, and the associated field is QueryId.
[0074] According to information such as QueryId and the SQL statement filled in the first interface, the information is stored in the QueryDef table. Then, based on NamedParameterJdbcTemplate, the SQL statement is parsed according to a regular expression matching, and information such as a field name or an alias and a field type returned by the SQL statement is stored in the QueryModelDef table. The field is a result field.
[0075] A regular expression, also known as a rule expression (Regular Expression, commonly abbreviated as regex, regexp, or RE in code), is a text pattern including ordinary characters (for example, letters between a and z) and special characters (referred to as "meta characters"), which is a concept in computer science. A regular expression uses a single string to describe and match a series of strings that match a certain syntax rule, and is usually used to retrieve and replace text that meets a certain pattern (rule).
[0076] NamedParameterJdbcTemplate is a class in the Spring Framework that provides a way to execute SQL statements using named parameters instead of traditional '?' placeholders, which improves code readability and maintainability.
[0077] In some embodiments, the Vue3 ReactiveReplacedData feature can be used to define the TableData reactive data object, set the computed attribute for each column during columns traversal to realize two-way binding and formatting, and use watch to listen to data changes and call the updateData method to update the internal data. Through the above process, a mapping model of SQL and QueryId can be designed.
[0078] According to the data display method applied to the semiconductor manufacturing process provided by the embodiments of the application, a user can flexibly construct a SQL query statement according to his own needs, and realize accurate query and display of data.
[0079] In some embodiments, in response to the second input to the second interface, the result display task corresponding to the target query task is created, and the second configuration information of the result display task includes: based on the second input, the ID of the result display task is bound to the ID of the target query task, and the ID of the result display task is stored as a third record in a third configuration table, and at least one fourth record associated with the third record in a fourth configuration table is generated; each fourth record is used to store the display attribute of the result field; the display attribute includes the order of display and whether to hide; the fourth record corresponds to the second record one by one.
[0080] In actual execution, ViewDef (third configuration table) can be created in the second interface, the custom name ViewId (part of the content of the second input) is input, the QueryId is selected from the drop-down box, and the ViewId is bound. According to the requirement, the ViewModelDef (fourth configuration table) under ViewDef is created, and the ColumnName (column name) in ViewModelDef needs to be consistent with the ColumnName of the bound QueryModelDef.
[0081] In some embodiments, columns of the device information table need to be configured, ViewDef is created, and is bound with Query, ViewModelDef is created according to the required device column name, whether to hide (an example of a display attribute, but not limited to the display attribute) is configured, and sorting is configured. Whether the column is hidden in the table can be set by setting the UseFlag (an example of a display attribute) of the ViewModelDef (achieved through the second input), Y indicates display, N indicates hiding, and the order of each column in the table can be adjusted by clicking the buttons PositionUp and PositionDown (part of the content of the second input).
[0082] The ViewDef table and the ViewModelDef table are established in the database, and the relationship between the two tables is that one piece of ViewDef table data corresponds to multiple pieces of ViewModelDef table data, and the association field is ViewId.
[0083] According to the data display method applied to the semiconductor manufacturing process provided in the embodiments of the present application, a personalized data display interface is customized according to the user's focus and needs, and the efficiency of data viewing and analysis is improved.
[0084] In some examples, in response to a third input to the third interface, a target query task is executed based on first configuration information, and a query result of the target query task is displayed based on second configuration, including:
[0085] Based on the ID of the target query task carried by the third input, the first record is determined, and a SQL statement is called to obtain the query result;
[0086] Based on each result field of the query result, the second record and the fourth record corresponding to the result field are respectively determined;
[0087] Based on the ID of the target query task, the result display task corresponding to the target query task is determined and executed, and the query result is displayed according to the fourth record corresponding to each result field.
[0088] In actual execution, based on ViewId, the search condition on the third interface is clicked to query the button (one way of the third input, but not limited to this), the QueryId bound according to ViewId can be determined, the SQL statement is executed, and the related data is retrieved.
[0089] In some embodiments, the data of the query device is queried, and when entering the page, the table for displaying the query result in the page displays all device data by default. According to the search condition, the table will filter out the required device data according to the search condition.
[0090] The backend interface can be called during interface initialization to query the configured View Model Def according to the ViewId, traverse the query result, and pass it to the encapsulated table component for dynamic rendering of table columns according to the configured column order and whether the attribute is hidden.
[0091] During interface initialization, the backend interface can also be called to query the configured SQL statement according to the bound QueryId, pass the SQL statement to the NamedParameterJdbcTemplate of the Spring framework for parsing, and return the data to the front end. The front end traverses the columns, matches the column name with the key name of the queried data, and if the condition is met, matches the data to the column for dynamic rendering.
[0092] In some embodiments, the backend can parse the SQL AST syntax tree based on the SqlParser library, extract the projection field, condition filtering, table join, grouping aggregation, and other query information. Traverse the AST tree nodes, analyze the fields and relationships, and construct the ViewModel object hierarchy mapped and bound to the Vue end.
[0093] In some embodiments, based on in-depth analysis of the Element Plus table component source code, the render function can be rewritten to dynamically generate VNode description table header cells according to the prop.columns configuration. In the renderHeader method, traverse the columns, call the renderColHeader method to render different types of cell components according to the column.type, and support complex table header layout. The above process belongs to front-end dynamic rendering technology. By rewriting part of the source code of the Element Plus table component, the table and different types of cell components can be dynamically generated and rendered according to the configured table properties.
[0094] According to the data display method applied in the semiconductor manufacturing process provided in the embodiments of the present application, the data generated in the semiconductor manufacturing process can be flexibly and efficiently queried and displayed based on the first configuration information and the second configuration information.
[0095] In some embodiments, the query result is displayed according to the fourth record corresponding to each result field, including: rendering the columns of the target table based on the display attribute of the result field in the fourth record corresponding to each result field, and filling the value of each result field with the display attribute of not hidden into the corresponding column in the target table.
[0096] According to the data display method applied in the semiconductor manufacturing process provided in the embodiments of the present application, the data generated in the semiconductor manufacturing process can be flexibly and efficiently queried and displayed.
[0097] In some embodiments, after performing the target query task based on the first configuration information and displaying the query result of the target query task based on the second configuration in response to the third input to the third interface, the method further includes, in response to a fourth input to the third interface, changing a display attribute of at least one result field, and updating the target table based on the changed display attribute to re-display the query result.
[0098] In some embodiments, the setting button (an example of the fourth input, but not limited thereto) can be clicked to display or hide the data in a column of the table, and the up and down buttons (an example of the fourth input, but not limited thereto) can be clicked to adjust the display order of the columns of the table.
[0099] In some embodiments, the current query result can be exported to an Excel document through the export button. For example, the export button can be clicked to transmit the data to the xlsx library of node.js through the front-end code processing to export the Excel document.
[0100] According to the data display method for the semiconductor manufacturing process provided in the embodiments of the present application, the user can update the column display mode on the interface through simple configuration operations, ensure the accuracy and real-time performance of data display, realize quick customization and update of the interface through simple configuration and adjustment, and reduce the maintenance cost and time cost of the system.
[0101] The following will be described in combination with an actual application scenario. The scenario is to display device information. After the configuration steps of steps 110 and 120 and the front-end code is written, a device information display interface that can dynamically configure the data source and search conditions and dynamically adjust the table columns and adjust the column order is realized. The device information display interface supports searching according to the custom query conditions, can specify the device information display columns that meet the user's needs, can configure the data source, and can sort the table columns and the like:
[0102] The interface initialization calls the backend interface to query the configuration stored in the database in step 120. The backend interface returns a JSON object array, and the front-end traverses the array to pass the column name of each item to the encapsulated table component called in the form of an HTML tag. The column name that is not configured will not be rendered on the page, thereby realizing the configurability of the table columns and realizing the dynamic rendering of the table columns.
[0103] According to the JSON object array returned by the backend interface, the front-end traverses the array according to the search condition attribute configured by each item. If it is yes, it is passed to the encapsulated form component to automatically render the form search condition on the table.
[0104] According to the JSON object array returned by the backend interface, the front end traverses the array according to the enabled attribute configured by each item. If it is not enabled, it is not transmitted to the encapsulated table component, thereby realizing the dynamic configuration of the table column.
[0105] According to the JSON object array returned by the backend interface, the front end traverses the array according to the position attribute configured by each item, sorts the sorted array in ascending order from small to large, and then transmits the sorted array to the encapsulated table component, thereby realizing the adjustable order of the table column.
[0106] When the query button is clicked, the front end calls the backend interface to query the configuration stored in the database in step 110, the backend executes the configured SQL parsing to return a JSON object array, the array is traversed and matched with the table column array, and the data is rendered to each column of the table, thereby realizing the dynamic configurable data source of the table.
[0107] The information query interface can also cache the frequently queried content of the user, thereby greatly improving the query efficiency.
[0108] The above-mentioned function interface only needs to write simple configuration code, without writing complex business logic code, and the above-mentioned functions can be realized without changing the code.
[0109] The application embodiment provides a data display method applied to a semiconductor manufacturing process. An execution subject can be a data display device applied to the semiconductor manufacturing process. In the application embodiment, the data display device applied to the semiconductor manufacturing process is taken as an example to execute the data display method applied to the semiconductor manufacturing process, and the data display device applied to the semiconductor manufacturing process is described.
[0110] The application embodiment further provides a data display device applied to a semiconductor manufacturing process.
[0111] As shown in Figure 2 The data display device applied to the semiconductor manufacturing process includes a first configuration module 210, a second configuration module 220, and a query display module 230.
[0112] The first configuration module 210 is configured to create first configuration information of a target query task in response to a first input to a first interface. The target query task is configured to query data in a semiconductor manufacturing process. The first configuration information includes an ID of the target query task and a SQL statement used to execute the target query task.
[0113] The second configuration module 220 is configured to create second configuration information of a result display task corresponding to the target query task in response to a second input to a second interface.
[0114] The query display module 230 is configured to, in response to the third input to the third interface, perform a target query task based on the first configuration information, and display a query result of the target query task based on the second configuration.
[0115] According to the data display device for the semiconductor manufacturing process provided by the embodiments of the present application, the first configuration information of the target query task and the second configuration information of the result display task corresponding to the target query task are created, and the data generated in the semiconductor manufacturing process can be flexibly and efficiently queried and displayed based on the first configuration information and the second configuration information.
[0116] In some embodiments, the first configuration module 210 can be specifically configured to:
[0117] store the ID of the target query task and the SQL statement as a first record in the first configuration information table based on the first input;
[0118] parse the SQL statement to generate at least one second record associated with the first record in the second configuration table; each second record is configured to store target information of a result field returned by the execution of the SQL statement; the target information includes a name and a type.
[0119] In some embodiments, the second configuration module 220 can be specifically configured to:
[0120] bind the ID of the result display task with the ID of the target query task based on the second input, store the ID of the result display task as a third record in the third configuration table, and generate at least one fourth record associated with the third record in the fourth configuration table; each fourth record is configured to store a display attribute of the result field; the display attribute includes a display order and whether to hide; the fourth record corresponds to the second record one by one.
[0121] In some embodiments, the query display module 230 can include:
[0122] an obtaining unit configured to determine the first record based on the ID of the target query task carried by the third input, and call the SQL statement to obtain a query result;
[0123] a determining unit configured to determine the second record and the fourth record corresponding to each result field of the query result, respectively;
[0124] a display unit configured to determine the result display task corresponding to the target query task based on the ID of the target query task, and execute the result display task, and display the query result according to the fourth record corresponding to each result field.
[0125] In some embodiments, the display unit can be specifically configured to:
[0126] The columns of the target table are rendered based on the display attribute of the result field in the fourth record corresponding to each result field, and the values of the result fields with the display attribute of not hidden are filled into the corresponding columns of the target table.
[0127] In some embodiments, the data display device applied in the semiconductor manufacturing process can further include:
[0128] The updating module is configured to change the display attribute of the at least one result field in response to the fourth input to the third interface, and update the target table based on the changed display attribute to display the query result again.
[0129] The data display device applied in the semiconductor manufacturing process in the embodiments of the present application can be an electronic device or a component in an electronic device, such as an integrated circuit or a chip. The electronic device can be a terminal or other devices other than a terminal. For example, the electronic device can be a mobile phone, a tablet computer, a notebook computer, a palm computer, a vehicle-mounted electronic device, a mobile Internet device (MID), an augmented reality (AR) / virtual reality (VR) device, a robot, a wearable device, an ultra-mobile personal computer (UMPC), a netbook, or a personal digital assistant (PDA), and the like. The electronic device can also be a server, a network attached storage (NAS), a personal computer (PC), a television (TV), a teller machine, or a self-service machine, and the like. The embodiments of the present application are not limited in this regard.
[0130] The data display device applied in the semiconductor manufacturing process in the embodiments of the present application can be a device with an operating system. The operating system can be an Android operating system, an iOS operating system, or other possible operating systems, and the embodiments of the present application are not limited in this regard.
[0131] The data display device applied in the semiconductor manufacturing process provided in the embodiments of the present application can achieve the advantages of the method embodiments. Figure 1 The processes performed by the method embodiments are not repeated here to avoid repetition.
[0132] In some embodiments, as Figure 3As shown, the electronic device 300 according to the embodiment of the present application further comprises a processor 310, a memory 320, and a computer program stored in the memory 320 and executable on the processor 310. The computer program is executed by the processor 310 to implement each process of the above-mentioned data display method applied in the semiconductor manufacturing process, and achieve the same technical effects. To avoid repetition, details are not described herein.
[0133] It should be noted that the electronic device in the embodiment of the present application includes the mobile electronic device and the non-mobile electronic device described above.
[0134] The embodiment of the present application further provides a non-transitory computer readable storage medium, which stores a computer program. The computer program is executed by a processor to implement each process of the above-mentioned data display method applied in the semiconductor manufacturing process, and achieve the same technical effects. To avoid repetition, details are not described herein.
[0135] The processor is the processor in the electronic device described in the above-mentioned embodiments. The readable storage medium includes a computer readable storage medium, such as a computer readable only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk, etc.
[0136] The embodiment of the present application further provides a computer program product, which includes a computer program. The computer program is executed by a processor to implement the above-mentioned data display method applied in the semiconductor manufacturing process.
[0137] The processor is the processor in the electronic device described in the above-mentioned embodiments. The readable storage medium includes a computer readable storage medium, such as a computer readable only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk, etc.
[0138] The embodiment of the present application further provides a chip, which includes a processor and a communication interface. The communication interface is coupled with the processor. The processor is used to run a program or an instruction to implement each process of the above-mentioned data display method applied in the semiconductor manufacturing process, and achieve the same technical effects. To avoid repetition, details are not described herein.
[0139] It should be understood that the chip mentioned in the embodiment of the present application can also be referred to as a system-level chip, a system chip, a chip system, or a system-on-chip, etc.
[0140] It should be noted that, in the present document, the terms "comprises", "comprising", or any other variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but can also include other elements not expressly listed or inherent to such process, method, article, or apparatus. An element proceeded by "comprises a", "comprising", or "comprises" does not, without more constraints, preclude the existence of additional identical elements in the process, method, article, or apparatus that comprises the element. Additionally, it should be noted that the terms "one embodiment", "some embodiments", "certain embodiments", "certain examples", or "some examples" as used in the present document are intended to refer to one or more embodiments or examples that do not necessarily have to cover all embodiments or examples of the present application. In other words, use of the above terms does not necessarily refer to the same embodiment or example. Furthermore, the described features, structures, or characteristics can be combined in any suitable manner in one or more embodiments or examples.
[0141] From the above description of the embodiments, it is apparent that the above-described method of the embodiments can be realized by means of software and general-purpose hardware platforms, of course, but in many cases the former is a better embodiment. Based on such an understanding, the technical solutions of the present application, essentially or in other words, the part that contributes to the prior art, can be embodied in the form of a computer software product stored in a storage medium (such as ROM / RAM, magnetic disk, optical disk), including a number of instructions to make a terminal (which can be a mobile phone, computer, server, or network equipment, etc.) execute the methods described in various embodiments of the present application.
[0142] The embodiments of the present application are described above in conjunction with the drawings, but the present application is not limited to the specific embodiments described above, which are merely illustrative rather than restrictive, and a person of ordinary skill in the art can make many forms without departing from the purpose of the present application and the scope protected by the claims.
[0143] In the description of the present specification, the description of the terms "one embodiment", "some embodiments", "exemplary embodiment", "example", "specific example", or "some examples" means that the specific features, structures, materials, or characteristics described in conjunction with the embodiment or example are included in at least one embodiment or example of the present application. In the present specification, the exemplary description of the above terms does not necessarily refer to the same embodiment or example. Furthermore, the specific features, structures, materials, or characteristics described can be combined in any suitable manner in any one or more embodiments or examples.
[0144] While the embodiments of the application have been shown and described, it is to be understood that the embodiments can be varied, modified, substituted and changed by those skilled in the art without departing from the principles and spirit of the application, the scope of which is defined by the claims and their equivalents.
Claims
1. A data display method used in a semiconductor manufacturing process, characterized in that: include: In response to a first input on the first interface, creating first configuration information of the target query task; The target query task is used to query data in a semiconductor manufacturing process; the first configuration information includes an ID of the target query task and an SQL statement for executing the target query task; In response to a second input on the second interface, creating second configuration information of a result display task corresponding to the target query task; In response to a third input on the third interface, the target query task is executed based on the first configuration information, and a query result of the target query task is displayed based on the second configuration.
2. The data display method used in a semiconductor manufacturing process according to claim 1, characterized in that: The step of creating first configuration information of the target query task in response to the first input on the first interface includes: Based on the first input, storing the ID of the target query task and the SQL statement as a first record in a first configuration information table; The SQL statement is parsed to generate at least one second record associated with the first record in a second configuration table; each second record is used to store target information of a result field returned by executing the SQL statement; the target information includes a name and a type.
3. The data display method used in a semiconductor manufacturing process according to claim 2, characterized in that: The step of creating second configuration information of a result display task corresponding to the target query task in response to a second input on the second interface includes: Based on the second input, the ID of the result display task is bound to the ID of the target query task, and the ID of the result display task is stored as a third record in a third configuration table, and at least one fourth record associated with the third record is generated in a fourth configuration table; each of the fourth records is used to store the display attributes of the result field; the display attributes include the display order and whether to hide; the fourth record corresponds one-to-one to the second record.
4. The data display method used in a semiconductor manufacturing process according to claim 3, characterized in that: The step of executing the target query task based on the first configuration information in response to the third input on the third interface and displaying the query result of the target query task based on the second configuration includes: Based on the ID of the target query task carried by the third input, determine the first record, and call the SQL statement to obtain the query result; Based on each result field of the query result, respectively determining the second record and the fourth record corresponding to the result field; Based on the ID of the target query task, a result display task corresponding to the target query task is determined and executed, and the query result is displayed according to the fourth record corresponding to each result field.
5. The data display method used in a semiconductor manufacturing process according to claim 4, characterized in that: The displaying of the query result according to the fourth record corresponding to each of the result fields includes: Render the columns of the target table based on the display attributes of the result fields in the fourth record corresponding to each of the result fields, and fill the values of the result fields whose display attributes are not hidden into the corresponding columns in the target table.
6. The data display method used in a semiconductor manufacturing process according to any one of claims 1 to 5, characterized in that: After executing the target query task based on the first configuration information in response to the third input on the third interface and displaying the query result of the target query task based on the second configuration, the method further includes: In response to a fourth input on the third interface, a display attribute of at least one of the result fields is changed, and based on the changed display attribute, the target table is updated to redisplay the query result.
7. A data display device used in a semiconductor manufacturing process, characterized in that: include: A first configuration module, configured to create first configuration information of a target query task in response to a first input on the first interface; The target query task is used to query data in a semiconductor manufacturing process; the first configuration information includes an ID of the target query task and an SQL statement for executing the target query task; A second configuration module is configured to create second configuration information of a result display task corresponding to the target query task in response to a second input on the second interface; The query display module is used to respond to a third input on the third interface, execute the target query task based on the first configuration information, and display the query result of the target query task based on the second configuration.
8. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein: When the processor executes the program, the data display method applied to the semiconductor manufacturing process as described in any one of claims 1 to 6 is implemented.
9. A non-transitory computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the data display method applied to a semiconductor manufacturing process as described in any one of claims 1 to 6 is implemented.
10. A computer program product comprising a computer program, characterized in that When the computer program is executed by a processor, the data display method applied to a semiconductor manufacturing process as described in any one of claims 1 to 6 is implemented.