CN105354213B - The method that XBRL financial report business models are established based on data point model - Google Patents
The method that XBRL financial report business models are established based on data point model Download PDFInfo
- Publication number
- CN105354213B CN105354213B CN201510618771.1A CN201510618771A CN105354213B CN 105354213 B CN105354213 B CN 105354213B CN 201510618771 A CN201510618771 A CN 201510618771A CN 105354213 B CN105354213 B CN 105354213B
- Authority
- CN
- China
- Prior art keywords
- data point
- row
- financial statement
- point model
- row field
- 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.)
- Active
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/31—Indexing; Data structures therefor; Storage structures
- G06F16/316—Indexing structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
- G06F16/212—Schema design and management with details for data modelling support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/31—Indexing; Data structures therefor; Storage structures
- G06F16/316—Indexing structures
- G06F16/328—Management therefor
Abstract
The present invention relates to data modeling technology.The present invention is to provide for a kind of method that XBRL financial report business models are established based on data point model, and business datum obscure in the financial report of numerous and complicated is translated as into accurate, logic and clear and definite information, its technical scheme can be summarized as：Financial statement is analyzed first, financial statement is split again and merges to obtain at least one fractionation form, and each fractionation form is analyzed using data point model concept, then data point model prototype is established, it is last to fill data point model prototype according to the analysis for splitting form, obtain XBRL financial report business models.The invention has the advantages that help to realize the definition of data structure, uniformity and continuity, suitable for establishing XBRL financial report business models.
Description
Technical field
The present invention relates to data modeling technology, the technology of XBRL financial report business models is more particularly to established.
Background technology
Data modeling refers to the abstract tissue to real world Various types of data, determines scope, data that database need to administer
Composition form etc. until changing into the process in real data storehouse.
Data point model is data-centered modeling method, had both expressed the content of data, and had expressed data again
Structure.In data point model, each data point is defined by basic item and latitude in financial report.The model can be considered that n is tieed up
Space, latitude are axle, and member is axial coordinate；Each data point has an accurate locus (specific [latitude] [member]
To combination) definition.
When obscure business datum is modeled in the financial report to numerous and complicated, how business datum is translated as
Accurately, logic, clear and definite information, maximumlly using data, the value of mining data, number is provided for enterprise diagnosis application
According to support, meets the problem of monitoring party uses the needs of of analysis to information, is currently in the urgent need to address.
The content of the invention
The invention aims to provide a kind of method that XBRL financial report business models are established based on data point model,
Business datum obscure in the financial report of numerous and complicated is translated as accurate, logic and clear and definite information.
The present invention solves its technical problem, and the technical scheme of use is to establish XBRL financial reports based on data point model
The method of business model, it is characterised in that comprise the following steps：
Step 1, financial statement is analyzed；
Step 2, financial statement is split and merges to obtain at least one fractionation form, and it is general using data point model
Read and each fractionation form is analyzed；
Step 3, establish data point model prototype；
Step 4, basis fill data point model prototype to the analysis for splitting form, obtain XBRL financial report business moulds
Type.
It is described analysis is carried out to financial statement to refer to specifically, in step 1：The purpose of the financial statement is specified, clearly should
Financial statement intersection item content, analyze hierarchical relationship each internal in row field and row field in the financial statement, analysis
Other outside support texts or form of every association, analyze relevant information implicit inside the financial statement in the financial statement
And support content.
Further, the described financial statement intersection item content refers to：Row field and row field in the financial statement
The cell content of common definition.
Specifically, step 2 comprises the following steps：
Step 21, former form is split according to stratigraphic classification possessed by row field and merges to obtain fractionation form,
If former form expresses the form concept of N number of dimensional model on being expert at, former form is split as N number of form from row, such as
There is the consistent still different row field of title of intension in fruit original form, then the consistent row field of intension is merged into one on being expert at
Row field；
Step 22, former form is split according to stratigraphic classification possessed by row field and merges to obtain fractionation form,
If former form expresses the form concept of N number of dimensional model on row, former form is split as N number of form from row, such as
There is the consistent still different row field of title of intension in fruit original form, then the consistent row field of intension is merged into one on row
Row field；
Step 23, using data point model concept to it is each fractionation form analyze.
Further, step 3 comprises the following steps：
Step 31, establish basic item element；
Step 32, establish dimension and members list；
Step 33, establish domain and hierarchical structure table；
Step 34, establish data point table.
Specifically, in step 31, the basic item element includes title, label, data type and time type.
Further, in step 32, the dimension and member column tableau format are title, label and type.
Specifically, in step 33, the domain and hierarchical structure tableau format are hierarchical structure sequence number, level and member name
Claim.
Further, in step 34, the data point table of establishing refers to：It is determined that the dimension corresponding to each available cell lattice
Degree and member value.
The invention has the advantages that in the present invention program, XBRL finance are established based on data point model by above-mentioned
The method of Report service model, the business datum during can the finance of numerous and complicated be included preferably use XBRL criteria for classifications
To represent, help to realize the definition of data structure, uniformity and continuity, contribute to regulator using multidimensional data and
Low-cost data exchange, storage and use are carried out, and greatly facilitates information user and carries out section, stripping and slicing formula from multiple dimensions
Interactive analysis excavate.
Embodiment
With reference to embodiment, technical scheme is described in detail.
The present invention's is established based on data point model in the method for XBRL financial report business models, first to financial statement
Analyzed, then financial statement is split and merges to obtain at least one fractionation form, and use data point model concept
Each fractionation form is analyzed, then establishes data point model prototype, data are filled in the last analysis according to splitting form
Point model prototype, obtain XBRL financial report business models.
Embodiment
The embodiment of the present invention is established based on data point model in the method for XBRL financial report business models, including following
Specific steps：
Step 1, financial statement is analyzed.
In this step, analysis is carried out to financial statement and referred to：The purpose for specifying the financial statement (is generally reflected at the finance
On statement heading, it embodies the essential information and data universal class of the financial statement), specify the financial statement intersection item
Content, hierarchical relationship (include internal implication relation) each internal in row field and row field in the financial statement is analyzed, divided
Other outside support texts or form (such as other correlation guides and reference explanation etc.) of items association in the financial statement are analysed,
Analyze relevant information implicit inside the financial statement and support content.Wherein, the financial statement intersection item content refers to：Should
Row field and the cell content of row field common definition in financial statement.
Step 2, financial statement is split and merges to obtain at least one fractionation form, and it is general using data point model
Read and each fractionation form is analyzed, specifically may comprise steps of：
Step 21, former form is split according to stratigraphic classification possessed by row field and merges to obtain fractionation form,
If former form expresses the form concept of N number of dimensional model on being expert at, former form is split as N number of form from row, such as
There is the consistent still different row field of title of intension in fruit original form, then the consistent row field of intension is merged into one on being expert at
Row field；
Step 22, former form is split according to stratigraphic classification possessed by row field and merges to obtain fractionation form,
If former form expresses the form concept of N number of dimensional model on row, former form is split as N number of form from row, such as
There is the consistent still different row field of title of intension in fruit original form, then the consistent row field of intension is merged into one on row
Row field；
Step 23, using data point model concept to it is each fractionation form analyze, here, data point model concept refers to
In a manner of " domain ", " dimension ", " member ", the implicit information included in field name need to be paid special attention to.
Step 3, data point model prototype is established, specifically may comprise steps of：
Step 31, basic item element is established, the basic item element includes title, label, data type and time
Type；
Step 32, dimension and members list are established, the dimension and member column tableau format are title, label and type；
Step 33, domain and hierarchical structure table are established, the domain and hierarchical structure tableau format are hierarchical structure sequence number, level
And member Name；
Step 34, data point table is established, the data point table of establishing refers to：It is determined that the dimension corresponding to each available cell lattice
Degree and member value.
Step 4, basis fill data point model prototype to the analysis for splitting form, obtain XBRL financial report business moulds
Type.
Concrete example is as follows：
Balance sheet in the financial report on December 31 in 2014 of conglomerate's company A, current assets RMB 5,800,
000 yuan, 3,080,000 yuan of money-capital RMB, 2,720,000 yuan of accounts receivable net value RMB, 0 yuan of stock.
1. a pair balance sheet is analyzed：
1) clear and definite form makes a report on purpose.The balance sheet discloses current assets situation in 2014, and data type is all goods
Coin type, point-type when time type is all.
2) clear and definite form intersection item content.Include current assets in the balance sheet, money-capital, accounts receivable is net
Value and stock.
3) analyze row field and row field each inside hierarchical relationship.Money-capital, accounts receivable net value, stock are stream
Subordinate's subject (hierarchical relationship) of dynamic assets；The numerical value of current assets is equal to money-capital, accounts receivable net value, stock three's number
It is worth sum.
4) the other outside support texts or form of analytical statement item association.Accounts receivable net value has a note form
Go to disclose specific mapping funds on account net value situation, wherein current assets, money-capital, accounts receivable net value and stock can refer to again
Corresponding accounting standard.
5) relevant information implicit inside analytical statement and support content.The disclosed body of the report is company A, the report period
Between be on December 31st, 2015, the unit of report is RMB￥.
2. a pair balance sheet is split and merges to obtain at least one fractionation form, and uses data point model concept
Each fractionation form is analyzed：
1) first balance sheet is split according to stratigraphic classification possessed by row field and merges to obtain and split form.
Current assets are first elements of the first order, and money-capital is first element of the second level, and accounts receivable net value is second
Second element of level, stock is the 3rd element of the second level.
2) balance sheet is being split according to stratigraphic classification possessed by row field and is merging to obtain fractionation form.
Due to the balance sheet that conglomerate generally there are the balance sheet of parent company's monomer and merge, parent company's monomer is defaulted as
Balance sheet, therefore understand there are two dimensions above in row according to the dimensional analysis of data point model, one be it is indivedual with
Merge dimension, specific member is indivedual；One is time dimension, and the specific time is on December 31st, 2014.
3. the analysis based on step 1 and step 2, establish the data point model prototype content of balance sheet
1) basic item element, element term CurrentAssets are established by taking current assets as an example, label provides for flowing
Production, data type is currency type, and debt-credit type is debit, and typical when time type is, affiliated table is balance sheet.
2) balance sheet is related to two dimensions, and one is indivedual and merges dimension, member include it is indivedual, merge, one
It is time dimension, member is on December 3rd, 2014.
3) according to the row level relation of balance sheet, establish field element individually and merge field element, the member in domain is comprising individual
Not, merge.
4) data point table is established, wherein data point current assets corresponding member under dimension that is indivedual and merging is
Not, corresponding member is on December 31st, 2014 under time dimension, the 30th article of the accounting standards for enterprises of reference；Increase is to data
The calculated relationship of point circulating fund, the numerical value of current assets be equal to money-capital, accounts receivable net value, stock three numerical value it
With.
4. filling data point model prototype according to the analysis for splitting form, XBRL financial report business models are obtained
For data point model prototype typically in the form of Excel, business expert can be with business people after establishing data point model prototype
Member and technical specialist link up together, fill data point model prototype according to the analysis for splitting form, obtain XBRL financial reports
Business model.
Claims (1)
1. the method for XBRL financial report business models is established based on data point model, it is characterised in that comprise the following steps：
Step 1, financial statement is analyzed, it is described analysis is carried out to financial statement to refer to：The purpose of the financial statement is specified,
The financial statement intersection item content is specified, grade each internal in row field and row field in the financial statement is analyzed and closes
System, other outside support texts or form of items association in the financial statement are analyzed, analyze what is implied inside the financial statement
Relevant information and support content, the described financial statement intersection item content refer to：Row field and row field in the financial statement
The cell content of common definition；
Step 2, financial statement is split and merges to obtain at least one fractionation form, and use data point model concept pair
Each form that splits is analyzed, and is specially：
Step 21, former form is split according to stratigraphic classification possessed by row field and merges to obtain fractionation form, if
Former form expresses the form concept of N number of dimensional model on being expert at, then former form is split as into N number of form from row, if former
There is the consistent still different row field of title of intension in form, then the consistent row field of intension is merged into a row word on being expert at
Section；
Step 22, former form is split according to stratigraphic classification possessed by row field and merges to obtain fractionation form, if
Former form expresses the form concept of N number of dimensional model on row, then former form is split as into N number of form from row；It is if former
There is the consistent still different row field of title of intension in form, then the consistent row field of intension is merged into a row word on row
Section；
Step 23, using data point model concept to it is each fractionation form analyze；
Step 3, data point model prototype is established, be specially：
Step 31, basic item element is established, the basic item element includes title, label, data type and time type；
Step 32, dimension and members list are established, the dimension and member column tableau format are title, label and type；
Step 33, establish domain and hierarchical structure table, the domain and hierarchical structure tableau format be hierarchical structure sequence number, level and into
Member's title；
Step 34, data point table is established, the data point table of establishing refers to：It is determined that dimension corresponding to each available cell lattice and
Member value；
Step 4, basis fill data point model prototype to the analysis for splitting form, obtain XBRL financial report business models.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510618771.1A CN105354213B (en) | 2015-09-24 | 2015-09-24 | The method that XBRL financial report business models are established based on data point model |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510618771.1A CN105354213B (en) | 2015-09-24 | 2015-09-24 | The method that XBRL financial report business models are established based on data point model |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105354213A CN105354213A (en) | 2016-02-24 |
| CN105354213B true CN105354213B (en) | 2017-11-24 |
Family
ID=55330186
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510618771.1A Active CN105354213B (en) | 2015-09-24 | 2015-09-24 | The method that XBRL financial report business models are established based on data point model |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105354213B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106844320B (en) * | 2016-12-27 | 2020-09-15 | 税友软件集团股份有限公司 | Financial statement integration method and equipment |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8099370B2 (en) * | 2007-04-03 | 2012-01-17 | Microsoft Corporation | System for financial documentation conversion |
| CN102508860A (en) * | 2011-09-29 | 2012-06-20 | 广州中浩控制技术有限公司 | Data mining method based on XBRL (extensible business reporting language) embodiment document |
| CN104731941B (en) * | 2015-03-31 | 2018-02-23 | 浪潮集团有限公司 | A kind of method based on XBRL technologies from unstructured financial report crawl data |
-
2015
- 2015-09-24 CN CN201510618771.1A patent/CN105354213B/en active Active
Also Published As
| Publication number | Publication date |
|---|---|
| CN105354213A (en) | 2016-02-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Okubo et al. | Asian fragmentation in the global financial crisis | |
| CN107256265A (en) | A kind of search-engine results data visualization methods of exhibiting and system | |
| CN110377696A (en) | A kind of commodity future news the analysis of public opinion method and system | |
| CN106372044B (en) | A method of based on the typing dimension XBRL report of report generation | |
| CN104965886B (en) | Data dimension processing method | |
| CN107704512A (en) | Financial product based on social data recommends method, electronic installation and medium | |
| US8768866B2 (en) | Computer-implemented systems and methods for forecasting and estimation using grid regression | |
| CN107657284A (en) | A kind of trade name sorting technique and system based on Semantic Similarity extension | |
| CN107122327A (en) | The method and training system of a kind of utilization training data training pattern | |
| CN104239660B (en) | Knowledge fusion method based on dynamic ontology under cloud manufacturing mode | |
| Plödt et al. | Estimating fiscal policy reaction functions: The role of model specification | |
| Teixeira et al. | Revenue diversification in public higher education: Comparing the university and polytechnic sectors | |
| CN104750771A (en) | Method and system for contextual data analysis using domain information | |
| EP3018595A1 (en) | System and method for reporting multiple objects in enterprise content management | |
| CN102122280A (en) | Method and system for intelligently extracting content object | |
| CN103631788A (en) | Vehicle manufacturing quality problem diagnosis system based on shared data base | |
| CN103208038B (en) | A kind of patent introduces the computing method of predicted value | |
| TWI690808B (en) | Data reorganization method and device | |
| CN107797933A (en) | Generate the method and device of analog message | |
| Devadason | Reorganization of Intra‐ASEAN 5 Trade Flows: The ‘China Factor’ | |
| Ghosh | Inbound Australian tourism demand from Asia: a panel gravity model | |
| CN105354213B (en) | The method that XBRL financial report business models are established based on data point model | |
| CN102819542A (en) | Method and device for presenting instance documents | |
| Pianta | The impact of the pandemic on industries: A conceptual map and key processes | |
| CN105550892A (en) | On-line member gender recognition method and system, and information recommendation system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |