CN114443118A

CN114443118A - Sample table modification method and device, electronic equipment and storage medium

Info

Publication number: CN114443118A
Application number: CN202111459226.4A
Authority: CN
Inventors: 夏日; 解莹
Original assignee: Beijing Shareit Information Technology Co Ltd
Current assignee: Beijing Shareit Information Technology Co Ltd
Priority date: 2021-12-02
Filing date: 2021-12-02
Publication date: 2022-05-06

Abstract

The disclosure relates to a method for modifying a sample table, comprising: displaying a first configuration interface, wherein the first configuration interface is provided with a first configuration inlet, and the first configuration inlet is used for detecting a first configuration operation of a target sample table determined to be modified; displaying a second configuration interface according to a configuration result of the first configuration operation, wherein the second configuration interface is provided with a second configuration inlet, and the second configuration inlet is used for detecting and determining a second configuration operation of a target column in the target sample table; determining the target column according to the second configuration operation; creating and executing a modification task; wherein the modification task is used for modifying the target column.

Description

Sample table modification method and device, electronic equipment and storage medium

Technical Field

The present disclosure relates to the field of information processing, and in particular, to a method and an apparatus for modifying a sample table, an electronic device, and a storage medium.

Background

With the development of science and technology, artificial intelligence is widely applied. In the field of artificial intelligence, a network model is an important component, the network model needs to be trained before being applied, a training sample needs to be used during training, and the training of the network model can be realized through the training sample to obtain the trained network model. The training samples have respective characteristics, the characteristics of different training samples may be different, and the sample table has a large number of training samples, and the characteristics of the training samples change as the number of training samples increases and the number of training samples changes. As the features change, the feature data in the sample table needs to be modified.

Disclosure of Invention

The disclosure provides a sample table modification method and device, electronic equipment and a storage medium.

In a first aspect of the embodiments of the present disclosure, a method for modifying a sample table is provided, including: displaying a first configuration interface, wherein the first configuration interface is provided with a first configuration inlet, and the first configuration inlet is used for detecting a first configuration operation of a target sample table determined to be modified; displaying a second configuration interface according to a configuration result of the first configuration operation, wherein the second configuration interface is provided with a second configuration inlet, and the second configuration inlet is used for detecting and determining a second configuration operation of a target column in the target sample table; determining the target column according to the second configuration operation; creating and executing a modification task; wherein the modification task is used for modifying the target column.

In one embodiment, the second configuration portal comprises: configuring an alternative column configuration inlet of an alternative column and configuring a target column configuration inlet of a target column; the candidate column configuration entry is used for detecting candidate column configuration operation for configuring candidate columns, and the target column configuration entry is used for detecting target column configuration operation for configuring target columns; the determining the target column according to the second configuration operation includes: binding the alternative columns from the columns of the target sample table according to the alternative column configuration operation; and determining the target column from the alternative columns according to the target column configuration operation.

In one embodiment, said binding said alternative column from a column of said target sample table according to said alternative column configuration operation comprises: determining unbound columns in the target sample table; binding the alternative columns from the unbound columns according to the alternative column configuration operation.

In one embodiment, the method further comprises: when all columns in the target sample table are bound, inquiring whether the bound at least one column can be unbound; after the bound at least one column is unbound, binding the alternative column from the unbound at least one column.

In one embodiment, the alternative column configuration entry comprises: a data type configuration entry; the data type configuration entry is used for detecting data type configuration operation for configuring the data types in the alternative columns; binding the alternative columns from the unbound columns, including: determining whether the data type of the data stored in the unbound column is consistent with the data type indicated by the data type configuration operation according to the data type configuration operation; and when the data type of the data stored in the unbound column is consistent with the data type indicated by the data type configuration operation, binding the alternative column from the unbound column.

In one embodiment, the method further comprises: and when the data type of the stored data in the unbound column is consistent with the data type indicated by the data type configuration operation, binding the alternative column in which the data type of the stored data is consistent with the data type indicated by the data type configuration operation according to the data type configuration operation.

In one embodiment, the method comprises: when the target sample table does not exist, displaying a creation page of the target sample table; wherein the creation page comprises at least one creation entry for creating the target sample table; creating the target sample table according to the creation operation received by the creation entrance; wherein the target sample table comprises a plurality of columns, each column comprising a plurality of rows.

In one embodiment, the method further comprises: unbinding the columns of the target column or the alternative columns other than the target column without modifying the columns of the target column or the alternative columns other than the target column.

In one embodiment, the target sample table is a sample table of text data.

In a second aspect of the embodiments of the present disclosure, there is provided a modification apparatus for a sample table, including: the system comprises a first configuration interface display module, a first configuration interface display module and a second configuration interface display module, wherein the first configuration interface display module is used for displaying a first configuration interface, and the first configuration interface is provided with a first configuration inlet which is used for detecting a first configuration operation of a target sample table determined to be modified; a second configuration interface display module, configured to display a second configuration interface according to a configuration result of the first configuration operation, where the second configuration interface has a second configuration entry, and the configuration entry is used to detect a second configuration operation for determining a target column in the target sample table; a target column determination module, configured to determine the target column according to the second configuration operation; the modification module is used for creating and executing modification tasks; wherein the modification task is used for modifying the target column.

In a third aspect of the embodiments of the present disclosure, there is provided an electronic device, including: a processor and a memory for storing executable instructions operable on the processor, wherein: when the processor is used for executing the executable instructions, the executable instructions execute the method of any one of the above embodiments.

In a fourth aspect of the embodiments of the present disclosure, a non-transitory computer-readable storage medium is provided, in which computer-executable instructions are stored, and when executed by a processor, the computer-executable instructions implement the method according to any of the embodiments described above.

The technical scheme provided by the embodiment of the disclosure can have the following beneficial effects:

the embodiment of the disclosure displays a first configuration interface, wherein the first configuration interface is provided with a first configuration inlet, and the first configuration inlet is used for detecting a first configuration operation of a target sample table determined to be modified. And then displaying a second configuration interface according to the configuration result of the first configuration operation, wherein the second configuration interface is provided with a second configuration inlet, the second configuration inlet is used for detecting a second configuration operation for determining a target column in the target sample table, and the target column is determined according to the second configuration operation. And then creating and executing a modification task, wherein the modification task is used for modifying the target column.

The target column can be modified according to the modification task by determining the target sample table and determining the target column in the target sample, the target sample table in the embodiment realizes the independent modification of the columns in the target sample table, and if a certain column needs to be independently modified, the target column needing to be modified can be determined according to the configuration operation, so that the target column is modified, the data of other columns in the target sample table are not influenced, the problem of resource waste caused by the fact that all columns in the target sample table need to be modified when the target column is modified is solved, and resources are saved.

It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.

Drawings

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present disclosure and together with the description, serve to explain the principles of the disclosure.

FIG. 1 is a flow diagram illustrating a method for modifying a sample table in accordance with an exemplary embodiment;

FIG. 2 is a diagram illustrating a method of binding alternate columns in accordance with an exemplary embodiment;

FIG. 3 is a schematic diagram illustrating one type of determining alternative columns in accordance with an exemplary embodiment;

FIG. 4 is a flow diagram illustrating another method of modifying a sample table in accordance with an exemplary embodiment;

FIG. 5 is a block diagram illustrating a sample table modification apparatus in accordance with an exemplary embodiment;

FIG. 6 is a schematic diagram illustrating a sample table configuration platform in accordance with an exemplary embodiment;

FIG. 7 is a schematic diagram illustrating a create target sample table in accordance with an illustrative embodiment;

FIG. 8 is a table information diagram illustrating a target sample table created in accordance with FIG. 7, in accordance with an exemplary embodiment;

FIG. 9 is a diagrammatical representation of a configuration interface for binding alternate columns in accordance with an exemplary embodiment;

FIG. 10 is a diagram illustrating a create modification task in accordance with an exemplary embodiment;

FIG. 11 is a task information diagram illustrating a created modification task in accordance with an exemplary embodiment;

FIG. 12 is a schematic diagram illustrating a modified flow of a sample table in accordance with an illustrative embodiment;

FIG. 13 is a block diagram illustrating a sample table configuration platform in accordance with an exemplary embodiment.

Detailed Description

Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The implementations described in the exemplary embodiments below are not intended to represent all implementations consistent with the present disclosure. Rather, they are merely examples of devices consistent with certain aspects of the present disclosure, as detailed in the appended claims.

Referring to fig. 1, a schematic flow chart of a method for modifying a sample table according to an embodiment of the present disclosure is provided, where the method includes the following steps:

step S100, displaying a first configuration interface, wherein the first configuration interface is provided with a first configuration inlet, and the first configuration inlet is used for detecting and determining a first configuration operation of a target sample table to be modified;

step S200, displaying a second configuration interface according to the configuration result of the first configuration operation, wherein the second configuration interface is provided with a second configuration inlet, and the configuration inlet is used for detecting and determining the second configuration operation of the target column in the target sample table;

step S300, determining a target column according to the second configuration operation;

step S400, creating and executing a modification task; wherein the modification task is used for modifying the target column.

At least the method can be executed in a sample table configuration platform, that is, the execution subject of the method at least comprises the sample table configuration platform. The sample table configuration platform can comprise a mobile phone, a tablet computer and the like.

The sample table configuration platform can configure sample tables, detect configuration operation and configure the sample tables according to the configuration operation. The sample table needing to be modified can be determined through the sample table configuration platform, and the sample table needing to be modified is used as a target sample table. The sample table configuration platform can determine any sample table in the sample pool, namely the sample table is in the sample pool, a target sample table can be determined from the sample pool through the sample table configuration platform, and then the target sample table is modified correspondingly. The specific format of the sample table is not limited herein, and for example, the sample table has rows and columns, and the data in the sample table is distributed in the sample table in a manner of rows and columns.

The sample table configuration platform has display functionality, such as having a display screen or other portion that can be displayed. The sample table configuration platform displays a first configuration interface, and the first configuration interface is used for determining a sample table needing to be modified, namely, a target sample table to be modified can be determined through the first configuration interface. The first configuration interface has a first configuration entry therein that can detect a first configuration operation applied to the first configuration entry for determining a target sample. Upon detection of a first configuration operation through the first configuration portal, a target sample table may be determined in accordance with the first configuration operation.

The first configuration operation may be a configuration operation corresponding to an actual configuration requirement, the first configuration interface may be a display interface having a configuration function in any form, the display form of the first configuration interface is not limited, and the first configuration entry may be a configuration entry in the form of a control, such as a button.

And determining a target sample table through the first configuration interface and the first configuration inlet, wherein the determined target sample table is a configuration result of the first configuration operation.

After the target sample table is determined, the target sample table can be configured, and a second configuration interface is displayed, wherein the second configuration interface is matched with the target sample table, and the second configuration interfaces corresponding to different target sample tables may be different. The second configuration interface is used for configuring the target sample, and the second configuration interface is provided with a second configuration inlet which is used for detecting a second configuration operation for configuring the target column in the target sample table.

The target sample table in this embodiment has a function of configuring columns individually, and at least one column may be configured individually. And determining a target column according to the second configuration operation after the second configuration operation is detected through the second configuration inlet, wherein the target column is the column to be modified in the target sample table.

After the target column is determined, a modification task for modifying the target column can be created and then executed. When the target column is modified independently, other columns in the target sample table are not affected, the second configuration operation does not determine to modify other columns in the target sample table except the target column, and the other columns except the target column are not modified when a modification task is executed, wherein the modification task modifies the target column independently. Therefore, data isolation of different columns in the sample table is realized, and interference and influence on other columns when the target column is modified are reduced. Meanwhile, when the target column is independently modified, the problem of resource waste caused by simultaneous modification of other types can be reduced, and resources such as computing resources and storage resources are saved.

In another embodiment, the second configuration portal includes: configuring an alternative column configuration inlet of an alternative column and configuring a target column configuration inlet of a target column; the candidate column configuration entry is used for detecting candidate column configuration operation for configuring the candidate column, and the target column configuration entry is used for detecting target column configuration operation for configuring the target column. The alternative column configuration entry may detect an alternative column configuration operation, and after the alternative column configuration entry detects the alternative column configuration operation, the sample table configuration platform may determine an alternative column according to the alternative column configuration operation. In the sample table, each column can be bound, different columns can be bound by different accounts, and the same column can be bound by only one account at the same time.

Step S300, determining a target column according to the second configuration operation, including: binding the alternative columns from the columns of the target sample table according to the alternative column configuration operation, and then determining the target columns from the alternative columns according to the target column configuration operation.

The alternative columns are a part of columns or all columns determined from the columns which can be bound currently, namely a part of columns determined from the columns which are not bound by other accounts are used as the alternative columns, or columns which are not bound by other accounts are used as the alternative columns. The alternative columns can be determined according to actual requirements, and the configuration operations of the alternative columns corresponding to different alternative columns are different. Namely, determining the unbound columns in the target sample table, and binding the alternative columns from the unbound columns according to the alternative column configuration operation. In the target sample table, if a column is already bound, other accounts cannot be bound to the column again, and thus cannot modify the column. After a column is bound by an account, the column may be modified by the account, and different accounts modify different alternative columns of the binding, so that different accounts need to determine corresponding alternative columns and target columns through different first configuration operations and second configuration operations.

After determining the candidate columns, the target columns may be determined from the candidate columns according to the target column configuration operation. The determination of the target column may be determined according to a corresponding target column configuration operation determined by specific requirements. The number of the candidate columns may be greater than or equal to the number of the target columns, after the candidate columns are determined, a part of the candidate columns may be determined as the target columns according to the target configuration operation, or all the candidate columns may be determined as the target columns, which is not limited herein.

In another embodiment, referring to fig. 2, a schematic diagram of a method for binding alternative columns is shown, where the method further includes:

in step S10, when all columns in the target sample table are bound, it is queried whether at least one bound column can be unbound.

In step S20, after the at least one bound column is unbound, an alternative column is bound from the at least one unbound column.

Before binding an alternative column from a column of the target sample table according to the alternative column configuration operation, it is determined whether there is an unbound column in the target sample table, i.e., whether all columns in the target sample table are bound. And if the columns in the target sample table are all bound, inquiring whether columns capable of being unbound exist in the bound columns, and if at least one column capable of being unbound exists, binding an alternative column from the unbound columns after the columns capable of being unbound are unbound.

The columns that can be unbound may be columns that can be unbound within a preset time period, and may be columns that can be unbound within a preset time period from a query time when at least one column that is bound can be queried to be unbound. And if the current time is the query time, the preset time duration is 10 seconds, and columns which can be unbound by other accounts within 10 seconds are selected.

For example, 10 columns in the target sample table are respectively bound by 3 accounts, before binding the alternative columns from the columns of the target sample table according to the alternative column configuration operation, if it is determined that all of the 10 columns of the target sample table are bound, whether the 10 columns can be unbound is queried, specifically, query information may be sent to the bound 3 accounts, and it is determined whether the columns capable of being unbound exist according to feedback information of the query information. If there are columns that can be unbound, such as the first, second, and fifth columns that can be unbound, then after the first, second, and fifth columns are unbound, the alternate columns are bound from the first, second, and fifth columns. The first column, the second column and the fifth column may all be bound as candidate columns, or one or two of the columns may be bound as candidate columns.

In another embodiment, the alternate column configuration entry includes: a data type configuration entry; and the data type configuration inlet is used for detecting the data type configuration operation of the data type in the configuration alternative column.

Referring to fig. 3, another schematic diagram of determining alternative columns, binding alternative columns in columns that are not bound, includes:

step a, according to the data type configuration operation, determining whether the data type of the data stored in the unbound column is consistent with the data type indicated by the data type configuration operation.

And b, binding the alternative columns from the unbound columns when the data types of the data stored in the unbound columns are consistent with the data types indicated by the data type configuration operation. The method specifically comprises the following steps: and binding the alternative columns of which the data types of the stored data are consistent with the data types indicated by the data type configuration operation according to the data type configuration operation.

The columns in the target sample table are used for storing sample data, different columns store different data information, when the target column is modified, the written data type needs to be consistent with the data type of the data stored in the target column, otherwise, the data in the target column cannot be normally modified. For example, if the data type of the data stored in the target column is character type, the data type of the data to be newly written is also character type when the target column is modified. If the data type of the data stored in the target column is integer, the data type of the newly written data is also integer when the target column is modified.

When the data type configuration entry detects a data type configuration operation, the data type configuration operation may indicate a data type that the data type configuration operation needs to configure, so the data type modified for the target column may be determined according to the data type configuration operation, and then, the data type modified for the target column may be compared with the data type of the data stored in the unbound column to determine whether the data type identical to the data type indicated by the data type configuration operation exists in the data types of the data stored in the unbound column. If the candidate columns exist, the target columns in the candidate columns can be modified after the candidate columns are bound from the unbound columns, and then the candidate columns, in which the data types of the stored data are consistent with the data types indicated by the data type configuration operation, are bound from the unbound columns.

For example, there are 10 columns in the target sample table, and there are 10 columns in the first to tenth columns, and there are second to fifth columns in the unbound columns, each having its own data storage type, and the stored data is also the data of that data type. For example, the data type of the second column of stored data is character type, the data type of the third column of stored data is integer type, and so on. And if the data type indicated by the data type configuration operation is a character type, determining whether the data types of the second to fifth columns of stored data are consistent with the character type, namely whether the data types of the second to fifth columns of stored data have the character type. And determining that the data type of the second column of stored data is consistent with the data type indicated by the data type configuration operation, and determining that the second column is an alternative column from the second column to the fifth column.

In another embodiment, referring to fig. 4, there is a flow chart of another method for modifying a sample table, the method includes:

step A, when a target sample table does not exist, displaying a creation page of the target sample table; and the creating page comprises at least one creating entry used for creating the target sample table.

Step B, creating a target sample table according to the creation operation received by the creation entrance; wherein the target sample table comprises a plurality of columns, each column comprising a plurality of rows.

And if the target sample table to be modified as required does not exist when the target sample table is determined, displaying a creation page of the target sample table, wherein the creation page is provided with a creation entry for creating the target sample table, the creation entry can detect a creation operation, and the target sample table can be created according to the creation operation. The target sample table is created with columns and rows, each corresponding to a plurality of columns, and each row may also correspond to a plurality of columns. The target sample table, which may be a data table in a database, is created with the function of a separate modified column.

In another embodiment, the method further comprises:

and when the columns in the target columns or the alternative columns except the target columns are not modified, unbundling the columns in the target columns or the alternative columns except the target columns.

In an alternative column of an account binding, if the account does not modify the target column in the alternative column within a certain time, the target column may be unbound. If the target column of the account needs to be modified within a certain time, and columns in the alternative column except the target column are not modified, other columns except the target column can be unbound, and the unbound columns can be bound by other accounts, so that the other accounts can modify the corresponding binding columns conveniently.

In another embodiment, the target sample table is a sample table of text data, and data in text form, such as character-type and integer-type data, is stored in the sample table of text data.

In another embodiment, referring to fig. 5, a schematic structural diagram of an apparatus for modifying a sample table is shown, the apparatus including:

a first configuration interface display module 1, configured to display a first configuration interface, where the first configuration interface has a first configuration entry, and the first configuration entry is used to detect a first configuration operation that determines a target sample table to be modified;

a second configuration interface display module 2, configured to display a second configuration interface according to a configuration result of the first configuration operation, where the second configuration interface has a second configuration entry, and the configuration entry is used to detect a second configuration operation for determining a target column in the target sample table;

a target column determination module 3, configured to determine the target column according to the second configuration operation;

the modification module is used for creating and executing modification tasks; wherein the modification task is used for modifying the target column.

In another embodiment, the second configuration portal comprises: configuring an alternative column configuration inlet of an alternative column and configuring a target column configuration inlet of a target column; the candidate column configuration entry is used for detecting candidate column configuration operation for configuring candidate columns, and the target column configuration entry is used for detecting target column configuration operation for configuring target columns;

the target column determination module 3 includes:

the alternative column binding unit is used for binding the alternative columns from the columns of the target sample table according to the alternative column configuration operation;

and the target column determining unit is used for determining the target column from the alternative columns according to the target column configuration operation.

In another embodiment, the alternative column binding unit includes:

an unbound column determining subunit that determines an unbound column in the target sample table;

a first candidate column determination subunit binding the candidate columns from the unbound columns according to the candidate column configuration operation.

In another embodiment, the alternative column binding unit further includes:

the query subunit is used for querying whether the bound at least one column can be unbound when the columns in the target sample table are all bound;

the second candidate column determination subunit, after the at least one column that is bound is unbound, binds the candidate column from the at least one column that is unbound.

In another embodiment, the alternate column configuration entry comprises: a data type configuration entry; the data type configuration entry is used for detecting data type configuration operation for configuring the data types in the alternative columns;

the first alternative column determines the subunit, and is further configured to:

determining whether the data type of the data stored in the unbound column is consistent with the data type indicated by the data type configuration operation according to the data type configuration operation; binding the alternative column from the unbound column when the data type of the data stored in the unbound column is consistent with the data type indicated by the data type configuration operation.

In another embodiment, the first alternative column identifies a subunit, further to:

and when the data type of the stored data in the unbound column is consistent with the data type indicated by the data type configuration operation, binding the alternative column in which the data type of the stored data is consistent with the data type indicated by the data type configuration operation according to the data type configuration operation.

In another embodiment, the apparatus further comprises:

the page creating display module is used for displaying a creating page of the target sample table when the target sample table does not exist; wherein the creation page comprises at least one creation entry for creating the target sample table;

the creating module is used for creating the target sample table according to the creating operation received by the creating inlet; wherein the target sample table comprises a plurality of columns, each column comprising a plurality of rows.

In another embodiment, the apparatus further comprises:

and the unbinding module is used for unbinding the columns except the target column in the target column or the alternative column when the columns except the target column in the target column or the alternative column are not modified.

In another embodiment, the target sample table is a sample table of text data.

In another embodiment, another example of a method for modifying a sample table is also provided.

In the traditional model training process, along with the change of features, the data backtracking, namely rewriting, of a sample table is often required from the selection of the features, the generation of samples and the final training of the model. The existing storage scheme is to rewrite the whole sample table, which results in the waste of computing resources and storage redundancy.

The invention discloses a method for modifying a sample table under a model training sample with multiple tenants, which can ensure the transaction isolation under mass data, and achieve the purposes of sample space autonomy and calculation resource saving.

The scheme is carried out through a sample table configuration Platform, such as an AI-Platform, and can provide a table building function and a data backtracking function, and a user can realize the management of a column (slot) of a sample table and the backtracking of slot data by filling in the meta information of the table. Referring to FIG. 6, a schematic diagram of an AI-Platform is shown, having a functional layer, a column (slot) management layer, an engine layer and a storage layer. The function layer can be used for sample table management, sample task management and the like, the column (slot) management layer can be used for column management, the engine layer can be used for management of a specific form of a sample table, such as an iceberg engine, and the storage layer can store data in the sample table, and can be hdfs distributed storage.

The storage scheme for the sample table uses the more popular iceberg technology at present. The method is a data storage scheme supporting target slot modification under mass data.

Referring to FIG. 7, a schematic diagram of creating a target sample table is shown.

Fig. 7 shows a sample table creation page having creation entries such as type, slot number, data type, and table name, from which a target sample table can be created. Other information in the figure can refer to fig. 7 and will not be described. For example, a 10-column target sample table may be created, with each column being a slot, for 10 slots, i.e., 10 columns.

Referring to fig. 8, a table information diagram of a target sample table created according to fig. 7 is shown. The table name, slot number, and the like of the sample table are shown in fig. 8. In addition, fig. 8 also shows a second configuration entry, such as an alternative column configuration entry, that is, the feature binding in fig. 8, the binding of the alternative column may be performed according to the alternative column configuration operation, which may be an operation acting on the "feature binding," and then the alternative column may be bound.

Referring to fig. 9, a schematic diagram of a configuration interface for binding alternative columns is shown. Slot id indicates the column position, i.e., the column number. The data type indicates the number type of the stored data per column, such as int type and double type. The state is the bound state of each column in the target sample table, the columns with

Slot id

1 and 2 are unbound, i.e. available states, and the two columns can be bound. The column with Slot id 3 is in a bound state, namely an occupied state, and cannot be bound.

When columns with the Slot ids of 1 and 2 can be bound, determining the columns which need to be bound finally according to the data types corresponding to the columns with the Slot ids of 1 and 2 and the data types indicated by the data type configuration operation, and if the data types indicated by the data type configuration operation are int types, binding the columns with the Slot ids of 1 and 2 into alternative columns.

Referring to FIG. 10, a diagram of creating modification tasks is shown. The creation may be performed according to the creation entry shown in fig. 10, each block in the drawing is the creation entry, and the modification task may be created by combining a plurality of creation entries, and each creation entry shown in the drawing is not described one by one. Referring to fig. 11, a schematic diagram of task information of a created modification task is shown, where the diagram includes a sequence number, a name, a sample table name, a creation time, a task type and a status of the task.

Referring to fig. 12, a schematic diagram of a modification flow of a sample table is shown, where when a valid attribute in the sample table is a binding candidate column, in a data type of the unbound column storage data, whether a data type identical to the data type indicated by the data type configuration operation exists or not is shown.

In another embodiment, there is also provided an electronic device including:

a processor and a memory for storing executable instructions operable on the processor, wherein:

when the processor is used for executing the executable instructions, the executable instructions execute the method of any one of the above embodiments.

In another embodiment, a non-transitory computer-readable storage medium is also provided, having stored therein computer-executable instructions that, when executed by a processor, implement the method of any of the above embodiments.

It should be noted that "first" and "second" in the embodiments of the present disclosure are merely for convenience of description and distinction, and have no other specific meaning.

FIG. 13 is a block diagram illustrating a sample table configuration platform in accordance with an exemplary embodiment. For example, the sample table configuration platform may be a mobile phone, a computer, a digital broadcast terminal, a messaging device, a tablet device, a personal digital assistant, and the like.

Referring to FIG. 13, the sample table configuration platform may include one or more of the following components: a processing component 802, a memory 804, a power component 806, a multimedia component 808, an audio component 810, an input/output (I/O) interface 812, a sensor component 814, and a communication component 816.

The processing component 802 generally controls the overall operation of the sample table configuration platform, such as operations associated with presentation, phone calls, data communications, camera operations, and recording operations. The processing components 802 may include one or more processors 820 to execute instructions to perform all or a portion of the steps of the methods described above. Further, the processing component 802 can include one or more modules that facilitate interaction between the processing component 802 and other components. For example, the processing component 802 can include a multimedia module to facilitate interaction between the multimedia component 808 and the processing component 802.

The memory 804 is configured to store various types of data to support operations on the sample table configuration platform. Examples of such data include instructions for any application or method operating on the sample table configuration platform, contact data, phonebook data, messages, pictures, videos, and the like. The memory 804 may be implemented by any type or combination of volatile or non-volatile memory devices such as Static Random Access Memory (SRAM), electrically erasable programmable read-only memory (EEPROM), erasable programmable read-only memory (EPROM), programmable read-only memory (PROM), read-only memory (ROM), magnetic memory, flash memory, magnetic or optical disks.

A power component 806 provides power to various components of the sample table configuration platform. The power components 806 may include a power management system, one or more power sources, and other components associated with generating, managing, and distributing power for the sample table configuration platform.

The multimedia component 808 includes a screen that provides an output interface between the sample table configuration platform and the user. In some embodiments, the screen may include a Liquid Crystal Display (LCD) and a Touch Panel (TP). If the screen includes a touch panel, the screen may be implemented as a touch screen to receive an input signal from a user. The touch panel includes one or more touch sensors to sense touch, slide, and gestures on the touch panel. The touch sensor may not only sense the boundary of a touch or slide action, but also detect the duration and pressure associated with the touch or slide operation. In some embodiments, the multimedia component 808 includes a front facing camera and/or a rear facing camera. When the sample table configuration platform is in an operation mode, such as a shooting mode or a video mode, the front camera and/or the rear camera can receive external multimedia data. Each front camera and rear camera may be a fixed optical lens system or have a focal length and optical zoom capability.

The audio component 810 is configured to output and/or input audio signals. For example, the audio component 810 includes a Microphone (MIC) configured to receive an external audio signal when the sample meter configuration platform is in an operational mode, such as a call mode, a recording mode, and a voice recognition mode. The received audio signals may further be stored in the memory 804 or transmitted via the communication component 816. In some embodiments, audio component 810 also includes a speaker for outputting audio signals.

The I/O interface 812 provides an interface between the processing component 802 and peripheral interface modules, which may be keyboards, click wheels, buttons, etc. These buttons may include, but are not limited to: a home button, a volume button, a start button, and a lock button.

The sensor component 814 includes one or more sensors for providing various aspects of state assessment for the sample table configuration platform. For example, the sensor component 814 may detect the open/closed state of the sample meter configuration platform, the relative positioning of the components, such as the display and keypad of the sample meter configuration platform, the sensor component 814 may also detect a change in position of the sample meter configuration platform or a component of the sample meter configuration platform, the presence or absence of user contact with the sample meter configuration platform, the orientation or acceleration/deceleration of the sample meter configuration platform, and a change in temperature of the sample meter configuration platform. Sensor assembly 814 may include a proximity sensor configured to detect the presence of a nearby object without any physical contact. The sensor assembly 814 may also include a light sensor, such as a CMOS or CCD image sensor, for use in imaging applications. In some embodiments, the sensor assembly 814 may also include an acceleration sensor, a gyroscope sensor, a magnetic sensor, a pressure sensor, or a temperature sensor.

The communication component 816 is configured to facilitate wired or wireless communication between the sample table configuration platform and other devices. The sample table configuration platform may have access to a wireless network based on a communication standard, such as WiFi, 2G or 3G, or a combination thereof. In an exemplary embodiment, the communication component 816 receives a broadcast signal or broadcast related information from an external broadcast management system via a broadcast channel. In an exemplary embodiment, communications component 816 further includes a Near Field Communications (NFC) module to facilitate short-range communications. For example, the NFC module may be implemented based on Radio Frequency Identification (RFID) technology, infrared data association (IrDA) technology, Ultra Wideband (UWB) technology, Bluetooth (BT) technology, and other technologies.

In an exemplary embodiment, the sample table configuration platform may be implemented by one or more Application Specific Integrated Circuits (ASICs), Digital Signal Processors (DSPs), Digital Signal Processing Devices (DSPDs), Programmable Logic Devices (PLDs), Field Programmable Gate Arrays (FPGAs), controllers, micro-controllers, microprocessors, or other electronic components for performing the above-described methods.

Other embodiments of the disclosure will be apparent to those skilled in the art from consideration of the specification and practice of the disclosure disclosed herein. This disclosure is intended to cover any variations, uses, or adaptations of the disclosure following, in general, the principles of the disclosure and including such departures from the present disclosure as come within known or customary practice within the art to which the disclosure pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the disclosure being indicated by the following claims.

It will be understood that the present disclosure is not limited to the precise arrangements described above and shown in the drawings and that various modifications and changes may be made without departing from the scope thereof. The scope of the present disclosure is limited only by the appended claims.

Claims

1. A method for modifying a sample table, comprising:

displaying a first configuration interface, wherein the first configuration interface is provided with a first configuration inlet, and the first configuration inlet is used for detecting a first configuration operation of a target sample table determined to be modified;

displaying a second configuration interface according to a configuration result of the first configuration operation, wherein the second configuration interface is provided with a second configuration inlet, and the second configuration inlet is used for detecting and determining a second configuration operation of a target column in the target sample table;

determining the target column according to the second configuration operation;

creating and executing a modification task; wherein the modification task is used for modifying the target column.

2. The method of claim 1, wherein the second configuration portal comprises: configuring an alternative column configuration inlet of an alternative column and configuring a target column configuration inlet of a target column; the candidate column configuration entry is used for detecting candidate column configuration operation for configuring candidate columns, and the target column configuration entry is used for detecting target column configuration operation for configuring target columns;

the determining the target column according to the second configuration operation includes:

binding the alternative columns from the columns of the target sample table according to the alternative column configuration operation;

and determining the target column from the alternative columns according to the target column configuration operation.

3. The method of claim 2, wherein the binding the alternative column from the column of the target sample table according to the alternative column configuration operation comprises:

determining unbound columns in the target sample table;

binding the alternative columns from the unbound columns according to the alternative column configuration operation.

4. The method of claim 3, further comprising:

when all columns in the target sample table are bound, inquiring whether the bound at least one column can be unbound;

after the bound at least one column is unbound, binding the alternative column from the unbound at least one column.

5. The method of claim 3, wherein the alternative column configuration entry comprises: a data type configuration entry; the data type configuration entry is used for detecting data type configuration operation for configuring the data types in the alternative columns;

the binding the alternative columns from the unbound columns includes:

determining whether the data type of the data stored in the unbound column is consistent with the data type indicated by the data type configuration operation according to the data type configuration operation;

binding the alternative column from the unbound column when the data type of the data stored in the unbound column is consistent with the data type indicated by the data type configuration operation.

6. The method of claim 5, further comprising:

when the data type of the data stored in the unbound column is consistent with the data type indicated by the data type configuration operation, binding the alternative column in which the data type of the data is consistent with the data type indicated by the data type configuration operation according to the data type configuration operation.

7. The method according to claim 1, characterized in that it comprises:

when the target sample table does not exist, displaying a creation page of the target sample table; wherein the creation page comprises at least one creation entry for creating the target sample table;

creating the target sample table according to the creation operation received by the creation entrance; wherein the target sample table comprises a plurality of columns, each column comprising a plurality of rows.

8. The method of claim 1, further comprising:

unbinding the columns of the target column or the alternative columns other than the target column without modifying the columns of the target column or the alternative columns other than the target column.

9. The method of claim 1, wherein the target sample table is a sample table of text data.

10. An apparatus for modifying a sample table, comprising:

the system comprises a first configuration interface display module, a first configuration interface display module and a second configuration interface display module, wherein the first configuration interface display module is used for displaying a first configuration interface, and the first configuration interface is provided with a first configuration inlet which is used for detecting a first configuration operation of a target sample table determined to be modified;

a second configuration interface display module, configured to display a second configuration interface according to a configuration result of the first configuration operation, where the second configuration interface has a second configuration entry, and the configuration entry is used to detect a second configuration operation for determining a target column in the target sample table;

a target column determination module, configured to determine the target column according to the second configuration operation;

11. An electronic device, comprising:

the processor is configured to execute the executable instructions, when the executable instructions are executed, to perform the method of any of the preceding claims 1 to 9.

12. A non-transitory computer-readable storage medium having stored thereon computer-executable instructions that, when executed by a processor, perform the method of any of claims 1 to 9.