CN107239539A - A kind of user-defined m odel method based on relevant database - Google Patents
A kind of user-defined m odel method based on relevant database Download PDFInfo
- Publication number
- CN107239539A CN107239539A CN201710407098.6A CN201710407098A CN107239539A CN 107239539 A CN107239539 A CN 107239539A CN 201710407098 A CN201710407098 A CN 201710407098A CN 107239539 A CN107239539 A CN 107239539A
- Authority
- CN
- China
- Prior art keywords
- data
- analysis model
- odel
- data analysis
- user
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- 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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Abstract
The present invention discloses a kind of user-defined m odel method based on relevant database, is related to data processing technique, in database, the interpolation data table from data dictionary, basis of formation tables of data resource pool；Control point is explored, by continuously optimizing threshold parameter, the Data Analysis Model of Erecting and improving；The self-defined report on Data Analysis Model, realizes that various dimensions collect and detailed data inquiry.The present invention supports to write sql manually and automatically generate sql two ways to create analysis model, model can be issued as to publicly-owned, privately owned two types, multi-dimensional data analysis and detailed data query demand is met；Modeling requirement, constantly improve model library are collected available for data analysis system；Quick to meet business personnel's monitoring rules testing requirement, user-defined m odel demand effectively can carry out data monitoring, analysis, Zero-code quickly develops monitoring module and data sheet using data resource.
Description
Technical field
The present invention relates to data processing technique, specifically a kind of user-defined m odel side based on relevant database
Method.
Background technology
With the arrival in big data epoch, people more and more recognize importance of the data to enterprise.In this " number
According to i.e. assets " epoch, how to make full use of available data resource, carry out data analysis, mining data potential value, as enterprise
The problem of industry is in the urgent need to address.
The content of the invention
There is provided a kind of making by oneself based on relevant database for the demand and weak point that the present invention develops for current technology
Adopted modeling method and method.
A kind of user-defined m odel method based on relevant database of the present invention, solves what above-mentioned technical problem was used
Technical scheme is as follows：The user-defined m odel method based on relevant database, in database, is added from data dictionary
Tables of data, basis of formation tables of data resource pool；Explore control point, by continuously optimizing threshold parameter, Erecting and improving
Data Analysis Model；The self-defined report on Data Analysis Model, realizes that various dimensions collect and detailed data inquiry；
It, which implements process, includes：1）Basis of formation tables of data resource pool, 2）Create Data Analysis Model, 3）Create self-defined
Form.
It is preferred that, 1）Basis of formation tables of data resource pool
The interpolation data table from data dictionary, carries out table definition and row definition, basis of formation tables of data resource pool is self-defined builds
Mould opens tables of data access rights.
It is preferred that, 2）Create Data Analysis Model
Support to write sql manually and automatically generate sql two ways to create Data Analysis Model；Data Analysis Model is saved as
Middle table, is included to table resource pool；Data Analysis Model can be issued as to publicly-owned, privately owned two types.
It is preferred that, step 2）In, during using automatically generating sql modelings, by selecting tables of data, add condition of contact, choosing
Row are selected, filter condition, grouping field, the step of sort criteria six, system can automatically generate sql scripts.
It is preferred that, step 2）In, data are labelled according to business rule during modeling, the detailed data after labelling
Save as middle table, based on tables of data resource, for it is follow-up set up various dimensions and collect model do data supporting.
It is preferred that, 3）Create self-defined report
Based on Data Analysis Model, self-defined report can be created, supports aggregate query and detailed data to drill through；Can be by data
Analysis model includes unified model system, includes to model library.
A kind of user-defined m odel method and method based on relevant database of the present invention, have compared with prior art
Some beneficial effects are：User-defined m odel method of the present invention, supports to write sql manually and automatically generates the establishment of sql two ways
Model, can be issued as publicly-owned, privately owned two types by analysis model, meet multi-dimensional data analysis and detailed data inquires about need
Ask；Modeling requirement, constantly improve model library are collected available for data analysis system；It is quick to meet the test of business personnel's monitoring rules
Demand, user-defined m odel demand effectively can carry out data monitoring, analysis, Zero-code quickly develops monitoring mould using data resource
Block and data sheet.
Embodiment
For the object, technical solutions and advantages of the present invention are more clearly understood, below in conjunction with specific embodiment, to this hair
A kind of bright user-defined m odel method based on relevant database is further described.
User-defined m odel method of the present invention based on relevant database, in database, utilizes existing opening
Tables of data resource, Data Analysis Model is set up by user-defined m odel instrument；Self-defined analytical statement, meets multi-dimensional data point
Analysis and detailed data query demand；Querying condition can also be met simultaneously, show the unfixed form demand of field.
Embodiment：
User-defined m odel method based on relevant database described in the present embodiment, the interpolation data table from data dictionary is formed
Base data table resource pool, is that user-defined m odel opens tables of data access rights；Control point is explored, by continuously optimizing
Threshold parameter, the Data Analysis Model of Erecting and improving；The self-defined report on Data Analysis Model, realize various dimensions collect and
Detailed data is inquired about；
It, which implements process, includes：1）Basis of formation tables of data resource pool, 2）Create Data Analysis Model, 3）Create self-defined
Form, 4）
Wherein, 1）Basis of formation tables of data resource pool
The interpolation data table from data dictionary, carries out table definition and row definition, basis of formation tables of data resource pool is self-defined builds
Mould opens tables of data access rights.
2）Create Data Analysis Model
Support to write sql manually and automatically generate sql two ways to create Data Analysis Model；Data Analysis Model is saved as
Middle table, is included to table resource pool；Data Analysis Model can be issued as to publicly-owned, privately owned two types.
Step 2）In, during using automatically generating sql modelings, by selecting tables of data, add condition of contact, alternative column, mistake
Filter condition, grouping field, six steps of sort criteria, system can automatically generate sql scripts；
For the technical staff with sql bases data analysis mould is fast, accurately set up there is provided the mode for writing sql manually
Type.
Step 2）In, Data Analysis Model is saved as into middle table, included to table resource pool, complicated point is created for substep
Analyse model；Data are labelled according to business rule during modeling, the detailed data after labelling saves as middle table, as
Base data table resource, for it is follow-up set up various dimensions and collect model do data supporting.
Step 2）In, publicly-owned, privately owned two types can be issued as during model creation, publicly-owned model is all to possess self-defined
The user of modeling authority can check, for data sharing；Privately owned model only founder, which can check, to be used.
3）Create self-defined report
Based on Data Analysis Model, self-defined report can be created, supports aggregate query and detailed data to drill through；Can be by data
Analysis model includes unified model system, includes to model library.
Using the user-defined m odel method based on relational database described in the present embodiment, medical worker can utilize opening
Tables of data resource, oneself sets up Data Analysis Model, explores control point, by continual optimization threshold parameter, has set up
Kind Data Analysis Model；Querying condition can be met simultaneously, show the unfixed form demand of field.Quick satisfaction of the invention
Business personnel's monitoring rules testing requirement, user-defined m odel demand.
Above-mentioned embodiment is only the specific case of the present invention, and scope of patent protection of the invention includes but is not limited to
Above-mentioned embodiment, any person of an ordinary skill in the technical field that meet claims of the present invention and any
The appropriate change or replacement done to it, should all fall into the scope of patent protection of the present invention.
Claims (6)
1. a kind of user-defined m odel method based on relevant database, it is characterised in that in database, from data dictionary
Middle interpolation data table, basis of formation tables of data resource pool；Control point is explored, by continuously optimizing threshold parameter, is set up
Perfect Data Analysis Model；The self-defined report on Data Analysis Model, realizes that various dimensions collect and detailed data inquiry；
It, which implements process, includes：1）Basis of formation tables of data resource pool, 2）Create Data Analysis Model, 3）Create self-defined
Form.
2. a kind of user-defined m odel method based on relevant database according to claim 1, it is characterised in that 1）Formed
Base data table resource pool
The interpolation data table from data dictionary, carries out table definition and row definition, basis of formation tables of data resource pool is self-defined builds
Mould opens tables of data access rights.
3. a kind of user-defined m odel method based on relevant database according to claim 2, it is characterised in that 2）Wound
Build Data Analysis Model
Support to write sql manually and automatically generate sql two ways to create Data Analysis Model；Data Analysis Model is saved as
Middle table, is included to table resource pool；Data Analysis Model can be issued as to publicly-owned, privately owned two types.
4. a kind of user-defined m odel method based on relevant database according to claim 3, it is characterised in that step 2）
In, during using automatically generating sql modelings, by selecting tables of data, condition of contact is added, alternative column, filter condition is grouped word
Section, the step of sort criteria six, system can automatically generate sql scripts.
5. a kind of user-defined m odel method based on relevant database according to claim 3, it is characterised in that step 2）
In, data are labelled according to business rule during modeling, the detailed data after labelling saves as middle table, based on
Tables of data resource, for it is follow-up set up various dimensions and collect model do data supporting.
6. a kind of user-defined m odel method based on relevant database according to claim 1, it is characterised in that 3）Create
Self-defined report
Based on Data Analysis Model, self-defined report can be created, supports aggregate query and detailed data to drill through；Can be by data
Analysis model includes unified model system, includes to model library.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710407098.6A CN107239539A (en) | 2017-06-02 | 2017-06-02 | A kind of user-defined m odel method based on relevant database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710407098.6A CN107239539A (en) | 2017-06-02 | 2017-06-02 | A kind of user-defined m odel method based on relevant database |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107239539A true CN107239539A (en) | 2017-10-10 |
Family
ID=59985977
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710407098.6A Pending CN107239539A (en) | 2017-06-02 | 2017-06-02 | A kind of user-defined m odel method based on relevant database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107239539A (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109325020A (en) * | 2018-08-20 | 2019-02-12 | 中国平安人寿保险股份有限公司 | Small sample application method, device, computer equipment and storage medium |
| CN110851667A (en) * | 2019-09-25 | 2020-02-28 | 中国移动通信集团河南有限公司 | Integrated analysis method and tool for multi-source large data |
| CN110928903A (en) * | 2018-08-31 | 2020-03-27 | 阿里巴巴集团控股有限公司 | Data extraction method and device, equipment and storage medium |
| CN111061756A (en) * | 2019-10-16 | 2020-04-24 | 智慧足迹数据科技有限公司 | Data platform, data processing method and electronic equipment |
| CN111399838A (en) * | 2020-06-04 | 2020-07-10 | 成都四方伟业软件股份有限公司 | Data modeling method and device based on spark SQ L and materialized view |
| CN111782736A (en) * | 2020-07-20 | 2020-10-16 | 浪潮卓数大数据产业发展有限公司 | Data classification management method and system |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080126056A1 (en) * | 2006-11-29 | 2008-05-29 | American Express Travel Related Services Company, Inc. | System and method for managing simulation models |
| CN103984755A (en) * | 2014-05-28 | 2014-08-13 | 中国地质大学（北京） | Multidimensional model based oil and gas resource data key system implementation method and system |
| CN104240124A (en) * | 2014-09-05 | 2014-12-24 | 宁波和佳软件技术有限公司 | Rural financial service management system based on data warehouse technology and establishing method |
| CN106484855A (en) * | 2016-09-30 | 2017-03-08 | 广州特道信息科技有限公司 | A kind of big data concerning taxes intelligence analysis system |
-
2017
- 2017-06-02 CN CN201710407098.6A patent/CN107239539A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080126056A1 (en) * | 2006-11-29 | 2008-05-29 | American Express Travel Related Services Company, Inc. | System and method for managing simulation models |
| CN103984755A (en) * | 2014-05-28 | 2014-08-13 | 中国地质大学（北京） | Multidimensional model based oil and gas resource data key system implementation method and system |
| CN104240124A (en) * | 2014-09-05 | 2014-12-24 | 宁波和佳软件技术有限公司 | Rural financial service management system based on data warehouse technology and establishing method |
| CN106484855A (en) * | 2016-09-30 | 2017-03-08 | 广州特道信息科技有限公司 | A kind of big data concerning taxes intelligence analysis system |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109325020A (en) * | 2018-08-20 | 2019-02-12 | 中国平安人寿保险股份有限公司 | Small sample application method, device, computer equipment and storage medium |
| CN110928903A (en) * | 2018-08-31 | 2020-03-27 | 阿里巴巴集团控股有限公司 | Data extraction method and device, equipment and storage medium |
| CN110928903B (en) * | 2018-08-31 | 2024-03-15 | 阿里巴巴集团控股有限公司 | Data extraction method and device, equipment and storage medium |
| CN110851667A (en) * | 2019-09-25 | 2020-02-28 | 中国移动通信集团河南有限公司 | Integrated analysis method and tool for multi-source large data |
| CN110851667B (en) * | 2019-09-25 | 2023-05-30 | 中国移动通信集团河南有限公司 | Integration analysis method and tool for large amount of data of multiple sources |
| CN111061756A (en) * | 2019-10-16 | 2020-04-24 | 智慧足迹数据科技有限公司 | Data platform, data processing method and electronic equipment |
| CN111399838A (en) * | 2020-06-04 | 2020-07-10 | 成都四方伟业软件股份有限公司 | Data modeling method and device based on spark SQ L and materialized view |
| CN111782736A (en) * | 2020-07-20 | 2020-10-16 | 浪潮卓数大数据产业发展有限公司 | Data classification management method and system |
| CN111782736B (en) * | 2020-07-20 | 2022-07-26 | 浪潮卓数大数据产业发展有限公司 | Data classification management method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107239539A (en) | A kind of user-defined m odel method based on relevant database | |
| US11366829B2 (en) | System and method for analysis and management of data distribution in a distributed database environment | |
| CN103902653B (en) | A kind of method and apparatus for building data warehouse table genetic connection figure | |
| CN104899295B (en) | A kind of heterogeneous data source data relation analysis method | |
| CN110472068A (en) | Big data processing method, equipment and medium based on heterogeneous distributed knowledge mapping | |
| CN106709024A (en) | Data table source-tracing method and device based on consanguinity analysis | |
| CN107016019B (en) | Database index creation method and device | |
| CN106598862A (en) | SQL semantic extensibility-based performance diagnosis and optimization method | |
| CN111241129B (en) | Industrial production enterprise index data acquisition and calculation system | |
| CN106611053A (en) | Data cleaning and indexing method | |
| CN107622068A (en) | A kind of blog management method and device based on JSON forms | |
| CN102789487A (en) | Data query and retrieval processing device and data query and retrieval processing method | |
| CN108829651A (en) | A kind of method, apparatus of document treatment, terminal device and storage medium | |
| CN105677687A (en) | Data processing method and device | |
| CN108255852B (en) | SQL execution method and device | |
| CN104537561A (en) | Automatic economic activities classification device in organizing institution bar codes | |
| CN104731908A (en) | ETL-based data cleaning method | |
| Taleghani | Executive information systems development lifecycle | |
| CN104699752A (en) | Intellectual property inquiry system based on cloud database | |
| JP2007133624A (en) | Information management method and device using connection relation information | |
| CN106980617B (en) | Method and system for operating database based on JSON statement | |
| CN105718376A (en) | Method for establishing relations between bug, commit and related personnel | |
| CN110825744B (en) | Cluster environment-based air quality monitoring big data partition storage method | |
| US11263264B2 (en) | Management of graphs using secondary index vertices | |
| CN104699753A (en) | Intellectual property inquiry system based on cloud database |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20171010 |
|
| RJ01 | Rejection of invention patent application after publication |