CN105550321A - Method and apparatus for updating data based on same data structure - Google Patents
Method and apparatus for updating data based on same data structure Download PDFInfo
- Publication number
- CN105550321A CN105550321A CN201510932778.0A CN201510932778A CN105550321A CN 105550321 A CN105550321 A CN 105550321A CN 201510932778 A CN201510932778 A CN 201510932778A CN 105550321 A CN105550321 A CN 105550321A
- Authority
- CN
- China
- Prior art keywords
- data
- user data
- data structure
- stored
- new data
- 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.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2365—Ensuring data consistency and integrity
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
- G06F16/2358—Change logging, detection, and notification
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computer Security & Cryptography (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a method and an apparatus for updating data based on the same data structure. The method comprises the steps of obtaining original user data; analyzing the original user data and extracting a column heading and a column type of the original user data; storing the original user data as a data update structure according to the column heading and the column type; obtaining modified user data and storing the modified user data in the data update structure. The data can be automatically updated according to the data update structure of the data. The commercial intelligent data update is more intelligent and convenient.
Description
Technical field
The invention belongs to business intelligence data applied technical field, especially relate to a kind of based on the same data structure more method of new data and device.
Background technology
The demand realizing treatment and analyses of all kinds based on mass data is all there is in real all trades and professions, in order to meet the information layered subseries needs of enterprises and institutions' manager pay, mostly adopt towards the independent data process of single business and analytic system in reality or present data with electrical form and the form such as report tool, business intelligence on-line analysis instrument and meet and apply needs.
Due to towards the independent data process of single business and analytic system, usual use electrical form and report tool form, but use electrical form and report tool to be mutability owing to realizing Various types of data, need personnel manually to adjust to the renewal of data, loaded down with trivial details and easily make mistakes.
Summary of the invention
Embodiments provide a kind of based on the same data structure more method of new data and device, to solve above-mentioned Problems existing.
First aspect, embodiments provide the method based on same data structure more new data, described method comprises:
Obtain original user data;
Original user data is analyzed, extracts column heading and the row type of described original user data;
More new data structure is stored as according to described column heading and row type;
Obtain amended user data, and by amended user data stored in more new data structure.
Further, described original user data, comprising:
Local storage data or third party's data.
Further, by amended user data stored in more new data structure, comprising:
When revising type for increasing, add the user data of described increase stored in more new data structure.
Further, described by amended user data stored in more new data structure, comprising:
When revising type for deleting, delete the data structure of described deletion user data record.
Further, by amended user data stored in after more new data structure, also comprise:
In the data structure of user interface display update.
Second aspect, the embodiment of the present invention additionally provides a kind of device based on same data structure more new data, and described device comprises:
Data acquisition module, for obtaining original user data;
Extraction module, for analyzing original user data, extracts column heading and the row type of described original user data;
Memory module, for being stored as more new data structure according to described column heading and row type;
Update module, for obtaining amended user data, and by amended user data stored in more new data structure.
Further, described update module, for:
When revising type for increasing, add the user data of described increase stored in more new data structure.
Further, described update module, for:
When revising type for deleting, delete the data structure of described deletion user data record.
Further, described device also comprises:
Display module, in the data structure at user interface display update.
The technical scheme adopting the embodiment of the present invention to provide, by analyzing original user data, extracts column heading and the row type of described original user data; And be stored as more new data structure according to column heading and row type.After user's raw data (local data or third party's data) is modified, automatically can upgrade according to the more new data structure of these data.More new data is more intelligent convenient can to make business intelligence.
Accompanying drawing explanation
In order to be illustrated more clearly in the technical scheme of the embodiment of the present invention, be briefly described to the accompanying drawing used required in embodiment or description of the prior art below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to these accompanying drawings.
Fig. 1 is the schematic flow sheet based on the same data structure more method of new data that first embodiment of the invention provides;
Fig. 2 is the structural representation based on the same data structure more device of new data that first embodiment of the invention provides.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, be clearly and completely described the technical scheme in the embodiment of the present invention, obviously, described embodiment is the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
Fig. 1 is the schematic flow sheet based on the same data structure more method of new data that first embodiment of the invention provides, and described method relies on corresponding device to realize.Described device can be realized by software/hardware, and is generally integrated in database.
See Fig. 1, the described method based on same data structure more new data, comprising:
Step S101, obtains original user data.
From local data base or third party database, read original user data, described original user data can comprise the original user data of storage, such as, buy the record of commodity, or the track record etc. of student, such as:
| Name | Chinese language | Mathematics |
| Li Xiang | 90 | 85 |
Step S102, analyzes original user data, extracts column heading and the row type of described original user data.
Based on obtained user data, analyze, to obtain multiple attribute informations included in described user data.Exemplary, for the list data shown in step S101, by data analysis in his-and-hers watches, can obtain attribute information is name, Chinese Achievement Test and mathematics achievement attribute.And from described original user data, extract column heading and row type.
Step S103, is stored as more new data structure according to described column heading and row type.
Exemplary, when data content is the form in step S101, by " name " (text-type), " Chinese language " (decimal type), the column headings such as " mathematics " (decimal type) and row type save as data structure, and preserve data content " Li Xiang ".User adds data when being recorded as form 2, and by identification data structure by data content " Wang Qiang ", being appended to data content is form 3.
Step S104, obtains amended user data, and by amended user data stored in more new data structure.
Exemplary, user adds data record Wang Qiang to the form in step S101, and 77, when 91, by identification data structure by data content " Wang Qiang ", be appended to the data structure that form in rapid S101 is corresponding.Form the data structure in following table.
| Name | Chinese language | Mathematics |
| Li Xiang | 90 | 85 |
| Wang Qiang | 77 | 91 |
User also can delete the user data in data structure by said method, exemplary, can input the user data of deletion, and before user data, increase delete flag symbol.By identification data structure, data content is deleted.
The present embodiment, by analyzing data object frequency of utilization, determines High-frequency and low-frequency object; And for low frequency object interpolation mark and as object of reservation.Avoid the block attacks of data object.Ensure that the normal access of other user for database.
The present embodiment can upgrade automatically according to the more new data structure of these data.More new data is more intelligent convenient can to make business intelligence.
In another preferred implementation of the present embodiment, by amended user data stored in after more new data structure, also comprise: in the data structure of user interface display update.User can check the data structure after renewal by client.
Fig. 2 illustrates second embodiment of the invention.
Fig. 2 is the structural representation based on the same data structure more device of new data that second embodiment of the invention provides.
As seen from Figure 2, the described device based on same data structure more new data comprises:
Data acquisition module 210, for obtaining original user data;
Extraction module 220, for analyzing original user data, extracts column heading and the row type of described original user data;
Memory module 230, for being stored as more new data structure according to described column heading and row type;
Update module 240, for obtaining amended user data, and by amended user data stored in more new data structure.
Further, described update module 240, for:
When revising type for increasing, add the user data of described increase stored in more new data structure.
Further, described update module 220, for:
When revising type for deleting, delete the data structure of described deletion user data record.
Further, described device also comprises:
Display module 250, in the data structure at user interface display update.
Above-mentioned based on same data structure more new data device really, the method based on same data structure more new data can be performed, possess function and beneficial effect that method performs.
One of ordinary skill in the art will appreciate that: all or part of step realizing above-mentioned each embodiment of the method can have been come by the hardware that programmed instruction is relevant.Aforesaid program can be stored in a computer read/write memory medium.This program, when performing, performs the step comprising above-mentioned each embodiment of the method; And aforesaid storage medium comprises: ROM, RAM, magnetic disc or CD etc. various can be program code stored medium.
Last it is noted that above each embodiment is only in order to illustrate technical scheme of the present invention, be not intended to limit; Although with reference to foregoing embodiments to invention has been detailed description, those of ordinary skill in the art is to be understood that: it still can be modified to the technical scheme described in foregoing embodiments, or carries out equivalent replacement to wherein some or all of technical characteristic; And these amendments or replacement, do not make the essence of appropriate technical solution depart from the scope of various embodiments of the present invention technical scheme.
Claims (9)
1., based on a method for same data structure more new data, it is characterized in that, described method comprises:
Obtain original user data;
Original user data is analyzed, extracts column heading and the row type of described original user data;
More new data structure is stored as according to described column heading and row type;
Obtain amended user data, and by amended user data stored in more new data structure.
2. method according to claim 1, is characterized in that: described original user data, comprising:
Local storage data or third party's data.
3. method according to claim 1, is characterized in that, by amended user data stored in more new data structure, comprising:
When revising type for increasing, add the user data of described increase stored in more new data structure.
4. method according to claim 1, is characterized in that, described by amended user data stored in more new data structure, comprising:
When revising type for deleting, delete the data structure of described deletion user data record.
5. method according to claim 1, is characterized in that: by amended user data stored in after more new data structure, also comprise:
In the data structure of user interface display update.
6., based on a device for same data structure more new data, it is characterized in that, described device comprises:
Data acquisition module, for obtaining original user data;
Extraction module, for analyzing original user data, extracts column heading and the row type of described original user data;
Memory module, for being stored as more new data structure according to described column heading and row type;
Update module, for obtaining amended user data, and by amended user data stored in more new data structure.
7. device according to claim 6, is characterized in that: described update module, for:
When revising type for increasing, add the user data of described increase stored in more new data structure.
8. device according to claim 6, is characterized in that: described update module, for:
When revising type for deleting, delete the data structure of described deletion user data record.
9. device according to claim 6, is characterized in that: described device also comprises:
Display module, in the data structure at user interface display update.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510932778.0A CN105550321A (en) | 2015-12-12 | 2015-12-12 | Method and apparatus for updating data based on same data structure |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510932778.0A CN105550321A (en) | 2015-12-12 | 2015-12-12 | Method and apparatus for updating data based on same data structure |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105550321A true CN105550321A (en) | 2016-05-04 |
Family
ID=55829510
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510932778.0A Pending CN105550321A (en) | 2015-12-12 | 2015-12-12 | Method and apparatus for updating data based on same data structure |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105550321A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6901417B2 (en) * | 2002-01-11 | 2005-05-31 | International Business Machines Corporation | Method, system, and program for updating records in a database when applications have different version levels |
| CN101420376A (en) * | 2008-11-19 | 2009-04-29 | 腾讯科技（深圳）有限公司 | Method and device for updating data |
| CN103714163A (en) * | 2013-12-30 | 2014-04-09 | 中国科学院信息工程研究所 | Pattern management method and system of NoSQL database |
-
2015
- 2015-12-12 CN CN201510932778.0A patent/CN105550321A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6901417B2 (en) * | 2002-01-11 | 2005-05-31 | International Business Machines Corporation | Method, system, and program for updating records in a database when applications have different version levels |
| CN101420376A (en) * | 2008-11-19 | 2009-04-29 | 腾讯科技（深圳）有限公司 | Method and device for updating data |
| CN103714163A (en) * | 2013-12-30 | 2014-04-09 | 中国科学院信息工程研究所 | Pattern management method and system of NoSQL database |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107864301B (en) | Client label management method, system, computer equipment and storage medium | |
| CN109543925B (en) | Risk prediction method and device based on machine learning, computer equipment and storage medium | |
| CN107506343A (en) | The processing method and platform of a kind of information editing | |
| US20210365421A1 (en) | Data analysis method, computer device and storage medium | |
| WO2019062189A1 (en) | Electronic device, method and system for conducting data table filing processing, and storage medium | |
| CN103810212A (en) | Automated database index creation method and system | |
| CN112163072B (en) | Data processing method and device based on multiple data sources | |
| WO2019062078A1 (en) | Smart customer service method, electronic apparatus and computer-readable storage medium | |
| CN110019367B (en) | Method and device for counting data characteristics | |
| CN110162518B (en) | Data grouping method, device, electronic equipment and storage medium | |
| CN103678696A (en) | Method and device for controlling data read-write separation | |
| CN110806866A (en) | Generation method and device of front-end management system | |
| CN112418875B (en) | Cross-platform tax intelligent customer service corpus migration method and device | |
| CN109446167A (en) | A kind of storage of daily record data, extracting method and device | |
| CN112650424A (en) | Information prompting method and device, electronic equipment and storage medium | |
| CN110377891B (en) | Method, device and equipment for generating event analysis article and computer readable storage medium | |
| CN109376148B (en) | Data processing method and device for slow change dimension table and electronic equipment | |
| CN110515954B (en) | Data processing method, device, equipment and storage medium | |
| WO2019080424A1 (en) | Customer migration method and system, computer device and storage medium | |
| CN112131292A (en) | Method and device for structural processing of changed data | |
| CN105550321A (en) | Method and apparatus for updating data based on same data structure | |
| CN114968725A (en) | Task dependency relationship correction method and device, computer equipment and storage medium | |
| CN110019117A (en) | A kind of data archiving method and device | |
| CN110909112B (en) | Data extraction method, device, terminal equipment and medium | |
| CN107885839B (en) | Method and device for reading information in Word file |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20160504 |
|
| WD01 | Invention patent application deemed withdrawn after publication |