CN103853830B - A kind of cost data for supporting more cost objective types opens the design method of data source - Google Patents
A kind of cost data for supporting more cost objective types opens the design method of data source Download PDFInfo
- Publication number
- CN103853830B CN103853830B CN201410084840.0A CN201410084840A CN103853830B CN 103853830 B CN103853830 B CN 103853830B CN 201410084840 A CN201410084840 A CN 201410084840A CN 103853830 B CN103853830 B CN 103853830B
- Authority
- CN
- China
- Prior art keywords
- cost
- data
- data source
- cost data
- opens
- 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
- 238000000034 method Methods 0.000 title claims abstract description 21
- 238000013461 design Methods 0.000 title claims abstract description 14
- 239000000463 material Substances 0.000 claims abstract description 7
- 238000012423 maintenance Methods 0.000 claims description 7
- 230000008569 process Effects 0.000 claims description 6
- 241001269238 Data Species 0.000 claims description 4
- 230000015572 biosynthetic process Effects 0.000 claims description 2
- 238000011160 research Methods 0.000 claims description 2
- 238000003860 storage Methods 0.000 claims description 2
- 239000000284 extract Substances 0.000 abstract description 3
- 230000006870 function Effects 0.000 description 6
- 238000013480 data collection Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000014759 maintenance of location Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Stored Programmes (AREA)
Abstract
The present invention relates to the design method technical field that cost data opens data source, more particularly to a kind of cost data for supporting more cost objective types opens the design method of data source.A kind of cost data for supporting more cost objective types of the present invention opens the design method of data source, it extracts cost objective, expense item, Cost Driver, the statistical rules of material consumption and other places being connected with perimeter systems, do the data source configuration feature that paired foreground user opens, can making cost accounting software function, cost of implementation adjusts the hardware and software platform of software independent of specific business management software.
Description
Technical field
It is more particularly to a kind of to support more costs the present invention relates to the design method technical field that cost data opens data source
The cost data of object type opens the design method of data source.
Background technology
Traditional cost management ideas on software design is essentially all to rely on specific integrating enterprise management software, hard to compile
All kinds of specific dictionaries and document of code identification integrated software, such as assert, " material dictionary " " engineering project " is used as specific cost
Object assert that " material requistion " " depreciation of fixed assets " " granting of wage emolument " etc. for specific expense amount incurred, is assert and " produced in workshop
Amount " " workshop man-hour " etc. is specific Cost Driver etc., realizes and ossifys, it is difficult to extend.
Integrated application software platformization is prevailing now, and quickly develop in list, flow configuration etc. does well, but
Be showed when realizing similar cost management data mart modeling class software function it is weak, in addition, the quick exploitation characteristic of platform is instead
The problem of traditional cost management design method ossifys is highlighted, quickly " expense list is recorded for exploitation one for example, user can utilize platform
Enter " function, but the cost data Statistic Source for how being included cost management becomes difficulty.
The content of the invention
In order to solve problem of the prior art, the present invention provides a kind of cost datas for supporting more cost objective types to open
Put the design method of data source, by cost objective, expense item, Cost Driver, material consumption statistical rules and other with
The place of perimeter systems linking extracts, and does the data source configuration feature that paired foreground user opens, cost accounting can be made soft
Part function adjusts the hardware and software platform of software independent of specific business management software, cost of implementation.
The technical solution adopted in the present invention is as follows：
A kind of cost data for supporting more cost objective types opens the design method of data source, comprises the following steps：
A, cost object type table is established, realizes the maintenance process of data table data；
B, cost data source group table is established, realizes the maintenance process of these data table datas；
C, when cost data is fetched, automatic cost pool data is realized in the definition of parsing cost data source.
Cost objective type list is a dictionary table, for storing and distinguishing the class of the cost objective to be adjusted of cost software
Type；The cost data source group table is one group of tables of data for describing cost data source, different cost objective type storages
Each different cost data data source, each data source are the complete database data retrieval languages that combination represents
Sentence, sentence implementing result collection is by depending on doing effective cost data data.
Cost data source group table represents complete data retrieval language according to cost data three sublists of data source point, combination
Sentence：
Cost data source table one, definition retrieval From clause's content of sentence and Where clause's content；
Cost data source table two, Join clause's content of definition retrieval sentence, including contingency table and Correlation Criteria content；
Which Column Properties cost data source table three, definition retrieval sentence have.
Cost data source table one can distinguish the content of dataset representation, and cost data source table one has " affiliated type " word
" cost objective ", " Cost Driver ", " expense item ", " material consumption " four options are enumerated in section, drop-down, which mark data collection is
Kind cost data.
The Column Properties of cost data source table three are divided to two classes：
A, searching attribute, the component of Select clause, content are exactly expected data research result collection；
B, constrained attributes, with reference to the part collected in scene formation where clause, for filter result collection.
The advantageous effect that technical solution provided by the invention is brought is：
A kind of cost data for supporting more cost objective types of the present invention opens the design method of data source, by cost
Object, expense item, Cost Driver, the statistical rules of material consumption and other places being connected with perimeter systems extract,
The data source configuration feature that paired foreground user opens is done, cost accounting software function can be made independent of specific business administration
Software, cost of implementation adjust the hardware and software platform of software.
Specific embodiment
To make the object, technical solutions and advantages of the present invention clearer, below in conjunction with specific embodiment to the present invention
Embodiment is described in further detail.
Embodiment one
The present embodiment is realized in the following manner：
1st, cost object type table is established, realizes the maintenance process of data table data.Such as the following table 1：
2nd, cost data source group table is established, realizes the maintenance process of these data table datas.
To ensure that cost data source data can be parsed into correctly SQL statement when realizing data maintenance, cost data
Acquisition seeks to return to desired cost data result set by performing these SQL statements.Such as following table 2- tables 4.
Wherein, row, which define, will combine the Column Properties that cost accounting requires prefabricated system to need in table.
When cost data is fetched, automatic cost pool data is realized in the definition of parsing cost data source.
Specifically used method is as follows：
1st, operating cost object type definitions complete the definition of the object type for the cost accounting of being carried out；
2nd, operating cost data source definitions, according to practical business environment, deployment cost object, Cost Driver, expense item
Wait the data source definitions of Cost Drivers；
Cost data is completed in the business functions such as the 3rd, operating cost object collects, Cost Driver collects, the configuration of trigger data source
Data access；
4th, the cost data data that cost accounting software processing obtains, other functions of completion cost software.
The foregoing is merely presently preferred embodiments of the present invention, is not intended to limit the invention, it is all the present invention spirit and
Within principle, any modifications, equivalent replacements and improvements are made should all be included in the protection scope of the present invention.
Claims (3)
1. a kind of cost data for supporting more cost objective types opens the design method of data source, comprise the following steps：
A, cost object type table is established, realizes the maintenance process of data table data；
B, cost data source group table is established, realizes the maintenance process of these data table datas；
C, when cost data is fetched, automatic cost pool data is realized in the definition of parsing cost data source；
The cost objective type list is a dictionary table, for storing and distinguishing the cost objective to be adjusted of cost software
Type；The cost data source group table is one group of tables of data for describing cost data source, and different cost objective types are deposited
The respective different cost data data source of storage, each data source are the complete database data retrievals that combination represents
Sentence, sentence implementing result collection are considered effective cost data data；
The cost data source group table represents complete data retrieval language according to cost data three sublists of data source point, combination
Sentence：
Cost data source table one, definition retrieval From clause's content of sentence and Where clause's content；
Cost data source table two, Join clause's content of definition retrieval sentence, including contingency table and Correlation Criteria content；
Which Column Properties cost data source table three, definition retrieval sentence have.
2. a kind of cost data for supporting more cost objective types according to claim 1 opens the design side of data source
Method, which is characterized in that the cost data source table one can distinguish the content of dataset representation, and cost data source table one has
" cost objective ", " Cost Driver ", " expense item ", " material consumption " four options are enumerated in " affiliated type " field, drop-down, are marked
Know which kind of cost data data set is.
3. a kind of cost data for supporting more cost objective types according to claim 2 opens the design side of data source
Method, which is characterized in that the Column Properties of the cost data source table three are divided to two classes：
A, searching attribute, the component of Select clause, content are exactly expected data research result collection；
B, constrained attributes, with reference to the part collected in scene formation where clause, for filter result collection.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410084840.0A CN103853830B (en) | 2014-03-10 | 2014-03-10 | A kind of cost data for supporting more cost objective types opens the design method of data source |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410084840.0A CN103853830B (en) | 2014-03-10 | 2014-03-10 | A kind of cost data for supporting more cost objective types opens the design method of data source |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103853830A CN103853830A (en) | 2014-06-11 |
| CN103853830B true CN103853830B (en) | 2018-05-18 |
Family
ID=50861485
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410084840.0A Active CN103853830B (en) | 2014-03-10 | 2014-03-10 | A kind of cost data for supporting more cost objective types opens the design method of data source |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103853830B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106886535A (en) * | 2015-12-16 | 2017-06-23 | 大唐软件技术股份有限公司 | A kind of data pick-up method and apparatus for being adapted to multiple data sources |
| CN108509491B (en) * | 2018-02-12 | 2021-10-15 | 阿方提法律咨询（上海）有限公司 | Enterprise due diligence data processing system and method |
| CN109325017B (en) * | 2018-10-25 | 2022-03-04 | 中国辐射防护研究院 | Database design method of radionuclide migration diffusion numerical simulation system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1512412A (en) * | 2002-12-28 | 2004-07-14 | 鸿富锦精密工业（深圳）有限公司 | Product added value cost integrating system and method |
| CN1877563A (en) * | 2006-07-06 | 2006-12-13 | 北京北大方正电子有限公司 | Report form defining method and system |
| CN101930443A (en) * | 2009-06-22 | 2010-12-29 | 金蝶软件（中国）有限公司 | Data service system and data service realization method |
| CN103345484A (en) * | 2013-06-21 | 2013-10-09 | 中国工商银行股份有限公司 | Report form processing system based on dynamic domain and method |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110307281A1 (en) * | 2010-06-11 | 2011-12-15 | Satterfield & Pontikes Construction, Inc. | Model inventory manager |
-
2014
- 2014-03-10 CN CN201410084840.0A patent/CN103853830B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1512412A (en) * | 2002-12-28 | 2004-07-14 | 鸿富锦精密工业（深圳）有限公司 | Product added value cost integrating system and method |
| CN1877563A (en) * | 2006-07-06 | 2006-12-13 | 北京北大方正电子有限公司 | Report form defining method and system |
| CN101930443A (en) * | 2009-06-22 | 2010-12-29 | 金蝶软件（中国）有限公司 | Data service system and data service realization method |
| CN103345484A (en) * | 2013-06-21 | 2013-10-09 | 中国工商银行股份有限公司 | Report form processing system based on dynamic domain and method |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103853830A (en) | 2014-06-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106528532B (en) | Text error correction method, device and terminal | |
| Kuznetsova et al. | Treetalk: Composition and compression of trees for image descriptions | |
| Schmitz | Inducing ontology from flickr tags | |
| CN102982076B (en) | Based on the various dimensions content mask method in semantic label storehouse | |
| CN107609052A (en) | A kind of generation method and device of the domain knowledge collection of illustrative plates based on semantic triangle | |
| CN109376352B (en) | Patent text modeling method based on word2vec and semantic similarity | |
| CN111143479A (en) | Knowledge graph relation extraction and REST service visualization fusion method based on DBSCAN clustering algorithm | |
| CN108984518A (en) | A kind of file classification method towards judgement document | |
| CN102054029A (en) | Figure information disambiguation treatment method based on social network and name context | |
| CN105938495A (en) | Entity relationship recognition method and apparatus | |
| CN110597870A (en) | Enterprise relation mining method | |
| CN105608232B (en) | A kind of bug knowledge modeling method based on graphic data base | |
| CN103646032A (en) | Database query method based on body and restricted natural language processing | |
| CN103955703A (en) | Medical image disease classification method based on naive Bayes | |
| Gast et al. | The areal factor in lexical typology | |
| CN105095222B (en) | Uniterm replacement method, searching method and device | |
| CN106503102A (en) | A kind of search engine formula audit analysis method | |
| CN103853830B (en) | A kind of cost data for supporting more cost objective types opens the design method of data source | |
| CN105095436B (en) | Data source data method for automatic modeling | |
| CN101697164B (en) | Method, system and device for extracting information on traditional medicament patent documents | |
| CN104346331A (en) | Retrieval method and system for XML database | |
| CN106776695A (en) | The method for realizing the automatic identification of secretarial document value | |
| CN104281565A (en) | Semantic dictionary constructing method and device | |
| CN104216979A (en) | Chinese technology patent automatic classification system and method for patent classification by using system | |
| US10353927B2 (en) | Categorizing columns in a data table |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information |
Address after: 250100 Ji'nan high tech Zone, Shandong, No. 1036 wave road Applicant after: Langchao General Software Co., Ltd Address before: 250101 Shandong Province, Ji'nan City hi tech Development Zone, Nga Road No. 1036 Applicant before: Shandong Universal Software Co., Ltd., Langchao Group Corp. |
|
| CB02 | Change of applicant information | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |