CN117539460A - Data set editing processing method and system - Google Patents
Data set editing processing method and system Download PDFInfo
- Publication number
- CN117539460A CN117539460A CN202311423061.4A CN202311423061A CN117539460A CN 117539460 A CN117539460 A CN 117539460A CN 202311423061 A CN202311423061 A CN 202311423061A CN 117539460 A CN117539460 A CN 117539460A
- Authority
- CN
- China
- Prior art keywords
- data
- page
- target
- name
- structure information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 11
- 238000012545 processing Methods 0.000 claims abstract description 43
- 238000000034 method Methods 0.000 claims description 22
- 238000013524 data verification Methods 0.000 claims description 4
- 238000012795 verification Methods 0.000 claims 1
- 238000012986 modification Methods 0.000 abstract description 4
- 230000004048 modification Effects 0.000 abstract description 4
- 230000006870 function Effects 0.000 description 11
- 238000004891 communication Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 6
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000001514 detection method Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000006243 chemical reaction Methods 0.000 description 2
- 238000013461 design Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 239000004973 liquid crystal related substance Substances 0.000 description 2
- 230000007774 longterm Effects 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000010295 mobile communication Methods 0.000 description 2
- 230000005236 sound signal Effects 0.000 description 2
- 230000001133 acceleration Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 230000001419 dependent effect Effects 0.000 description 1
- 238000007599 discharging Methods 0.000 description 1
- 230000005484 gravity Effects 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000010897 surface acoustic wave method Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/38—Creation or generation of source code for implementing user interfaces
Landscapes
- Engineering & Computer Science (AREA)
- Software Systems (AREA)
- General Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The application discloses a data set editing processing method and system, after a data set scheme is created or read, a corresponding data page and a structure page are generated, data names or structures corresponding to data in the data page are modified and correspondingly displayed in the structure page, and data names or data structure information in the structure page are modified and correspondingly and synchronously modified in the data page, so that the structure information of the whole data set is visualized, the convenience of data structure modification is greatly improved, and the technical problems that the conventional data editing processing software is complicated in data set format editing processing and cannot intuitively and conveniently perform personalized adjustment on circulation data in the system are solved.
Description
Technical Field
The present disclosure relates to the field of data processing technologies, and in particular, to a method and a system for editing and processing a data set.
Background
In the current data editing processing software, only a data page is usually provided to realize the creation or the entry of a data set, and the data structure information in the data page cannot be automatically changed by a user, so that the technical problem of personalized adjustment of the circulation data in the system cannot be intuitively and conveniently realized.
Disclosure of Invention
The application provides a data set editing processing method and system, which solve the technical problems that the format editing processing of the data set by the existing data editing processing software is complex, and the circulation data in the system cannot be intuitively and conveniently subjected to personalized adjustment.
In view of this, a first aspect of the present application provides a data set editing processing method, the method including:
s1, creating or reading a data set scheme, and generating a data page and a corresponding structure page, wherein the data page comprises a data name contained in a first row of each column and data contained in other rows of each column, and the structure page comprises a structure information name contained in a first row and a non-first row, a data name of the first row and the non-first row corresponding to the data page and data structure information of the non-first row and the non-first row;
s2, modifying the data name or the data structure information in the structure page, and correspondingly changing the data name or the structure corresponding to the data in the data page;
or (b)
S3, modifying the data name in the data page, and the structure corresponding to each row or column of data, wherein the data name or the data structure information in the structure page is correspondingly changed.
Optionally, the step S2 or S3 specifically includes:
modifying the visible data structure information corresponding to the target data name in the structure page from a visible state or an invisible state to an invisible state or a visible state, and hiding or displaying the column of the corresponding target data name in the data page;
or (b)
And modifying the column of the target data name in the data page from display or hiding to hiding or display, and modifying the visibility data structure information of the corresponding target data name in the structure page from a visible state or an invisible state to an invisible state or a visible state.
Optionally, the step S2 or S3 specifically includes:
modifying the data structure information of the field type corresponding to the target data name in the structure page into a target field type, and modifying the data corresponding field type corresponding to the target data name in the data page into a target field type;
or (b)
And modifying the field type of the data of the column of the target data name in the data page into a target field type, and modifying the field type data structure information of the corresponding target data name in the structure page into the target field type.
Optionally, the step S2 or S3 specifically includes:
modifying the data structure information of the corresponding width of the target data name in the structure page into a target width value, and modifying the width of the column of the corresponding target data name in the data page into a target width;
or (b)
And modifying the width of the column of the target data name in the data page into a target width by dragging, and modifying the width data structure information of the corresponding target data name in the structure page into a target width value.
Optionally, the method further comprises:
and carrying out data verification on the field of the target data name by entering the target enumeration value in the data page, and displaying the corresponding target enumeration value in enumeration value data structure information of the corresponding target data name in the structure page.
A second aspect of the present application provides a data set editing processing system, the system comprising:
the generating unit is used for creating or reading a data set scheme, generating a data page and a corresponding structure page, wherein the data page comprises a data name contained in a first row of each column and data contained in other rows of each column, and the structure page comprises a structure information name contained in a first row and a non-first row, a data name of the first row and the non-first row corresponding to the data page and data structure information of the non-first row and the non-first row;
the first processing unit is used for modifying the data name or the data structure information in the structure page, and correspondingly modifying the data name or the structure corresponding to the data in the data page;
or (b)
And the second processing unit is used for modifying the data name in the data page, the structure corresponding to each row or each column of data, and correspondingly modifying the data name or the data structure information in the structure page.
Optionally, the first processing unit is specifically configured to modify the visibility data structure information corresponding to the target data name in the structure page from a visible state or an invisible state to an invisible state or a visible state, where the column of the corresponding target data name in the data page is hidden or displayed;
or (b)
The second processing unit is specifically configured to modify, from display or hiding to hiding or display, a column in which the target data name in the data page is located, and modify, from a visible state or an invisible state to an invisible state or a visible state, the visibility data structure information of the corresponding target data name in the structure page.
Optionally, the first processing unit is specifically configured to modify the data structure information of the field type corresponding to the target data name in the structure page into a target field type, and modify the data corresponding field type of the corresponding target data name in the data page into the target field type;
or (b)
The second processing unit is specifically configured to modify a field type of data in a column where the target data name is located in the data page into a target field type, and modify field type data structure information corresponding to the target data name in the structure page into the target field type.
A third aspect of the present application provides a data set editing processing apparatus, the apparatus comprising a processor and a memory:
the memory is used for storing program codes and transmitting the program codes to the processor;
the processor is configured to execute the steps of the data set editing processing method according to the first aspect described above according to instructions in the program code.
A fourth aspect of the present application provides a computer readable storage medium for storing program code for performing the method of the first aspect described above.
From the above technical solutions, the embodiments of the present application have the following advantages:
in the application, after a data set scheme is created or read, a corresponding data page and a structure page are generated, the data name or the structure corresponding to the data in the data page is modified and correspondingly displayed in the structure page, and the data name or the data structure information in the structure page is modified and correspondingly and synchronously modified in the data page, so that the structure information of the whole data set is visualized, the convenience of data structure modification is greatly improved, and the technical problem that the conventional data editing processing software is complicated in editing and processing the format of the data set and cannot intuitively and conveniently perform personalized adjustment on the circulation data in the system is solved.
Drawings
FIG. 1 is a flow chart of a method for processing data set editing in an embodiment of the present application;
FIG. 2 is a schematic diagram of a data set editing processing system in an embodiment of the present application;
fig. 3 is a schematic structural diagram of a data set editing processing device in an embodiment of the present application;
FIG. 4 is a display diagram of a data page in an embodiment of the present application;
fig. 5 is a display diagram of a structural page in an embodiment of the present application.
Detailed Description
In order to make the present application solution better understood by those skilled in the art, the following description will clearly and completely describe the technical solution in the embodiments of the present application with reference to the accompanying drawings in the embodiments of the present application, and it is apparent that the described embodiments are only some embodiments of the present application, not all embodiments. All other embodiments, which can be made by one of ordinary skill in the art without undue burden from the present disclosure, are within the scope of the present disclosure.
The application designs a data set editing processing method and system, which solve the technical problems that the existing data editing processing software is complicated in data set format editing processing and cannot intuitively adjust the format of the whole data set.
For ease of understanding, referring to fig. 1, fig. 1 is a flowchart of a method for processing data set editing in an embodiment of the present application, as shown in fig. 1, specifically:
s1, creating or reading a data set scheme, and generating a data page and a corresponding structure page, wherein the data page comprises a data name contained in a first row of each column and data contained in other rows of each column, and the structure page comprises a structure information name contained in a first row and not the first row, a data name of the data page corresponding to the first row and not the first row;
it should be noted that the saved ds file may be directly opened, the saved data schema may be directly selected for opening, or a new data set schema may be created.
As shown in fig. 4 and fig. 5, a data set scheme includes a data page and a corresponding structure page, where the data page may be understood as a data page that is usually edited, that is, in the data page, the data name and the corresponding data may be entered. In addition, the structure page includes a structure information name, a data name corresponding to the data page, and data structure information, where the structure information name refers to what structure of the data is modified, the data structure information refers to a current state of the structure of the data, for example, the structure information name is visibility, and the data structure information may be TURE or FALSE.
S2, modifying the data name or the data structure information in the structure page, and correspondingly changing the data name or the structure corresponding to the data in the data page;
or (b)
S3, modifying the data name in the data page, the structure corresponding to each row or each column of data, and correspondingly modifying the data name or the data structure information in the structure page.
It should be noted that, in the data set processing method of the present application, the structure related information of the data is updated in the corresponding data page or the structure page, whether in the structure page or the data page, where the structure page includes, but is not limited to, the data structure information such as the visibility, the display format, the display width, the annotation, the field type, the percentage number, the decimal number, and the like in the data page.
Further, the step S2 or S3 specifically includes:
modifying the visibility data structure information corresponding to the target data name in the structure page from a visible state or an invisible state to an invisible state or a visible state, and hiding or displaying the column of the corresponding target data name in the data page;
or (b)
The column of the target data name in the data page is changed from display or hiding to hiding or display, and the visibility data structure information of the corresponding target data name in the structure page is changed from a visible state or an invisible state to an invisible state or a visible state.
Further, the step S2 or S3 specifically includes:
modifying the data structure information of the field type corresponding to the target data name in the structure page into a target field type, and modifying the data corresponding field type corresponding to the target data name in the data page into a target field type;
or (b)
And modifying the field type of the data of the column of the target data name in the data page into a target field type, and modifying the field type data structure information of the corresponding target data name in the structure page into the target field type.
Wherein, when the field type is set to currency format, the thousandth bit separator can be further modified in the structure page to display decimal numbers, currency prefixes and the like.
Further, the step S2 or S3 specifically includes:
the data structure information of the width corresponding to the target data name in the structure page is modified into a target width value, and the width of the column of the corresponding target data name in the data page is modified into a target width;
or (b)
The width of the column of the target data name in the data page is modified to be the target width through dragging, and the width data structure information of the corresponding target data name in the structure page is modified to be the target width value.
Further, the method further comprises the following steps:
and carrying out data verification on the field of the target data name by entering the target enumeration value in the data page, and displaying the corresponding target enumeration value in enumeration value data structure information of the corresponding target data name in the structure page.
Referring to fig. 2, fig. 2 is a schematic structural diagram of a data set editing processing system in the embodiment of the present application, as shown in fig. 2, specifically:
the generating unit 201 is configured to create or read a data set scheme, and generate a data page and a corresponding structure page, where the data page includes a data name included in a first row of each column and data included in other rows of each column, and the structure page includes a structure information name included in a first row and not a first row, a data name of a first row and not a first column corresponding to the data page, and data structure information of a non-first row and not a first column;
the first processing unit 202 is configured to modify a data name or data structure information in a structure page, and correspondingly change a data name or a structure corresponding to data in the data page;
or (b)
The second processing unit 203 is configured to modify a data name in a data page, a structure corresponding to each row or each column of data, and correspondingly modify a data name or data structure information in a structure page.
Optionally, the first processing unit 202 is specifically configured to modify the visibility data structure information corresponding to the target data name in the structure page from a visible state or an invisible state to an invisible state or a visible state, and hide or display the column in which the corresponding target data name in the data page is located;
or (b)
The second processing unit 203 is specifically configured to modify, from display or hiding to hiding or displaying, a column in which the target data name in the data page is located, and modify, from a visible state or an invisible state to an invisible state or a visible state, the visibility data structure information of the corresponding target data name in the structure page.
Optionally, the first processing unit 202 is specifically configured to modify the data structure information of the field type corresponding to the target data name in the structure page to the target field type, and modify the data corresponding to the field type corresponding to the target data name in the data page to the target field type;
or (b)
The second processing unit 203 is specifically configured to modify a field type of data in a column where a target data name is located in a data page into a target field type, and modify field type data structure information corresponding to the target data name in a structure page into the target field type.
The embodiment of the present application further provides another data set editing processing device, as shown in fig. 3, for convenience of explanation, only the portion relevant to the embodiment of the present application is shown, and specific technical details are not disclosed, please refer to the method portion of the embodiment of the present application. The terminal can be any terminal equipment including a mobile phone, a tablet personal computer, a personal digital assistant (English full name: personal Digital Assistant, english abbreviation: PDA), a Sales terminal (English full name: point of Sales, english abbreviation: POS), a vehicle-mounted computer and the like, taking the mobile phone as an example of the terminal:
fig. 3 is a block diagram showing a part of a structure of a mobile phone related to a terminal provided in an embodiment of the present application. Referring to fig. 3, the mobile phone includes: radio Frequency (RF) circuit 1010, memory 1020, input unit 1030, display unit 1040, sensor 1050, audio circuit 1060, wireless fidelity (wireless fidelity, wiFi) module 1070, processor 1080, and power source 1090. Those skilled in the art will appreciate that the handset configuration shown in fig. 3 is not limiting of the handset and may include more or fewer components than shown, or may combine certain components, or may be arranged in a different arrangement of components.
The following describes the components of the mobile phone in detail with reference to fig. 3:
the RF circuit 1010 may be used for receiving and transmitting signals during a message or a call, and particularly, after receiving downlink information of a base station, the signal is processed by the processor 1080; in addition, the data of the design uplink is sent to the base station. Generally, RF circuitry 1010 includes, but is not limited to, an antenna, at least one amplifier, a transceiver, a coupler, a low noise amplifier (English full name: low Noise Amplifier, english abbreviation: LNA), a duplexer, and the like. In addition, the RF circuitry 1010 may also communicate with networks and other devices via wireless communications. The wireless communication may use any communication standard or protocol, including but not limited to global system for mobile communications (english: global System of Mobile communication, english: GSM), general packet radio service (english: general Packet Radio Service, GPRS), code division multiple access (english: code Division Multiple Access, english: CDMA), wideband code division multiple access (english: wideband Code Division Multiple Access, english: WCDMA), long term evolution (english: long Term Evolution, english: LTE), email, short message service (english: short Messaging Service, SMS), and the like.
The memory 1020 may be used to store software programs and modules that the processor 1080 performs various functional applications and data processing of the handset by executing the software programs and modules stored in the memory 1020. The memory 1020 may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program (such as a sound playing function, an image playing function, etc.) required for at least one function, and the like; the storage data area may store data (such as audio data, phonebook, etc.) created according to the use of the handset, etc. In addition, memory 1020 may include high-speed random access memory and may also include non-volatile memory, such as at least one magnetic disk storage device, flash memory device, or other volatile solid state memory device.
The input unit 1030 may be used to receive input numeric or character information and generate key signal inputs related to user settings and function control of the handset. In particular, the input unit 1030 may include a touch panel 1031 and other input devices 1032. The touch panel 1031, also referred to as a touch screen, may collect touch operations thereon or thereabout by a user (e.g., operations of the user on the touch panel 1031 or thereabout using any suitable object or accessory such as a finger, stylus, etc.), and drive the corresponding connection device according to a predetermined program. Alternatively, the touch panel 1031 may include two parts, a touch detection device and a touch controller. The touch detection device detects the touch azimuth of a user, detects a signal brought by touch operation and transmits the signal to the touch controller; the touch controller receives touch information from the touch detection device and converts it into touch point coordinates, which are then sent to the processor 1080 and can receive commands from the processor 1080 and execute them. Further, the touch panel 1031 may be implemented in various types such as resistive, capacitive, infrared, and surface acoustic wave. The input unit 1030 may include other input devices 1032 in addition to the touch panel 1031. In particular, other input devices 1032 may include, but are not limited to, one or more of a physical keyboard, function keys (e.g., volume control keys, switch keys, etc.), a track ball, a mouse, a joystick, etc.
The display unit 1040 may be used to display information input by a user or information provided to the user and various menus of the mobile phone. The display unit 1040 may include a display panel 1041, and alternatively, the display panel 1041 may be configured in the form of a liquid crystal display (english full name: liquid Crystal Display, acronym: LCD), an Organic Light-Emitting Diode (OLED), or the like. Further, the touch panel 1031 may overlay the display panel 1041, and when the touch panel 1031 detects a touch operation thereon or thereabout, the touch panel is transferred to the processor 1080 to determine a type of touch event, and then the processor 1080 provides a corresponding visual output on the display panel 1041 according to the type of touch event. Although in fig. 3, the touch panel 1031 and the display panel 1041 are two independent components for implementing the input and output functions of the mobile phone, in some embodiments, the touch panel 1031 and the display panel 1041 may be integrated to implement the input and output functions of the mobile phone.
The handset may also include at least one sensor 1050, such as a light sensor, a motion sensor, and other sensors. Specifically, the light sensor may include an ambient light sensor and a proximity sensor, wherein the ambient light sensor may adjust the brightness of the display panel 1041 according to the brightness of ambient light, and the proximity sensor may turn off the display panel 1041 and/or the backlight when the mobile phone moves to the ear. As one of the motion sensors, the accelerometer sensor can detect the acceleration in all directions (generally three axes), and can detect the gravity and direction when stationary, and can be used for applications of recognizing the gesture of a mobile phone (such as horizontal and vertical screen switching, related games, magnetometer gesture calibration), vibration recognition related functions (such as pedometer and knocking), and the like; other sensors such as gyroscopes, barometers, hygrometers, thermometers, infrared sensors, etc. that may also be configured with the handset are not described in detail herein.
Audio circuitry 1060, a speaker 1061, and a microphone 1062 may provide an audio interface between a user and a cell phone. Audio circuit 1060 may transmit the received electrical signal after audio data conversion to speaker 1061 for conversion by speaker 1061 into an audio signal output; on the other hand, microphone 1062 converts the collected sound signals into electrical signals, which are received by audio circuit 1060 and converted into audio data, which are processed by audio data output processor 1080 for transmission to, for example, another cell phone via RF circuit 1010 or for output to memory 1020 for further processing.
WiFi belongs to a short-distance wireless transmission technology, and a mobile phone can help a user to send and receive emails, browse webpages, access streaming media and the like through a WiFi module 1070, so that wireless broadband Internet access is provided for the user. Although fig. 3 shows a WiFi module 1070, it is understood that it does not belong to the necessary constitution of the handset, and can be omitted entirely as required within the scope of not changing the essence of the invention.
Processor 1080 is the control center of the handset, connects the various parts of the entire handset using various interfaces and lines, and performs various functions and processes of the handset by running or executing software programs and/or modules stored in memory 1020, and invoking data stored in memory 1020, thereby performing overall monitoring of the handset. Optionally, processor 1080 may include one or more processing units; preferably, processor 1080 may integrate an application processor primarily handling operating systems, user interfaces, applications, etc., with a modem processor primarily handling wireless communications. It will be appreciated that the modem processor described above may not be integrated into processor 1080.
The handset further includes a power source 1090 (e.g., a battery) for powering the various components, which may preferably be logically connected to the processor 1080 by a power management system, such as to provide for managing charging, discharging, and power consumption by the power management system.
Although not shown, the mobile phone may further include a camera, a bluetooth module, etc., which will not be described herein.
In the embodiment of the present application, the processor 1080 included in the terminal further has the following functions:
s1, creating or reading a data set scheme, and generating a data page and a corresponding structure page, wherein the data page comprises a data name contained in a first row of each column and data contained in other rows of each column, and the structure page comprises a structure information name contained in a first row and not the first row, a data name of the data page corresponding to the first row and not the first row;
s2, modifying the data name or the data structure information in the structure page, and correspondingly changing the data name or the structure corresponding to the data in the data page;
or (b)
S3, modifying the data name in the data page, the structure corresponding to each row or each column of data, and correspondingly modifying the data name or the data structure information in the structure page.
The present application also provides a computer-readable storage medium storing program code for executing any one of the specific implementation methods of the data set editing processing methods of the foregoing embodiments.
In the embodiment of the application, after a data set scheme is created or read, a corresponding data page and a structure page are generated, the data name or the structure corresponding to the data in the data page is modified and correspondingly displayed in the structure page, and the data name or the data structure information in the structure page is modified and correspondingly and synchronously modified in the data page, so that the structure information of the whole data set is visualized, the convenience of data structure modification is greatly improved, and the technical problem that the conventional data editing processing software is complicated in editing the format of the data set and cannot intuitively and conveniently perform personalized adjustment on the circulating data in the system is solved.
It will be clear to those skilled in the art that, for convenience and brevity of description, specific working procedures of the above-described systems, apparatuses and units may refer to corresponding procedures in the foregoing method embodiments, which are not repeated herein.
The terms "first," "second," "third," "fourth," and the like in the description of the present application and in the above-described figures, if any, are used for distinguishing between similar objects and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used may be interchanged where appropriate such that embodiments of the present application described herein may be capable of operation in sequences other than those illustrated or described herein, for example. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
It should be understood that in this application, "at least one" means one or more, and "a plurality" means two or more. "and/or" for describing the association relationship of the association object, the representation may have three relationships, for example, "a and/or B" may represent: only a, only B and both a and B are present, wherein a, B may be singular or plural. The character "/" generally indicates that the context-dependent object is an "or" relationship. "at least one of" or the like means any combination of these items, including any combination of single item(s) or plural items(s). For example, at least one (one) of a, b or c may represent: a, b, c, "a and b", "a and c", "b and c", or "a and b and c", wherein a, b, c may be single or plural.
In the several embodiments provided in this application, it should be understood that the disclosed systems, apparatuses, and methods may be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative, e.g., the division of the units is merely a logical function division, and there may be additional divisions when actually implemented, e.g., multiple units or components may be combined or integrated into another system, or some features may be omitted or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or units, which may be in electrical, mechanical or other form.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in each embodiment of the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be embodied in essence or a part contributing to the prior art or all or part of the technical solution in the form of a software product stored in a storage medium, including several instructions to cause a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods described in the embodiments of the present application. And the aforementioned storage medium includes: u disk, mobile hard disk, read-Only Memory (ROM), random access Memory (Random Access Memory, RAM), magnetic disk or optical disk, etc.
The above embodiments are merely for illustrating the technical solution of the present application, and not for limiting the same; although the present application has been described in detail with reference to the foregoing embodiments, it should be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the corresponding technical solutions.
Claims (10)
1. A data set editing processing method, comprising:
s1, creating or reading a data set scheme, and generating a data page and a corresponding structure page, wherein the data page comprises a data name contained in a first row of each column and data contained in other rows of each column, and the structure page comprises a structure information name contained in a first row and a non-first row, a data name of the first row and the non-first row corresponding to the data page and data structure information of the non-first row and the non-first row;
s2, modifying the data name or the data structure information in the structure page, and correspondingly changing the data name or the structure corresponding to the data in the data page;
or (b)
S3, modifying the data name in the data page, and the structure corresponding to each row or column of data, wherein the data name or the data structure information in the structure page is correspondingly changed.
2. The method according to claim 1, wherein the step S2 or S3 specifically comprises:
modifying the visible data structure information corresponding to the target data name in the structure page from a visible state or an invisible state to an invisible state or a visible state, and hiding or displaying the column of the corresponding target data name in the data page;
or (b)
And modifying the column of the target data name in the data page from display or hiding to hiding or display, and modifying the visibility data structure information of the corresponding target data name in the structure page from a visible state or an invisible state to an invisible state or a visible state.
3. The method according to claim 1, wherein the step S2 or S3 specifically comprises:
modifying the data structure information of the field type corresponding to the target data name in the structure page into a target field type, and modifying the data corresponding field type corresponding to the target data name in the data page into a target field type;
or (b)
And modifying the field type of the data of the column of the target data name in the data page into a target field type, and modifying the field type data structure information of the corresponding target data name in the structure page into the target field type.
4. The method according to claim 1, wherein the step S2 or S3 specifically comprises:
modifying the data structure information of the corresponding width of the target data name in the structure page into a target width value, and modifying the width of the column of the corresponding target data name in the data page into a target width;
or (b)
And modifying the width of the column of the target data name in the data page into a target width by dragging, and modifying the width data structure information of the corresponding target data name in the structure page into a target width value.
5. The data set editing processing method according to claim 1, further comprising:
and carrying out data verification on the field of the target data name by entering the target enumeration value in the data page, and displaying the corresponding target enumeration value in enumeration value data structure information of the corresponding target data name in the structure page.
6. A data set editing processing system, comprising:
the generating unit is used for creating or reading a data set scheme, generating a data page and a corresponding structure page, wherein the data page comprises a data name contained in a first row of each column and data contained in other rows of each column, and the structure page comprises a structure information name contained in a first row and a non-first row, a data name of the first row and the non-first row corresponding to the data page and data structure information of the non-first row and the non-first row;
the first processing unit is used for modifying the data name or the data structure information in the structure page, and correspondingly modifying the data name or the structure corresponding to the data in the data page;
or (b)
And the second processing unit is used for modifying the data name in the data page, the structure corresponding to each row or each column of data, and correspondingly modifying the data name or the data structure information in the structure page.
7. The data set editing processing system according to claim 6, wherein:
the first processing unit is specifically configured to modify the visibility data structure information corresponding to the target data name in the structure page from a visible state or an invisible state to an invisible state or a visible state, where the column of the corresponding target data name in the data page is hidden or displayed;
or (b)
The second processing unit is specifically configured to modify, from display or hiding to hiding or display, a column in which the target data name in the data page is located, and modify, from a visible state or an invisible state to an invisible state or a visible state, the visibility data structure information of the corresponding target data name in the structure page.
8. The data set editing processing system according to claim 6, wherein:
the first processing unit is specifically configured to modify the data structure information of the field type corresponding to the target data name in the structure page into a target field type, where the field type corresponding to the data of the target data name in the data page is modified into the target field type;
or (b)
The second processing unit is specifically configured to modify a field type of data in a column where the target data name is located in the data page into a target field type, and modify field type data structure information corresponding to the target data name in the structure page into the target field type.
9. The data set editing processing system according to claim 6, wherein:
the first processing unit is specifically configured to modify the data structure information of the width corresponding to the target data name in the structure page into a target width value, where the width of the column corresponding to the target data name in the data page is modified into a target width;
or (b)
The second processing unit is specifically configured to modify, by dragging, a width of a column where the target data name in the data page is located into a target width, and modify width data structure information of the corresponding target data name in the structure page into a target width value.
10. The data set editing processing system according to claim 6, further comprising:
and the verification unit is used for carrying out data verification on the field of the target data name by entering the target enumeration value in the data page, and displaying the corresponding target enumeration value in enumeration value data structure information of the corresponding target data name in the structure page.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311423061.4A CN117539460B (en) | 2023-10-30 | 2023-10-30 | Data set editing processing method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202311423061.4A CN117539460B (en) | 2023-10-30 | 2023-10-30 | Data set editing processing method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN117539460A true CN117539460A (en) | 2024-02-09 |
| CN117539460B CN117539460B (en) | 2024-07-23 |
Family
ID=89790898
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202311423061.4A Active CN117539460B (en) | 2023-10-30 | 2023-10-30 | Data set editing processing method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN117539460B (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6038569A (en) * | 1997-02-10 | 2000-03-14 | International Business Machines Corporation | System for data structure loading with concurrent image copy |
| CN107229750A (en) * | 2017-06-27 | 2017-10-03 | 网易（杭州）网络有限公司 | table data processing method, device, storage medium and processor |
| CN107273369A (en) * | 2016-04-06 | 2017-10-20 | 阿里巴巴集团控股有限公司 | A kind of table data modification method and device |
| US20180307602A1 (en) * | 2015-12-30 | 2018-10-25 | Huawei Technologies Co.,Ltd. | Access request processing method and apparatus, and computer device |
| CN111782649A (en) * | 2020-06-24 | 2020-10-16 | 中国平安财产保险股份有限公司 | Data acquisition format updating method and device, computer equipment and storage medium |
| CN112036736A (en) * | 2020-08-28 | 2020-12-04 | 杭州指令集智能科技有限公司 | Workflow creating method and device |
-
2023
- 2023-10-30 CN CN202311423061.4A patent/CN117539460B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6038569A (en) * | 1997-02-10 | 2000-03-14 | International Business Machines Corporation | System for data structure loading with concurrent image copy |
| US20180307602A1 (en) * | 2015-12-30 | 2018-10-25 | Huawei Technologies Co.,Ltd. | Access request processing method and apparatus, and computer device |
| CN107273369A (en) * | 2016-04-06 | 2017-10-20 | 阿里巴巴集团控股有限公司 | A kind of table data modification method and device |
| CN107229750A (en) * | 2017-06-27 | 2017-10-03 | 网易（杭州）网络有限公司 | table data processing method, device, storage medium and processor |
| CN111782649A (en) * | 2020-06-24 | 2020-10-16 | 中国平安财产保险股份有限公司 | Data acquisition format updating method and device, computer equipment and storage medium |
| CN112036736A (en) * | 2020-08-28 | 2020-12-04 | 杭州指令集智能科技有限公司 | Workflow creating method and device |
Non-Patent Citations (1)
| Title |
|---|
| IT之一小佬: "MySQL数据库修改表结构", pages 1 - 2, Retrieved from the Internet <URL:https://blog.csdn.net/weixin_44799217/article/details/112739747> * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN117539460B (en) | 2024-07-23 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106303070B (en) | notification message prompting method and device and mobile terminal | |
| CN108156508B (en) | Barrage information processing method and device, mobile terminal, server and system | |
| CN106506321B (en) | Group message processing method and terminal device | |
| CN104571979B (en) | A kind of method and apparatus for realizing split view | |
| CN110941750B (en) | Data linkage method and related device | |
| CN107103074B (en) | Processing method of shared information and mobile terminal | |
| CN106202422B (en) | The treating method and apparatus of Web page icon | |
| CN116541865A (en) | Password input method, device, equipment and storage medium based on data security | |
| US11147038B2 (en) | Notification message processing method and terminal | |
| CN111522674B (en) | Cross-application processing method of multimedia content and electronic equipment | |
| CN116702698A (en) | Word document formatting method, device, equipment and storage medium | |
| CN110602766B (en) | Personal hotspot identification method and method for determining association relationship between terminals | |
| CN110109788B (en) | Multi-key detection method and device, electronic equipment and storage medium | |
| CN116644716A (en) | Method, device, equipment and storage medium for formatting ppt document | |
| CN116303646A (en) | Cross-database data comparison method, device, equipment and storage medium | |
| CN116468382A (en) | RPA robot flow management method, device, equipment and storage medium | |
| CN117539460B (en) | Data set editing processing method and system | |
| CN115904179A (en) | Multi-screen desktop split-screen display method, device, equipment and storage medium | |
| CN110809234A (en) | Figure category identification method and terminal equipment | |
| CN116681438A (en) | Custom generation method, device, equipment and storage medium for collection interface | |
| CN118331665A (en) | Linux application screen capturing method, device, equipment and storage medium | |
| CN116382945A (en) | Card making processing method, system, equipment and computer readable storage medium | |
| CN116303086A (en) | End-to-end testing method, configuration method, device, equipment and storage medium | |
| CN118519620A (en) | Flow processing method, device, equipment and computer readable storage medium | |
| CN116303060A (en) | ESB call request processing method, device, system, equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |