CN102663044A - Method and device for creating search base and method and device for full-text search with authorities - Google Patents
Method and device for creating search base and method and device for full-text search with authorities Download PDFInfo
- Publication number
- CN102663044A CN102663044A CN2012100869427A CN201210086942A CN102663044A CN 102663044 A CN102663044 A CN 102663044A CN 2012100869427 A CN2012100869427 A CN 2012100869427A CN 201210086942 A CN201210086942 A CN 201210086942A CN 102663044 A CN102663044 A CN 102663044A
- Authority
- CN
- China
- Prior art keywords
- information
- authority
- database
- search
- client
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Storage Device Security (AREA)
Abstract
The invention discloses a method and a device for creating a search base and a method and a device for full-text search with authorities. The method for creating the search base includes creating a database recording correlation of identifiers for identities of members and authorities of the member; and creating a retrieval database recording correlation of the authorities of the members and information owners. By the aid of the method and the device for creating the search base and the method and the device for full-text search with the authorities, problems that an existing search base of the prior art is high in cost and are inconvenient, various unnecessary inquiry errors can be caused due to frequent change of the existing search base, and the like are solved. In addition, as subordination relation of information under realistic conditions are changed easily or are not changed in a large scale easily, subordination of the information is stored in the search base, probability of recreating retrieval in a large scale is reduced, cost is lowered, resources are saved, and time is saved for development personnel.
Description
Technical field
The present invention relates to the data search field, relate in particular to a kind of method for building up and device of search library, the full-text search and the device of cum rights limit.
Background technology
In the full-text search that existing common cum rights is limit; Generally be when creating the index process; Utilize every information to go index to have the people of this information authority visit; Then when the people with the visit of this information authority wherein a user carries out full-text search the time, the philtrum that system filtration goes out to have this information authority visit comprises this user's information, and information is represented to this user.
The process of people's index in this information that will have the visit of information authority in the prior art is roughly as follows; Suppose that a lot of information belong to A department; And three A1, A2, A3 member are arranged at present; So " can read the people " field of these information with regard to index everyone of A department, the index database tables of data is as follows:
Sequence number | Title | Content | Can read the people |
1 | Have a holiday or vacation New Year's Day | Had a holiday or vacation New Year's Day 3 days | A1、A2、A3 |
2 | Have a holiday or vacation the Spring Festival | Had a holiday or vacation the Spring Festival 7 days | A1、A2、A3 |
If A department adds a new person A4, so just need add the new person field that the authority people is arranged to these information index again.The index database tables of data need become:
Sequence number | Title | Content | Can read the people |
1 | Have a holiday or vacation New Year's Day | Had a holiday or vacation New Year's Day 3 days | A1、A2、A3、A4 |
2 | Have a holiday or vacation the Spring Festival | Had a holiday or vacation the Spring Festival 7 days | A1、A2、A3、A4 |
As above be not difficult to find out; When the departmental staff changes; All information of this department index of all need reforming, and certain departmental staff's change is more recurrent thing, this just causes the regular index of reforming of needs; Cost is higher and inconvenient, and the regular change of index database also can cause many unnecessary inquiry errors.
Summary of the invention
The technical matters that the present invention mainly solves provides a kind of method for building up and device of search library, the full-text search and the device of cum rights limit; Through in index database, preserving the subordinate of this information; And, reduce the probability of large-scale reconstruction index because subordinate relation is difficult for change or is not prone to extensive change.
For solving the problems of the technologies described above, the technical scheme that the present invention adopts is: a kind of method for building up of search library is provided, may further comprise the steps:
Set up database, said data-base recording has the incidence relation of member's identity indications and member's authority;
Set up index database, said index database records member's authority and information owner's incidence relation.
For solving the problems of the technologies described above, another technical scheme that the present invention adopts is: a kind of text searching method of cum rights limit is provided, may further comprise the steps:
S1, the search key that receives the client submission and member's identity indications;
S2, in the database that presets, inquire about member's authority of said member's correspondence according to said key word of submitting to and member's identity indications;
Filter information in S3, the index database that presetting according to said key word and member's authority of in the database that presets, inquiring;
S4, will return to said client, and show through said client through the information after the above-mentioned screening.
Wherein, said member has different member's authorities.
For solving the problems of the technologies described above, another technical scheme that the present invention adopts is: a kind of apparatus for establishing of search library is provided, comprises:
The first establishment unit is used to set up database, and said data-base recording has the incidence relation of member's identity indications and member's authority;
The second establishment unit is used to set up index database, and said index database records member's authority and information owner's incidence relation.
For solving the problems of the technologies described above, another technical scheme that the present invention adopts is: a kind of full-text search device of cum rights limit is provided, comprises:
Receiving element is used to receive the key word of client submission and member's identity indications;
First search unit is used for inquiring about the corresponding member's authority of said member according to said key word of submitting to and member's identity indications at the database that is presetting;
Second search unit, be used for according to said key word and in the index database that member's authority that the database that presets inquires is presetting filter information;
Return the unit, be used for the information after above-mentioned screening is returned to said client, and show through said client.
Wherein, said member has different member's authorities.
The invention has the beneficial effects as follows: be different from the prior art when the departmental staff changes; All information of this department index of all need reforming; And certain departmental staff's change is more recurrent thing, and this just causes the regular index of reforming of needs, and cost is higher and inconvenient; The regular change of index database also can cause many unnecessary inquiry errors; The present invention provides a kind of method for building up and device of search library, the full-text search and the device of cum rights limit, when personnel's change of certain department, only need to the incidence relation of member's in the database identity indications and member's authority do a spot of increase, deletion action gets final product; Index database need not to do any change; The regular index database of reforming must be in prior art has solved effectively and exists cost higher and inconvenient in the prior art, and the regular change of index database also can cause many unnecessary problems such as inquiry error; And because the subordinate relation of information is difficult for change or is not prone to extensive change in the reality,, reduce the probability of large-scale reconstruction index, reduced cost, practiced thrift resource and developer's time through in index database, preserving the subordinate of information.
Description of drawings
Fig. 1 is the method for building up process flow diagram of search library of the present invention;
Fig. 2 is the apparatus for establishing figure of search library of the present invention;
Fig. 3 is the method flow diagram of the full-text search of cum rights limit of the present invention;
Fig. 4 is the embodiment process flow diagram of method of the full-text search of cum rights of the present invention limit;
Fig. 5 is the embodiment process flow diagram of method of the full-text search of cum rights of the present invention limit;
Fig. 6 is a specific embodiment process flow diagram provided by the invention;
Fig. 7 is the installation drawing of the full-text search of cum rights limit of the present invention;
Fig. 8 is an embodiment device figure of the full-text search of cum rights limit of the present invention.
Embodiment
By specifying technology contents of the present invention, structural attitude, realized purpose and effect, give explanation below in conjunction with embodiment and conjunction with figs. are detailed.
See also Fig. 1, the present invention is for solving the problems of the technologies described above, and the technical scheme that the present invention adopts is: a kind of method for building up of search library is provided, may further comprise the steps:
Set up database, said data-base recording has the incidence relation of member's identity indications and member's authority;
Set up index database, said index database records member's authority and information owner's incidence relation.
In above-mentioned, " setting up database " and " setting up index database " two steps also can be to set up index database earlier to set up database more in no particular order, also can be that two steps are carried out simultaneously.
Be the technique effect of understanding method provided by the invention better and reaching, said process at length be described below in conjunction with concrete embodiment.
1. create database, be used to preserve first contingency table (incidence relation) of user name (being member's identity indications) and the residing department of user (being member's authority), as shown in the table:
User name | Department |
A | Research and development centre |
A | Logistics Department |
B | Research and development centre |
When a user is in a plurality of department (authority) with a plurality of departments, will in this table, preserve many records, as above the A in the table has the authority of research and development centre and Logistics Department, in this table, just has two records about A.
2. create index database, preserve member's authority and owner's second contingency table (incidence relation).
With the notice is example, and notice generally comprises title and content field, and these notices issue by department, if certain member will can't see the notice of " research and development centre " department not under " research and development centre " department.In index database, increase the field (being the information subordinate field) of " affiliated function " now, be used to deposit the affiliated department (department of information subordinate just) of this notice.When a notice and an employee belong to certain department; This employee just can be seen this notice so; As the B in first contingency table has the authority of " research and development centre " 1., and article one notice also belongs to " research and development centre " in the following table, and then this notice can be retrieved by employee B; But second and third notice belongs to " Logistics Department ", and these two notices then cannot be retrieved by employee B so.
Sequence number | Title | Content | Affiliated function |
1 | Have a holiday or vacation New Year's Day | Had a holiday or vacation New Year's Day 3 days | Research and development centre |
2 | Have a holiday or vacation the Spring Festival | Had a holiday or vacation the Spring Festival 7 days | Logistics Department |
3 | Year-end meeting | Year-end can * hold the moon * day | Logistics Department |
As " research and development centre " the employee C that newly arrived; Then in first contingency table, increase a record (user name: C, department:, should " B " leave research and development centre together research and development centre); The 3rd record (user name: B with first contingency table; Department: research and development centre) deletion gets final product, personnel's change, and index database need not to do any change.So when personnel's change of certain department; Only need done a spot of increase at first contingency table, deletion action gets final product; The regular index database of reforming must be in prior art; Solved effectively and exist cost higher and inconvenient in the prior art, the regular change of index database also can cause many unnecessary problems such as inquiry error; And because the subordinate relation of information is difficult for change or is not prone to extensive change in the reality,, reduce the probability of large-scale reconstruction index, reduced cost, practiced thrift resource and developer's time through in index database, preserving the subordinate of information.
Here; Information subordinate (subordinate of information) refers to the member who has the reading information authority, information owner just, such as: suppose that certain information is a notice; And this notice has only the people of Finance Department just can see, this notice (information) just is subordinated to Finance Department so.
The above-mentioned flow process of mentioning can use the apparatus for establishing of search library as shown in Figure 2 to realize that device comprises described in the figure:
The first establishment unit is used to set up database, and said data-base recording has the incidence relation of member's identity indications and member's authority;
The second establishment unit is used to set up index database, and said index database records member's authority and information owner's incidence relation.
See also Fig. 3 to Fig. 5, for solving the problems of the technologies described above, another technical scheme that the present invention adopts is: a kind of text searching method of cum rights limit is provided, may further comprise the steps:
S1, the key word that receives the client submission and member's identity indications;
S2, in the database that presets, inquire about member's authority of said member's correspondence according to said key word of submitting to and member's identity indications;
Filter information in S3, the index database that presetting according to said key word and member's authority of in the database that presets, inquiring;
S4, will return to said client, and show through said client through the information after the above-mentioned screening.
A series of execution in step after the above-mentioned identity indications that receives key word that client submits to and member for service end.In a concrete embodiment, step S1 specifically accomplishes through following steps:
S11, said client are provided with input frame, receive outside search key of submitting to and member's identity indications;
S12, said client are sent said key word and member's identity indications to service end;
S13, said service end receive said key word and member's identity indications.
Step S4 specifically accomplishes through following steps:
S41, said service end will return to said client through the information after the above-mentioned screening;
S42, said client receive said information after above-mentioned screening;
S43, said client are provided with display box, and said tabulation through the information after the above-mentioned screening is shown in said display box.
In one embodiment of this invention, said member has different member's authorities.As A in first contingency table authority of research and development centre and Logistics Department is arranged, in this table, just have two records so about A.
See also Fig. 6, preceding two steps are the processes of setting up of search library among Fig. 6, and preamble is described, and repeats no more at this, and following mask body is set forth the text searching method of cum rights limit provided by the invention.
In a concrete embodiment; When the user uses method provided by the invention to carry out retrieval and inquisition; Can be in the input frame of client setting input institute key word and the user name (key word and member's identity indications) that will inquire about, the input frame interface cardinal principle of client setting is like following table:
After the user imported completion and clicks " search " button, client received key word and the user name (having a holiday or vacation and A) that the user submits to, and sent key word and user name to service end.
After service end receives the key word and user name that client sends over, according to finding the department that the user has in first contingency table of user name in 1..Preceding text show; Key word and user name that the user submits to are respectively " having a holiday or vacation " and " A "; Just the party A-subscriber retrieves " having a holiday or vacation " this key word; Inquire the authority that A employee has " research and development centre " and " Logistics Department " these two departments in first contingency table of service end from 1., the result who obtains after the retrieval is: " affiliated function: research and development centre, Logistics Department, key word: have a holiday or vacation ".
After said process is accomplished; Service end is searched in index database and filter information according to member's authority and key word again: the above-mentioned result that retrieval obtains in database is " affiliated function: research and development centre, Logistics Department; key word: have a holiday or vacation ", and search " affiliated function " is the information that " research and development centre " perhaps comprises " having a holiday or vacation " this key word in " Logistics Department " and title or the content in second contingency table in 2. like this.Can find that these two of 1,2 in index database second contingency tables satisfy condition.
Service end turns back to user interface through above-mentioned filter information and after being met the information list of condition with the information list content, and the user can see as shown in the table substantially:
Through said process, just accomplished the full-text search process of a cum rights limit.
See also Fig. 7 and Fig. 8, the method flow of the composition retrieval of above-mentioned cum rights limit can use the full-text search device of cum rights limit as shown in Figure 7 to realize that said device comprises:
Receiving element is used to receive the key word of client submission and member's identity indications;
First search unit is used for inquiring about the corresponding member's authority of said member according to said key word of submitting to and member's identity indications at the database that is presetting;
Second search unit, be used for according to said key word and in the index database that member's authority that the database that presets inquires is presetting filter information;
Return the unit, be used for the information after above-mentioned screening is returned to said client, and show through said client.
In a concrete embodiment, said receiving element comprises:
Client first receives subelement, is used to be provided with input frame, receives outside key word of submitting to and member's identity indications;
Client is sent subelement, is used for sending to service end said key word and member's identity indications;
Service end receives subelement, is used to receive said key word and member's identity indications.
The said unit that returns comprises:
Service end is sent subelement, is used for the information after above-mentioned screening is returned to said client;
Client second receives subelement, is used to receive said information after above-mentioned screening;
Client shows subelement, is used to be provided with display box, and said tabulation through the information after the above-mentioned screening is shown in said display box.
Wherein, said member has different member's authorities.
In sum, be different from the prior art when the departmental staff changes all information of this department index of all need reforming; And certain departmental staff's change is more recurrent thing, and this just causes the regular index of reforming of needs, and cost is higher and inconvenient; The regular change of index database also can cause many unnecessary inquiry errors; The present invention provides a kind of method for building up and device of search library, the full-text search and the device of cum rights limit, when personnel's change of certain department, only needs get final product member's in the database the identity indications and the incidence relation of member's authority; Index database need not to do any change; The regular index database of reforming must be in prior art has solved effectively and exists cost higher and inconvenient in the prior art, and the regular change of index database also can cause many unnecessary problems such as inquiry error; And because the subordinate relation of information is difficult for change or is not prone to extensive change in the reality,, reduce the probability of large-scale reconstruction index, reduced cost, practiced thrift resource and developer's time through in index database, preserving the subordinate of information.
The above is merely embodiments of the invention; Be not so limit claim of the present invention; Every equivalent structure transformation that utilizes instructions of the present invention and accompanying drawing content to be done, or directly or indirectly be used in other relevant technical fields, all in like manner be included in the scope of patent protection of the present invention.
Claims (6)
1. the method for building up of a search library is characterized in that, may further comprise the steps:
Set up database, said data-base recording has the incidence relation of member's identity indications and member's authority;
Set up index database, said index database records member's authority and information owner's incidence relation.
2. the text searching method of a cum rights limit is characterized in that, may further comprise the steps:
S1, the search key that receives the client submission and member's identity indications;
S2, in the database that presets, inquire about member's authority of said member's correspondence according to said key word of submitting to and member's identity indications;
Filter information in S3, the index database that presetting according to said key word and member's authority of in the database that presets, inquiring;
S4, will return to said client, and show through said client through the information after the above-mentioned screening.
3. the text searching method of cum rights limit according to claim 2, it is characterized in that: said member has different member's authorities.
4. the apparatus for establishing of a search library is characterized in that comprising:
The first establishment unit is used to set up database, and said data-base recording has the incidence relation of member's identity indications and member's authority;
The second establishment unit is used to set up index database, and said index database records member's authority and information owner's incidence relation.
5. the full-text search device of cum rights limit is characterized in that comprising:
Receiving element is used to receive the key word of client submission and member's identity indications;
First search unit is used for inquiring about the corresponding member's authority of said member according to said key word of submitting to and member's identity indications at the database that is presetting;
Second search unit, be used for according to said key word and in the index database that member's authority that the database that presets inquires is presetting filter information;
Return the unit, be used for the information after above-mentioned screening is returned to said client, and show through said client.
6. the full-text search device of cum rights limit according to claim 5, it is characterized in that: said member has different member's authorities.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2012100869427A CN102663044A (en) | 2012-03-28 | 2012-03-28 | Method and device for creating search base and method and device for full-text search with authorities |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN2012100869427A CN102663044A (en) | 2012-03-28 | 2012-03-28 | Method and device for creating search base and method and device for full-text search with authorities |
Publications (1)
Publication Number | Publication Date |
---|---|
CN102663044A true CN102663044A (en) | 2012-09-12 |
Family
ID=46772535
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN2012100869427A Pending CN102663044A (en) | 2012-03-28 | 2012-03-28 | Method and device for creating search base and method and device for full-text search with authorities |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN102663044A (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106354721A (en) * | 2015-07-14 | 2017-01-25 | 杭州海康威视系统技术有限公司 | Retrieval method and device based on authority |
CN107862098A (en) * | 2017-12-21 | 2018-03-30 | 中通服公众信息产业股份有限公司 | A kind of affiliated partner search method based on full-text search |
CN110674112A (en) * | 2019-09-23 | 2020-01-10 | 北京百分点信息科技有限公司 | Data query method and device and electronic equipment |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101227285A (en) * | 2008-01-29 | 2008-07-23 | 中兴通讯股份有限公司 | System and method for dynamic controlling terminal user authority |
CN101860436A (en) * | 2009-04-08 | 2010-10-13 | 北京博越世纪科技有限公司 | Technology for accurately controlling system user data authority |
CN102063479A (en) * | 2010-12-22 | 2011-05-18 | 北京中电普华信息技术有限公司 | Method and system for controlling data access right |
CN102129539A (en) * | 2011-03-11 | 2011-07-20 | 清华大学 | Data resource authority management method based on access control list |
-
2012
- 2012-03-28 CN CN2012100869427A patent/CN102663044A/en active Pending
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101227285A (en) * | 2008-01-29 | 2008-07-23 | 中兴通讯股份有限公司 | System and method for dynamic controlling terminal user authority |
CN101860436A (en) * | 2009-04-08 | 2010-10-13 | 北京博越世纪科技有限公司 | Technology for accurately controlling system user data authority |
CN102063479A (en) * | 2010-12-22 | 2011-05-18 | 北京中电普华信息技术有限公司 | Method and system for controlling data access right |
CN102129539A (en) * | 2011-03-11 | 2011-07-20 | 清华大学 | Data resource authority management method based on access control list |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106354721A (en) * | 2015-07-14 | 2017-01-25 | 杭州海康威视系统技术有限公司 | Retrieval method and device based on authority |
CN107862098A (en) * | 2017-12-21 | 2018-03-30 | 中通服公众信息产业股份有限公司 | A kind of affiliated partner search method based on full-text search |
CN110674112A (en) * | 2019-09-23 | 2020-01-10 | 北京百分点信息科技有限公司 | Data query method and device and electronic equipment |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106682150B (en) | Information processing method and device | |
O'shaughnessy et al. | Media and society: An introduction | |
US8086592B2 (en) | Apparatus and method for associating unstructured text with structured data | |
US20120054174A1 (en) | Geospatial database integration using business models | |
Southall | Rebuilding the Great Britain Historical GIS, Part 1: Building an indefinitely scalable statistical database | |
US9633095B2 (en) | Extract, transform and load (ETL) system and method | |
Alter et al. | The Intermediate Data Structure (IDS) for longitudinal historical microdata, version 4 | |
WO2011091708A1 (en) | Method for multi-dimensional database storage and inquiry | |
US20080172393A1 (en) | System and Method for Public Access and Control of MLS Data | |
CN101963993B (en) | Method for fast searching database sheet table record | |
CN102663044A (en) | Method and device for creating search base and method and device for full-text search with authorities | |
US20060282278A1 (en) | Determination of an entity's assets associated with an event | |
Cigánek | Design and implementation of open-data data warehouse | |
CN112416992A (en) | Industry type identification method, system and equipment based on big data and keywords | |
Goldstein et al. | Identifiers for earth science data sets: Where we have been and where we need to go | |
Sladić et al. | Cadastral records in Serbian land administration | |
CN105653593A (en) | Intellectual property data management system and sharing method based on social friends | |
CN110851431A (en) | Data processing method and device for data center station | |
CN110704421A (en) | Data processing method, device, equipment and computer readable storage medium | |
Kuria20 et al. | A prototype digital cadastral information system for the survey of Kenya | |
CN110990748B (en) | Public opinion data collection and release system | |
Hawkins | Updates on Program for Cooperative Cataloging (PCC) linked data task groups | |
Ganczar | The infrastructure of spatial information as an example of opening public sector data in Poland | |
Rob et al. | Information gems from criminal mines: A data warehouse case study focusing on big-city criminal activity | |
Hughes | Keeping track: the importance of the field label on bottled specimens and matters arising |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20120912 |