CN107688648A - A kind of data record method - Google Patents
A kind of data record method Download PDFInfo
- Publication number
- CN107688648A CN107688648A CN201710773674.9A CN201710773674A CN107688648A CN 107688648 A CN107688648 A CN 107688648A CN 201710773674 A CN201710773674 A CN 201710773674A CN 107688648 A CN107688648 A CN 107688648A
- Authority
- CN
- China
- Prior art keywords
- list item
- data
- record
- record sheet
- project 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 36
- 230000008859 change Effects 0.000 claims abstract description 49
- 230000004048 modification Effects 0.000 claims abstract description 17
- 238000012986 modification Methods 0.000 claims abstract description 17
- 238000012545 processing Methods 0.000 description 6
- 238000013461 design Methods 0.000 description 5
- 230000006870 function Effects 0.000 description 4
- 238000007726 management method Methods 0.000 description 3
- 230000008569 process Effects 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 238000012795 verification Methods 0.000 description 1
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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The present embodiments relate to a kind of data record method, including：Create the list item project information of the first record sheet；Receive the list item data of the first record sheet；Wherein, list item data have project information attribute；Receive the list item change operation of user's input；The list item change operation includes changing list item project information and corresponding list of modification item data；Obtain the change list item project information in the list item change operation；Corresponding list item data are searched in first record sheet according to the change list item project information；The list item data found are updated to the list of modification item data；Change record is generated, is stored in the 3rd record sheet.
Description
Technical field
The present invention relates to data processing field, more particularly to a kind of data record method.
Background technology
With the development of information technology, record and management for data rely primarily on server completion, in data management
In, it is often necessary to the data in server are modified and updated, the modification and renewal of record data are an important rings
Section.
Network payment is widely used in the life of people, a simple transaction, and operation seems only to need a few minutes very
To several seconds, real server ensured that transaction is completed for efficient process data, in beginning preparing for for transaction, the process of transaction,
Inquiry verification after transaction etc. is all the bargain transaction for just ensuring to meet both sides under server support.Wherein, because service
The logic flow of the data structure table design counterpart expenditure of device, and modification of the server to data, the record of renewal are particularly
It is important.
But the record that existing server is modified and updated for data is all based on a table, process is cumbersome,
And when data processing amount is big, server operation speed is slow, treatment effeciency is low.
The content of the invention
The purpose of the present invention is the defects of being directed to prior art, there is provided a kind of data record method, a point table is carried out to data
Processing, improve the speed of service and treatment effeciency of server.
In view of this, the embodiments of the invention provide a kind of data record method, including：
Create the list item project information of the first record sheet；
Receive the list item data of the first record sheet；Wherein, list item data have project information attribute；
Receive the list item change operation of user's input；The list item change operation includes changing list item project information and phase
Corresponding list of modification item data；
Obtain the change list item project information in the list item change operation；
Corresponding list item data are searched in first record sheet according to the change list item project information；
The list item data found are updated to the list of modification item data；
Change record is generated, is stored in the 3rd record sheet.
Preferably, in the generation more new record, before being stored in the 3rd record sheet, methods described also includes：
Create the list item project information of the 3rd record sheet.
It is further preferred that after the list item project information for creating the 3rd record sheet, methods described is also wrapped
Include：
Corresponding change record is inquired about in the 3rd record sheet according to the list item project information.
Preferably, the first list item project information of second record sheet is believed for the gauge outfit field of first record sheet
Breath；Methods described also includes：
The link data of first record sheet are obtained according to the first list item project information；
According to the list item project information and list item data of the first record sheet described in the link data acquisition.
It is further preferred that it is described according to it is described link data acquisition described in the first record sheet list item project information and
Before list item data, methods described also includes：
The association established between the first list item project information of second record sheet and first record sheet.
Preferably, in the list item project information and entry number of first record sheet according to the link data acquisition
According to before, methods described also includes：
Create the list item project information of the second record sheet；
Receive the list item data of the second record sheet.
A kind of data record method provided in an embodiment of the present invention, a point list processing is carried out to data, improves the fortune of server
Scanning frequency degree and treatment effeciency.
Brief description of the drawings
Fig. 1 is data record method flow chart provided in an embodiment of the present invention.
Embodiment
In order that the object, technical solutions and advantages of the present invention are clearer, the present invention is made below in conjunction with accompanying drawing into
One step it is described in detail, it is clear that the described embodiment only a part of embodiment of the present invention, rather than whole implementation
Example.Based on the embodiment in the present invention, what those of ordinary skill in the art were obtained under the premise of creative work is not made
All other embodiment, belongs to the scope of protection of the invention.
Data record method provided in an embodiment of the present invention, the data note being especially suitable for, but not limited in network payment
Record, with reference to the data record method flow chart shown in Fig. 1, the data record method of the present invention is described in detail.
As shown in figure 1, data record method provided in an embodiment of the present invention mainly comprises the following steps：
Step 101, the list item project information of the first record sheet is created；
Specifically, server creates the first record sheet, the first record sheet includes gauge outfit field information and list item project information,
First record sheet can be account table, and for recording user profile, the gauge outfit field information in account record sheet is account ID, table
Item project information includes but is not limited to account number cipher, address name, telephone number, home address, passport NO. and creation time.
Step 102, the list item data of the first record sheet are received；
Specifically, user terminal receives the user's registration information that user inputs at user's registration interface, according to user's registration
Information generates list item data, and is sent to server；Server receives the list item data that user terminal is sent, and list item data are tools
There is project information attribute, server identifies the project information attribute of list item data, so as to which list item data are input into the first note
Record the relevant position of table.
After list item data are input into the first record sheet, server establishes gauge outfit field information, list item project information
Association between list item data, it is therefore intended that during with user orientation server request items data or amended subject data, server
Corresponding project data can quickly be found.
Wherein, user terminal can be understood as the terminal device with input, display, communication and data processing function, example
Such as, smart mobile phone or other handheld terminals etc..
In a preferred embodiment, server further creates the second record sheet while the first record sheet is created, and second
Record sheet is trading record sheet, records every transaction of user, the gauge outfit field information of the second record sheet is order ID, and second remembers
The the first list item project information for recording table is the gauge outfit field information of the first record sheet, and the list item project information of the second record sheet includes
But it is not limited to account ID, payment, payment platform, pay status, purchase commodity ID and creation time；In second record sheet
Project data is automatically entered according to the trading situation of user, also with regard to saying when user carries out network payment on the subscriber terminal
Afterwards, server automatically generates sequence information, and sequence information includes order ID, account ID, payment, payment platform, payment
State, purchase commodity ID and order creation time, wherein payment platform are divided into Alipay, wechat and other manner, pay status
Be divided into do not pay, pay successfully, pay failure, non-reimbursement and refunded；Server is according to sequence information in the second record sheet
Project data automatically entered.
After the first record sheet and the second record sheet is created, the first list item project information account of the second record sheet is established
Association between ID and the first record sheet account table, the purpose for establishing association are, when user or order management person check
When two record sheets are trading record sheet, the chain that the first record sheet is account table can be obtained according to the account ID in trading record sheet
Connect data；Further according to the list item project information and list item data of the link record sheet of data acquisition first.Account table and transaction are remembered
Record table is provided separately, and splitting into multiple tables of data according to ID scopes stores, lifting system bearing capacity and the speed of service, and leads to
The acquisition of associated data can be ensured by crossing the foundation of incidence relation.
Step 103, the list item change operation of user's input is received；
Specifically, when user profile changes, user terminal receive user's input change list item project information and
Corresponding list of modification item data, user terminal generate table according to change list item project information and corresponding list of modification item data
Item change operation is sent to server.Wherein, list item change operation includes changing list item project information and corresponding change
List item data, and account ID is carried in Xiang Mingda operation, so that server be able to can obtain according to account ID is carried
Take corresponding list item project information and corresponding list item data.
Step 104, the change list item project information in list item change operation is obtained；
In a specific example, user wants to change telephone number and be changed to 88868886, is entered by user terminal
Row input change operation, the account ID that server carries in being operated according to change find corresponding list item project information and phase
Corresponding list item data, and be telephone number according to the change project information extracted in change operation.
Step 105, corresponding list item data are searched in the first record sheet according to change list item project information, will searched
To list item data be updated to list of modification item data；
In the example described in step 104, server is according to account ID, list item project information and corresponding list item data
Between incidence relation get change project information telephone number corresponding to project data be 55666688；55666688 are become
More 88868886.
Step 106, change record is generated, is stored in the 3rd record sheet.
Certainly before step 106, method also includes：Server creates the list item project information of the 3rd record sheet, wherein,
3rd record sheet is Operation Log table, the change histories of record entry data, is that the change of significant data afterwards leaves archives, the
Gauge outfit field information in three record sheets is daily record ID, and daily record ID is generated based on modification Date Of Change；List item project information
The data value after data value, modification before the Data field names including but not limited to changed, modification, the behaviour for changing data
Author, modification data reasons and modification data time.
Specifically, after the list item data in updating the first record sheet or the second record sheet, server is based on change and grasped
Change record is automatically generated, and is stored in the 3rd record sheet.
It should be noted that in the first record sheet project data occur change or the second record sheet in project data become
More all be recorded in the 3rd record sheet, for example the pay status of order becomes to pay by not paying, server be based on order ID with
And pay status finds the current state of order not pay, and payment is changed to pay, generation change after change
Record is stored in the 3rd record sheet.
Be the situation of change for recording user profile and sequence information in the purpose of design of the 3rd record sheet, as user or
Order management personnel are wanted when being checked to alteration, in the change list item project information that user terminal selecting to be checked,
And it is sent to server；Server inquires about corresponding change record according to list item project information in the 3rd record sheet, and returns
Back to user terminal, consequently facilitating the inquiry of change record.
A kind of data record method provided in an embodiment of the present invention, can be with by planned network payment data database table structure
Processing pays request logic, while the design of Operation Log ensure that data occur exception and check that record is analyzed, and leads to
Cross the design lifting system bearing capacity of split table.
Professional should further appreciate that, each example described with reference to the embodiments described herein
Unit and algorithm steps, it can be realized with electronic hardware, computer software or the combination of the two, it is hard in order to clearly demonstrate
The interchangeability of part and software, the composition and step of each example are generally described according to function in the above description.
These functions are performed with hardware or software mode actually, application-specific and design constraint depending on technical scheme.
Professional and technical personnel can realize described function using distinct methods to each specific application, but this realization
It is it is not considered that beyond the scope of this invention.
The method that is described with reference to the embodiments described herein can use hardware, computing device the step of algorithm
Software module, or the two combination are implemented.Software module can be placed in random access memory (RAM), internal memory, read-only storage
(ROM), electrically programmable ROM, electrically erasable ROM, register, hard disk, moveable magnetic disc, CD-ROM or technical field
In any other form of storage medium well known to interior.
Above-described embodiment, the purpose of the present invention, technical scheme and beneficial effect are carried out further
Describe in detail, should be understood that the embodiment that the foregoing is only the present invention, be not intended to limit the present invention
Protection domain, within the spirit and principles of the invention, any modification, equivalent substitution and improvements done etc., all should include
Within protection scope of the present invention.
Claims (6)
1. a kind of data record method, it is characterised in that methods described includes：
Create the list item project information of the first record sheet；
Receive the list item data of the first record sheet；Wherein, list item data have project information attribute；
Receive the list item change operation of user's input；List item change operation includes change list item project information and corresponding
List of modification item data；
Obtain the change list item project information in the list item change operation；
Corresponding list item data are searched in first record sheet according to the change list item project information；
The list item data found are updated to the list of modification item data；
Change record is generated, is stored in the 3rd record sheet.
2. data record method according to claim 1, it is characterised in that in the generation more new record, be stored in the
Before in three record sheets, methods described also includes：
Create the list item project information of the 3rd record sheet.
3. data record method according to claim 2, it is characterised in that in the table for creating the 3rd record sheet
After item project information, methods described also includes：
Corresponding change record is inquired about in the 3rd record sheet according to the list item project information.
4. data record method according to claim 1, it is characterised in that the first list item project of second record sheet
Information is the gauge outfit field information of first record sheet；Methods described also includes：
The link data of first record sheet are obtained according to the first list item project information of second record sheet；
According to the list item project information and list item data of the first record sheet described in the link data acquisition.
5. data record method according to claim 4, it is characterised in that described according to the link data acquisition institute
Before the list item project information and list item data of stating the first record sheet, methods described also includes：
The association established between the first list item project information of second record sheet and first record sheet.
6. data record method according to claim 1, it is characterised in that described according to the link data acquisition institute
Before the list item project information and list item data of stating the first record sheet, methods described also includes：
Create the list item project information of the second record sheet；
Receive the list item data of the second record sheet.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710773674.9A CN107688648A (en) | 2017-08-31 | 2017-08-31 | A kind of data record method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710773674.9A CN107688648A (en) | 2017-08-31 | 2017-08-31 | A kind of data record method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107688648A true CN107688648A (en) | 2018-02-13 |
Family
ID=61155796
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710773674.9A Pending CN107688648A (en) | 2017-08-31 | 2017-08-31 | A kind of data record method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107688648A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109919572A (en) * | 2019-01-24 | 2019-06-21 | 贝壳技术有限公司 | A kind of variation and device of house prosperity transaction process |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1130773A (en) * | 1994-12-26 | 1996-09-11 | 卡西欧计算机公司 | Data file update processing apparatus |
| US6839720B1 (en) * | 2000-09-29 | 2005-01-04 | Arthur Thibodeau | Rental property caching and searching system and process |
| CN101283317A (en) * | 2005-02-11 | 2008-10-08 | 伏特资讯科学公司 | Project work change in plan/scope administrative and business information synergy system and method |
| CN105095457A (en) * | 2015-07-28 | 2015-11-25 | 驰众信息技术（上海）有限公司 | Method for storing and managing historical data |
| CN106503186A (en) * | 2016-10-25 | 2017-03-15 | 广东浪潮大数据研究有限公司 | A kind of data managing method, client and system |
-
2017
- 2017-08-31 CN CN201710773674.9A patent/CN107688648A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1130773A (en) * | 1994-12-26 | 1996-09-11 | 卡西欧计算机公司 | Data file update processing apparatus |
| US6839720B1 (en) * | 2000-09-29 | 2005-01-04 | Arthur Thibodeau | Rental property caching and searching system and process |
| CN101283317A (en) * | 2005-02-11 | 2008-10-08 | 伏特资讯科学公司 | Project work change in plan/scope administrative and business information synergy system and method |
| CN105095457A (en) * | 2015-07-28 | 2015-11-25 | 驰众信息技术（上海）有限公司 | Method for storing and managing historical data |
| CN106503186A (en) * | 2016-10-25 | 2017-03-15 | 广东浪潮大数据研究有限公司 | A kind of data managing method, client and system |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109919572A (en) * | 2019-01-24 | 2019-06-21 | 贝壳技术有限公司 | A kind of variation and device of house prosperity transaction process |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CA2716420C (en) | Third party information transfer | |
| US8682753B2 (en) | System and method to consolidate and update a user's financial account information | |
| KR102310840B1 (en) | Method of providing real estate transaction platform that supports direct transactions between sellers and buyers | |
| CN112163946A (en) | Accounting processing method and device based on distributed transaction system | |
| US11501322B2 (en) | Blockchain-based data processing systems, methods, and apparatuses | |
| CN110310079A (en) | Application data evaluation method, device, computer equipment and storage medium based on intelligent decision-making | |
| CN108764696A (en) | A kind of purchasing management method and platform | |
| CN107590723A (en) | Increase method, system and server that wechat is ordered goods in online lower operation system | |
| CN107958417A (en) | A kind of investment and financing bridging method and platform based on big data | |
| CN110555023B (en) | Data storage method and device based on credit contract | |
| CN109087129A (en) | User's evaluation method, apparatus and computer readable storage medium | |
| CN107688648A (en) | A kind of data record method | |
| JP2003208503A (en) | Accountancy system | |
| US9525687B2 (en) | Template for customer attributes | |
| JP2016181171A (en) | Information processing apparatus, system, method, and program | |
| CN111242758A (en) | Intelligent account checking method and system | |
| CN110782310A (en) | Method, device and system for asynchronously acquiring user attribute information from third-party platform | |
| CN115776548A (en) | Double recording system | |
| CN111708757B (en) | Data resource processing method, device and system, storage medium and electronic equipment | |
| CN106777000A (en) | Method for pushing, supplying system and mobile terminal based on entity card | |
| CN111159568A (en) | Information processing apparatus, information processing method, and program | |
| CN110674402A (en) | Technical popularization information service system | |
| CN110084625A (en) | A kind of intelligent reference method and device based on block chain technology | |
| JP2002245264A (en) | XML DTD management system and method, XML DTD distribution system and method, and program | |
| WO2023219572A1 (en) | Method and system for adaptively processing a request for data |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180213 |