CN109377375A - Fund relation map generation method, system, computer equipment and storage medium - Google Patents
Fund relation map generation method, system, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109377375A CN109377375A CN201811018628.9A CN201811018628A CN109377375A CN 109377375 A CN109377375 A CN 109377375A CN 201811018628 A CN201811018628 A CN 201811018628A CN 109377375 A CN109377375 A CN 109377375A
- Authority
- CN
- China
- Prior art keywords
- fund
- data
- client
- entity
- server
- 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
- 238000000034 method Methods 0.000 title claims abstract description 28
- 238000012800 visualization Methods 0.000 claims abstract description 20
- 241001269238 Data Species 0.000 claims abstract description 6
- 238000013079 data visualisation Methods 0.000 claims description 6
- 238000009434 installation Methods 0.000 claims description 5
- 230000000007 visual effect Effects 0.000 abstract description 6
- 230000008901 benefit Effects 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 3
- 238000011161 development Methods 0.000 description 2
- 239000000284 extract Substances 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 210000000026 apposition eye Anatomy 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 210000001072 colon Anatomy 0.000 description 1
- 230000002354 daily effect Effects 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 230000003203 everyday effect Effects 0.000 description 1
- 239000004744 fabric Substances 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- PCHJSUWPFVWCPO-UHFFFAOYSA-N gold Chemical compound [Au] PCHJSUWPFVWCPO-UHFFFAOYSA-N 0.000 description 1
- 239000010931 gold Substances 0.000 description 1
- 229910052737 gold Inorganic materials 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 238000012545 processing Methods 0.000 description 1
- 230000001105 regulatory effect Effects 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 238000009394 selective breeding Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/06—Asset management; Financial planning or analysis
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Finance (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Operations Research (AREA)
- Game Theory and Decision Science (AREA)
- Human Resources & Organizations (AREA)
- Entrepreneurship & Innovation (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to financial technology field more particularly to a kind of fund relation map generation method, system, computer equipment and storage mediums.This method comprises: sending inquiry request to server after client obtains the query information that user inputs；After server receives inquiry request, when the Entities Matching of query information and relation data concentration, entity and corresponding relation data are fed back to client by server；Entity and relation data are assigned to draw data list by client, and client call data visualization software is shown after draw data list is converted to visualization view.Client of the invention obtains the relational dataset of server feedback as patterned basic data by inquiry request, visualization view is shown after being converted by visual software, user intuitively knows the correlation of association fund by other close fund datas of data correlation relation that client can find and inquire.
Description
Technical field
The present invention relates to financial technology fields more particularly to a kind of fund relation map generation method, system, computer to set
Standby and storage medium.
Background technique
Fund Market high risk and high yield are simultaneously deposited, therefore are constantly subjected to people for the research of the Knowledge Discovery of fund data
Concern.In recent years, it is greatly improved with the rapid development of computer technology with storage capacity, so that this aspect is ground
Study carefully and has a great development.
Finance and economic application APP on the market or website at present have a large amount of fund information data to generate daily, these numbers
According to the tendency for being undoubtedly beneficial to stock invester's understanding stock market, correct investment decision is made.But since data volume is big, stock invester can not be from
Data information that is effective, novel, facilitating investment is extracted or identified in mass data.Finance and economic application on the market at present
APP or website, the list information for being only capable of providing simple fund show, simple textual list message form, and client is from list
Information can only understand the case where single fund, can not be apparent from the direct feel of association between each fund.
Summary of the invention
In view of this, it is necessary to for fund information data at present on the market, be only capable of providing the list of simple fund
Information show the problem of, a kind of fund relation map generation method, system, computer equipment and storage medium are provided.
A kind of fund relation map generation method, comprising:
After client obtains the query information of user's input, inquiry request is sent to server, is wrapped in the inquiry request
Contain the query information；
After the server receives the inquiry request, by the relation data of the query information and storage in the database
Collection is matched, and the relational dataset includes multiple entities and the corresponding relation data of the entity, the entity include
Fund, fund manager or Fund Company, when the Entities Matching of the query information and relation data concentration, the service
The entity and corresponding relation data are fed back to the client by device；
The entity and the relation data are assigned to the draw data being preset in the client by the client
List, the client call data visualization software are opened up after the draw data list is converted to visualization view
Show.
After the client obtains the query information that user inputs in one of the embodiments, looked into server transmission
Request is ask, includes the query information in the inquiry request, comprising:
Query interface is arranged in the client, and the input for inputting the query information is arranged in the query interface
Frame obtains the query information by the query interface；
The query information is generated SQL query language by the client, and the inquiry request containing SQL query language is sent out
Give the server.
The query information is generated SQL query language by the client in one of the embodiments, will contain SQL
Before the inquiry request of query language is sent to the server, further includes:
The automatic installation relation type data base management system client mysql client software of client, the service
The automatic installation relation type database management system server mysql server software of device；
The server setting and the access authority for opening port, the client are ordered by remote terminal protocol telnet
Order is connect with the Server remote；
The server modifies the user right of the mysql server software, so that the client is described in
Server described in mysql client softward interview.
In one of the embodiments, the client entity and the relation data are assigned to be preset in it is described
Draw data list in client, comprising:
The draw data list include data template and link template, the data template include data template title,
Data template type and text variable, the link template include link template name, link template type, come source variable, mesh
Mark variable and text variable；
The relation data includes multiple entity types, and the entity type is the base for having incidence relation with the entity
Golden number evidence, the incidence relation include but is not limited to fund manager, Fund Company, the fund managed, the fund managed public affairs
Department, graduated school, tutor, classmate, in spouse at least one of relationship；
The relation data further includes other entities and other corresponding entity types, other described entities and the entity
With at least one identical entity type, by the identical entity type by the entity and other described entities
It is associated；
The client is by all fund datas and other described entities point in the entity and the relation data
The data template title of the entity is assigned to the link by the text variable not being assigned in the respective data template
Template carrys out source variable, the data template title of the entity type is assigned to the target variable of the link template, by institute
The incidence relation for stating entity and the entity type is assigned to the text variable for linking template, by the entity and the reality
Body type is associated by the link template.
The data template in the draw data list and link template use json data in one of the embodiments,
Format.
The client call data visualization software converts the draw data list in one of the embodiments,
To be shown after visualization view, comprising:
The client will be sent to using the draw data list of json data format and be preset in the client
Interior data visualization D3.js software, the D3.js software is by the data template of assignment and the link template switch
To be shown after visualization figure.
In one of the embodiments, when the entity is the fund, comprising:
It includes the corresponding fund code of the fund, fund manager, base that the server also obtains from the database
King Company, nearly annual earnings, the related data in disk including valuation and historical yield, feed back to the visitor for the related data
Family end；
The client passes through list to the fund, fund code, fund manager, Fund Company and nearly annual earnings
Form is shown, and the client is shown valuation in the disk and historical yield by way of curve graph.
A kind of fund relation map generation system, comprising:
Request unit after obtaining the query information that user inputs for client, sends inquiry request to server, described
It include the query information in inquiry request；
Feedback unit after receiving the inquiry request for the server, by the query information and is stored in data
Relational dataset in library is matched, and the relational dataset includes multiple entities and the corresponding relationship number of the entity
According to the entity includes fund, fund manager or Fund Company, when the entity of the query information and relation data concentration
When matching, the entity and corresponding relation data are fed back to the client by the server；
The entity and the relation data are assigned to for the client and are preset in the client by display unit
The draw data list is converted to visualization view by interior draw data list, the client call data visualization software
It is shown after figure.
A kind of computer equipment, including memory and processor are stored with computer-readable instruction in the memory, institute
When stating computer-readable instruction and being executed by the processor, so that the processor executes above-mentioned fund relation map generation method
The step of.
A kind of storage medium being stored with computer-readable instruction, the computer-readable instruction are handled by one or more
When device executes, so that the step of one or more processors execute above-mentioned fund relation map generation method.
Above-mentioned fund relation map generation method, device, computer equipment and storage medium, including client obtain user
After the query information of input, inquiry request is sent to server, includes query information in inquiry request；Server receives inquiry
After request, query information is matched with the relational dataset of storage in the database, relational dataset includes multiple realities
Body and the corresponding relation data of entity, entity includes fund, fund manager or Fund Company, when query information and relational dataset
In Entities Matching when, entity and corresponding relation data are fed back to client by server；Client is by entity and relationship number
According to the draw data list being preset in client is assigned to, client call data visualization software turns draw data list
It is shown after being changed to visualization view.Client of the invention obtains the relational dataset of server feedback by inquiry request
As patterned basic data, visualization view is shown after being converted by visual software, user passes through client
Other close fund datas of the data correlation relation that can be found and inquire, intuitively know the mutual pass of association fund
System realizes and the effective of magnanimity public data is extracted and be associated with, provides advantageous direct fund data for capital investment.
Detailed description of the invention
By reading the following detailed description of the preferred embodiment, various other advantages and benefits are common for this field
Technical staff will become clear.The drawings are only for the purpose of illustrating a preferred embodiment, and is not considered as to the present invention
Limitation.
Fig. 1 is the flow chart of the fund relation map generation method in one embodiment of the invention；
Fig. 2 is a kind of visualization view in one embodiment；
Fig. 3 is valuation curve graph in the disk of fund a kind of in one embodiment；
Fig. 4 is a kind of historical yield curve graph of fund in one embodiment；
Fig. 5 is the structure chart that fund relation map generates system in one embodiment of the invention.
Specific embodiment
In order to make the objectives, technical solutions, and advantages of the present invention clearer, with reference to the accompanying drawings and embodiments, right
The present invention is further elaborated.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, and
It is not used in the restriction present invention.
Those skilled in the art of the present technique are appreciated that unless expressly stated, singular " one " used herein, " one
It is a ", " described " and "the" may also comprise plural form.It is to be further understood that being arranged used in specification of the invention
Diction " comprising " refer to that there are the feature, integer, step, operation, element and/or component, but it is not excluded that in the presence of or addition
Other one or more features, integer, step, operation, element, component and/or their group.
Fig. 1 is the flow chart of the fund relation map generation method in one embodiment of the invention, as shown in Figure 1, a kind of
Fund relation map generation method, comprising the following steps:
Step S1, client send inquiry request: after client obtains the query information of user's input, sending to server
Inquiry request includes query information in inquiry request.
For client before the query information for obtaining user's input, client can preset query interface, and inquire
Interface setting is used for the input frame of input inquiry information, obtains query information by query interface.The inquiry of query interface input
Information can be fund, fund manager or Fund Company, such as it is " fund manager that user inputs fund manager in query information
When 1 ", after client gets this query information, inquiry request is sent to server.
In one embodiment, after client gets this query information, before sending inquiry request to server, comprising:
The automatic installation relation type data base management system client mysql client software of client, server are pacified automatically
Fill Relational DBMS server mysql server software；Server is arranged and opens the access authority of port,
Client is connect by remote terminal protocol telnet order with Server remote；Server modifies mysql server software
User right, so that client passes through mysql client softward interview server.After client and server establishes connection, visitor
Query information is generated SQL query language by family end, and the inquiry request containing SQL query language is sent to server.
Sql like language is the abbreviation of structured query language (Structured Query Language), is a kind of data
Library inquiry and programming language for accessing data and querying, updating, and managing relational database system, while being also number
According to the extension name of library script file.Sql like language does not require the specified deposit method to data of client, does not need client yet
Specific data location mode is solved, so the disparate databases system with entirely different fabric, can be used identical
Structured query language inputs the interface with management as data, and structured query language sentence can be nested, this has it
Great flexibility and powerful function.
Before this client inquires database to server using sql like language, client and server is needed to establish connection, this
Embodiment installs corresponding software respectively by client and server automatically, server is arranged and opens access authority, client
The mode of long-range connection server, realizes the connection of the two.The present embodiment is obtained by generating SQL query language to server
The corresponding relational dataset of query information can inquire fund data, make as long as establishing any client of connection with server
It is simple and convenient to obtain client acquisition fund data.
Matching inquiry information: step S2 after server receives inquiry request, by query information and is stored in the database
Relational dataset is matched, and relational dataset includes multiple entities and the corresponding relation data of entity, entity include fund,
Fund manager or Fund Company, when the Entities Matching that query information and relation data are concentrated, server is by entity and corresponding
Relation data feeds back to client.
Relational dataset is periodically stored in the database of server, relational dataset includes multiple entities and entity pair
The relation data answered, wherein entity is fund, fund manager or Fund Company, and relation data includes multiple entity types, entity
Type is the fund data for having incidence relation with entity, and incidence relation includes but is not limited to fund manager, Fund Company, management
The fund crossed, the Fund Company managed, graduated school, tutor, classmate, in spouse at least one of relationship.In this step
Relational dataset can be using shown in following Tables 1 and 2:
Table 1
Entity in table 1 is fund manager 1, and having the fund data of incidence relation with fund manager 1 is that incidence relation is
The fund data Jia Shi fund management Co., Ltd of Fund Company, incidence relation are that the fund data Shanghai XX of graduated school is big
It learns.
Table 2
Entity in table 2 is fund manager 2, and having the fund data of incidence relation with fund manager 2 is that incidence relation is
The fund data Jia Shi fund management Co., Ltd of Fund Company, incidence relation are the fund data classmate E of classmate.
After including the query information of " fund manager 1 " in the inquiry request that server receives client transmission, from number
According in library relation data concentration searched and matched, when a certain entity contains entitled fund manager 1, by entity and with
The relevant all entity types of entity extract, for example the incidence relation in table 1 is " Fund Company ", physical name
The entity type and incidence relation of referred to as " Jia Shi fund management Co., Ltd " are " graduated school ", entity name is " Shanghai XX
The entity type of university ".
Due to fund manager 1 and the entity type having the same of fund manager 2, it is " base that server, which also extracts entity name,
The entity and its other corresponding entity types of Jin manager 2 ", for example incidence relation is " Fund Company ", entity name is " good
The entity type that the entity type and incidence relation of real fund management Co., Ltd " are " classmate ", entity name is " classmate E ".
In this step, the relational dataset of server storage in the database is carried out respectively from different fund websites
Acquisition, such as disclosed official website of Fund Company, regulatory agency disclose data, middle National IP Network, domestic and international academic paper website, new
Unrestrained microblogging, all kinds of investment recommendation websites, can also be that day eye looks into equal APP channel, obtain fund basis by web crawlers algorithm
Information.It is local data base, the source of fund basic information such as safety Euler map number that the database of fund website, which can also be,
According to site for service, Pingan Insurance website, Lu Jin institute website, the database of these websites is local data base, can be from local number
According to acquisition magnanimity fund basic information in library.After timing acquisition to fund basic information, by data screening rule, to fund base
Plinth information is screened, and many-termed relation data set is obtained, and the fund data in each relational dataset has incidence relation, to same
The one multiple entities of n-th-trem relation n data set generation, each entity is corresponding to generate multiple entity types, and entity includes fund, fund manager
Or Fund Company, entity type include other fund datas of entity associated；Every two entity is matched, when with identical
Entity type when, entity type is set to off set type, is associated two entities with relationship type, by two entities
Relevant relation data is generated with entity type.
In this step, server when being matched to query information with relational dataset, can using accurate matching or
The mode of fuzzy matching is matched.Accurate matching refers to that only entire field is identical as term and just matches.In this step,
The query information that user inputs is worked as into fixed phrases, is retrieved with the relational dataset of storage in the database, only relationship
Entity name and fixed phrases in data set is completely the same, just thinks query information and the Entities Matching that relation data is concentrated.
As long as fuzzy matching refers to no matter how the position of word the word occurs.In this step, query information user inputted
Be split as the unit concept of individual Chinese character, and carry out logic and operation, according to preset logic and operation think query information with
The Entities Matching that relation data is concentrated.Concrete condition when logic and operation can be according to actual implementation, with " and ", " or ",
" not " relationship.For example, query information is " good reality fund ", then " good reality fund " is split as " praise ", " reality ", " fund ", it is default
Logic is " and " relationship, as long as there is " good " and " reality " and " fund " in a certain entity name in entity, then it is assumed that
Match.This step server matches query information with relational dataset preferably by the way of fuzzy matching, in order to
Family only needs data key words to be achieved with the fund data of incidence relation.
Step S3, visualization view are shown: entity and relation data are assigned to and are preset in drawing in client by client
Diagram data list, client call data visualization software are shown after draw data list is converted to visualization view.
In one embodiment, draw data list includes data template and link template, and data template includes data mould
Board name, data template type and text variable, link template include link template name, link template type, come source variable,
Target variable and text variable.Data template can have the data template of multiple and different types, in order to by fund manager, fund
And Fund Company etc. carries out difference presentation.
Wherein, data template is used for entity and entity type, and link template is used between entity and corresponding entity type
Direction.Data template and link template in draw data list use json data format.
Json (JavaScript Object Notation) data format is a kind of number lighter and handier than xml, simpler
According to exchange format, Json data format is JavaScript native format, and JSON data are handled in JavaScript and are not needed
Any special API or kit.The rule of JSON are as follows: object is unordered " ' name/value ' a to " set.One object
With " " (left bracket) starts, " " (right parenthesis) end.Each " title " heel one ": " (colon)；" ' name/value ' to " it
Between use ", " (comma) separate be used as a kind of data transmission format.Json, which does not need to send from server end, contains specific content
The header message of type causes the parameter of Json data format to transmit simpler and more practical, is more suitable for fund number in this step
According to transmitting.Client, using after json data format, can meet numerous applications to data template and link template, as webpage,
Cell phone application, PC application etc. are drawn.
Data template in the present embodiment is for example:
Link template in the present embodiment is for example:
In this step, the relation data that client is got includes multiple entity types, and entity type is that have with entity
The fund data of incidence relation, incidence relation include but is not limited to fund manager, Fund Company, the fund managed, managed
Fund Company, graduated school, tutor, classmate, in spouse at least one of relationship；Relation data further includes other entities and right
Other entity types answered, other entities and entity have at least one identical entity type, pass through identical entity type
Entity and other entities are associated.Client divides all fund datas in entity and relation data with other entities
The text variable not being assigned in respective data template becomes the source that the data template title of entity is assigned to link template
The data template title of entity type is assigned to the target variable of link template by amount, by being associated with for entity and entity type
System is assigned to the text variable of link template, and entity is associated with entity type by linking template.
Specifically, after user inputs " fund manager 1 " in step 1), multiple realities of the step 2) server feedback to client
Body and relation data are as follows: entity name be " fund manager 1 " entity, corresponding relation data be connection relationship be " Fund Company ",
Entity name is the entity type of " Jia Shi fund management Co., Ltd " and incidence relation is " graduated school ", entity name is
The entity type of " Shanghai XX university ".Entity name is the entity of " fund manager 2 ", and corresponding relation data is that incidence relation is
" Fund Company ", entity name are the entity type of " Jia Shi fund management Co., Ltd " and incidence relation is " classmate ", entity
The entity type of entitled " classmate E ", then step 3) generates five kinds of data template, and 4 link templates are presented by tabular form,
Data template such as the following table 3 links template such as the following table 4:
| Data template title | Data template type | Text variable |
| X1 | X2 | Fund manager 1 |
| X3 | X4 | Jia Shi fund management Co., Ltd |
| X5 | X6 | Shanghai XX university |
| X7 | X8 | Fund manager 2 |
| X9 | X10 | Classmate E |
Table 3
| Link template name | Link template type | Carry out source variable | Target variable | Text variable |
| Y1 | Y2 | X1 | X3 | Fund Company |
| Y3 | Y4 | X1 | X5 | Graduated school |
| Y5 | Y6 | X7 | X3 | Fund Company |
| Y7 | Y8 | X7 | X9 | Classmate |
Table 4
The present embodiment can by presetting the data template and link template of json data format in draw data list
To realize the template of various modes, when needing to modify template style, data template or link template, modification need to be only modified
It is simple and convenient with safeguarding.Entity and relation data that client obtains are assigned to data template and link the mode of template, it is whole
As long as a process pre-set parameter can automatic assignment, be not necessarily to artificial selection template.Data after assignment are json numbers
According to format, in order to the use of subsequent visual software, json data format can preferably be compatible with the visual software of diversified forms.
In one embodiment, client will be sent to using the draw data list of json data format and be preset in client
The data template of assignment and link template switch are visualization figure by the data visualization D3.js software in end, D3.js software
After be shown.
Data visualization D3.js software can free plan, be suitble to show rich and varied chart style, and exempt from completely
Take, code open source.Since data visualization D3.js software subtype is very rich, it almost can satisfy all exploitations
Demand.As shown in Fig. 2, five kinds of data template and 4 link templates that step 3) generates, pass through data visualization D3.js software
Visualization figure is generated, it is base that user, which can get information about " fund manager 1 " and " fund manager 2 " direct incidence relation,
King Company " Jia Shi fund management Co., Ltd ".
Entity and relation data are converted to Visual Chart by D3.js software by the present embodiment, are checked for user, can be more
The relationship situation of the good fund data for showing a certain entity and corresponding incidence relation.
In one embodiment, when entity is fund, comprising: it includes that fund is corresponding that server obtains also from database
Fund code, fund manager, Fund Company, nearly annual earnings, the related data in disk including valuation and historical yield, by phase
Data feedback is closed to client.Client passes through column to fund, fund code, fund manager, Fund Company and nearly annual earnings
The form of table is shown, and client is shown valuation in disk and historical yield by way of curve graph.
Server in the present embodiment can be the server of fund transaction system, and the database purchase of server has fund
The historical data and real time data of transaction system.For example, the safety corresponding server of fund net and database everyday, are stored with base
The corresponding fund code of gold, fund manager, Fund Company, nearly annual earnings, the dependency number in disk including valuation and historical yield
According to.
Specifically, when user inputs the fund that fund name is " upslide rub root core growth ", server is from database
Middle lookup simultaneously gets the corresponding fund code of the fund, fund manager, Fund Company, nearly annual earnings, valuation and goes through in disk
Related data including history income, and feed back to client.Client to fund, fund code, fund manager, Fund Company and
Nearly annual earnings are shown by way of list, show that content is as shown in table 5 below:
Table 5
As shown in Figure 3 and Figure 4, client passes through valuation in the disk of " upslide rub root core growth " fund and historical yield
The form of curve graph is shown.
The present embodiment, user can not only understand fund data associated by query information by visualization view, moreover it is possible to logical
It crosses table and curve graph further appreciates that the corresponding real time data of the fund of inquiry and historical data, provided for capital investment more complete
The effective data in face.
Fund relation map generation method of the invention, client obtain the inquiry that user inputs by query interface and believe
Breath generates SQL query language, accesses and connects with the Database of server, realizes that any client can be with database side
Just the purpose of secure connection.After server receives SQL query language, by with relational dataset preset in database carry out
Match, the entity and relation data that will match to are imposed a fine to client, and processing of the server end without data reduces server
Operating pressure.After client gets entity and relation data, multiple json numbers are generated by preset draw data list
After the data template and link template of format, by calling data visualization software to be by data template and link template switch
Visualization view is shown user, and the content of displaying is fund relation map.The present invention to fund relation map into
While row is shown, when query information is fund, also to the corresponding related data of fund, such as fund code, fund manager, base
King Company, nearly annual earnings, the related data in disk including valuation and historical yield, carry out the form and curve graph of list respectively
Form further show user, provide more comprehensively effective data for capital investment, user can be from numerous and complicated sea
The most close fund data of incidence relation is obtained in amount fund relevant information.
In one embodiment it is proposed that a kind of fund relation map generates system, as shown in figure 5, including such as lower unit:
Request unit after obtaining the query information that user inputs for client, sends inquiry request, inquiry to server
It include query information in request；
Feedback unit, after receiving inquiry request for server, by the relationship number of query information and storage in the database
It is matched according to collection, relational dataset includes multiple entities and the corresponding relation data of entity, and entity includes fund, fund warp
Reason or Fund Company, when the Entities Matching that query information and relation data are concentrated, server is by entity and corresponding relationship number
According to feeding back to client；
Entity and relation data are assigned to the draw data column being preset in client for client by display unit
Table, client call data visualization software are shown after draw data list is converted to visualization view.
In one embodiment it is proposed that a kind of computer equipment, including memory and processor, it is stored in memory
Computer-readable instruction, when computer-readable instruction is executed by processor, so that reality when processor executes computer-readable instruction
Existing following steps: after client obtains the query information of user's input, inquiry request is sent to server, includes in inquiry request
There is query information；After server receives inquiry request, by the relational dataset progress of query information and storage in the database
Match, relational dataset includes multiple entities and the corresponding relation data of entity, and entity includes that fund, fund manager or fund are public
Department, when the Entities Matching of query information and relation data concentration, entity and corresponding relation data are fed back to visitor by server
Family end；Entity and relation data are assigned to the draw data list being preset in client, client call data by client
Visual software is shown after draw data list is converted to visualization view.
In one embodiment it is proposed that a kind of storage medium for being stored with computer-readable instruction, computer-readable finger
When order is executed by one or more processors, so that one or more processors execute following steps: there is query information；Server
After receiving inquiry request, query information is matched with the relational dataset of storage in the database, relational dataset includes
There are multiple entities and the corresponding relation data of entity, entity includes fund, fund manager or Fund Company, when query information and is closed
Coefficient according to concentration Entities Matching when, entity and corresponding relation data are fed back to client by server；Client is by entity
And relation data is assigned to the draw data list being preset in client, client call data visualization software is by number of drawing
It is shown after being converted to visualization view according to list.
Those of ordinary skill in the art will appreciate that all or part of the steps in the various methods of above-described embodiment is can
It is completed with instructing relevant hardware by program, which can be stored in a computer readable storage medium, storage
Medium may include: read-only memory (ROM, Read Only Memory), random access memory (RAM, Random
Access Memory), disk or CD etc..
Each technical characteristic of embodiment described above can be combined arbitrarily, for simplicity of description, not to above-mentioned reality
It applies all possible combination of each technical characteristic in example to be all described, as long as however, the combination of these technical characteristics is not deposited
In contradiction, all should be considered as described in this specification.
Some exemplary embodiments of the invention above described embodiment only expresses, the description thereof is more specific and detailed, but
It cannot be construed as a limitation to the scope of the present invention.It should be pointed out that for the ordinary skill people of this field
For member, without departing from the inventive concept of the premise, various modifications and improvements can be made, these belong to of the invention
Protection scope.Therefore, the scope of protection of the patent of the invention shall be subject to the appended claims.
Claims (10)
1. a kind of fund relation map generation method characterized by comprising
After client obtains the query information of user's input, inquiry request is sent to server, includes in the inquiry request
The query information；
After the server receives the inquiry request, by the query information and storage relational dataset in the database into
Row matching, the relational dataset includes multiple entities and the corresponding relation data of the entity, the entity include fund,
Fund manager or Fund Company, when the Entities Matching of the query information and relation data concentration, the server will
The entity and corresponding relation data feed back to the client；
The entity and the relation data are assigned to the draw data list being preset in the client by the client,
The client call data visualization software is shown after the draw data list is converted to visualization view.
2. fund relation map generation method according to claim 1, which is characterized in that it is defeated that the client obtains user
After the query information entered, inquiry request is sent to server, includes the query information in the inquiry request, comprising:
Query interface is arranged in the client, and the input frame for inputting the query information is arranged in the query interface,
The query information is obtained by the query interface；
The query information is generated SQL query language by the client, and the inquiry request containing SQL query language is sent to
The server.
3. fund relation map generation method according to claim 2, which is characterized in that the client is by the inquiry
Information generates SQL query language, before the inquiry request containing SQL query language is sent to the server, further includes:
The automatic installation relation type data base management system client mysql client software of client, the server is certainly
Dynamic installation relation type database management system server mysql server software；
Server setting and the access authority for opening port, the client by remote terminal protocol telnet order and
The Server remote connection；
The server modifies the user right of the mysql server software, so that the client passes through the mysql
Server described in client softward interview.
4. fund relation map generation method according to claim 1, which is characterized in that the client is by the entity
And the relation data is assigned to the draw data list being preset in the client, comprising:
The draw data list includes data template and link template, and the data template includes data template title, data
Template type and text variable, the link template include link template name, link template type, come source variable, target change
Amount and text variable；
The relation data includes multiple entity types, and the entity type is the fund number for having incidence relation with the entity
According to the incidence relation includes but is not limited to fund manager, Fund Company, the fund managed, the Fund Company managed, finishes
Industry universities and colleges, tutor, classmate, in spouse at least one of relationship；
The relation data further includes other entities and other corresponding entity types, other described entities and the entity have
At least one identical described entity type is carried out the entity and other described entities by the identical entity type
Association；
The client by the entity and the relation data all fund datas and other described entities assign respectively
It is worth to the text variable in the respective data template, the data template title of the entity is assigned to the link template
Carry out source variable, by the data template title of the entity type be assigned to it is described link template target variable, by the reality
The incidence relation of body and the entity type is assigned to the text variable for linking template, by the entity and the entity class
Type is associated by the link template.
5. fund relation map generation method according to claim 4, which is characterized in that in the draw data list
Data template and link template use json data format.
6. fund relation map generation method according to claim 5, which is characterized in that the client call data can
It is shown depending on changing after the draw data list is converted to visualization view by software, comprising:
The client will be sent to using the draw data list of json data format and is preset in the client
Data visualization D3.js software, the data template of assignment and the link template switch are by the D3.js software can
Depending on being shown after change figure.
7. fund relation map generation method according to claim 1, which is characterized in that when the entity is the fund
When, comprising:
It includes the corresponding fund code of the fund, fund manager, fund public affairs that the server also obtains from the database
Related data in department, nearly annual earnings, disk including valuation and historical yield, feeds back to the client for the related data
End；
The client is to the fund, fund code, fund manager, Fund Company and nearly annual earnings by way of list
It is shown, the client is shown valuation in the disk and historical yield by way of curve graph.
8. a kind of fund relation map generates system characterized by comprising
Request unit after obtaining the query information that user inputs for client, sends inquiry request, the inquiry to server
It include the query information in request；
Feedback unit after receiving the inquiry request for the server, by the query information and stores in the database
Relational dataset matched, the relational dataset includes multiple entities and the corresponding relation data of the entity, institute
Stating entity includes fund, fund manager or Fund Company, when the Entities Matching of the query information and relation data concentration
When, the entity and corresponding relation data are fed back to the client by the server；
The entity and the relation data are assigned to for the client and are preset in the client by display unit
Draw data list, after the draw data list is converted to visualization view by the client call data visualization software
It is shown.
9. a kind of computer equipment, including memory and processor, it is stored with computer-readable instruction in the memory, it is described
When computer-readable instruction is executed by the processor, so that the processor executes such as any one of claims 1 to 7 right
It is required that the step of fund relation map generation method.
10. a kind of storage medium for being stored with computer-readable instruction, the computer-readable instruction is handled by one or more
When device executes, so that one or more processors execute the fund relational graph as described in any one of claims 1 to 7 claim
The step of composing generation method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811018628.9A CN109377375A (en) | 2018-09-03 | 2018-09-03 | Fund relation map generation method, system, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811018628.9A CN109377375A (en) | 2018-09-03 | 2018-09-03 | Fund relation map generation method, system, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109377375A true CN109377375A (en) | 2019-02-22 |
Family
ID=65404132
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811018628.9A Pending CN109377375A (en) | 2018-09-03 | 2018-09-03 | Fund relation map generation method, system, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109377375A (en) |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109918396A (en) * | 2019-03-11 | 2019-06-21 | 山东鲁能软件技术有限公司 | A kind of multiplicity data search method |
| CN110134732A (en) * | 2019-05-17 | 2019-08-16 | 北京天融信网络安全技术有限公司 | A kind of methods of exhibiting and device of authorization relationship quantity |
| CN110335145A (en) * | 2019-07-12 | 2019-10-15 | 深圳众赢维融科技有限公司 | A kind of influence factor Dynamic Display method, apparatus, electronic equipment and storage medium |
| CN110377628A (en) * | 2019-07-23 | 2019-10-25 | 京东方科技集团股份有限公司 | A kind of information acquisition method, device and electronic equipment |
| CN110489666A (en) * | 2019-08-19 | 2019-11-22 | 泰康保险集团股份有限公司 | Data processing method, device and storage medium |
| CN110955803A (en) * | 2019-11-15 | 2020-04-03 | 北京浪潮数据技术有限公司 | Drawing method, device, equipment and medium of relational graph based on graph database |
| CN111090801A (en) * | 2019-12-18 | 2020-05-01 | 创新奇智(青岛)科技有限公司 | Expert interpersonal relationship atlas drawing method and system |
| CN111159421A (en) * | 2019-12-25 | 2020-05-15 | 中国建设银行股份有限公司 | Knowledge graph-based fund query method and device |
| CN113312517A (en) * | 2020-02-26 | 2021-08-27 | 京东方科技集团股份有限公司 | Fund knowledge graph obtaining method and device and electronic equipment |
| CN113711203A (en) * | 2019-04-19 | 2021-11-26 | 微软技术许可有限责任公司 | Visual representation of direction correlation of service health |
| CN114595343A (en) * | 2022-05-07 | 2022-06-07 | 北京金堤科技有限公司 | Map display method and device, storage medium and electronic equipment |
| CN114880406A (en) * | 2022-05-05 | 2022-08-09 | 国网智能电网研究院有限公司 | Data management method and device |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120011134A1 (en) * | 2010-07-08 | 2012-01-12 | Travnik Jakub | Systems and methods for database query translation |
| CN106294588A (en) * | 2016-07-28 | 2017-01-04 | 广东中标数据科技股份有限公司 | The method and device of fast search content to be inquired about |
| CN106528822A (en) * | 2016-11-17 | 2017-03-22 | 山东合天智汇信息技术有限公司 | Construction method of business relationship circle, query method and query system of business relationship circle |
| CN106682145A (en) * | 2016-12-22 | 2017-05-17 | 北京览群智数据科技有限责任公司 | Enterprise information processing method, server and client |
| CN107657057A (en) * | 2017-10-19 | 2018-02-02 | 河北省科学院应用数学研究所 | A kind of enterprise's reference information fusion graphic method |
| CN108170704A (en) * | 2017-11-21 | 2018-06-15 | 北京明略软件系统有限公司 | A kind of method and device of atlas analysis |
-
2018
- 2018-09-03 CN CN201811018628.9A patent/CN109377375A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120011134A1 (en) * | 2010-07-08 | 2012-01-12 | Travnik Jakub | Systems and methods for database query translation |
| CN106294588A (en) * | 2016-07-28 | 2017-01-04 | 广东中标数据科技股份有限公司 | The method and device of fast search content to be inquired about |
| CN106528822A (en) * | 2016-11-17 | 2017-03-22 | 山东合天智汇信息技术有限公司 | Construction method of business relationship circle, query method and query system of business relationship circle |
| CN106682145A (en) * | 2016-12-22 | 2017-05-17 | 北京览群智数据科技有限责任公司 | Enterprise information processing method, server and client |
| CN107657057A (en) * | 2017-10-19 | 2018-02-02 | 河北省科学院应用数学研究所 | A kind of enterprise's reference information fusion graphic method |
| CN108170704A (en) * | 2017-11-21 | 2018-06-15 | 北京明略软件系统有限公司 | A kind of method and device of atlas analysis |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109918396A (en) * | 2019-03-11 | 2019-06-21 | 山东鲁能软件技术有限公司 | A kind of multiplicity data search method |
| CN113711203A (en) * | 2019-04-19 | 2021-11-26 | 微软技术许可有限责任公司 | Visual representation of direction correlation of service health |
| CN110134732A (en) * | 2019-05-17 | 2019-08-16 | 北京天融信网络安全技术有限公司 | A kind of methods of exhibiting and device of authorization relationship quantity |
| CN110335145A (en) * | 2019-07-12 | 2019-10-15 | 深圳众赢维融科技有限公司 | A kind of influence factor Dynamic Display method, apparatus, electronic equipment and storage medium |
| CN110377628A (en) * | 2019-07-23 | 2019-10-25 | 京东方科技集团股份有限公司 | A kind of information acquisition method, device and electronic equipment |
| CN110489666A (en) * | 2019-08-19 | 2019-11-22 | 泰康保险集团股份有限公司 | Data processing method, device and storage medium |
| CN110955803A (en) * | 2019-11-15 | 2020-04-03 | 北京浪潮数据技术有限公司 | Drawing method, device, equipment and medium of relational graph based on graph database |
| CN111090801A (en) * | 2019-12-18 | 2020-05-01 | 创新奇智(青岛)科技有限公司 | Expert interpersonal relationship atlas drawing method and system |
| CN111159421A (en) * | 2019-12-25 | 2020-05-15 | 中国建设银行股份有限公司 | Knowledge graph-based fund query method and device |
| CN113312517A (en) * | 2020-02-26 | 2021-08-27 | 京东方科技集团股份有限公司 | Fund knowledge graph obtaining method and device and electronic equipment |
| CN114880406A (en) * | 2022-05-05 | 2022-08-09 | 国网智能电网研究院有限公司 | Data management method and device |
| CN114595343A (en) * | 2022-05-07 | 2022-06-07 | 北京金堤科技有限公司 | Map display method and device, storage medium and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109377375A (en) | Fund relation map generation method, system, computer equipment and storage medium | |
| US11645345B2 (en) | Systems and methods for issue tracking systems | |
| US11809458B2 (en) | System and method for providing database abstraction and data linkage | |
| US9286329B2 (en) | Generating analytics application using reusable application modules | |
| CN109863527A (en) | The method and system of the server side rendering of local content for showing | |
| JP5683037B2 (en) | Business relationship map generation system and program | |
| US20150169778A1 (en) | Graphical user interface for filtering a population of items | |
| US8150879B2 (en) | Building custom dimension trees | |
| US10083247B2 (en) | Generating state-driven role-based landing pages | |
| KR101316713B1 (en) | One-Source Multi-language banking system and controlling method therefore | |
| US10795901B2 (en) | Generic entry and exit network interface system and method | |
| CN111382279B (en) | Examination method and device | |
| US11100126B2 (en) | Creating reports using dimension trees | |
| CN109543028A (en) | Computer system, non-transitory machine-readable storage media and computer implemented method | |
| US20220277399A1 (en) | Personalized transaction categorization | |
| CN109408704B (en) | Fund data association method, system, computer device and storage medium | |
| CN110716994B (en) | Retrieval method and device supporting heterogeneous geographic data resource retrieval | |
| US11693874B2 (en) | Framework to facilitate data access | |
| US11995132B2 (en) | Systems and methods for visualizing posting data and facilitating posting communications | |
| Zhao et al. | Developing GIS Tools to Integrate MCDM models for the analysis of bank branch closures | |
| US11928109B2 (en) | Integrative configuration for bot behavior and database behavior | |
| AU2021105889A4 (en) | Aggregated Security Information And Automation System For Diverse Cloud Business Systems | |
| US20220148080A1 (en) | Systems and methods for geo mapping | |
| CN107111839A (en) | System and method for the universal identification of the credit related data in multiple country-specific data storehouses | |
| CN114218399A (en) | Information recommendation method, device and equipment based on knowledge graph and storage medium |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190222 |