CN107368605A - A kind of dynamic modelling method based on chart database - Google Patents
A kind of dynamic modelling method based on chart database Download PDFInfo
- Publication number
- CN107368605A CN107368605A CN201710639323.9A CN201710639323A CN107368605A CN 107368605 A CN107368605 A CN 107368605A CN 201710639323 A CN201710639323 A CN 201710639323A CN 107368605 A CN107368605 A CN 107368605A
- Authority
- CN
- China
- Prior art keywords
- chart database
- information
- model
- configuration information
- database
- 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
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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—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
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)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention discloses a kind of Modeling Method of Dynamic Data based on chart database, including, S100：The model configuration information set according to user, generate chart database initialization information；And according to the chart database initialization information, generate the chart database graph structure of blank；S200：The model configuration information set according to user, generate source data filter information；And according to the source data filter information, source data is screened；S300：By in the chart database graph structure of blank described in the source data steps for importing S100 through being filtered out in step S200, chart database is formed.This method supports user according to business demand, flexible configuration setting is carried out to entities/events/relation in diagram data/query function model information, and according to the model configuration information of user's setting, complete establishment, storage and data query, the application of chart database, greatly simplify establishment and the application program of chart database, and the separation of system and business is realized, enhance the ease for use and versatility of chart database.
Description
Technical field
The present invention relates to big data processing technology field, more particularly to a kind of dynamic modelling method based on chart database.
Background technology
Chart database is a kind of non-relational database, the relation information between its Graphics Application theory storage entity.Institute
Some data are stored in the form of node (Point) and side (Edge), and each node represents present in real world " entity ", often
" relation " of the bar side between entity and entity.Generally, chart database stores the pass being made up of several nodes and side
It is network.For relevant database, chart database, can be by a large amount of structural datas because storage form is simple
It is stored under flexible network structure, realizes the functions such as a large amount of storages and the Flexible Query of data, is the current big data epoch
Under the most frequently used data system.
But in actual applications, chart database needs and application system combination competence exertion self-value.Different business
Application scenarios, the storage and presentation of data vary.According to type of the summit with side, attribute difference, chart database is being created
When need chart database build in the script of storehouse customize write；According to different entity and relation, it is necessary to different chart databases
Query statement is coupling in application system, causes application system is high to couple, development efficiency is low.
And the form of chart database storage is summit and side, entity and relation in real world is correspond to, wherein scheming
Relation storage in database is complicated various, when needing to inquire about the physical relationship of related entities in specific operation system, one
As need in the script of storehouse, input standard, tediously long specialized query sentence carry out dissection from level to level from the network of personal connections of complexity
Formula is inquired about and obtained, and not only requires high to the professional knowledge of user, and query statement is numerous and diverse, reduce further chart database
Development and application efficiency under different business scene.
The content of the invention
It is an object of the invention to overcome the above-mentioned deficiency in the presence of prior art, there is provided a kind of to facilitate user to figure number
According to the dynamic modelling method of storehouse data storage and query.This method is defined in chart database and pushed up by the foundation of data model
Vertex type and attribute, the type on side and attribute, relevant inquiring sentence so that the storage of data in chart database, and it is corresponding
Data query can be carried out directly according to the predefined model configuration information of user, greatly simplifie the establishment of chart database with
Application program, so as to improve the ease for use and versatility of chart database application, and realize to business in chart database and system
Separation, reduce the degree of coupling of chart database and application system, further improve the development and application efficiency of dynamic chart database.
In order to realize foregoing invention purpose, the invention provides following technical scheme：
A kind of dynamic modelling method based on chart database, its key step include：
S100：The model configuration information set according to user, generate chart database initialization information；And according to the figure number
According to library initialization information, the diagram data graph structure of blank is generated；
S200：The model configuration information set according to user, generate source data filter information；And sieved according to the source data
Information is selected, source data is screened；
S300：By the diagram data graph structure of blank described in the source data steps for importing S100 through being filtered out in step S200
In, form chart database.
Wherein, the step S100 is mainly comprised the following steps：
S110:User passes through model configuration interface, setting model configuration information；Wherein, the model configuration information includes
The physical model configuration information of vertex correspondence in chart database, and relational model configuration information corresponding to side in chart database；
The setting of the model configuration information, is specifically included again：S111：Physical model configuration information is set, and is specifically included to entity mould
The type and attribute information of type carry out configuration setting；S112：Relational model configuration information is set, and is specifically included to relational model
Type, attribute, and entity information associated by relation carry out configuration setting；
S120：The model configuration information that user in S110 steps is set, configuration database is saved in by data transfer
In；
S130：Chart database alternation of bed reading model configuration information from the configuration database, at the beginning of generating chart database
Beginningization information；
S140：Chart database alternation of bed creates corresponding summit and side, so as to generate according to chart database initialization information
The chart database graph structure of blank.
Wherein：Model configuration interface, configuration database and chart database alternation of bed described in the step, i.e. composition are originally
Dynamic modeling system in invention dynamic modelling method.Heretofore described blank sheet database diagram structure, analogy relation type
Table structure in database, refer specifically to be according to user setting model configuration information generation blank summit and side, be used for
The source data being adapted with the model information in each summit and side is stored, so as to form diagram data.
The step S200 specifically comprises the following steps：
S210：Data collecting system obtains the model configuration information of user's setting from configuration database, generates source data
Filter information；
S220：Data collecting system filters out from external source data according to source data filter information and meets model configuration
The source data of information.
The step S300 specifically comprises the following steps：
S310：The source data that data collecting system will filter out, be converted to chart database storage format；
S320：Source data after changing saving format, comparison model configuration information are directed respectively into sky by data collecting system
Storage location is corresponded in white chart database graph structure, forms chart database.
According to above-mentioned dynamic modelling method, user is only needed in model configuration interface, according to operation system demand, specific aim
Configuration setting is carried out to the relational model and entity model information of side in diagram data and vertex correspondence, and according to the mould of user's setting
Type configuration information completes the establishment of chart database and the screening and storage of source data, greatly simplify diagram data and creates program, carries
The high ease for use of chart database.
Further optimize, the setting of model configuration information, also comprises the following steps in the step S110：
S113：Event model configuration information is set, and the relation of entity behavior event will be represented in relational model as independent
Model carries out configuration setting, and the event model configuration information specifically includes event model type, attribute, and event ownership is in fact
Body information.
Due to the relation in the practical application of chart database, being often not only concerned only between entity and entity, Er Qieguan
Noting event (i.e. what entity done) and different entities caused by entity, (two people are by bus independent by the relation of event establishment
Event, but two people taken same order of classes or grades at school car just establish association colleague relation), so, in one kind of the present invention
In dynamic modelling method based on chart database, by " event " relation of presentation-entity behavior be abstracted as side by side with " entity " and
The independent model type of " relation " carries out configuration setting, and is stored in configuration database, diagram data is more nearly actual answer
With scene, be advantageous to further development and utilization of the chart database in lower floor's different business systems.
Based on same inventive concept, the present invention also provides a kind of dynamic queries modeling method based on chart database, described
Dynamic queries modeling method mainly comprises the steps of：
S400：Chart database by the use of the above-mentioned method generation based on chart database dynamic modeling is used as inquiry modeling pair
As, and query function modeling is carried out in same configuration database；
S410：Query function models：Physical model query statement, event model query statement and relational model are looked into respectively
Ask sentence and carry out function modelling definition, be saved in the configuration database；
S420：Query function is transferred：Data application system obtains the inquiry of corresponding model from the configuration database
Function, the query function can be directly used for the interactive query with chart database；
S430:Data application system obtains corresponding data information using query function from chart database.
Using according to the chart database that heretofore described dynamic modelling method creates as query function dynamic modeling object,
Physical model, event model and the relational model query function set respectively to user in chart database is modeled definition, and
It is pre-stored in the configuration database, is easy to the application system of lower floor's chart database directly to be transferred accordingly from configuration database
The query function of model, is applied in the interactive query of chart database.
Compared with prior art, beneficial effects of the present invention：
1. in present method invention, by establishing dynamic modeling system (that is, the model configuration interface suitable for chart database
+ configuration database+chart database alternation of bed), under the transfer effect of the dynamic modeling system, user only need to configure boundary in model
Corresponding model configuration information is set on face, you can complete the establishment of chart database, and directly quote and prestored in configuration database
Respective queries sentence be can be achieved in chart database corresponding information carry out specific aim inquiry, greatly simplify chart database
Establishment program and query steps, reduce the technical difficulty of associative operation, improve the ease for use of chart database；
2. according to the modeling method provided by the invention based on chart database, under different business background demand, user is only
Configuration setting need to be carried out by choosing different entities/events/relational models in the flexibility of model configuration interface, and in diagram data
The transfer effect of alternation of bed, realizes the quick establishment to chart database, has further expanded the suitable application area of diagram data；
3. in the methods of the invention by the configuration database of dynamic modeling system by the " thing of presentation-entity behavior
Part " relation is abstracted as the independent model type with " entity " and " relation " side by side, and sets up corresponding inquiry for all kinds of " events "
Sentence, so that the application of chart database more conforms to business usage scenario, improve the versatility of chart database；
4. the inventive method is in configuration database to entities/events/relation/query function model information by setting,
Make chart database upstream (collection, storage) according to model configuration information storage into chart database, chart database downstream (inquiry,
Using) according to query function pattern query data.Upstream and downstream all need not excessively be paid close attention to be interacted with chart database, reduces coupling
Degree, being separated from each other for business and system is realized, further increases the development and application efficiency of chart database.
Brief description of the drawings：
Fig. 1 is the dynamic modelling method step of the present invention based on chart database；
Fig. 2 is that dynamic modeling system of the present invention interacts schematic diagram with external system；
Fig. 3 is the blank sheet database diagram structural representation created according to model configuration information in embodiment 1；
Embodiment
With reference to test example and embodiment, the present invention is described in further detail.But this should not be understood
Following embodiment is only limitted to for the scope of the above-mentioned theme of the present invention, it is all that this is belonged to based on the technology that present invention is realized
The scope of invention.
Embodiment 1
According to a kind of dynamic modelling method based on chart database of the present invention, blank sheet number in wherein step S100
According to the formation of library template, complete as follows：
S110：User in web model configuration interface, set entities/events/relational model type as shown in Table 1 and
Attribute configuration information；
1 entities/events of form/relational model table
S120：Above-mentioned entities/events/relational model type and attribute configuration information, mysql is saved in by data transfer
In configuration database；
S130：Chart database alternation of bed obtains above-mentioned entities/events/relational model type from mysql configuration databases
And attribute configuration information, generate chart database initialization information；
S140：Chart database initialization information is sent to Java Gremlin standard interfaces (such as by chart database alternation of bed
Shown in form 2) and excite chart database standard Gremlin to create program, operation chart database creates corresponding summit and side, raw
Into the chart database graph structure (as shown in Figure 3) of blank.
The standard Java Gremlin interfaces of form 2
Source Data Acquisition and screening described in step S200, are completed especially by following steps：
S210：Data collecting system obtains the model configuration information in form 1 from mysql configuration databases, generates source
Data screening information；
S220：Data collecting system filters out according to the model configuration information in form 1 from source database meets model
The source data of configuration information.
Step S300 specifically comprises the following steps：
S310：The source data that data collecting system will filter out, be converted to chart database storage format；
S320：Data collecting system configures the source data after changing saving format, control entities/events/relational model
Information, which is directed respectively into blank sheet database diagram structure, corresponds to storage location, forms chart database.
Embodiment 2
Based on same inventive concept and same dynamic modeling system, the present invention also provides a kind of dynamic based on chart database
Modeling method is inquired about, the dynamic queries modeling method mainly comprises the steps of：
S400：It is inquiry modeling object from the chart database formed in S320 steps；
S410：Letter is carried out to physical model query statement, event model query statement and relational model query statement respectively
Number modeling definition, is saved in mysql configuration databases.Function modelling definition need to rely on entities/events/relation dynamic
The established model of modeling, type and attribute in entities/events/relationship modeling be parameter in function modelling definition statement and
Variable.Example is as shown in table 3, and the type person in entity (people) modeling, attribute (card_id, name, age) is all entity
Query function sentence define in part；
The query function of form 3 models the relation with solid modelling
S420：Data application system obtains query function from mysql configuration databases；
S430：Data application system obtains the information such as entities/events/relation using query function from chart database.With
Exemplified by form 4, Data application system calls queryEntityRide function interfaces from mysql configuration databases, can be used for
It is connected with chart database java routine interfaces, so as to obtain the entity for having the relation of colleague in some time range with certain entity
Information.
The function model table of form 4
Embodiment 3
Below, we are based on diagram data specifically so that information in public security organs studies and judges system business background as an example by of the present invention
Dynamic modelling method and dynamic queries modeling method connected applications briefing based on chart database it is as follows：
Information in public security organs, which studies and judges system, needs collect intelligence data, and carries out data analysis and information by visual mode
Study and judge, effective support is provided for merit detection.The information in public security organs studies and judges the main business workflow of system:Data acquisition --->
Data storage --->Data study and judge, and/analysis/inquires about.
1. data acquisition:Information in public security organs needs collector's information bank, Internet bar's identity card registration record, the public transport (people
Boat, train etc.) going on a journey records, hotel accommodations register information, the information such as real name message registration.During dynamic modeling as required
The data of collection establish entities/events/relational model configuration information, as shown in Table 5；The process of data acquisition is exactly according to this
Process of the model configuration information acquired data storage to chart database.
2. data study and judge, and/analysis/inquires about：Public security user needs to carry out information based on the data in chart database to study and judge point
Analysis, directly or indirectly incidence relation between analysis personnel.For example whether Mr. Wang and Li go together whether nearest January, Zhang
Whether certain crosses net in same Internet bar with height.Using the function model configuration information set in modeling process, data study and judge/point
Analysis/inquiry directly utilizes function Query Result from chart database, and the incidence relation between analysis suspect provides foundation, such as
Shown in form 6.The police criminal detection of form 5 studies and judges system entity/event/relational model
The police criminal detection of form 6 studies and judges system queries function model
Claims (8)
1. a kind of dynamic modelling method based on chart database, it is characterised in that this method mainly comprises the following steps：
S100：The model configuration information set according to user, generate chart database initialization information；And according to the chart database
Initialization information, generate the diagram data graph structure of blank；
S200：The model configuration information set according to user, generate source data filter information；And screen and believe according to the source data
Breath, is screened to source data；
S300：By in the diagram data graph structure of blank described in the source data steps for importing S100 through being filtered out in step S200,
Form chart database.
A kind of 2. dynamic modelling method based on chart database according to claim 1, it is characterised in that the step
S100 is mainly comprised the following steps：
S110：User passes through model configuration interface, setting model configuration information；Wherein, the model configuration information includes figure number
According to the physical model configuration information of vertex correspondence in storehouse, and relational model configuration information corresponding to side in chart database；
S120：The model configuration information is saved in configuration database；
S130：Chart database alternation of bed reading model configuration information from the configuration database, generation chart database initialization
Information；
S140：Chart database alternation of bed creates corresponding summit and side, so as to generate blank according to chart database initialization information
Chart database graph structure.
A kind of 3. dynamic modelling method based on chart database according to claim 2, it is characterised in that the step
The setting of model configuration information, specifically comprises the following steps in S110：
S111：Physical model configuration information is set, and is specifically included and is carried out configuration setting to the type and attribute information of physical model；
S112：Relational model configuration information is set, and specifically includes the type to relational model, attribute, and associated by relation in fact
Body information carries out configuration setting.
A kind of 4. dynamic modelling method based on chart database according to claim 3, it is characterised in that the step
The setting of model configuration information, also comprises the following steps in S110：
S113：Event model configuration information is set, and the relation of entity behavior event will be represented in relational model as independent model
Configuration setting is carried out, the event model configuration information specifically includes event model type, attribute, and event ownership entity letter
Breath.
A kind of 5. dynamic modelling method based on chart database according to claim 2, it is characterised in that the step
Model configuration interface in S110 is visualization interface.
A kind of 6. dynamic modelling method based on chart database according to claim 2, it is characterised in that the step
S200 specifically comprises the following steps：
S210：Data collecting system obtains the model configuration information of user's setting from configuration database, and according to acquisition
Model configuration information, generate source data filter information；
S220：Data collecting system filters out from external source data according to source data filter information and meets model configuration information
Source data.
7. a kind of dynamic modelling method based on chart database according to claim 6, it is characterised in that in the step
S300 specifically comprises the following steps：
S310：The source data that data collecting system will filter out, be converted to chart database storage format；
S320：Source data after changing saving format, comparison model configuration information are directed respectively into blank sheet by data collecting system
Storage location is corresponded in database diagram structure, forms chart database.
A kind of 8. dynamic queries modeling method based on data type schema storehouse, it is characterised in that the dynamic queries modeling method master
Comprise the steps of：
S400：The chart database generated using the dynamic modelling method based on chart database as described in one of claim 1 ~ 6
As inquiry modeling object；
S410：Query function models：Language is inquired about to physical model query statement, event model query statement and relational model respectively
Sentence carries out function modelling definition, is saved in the configuration database；
S420：Query function is transferred：Data application system obtains the query function of corresponding model, institute from the configuration database
State query function and can be directly used for interactive query with chart database；
S430:Data application system obtains corresponding data information using query function from chart database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710639323.9A CN107368605B (en) | 2017-07-31 | 2017-07-31 | A kind of dynamic modelling method based on chart database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710639323.9A CN107368605B (en) | 2017-07-31 | 2017-07-31 | A kind of dynamic modelling method based on chart database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107368605A true CN107368605A (en) | 2017-11-21 |
| CN107368605B CN107368605B (en) | 2018-12-11 |
Family
ID=60308883
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710639323.9A Active CN107368605B (en) | 2017-07-31 | 2017-07-31 | A kind of dynamic modelling method based on chart database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107368605B (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108090198A (en) * | 2017-12-22 | 2018-05-29 | 浙江创邻科技有限公司 | Chart database creates and data load method, equipment and medium |
| CN109582808A (en) * | 2018-11-22 | 2019-04-05 | 北京锐安科技有限公司 | A kind of user information querying method, device, terminal device and storage medium |
| CN116304207A (en) * | 2023-02-22 | 2023-06-23 | 中广核智能科技(深圳)有限责任公司 | Data association method and system based on graph database |
| US11949548B2 (en) | 2019-12-17 | 2024-04-02 | Zte Corporation | Method for service status analysis, server, and storage medium |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140365531A1 (en) * | 2013-06-07 | 2014-12-11 | Vmware,Inc. | Creation of a graph database of a virtualization infrastructure |
| CN105718376A (en) * | 2016-02-17 | 2016-06-29 | 扬州大学 | Method for establishing relations between bug, commit and related personnel |
-
2017
- 2017-07-31 CN CN201710639323.9A patent/CN107368605B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140365531A1 (en) * | 2013-06-07 | 2014-12-11 | Vmware,Inc. | Creation of a graph database of a virtualization infrastructure |
| CN105718376A (en) * | 2016-02-17 | 2016-06-29 | 扬州大学 | Method for establishing relations between bug, commit and related personnel |
Non-Patent Citations (1)
| Title |
|---|
| 肖 佳 等: "海量 ＲDF 数据存储查询研究", 《北 京 信 息 科 技 大 学 学 报》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108090198A (en) * | 2017-12-22 | 2018-05-29 | 浙江创邻科技有限公司 | Chart database creates and data load method, equipment and medium |
| CN109582808A (en) * | 2018-11-22 | 2019-04-05 | 北京锐安科技有限公司 | A kind of user information querying method, device, terminal device and storage medium |
| US11949548B2 (en) | 2019-12-17 | 2024-04-02 | Zte Corporation | Method for service status analysis, server, and storage medium |
| CN116304207A (en) * | 2023-02-22 | 2023-06-23 | 中广核智能科技(深圳)有限责任公司 | Data association method and system based on graph database |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107368605B (en) | 2018-12-11 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107368605B (en) | A kind of dynamic modelling method based on chart database | |
| CN103080932B (en) | Process associated data set | |
| CN107085587A (en) | Indirect filtering in blended data operation | |
| CN109784721B (en) | Employment data analysis and data mining analysis platform system | |
| CN105468371B (en) | A kind of business process map merging method based on Subject Clustering | |
| Alvares et al. | Dynamic modeling of trajectory patterns using data mining and reverse engineering | |
| CN111026874A (en) | Data processing method and server of knowledge graph | |
| CN107885881A (en) | Business datum real-time report, acquisition methods, device, equipment and its storage medium | |
| CN107992865A (en) | A kind of vehicle identification method and system based on video analysis | |
| JP5535062B2 (en) | Data storage and query method for time series analysis of weblog and system for executing the method | |
| CN105574761B (en) | A kind of taxpayer's interests related network parallel generation method based on Spark | |
| CN113282623A (en) | Data processing method and device | |
| CN109766000A (en) | A kind of wisdom education system and method based on virtual reality | |
| CN108255852B (en) | SQL execution method and device | |
| CN103927168B (en) | A kind of method and device of object-oriented data model persistence | |
| CN111639068A (en) | Multi-system-based public data pool generation method, device, equipment and readable storage medium | |
| CN104765763B (en) | A kind of semantic matching method of the Heterogeneous Spatial Information classification of service based on concept lattice | |
| CN103299294A (en) | System and method for interpreting and generating integration flows | |
| CN109753541A (en) | A kind of relational network construction method and device, computer readable storage medium | |
| WO2012088760A1 (en) | Data analysis device and method therefor based on analysis factors calculated on demand | |
| US20130151465A1 (en) | Range and pattern selection in reporting solutions related to analytical models | |
| CN105868368A (en) | Discrimination method for vehicles entering city for the first time | |
| CN114547157A (en) | Knowledge graph analysis system and method | |
| Harwood et al. | Big data and semantic technology: A future for data integration, exploration and visualisation | |
| Zucca | Traces in the clickstream: Early work on a management information repository at the University of Pennsylvania |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |