CN108021627A - The storage method and device of associated data - Google Patents
The storage method and device of associated data Download PDFInfo
- Publication number
- CN108021627A CN108021627A CN201711172972.9A CN201711172972A CN108021627A CN 108021627 A CN108021627 A CN 108021627A CN 201711172972 A CN201711172972 A CN 201711172972A CN 108021627 A CN108021627 A CN 108021627A
- Authority
- CN
- China
- Prior art keywords
- attribute information
- incidence relation
- data
- user
- querying condition
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
This application discloses the storage method and device of a kind of associated data, it is related to technical field of data processing, data space can be greatly decreased, lifts the operation efficiency of database.The described method includes：Obtaining needs operation associated entity table, and record has different attribute informations in the entity table；The inquiry request sent according to user determines the incidence relation in the entity table between each attribute information, and user is carried in the inquiry request to be needed to obtain the querying condition of data；Need to obtain the querying condition of data as inquiry field using the user, create the view of the incidence relation between each attribute information, and preserve the view of establishment.The application is suitable for the storage of associated data.
Description
Technical field
The present invention relates to technical field of data processing, particularly with regard to the storage method and device of associated data.
Background technology
With the fast development of computer and internet, all trades and professions can all produce more than one hundred million datas daily, even more,
How using these data for the strategic decision and follow-up developments of enterprise provide data support to play in enterprise development to
Close important effect.For the shopping website for possessing hundred million users and shiploads of merchandise, the process of target group is being searched
In, it is necessary to reference to substantial amounts of historical data, for example, user once paid close attention to brand, browsed commodity, averagely buy commodity
The user's history behavioral data such as purchase again is not bought or bought to price, which articles storage.And these history numbers
Attributes different according to this is dispersed in the various fields of entity table, when carrying out data search, it is necessary to each category by entity table
Property carries out substantial amounts of operation associated, could obtain target group.
The prior art by each attribute field of tables of data during operation is associated, the association of each step generation
As a result it can all be preserved with an interim table, and then the interim table of generation and entity table are stored into database.However,
The more situation of data, the operation associated of each field can also increase therewith in the tables of data being related to so that generation it is interim
Table quantity is excessive, takes storage resource, and the operational efficiency of image database.
The content of the invention
An embodiment of the present invention provides the storage method and device of associated data, solves interim table in correlation technique and takes
The problem of memory space.
One side according to embodiments of the present invention, there is provided a kind of storage method of associated data, including：Acquisition needs to close
Join the entity table of operation, record has different attribute informations in the entity table；Institute is determined according to the inquiry request that user sends
The incidence relation between each attribute information in entity table is stated, user is carried in the inquiry request to be needed to obtain looking into for data
Inquiry condition；Need to obtain the querying condition of data as inquiry field using the user, create the association between each attribute information
The view of relation, and preserve the view of establishment.
Further, the inquiry request sent according to user determines the pass in the entity table between each attribute information
Connection relation includes：Being filtered out according to the querying condition from the entity table needs associated attribute information；With the screening
It is relation node to go out to need associated attribute information, determines the incidence relation between each attribute information.
Further, the querying condition includes multiple levels, has incidence relation between the querying condition in each level,
It is described to need associated attribute information to determine the incidence relation bag between each attribute information as relation node using described filter out
Include：Using the querying condition of each level as relation node, each level is filtered out from the entity table needs associated attribute
Information；Associated attribute information is needed according to each level, establishes the incidence relation between each attribute information.
Further, the incidence relation between each attribute information is tree structure, described to need to obtain with the user
The querying condition for evidence of fetching is inquiry field, and creating the view of the incidence relation between each attribute information includes：From the use
Family needs to extract the inquiry field for the incidence relation being related between each attribute information in the querying condition of acquisition data；With institute
The relation node that inquiry field is tree structure is stated, creates the view of the incidence relation between each attribute information.
Further, need to obtain the querying condition of data as inquiry field using the user described, create each attribute
The view of incidence relation between information, and after preserving the view of establishment, the method further includes：Receive looking into for user's transmission
Request is ask, searches the query result number with incidence relation from the entity table according to the inquiry field stored in the view
According to.
Another aspect according to embodiments of the present invention, there is provided a kind of storage device of associated data, including：Acquiring unit,
Operation associated entity table is needed for obtaining, record has different attribute informations in the entity table；Determination unit, for root
The inquiry request sent according to user determines incidence relation in the entity table between each attribute information, in the inquiry request
Carrying user needs to obtain the querying condition of data；Creating unit, for needing to obtain the inquiry bar of data with the user
Part is inquiry field, creates the view of the incidence relation between each attribute information, and preserve the view of establishment.
Further, the determination unit includes：Screening module, for being sieved according to the querying condition from the entity table
Selecting needs associated attribute information；Determining module, for needing associated attribute information as relation node using described filter out,
Determine the incidence relation between each attribute information.
Further, the querying condition includes multiple levels, has incidence relation between the querying condition in each level；
The determining module, specifically for using the querying condition of each level as relation node, being filtered out from the entity table each
Level needs associated attribute information；The determining module, is specifically additionally operable to need associated attribute information according to each level,
Establish the incidence relation between each attribute information.
Further, the incidence relation between each attribute information is tree structure, and the creating unit includes：Extraction
Module, extracts the association that is related between each attribute information in the querying condition for needing to obtain data from the user and closes
The inquiry field of system；Creation module, for using the inquiry field as the relation node of tree structure, creating each attribute information
Between incidence relation view.
Further, described device further includes：Searching unit, for receiving the inquiry request of user's transmission, regards according to described
The inquiry field stored in figure searches the query result data with incidence relation from the entity table.
By the present invention, need to obtain the querying conditions of data using user to inquire about field, create each attribute information it
Between incidence relation view, and preserve the view of establishment to substitute entity table, reduce the occupancy of data space, at the same time
It also retains the incidence relation between data.Associated with whole associated datas in the prior art with what entity sheet form was stored
The storage method of data is compared, and the embodiment of the present invention is used as pass by the use of the incidence relation between each attribute information in associated data
Set section point, while basic entity table is preserved, has cast out associated interim table between entity table, remains between entity table
The querying condition of incidence relation, creates view by inquiring about field with querying condition, interim table is substituted by view, is improved
The storage speed of data, ensure that the operational efficiency of database.
Brief description of the drawings
Attached drawing described herein is used for providing a further understanding of the present invention, forms the part of the application, this hair
Bright schematic description and description is used to explain the present invention, does not form inappropriate limitation of the present invention.In the accompanying drawings：
Fig. 1 is the flow chart one of the storage method of associated data according to embodiments of the present invention；
Fig. 2 is the flowchart 2 of the storage method of associated data according to embodiments of the present invention
Fig. 3 is the structure diagram one of the storage device of associated data according to embodiments of the present invention；
Fig. 4 is the structure diagram two of the storage device of associated data according to embodiments of the present invention.
Embodiment
Come that the present invention will be described in detail below with reference to attached drawing and in conjunction with the embodiments.It should be noted that do not conflicting
In the case of, the feature in embodiment and embodiment in the application can be mutually combined.
A kind of storage method of associated data is provided in the present embodiment, and Fig. 1 is association according to embodiments of the present invention
The flow chart one of the storage method of data, as shown in Figure 1, the flow includes the following steps：
Step S101, obtaining needs operation associated entity table；
Wherein, entity table is the table of corresponding practical object, and record has different attribute informations, as user name, age of user,
User's gender etc., it is necessary to explanation, when tables of data is created, if indicated without special, the tables of data created
It is one of most important part in database in tables of data for entity table, for example, in Education Administration Information System, teaching management
In database comprising respectively surround particular topic 6 tables of data, Jiao Shibiao, curriculum schedule, list of results, class's table and table of giving lessons,
For information such as management drop loss process middle school student, classroom, courses.Each independent tables of data in certain database passes through foundation
Relation is coupled, and such as the tables of data associated with teacher A has class's table, also has the list of results etc. of the class.
For the embodiment of the present invention, each tables of data is respectively provided with incidence relation in database, in order to avoid data input mistake
By mistake, and database efficient operation can be made, Data Sheet Design should classify information according to certain principle, while to ensure to count
According to the reasonability of table structure, usually ensure that a table surrounds a theme, makes tables of data easily safeguard, for example, by teacher
Essential information is stored in teacher's table, if these information are stored in table of giving lessons, delete certain teacher give lessons information when
May together it be deleted together with teacher's essential information.
In the present embodiment, operation associated entity table is needed by obtaining, is being needed the entity table with incidence relation
When being associated, subsequent operation can be carried out based on the entity table stored in database, while be also convenient for subsequently from entity table
It is middle to search the data with incidence relation.
Step S102, the inquiry request sent according to user determine the association in the entity table between each attribute information
Relation；
Wherein, the inquiry request that user sends needs to inquire about the data in tables of data for user, and is taken in inquiry request
Need to obtain the querying condition of data with user, it is women to need to inquire about gender attribute information such as user, and age attribute
Information is data after 80s, and either user needs to inquire about purchase attribute information to buy Gree Electric Appliances or browsing attribute letter
Cease, without limiting, can be single querying condition, such as look into for the data of browsed Gree Electric Appliances, the present invention to querying condition
Ask the data of some attribute information, or the combination of multiple queries condition, as inquiry meets multiple attribute information intersections
Data, or inquiry meet the data of multiple attribute information unions.
For the embodiment of the present invention, the incidence relation between each attribute information can be one-to-one association, one-to-many pass
Connection or multi-to-multi association, for example, the entity table that mainly includes of Employee Profile management system project have Basic Information Table, department table,
Project team's table, bank card table, the incidence relation between each attribute information in these entity tables have：Each employee necessarily corresponds to
Employee Profile data, belongs to one-one relationship, each employee can have multiple bank cards, but each bank card is only possible to belong to one
A employee, belongs to one-to-many relation, and each employee can have more zooids at the same time in multiple project team, each project team at the same time
Work, belongs to many-to-many relationship, just can be to the entity table with incidence relation after the incidence relation of each attribute information is analyzed
It is associated operation.
In embodiments of the present invention, by determining the incidence relation in entity table between each attribute information, it will be appreciated that
Data interdepend and influence relation between entity table in database, and then facilitate the user to carry out data search.
Step S103, needs to obtain the querying condition of data as inquiry field using the user, creates each attribute information
Between incidence relation view, and preserve the view of establishment.
Since user needs to obtain data generally obtained by the operation associated entity table of needs is associated after operation
Inquiry data, so querying condition can be used as the inquiry field of associated entity table, for example, there is record in entity table 1
Teacher A corresponds to the attribute information of student's numbering, and entity table 2 records the information for having student, and it is teacher couple that user, which needs to obtain data,
Student information is answered, then teacher A is corresponded into student information as inquiry field, for the embodiment of the present invention, different querying conditions
Can there can also be relationship between superior and subordinate between certain querying condition as different inquiry fields, further create elder brother and belong to
The view of incidence relation between property information.
For the embodiment of the present invention, can be used for searching from database using the incidence relation between each attribute information
Corresponding data, in the prior art when inquiring about corresponding data, can be associated operation by the entity table with incidence relation, raw
The data that user needs to inquire about are got after into interim table, and the embodiment of the present invention need not generate interim table, but will need to close
The inquiry field of connection operation is stored in view, when inquiring about corresponding data, by the inquiry field that is stored in view come from tool
The data that user needs to inquire about are obtained in relevant data.
A kind of storage method of associated data provided in an embodiment of the present invention, needs to obtain the querying condition of data with user
To inquire about field, the view of the incidence relation between each attribute information is created, and preserves the view of establishment to substitute entity table,
Reduce the occupancy of data space, while also retains the incidence relation between data.With all associating in the prior art
The storage method for the associated data that data are stored with entity sheet form is compared, and the embodiment of the present invention utilizes each in associated data
Incidence relation between a attribute information is as relation node, while basic entity table is preserved, cast out entity table it
Between associated interim table, remain the querying condition of incidence relation between entity table, created by inquiring about field with querying condition
View, interim table is substituted by view, improves the storage speed of data, ensure that the operational efficiency of database.
Fig. 2 is the flowchart 2 of the storage method of associated data according to embodiments of the present invention, as shown in Fig. 2, the flow
Include the following steps：
Step S201, obtaining needs operation associated entity table；
In the database, usually including multiple entity tables, nor mutually independent, different reality between these entity tables
Need to establish a kind of incidence relation between body surface, for example, in the family of relationship type, you are many there are this together with other members
Relation, you and your mother are related, you only have a mother, but your mother might have several children, you
There is relation with your fraternal elder sisters, you there may be many siblings.There is incidence relation could be by the data between entity table
Communicate with each other, and in this communication process, it is necessary to there is an attribute information in entity table as mark, different records pair
The attribute information value answered cannot be identical, can not be blank, can be distinguished respectively by value different in this attribute information
Bar records, and just as we distinguish different people, everyone has name, but it cannot function as major key, because name is easy to
Duplicate, and identification card number is that everyone is different, it is possible to different people is distinguished according to it, in the table of database
Field as major key will be as the identification card number of people, it is necessary to be each record value it is different, this could be according to major key
Value determine different records.
,, can not there are the incidence relation of multiple entity tables during actual data storage for the embodiment of the present invention
The required data of user can be inquired in an entity table, if without operation associated between entity table, are needed very
More inquiry operations could be realized, for example, it is desired to which restrictive condition is inquired about from A tables to inquire about data from B tables, it is necessary to two
Table carries out inquiry operation, influences running efficiency of system.
Step S202, being filtered out according to the querying condition from the entity table needs associated attribute information；
In design relation type database, most important part work is that have how each attribute information is assigned to
In the entity table of incidence relation.Once the distribution to these attribute informations is completed, for the operation associated general between entity table
Dependent on associated attribute information is needed, by needing associated attribute information, it is possible to operation associated entity table will be needed
Linked together by certain significant mode.For example, if you do not know which user has played order, then individually order
Single information is no any use.But you are not necessarily in same tables of data while store customer and sequence information.
You can store Customer Information and sequence information respectively in two relation database tables, and such Customer Information and sequence information are with regard to phase
When in needing associated attribute information, then using the incidence relation between two tables of data, can checking at the same time in tables of data
Each order and its relevant customer information.If normalized entity table is the basis of relevant database, then
It is operation associated between these tables of data, it is to establish these basic foundation stones.
For the embodiment of the present invention, it is necessary to which associated attribute information is associated the tie of operation, example equivalent to entity table
Record has the name and student number attribute of student such as in entity table a, and the student number and achievement attribute for having student are recorded in entity table b,
Here student number attribute is to need associated attribute information between entity table a and entity table b.
Need associated attribute information by filtering out, using need associated attribute information as tie progress entity table it
Between it is operation associated, ensure between entity table it is operation associated very big flexibility can be brought to user, effective improve is looked into
Ask efficiency.
Step S203, needs associated attribute information as relation node using described filter out, determine each attribute information it
Between incidence relation；
Due to tie operation associated between associated equivalent to the two entity tables of attribute information of needs, further with screening
Go out to need associated attribute information to determine to record user in the incidence relation between attribute information, such as table a as relation node
Name and the recent purchase information of user, table 2 record user name and the essential information of user, need exist for associated attribute letter
Cease for user name, the incidence relation between each attribute information is user name and user basic information is one-one relationship, user
The name purchase information recent with user can be one-one relationship or many-one relationship, will can further be used by user name
The essential information at the family purchase information association recent with user is got up.
It should be noted that the incidence relation between above-mentioned each attribute information can be according to actual queries demand come really
It is fixed, if query demand is the friendship that age attribute in user basic information buys with user a certain item property in information in the recent period
Collection, then the incidence relation between above-mentioned each attribute information for age attribute and a certain item property intersection incidence relation, such as
Query demand is that the age attribute in user basic information buys purchase A item properties in information with user in the recent period or user is near
Phase browses the intersection that A item properties are browsed in information, then the incidence relation between above-mentioned each attribute information is purchase A commodity categories
Property with browsing the unions of A item properties, afterwards with the incidence relation of age attribute intersection, the embodiment of the present invention is to each attribute information
Between incidence relation without limit.
Step S204, extracts and is related between each attribute information in the querying condition for needing to obtain data from the user
Incidence relation inquiry field；
Wherein, querying condition includes multiple levels, has incidence relation, usual feelings between the querying condition in each level
Under condition in the querying condition correspondent entity table of different levels different levels attribute information, as the product place of production attribute information in have
State is attribute, province attribute and City attribution, has a year attribute, moon attribute and day attribute, high-level in time attribute information
The corresponding value range of attribute information it is usually less and limited, the querying condition of corresponding high-level, it is attribute such as to inquire about state, state
National negligible amounts included in attribute, the corresponding value range of attribute information of low-level is usually more and unlimited, right
The querying condition of low-level is answered, such as inquires about City attribution, city numbers included in City attribution are more.
For the embodiment of the present invention, it is related to the inquiry field of incidence relation between each attribute information usually from inquiry bar
The multiple attribute keywords detached in part, for example, querying condition for students' genders female, average mark more than 90, then extract
Inquiry field is gender, female, average mark, 90, during certainly for the querying condition for being related to multi-layer, in the inquiry field extracted
It is also possible that the attribute keywords of repetition, the embodiment of the present invention is to inquiring about the form of field without limiting.
Step S205, using the inquiry field as the relation node of tree structure, creates the pass between each attribute information
The view of connection relation, and the view of storage creation；
For the embodiment of the present invention, the incidence relation between each attribute information can be tree structure, each leaf section
An attribute information in point presentation-entity table, due to the category that inquiry field is the incidence relation being related between each attribute information
Property keyword, further to inquire about relation node of the field as tree structure, creates the incidence relation between each attribute information
View, and then by between each attribute incidence relation preserve in the view.
For the embodiment of the present invention, the side for being preserved the incidence relation between each attribute information by creating view
Formula, without interim table of the preservation after operation associated, eliminates the storage that interim table takes without calculating attribute information
Space, is only preserved the incidence relation between each attribute information in entity table in the form of logical formula.
Step S206, receives the inquiry request that user sends, according to the inquiry field stored in the view from the reality
The query result data with incidence relation are searched in body surface.
For the embodiment of the present invention, after the view of the incidence relation between creating each attribute information, deposited in view
Stored up the incidence relation between each attribute information, and and indirect storage it is operation associated after interim table, so being used receiving
After the inquiry request that family is sent, it can be searched directly according to the inquiry field stored in the view of establishment from entity table with pass
The inquiry data of connection relation, so as to increase substantially efficiency data query.
For example, during reality is stored for the test data that a user is 200,000,000, including 4 entity tables,
Entity table, the side stored after operation is associated according to the incidence relation between each attribute information by 13 attribute informations
Formula, the stored memory for taking database are 21G, and the total consumption time is 39 minutes, and the embodiment of the present invention not to entity table into
The operation associated storage of row, but the incidence relation between each attribute information is stored with view, centre is associated
The process of operation is replaced by view, and the stored memory for taking database is 0.3G, and the total consumption time is 5 minutes, is greatly subtracted
Lack EMS memory occupation in database, improve data storage efficiency.
For the embodiment of the present invention, specific application scenarios can be as follows, but not limited to this, including：Obtaining needs
Associated employee's registration table 1, including attribute information have：Employee number, employee name, employee's gender, the industry number of employee, need
Associated employee's registration table 2, including attribute information is wanted to have：Industry number, the department name of employee is, it is necessary to associated attribute information
For the industry number of employee, using the industry number of employee as relation node, determine the industry number of employee with table 1 and table 2
The incidence relation of each attribute information, and need to extract inquiry field in the querying condition of acquisition data from user for employee's volume
Number, employee name, employee's gender, the industry number of employee, department name, to inquire about relation node of the field as tree structure,
The view of the incidence relation in table 1 and table 2 between each attribute information is created, completes the storage of associated data.When receiving
All employees that the department name that user sends is sales department and employee's gender is women, further store according in view
" department name " and " employee's gender " inquiry field is searched from entity table department name attribute information be sales department with
And employee's gender attribute information is gender woman's data, obtains query result data.
The storage method of another associated data of the embodiment of the present invention, by needing to obtain the inquiry bar of data from user
The inquiry field for the incidence relation being related between each attribute information is extracted in part, to inquire about relation of the field as tree structure
Node, creates the view of the incidence relation between each attribute information, and the view of storage creation, is retained by way of view
The querying condition of incidence relation, reduces the occupancy of data space between entity table, while also retains between data
Incidence relation.
Fig. 3 is the structure diagram one of the storage device of associated data according to embodiments of the present invention, as shown in figure 3, the dress
Put including：
Acquiring unit 31, can be used for obtaining the operation associated entity table of needs, recorded in the entity table have it is different
Attribute information；
Determination unit 32, can be used for determining each attribute information in the entity table according to the inquiry request that user sends
Between incidence relation, user is carried in the inquiry request to be needed to obtain the querying condition of data；
Creating unit 33, can be used for needing to obtain the querying condition of data as inquiry field using the user, creates each
The view of incidence relation between a attribute information, and preserve the view of establishment.
A kind of storage device of associated data provided in an embodiment of the present invention, needs to obtain the querying condition of data with user
To inquire about field, the view of the incidence relation between each attribute information is created, and preserves the view of establishment to substitute entity table,
Reduce the occupancy of data space, while also retains the incidence relation between data.With all associating in the prior art
The storage method for the associated data that data are stored with entity sheet form is compared, and the embodiment of the present invention utilizes each in associated data
Incidence relation between a attribute information is as relation node, while basic entity table is preserved, cast out entity table it
Between associated interim table, remain the querying condition of incidence relation between entity table, created by inquiring about field with querying condition
View, interim table is substituted by view, improves the storage speed of data, ensure that the operational efficiency of database.
As the further explanation of the storage device of associated data shown in Fig. 3, Fig. 4 is pass according to embodiments of the present invention
Join the structure diagram two of the storage device of data, as shown in figure 4, the device further includes：
Searching unit 34, can be used for receiving the inquiry request that user sends, according to the inquiry word stored in the view
Section searches the query result data with incidence relation from the entity table.
Further, the determination unit 32 includes：
Screening module 321, can be used for filtering out the associated category of needs from the entity table according to the querying condition
Property information；
Determining module 322, can be used for, using the associated attribute information of needs that filters out as relation node, determining each
Incidence relation between attribute information.
Further, the querying condition includes multiple levels, between the querying condition in each level there is association to close
System；
The determining module 322, specifically can be used for using the querying condition of each level as relation node, from the entity
Each level is filtered out in table needs associated attribute information；
The determining module 322, specifically can be also used for needing associated attribute information according to each level, establishes each
Incidence relation between attribute information.
Further, the incidence relation between each attribute information is tree structure, and the creating unit 33 includes：
Extraction module 331, can be used for from the user need obtain data querying condition in extract be related to it is each
The inquiry field of incidence relation between attribute information；
Creation module 332, can be used for the relation node using the inquiry field as tree structure, create each attribute letter
The view of incidence relation between breath.
The storage device of another kind associated data provided in an embodiment of the present invention, by needing to obtain looking into for data from user
The inquiry field for the incidence relation being related between each attribute information is extracted in inquiry condition, to inquire about field as tree structure
Relation node, creates the view of the incidence relation between each attribute information, and the view of storage creation, by way of view
The querying condition of incidence relation between entity table is remained, reduces the occupancy of data space, while also retains data
Between incidence relation.
Obviously, those skilled in the art should be understood that above-mentioned each module of the invention or each step can be with general
Computing device realize that they can be concentrated on single computing device, or be distributed in multiple computing devices and formed
Network on, alternatively, they can be realized with the program code that computing device can perform, it is thus possible to which they are stored
Performed in the storage device by computing device, and in some cases, can be with different from shown in order execution herein
The step of going out or describing, they are either fabricated to each integrated circuit modules respectively or by multiple modules in them or
Step is fabricated to single integrated circuit module to realize.Combined in this way, the present invention is not restricted to any specific hardware and software.
The foregoing is only a preferred embodiment of the present invention, is not intended to limit the invention, for the skill of this area
For art personnel, the invention may be variously modified and varied.Within the spirit and principles of the invention, that is made any repaiies
Change, equivalent substitution, improvement etc., should all be included within protection scope of the present invention.
Claims (10)
- A kind of 1. storage method of associated data, it is characterised in that including：Obtaining needs operation associated entity table, and record has different attribute informations in the entity table；The inquiry request sent according to user determines the incidence relation in the entity table between each attribute information, the inquiry User is carried in request to be needed to obtain the querying condition of data；Need to obtain the querying condition of data as inquiry field using the user, create the incidence relation between each attribute information View, and preserve the view of establishment.
- 2. according to the method described in claim 1, it is characterized in that, the inquiry request sent according to user determines the reality Incidence relation in body surface between each attribute information includes：Being filtered out according to the querying condition from the entity table needs associated attribute information；Associated attribute information is needed to determine the incidence relation between each attribute information as relation node using described filter out.
- 3. according to the method described in claim 2, it is characterized in that, the querying condition includes multiple levels, in each level Querying condition between there is incidence relation, it is described that associated attribute information is needed as relation node using described filter out, it is definite Incidence relation between each attribute information includes：Using the querying condition of each level as relation node, each level is filtered out from the entity table needs associated attribute Information；Associated attribute information is needed according to each level, establishes the incidence relation between each attribute information.
- 4. according to the method described in claim 1, it is characterized in that, the incidence relation between each attribute information is tree-like Structure, it is described to need to obtain the querying condition of data as inquiry field using the user, create the pass between each attribute information The view of connection relation includes：The incidence relation that is related between each attribute information is extracted in the querying condition for needing to obtain data from the user Inquire about field；Relation node using the inquiry field as tree structure, creates the view of the incidence relation between each attribute information.
- 5. according to the described method of any one of claim 1-4, it is characterised in that acquisition number is needed with the user described According to querying condition for inquiry field, create the view of the incidence relation between each attribute information, and preserve the view of establishment Afterwards, the method further includes：The inquiry request that user sends is received, being searched according to the inquiry field stored in the view from the entity table has The query result data of incidence relation.
- A kind of 6. storage device of associated data, it is characterised in that including：Acquiring unit, needs operation associated entity table, record has different attribute informations in the entity table for obtaining；Determination unit, the inquiry request for being sent according to user determine the association between each attribute information in the entity table Relation, user is carried in the inquiry request to be needed to obtain the querying condition of data；Creating unit, for needing to obtain the querying condition of data as inquiry field using the user, creates each attribute information Between incidence relation view, and preserve the view of establishment.
- 7. device according to claim 6, it is characterised in that the determination unit includes：Screening module, needs associated attribute information for being filtered out according to the querying condition from the entity table；Determining module, for needing associated attribute information as relation node using described filter out, determine each attribute information it Between incidence relation.
- 8. device according to claim 7, it is characterised in that the querying condition includes multiple levels, in each level Querying condition between there is incidence relation；The determining module, specifically for using the querying condition of each level as relation node, being filtered out from the entity table Each level needs associated attribute information；The determining module, is specifically additionally operable to need associated attribute information according to each level, establish each attribute information it Between incidence relation.
- 9. device according to claim 6, it is characterised in that the incidence relation between each attribute information is tree-like Structure, the creating unit include：Extraction module, extracts and is related between each attribute information in the querying condition for needing to obtain data from the user Incidence relation inquiry field；Creation module, for using the inquiry field as the relation node of tree structure, creating the pass between each attribute information The view of connection relation.
- 10. according to the device any one of claim 6-9, it is characterised in that described device further includes：Searching unit, for receiving the inquiry request of user's transmission, according to the inquiry field stored in the view from the reality The query result data with incidence relation are searched in body surface.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711172972.9A CN108021627A (en) | 2017-11-21 | 2017-11-21 | The storage method and device of associated data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201711172972.9A CN108021627A (en) | 2017-11-21 | 2017-11-21 | The storage method and device of associated data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108021627A true CN108021627A (en) | 2018-05-11 |
Family
ID=62080016
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201711172972.9A Pending CN108021627A (en) | 2017-11-21 | 2017-11-21 | The storage method and device of associated data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108021627A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109241052A (en) * | 2018-07-26 | 2019-01-18 | 山东大学 | A kind of storage method based on associated data, device, medium and equipment |
| CN109271392A (en) * | 2018-10-30 | 2019-01-25 | 长威信息科技发展股份有限公司 | Quick discrimination and the method and apparatus for extracting relevant database entity and attribute |
| CN109284289A (en) * | 2018-09-11 | 2019-01-29 | 深圳市网安计算机安全检测技术有限公司 | Data set processing method, device, computer equipment and storage medium |
| CN109828965A (en) * | 2019-01-09 | 2019-05-31 | 北京小乘网络科技有限公司 | A kind of method and electronic equipment of data processing |
| CN111611322A (en) * | 2019-02-25 | 2020-09-01 | 京东数字科技控股有限公司 | User information correlation method and system |
| CN111752956A (en) * | 2019-03-26 | 2020-10-09 | 华为技术有限公司 | Entity association change method and device and electronic equipment |
| CN114840530A (en) * | 2022-05-26 | 2022-08-02 | 国网江苏省电力有限公司无锡供电分公司 | Multi-element visual data model construction method and system |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102521416A (en) * | 2011-12-28 | 2012-06-27 | 用友软件股份有限公司 | Data correlation query method and data correlation query device |
| CN103617448A (en) * | 2013-12-05 | 2014-03-05 | 用友软件股份有限公司 | Method for immediately analyzing business data |
-
2017
- 2017-11-21 CN CN201711172972.9A patent/CN108021627A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102521416A (en) * | 2011-12-28 | 2012-06-27 | 用友软件股份有限公司 | Data correlation query method and data correlation query device |
| CN103617448A (en) * | 2013-12-05 | 2014-03-05 | 用友软件股份有限公司 | Method for immediately analyzing business data |
Cited By (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109241052A (en) * | 2018-07-26 | 2019-01-18 | 山东大学 | A kind of storage method based on associated data, device, medium and equipment |
| CN109284289A (en) * | 2018-09-11 | 2019-01-29 | 深圳市网安计算机安全检测技术有限公司 | Data set processing method, device, computer equipment and storage medium |
| CN109284289B (en) * | 2018-09-11 | 2022-03-22 | 深圳市网安计算机安全检测技术有限公司 | Data set processing method and device, computer equipment and storage medium |
| CN109271392A (en) * | 2018-10-30 | 2019-01-25 | 长威信息科技发展股份有限公司 | Quick discrimination and the method and apparatus for extracting relevant database entity and attribute |
| CN109828965A (en) * | 2019-01-09 | 2019-05-31 | 北京小乘网络科技有限公司 | A kind of method and electronic equipment of data processing |
| CN109828965B (en) * | 2019-01-09 | 2021-06-15 | 千城数智(北京)网络科技有限公司 | Data processing method and electronic equipment |
| CN111611322A (en) * | 2019-02-25 | 2020-09-01 | 京东数字科技控股有限公司 | User information correlation method and system |
| WO2020173214A1 (en) * | 2019-02-25 | 2020-09-03 | 京东数字科技控股有限公司 | User information association method and system |
| CN111611322B (en) * | 2019-02-25 | 2024-04-09 | 京东科技控股股份有限公司 | User information association method and system |
| CN111752956A (en) * | 2019-03-26 | 2020-10-09 | 华为技术有限公司 | Entity association change method and device and electronic equipment |
| CN111752956B (en) * | 2019-03-26 | 2023-12-08 | 华为技术有限公司 | Entity association change method and device and electronic equipment |
| CN114840530A (en) * | 2022-05-26 | 2022-08-02 | 国网江苏省电力有限公司无锡供电分公司 | Multi-element visual data model construction method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108021627A (en) | The storage method and device of associated data | |
| Kirby-Hawkins et al. | An investigation into the geography of corporate e-commerce sales in the UK grocery market | |
| Argüelles et al. | A new approach to the identification of regional clusters: hierarchical clustering on principal components | |
| US7925658B2 (en) | Methods and apparatus for mapping a hierarchical data structure to a flat data structure for use in generating a report | |
| CN105447184B (en) | Information extraction method and device | |
| US8341101B1 (en) | Determining relationships between data items and individuals, and dynamically calculating a metric score based on groups of characteristics | |
| CN108153824A (en) | The determining method and device of targeted user population | |
| US8972463B2 (en) | Method and apparatus for functional integration of metadata | |
| CN109213771A (en) | Update the method and apparatus of portrait label | |
| Elalfi et al. | Extracting rules from trained neural network using GA for managing E-business | |
| US20150242529A1 (en) | Method for Interlacing Multiple Internet domain names with a Database Driven Website to Obtain Better Webpage Ranking on Major Search Engines by Executing Computer-Executable Instructions Stored On a Non-Transitory Computer-Readable Medium | |
| Lin et al. | Using customer knowledge in designing electronic catalog | |
| CN106960044A (en) | A kind of Time Perception personalization POI based on tensor resolution and Weighted H ITS recommends method | |
| CN111882403A (en) | Financial service platform intelligent recommendation method based on user data | |
| CN103678350B (en) | Social network search result methods of exhibiting and device | |
| CN106095964A (en) | A kind of method that data are carried out visualization filing and search | |
| JP2018026133A (en) | Information providing system and information providing method utilizing physical medium | |
| CN107729330A (en) | The method and apparatus for obtaining data set | |
| CN106250402A (en) | A kind of Website classification method and device | |
| CN106844649A (en) | A kind of waste and old industry commending system based on mixing various modes and its method | |
| CN114357020A (en) | Service scene data extraction method and device, computer equipment and storage medium | |
| Arhas et al. | Social Network Analysis: E-Marketing Sales of “Kue Lebaran” in the Perspective of the Technology Acceptance Model | |
| CN104182226B (en) | A kind of General Mobile information system adaptation method and device | |
| CN112988848B (en) | Data processing method, device, equipment and storage medium | |
| Cardador et al. | Tourist ethnocentrism: A bibliometric analysis based on Web of Science (WoS) |
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: 20180511 |