CN107368605B - A kind of dynamic modelling method based on chart database - Google Patents

A kind of dynamic modelling method based on chart database Download PDF

Info

Publication number
CN107368605B
CN107368605B CN201710639323.9A CN201710639323A CN107368605B CN 107368605 B CN107368605 B CN 107368605B CN 201710639323 A CN201710639323 A CN 201710639323A CN 107368605 B CN107368605 B CN 107368605B
Authority
CN
China
Prior art keywords
chart database
database
model
configuration information
information
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
Application number
CN201710639323.9A
Other languages
Chinese (zh)
Other versions
CN107368605A (en
Inventor
陈代伟
王纯斌
文昕
钟明材
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Chengdu Sefon Software Co Ltd
Original Assignee
Chengdu Sefon Software Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Chengdu Sefon Software Co Ltd filed Critical Chengdu Sefon Software Co Ltd
Priority to CN201710639323.9A priority Critical patent/CN107368605B/en
Publication of CN107368605A publication Critical patent/CN107368605A/en
Application granted granted Critical
Publication of CN107368605B publication Critical patent/CN107368605B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2228Indexing structures
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • G06F16/211Schema design and management
    • G06F16/212Schema 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: according to model configuration information set by user, generate chart database initialization information;And according to the chart database initialization information, the chart database graph structure of blank is generated;S200: according to model configuration information set by user, source data filter information is generated;And according to the source data filter information, source data is screened;S300: by the chart database graph structure of blank described in the source data steps for importing S100 through filtering 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/relationship in diagram data/query function model information, and according to model configuration information set by user, complete creation, storage and data query, the application of chart database, greatly simplify the creation and application program of chart database, and realize the separation of system and business, enhance the ease for use and versatility of chart database.

Description

A kind of dynamic modelling method based on chart database
Technical field
The present invention relates to big data processing technology field, in particular to a kind of dynamic modelling method based on chart database.
Background technique
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 indicates present in real world " entity ", often " relationship " of the side between entity and entity.Generally, chart database stores the pass being made of several nodes and side It is network.For relevant database, chart database, can be by a large amount of structural datas since 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, be current big data era Under most common data system.
But in practical applications, chart database needs the competence exertion self-value in conjunction with application system.Different business Application scenarios, the storage and presentation of data are multifarious.It is different with the type on side, attribute according to vertex, in creation chart database When need chart database build in the script of library customize write;According to different entity and relationship, different chart databases is needed Query statement is coupled in application system, and application system height is caused to couple, and development efficiency is low.
And the format of chart database storage is vertex and side, entity in the real world and relationship is corresponded to, wherein scheming The complicated multiplicity of relationship storage in database, when needing to inquire the physical relationship of related entities in specific operation system, one As need in the script of library, input standard, interminable specialized query sentence carry out dissection from level to level from complicated network of personal connections Formula inquiry and acquisition, not only require height to the professional knowledge of user, but also query statement is many and diverse, further reduced chart database Development and application efficiency under different business scene.
Summary of the invention
It is an object of the invention to overcome the above-mentioned deficiency in the presence of the prior art, provides and a kind of facilitate user to figure number According to the dynamic modelling method of library data storage and query.This method is defined in chart database and is 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 and corresponding in chart database Data query can be carried out directly according to the predefined model configuration information of user, greatly simplifie the creation of chart database with Application program to improve the ease for use and versatility of chart database application, and is realized to business in chart database and system Separation, reduce the degree of coupling of chart database and application system, further increase the development and application efficiency of dynamic chart database.
In order to achieve the above-mentioned object of the invention, the present invention provides following technical schemes:
A kind of dynamic modelling method based on chart database, key step include:
S100: according to model configuration information set by user, chart database initialization information is generated;And according to the figure number According to library initialization information, the chart database graph structure of blank is generated;
S200: according to model configuration information set by user, source data filter information is generated;And it is sieved according to the source data Information is selected, source data is screened;
S300: by the chart database figure knot of blank described in the source data steps for importing S100 through being filtered out in step S200 In structure, chart database is formed.
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 corresponding relational model configuration information in side in the physical model configuration information and chart database of vertex correspondence in chart database; The setting of the model configuration information, and specifically include: S111: the setting of physical model configuration information is specifically included to entity mould The type and attribute information of type carry out configuration setting;S112: the setting of relational model configuration information is specifically included to relational model Entity information associated by type, attribute and relationship carries out configuration setting;
S120: by model configuration information set by user in S110 step, configuration database is saved in by data transmitting 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 vertex and side, to generate according to chart database initialization information The chart database graph structure of blank.
Wherein: model configuration interface described in the step, configuration database and chart database alternation of bed, i.e. group cost 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 used for according to the vertex and side of the blank of model configuration information set by user generation Source data compatible with the model information in each vertex and side is stored, to form diagram data.
The step S200 specifically comprises the following steps:
S210: data collection system obtains model configuration information set by user from configuration database, generates source data Filter information;
S220: data collection 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 collection system will filter out is converted to chart database storage format;
S320: the source data after converting saving format, comparison model configuration information are directed respectively into sky by data collection system Storage location is corresponded in white chart database graph structure, forms chart database.
According to above-mentioned dynamic modelling method, user only needs in model configuration interface, according to operation system demand, specific aim Relational model and entity model information to side in diagram data and vertex correspondence carry out configuration setting, and according to mould set by user Type configuration information completes the creation of chart database and the screening and storage of source data, greatlies simplify diagram data creation program, mentions The high ease for use of chart database.
It advanced optimizes, the setting of model configuration information in the step S110, further includes following steps:
S113: the setting of event model configuration information will represent the relationship of entity behavior event as independent in relational model Model carries out configuration setting, and it is real that the event model configuration information specifically includes event model type, attribute and event ownership Body information.
Due in the practical application of chart database, the relationship being often not only concerned only between entity and entity, Er Qieguan Infusing the event (i.e. what entity done) and different entities that entity generates, (two people are by bus independent by the relationship of event establishment Event, but two people taken same shift vehicle just establish association colleague relationship), so, in one kind of the present invention In dynamic modelling method based on chart database, by " event " relationship of presentation-entity behavior be abstracted as side by side with " entity " and The independent model type of " relationship " carries out configuration setting, and is stored in configuration database, is more nearly diagram data and actually answers With scene, be conducive to further development and utilization of the chart database in lower layer's different business systems.
Based on the same inventive concept, the dynamic queries modeling method based on chart database that the present invention also provides a kind of, it is described Dynamic queries modeling method mainly consists of the following steps:
S400: the chart database generated using the above-mentioned method based on chart database dynamic modeling is as inquiry modeling pair As, and query function modeling is carried out in same configuration database;
S410: query function modeling: physical model query statement, event model query statement and relational model are looked into respectively It askes sentence and carries 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 the chart database of the creation of dynamic modelling method described according to the present invention as query function dynamic modeling object, Modeling definition is carried out to physical model set by user in chart database, event model and relational model query function respectively, and It is pre-stored in the configuration database, is directly transferred accordingly from configuration database convenient for the application system of lower layer's chart 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 the dynamic modeling system for being suitable for chart database (that is, model configuration interface + 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, the creation of chart database can be completed, and directly quote and prestore in configuration database Respective queries sentence can be realized in chart database corresponding information carry out specific aim inquiry, greatly simplify chart database Creation program and query steps, reduce the technical difficulty of relevant operation, improve the ease for use of chart database;
2. the modeling method based on chart database provided according to the present invention, under different business background demand, user is only Configuration setting need to be carried out by choosing different entities/events/relational models in model configuration interface flexibility, and in diagram data The transfer of alternation of bed acts on, and realizes the quick creation 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 " relationship is abstracted as the independent model type with " entity " and " relationship " side by side, and sets up corresponding inquiry for all kinds of " events " Sentence improves the versatility of chart database so that the application of chart database be made to be more in line with business usage scenario;
4. the method for the present invention is by setting entities/events/relationship/query function model information in configuration database, Make chart database upstream (acquisition, 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 does not all need excessively to pay close attention to the interaction with chart database, reduces coupling Degree realizes being separated from each other for business and system, further improves the development and application efficiency of chart database.
Detailed description of the invention:
Fig. 1 is the dynamic modelling method step of the present invention based on chart database;
Fig. 2 interacts schematic diagram with external system for dynamic modeling system of the present invention;
Fig. 3 is the blank sheet database diagram structural schematic diagram according to model configuration information creation in embodiment 1;
Specific embodiment
Below with reference to test example and specific embodiment, the present invention is described in further detail.But this should not be understood It is all that this is belonged to based on the technology that the content of present invention is realized for the scope of the above subject matter of the present invention is limited to the following embodiments The range of invention.
Embodiment 1
A kind of dynamic modelling method based on chart database according to the present invention, wherein blank sheet number in step S100 According to the formation of library template, complete as follows:
S110: user in web model configuration interface, set entities/events as shown in Table 1/relational model type and Attribute configuration information;
1 entities/events of table/relational model table
S120: above-mentioned entities/events/relational model type and attribute configuration information are saved in mysql by data transmitting In configuration database;
S130: chart database alternation of bed obtains above-mentioned entities/events/relational model type from mysql configuration database And attribute configuration information, generate chart database initialization information;
S140: chart database initialization information is transmitted to Java Gremlin standard interface (such as by chart database alternation of bed Shown in table 2) and chart database standard Gremlin is excited to create program, operation chart database creates corresponding vertex and side, raw At the chart database graph structure (as shown in Figure 3) of blank.
2 standard Java Gremlin interface of table
Source Data Acquisition described in step S200 and screening, are completed especially by following steps:
S210: data collection system generates source from the model configuration information obtained in table 1 in mysql configuration database Data screening information;
S220: data collection system is filtered out from source database according to the model configuration information in table 1 meets model The source data of configuration information.
Step S300 specifically comprises the following steps:
S310: the source data that data collection system will filter out is converted to chart database storage format;
S320: data collection system configures the source data after converting 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 the same inventive concept with same dynamic modeling system, the present invention also provides a kind of dynamics based on chart database Modeling method is inquired, the dynamic queries modeling method mainly consists of the following steps:
S400: selecting the chart database formed in S320 step is inquiry modeling object;
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 database.Function modelling definition needs to rely on entities/events/relationship dynamically Model established model, the 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 component part;
The relationship of 3 query function of table modeling and solid modelling
S420: Data application system obtains query function from mysql configuration database;
S430: Data application system obtains the information such as entities/events/relationship using query function from chart database.With For table 4, Data application system calls queryEntityRide function interface from mysql configuration database, can be used for It is connected with chart database java routine interface, to obtain the entity for having the relationship of colleague in some time range with certain entity Information.
4 function model table of table
Embodiment 3
In the following, we are based on diagram data specifically by taking 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 studies and judges system and needs collect intelligence data, and carries out data analysis and information by visual mode It studies and judges, provides effective support for merit detection.The information in public security organs studies and judges the main business workflow of system: data acquisition --- > Data storage --- > data are studied and judged/and it analyzes/inquires.
1. data acquire: information in public security organs needs collector's information bank, Internet bar's identity card registration record, the public transport (people Boat, train etc.) trip record, hotel accommodations register information, the information such as real name message registration.During dynamic modeling as required The data of acquisition 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.
/ analyze/and inquire 2. data are studied and judged: 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 table 6.
5 police criminal detection of table studies and judges system entity/event/relational model
6 police criminal detection of table studies and judges system queries function model

Claims (7)

1. a kind of dynamic modelling method based on chart database, which is characterized in that this method mainly includes the following steps:
S100: according to model configuration information set by user, chart database initialization information is generated;And according to the chart database Initialization information generates the chart database graph structure of blank, specifically comprises 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 corresponding relational model configuration information in side in the physical model configuration information and chart database of vertex correspondence in library;
S120: the model configuration information is saved in configuration database;
S130: chart database alternation of bed reading model configuration information from the configuration database generates chart database initialization Information;
S140: chart database alternation of bed creates corresponding vertex and side, to generate blank according to chart database initialization information Chart database graph structure;
S200: according to model configuration information set by user, source data filter information is generated;And it screens and believes according to the source data Breath, screens source data;
S300: by the chart database graph structure of blank described in the source data steps for importing S100 through being filtered out in step S200 In, form chart database.
2. a kind of dynamic modelling method based on chart database according to claim 1, which is characterized in that the step The setting of model configuration information, specifically comprises the following steps: in S110
S111: the setting of physical model configuration information specifically includes and carries out configuration setting to the type and attribute information of physical model;
S112: the setting of relational model configuration information specifically includes real associated by the type to relational model, attribute and relationship Body information carries out configuration setting.
3. a kind of dynamic modelling method based on chart database according to claim 2, which is characterized in that the step The setting of model configuration information in S110, further includes following steps:
S113: the setting of event model configuration information will represent the relationship of entity behavior event as independent model in relational model Configuration setting is carried out, the event model configuration information specifically includes event model type, attribute and event ownership entity letter Breath.
4. a kind of dynamic modelling method based on chart database according to claim 1, which is characterized in that the step Model configuration interface in S110 is visualization interface.
5. a kind of dynamic modelling method based on chart database according to claim 1, which is characterized in that the step S200 specifically comprises the following steps:
S210: data collection system obtains model configuration information set by user from configuration database, and according to the mould of acquisition Type configuration information generates source data filter information;
S220: data collection system filters out from external source data according to source data filter information and meets model configuration information Source data.
6. a kind of dynamic modelling method based on chart database according to claim 5, which is characterized in that in the step S300 specifically comprises the following steps:
S310: the source data that data collection system will filter out is converted to chart database storage format;
S320: the source data after converting saving format, comparison model configuration information are directed respectively into blank sheet by data collection system Storage location is corresponded in database diagram structure, forms chart database.
7. a kind of dynamic queries modeling method based on data type schema library, which is characterized in that the dynamic queries modeling method master It comprises 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: language query function modeling: is inquired 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 Stating query function can be directly used for interactive query with chart database;
S430: Data application system obtains corresponding data information using query function from chart database.
CN201710639323.9A 2017-07-31 2017-07-31 A kind of dynamic modelling method based on chart database Active CN107368605B (en)

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 CN107368605A (en) 2017-11-21
CN107368605B true 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)

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108090198B (en) * 2017-12-22 2020-12-22 浙江创邻科技有限公司 Graph database creating method, graph database creating device, graph database loading device, and graph database loading medium
CN109582808A (en) * 2018-11-22 2019-04-05 北京锐安科技有限公司 A kind of user information querying method, device, terminal device and storage medium
CN112994916B (en) 2019-12-17 2024-05-24 中兴通讯股份有限公司 Service state analysis method, server and storage medium
CN116304207A (en) * 2023-02-22 2023-06-23 中广核智能科技(深圳)有限责任公司 Data association method and system based on graph database

Family Cites Families (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US9460187B2 (en) * 2013-06-07 2016-10-04 Vmware, Inc. Creation of a graph database of a virtualization infrastructure
CN105718376B (en) * 2016-02-17 2018-09-25 扬州大学 A kind of bug, commit, related personnel's relation establishing method

Also Published As

Publication number Publication date
CN107368605A (en) 2017-11-21

Similar Documents

Publication Publication Date Title
CN107368605B (en) A kind of dynamic modelling method based on chart database
CN103080932B (en) Process associated data set
CN1713196B (en) Product ordering system based on automatic design grid
CN108197237A (en) Visualization data, which collect, shows system
CN106104518A (en) For the framework extracted according to the data of example
CN107085587A (en) Indirect filtering in blended data operation
JP2009509271A (en) Apparatus and method for data profiling based on composition of extraction, transformation and reading tasks
CN111026874A (en) Data processing method and server of knowledge graph
CN107491476B (en) Data model conversion and query analysis method suitable for various big data management systems
CN110019555A (en) A kind of relation data semantization modeling method
WO2015085622A1 (en) Semantization method for terminal device of internet of things
CN105574761B (en) A kind of taxpayer's interests related network parallel generation method based on Spark
CN104199889A (en) RTLogic big data processing system and method based on CEP technology
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
CN106685707A (en) Asset information control method in distributed infrastructure system
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
Xie et al. Cloud computing image recognition system assists the construction of the internet of things model of administrative management event parameters
Harwood et al. Big data and semantic technology: A future for data integration, exploration and visualisation
CN114780752A (en) Method, system, equipment and storage medium for establishing federal knowledge graph
CN114547157A (en) Knowledge graph analysis system and method
CN108073643A (en) Task processing method and device
CN103092841A (en) Method and device for processing data

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