CN105956918A - Method for recording dynamic variation data - Google Patents
Method for recording dynamic variation data Download PDFInfo
- Publication number
- CN105956918A CN105956918A CN201610273068.6A CN201610273068A CN105956918A CN 105956918 A CN105956918 A CN 105956918A CN 201610273068 A CN201610273068 A CN 201610273068A CN 105956918 A CN105956918 A CN 105956918A
- Authority
- CN
- China
- Prior art keywords
- day
- balance
- remaining sum
- account
- month
- 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
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
Abstract
The invention provides a method for recording dynamic variation data, and the method comprises the steps: for a present account, end-of-day balance and end-of-day balance states in an account primary table is initialized, a month which the day of opening the account is in is defined as a N-th month, and account balance history tables of the N-th month and a N+1 month are built; end-of-day balance and an end-of-day balance state of a n-th day of the N-th month are recorded in the account primary table; in a first preset time, the balance and the balance state of the n-th day in the account balance history tables are updated according to the end-of-day balance and the end-of-day balance state recorded in the n-th day; and when a value day trading is performed, the end-of-day balance and the end-of-day balance states in the account primary table, and balance and balance states of dates from an actual starting day to a performed day of the value day trading in the account balance history table are updated according to the value day trading.
Description
Technical field
The present invention is about Data recording technique, specifically, is dynamically to change number about a kind of based on big data background
According to recording method.
Background technology
Data have penetrated into each industry current and operation function field, become the most important factor of production,
Increasing people begins to focus on the excavation to mass data and application, as given according to bank account balances situation of change
Differentiation interest rate, consumption data every day according to client determine that the consumption habit of customers is with directed marketing etc..But data are such as
How what storage, how record, update, not yet obtain enough attention.
As a example by banking system, for the record of account balance, conventional method is to perform when batch at night, but
For business bank, account amount is growing, and trading volume incrementally increases, if the record of account balance history is placed on night
Between batch processing, ample resources can be taken and cause batch window at night to increase, thus batch at system night is caused the biggest
Pressure.
Summary of the invention
The main purpose of the embodiment of the present invention is to provide the recording method of a kind of dynamic changing data, improves dynamically change
The recording process of data, thus reduce the impact for system batch at night.
To achieve these goals, the embodiment of the present invention provides a kind of dynamic changing data recording method, and described is dynamic
Delta data recording method includes: initialize the remaining sum and balance status at end day at end day in account table for current account,
And month residing for the same day of opening an account is defined as the N month, the newly-built N month and the account balance history lists of the N+1 month;
The remaining sum and balance status at end day at end day of N month n days is recorded in account table;At first scheduled time, root
According to account table n days record end day remaining sum and balance status at end day more new account balance history lists in n days
Remaining sum and balance status;When retrodict Day Trading time, according to retrodict Day Trading update account table remaining sum at end day,
From the actual starting date of Day Trading of retrodicting, to Day Trading of retrodicting in day whole balance status and account balance history lists
There is remaining sum and the balance status of day.
In one embodiment, the first above-mentioned scheduled time is (n+1)th.
In one embodiment, above-mentioned when retrodict Day Trading time, update the day of account table according to Day Trading of retrodicting
From the actual starting date of Day Trading of retrodicting, to retrodicting in whole remaining sum, balance status at end day and account balance history lists
The remaining sum that day occurs of Day Trading and balance status, specifically include: from the beginning of the actual starting date of Day Trading of retrodicting, to
Before the state of querying the balance be batch updating or the date of online renewal, be defined as the Base day, using the remaining sum of Base day as
The baseline amount of money;Reality is updated according to the baseline amount of money, the dealing money of Day Trading of retrodicting, the remaining sum of every day and balance status
Starting date is to day remaining sum of every day in account balance history lists occurs, and actual starting date extremely occurs the remaining sum shape of day
State is updated to online renewal.
In one embodiment, above-mentioned according to the baseline amount of money, the dealing money of Day Trading of retrodicting, the remaining sum of every day and remaining
Volume state updates actual starting date and day remaining sum of every day in account balance history lists extremely occurs, and specifically includes: for reality
Border starting date, to the every day occurred in day, if balance status is unknown, then abandons processing the remaining sum of described every day;If it is remaining
Volume state is ibid one day, and the baseline amount of money and dealing money sum are updated to the remaining sum of every day;If balance status is connection
Machine updates or batch updating, and the remaining sum current every day and dealing money sum are updated to the remaining sum of every day;For described
There is day, in second scheduled time, according to described account table described generation day entry end day remaining sum and day eventually remaining
Volume state updates remaining sum and the balance status that day occurs described in described account balance history lists.
In one embodiment, the above-mentioned remaining sum and balance status at end day at end day initialized in account table, specifically include:
Remaining sum at end day in described account table is defined as 0, and the balance status at end day in described account table is defined as
Unknown.
In one embodiment, the above-mentioned newly-built N month and the account balance history lists of the N+1 month, specifically include:
In the described N month, by described account balance history lists create day and before the remaining sum on date be defined as 0,
Balance status is defined as the unknown;And by described account balance history lists create the remaining sum on date after day be defined as 0,
Balance status is defined as ibid one day;In the described N+1 month, daily balance being defined as 0, balance status is defined as
Ibid one day.
In one embodiment, above-mentioned in described account table, record N month n days end day remaining sum and day eventually
Balance status, specifically includes: step a1: whether the balance status at end day judging described n days is unknown;If
It is to perform step a2, otherwise perform step a3;Step a2: by the remaining sum at end day of n days in described account table
State is updated to batch updating;Step a3: judge whether the remaining sum at end day of n days changes;If it is, hold
Row step a4, otherwise performs step a5;Step a4: update described account table according to the change of remaining sum at described end day
The remaining sum at end day of middle n days, and balance status at end day is updated to batch updating;Step a5: by described accountee
In table, the balance status at end day of n days is updated to ibid one day.
In one embodiment, above-mentioned according to described account table described n days record end day remaining sum and day the most remaining
Volume state updates remaining sum and the balance status of described n days, specifically includes: judge that the described day of described n days is the most remaining
Whether volume state is batch updating;If it is, by the balance updates of n days corresponding in described account balance history lists
For the remaining sum at end day of described n days, and balance status is updated to batch updating;The most do not update described account balance
History lists.
In one embodiment, above-mentioned dynamic changing data recording method also includes: preset day in the one of the N+1 month
Phase, the account balance history lists of the newly-built N+2 month.
In one embodiment, the account balance history lists of the above-mentioned newly-built N+2 month, specifically include: described
In the N+2 month, the described remaining sum of every day is defined as 0, balance status is defined as ibid one day.
Having the beneficial effects that of the embodiment of the present invention, adds remaining sum item at end day and balance status at end day in account table
, and build account balance history lists, affect the transaction of history remaining sum for Day Trading etc. of such as retrodicting, start correspondence
Balance updates process, the history that upgrades in time remaining sum, provide data more accurately for the operation such as subsequent query or interest-bearing
Support.
Accompanying drawing explanation
In order to be illustrated more clearly that the embodiment of the present invention or technical scheme of the prior art, embodiment will be described below
The accompanying drawing used required in is briefly described, it should be apparent that, the accompanying drawing in describing below is only the present invention's
Some embodiments, for those of ordinary skill in the art, on the premise of not paying creative work, also may be used
To obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is the flow chart of the recording method of the dynamic changing data according to the embodiment of the present invention;
Fig. 2 is the record remaining sum at end day according to the embodiment of the present invention and the process schematic of balance status at end day;
Fig. 3 is the more new balance according to the embodiment of the present invention and the process schematic of balance status.
Detailed description of the invention
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Describe, it is clear that described embodiment is only a part of embodiment of the present invention rather than whole embodiments wholely.
Based on the embodiment in the present invention, those of ordinary skill in the art are obtained under not making creative work premise
Every other embodiment, broadly falls into the scope of protection of the invention.
The embodiment of the present invention provides the recording method of a kind of dynamic changing data.Below in conjunction with accompanying drawing, the present invention is carried out in detail
Describe in detail bright.
The embodiment of the present invention provides the recording method of a kind of dynamic changing data, as it is shown in figure 1, this dynamic changing data
Recording method mainly include following steps:
Step S101: initialize the remaining sum and balance status at end day at end day in account table for current account, and will
Open an account and be defined as the N month month residing for the same day, the newly-built N month and the account balance history lists of the N+1 month;
Step S102: record the remaining sum and balance status at end day at end day of N month n days in account table;
Step S103: in first scheduled time, according to account table n days record end day remaining sum and day eventually remaining
The remaining sum of n days and balance status in volume state more new account balance history lists:
Wherein, when retrodict Day Trading time, update the remaining sum at end day of account table, day according to Day Trading of retrodicting eventually remaining
In volume state and account balance history lists from the actual starting date of Day Trading of retrodicting, to generation day of Day Trading of retrodicting
Remaining sum and balance status.
By each above-mentioned step, the recording method of the dynamic changing data of the embodiment of the present invention, in account table
Add remaining sum item at end day and balance status item at end day, and build account balance history lists, for Day Trading of such as retrodicting
Deng affecting the transaction of history remaining sum, starting corresponding balance updates process, the history that upgrades in time remaining sum, for subsequent query
Or the operation such as interest-bearing provides data support more accurately.
Below in conjunction with concrete example, each step of the recording method of the dynamic changing data of the embodiment of the present invention is carried out
Describe in detail.
Above-mentioned steps S101: initialize the remaining sum and balance status at end day at end day in account table for current account,
And month residing for the same day of opening an account is defined as the N month, the newly-built N month and the account balance history lists of the N+1 month.
In actual application, it is preferred that can be to open an account the same day client, the account table of the account of this client be carried out
Initialize.But initializing account table at different time also dependent on needs, the present invention is not limited thereto.
Account table is used for storing accounts information, and daily night, batch processing carried out updating this table when interest calculates.Initializing should
Account table refers to, remaining sum item and balance status item at end day at newly-built end day in account table, and by remaining sum definition at end day
It is 0, the balance status at end day in account table is defined as " unknown ".Account master meter is as shown in table 1 below.
Table 1
Further, for this client, and newly-built open an account this month and next month (make a distinction during for ease of being described below, will
Open an account and of that month be referred to as first month, the next month in this month of opening an account is referred to as second month) account balance history lists.
Account balance history lists is for record account daily balance and balance status in detail.Account remaining sum history lists such as following table
Shown in 2.
Table 2
When newly-built account remaining sum history lists, by open an account the same day and before the remaining sum on date be defined as 0, remaining sum
State is defined as the unknown;And the remaining sum on date after the same day of opening an account is defined as 0, balance status is defined as " ibid
One day ".
Above-mentioned steps S102, records the remaining sum and balance status at end day at end day of N month n days in account table.
The remaining sum and balance status at end day at end day on account same day is recorded in account table.Specifically, in account table
The process of record remaining sum at end day and balance status at end day is as shown in Figure 2.
Step S201: whether the balance status at end day judging the same day is " unknown ";If it is, perform step S202,
Otherwise perform step S203;
Step S202: the balance status at end day on the same day in account table is updated to " batch updating ";
Step S203: judge whether the remaining sum at end day on the same day changes;If it is, perform step S204, otherwise
Perform step S205;
Step S204: update the remaining sum at end day on the same day in account table according to the change of remaining sum at end day, and day is the most remaining
Volume state is updated to " batch updating ";
Step S205: the balance status at end day on the same day in account table is updated to " ibid one day ".
Above-mentioned step S103, in first scheduled time, according to account table n days record end day remaining sum and
The remaining sum of n days and balance status in day whole balance status more new account balance history lists.
Specifically, the process of more new balance and balance status is as shown in Figure 3:
Whether the balance status at end day first determining whether n days is " batch updating ";If it is, need more New Account
Remaining sum history lists, otherwise need not more new account balance history lists.
If needing more new account balance history lists, then according to n days record end day remaining sum and balance status at end day more
The remaining sum of new n days and balance status.Specifically, it is by the balance updates of n days corresponding in account balance history lists
For the remaining sum at end day of n days, and balance status is updated to " batch updating ".
In a preferred embodiment, the record remaining sum at end day of above-mentioned steps S102 and the process of balance status at end day be
Complete during the batch processing at night on the same day, and the process of the more new balance of above-mentioned steps S103 and balance status is secondary
In the daytime the batch processing of day completes (the first the most above-mentioned scheduled time can be (n+1)th), by asynchronous refresh process,
When can reduce batch processing at night every day, system resource is taken, promote the treatment effeciency to dynamic changing data.
In actual applications, one can be set when carrying out parameter configuration monthly to carry out joining of pre-inserted account balance history lists
Put the date, when this configuration date of first month, the account balance history lists of newly-built second month, and by this second
Remaining sum in the account balance history lists of individual month is defined as 0, balance status is defined as " ibid one day ".
In the specific implementation, it is also possible to be at the account balance history lists setting up open an account this month and next month the same day of opening an account,
And when this configuration date, newly-built trimestral account balance history lists.Specifically, be according to this date with open an account
Before and after, relation determines.
Such as, if open an account day configuration the date before, then the account balance history lists of newly-built first month when opening an account,
Account balance history lists at the configuration date newly-built second month in this month of opening an account;If opening an account, day is after the configuration date,
The then account balance history lists of newly-built first month and second month when opening an account, when the configuration date of second month,
Newly-built trimestral account balance history lists.The example above content is only to illustrate New Account remaining sum history lists
Content, and and be not used to limit the present invention.
The above, for generally, be in batch processing the and during next day of batch processing in the daytime at night every day, for
The process that the remaining sum of account every day and balance status are updated.But in concrete implementation process, for customer account,
It sometimes appear that affect the transaction (Day Trading of retrodicting as because adjusting account to occur) of history remaining sum, the most then need the most more
The remaining sum on the same day on corresponding date in the remaining sum at end day of New Account master meter, balance status at end day, and account balance history lists
And balance status.Specifically, for the remaining sum of relevant date during the transaction of the history remaining sum that makes a difference and balance status
Renewal process is as follows:
When retrodict Day Trading time, first according to the input of user determine this Day Trading of retrodicting actual starting date and send out
Raw dealing money, this actual starting date i.e. refers to, the starting date making history remaining sum change due to this transaction of retrodicting.
In actual applications, this user can be the teller of banking system, teller input this day friendship of retrodicting by terminal unit
Easy actual starting date and dealing money.
Then, from the beginning of the actual starting date of Day Trading of retrodicting, the state that queries the balance forward is " batch updating " or " connection
Machine update " date, this date is defined as the Base day, using the remaining sum of Base day as the baseline amount of money.
This is updated actual initial according to the baseline amount of money and the dealing money of Day Trading of retrodicting, the remaining sum of every day and balance status
Day is to day remaining sum of every day in account balance history lists occurs, and extremely actual starting date is occurred the balance status of day more
It is newly " online renewal ".
Specifically, for actual starting date to each day occurred in day proxima luce (prox. luc), if the balance status on the same day is " not
Know ", then abandon processing the remaining sum on the same day;If the balance status on the same day is " ibid one day ", then by the baseline amount of money and friendship
Easily amount of money sum is updated to the remaining sum on the same day;If the balance status on the same day is " online renewal " or " batch updating ",
Then the remaining sum current same day and dealing money sum are updated to the remaining sum on the same day.
Day Trading of retrodicting be there is to the balance status of day, then in a scheduled time (the e.g. next day of this generation day)
In the daytime during batch processing, according in account table this generation day end day remaining sum and balance status at end day come more than more New Account
The remaining sum of this generation day and balance status in volume history lists.
The recording method of the dynamic changing data of the embodiment of the present invention, in effectively record account balance history for business scenario
On the premise of use, by the way of asynchronous refresh, by specifically balance updates procedural arrangements next day in the daytime batch
In processing procedure, thus alleviate the impact for batch time window at night to greatest extent, improve treatment effeciency.
Further, the recording method of the dynamic changing data of the embodiment of the present invention, related to account balance is updated
Capital log history remaining sum, for non-Day Trading of retrodicting, can record remaining sum at end account day when batch processing at end day, and
Start batch program next day to update in history balance sheet;For Day Trading of retrodicting, history can be carried out in transaction simultaneously
The adjustment of upper remaining sum, the remaining sum change in this day caused simultaneously for this transaction, can be updated by batch program next day equally
In history balance sheet.
Below in conjunction with a concrete example specifically processing the recording method of the dynamic changing data of the embodiment of the present invention
Journey is described further.
Setup parameter configuration monthly No. 25 carry out the pre-inserted of account balance history lists next month.
Step 1, certain account were opened an account on March 10th, 2014, when opening an account, initialize end account table day remaining sum and
State, remaining sum history lists pre-inserted March and the record in April.
In account table end day remaining sum item and end day balance status item as shown in table 3 below.
Table 3
Day whole remaining sum | Day whole balance status |
0 | Unknown |
The account balance historical record in March is as shown in table 4 below.
Table 4
Date | 3.1…3.9 | 3.10 | 3.11…3.31 |
Remaining sum | 0 | 0 | 0 |
Balance status | Unknown | Unknown | Ibid one day |
The account balance historical record in April is as shown in table 5 below.
Table 5
Date | 4.1…4.30 |
Remaining sum | 0 |
Balance status | Ibid one day |
Step 2, opened an account the same day on March 10th, 2014, fund account 50,000 yuan, withdraw the money 10,000 yuan, this light
Whole remaining sum is 40,000 yuan, during batch processing at night on the same day, updates the remaining sum and balance status at end day at end day of account table,
Need not more new balance history lists.After renewal end day remaining sum and end day balance status as shown in table 6 below.
Table 6
Day whole remaining sum | Day whole balance status |
40000 | Batch updating |
Step 3, in the next day (on March 11st, 2014) of day of opening an account, update the account by batch processing in the daytime
The remaining sum on March 10 and balance status information in remaining sum history lists.
The account balance historical record in the March after renewal is as shown in table 7 below.
Table 7
Date | 3.1…3.9 | 3.10 | 3.11…3.31 |
Remaining sum | 0 | 40000 | 0 |
Balance status | Unknown | Batch updating | Ibid one day |
April, remaining sum historical record was as shown in table 8 below.
Table 8
Date | 4.1…4.30 |
Remaining sum | 0 |
Balance status | Ibid one day |
Step 4, on March 11st, 2014, account do not moves family, and March 11, night, batch updating account table was Sino-Japan
Whole balance status.After renewal end day remaining sum and end day balance status as shown in table 9 below.
Table 9
Day whole remaining sum | Day whole balance status |
40000 | Ibid one day |
Step 5, on March 12nd, 2014, owing to account table balance status at Sino-Japan end is " ibid one day ", in the daytime
Batch is not required to more new account balance history lists.
Now, account balance in March history lists record as shown in table 10 below.
Table 10
Date | 3.1…3.9 | 3.10 | 3.11 | 3.12…3.31 |
Remaining sum | 0 | 40000 | 0 | 0 |
Balance status | Unknown | Batch updating | Ibid one day | Ibid one day |
April account balance history lists record as shown in table 11 below.
Table 11
Date | No. 4.1 ... No. 4.30 |
Remaining sum | 0 |
Balance status | Ibid one day |
Step 6, from April 17th, 3.12 days 1 in 2014, account does not all move family, account table and account
Family remaining sum historical record situation is with above-mentioned step 4 and step 5.When April 18, the day deposit that falls back was handed over
Easily (the most above-mentioned transaction affecting history remaining sum, then April 18 is for occurring day), the Day Trading date of retrodicting is April
(above-mentioned actual starting date) on the 12nd, is stored in the amount of money 30,000 yuan, fall back Day Trading time to update account table Sino-Japan eventually remaining
Volume and balance status at end day (owing to being now online renewal, therefore balance status at end day is updated to " online renewal "),
The simultaneously record in the most more new balance history lists April 12 to April 17.Now, owing to April 12 is to April 17
Day " balance status on the same day " in account balance history lists is " ibid one day ", needs backtracking when carrying out balance updates
State nearest before April 12 is " online renewal " or the date of " batch updating ", with in this date
Remaining sum is as the baseline of follow-up balance updates.Needing to trace back to March 10 in this example, obtaining the baseline amount of money is 40,000.
Now, in the account table after renewal end day remaining sum and end day balance status as shown in table 12 below.
Table 12
Day whole remaining sum | Day whole balance status |
70000 | Online renewal |
Recording of the account balance history lists in the March after renewal is as shown in table 13 below.
Table 13
Date | 3.1…3.9 | 3.10 | 3.11 | 3.12…3.31 |
Remaining sum | 0 | 40000 | 0 | 0 |
Balance status | Unknown | Batch updating | Ibid one day | Ibid one day |
Recording of the account balance history lists in the April after renewal is as shown in table 14 below.
Table 14
Date | 4.1…4.11 | 4.12…4.17 | 4.18…4.30 |
Remaining sum | 0 | 70000 | 0 |
Balance status | Ibid one day | Online renewal | Ibid one day |
Step 7, when the batch processing at night on April 18, update the remaining sum and remaining sum at end day at end day of account table
State, it is not necessary to more new balance history lists.
After renewal end day remaining sum and end day balance status as shown in table 15 below.
Table 15
Day whole remaining sum | Day whole balance status |
70000 | Batch updating |
Step 8, when the batch processing in the daytime on April 19, update the account remaining sum history lists in April 18
Balance amount information.
Recording of the account balance history lists in the March after renewal is as shown in table 16 below.
Table 16
Date | 3.1…3.9 | 3.10 | 3.11 | 3.12…3.31 |
Remaining sum | 0 | 40000 | 0 | 0 |
Balance status | Unknown | Batch updating | Ibid one day | Ibid one day |
Recording of the account balance history lists in the April after renewal is as shown in table 17 below.
Table 17
Date | 4.1…4.11 | 4.12…4.17 | 4.18 | 4.19…4.30 |
Remaining sum | 0 | 70000 | 70000 | 0 |
Balance status | Ibid one day | Online renewal | Batch updating | Ibid one day |
Step 9, in default April 25 (monthly carrying out the pre-inserted of account balance history lists on 25th), criticize in the daytime
Amount processing procedure carries out the pre-inserted of the account balance history lists in May.The account balance history lists such as following table in newly-built May
Shown in 18.
Table 18
Date | 5.1…5.31 |
Remaining sum | 0 |
Balance status | Ibid one day |
Above, it is the recording method use example in actual applications of the dynamic changing data of the embodiment of the present invention, but
It is only the process that the embodiment of the present invention is described, and and be not used to limit the present invention.
By foregoing it can be seen that the recording method of the dynamic changing data of the embodiment of the present invention is effectively recording account
On the premise of family remaining sum history is for business scenario, account table adds remaining sum item at end day and remaining sum shape at end day
State item, and build account balance history lists, the transaction of history remaining sum is affected for Day Trading etc. of such as retrodicting, it is right to start
The balance updates process answered, the history that upgrades in time remaining sum, provide for the operation such as subsequent query or interest-bearing and count more accurately
According to support.Further, propose the mode of asynchronous refresh, alleviate the shadow for batch time window at night to greatest extent
Ring.And by the action parameterisable configuration of the pre-inserted remaining sum history of batch so that different provinces are configurable on not same date and enter
Row is pre-inserted, and action data processed is decentralized, and reasonable distribution resource alleviates the resource for on-line transaction and fights for,
Improve treatment effeciency.
One of ordinary skill in the art will appreciate that all or part of step realizing in above-described embodiment method can be led to
Program of crossing completes to instruct relevant hardware, and this program can be stored in a computer read/write memory medium, than
Such as ROM/RAM, magnetic disc, CD etc..
Particular embodiments described above, has been carried out the purpose of the present invention, technical scheme and beneficial effect the most in detail
Describe in detail bright, be it should be understood that the specific embodiment that the foregoing is only the present invention, be not used to limit this
Bright protection domain, all within the spirit and principles in the present invention, any modification, equivalent substitution and improvement etc. done,
Should be included within the scope of the present invention.
Claims (10)
1. the recording method of a dynamic changing data, it is characterised in that the record side of described dynamic changing data
Method includes:
Initialize the remaining sum and balance status at end day at end day in account table for current account, and will open an account residing for the same day
It is defined as the N month, the newly-built N month and the account balance history lists of the N+1 month month;
The remaining sum and balance status at end day at end day of N month n days is recorded in described account table;
In first scheduled time, according to described account table in the remaining sum and remaining sum shape at end day at end day of described n days record
State updates remaining sum and the balance status of n days in described account balance history lists;
When retrodict Day Trading time, update the remaining sum at end day of described account table, day eventually according to described Day Trading of retrodicting
From the actual starting date of described Day Trading of retrodicting in balance status and described account balance history lists, retrodict to described
The described remaining sum that day occurs of Day Trading and balance status.
The recording method of dynamic changing data the most according to claim 1, it is characterised in that described first pre-
Fix time is (n+1)th.
The recording method of dynamic changing data the most according to claim 1, it is characterised in that when retrodicting
During Day Trading, according to described retrodict Day Trading update the remaining sum at end day of described account table, balance status at end day and
In described account balance history lists from the actual starting date of described Day Trading of retrodicting, to generation day of described Day Trading of retrodicting
Described remaining sum and balance status, specifically include:
Receive actual starting date and the dealing money of Day Trading of retrodicting described in user's input;
From the beginning of described actual starting date, the state of querying the balance is batch updating or the date of online renewal forward, definition
On the basis of day, using the remaining sum of described Base day as the baseline amount of money;
According to the described baseline amount of money, described in the retrodict dealing money of Day Trading, the remaining sum of every day and balance status update institute
State actual starting date, to described, day remaining sum of every day in described account balance history lists occurs, and described reality is initiateed
Day is updated to online renewal to the balance status that day occurs.
The recording method of dynamic changing data the most according to claim 3, it is characterised in that according to described base
The line amount of money, described in the retrodict dealing money of Day Trading, the remaining sum of every day and balance status update described actual starting date extremely
Described generation day the remaining sum of every day in described account balance history lists, specifically include:
For the every day in described actual starting date to the described proxima luce (prox. luc) that day occurs, if balance status is unknown, then put
Abandon the remaining sum processing described every day;
If balance status is ibid one day, the described baseline amount of money and dealing money sum are updated to the remaining sum of described every day;
If balance status is online renewal or batch updating, the remaining sum current every day is updated with described dealing money sum
Remaining sum for described every day;
For described generation day, in second scheduled time, whole in the day of described generation day entry according to described account table
Remaining sum and balance status at end day update remaining sum and the balance status that day occurs described in described account balance history lists.
The recording method of dynamic changing data the most according to claim 3, it is characterised in that initialize account
Remaining sum and balance status at end day at end day in master meter, specifically includes:
Remaining sum at end day in described account table is defined as 0, and by fixed for the balance status at end day in described account table
Justice is unknown.
The recording method of dynamic changing data the most according to claim 5, it is characterised in that the newly-built N month
And the account balance history lists of the N+1 month, specifically include:
In the described N month, by described account balance history lists create day and before the date remaining sum definition
Be 0, balance status be defined as the unknown, and by described account balance history lists create day after the remaining sum on date fixed
Justice is 0, balance status is defined as ibid one day;
In the described N+1 month, daily balance being defined as 0, balance status is defined as ibid one day.
The recording method of dynamic changing data the most according to claim 6, it is characterised in that in described account
Master meter records the remaining sum and balance status at end day at end day of N month n days, specifically includes:
Step a1: whether the balance status at end day judging described n days is unknown;If it is, perform step a2,
Otherwise perform step a3;
Step a2: the balance status at end day of n days in described account table is updated to batch updating;
Step a3: judge whether the remaining sum at end day of n days changes;If it is, perform step a4, otherwise hold
Row step a5;
Step a4: update the remaining sum at end day of n days in described account table according to the change of remaining sum at described end day, and
Balance status at end day is updated to batch updating;
Step a5: the balance status at end day of n days in described account table is updated to ibid one day.
The recording method of dynamic changing data the most according to claim 7, it is characterised in that according to described account
Householder's table described n days record end day remaining sum and balance status at end day update the remaining sum of described n days and remaining sum shape
State, specifically includes:
Whether the balance status at described end day judging described n days is batch updating;
If it is, by the day that balance updates is described n days of n days corresponding in described account balance history lists eventually
Remaining sum, and balance status is updated to batch updating;
The most do not update described account balance history lists.
The recording method of dynamic changing data the most according to claim 1, it is characterised in that described is dynamic
The recording method of delta data also includes:
Preset the date in the one of the N+1 month, the account balance history lists of the newly-built N+2 month.
The recording method of dynamic changing data the most according to claim 9, it is characterised in that newly-built N+2
The account balance history lists of the moon, specifically includes:
In the described N+2 month, the described remaining sum of every day is defined as 0, balance status is defined as ibid one day.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610273068.6A CN105956918A (en) | 2016-04-28 | 2016-04-28 | Method for recording dynamic variation data |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201610273068.6A CN105956918A (en) | 2016-04-28 | 2016-04-28 | Method for recording dynamic variation data |
Publications (1)
Publication Number | Publication Date |
---|---|
CN105956918A true CN105956918A (en) | 2016-09-21 |
Family
ID=56916215
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201610273068.6A Pending CN105956918A (en) | 2016-04-28 | 2016-04-28 | Method for recording dynamic variation data |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN105956918A (en) |
Cited By (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107273452A (en) * | 2017-05-31 | 2017-10-20 | 深圳市长亮科技股份有限公司 | Data-updating method and system |
CN108335185A (en) * | 2018-02-09 | 2018-07-27 | 中国银行股份有限公司 | A kind of night on-line transaction accesses the method and device of newest facility extent |
CN109033468A (en) * | 2018-08-31 | 2018-12-18 | 阿里巴巴集团控股有限公司 | The processing method and processing device of resource change |
CN109214902A (en) * | 2018-07-27 | 2019-01-15 | 阿里巴巴集团控股有限公司 | A kind of user account assets settlement method and device |
CN110276614A (en) * | 2019-04-30 | 2019-09-24 | 阿里巴巴集团控股有限公司 | The update method and device of ledger |
CN111179090A (en) * | 2020-01-02 | 2020-05-19 | 中国银行股份有限公司 | Transaction data processing method, device and equipment |
CN111311396A (en) * | 2020-02-13 | 2020-06-19 | 中国建设银行股份有限公司 | Re-posting accounting method, device, equipment and storage medium |
CN111383089A (en) * | 2020-03-17 | 2020-07-07 | 中国建设银行股份有限公司 | Account adjusting method, account adjusting device, terminal equipment and storage medium |
CN113486021A (en) * | 2021-07-27 | 2021-10-08 | 中国银行股份有限公司 | Method and device for determining daily average balance of account in distributed bank system |
CN113807939A (en) * | 2021-10-21 | 2021-12-17 | 吉林亿联银行股份有限公司 | Account processing method and device |
-
2016
- 2016-04-28 CN CN201610273068.6A patent/CN105956918A/en active Pending
Cited By (15)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107273452A (en) * | 2017-05-31 | 2017-10-20 | 深圳市长亮科技股份有限公司 | Data-updating method and system |
CN108335185A (en) * | 2018-02-09 | 2018-07-27 | 中国银行股份有限公司 | A kind of night on-line transaction accesses the method and device of newest facility extent |
CN108335185B (en) * | 2018-02-09 | 2021-11-23 | 中国银行股份有限公司 | Method and device for accessing latest overdraft limit in night online transaction |
CN109214902A (en) * | 2018-07-27 | 2019-01-15 | 阿里巴巴集团控股有限公司 | A kind of user account assets settlement method and device |
CN109033468A (en) * | 2018-08-31 | 2018-12-18 | 阿里巴巴集团控股有限公司 | The processing method and processing device of resource change |
CN109033468B (en) * | 2018-08-31 | 2022-09-16 | 创新先进技术有限公司 | Resource change processing method and device |
CN110276614A (en) * | 2019-04-30 | 2019-09-24 | 阿里巴巴集团控股有限公司 | The update method and device of ledger |
CN110276614B (en) * | 2019-04-30 | 2023-01-13 | 创新先进技术有限公司 | Updating method and device of account splitting account |
CN111179090A (en) * | 2020-01-02 | 2020-05-19 | 中国银行股份有限公司 | Transaction data processing method, device and equipment |
CN111179090B (en) * | 2020-01-02 | 2024-04-19 | 中国银行股份有限公司 | Transaction data processing method, device and equipment |
CN111311396A (en) * | 2020-02-13 | 2020-06-19 | 中国建设银行股份有限公司 | Re-posting accounting method, device, equipment and storage medium |
CN111383089A (en) * | 2020-03-17 | 2020-07-07 | 中国建设银行股份有限公司 | Account adjusting method, account adjusting device, terminal equipment and storage medium |
CN113486021A (en) * | 2021-07-27 | 2021-10-08 | 中国银行股份有限公司 | Method and device for determining daily average balance of account in distributed bank system |
CN113486021B (en) * | 2021-07-27 | 2024-02-27 | 中国银行股份有限公司 | Method and device for determining daily average balance of account in distributed banking system |
CN113807939A (en) * | 2021-10-21 | 2021-12-17 | 吉林亿联银行股份有限公司 | Account processing method and device |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN105956918A (en) | Method for recording dynamic variation data | |
US10332204B2 (en) | Indirect and direct credit optimization | |
Sanya et al. | Assessing bank competition within the East African Community | |
CN110428322A (en) | A kind of adaptation method and device of business datum | |
CN107133289A (en) | A kind of method and apparatus of determination commercial circle | |
Tröster et al. | Delivering on promises? The expected impacts and implementation challenges of the economic partnership agreements between the European Union and Africa | |
CN109670896A (en) | Investment product recommended method, device, equipment and storage medium | |
Morkovina et al. | Export potential and measures to support small and medium-sized enterprises | |
Zelity | The welfare effects of FDI: A quantitative analysis | |
CN105631742A (en) | Small and medium enterprise credit evaluation method | |
CN106157138A (en) | Group belonging to a kind of bank transaction data determines method and device | |
Heckel et al. | Unconventional monetary policy through open market operations: A principal component analysis | |
Kuang et al. | The nonlinear effect of financial and fiscal policies on poverty alleviation in China—An empirical analysis of Chinese 382 impoverished counties with PSTR models | |
CN102354277A (en) | Data storage method and device | |
Whalley | China's integration into the world economy | |
Spray | Reorganise, replace or expand? The role of the supply-chain in first-time exporting | |
CN109191214B (en) | Transaction option matching method and system and intelligent transaction terminal | |
Rupa | Progress of MUDRA with special reference to Tamil Nadu | |
CN110276692A (en) | A kind of method and device handling transaction data | |
Kapur | A short-term analytical model of the Singapore economy | |
Liyanage | Determinants of capital inflows: Evidence from Sri Lanka | |
Zhang et al. | Total Factor Productivity and China's Miraculous Growth: An Empirical Analysis | |
YELDAN | MULTI-SECTOR GENERAL EQUILIBRIUM | |
TOXANOVA et al. | Innovative Entrepreneurship Financing in the Republic of Kazakhstan. | |
CN111429251A (en) | Method and device for processing data under multiple modes |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20160921 |
|
RJ01 | Rejection of invention patent application after publication |