CN102354277A - Data storage method and device - Google Patents

Data storage method and device Download PDF

Info

Publication number
CN102354277A
CN102354277A CN201110280416XA CN201110280416A CN102354277A CN 102354277 A CN102354277 A CN 102354277A CN 201110280416X A CN201110280416X A CN 201110280416XA CN 201110280416 A CN201110280416 A CN 201110280416A CN 102354277 A CN102354277 A CN 102354277A
Authority
CN
China
Prior art keywords
data
information table
summary information
layer
memory controller
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201110280416XA
Other languages
Chinese (zh)
Other versions
CN102354277B (en
Inventor
刘竞宇
李炅宇
侯勤川
李凡
张书波
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
China Minsheng Banking Corp Ltd
Original Assignee
China Minsheng Banking Corp Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by China Minsheng Banking Corp Ltd filed Critical China Minsheng Banking Corp Ltd
Priority to CN201110280416.XA priority Critical patent/CN102354277B/en
Publication of CN102354277A publication Critical patent/CN102354277A/en
Application granted granted Critical
Publication of CN102354277B publication Critical patent/CN102354277B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention provides a data storage method and device. The data storage method comprises that: a storage controller of the data storage device acquires a data storage command; the storage controller controls an infrastructure layer of the data storage device to store infrastructure data; the storage controller controls an intermediate layer of the data storage device to extract intermediate data corresponding to at least one application from the infrastructure data of the infrastructure layer and store the intermediate data into an intermediate summary information table; and the storage controller controls an application layer of the data storage device to extract the universal summary data of the application from the intermediate data of the intermediate layer, store the universal summary data into a universal summary information table, extract the data mart data of the application from the intermediate data and universal summary information table of the intermediate layer and store the data mart data into at least one application data mart. By the data storage method and device provided by the invention, data access efficiency can be improved.

Description

Date storage method and device
Technical field
The embodiment of the invention relates to data storage technology, relates in particular to a kind of date storage method and device.
Background technology
At present, adopt the Data Warehouse memory technology of financial service logic data model (Finance Serve Logic DataModel is called for short FS-LDM) to have widespread use in banking industry.The Data Warehouse memory technology of this employing FS-LDM is independent of any physical database platform, therefore has eurytopicity.
The data warehouse of FS-LDM adopts two layer architectures, correspondingly, also adopts two layer architectures based on the Data Warehouse memory storage of this FS-LDM, that is, this data storage device comprises basal layer and gathers layer.Wherein, the third normal form of standard is followed in the basal layer strictness.Particularly, in adopting the basal layer of third normal form: a notes record of source operation system table need break and store the scattered fractionation of business datum in several the object tables; The parent table is included the professional common information of all subclasses, makes that the data volume that contains the more parent table of subclass is extremely huge, and the complete access of subclass business datum need be used the related huge parent table of sublist; All record in the associated entity for the various relations between any two entities, with concerning that kind distinguishes the different relationships type, relation table is very huge.In existing Data Warehouse memory storage, be to gather layer on basal layer based on FS-LDM.Gather the derivative data of layer storage surface to each application, for the general character part of different application, gather the layer base layer data is repeated to gather.
In a word, according to the These characteristics of existing data storage device, adopt this data storage device, the response speed of data access operation is slow, efficient is low.
Summary of the invention
The embodiment of the invention provides a kind of date storage method, in order to solve defective of the prior art, improves data access efficiency.
The embodiment of the invention also provides a kind of data storage device, in order to solve defective of the prior art, improves data access efficiency.
The embodiment of the invention provides a kind of date storage method, comprising:
The memory controller of data storage device obtains data storage command;
The basal layer storage basic data of said memory controller controls data storage device;
The middle layer of said memory controller controls data storage device is extracted at least one and is used corresponding intermediate data and store middle summary information table into from the basic data of said basal layer;
The application layer of said memory controller controls data storage device is extracted the general combined data of using and is stored general summary information table into from the intermediate data in said middle layer, from the intermediate data in said middle layer and said general summary information table, extract the Data Mart data of using and store at least one application data fairground into.
Aforesaid method, wherein, the basal layer of said memory controller controls data storage device storage basic data comprises:
Said memory controller controls protocol information table is stored at least a protocol number and protocol type code; Said memory controller controls is as the protocol number and the protocol type code of at least one type information table storage corresponding types of the sublist of protocol information table; Said memory controller controls is as the data of the corresponding agreement of at least one data table stores of the sublist of type information table;
And/or said memory controller controls attribute history lists is according to protocol type, the attribute information of at least one agreement of classification and storage.
Aforesaid method, wherein, the middle layer of said memory controller controls data storage device is extracted the corresponding intermediate data of at least one application and is stored middle summary information table into and comprises from the basic data of said basal layer:
The said middle layer of said memory controller controls is extracted the corresponding data of account levels summary information and is stored account levels summary information table into from the basic data of said basal layer;
And/or the said middle layer of said memory controller controls is extracted the corresponding data of voucher level summary information and is stored voucher summary information table into from the basic data of said basal layer;
And/or the said middle layer of said memory controller controls is extracted the corresponding data of receipt level summary information and is stored receipt summary information table into from the basic data of said basal layer;
And/or the said middle layer of said memory controller controls is extracted the corresponding data of customer deposit level summary information and is stored customer deposit summary information table into from the basic data of said basal layer;
And/or the said middle layer of said memory controller controls is extracted the corresponding data of customer lending level summary information and is stored customer lending summary information table into from the basic data of said basal layer.
Aforesaid method, wherein, the middle layer of the said data storage device of said memory controller controls comprises said intermediate data storage to middle summary information table:
The major key of tables of data of basal layer that adopt to add prefix is as the major key of summary information table in the middle of said, or, adopt major key and the preset supplemental field of the tables of data of basal layer form said in the middle of the major key of summary information table;
And/or; Type according to the general character field in the tables of data of at least one basal layer; Confirm the type of this general character field of said middle summary information table; The type of the general character field in the tables of data of at least one basal layer not simultaneously, said in the middle of the type of this general character field of summary information table be variable type;
And/or the combination of Currency Type field and value type code field of tables of data of adopting basal layer is as the major key of summary information table in the middle of said, with the data-switching of different Currency Types in the tables of data of basal layer for specify Currency Type and store into said in the middle of the summary information table;
And/or, calculate the data of the attribute of deriving and store said middle summary information table into according to said basic data;
And/or, the said intermediate data in the middle of said in the summary information table storage preset time period.
Aforesaid method; Wherein, the application layer of said memory controller controls data storage device also comprises after from the intermediate data in said middle layer, extracting the general combined data of using: the application layer of the said data storage device of said memory controller controls is extracted the general combined data of using from the basic data of said basal layer;
The application layer of said memory controller controls data storage device also comprises after from the intermediate data in said middle layer and said general summary information table, extracting application data fairground data: the application layer of the said data storage device of said memory controller controls is extracted the Data Mart data of application from the basic data of said basal layer.
The embodiment of the invention also provides a kind of data storage device, comprising: memory controller, basal layer, middle layer and application layer;
Memory controller obtains data storage command; Control basal layer storage basic data; The control middle layer is extracted at least one and is used corresponding intermediate data and store middle summary information table into from the basic data of said basal layer; The control application layer is extracted the general combined data of using and is stored general summary information table into from the intermediate data in said middle layer, from the intermediate data in said middle layer and said general summary information table, extract the Data Mart data of application and store at least one application data fairground into.
Aforesaid data storage device; Wherein, Said basal layer specifically is used for the control according to said memory controller; Store at least a protocol number and protocol type code at the protocol information table; At protocol number and protocol type code, in data as at least one data table stores correspondence agreement of the sublist of type information table as at least one type information table storage corresponding types of the sublist of protocol information table;
And/or said basal layer specifically is used for the control according to said memory controller, at the attribute information of attribute history lists according at least one agreement of protocol type classification and storage.
Aforesaid data storage device, wherein,
Said middle layer specifically is used for extracting the corresponding data of account levels summary information and storing account levels summary information table into from the basic data of said basal layer according to the control of said memory controller;
And/or said middle layer specifically is used for the control according to said memory controller, from the basic data of said basal layer, extracts the corresponding data of voucher level summary information and stores voucher summary information table into;
And/or said middle layer specifically is used for the control according to said memory controller, from the basic data of said basal layer, extracts the corresponding data of receipt level summary information and stores receipt summary information table into;
And/or said middle layer specifically is used for the control according to said memory controller, from the basic data of said basal layer, extracts the corresponding data of customer deposit level summary information and stores customer deposit summary information table into;
And/or said middle layer specifically is used for the control according to said memory controller, from the basic data of said basal layer, extracts the corresponding data of customer lending level summary information and stores customer lending summary information table into.
Aforesaid data storage device, wherein,
Said middle layer specifically is used for the control according to said memory controller; The major key of the tables of data of the basal layer of employing interpolation prefix is as the major key of summary information table in the middle of said; Or, the major key of the major key of the tables of data of employing basal layer and the said middle summary information table of presetting of supplemental field composition;
And/or; Said middle layer specifically is used for the control according to said memory controller; Type according to the general character field in the tables of data of at least one basal layer; Confirm the type of this general character field of said middle summary information table; The type of the general character field in the tables of data of at least one basal layer not simultaneously, said in the middle of the type of this general character field of summary information table be variable type;
And/or; Said middle layer specifically is used for the control according to said memory controller; The combination of Currency Type field and value type code field of tables of data of adopting basal layer is as the major key of summary information table in the middle of said, with the data-switching of different Currency Types in the tables of data of basal layer for specify Currency Type and store into said in the middle of the summary information table;
And/or said middle layer specifically is used for the control according to said memory controller, calculates the data of the attribute of deriving and stores said middle summary information table into according to said basic data;
And/or said middle layer specifically is used for the control according to said memory controller, the said intermediate data in the middle of said in the summary information table storage preset time period.
Aforesaid data storage device, wherein,
Said memory controller also is used for controlling general combined data and the Data Mart data of the application layer of said data storage device from the basic data extraction application of said basal layer;
The application layer of said data storage device also is used for the control according to said memory controller, from the basic data of said basal layer, extracts general combined data and the Data Mart data of using.
Can be known that by technique scheme the embodiment of the invention is through increasing the middle layer in data storage device, this middle layer of memory controller controls is extracted basic data and is gathered into intermediate data from basal layer, and intermediate data storage is arrived the middle layer.The memory controller controls application layer is from the extracting data data of middle layer storage.Because the data to basal layer are carried out preliminary gathering in the middle layer; Application layer can be obtained data from the table in middle layer; And a large amount of table that needn't search basal layer one by one; And avoided application layer in the technical scheme of existing two layer architectures to base layer data repeat gather, thereby improved the efficient of data access operation.
Description of drawings
In order to be illustrated more clearly in the embodiment of the invention or technical scheme of the prior art; To do one to the accompanying drawing of required use in embodiment or the description of the Prior Art below introduces simply; Obviously; Accompanying drawing in describing below is some embodiments of the present invention; For those of ordinary skills; Under the prerequisite of not paying creative work, can also obtain other accompanying drawing according to these accompanying drawings.
Fig. 1 is the process flow diagram of the date storage method of the embodiment of the invention one;
Fig. 2 is the structural representation of the data storage device of the embodiment of the invention two.
Embodiment
For the purpose, technical scheme and the advantage that make the embodiment of the invention clearer; To combine the accompanying drawing in the embodiment of the invention below; Technical scheme in the embodiment of the invention is carried out clear, intactly description; Obviously; Described embodiment is the present invention's part embodiment, rather than whole embodiment.Based on the embodiment among the present invention, those of ordinary skills are not making the every other embodiment that is obtained under the creative work prerequisite, all belong to the scope of the present invention's protection.
Fig. 1 is the process flow diagram of the date storage method of the embodiment of the invention one.As shown in Figure 1, this method comprises following process.
Step 101: the memory controller of data storage device obtains data storage command.
Step 102: the basal layer storage basic data of memory controller controls data storage device.
Step 103: the middle layer of memory controller controls data storage device is extracted at least one and is used corresponding intermediate data and store middle summary information table into from the basic data of basal layer.
Step 104: the application layer of memory controller controls data storage device is extracted the general combined data of using and is stored general summary information table into from the intermediate data in middle layer, from the intermediate data in middle layer and general summary information table, extracts the Data Mart data of using and stores at least one application data fairground into.
In the embodiment of the invention one, in data storage procedure, increased the middle layer storing process.After storing basic data into basal layer, from basal layer, extract to use corresponding intermediate data storage to the middle layer, the data of application layer storage are the extracting data of the storage from the middle layer and coming.Owing between basal layer and application layer, increased the middle layer, the data in the middle layer to basal layer are carried out preliminary gathering, thereby have strengthened the stratification of data granularity.The table of application layer is associated with the table in the middle layer that data are tentatively gathered, and has reduced related with the table of various basal layer.When reading of data; Application layer can be obtained data from the table in middle layer; And a large amount of table that needn't as prior art, search basal layer one by one; And through tentatively gathering of middle layer; Avoided application layer in the technical scheme of existing two layer architectures to base layer data repeat gather, thereby improved the efficient of data access operation.
On the basis of technique scheme, particularly, in the step 101, use the user of data storage device to send data storage command to the memory controller of data storage device through client, comprise basic data to be stored in this data storage command.After step 104, can also comprise step 105: message is accomplished in the storage of memory controller return data.Particularly, memory controller is accomplished message to the storage of user client return data.
On the basis of technique scheme; Further; In above-mentioned steps 103; Memory controller can also the control data memory storage application layer from the basic data of basal layer, extract the general combined data of using; And the application layer that memory controller can also the control data memory storage is extracted the Data Mart data of using from the basic data of basal layer.Particularly; The application layer of data storage device can be subdivided into two parts; That is: general gather the part and the Data Mart part; The detailed process of step 103 comprises: the first step, the application layer of memory controller controls data storage device general gather part and from the basic data of the intermediate data in middle layer and basal layer, extract the general combined data of using and store at least one application summary information table into; In second step, the Data Mart of the application layer of memory controller controls data storage device part is extracted the Data Mart data of using and is stored at least one application data fairground table into from the basic data of the intermediate data in above-mentioned application summary information table, middle layer and basal layer.Wherein, In the first step; The general part that gathers is preferentially extracted required general combined data from the intermediate data in middle layer, if the intermediate data in middle layer can't satisfy the needs of general combined data, the general part that gathers is extracted from the basic data of basal layer again.In second step; The Data Mart part is preferentially extracted required Data Mart data from the intermediate data in general summary information table and middle layer; If the intermediate data in general summary information table and middle layer all can't satisfy the needs of Data Mart data, the Data Mart part is extracted from the basic data of basal layer again.This step has increased the dirigibility of data storage through the data from middle layer and basal layer co-extracted application layer.
Below respectively through instantiation, under the control of memory controller, the storing process of basal layer, middle layer, application layer describes in detail.
Basal layer
In above-mentioned steps 101; Under the control of memory controller, during the basal layer of data storage device storage basic data, for the storage of agreement theme; Adopt following processing mode: at first, memory controller controls protocol information table is stored at least a protocol number and protocol type code; Then, memory controller controls is as the protocol number and the protocol type code of at least one type information table storage corresponding types of the sublist of protocol information table; At last, memory controller controls is as the data of the corresponding agreement of at least one data table stores of the sublist of type information table.
Below introduce the storage means of basal layer under the control of memory controller that the present invention proposes through a specific embodiment.Basal layer has been contained the basic data of operation system; For example, basal layer can comprise the data of following system: core system, individual loan system, to public risk system, Net silver system, fund system, three-party deposit system, billing system, international clearing system, foreign-currency trade system, credit card system, large-amount payment system, small amount payment system etc.In the date storage method that the present invention proposes,, the data storage of basal layer is classified according to agreement corresponding service characteristics and service logic according to the inquiry and the frequency of utilization of business demand and data.Agreement is the contractual relation of signing to certain specific products or service between financial institution and the client, and the data content of an agreement can comprise: the declaration form of deposit at bank account, loan account, inner account, loan receipt, contract, insurance company etc.With the source operation system is example, and table 1 is the tables of data of variety of protocol in the operation system of source.Referring to table 1, this source operation system includes but not limited to the agreement of record in the table 1, and is concrete, in the data content such as table 1 of each agreement.
Table 1 is the tables of data of variety of protocol in the operation system of source
Figure BDA0000092711870000091
In embodiments of the present invention, to above-mentioned variety of protocol, according to the difference of business characteristic, above-mentioned agreement is classified, according to the data of each agreement of classification and storage.For example, in the variety of protocol of table 1 record: savings account agreement, loan account agreement and inner account agreement all belong to the account quasi-protocol; Personal loan receipt agreement and to the equal data receipt of public affairs loans receipt agreement quasi-protocol.In the form of basal layer storage, comprise protocol information table, type information table and tables of data, wherein, the protocol information table is as super parent table, at least one type information table of protocol information table subordinate, the type information table is as the sublist of protocol information table.The type information table is as parent table, at least one tables of data of type information table subordinate, and tables of data is as the sublist of type information table.Wherein, the protocol information table is stored at least a protocol number and protocol type code.The protocol number and the protocol type code of type information table storage corresponding types.Variety of protocol according to table 1 record; The type information table can be divided into account category information table and receipt category information table; The protocol number of storage accounts quasi-protocol and protocol type code in the account category information table, the protocol number and the protocol type code of storage receipt quasi-protocol in the receipt category information table.The data of the corresponding agreement of data table stores.According to the variety of protocol of table 1 record, account category information table subordinate's tables of data can comprise savings account tables of data, loan account tables of data and inner account data table or the like.Receipt class contract information table subordinate's tables of data can comprise personal loan receipt tables of data, to public affairs loans receipt tables of data or the like.Wherein, each data table stores related data of corresponding protocols separately.With the savings account tables of data is example, and the protocol number of storage savings account agreement in the savings account tables of data, protocol type code, mechanism number, protocol status code, Currency Type, agreement Start Date, agreement date of expiry, interest rate, subject code, paper money converge data such as sign, the balance of deposits, last financial transaction day and customer manager.Further, for the agreement of inconvenience classification, agreements such as the card of record and contract in the table 1 for example, card tables of data that it is corresponding and contract dataset table can be directly as the sublist of protocol information table.
A kind of preferred implementation is, in practical application, above-mentioned as super parent table protocol information table table and all be logical table as the type information table of parent table, reality is physicsization not.
In technique scheme; When the basic data of storage basal layer, through agreement being classified the data qualification storage corresponding according to business characteristic to different agreement; Thereby obtain desired data rapidly and accurately according to classification when being convenient to reading of data, improved data access efficiency.
In above-mentioned steps 101; Under the control of memory controller; When the basal layer of data storage device is stored basic data; Storage for the attribute history lists; Adopt following processing mode: memory controller controls attribute history lists is according to protocol type, the attribute information of at least one agreement of classification and storage.Through the attributive classification of different agreement type is deposited, only relate to the corresponding attribute history lists of this agreement to the accessing operation of the data of a certain quasi-protocol.Do not distinguish protocol type with existing basal layer and the attribute history lists that each protocol attribute all directly stores the agreement master meter into concentrated compare, the method for the above-mentioned classification and storage protocol attribute of the embodiment of the invention can significantly improve the efficient of user capture location in the data access process.
The middle layer
In the date storage method of the embodiment of the invention, between basal layer and application layer, increased the middle layer.
In practical application; Utilize the data of basal layer storage; Actual business requirement realizes multiple application; For example, can include but not limited to following application: client's single view, customer relation management, profitability analysis, client's integration managing, retail customer handle examination, financial general ledger form etc.The data that these application relate to all derive from the basic data of basal layer storage, and need handle basic data according to the real needs of using.For example; Client's single view application need extracts remaining sum, month average daily remaining sum, the season average daily remaining sum and data such as year average daily remaining sum of client's essential information, all kinds of savings account, card and every loan receipt from basic data, and data such as the loans and deposits remaining sum of client's level and all kinds of average daily remaining sums.The customer relation management application need extracts the client from basic data essential information, the situation of holding of client's various product, client trading preference such as gathers at data.Client's integration managing application need extracts data such as the gathering of all kinds of accounts and loan balance, classification of business transaction, client's essential information from basic data.The retail customer handles data such as the examination application need extracts every client of customer manager exploitation or lifting from basic data assets, debt, intermediary service information.Finance general ledger form application need from basic data, extract each section now the account balance data and gather so that general ledger and ledger are consistent.
According to the analysis of desired data is used in above-mentioned application and other, in embodiments of the present invention, before application layer was extracted data, elder generation carried out preliminary extraction in the middle layer to basic data and gathers.On this basis, application layer is directly used the data of extracting in above-mentioned middle layer and perhaps again the data of middle layer extraction is aggregated into the more data of coarseness such as client's level, subject level and mechanism's level.
Particularly; In above-mentioned steps 102, middle summary information table can comprise a kind of or several combination arbitrarily in following each table: account levels summary information table, voucher summary information table, receipt summary information table, customer deposit summary information table and customer lending summary information table.Correspondingly; Under the control of memory controller; When the middle layer of data storage device is extracted the corresponding intermediate data of at least one application and is stored centre summary information table into from the basic data of basal layer; Adopt a kind of or several combination arbitrarily in the following processing mode: the first, the memory controller controls middle layer is extracted the corresponding data of account levels summary information and is stored account levels summary information table into from the basic data of basal layer; The second, the memory controller controls middle layer is extracted the corresponding data of voucher level summary information and is stored voucher summary information table into from the basic data of basal layer; The 3rd, the memory controller controls middle layer is extracted the corresponding data of receipt level summary information and is stored receipt summary information table into from the basic data of basal layer; The 4th, the memory controller controls middle layer is extracted the corresponding data of customer deposit level summary information and is stored customer deposit summary information table into from the basic data of basal layer; The 5th, the memory controller controls middle layer is extracted the corresponding data of customer lending level summary information and is stored customer lending summary information table into from the basic data of basal layer.
From the basic data of basal layer, extract the corresponding data instance of account levels summary information with the middle layer, the mean data of attribute, remaining sum and each frequency of account level is extracted in the middle layer from basal layer.Storage means with variety of protocol shown in the above-mentioned table 1 and above-mentioned basal layer is an example; Real needs according to various application; Under the control of memory controller; Middle layer extraction from basal layer needs the basic data of book keeping operation; That is, the base layer data that subject code and professional code name are arranged is extracted in the middle layer from basal layer.For example, adopt in the data of basal layer storage of said method the middle layer data in account data table, loan account tables of data and the inner account data table of from basal layer, drawing deposits.
In the middle layer after basal layer extracts data, with above-mentioned data storage in middle summary information table.Particularly, in above-mentioned steps 102, under the control of memory controller, the middle layer of data storage device during to middle summary information table, is adopted following processing mode with intermediate data storage:
The first, the major key of tables of data of basal layer that adopt to add prefix is as the major key of middle summary information table, or, adopt the major key of the tables of data of basal layer form with preset supplemental field in the middle of the major key of summary information table.
According to the data of required extraction, if each major key still has uniqueness when being arranged on the major key in the tables of data of required a plurality of basal layers in the form, then can be with the major key of the major key in the tables of data of basal layer as middle summary information table.Otherwise, if exist when being arranged on the major key in the tables of data of required a plurality of basal layers in the form major key not have the situation of uniqueness, then can adopt any one mode in the following dual mode be provided with in the middle of the major key of summary information table.Mode one: before the major key of the tables of data of each basal layer, add different prefixs and distinguish, with the major key of the tables of data of the basal layer that adds prefix major key as middle summary information table.Mode two: the major key of middle summary information table adopts the combination major key; With the major key of the tables of data of basal layer a part as this combination major key; And increase the field that another one is used to distinguish the tables of data major key of basal layer again; As middle summary information table supplemental field, by the major key of the tables of data of basal layer and supplemental field combination combination major key as middle summary information table.Mode two does not change the record of former table major key, has not only helped quick and precisely searching but also can improve related efficient between the table of middle layer and basal layer.
The second, according to the type of the general character field in the tables of data of at least one basal layer, the type of this general character field of summary information table in the middle of confirming.The type of the general character field in the tables of data of at least one basal layer not simultaneously, the type of this general character field of middle summary information table is a variable type.
In middle summary information table, when the type of general character field is set, need consider the type of this field of tables of data of each basal layer simultaneously, the expansion needs of other data source that further also need look to the future.For example, the type of certain general character field in first tables of data of basal layer is 4 character types, is designated as CHAR (4); Type in second tables of data of basal layer is 5 character types, is designated as CHAR (5); Type in the 3rd tables of data of basal layer is 6 character types; Be designated as CHAR (6); Then can the type of this general character field in middle summary information table be set to 6 bit variable character types; Be designated as VARCHAR (6); Further, it is also conceivable that the needs of the data source that following other business is required, the length of this field is expanded; The type of this general character field in middle summary information table is set to 8 bit variable character types, is designated as VARCHAR (8).Adopt aforesaid way that the type of the general character field in the middle summary information table is set, can guarantee the data of from the tables of data of basal layer, extracting are accurately stored, and can save storage space.Further, through field length is expanded, improved the extensibility of the middle summary information table in middle layer.
The 3rd, the combination of Currency Type field and value type code field of tables of data of adopting basal layer is as the major key of middle summary information table, with the data-switching of different Currency Types in the tables of data of basal layer for specifying Currency Type and storing middle summary information table into.
In the basic data of basal layer storage, the Currency Type that different accounts adopts possibly have nothing in common with each other.Because can't directly carry out computing to different Currency Types in application layer; Therefore the situation to different Currency Types gathers in the middle layer, thus make application layer can be only mode through simple summation can obtain fine-grained summarized results such as client's level, subject level, mechanism's level according to account.In the middle summary information table in middle layer, adopt Currency Type field and the combination of value type code field in the tables of data of basal layer, as the part of the major key of middle summary information table.In the middle layer, with the data-switching of different Currency Types in the tables of data of basal layer for specify Currency Type and store in the middle of the summary information table.For example, the data-switching of the remaining sum generic attribute stored in the base layer data table to Renminbi and/or dollar corresponding data, in middle summary information table, is stored respectively the data of former coin, folding Renminbi and folding dollar.In the middle layer Currency Type and corresponding data are converted, provide convenience, saved the time that application layer is extracted data, improved data access efficiency thereby extract combined data for application layer.
The 4th, calculate the data of the attribute of deriving and store middle summary information table into according to basic data.
Concrete needs according to the various application of application layer calculate the required attribute of deriving that calculates according to base layer data of each application layer in the middle layer.For example; From the remaining sum history lists of basal layer storage, extract balance data on the same day; And according to the concrete business rule of using; According to the same day balance data calculate to obtain the data of the attribute correspondences of deriving such as nearly three months average daily data of equal data of the monthly data of remaining sum, remaining sum season, the average annual data of remaining sum, remaining sum, nearly 1 year average daily data of remaining sum, with the data storage of above-mentioned derive attribute and correspondence in middle summary information table.When application layer need be extracted above-mentioned derivative data; Needn't extract and calculate the basic data of basal layer; The data that only need extract the required attribute correspondence of deriving from the middle layer get final product, thereby have improved the speed of application layer reading of data, have improved data access efficiency.
The 5th, the intermediate data in middle summary information table storage preset time period.
Need the data of basal layer be gathered in the middle layer, and the data that require the middle layer to gather can support the real needs of the multiple application of application layer, therefore, need the intermediate data in the storage preset time period in the middle summary information table in middle layer.If this preset time period is long, can waste storage space, if this preset time period is too short, then can't satisfy the real needs that application layer is all used.A kind of preferred implementation is, this time cycle is preset as 13 months, promptly keeps the data at nearest 13 months the end of month in the middle summary information table in middle layer.And, on this basis, can also adjust the preset time cycle according to the concrete condition of using.
Particularly; The method that adopt said extracted in the middle layer, gathers and store intermediate data; Can store multiple middle summary information table in the middle layer, specifically can include but not limited to following each table: account levels summary information table, card summary information table, other voucher summary information table, receipt summary information table, customer deposit summary information table and customer lending summary information table.
In technique scheme,, between basal layer and application layer, play the succession effect through between basal layer and application layer, the middle layer being set.For basal layer, the data after the middle layer storage is processed, gathered base layer data are more near the needs of using; And for application layer, the combined data of the various application of supporting application layer is extracted and is calculated in the middle layer from basal layer.Before application layer was extracted data, elder generation carried out preliminary extraction in the middle layer to basic data and gathers.When application layer need be extracted data, the first-selected intermediate data that extracts from the middle layer, when the required data of application layer were not preserved in the middle layer, application layer was extracted basic data from basal layer again.Thereby gather level and granularity through what application layer data had been enriched in the storage that increases the middle layer, make data gather granularity and become more meticulous more.And, through the middle layer is set, avoided application layer through many tables in storage satisfy the general character data of various application, reduced redundancy, reduced repeating that general character uses effectively and gathered, improved the access response speed of data access operation.
Application layer
Under the control of memory controller; Application layer is according to the real needs of various application; The data of basal layer and middle layer storage are extracted and are gathered, the data storage after will gathering to general combined data table with at least one in the application data fairground table of application-specific.
Wherein, application data fairground table is directly related with concrete application.For example; Can be divided into following application data fairground table according to professional bar line and type of service; But be not limited to following each table, comprise: client's single view fairground, customer relation management fairground, business indicator wall bulletin fairground, anti money washing fairground, the outstanding integration of retail fairground, retail examination fairground, e-bank's Data Mart, multidimensional data fairground, public affairs and division department fairground etc.Particularly, the data granularity in different fairgrounds and time cycle are according to the real needs setting in this fairground.For example,, satisfy the requirement of new Basel Agreement, need to keep nearest 5 years detailed data for the EWRM Data Mart; For each branch retail examination data fairground, need to keep the customer manager of nearest 2 years end of the seasons and the examination summarized results of each team; For the Data Mart that does not have specific demand, keep the combined data at nearly in the end of month, 1.
Summary information of customers table with in above-mentioned client's single view fairground is an example, and under the control of memory controller, application layer is from the middle layer or from middle layer and basal layer extraction data and gather and specifically comprise following process.
Application layer is extracted the data on identical statistics date from account summary information table, receipt summary information table, customer deposit summary information table and the customer lending summary information table in middle layer, and carries out related through core customer major key, Currency Type and value type code major key.In the summary information of customers table storage client open an account mechanism number, litigant's Sort Code, hold the product number, data such as the balance of deposits moon is average daily, balance of deposits season is average daily, balance of deposits year is average daily, the balance of deposits and loan ceiling.Wherein, open an account mechanism field of the client from the customer deposit summary information table in middle layer is extracted the open an account data of mechanism number of client in the summary information of customers table; Litigant's Sort Code field from the customer deposit summary information table in middle layer is extracted the data of the litigant's Sort Code in the summary information of customers table; Through Different products number field in the account summary information table in middle layer and the receipt summary information table is gathered according to the core customer attribute, obtain the data of holding the product number of summary information of customers table; Respectively through, remaining sum Ji Jun monthly to remaining sum in the customer deposit summary information table in middle layer, remaining sum is average annual and the remaining sum field; Gather according to the core customer attribute, the balance of deposits moon that obtains the summary information of customers table respectively is average daily, balance of deposits season average daily, balance of deposits year average daily and data such as the balance of deposits; Through the residue capital field in the customer lending summary information table in middle layer is gathered according to the core customer attribute, obtain the data of the loan ceiling of summary information of customers table.The extracting data that data in the summary information of customers table of application layer are all stored from the middle layer; Further, in other summary information table of application layer storage, the data of part summary information table storage need simultaneously from the data of the data of middle layer storage and basal layer storage, to extract.In technique scheme, through the middle layer is set when the data storage, application layer is preferably extracted data from the middle layer when extracting data, thereby makes the operation of application layer succinct more, fast.
More than date storage method that the present invention is proposed introduce, below through the embodiment of the invention two, introduce the data storage device that adopts above-mentioned date storage method.
Fig. 2 is the structural representation of the data storage device of the embodiment of the invention two.As shown in Figure 2, this data storage device comprises: memory controller 20, basal layer 21, middle layer 22 and application layer 23.
Wherein, Memory controller 20 obtains data storage command; Control basal layer 21 storage basic datas; Control middle layer 22 is extracted at least one and is used corresponding intermediate data and store middle summary information table into from the basic data of basal layer 21; Control application layer 23 is extracted the general combined data of using and is stored general summary information table into from the intermediate data in middle layer 22, from the intermediate data in said middle layer and said general summary information table, extract the Data Mart data of application and store at least one application data fairground into.
Basal layer 21 is used for storage basic data under the control of memory controller 20.Middle layer 22 is used under the control of memory controller 20, extracting at least one from the basic data of basal layer 21 and uses corresponding intermediate data and store middle summary information table into.Application layer 23 is used under the control of memory controller 20 from the middle layer that 22 intermediate data extracts the general combined data of using and stores general summary information table into, and is used under the control of memory controller 20 from the middle layer that 22 intermediate data and above-mentioned general summary information table extract the Data Mart data of using and store at least one application data fairground into.
On the basis of such scheme; Particularly; Basal layer 21 is used under the control of memory controller 20; Store at least a protocol number and protocol type code at the protocol information table; At protocol number and protocol type code, in data as at least one data table stores correspondence agreement of the sublist of type information table as at least one type information table storage corresponding types of the sublist of protocol information table.On the basis of such scheme, particularly, basal layer 21 can also be used under the control of memory controller 20, in the attribute history lists, and according to protocol type, the attribute information of at least one agreement of classification and storage.
On the basis of such scheme, particularly, middle layer 22 specifically is used under the control of memory controller 20, extracting the corresponding data of account levels summary information and storing account levels summary information table into from the basic data of basal layer 21.And/or middle layer 22 specifically is used under the control of memory controller 20, extracting the corresponding data of voucher level summary information and storing voucher summary information table into from the basic data of basal layer 21.And/or middle layer 22 specifically is used under the control of memory controller 20, extracting the corresponding data of receipt level summary information and storing receipt summary information table into from the basic data of basal layer 21.And/or middle layer 22 specifically is used under the control of memory controller 20, extracting the corresponding data of customer deposit level summary information and storing customer deposit summary information table into from the basic data of basal layer 21.And/or middle layer 22 specifically is used under the control of memory controller 20, extracting the corresponding data of customer lending level summary information and storing customer lending summary information table into from the basic data of basal layer 21.
On the basis of such scheme; Particularly; Middle layer 22 is used for the control according to memory controller 20; The major key of the tables of data of the basal layer 21 of employing interpolation prefix is as the major key of middle summary information table; Or, the major key of summary information table in the middle of the major key of the tables of data of employing basal layer 21 is formed with preset supplemental field.Middle layer 22 also is used for the control according to memory controller 20; Type according to the general character field in the tables of data of at least one basal layer 21; The type of this general character field of summary information table in the middle of confirming; The type of the general character field in the tables of data of at least one basal layer 21 not simultaneously, the type of this general character field of middle summary information table is a variable type.Middle layer 22 also is used for the control according to memory controller 20; The combination of Currency Type field and value type code field of tables of data of adopting basal layer 21 is as the major key of middle summary information table, with the data-switching of different Currency Types in the tables of data of basal layer 21 for specify Currency Type and store in the middle of the summary information table.Middle layer 22 also is used for the control according to memory controller 20, calculates the data of the attribute of deriving and stores middle summary information table into according to basic data.Middle layer 22 also is used for the control according to memory controller 20, the intermediate data in middle summary information table storage preset time period.
On the basis of such scheme, particularly, memory controller 20 also is used for the application layer 23 of control data memory storage and extracts general combined data and the Data Mart data of using from the basic data of basal layer 21.The application layer 23 of data storage device also is used for the control according to memory controller 20, from the basic data of basal layer 21, extracts general combined data and the Data Mart data of using.
In the above-mentioned data storage device, the date storage method of memory controller 20 control basal layer 21, middle layer 22 and application layers 23 is carried out according to the date storage method of the embodiment of the invention one record, repeats no more at this.
On the basis of technique scheme; In practical application; Can adopt 20 pairs of basal layers 21 of a memory controller; Comprehensive Control is carried out with application layer 23 in middle layer 22; Also can be to basal layer 21; Middle layer 22 adopts three memory controllers to control respectively with application layer 23; Promptly; Adopt the basal layer memory controller; Middle layer memory controller and application layer memory controller are respectively to basal layer 21; Middle layer 22 is controlled with application layer 23; Specifically the control method to each layer is identical with technique scheme; Need be to the new data of data storage device stores the time, basal layer memory controller controls basal layer 21 carries out storage operation.After basal layer memory controller controls basal layer 21 was accomplished storage operation, the basal layer memory controller sent a notification message to the middle layer memory controller.After storage operation was accomplished in memory controller controls middle layer, middle layer 22, the middle layer memory controller sent a notification message to the application layer memory controller.After application layer memory controller controls application layer 23 was accomplished storage operation, the application layer memory controller was accomplished message to the storage of user client return data.
In the embodiment of the invention two, in data storage device, increased the middle layer, thereby strengthened the stratification of data granularity.The middle layer is extracted basic data and is gathered from basal layer; Obtain intermediate data and storage; Application layer is extracted data from the intermediate data of middle layer storage, and needn't as prior art, search a large amount of table of basal layer one by one, has therefore improved data access efficiency.And, through the middle layer to tentatively the gathering of data, avoided application layer in the technical scheme of existing two layer architectures to base layer data repeat gather, improved data access efficiency.
Date storage method and data storage device that the present invention proposes adopt three-tier architecture, transform to the layer architecture that can embody the different levels division of labor from traditional single stiff data storage device framework.Compare with existing two layer architectures; The data storage device of the three-tier architecture that the present invention proposes is well arranged, framework is clear; Not only improve the extensibility of data storage device, but also improved the efficient of data access and the efficient that the data memory storage is administered and maintained.In the concrete application of banking industry; The various information application grows with each passing day with business demand, and the advance of this data storage device, applicability and high efficiency play conclusive effect to the follow-up function of bringing into play data storage device decision support, marketing support, management support to greatest extent.The three-tier architecture of the data storage device that the present invention proposes is innovated on the basis of inheriting the existing data storage device framework of industry.The middle layer is set in the data storage device framework first; The multi-layer data memory storage framework that constructs; Can strengthen the stratification and the variation of data granularity; Satisfy the demand of types of applications fast comprehensively; Solve effectively that repeating that the conventional data storage device architecture exists gathered, redundant storage, problems such as sharing degree is low, standard differs, consistance difference; Concentrate the condition of having created for realizing full administration-management reason infologic; Greatly improve the efficient of storage, processing and the use of the battalion's management data of passing through entirely, reduced handling cost.And the framework of the data storage device that the present invention proposes can shorten data modeling cycle and data load time, improves the overall operation and the maintenance efficiency of data storage device.Novel framework of the present invention is the bank data hierarchical design; Reduce interference and influence between each layer data as far as possible; Make the extendability of data storage device more powerful; The ability flexible adaptation is the demand of the quick fast development of banking under the new situation, is particularly useful for the setting of banking industry to the enterprise-level data storage device.
Need to prove: for aforesaid each method embodiment; For simple description; So it all is expressed as a series of combination of actions; But those skilled in the art should know; The present invention is not subjected to the restriction of described sequence of movement; Because according to the present invention, some step can adopt other orders or carry out simultaneously.Secondly, those skilled in the art also should know, the embodiment described in the instructions all belongs to preferred embodiment, and related action and module might not be that the present invention is necessary.
In the above-described embodiments, the description of each embodiment is all emphasized particularly on different fields, do not have the part that details among certain embodiment, can be referring to the associated description of other embodiment.
One of ordinary skill in the art will appreciate that: all or part of step that realizes said method embodiment can be accomplished through the relevant hardware of programmed instruction; Aforesaid program can be stored in the computer read/write memory medium; This program the step that comprises said method embodiment when carrying out; And aforesaid storage medium comprises: various media that can be program code stored such as ROM, RAM, magnetic disc or CD.
What should illustrate at last is: above embodiment is only in order to illustrating technical scheme of the present invention, but not to its restriction; Although with reference to previous embodiment the present invention has been carried out detailed explanation, those of ordinary skill in the art is to be understood that: it still can be made amendment to the technical scheme that aforementioned each embodiment put down in writing, and perhaps part technical characterictic wherein is equal to replacement; And these are revised or replacement, do not make the spirit and scope of the essence disengaging various embodiments of the present invention technical scheme of relevant art scheme.

Claims (10)

1. a date storage method is characterized in that, comprising:
The memory controller of data storage device obtains data storage command;
The basal layer storage basic data of said memory controller controls data storage device;
The middle layer of said memory controller controls data storage device is extracted at least one and is used corresponding intermediate data and store middle summary information table into from the basic data of said basal layer;
The application layer of said memory controller controls data storage device is extracted the general combined data of using and is stored general summary information table into from the intermediate data in said middle layer, from the intermediate data in said middle layer and said general summary information table, extract the Data Mart data of using and store at least one application data fairground into.
2. method according to claim 1 is characterized in that, the basal layer storage basic data of said memory controller controls data storage device comprises:
Said memory controller controls protocol information table is stored at least a protocol number and protocol type code; Said memory controller controls is as the protocol number and the protocol type code of at least one type information table storage corresponding types of the sublist of protocol information table; Said memory controller controls is as the data of the corresponding agreement of at least one data table stores of the sublist of type information table;
And/or said memory controller controls attribute history lists is according to protocol type, the attribute information of at least one agreement of classification and storage.
3. method according to claim 1 and 2; It is characterized in that the middle layer of said memory controller controls data storage device is extracted the corresponding intermediate data of at least one application and stored middle summary information table into and comprises from the basic data of said basal layer:
The said middle layer of said memory controller controls is extracted the corresponding data of account levels summary information and is stored account levels summary information table into from the basic data of said basal layer;
And/or the said middle layer of said memory controller controls is extracted the corresponding data of voucher level summary information and is stored voucher summary information table into from the basic data of said basal layer;
And/or the said middle layer of said memory controller controls is extracted the corresponding data of receipt level summary information and is stored receipt summary information table into from the basic data of said basal layer;
And/or the said middle layer of said memory controller controls is extracted the corresponding data of customer deposit level summary information and is stored customer deposit summary information table into from the basic data of said basal layer;
And/or the said middle layer of said memory controller controls is extracted the corresponding data of customer lending level summary information and is stored customer lending summary information table into from the basic data of said basal layer.
4. method according to claim 1 and 2 is characterized in that, the middle layer of the said data storage device of said memory controller controls comprises said intermediate data storage to middle summary information table:
The major key of tables of data of basal layer that adopt to add prefix is as the major key of summary information table in the middle of said, or, adopt major key and the preset supplemental field of the tables of data of basal layer form said in the middle of the major key of summary information table;
And/or; Type according to the general character field in the tables of data of at least one basal layer; Confirm the type of this general character field of said middle summary information table; The type of the general character field in the tables of data of at least one basal layer not simultaneously, said in the middle of the type of this general character field of summary information table be variable type;
And/or the combination of Currency Type field and value type code field of tables of data of adopting basal layer is as the major key of summary information table in the middle of said, with the data-switching of different Currency Types in the tables of data of basal layer for specify Currency Type and store into said in the middle of the summary information table;
And/or, calculate the data of the attribute of deriving and store said middle summary information table into according to said basic data;
And/or, the said intermediate data in the middle of said in the summary information table storage preset time period.
5. method according to claim 1 and 2 is characterized in that,
The application layer of said memory controller controls data storage device also comprises after from the intermediate data in the basic data of said basal layer and said middle layer, extracting the general combined data of using: the application layer of the said data storage device of said memory controller controls is extracted the general combined data of application from the basic data of said basal layer;
The application layer of said memory controller controls data storage device also comprises after from the intermediate data in said middle layer and said general summary information table, extracting application data fairground data: the application layer of the said data storage device of said memory controller controls is extracted the Data Mart data of application from the basic data of said basal layer.
6. a data storage device is characterized in that, comprising: memory controller, basal layer, middle layer and application layer;
Memory controller obtains data storage command; Control basal layer storage basic data; The control middle layer is extracted at least one and is used corresponding intermediate data and store middle summary information table into from the basic data of said basal layer; The control application layer is extracted the general combined data of using and is stored general summary information table into from the intermediate data in said middle layer, from the intermediate data in said middle layer and said general summary information table, extract the Data Mart data of application and store at least one application data fairground into.
7. data storage device according to claim 6 is characterized in that,
Said basal layer specifically is used for the control according to said memory controller; Store at least a protocol number and protocol type code at the protocol information table; At protocol number and protocol type code, in data as at least one data table stores correspondence agreement of the sublist of type information table as at least one type information table storage corresponding types of the sublist of protocol information table;
And/or said basal layer specifically is used for the control according to said memory controller, at the attribute information of attribute history lists according at least one agreement of protocol type classification and storage.
8. according to claim 6 or 7 described data storage devices, it is characterized in that,
Said middle layer specifically is used for extracting the corresponding data of account levels summary information and storing account levels summary information table into from the basic data of said basal layer according to the control of said memory controller;
And/or said middle layer specifically is used for the control according to said memory controller, from the basic data of said basal layer, extracts the corresponding data of voucher level summary information and stores voucher summary information table into;
And/or said middle layer specifically is used for the control according to said memory controller, from the basic data of said basal layer, extracts the corresponding data of receipt level summary information and stores receipt summary information table into;
And/or said middle layer specifically is used for the control according to said memory controller, from the basic data of said basal layer, extracts the corresponding data of customer deposit level summary information and stores customer deposit summary information table into;
And/or said middle layer specifically is used for the control according to said memory controller, from the basic data of said basal layer, extracts the corresponding data of customer lending level summary information and stores customer lending summary information table into.
9. according to claim 6 or 7 described data storage devices, it is characterized in that,
Said middle layer specifically is used for the control according to said memory controller; The major key of the tables of data of the basal layer of employing interpolation prefix is as the major key of summary information table in the middle of said; Or, the major key of the major key of the tables of data of employing basal layer and the said middle summary information table of presetting of supplemental field composition;
And/or; Said middle layer specifically is used for the control according to said memory controller; Type according to the general character field in the tables of data of at least one basal layer; Confirm the type of this general character field of said middle summary information table; The type of the general character field in the tables of data of at least one basal layer not simultaneously, said in the middle of the type of this general character field of summary information table be variable type;
And/or; Said middle layer specifically is used for the control according to said memory controller; The combination of Currency Type field and value type code field of tables of data of adopting basal layer is as the major key of summary information table in the middle of said, with the data-switching of different Currency Types in the tables of data of basal layer for specify Currency Type and store into said in the middle of the summary information table;
And/or said middle layer specifically is used for the control according to said memory controller, calculates the data of the attribute of deriving and stores said middle summary information table into according to said basic data;
And/or said middle layer specifically is used for the control according to said memory controller, the said intermediate data in the middle of said in the summary information table storage preset time period.
10. according to claim 6 or 7 described data storage devices, it is characterized in that,
Said memory controller also is used for controlling general combined data and the Data Mart data of the application layer of said data storage device from the basic data extraction application of said basal layer;
The application layer of said data storage device also is used for the control according to said memory controller, from the basic data of said basal layer, extracts general combined data and the Data Mart data of using.
CN201110280416.XA 2011-09-20 2011-09-20 Data storage method and device Active CN102354277B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201110280416.XA CN102354277B (en) 2011-09-20 2011-09-20 Data storage method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201110280416.XA CN102354277B (en) 2011-09-20 2011-09-20 Data storage method and device

Publications (2)

Publication Number Publication Date
CN102354277A true CN102354277A (en) 2012-02-15
CN102354277B CN102354277B (en) 2014-07-09

Family

ID=45577844

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201110280416.XA Active CN102354277B (en) 2011-09-20 2011-09-20 Data storage method and device

Country Status (1)

Country Link
CN (1) CN102354277B (en)

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106156178A (en) * 2015-04-17 2016-11-23 阿里巴巴集团控股有限公司 A kind of data processing method and equipment
CN107016027A (en) * 2016-12-08 2017-08-04 阿里巴巴集团控股有限公司 The method and apparatus for realizing business information fast search
CN109634963A (en) * 2018-12-11 2019-04-16 泰康保险集团股份有限公司 Processing method, device and the readable storage medium storing program for executing of declaration form data
CN110569315A (en) * 2019-07-29 2019-12-13 北京创鑫旅程网络技术有限公司 Data processing method and device based on data warehouse
CN113067762A (en) * 2021-03-24 2021-07-02 重庆长安汽车股份有限公司 In-vehicle data recording and recorded data extraction method for automatic driving

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR100642824B1 (en) * 2003-11-06 2006-11-10 주식회사 신한은행 Method of bank transaction using tailored customer account and its system
US7275684B2 (en) * 2004-12-06 2007-10-02 Bank Of America Corporation Method and system for consolidating cash letters
CN101183986A (en) * 2007-11-26 2008-05-21 河北全通通信有限公司 Method for economized storage, construction ''green'' database
CN101702798A (en) * 2009-11-11 2010-05-05 南京联创科技集团股份有限公司 Design method of multi-service drive share frame model
CN101714273A (en) * 2009-05-26 2010-05-26 北京银丰新融科技开发有限公司 Rule engine-based method and system for monitoring exceptional service of bank

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR100642824B1 (en) * 2003-11-06 2006-11-10 주식회사 신한은행 Method of bank transaction using tailored customer account and its system
US7275684B2 (en) * 2004-12-06 2007-10-02 Bank Of America Corporation Method and system for consolidating cash letters
CN101183986A (en) * 2007-11-26 2008-05-21 河北全通通信有限公司 Method for economized storage, construction ''green'' database
CN101714273A (en) * 2009-05-26 2010-05-26 北京银丰新融科技开发有限公司 Rule engine-based method and system for monitoring exceptional service of bank
CN101702798A (en) * 2009-11-11 2010-05-05 南京联创科技集团股份有限公司 Design method of multi-service drive share frame model

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106156178A (en) * 2015-04-17 2016-11-23 阿里巴巴集团控股有限公司 A kind of data processing method and equipment
CN107016027A (en) * 2016-12-08 2017-08-04 阿里巴巴集团控股有限公司 The method and apparatus for realizing business information fast search
CN109634963A (en) * 2018-12-11 2019-04-16 泰康保险集团股份有限公司 Processing method, device and the readable storage medium storing program for executing of declaration form data
CN109634963B (en) * 2018-12-11 2021-01-26 泰康保险集团股份有限公司 Policy data processing method and device and readable storage medium
CN110569315A (en) * 2019-07-29 2019-12-13 北京创鑫旅程网络技术有限公司 Data processing method and device based on data warehouse
CN113067762A (en) * 2021-03-24 2021-07-02 重庆长安汽车股份有限公司 In-vehicle data recording and recorded data extraction method for automatic driving

Also Published As

Publication number Publication date
CN102354277B (en) 2014-07-09

Similar Documents

Publication Publication Date Title
Seabright The vanishing rouble: Barter networks and non-monetary transactions in post-Soviet societies
Maurer Payment: Forms and functions of value transfer in contemporary society
O’Dwyer Cache society: transactional records, electronic money, and cultural resistance
Pomfret Resource management and transition in Central Asia, Azerbaijan and Mongolia
Iriyadi et al. Financial Reporting for Micro Small and Medium Enterprises Towards Industrial Revolution Era 4.0
CN102354277B (en) Data storage method and device
Martin Too far ahead of its time: Barclays, Burroughs, and real-time banking
Li et al. Failure analysis of corporations with multiple hospitality businesses
Broby et al. FINTECH in Scotland: building a digital future for the financial sector
Wölfing et al. Cash management in transition: From cash management to cash process management
CN107292733A (en) A kind of household finance management information system
Delli Gatti et al. Breaking bad: supply chain disruptions in a streamlined agent-based model
JP6353612B1 (en) Management information system, method, and program
US20220222658A1 (en) Currency value management system and currency value management program
Norris Jr China foreign direct investment: Greenfield, mergers & acquisition, or joint-venture
Vu et al. Research on comparing Z-Score, O-Score and X-Score models in analyzing factors affecting financial risk in medical companies listed on Vietnam stock market
Dabrowski Macroeconomic Vulnerability, Monetary, and Fiscal Policies
Wandhöfer Financing models for SMEs in the age of disintermediation
Karanam et al. Leveraging the New Business Model: The Blockchain World of Banking
KARAÖMER The analysis of FinTech sector in Turkey
Leclaire Invited ArticleFiscal and monetary policy for difficult times: MMT solutions
Reichert Comarch EDI platform case study: The advanced electronic data interchange hub as a supply-chain performance booster
Nowell Hilferdings Finance Capital Versus Wal-Mart World: Disaggregating The Dollars Hegemony
UGLI et al. INCREASING THE COMPETITIVENESS OF BANKING SERVICES IN THE COUNTRY
Shayebr et al. Impact of Information Technology on Accounting Systems

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant