CN102004800A - Data query method and device of PDM (Product Data Management) system - Google Patents
Data query method and device of PDM (Product Data Management) system Download PDFInfo
- Publication number
- CN102004800A CN102004800A CN 201010610445 CN201010610445A CN102004800A CN 102004800 A CN102004800 A CN 102004800A CN 201010610445 CN201010610445 CN 201010610445 CN 201010610445 A CN201010610445 A CN 201010610445A CN 102004800 A CN102004800 A CN 102004800A
- Authority
- CN
- China
- Prior art keywords
- data
- pdm
- index
- update
- renewal
- 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
Abstract
The invention discloses a data query method and device of a PDM (Product Data Management) system, wherein the data query method of the PDM system comprises the following steps of: acquiring the updating data in the PDM system; updating an index database according to the updating data; and querying the index database in a full-text searching way. The invention can be used for enhancing the data query efficiency of the PDM system.
Description
Technical field
The present invention relates to the querying method and the device of data in a kind of product data management (Product Data Manage abbreviates PDM as) system.
Background technology
The PDM system is typical database application system, the data message in the main process database.As time goes on these data messages will be on the increase, and this is the data resource of enterprise's preciousness.When needs were used for reference with reference to historical data, user expectation can get access to satisfactory data by inquiry, to avoid the wasting of resources, does repetitive operation.When system software can not search out the data of user expectation fast, user experience was unfriendly, thought that inquiry velocity is very slow, even " deadlock " phenomenon occurred, and this use that has a strong impact on system is promoted.Especially, in PDM system and other application software, as in CAXAEB (electronics plate) integrated, the user only is concerned about some particular data, as drawing information, the user wish to list drawing all use information state so that reference, this just relates to multiword section complex query and nested query, how to show user requested data quickly, will influence the public praise of product and further promote, therefore, search efficiency is most important.
Database Systems are cores of data management system, based on the issued transaction of database and data query and analyzing and processing is one of critical function of PDM system, and query manipulation occupied proportion maximum in various database manipulations, query manipulation based on the SELECT statement be again the statement of cost maximum in SQL statement, so importance of Query Optimization Technique.But how many data are the scheme that whether has this performance of more perfect solution promptly no matter have in the database, what fields are arranged, the inquiry specified conditions, as comprising the data of " GB " in all fields such as part description or part code name, can disposablely check out soon, allow the user feel very fast (need not the progress prompt of " close friend "), this is that everybody wishes the dreamboat that reaches.Strengthen the good experience of user, this can allow the user accept in a sense substantially as far as possible.Especially in PDM and drawing software integrated products, the just drawing information that the user is concerned about, it is how very fast when retrieval is come out fast with the target drawing, list the drawing path that is cited, so that know the scope that the drawing change may influence, this is very useful to the user, quote the inquiry in path, also be operation the most consuming time in the search usually, if can in integrated, effectively improve the performance of this operation, will create higher benefit for integrated products.
The inquiry of PDM system at present, one all is based on SQL statement and directly obtains in real time from database, and the efficient raising then mainly depends on query strategy optimization.
The object data inquiry is the function of each applied information system indispensability, and its efficiency is also more common, and a lot of prioritization schemes or method are also arranged so far.Modal is to improve query strategy, carries out query optimization, but nearly all inquiry all is directly to fetch data from database read.
A kind of method is provided in correlation technique, and this method may further comprise the steps:
1) at first searches qualified drawing object information in the database.
2) analyze in the data model may with the object and the database table of drawing generation incidence relation, search the object that direct correlation is arranged with drawing by the mode of conjunctive query, as part, product, file etc.
3) parent object or the associated object information of the object of recursive lookup and drawing direct correlation are till finding final products or file.
In search procedure, optimize the SQL query statement, perhaps in database as far as possible, rationally make index of reference, also simplify or avoid large-scale table is carried out the ordering of repetition, the SQL statement of use avoids carrying out full table scan as far as possible, eliminates the optimization to the SQL statement levels such as sequential access of large-scale table line data.
For above-mentioned method, on some database servers, index may lose efficacy or make reading efficiency reduce because of frequent operation, and one may slow down the inquiry of index of reference unclearly; And in inquiry, relate to multilist compound query and recursive query, this has increased the difficulty of query statement and the reduction of search efficiency.
The lower problem of search efficiency at data in the PDM system in the correlation technique does not propose effective solution at present as yet.
Summary of the invention
At the lower problem of search efficiency of data in the PDM system in the correlation technique and propose the present invention, for this reason, fundamental purpose of the present invention is to provide the querying method and the device of data in a kind of PDM system, to address the above problem.
To achieve these goals, according to an aspect of the present invention, provide the querying method of data in a kind of PDM system.The querying method of data comprises in this PDM system: obtain the more new data in the described PDM system; According to described renewal Data Update index data base; And, inquire about described index data base by the mode of full-text search.
Further, obtain more new data in the described PDM system by trigger.
Further, after the more new data in obtaining described PDM system, described method also comprises: described more new data is write in the interim tabulation, comprise according to described renewal Data Update index data base: utilize the described index data base of renewal Data Update in the described interim tabulation.
Further, after writing described more new data in the interim tabulation, described method also comprises: load executable program; Comprise according to described renewal Data Update index data base: described executable program is regularly according to the described index data base of renewal Data Update in the described interim tabulation.
Further, the mode with task scheduling loads described executable program.
Further, comprise:, then upgrade the complete trails information in the described index data base and the object information of described complete trails information correspondence if the information of medium object is by change in the drawing complete trails according to described renewal Data Update index data base.
Further, described more new data is the more new data of drawing object.
To achieve these goals, according to a further aspect in the invention, provide the inquiry unit of data in a kind of PDM system.The inquiry unit of data comprises in this PDM system: acquisition module is used for obtaining the more new data of described PDM system; Update module is used for according to described renewal Data Update index data base; Enquiry module is used for inquiring about described index data base by the mode of full-text search.
Further, the inquiry unit of data also comprises in the above-mentioned PDM system: writing module, be used for after described acquisition module obtains the more new data of described PDM system, described more new data is write in the interim tabulation, wherein, update module is used for utilizing the described index data base of renewal Data Update of described interim tabulation.
Further, the inquiry unit of data also comprises in the above-mentioned PDM system: load-on module, be used for after the said write module writes interim tabulation with described more new data, load executable program, wherein, described update module is used for making the renewal Data Update described index data base of described executable program timing according to described interim tabulation.
By the present invention, adopt the more new data obtain in the described PDM system; According to described renewal Data Update index data base; And, by the method that the mode of full-text search is inquired about described index data base, solve in the correlation technique the lower problem of the search efficiency of data in the PDM system, and then reached the search efficiency effect that improves data in the PDM system.
Description of drawings
Accompanying drawing described herein is used to provide further understanding of the present invention, constitutes the application's a part, and illustrative examples of the present invention and explanation thereof are used to explain the present invention, do not constitute improper qualification of the present invention.In the accompanying drawings:
Fig. 1 is the process flow diagram according to the querying method of data in the PDM system of the embodiment of the invention;
Fig. 2 is the synoptic diagram according to the inquiry unit of data in the PDM system of the embodiment of the invention; And
Fig. 3 is the synoptic diagram according to the preferred embodiment of the inquiry unit of data in the PDM of the present invention system.
Embodiment
Need to prove that under the situation of not conflicting, embodiment and the feature among the embodiment among the application can make up mutually.Describe the present invention below with reference to the accompanying drawings and in conjunction with the embodiments in detail.
Fig. 1 is the process flow diagram according to the querying method of data in the PDM system of the embodiment of the invention.
As shown in Figure 1, this method comprises following step:
Step S102 obtains the more new data in the described PDM system.
For example, can obtain more new data in the described PDM system by trigger.
Preferably, after the more new data in obtaining described PDM system, described method also comprises: described more new data is write in the interim tabulation, comprise according to described renewal Data Update index data base: utilize the described index data base of renewal Data Update in the described interim tabulation.
Preferably, after writing described more new data in the interim tabulation, described method also comprises: load executable program; Comprise according to described renewal Data Update index data base: described executable program is regularly according to the described index data base of renewal Data Update in the described interim tabulation.
Preferably, the mode with task scheduling loads described executable program.
Step S104 is according to described renewal Data Update index data base.
Preferably, comprise:, then upgrade the complete trails information in the described index data base and the object information of described complete trails information correspondence if the information of medium object is by change in the drawing complete trails according to described renewal Data Update index data base.
Step S106 inquires about described index data base by the mode of full-text search.
Preferably, described more new data is the more new data of drawing object.
At PDM system and drawing software integrated in, be primarily aimed at the drawing object and carry out information inquiry, go out drawing side by side and quote complete trails, existing solution all is to adopt directly to carry out from data base querying, the centre relates to multilist conjunctive query and recursive query, (user feels that search is very slow to search for length consuming time, just listed Search Results etc. several seconds), the invention provides a kind of not directly from data base querying, and can obtain Query Result at faster speed and obtain the solution of drawing all references complete trails, and inquiry is to carry out the fuzzy matching of a plurality of fields search.
The preferred embodiments of the present invention are below described.
At first,, clearly obtain all data (mainly being the drawing object) alter operation (increase, revise, delete), and obtain the change data, write in the temporary table by trigger, and according to renewal data creation that gets access to or renewal index data base.If the information of medium object has alter operation in the drawing complete trails, then to upgrade object information corresponding in complete trails information in the index database and the complete trails.This index data base will be the data source of following data query, rather than directly obtain from database.
Secondly, load the exe program in the mode of task scheduling, this exe program timing is according to the change Data Update index database in the temporary table.
At last, the mode search index database by full-text search obtains Query Result.Utilize the full-text search technology to obtain data and will get access to Query Result quickly.
For example, can adopt following specific implementation to realize:
Following is the detailed description that example is carried out code level with c# version and SQL server database:
At first, set up a temporary table on database, this table is gone up the Key attribute (as CLASSID and OBJECTID) of record change object (drawing), record change (comprising increase, modification and the deletion of data recording) flag information, as increase to 1, be revised as 2, deletion is 3, and the record change time.
Analyze all and the object of linking relationship and relevant database table thereof are arranged with drawing, as parts list, list of drawing, the chained list of drawing and part, the tree-shaped chained list of part and part relates to the field of inquiry in all correlation tables, set up the relative trigger device then on all correlation tables of database, after creating new object, the CLASSID of this object, OBJECTID are recorded corresponding field in the temporary table, and the change attribute field is recorded as 1, and notes the creation-time of object; Similarly, after object properties take place to revise or delete, equally the Key attribute of change object is also recorded in the temporary table, during the change object information, the change attribute field is 2, and during the deletion object, this change attribute field is 3, writes down the change time simultaneously.If relate to chained list, except the information of writing down linked object itself, also to write down father and son's object CLASSID, OBJECTID information on the linked object.
Set up an exe program, the effect of this program is: the object data scanning 2) in the temporary table, mode by conjunctive query is taken out the object details in this table, and according to zone bit information, the newly-built newly-built index of drawing object information also adds index database to; And inquiring the complete trails information of object, this complete trails information also needs to set up corresponding index; If the drawing object has upgraded data message, then this lastest imformation also is updated to index database; If linked object upgrades, need only upgrade the corresponding informance in the complete trails, if the deletion of drawing object is then deleted all and related to the index information of this object from index database.Simultaneity factor will write down the time of this time upgrading index.After index upgrade finishes, did the data of handling in the deletion temporary table, exist to avoid junk data.Carry out this program next time, program can check that the change time is greater than the data of this update time in the temporary table, avoid repetitive operation, raise the efficiency, set up index and the API that the mode of index can utilize Lucene.Net (text searching server) to provide is provided operates.
Server end at the database place loads a task scheduling, and this task scheduling regularly carries out 3) the middle exe program of setting up.The frequency of carrying out can be adjusted according to user's request, if the user needs inquiry in real time, the time interval that this exe carries out can be provided with shortly, carry out once as per minute, if do not need real-time inquiry, can be set to carry out once every day, can be arranged on the late into the night to the execution time like this, to reduce the operating load of server.
After above program and configuration are all carried out, just can carry out full-text search.The API that utilizes Lucene.Net to provide takes out qualified record and returns client from the index database of its foundation, carry out subsequent treatment then.
Utilize traditional SQL statement also can reach the purpose that inquires qualified data, when the user inquiring designation of drawing, when a plurality of fields such as description contain the data of some specified conditions, need carry out the fuzzy matching search of a plurality of fields, if relate to the conjunctive query of multilist again, the SQL statement complexity, perhaps when data volume is very big, it will be an operation quite consuming time, so just not having the inventive method performance, good (the present invention has done index to significant data in the database after all, and utilized third party's full-text search technology with higher search efficiency) the query optimizer performance of not getting rid of following DBMS (data base management system (DBMS)) certainly obtains huge improvement, and can support big quantity compound query well and do not have performance issue.
In addition, SQL Server2005 and 2008 provides send the function of full-text query in the SQL Server table based on the data of character for application program and user.Before can moving full-text query to given table, the data base administrator must create full-text index by his-and-hers watches.In addition, begin to provide system non-index word table from SQL Server 2008.If will support language-specific or commercial application scenarios, need and delete the non-index word table of non-index word (being also referred to as noise word) change system by interpolation, and create additional non-index word table as required.But on some database servers, index may lose efficacy or make reading efficiency reduce because of frequent operation, and one may slow down the inquiry of index of reference unclearly.In addition, after database table upgrades mass data, need deletion and rebuild index to improve inquiry velocity, this takes time and effort than the present invention in follow-up maintenance work.
By above embodiment as can be seen, data query no longer directly obtains from database in the PDM system, but the change data of setting up according to trigger, utilize the full-text search technology to create index database, and utilize the full-text search technology to obtain Query Result, and the renewal of index database is not synchronous with Data Update, adopts regularly executive mode renewal index database of exe.
Further, the PDM system utilizes the full-text search technology to create index database, query object information and quotes complete trails information, adopts regularly executive mode renewal index database of exe.
Need to prove, can in computer system, carry out in the step shown in the process flow diagram of accompanying drawing such as a set of computer-executable instructions, and, though there is shown logical order in flow process, but in some cases, can carry out step shown or that describe with the order that is different from herein.
According to embodiments of the invention, provide the inquiry unit of data in a kind of PDM system.
Fig. 2 is the synoptic diagram according to the inquiry unit of data in the PDM system of the embodiment of the invention.
As shown in Figure 2, the inquiry unit of data comprises acquisition module 202, update module 204 and enquiry module 206 in this PDM system.
Wherein, acquisition module 202 is used for obtaining the more new data of described PDM system; Update module 204 is used for according to described renewal Data Update index data base; Enquiry module 206 is used for inquiring about described index data base by the mode of full-text search.
Fig. 3 is the synoptic diagram according to the preferred embodiment of the inquiry unit of data in the PDM of the present invention system.
As shown in Figure 3, the inquiry unit of data also comprises in the above-mentioned PDM system: writing module 208, be used for after described acquisition module obtains the more new data of described PDM system, described more new data is write in the interim tabulation, wherein, update module is used for utilizing the described index data base of renewal Data Update of described interim tabulation.
Preferably, the inquiry unit of data also comprises in the above-mentioned PDM system: load-on module 210, be used for after the said write module writes interim tabulation with described more new data, load executable program, wherein, described update module is used for making the renewal Data Update described index data base of described executable program timing according to described interim tabulation.
As can be seen from the above description, the present invention can improve the search efficiency of data in the PDM system.Further, the invention solves the efficiency that relates to multiword section fuzzy query and object reference complete trails in the data query, and can realize the compound search of a plurality of key words; Strengthened the experience of user's using system so greatly, embodied software more, saved the time of system user, made that software systems can better application and popularization to the essence efficiently that the user brings.
Obviously, those skilled in the art should be understood that, above-mentioned each module of the present invention or each step can realize with the general calculation device, they can concentrate on the single calculation element, perhaps be distributed on the network that a plurality of calculation element forms, alternatively, they can be realized with the executable program code of calculation element, thereby, they can be stored in the memory storage and carry out by calculation element, perhaps they are made into each integrated circuit modules respectively, perhaps a plurality of modules in them or step are made into the single integrated circuit module and realize.Like this, the present invention is not restricted to any specific hardware and software combination.
The above is the preferred embodiments of the present invention only, is not limited to the present invention, and for a person skilled in the art, the present invention can have various changes and variation.Within the spirit and principles in the present invention all, any modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1. the querying method of data in the PDM system is characterized in that, comprising:
Obtain the more new data in the product data management PDM system;
According to described renewal Data Update index data base; And
Inquire about described index data base by the mode of full-text search.
2. the querying method of data is characterized in that in the PDM according to claim 1 system, obtains more new data in the described PDM system by trigger.
3. the querying method of data is characterized in that in the PDM according to claim 1 system,
After the more new data in obtaining described PDM system, described method also comprises:
Described more new data is write in the interim tabulation,
Comprise according to described renewal Data Update index data base:
Utilize the described index data base of renewal Data Update in the described interim tabulation.
4. the querying method of data is characterized in that in the PDM according to claim 3 system,
After writing described more new data in the interim tabulation, described method also comprises:
Load executable program;
Comprise according to described renewal Data Update index data base:
Described executable program is regularly according to the described index data base of renewal Data Update in the described interim tabulation.
5. the querying method of data is characterized in that in the PDM according to claim 4 system, loads described executable program in the mode of task scheduling.
6. the querying method of data is characterized in that in the PDM according to claim 1 system, comprises according to described renewal Data Update index data base:
If the information of medium object is by change in the drawing complete trails, then upgrade the complete trails information in the described index data base and the object information of described complete trails information correspondence.
7. the querying method of data is characterized in that described more new data is the more new data of drawing object in the PDM according to claim 1 system.
8. the inquiry unit of data in the PDM system is characterized in that, comprising:
Acquisition module is used for obtaining the more new data of described PDM system;
Update module is used for according to described renewal Data Update index data base; And
Enquiry module is used for inquiring about described index data base by the mode of full-text search.
9. the inquiry unit of data is characterized in that in the PDM according to claim 8 system, also comprises:
Writing module is used for after described acquisition module obtains the more new data of described PDM system described more new data being write in the interim tabulation,
Wherein, update module is used for utilizing the described index data base of renewal Data Update of described interim tabulation.
10. the inquiry unit of data is characterized in that in the PDM according to claim 8 system, also comprises:
Load-on module is used for after the said write module writes interim tabulation with described more new data, loads executable program,
Wherein, described update module is used for making the renewal Data Update described index data base of described executable program timing according to described interim tabulation.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201010610445 CN102004800A (en) | 2010-12-28 | 2010-12-28 | Data query method and device of PDM (Product Data Management) system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201010610445 CN102004800A (en) | 2010-12-28 | 2010-12-28 | Data query method and device of PDM (Product Data Management) system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102004800A true CN102004800A (en) | 2011-04-06 |
Family
ID=43812162
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201010610445 Pending CN102004800A (en) | 2010-12-28 | 2010-12-28 | Data query method and device of PDM (Product Data Management) system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102004800A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103810175A (en) * | 2012-11-06 | 2014-05-21 | 凌群电脑股份有限公司 | Method for automatically establishing data indexes |
| CN104504144A (en) * | 2015-01-05 | 2015-04-08 | 浪潮(北京)电子信息产业有限公司 | Method and device for acquiring index-related information |
| CN106250422A (en) * | 2016-07-26 | 2016-12-21 | 盐城工学院 | A kind of standard component data method for quickly retrieving based on PDM system |
| CN108984374A (en) * | 2017-06-01 | 2018-12-11 | 腾讯科技（深圳）有限公司 | A kind of test method and system of database performance |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101136016A (en) * | 2006-09-01 | 2008-03-05 | 北大方正集团有限公司 | Indexes on-line updating method of full text retrieval system |
| US20080077570A1 (en) * | 2004-10-25 | 2008-03-27 | Infovell, Inc. | Full Text Query and Search Systems and Method of Use |
| CN101408876A (en) * | 2007-10-09 | 2009-04-15 | 中兴通讯股份有限公司 | Method and system for searching full text of electric document |
| CN101561815A (en) * | 2009-05-19 | 2009-10-21 | 华中科技大学 | Distributed cryptograph full-text retrieval system |
| CN101853288A (en) * | 2010-05-19 | 2010-10-06 | 马晓普 | Configurable full-text retrieval service system based on document real-time monitoring |
| CN101859323A (en) * | 2010-05-31 | 2010-10-13 | 广西大学 | Ciphertext full-text search system |
-
2010
- 2010-12-28 CN CN 201010610445 patent/CN102004800A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20080077570A1 (en) * | 2004-10-25 | 2008-03-27 | Infovell, Inc. | Full Text Query and Search Systems and Method of Use |
| CN101136016A (en) * | 2006-09-01 | 2008-03-05 | 北大方正集团有限公司 | Indexes on-line updating method of full text retrieval system |
| CN101408876A (en) * | 2007-10-09 | 2009-04-15 | 中兴通讯股份有限公司 | Method and system for searching full text of electric document |
| CN101561815A (en) * | 2009-05-19 | 2009-10-21 | 华中科技大学 | Distributed cryptograph full-text retrieval system |
| CN101853288A (en) * | 2010-05-19 | 2010-10-06 | 马晓普 | Configurable full-text retrieval service system based on document real-time monitoring |
| CN101859323A (en) * | 2010-05-31 | 2010-10-13 | 广西大学 | Ciphertext full-text search system |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103810175A (en) * | 2012-11-06 | 2014-05-21 | 凌群电脑股份有限公司 | Method for automatically establishing data indexes |
| CN104504144A (en) * | 2015-01-05 | 2015-04-08 | 浪潮(北京)电子信息产业有限公司 | Method and device for acquiring index-related information |
| CN106250422A (en) * | 2016-07-26 | 2016-12-21 | 盐城工学院 | A kind of standard component data method for quickly retrieving based on PDM system |
| CN108984374A (en) * | 2017-06-01 | 2018-12-11 | 腾讯科技（深圳）有限公司 | A kind of test method and system of database performance |
| CN108984374B (en) * | 2017-06-01 | 2021-05-07 | 腾讯科技（深圳）有限公司 | Method and system for testing database performance |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107391653B (en) | Distributed NewSQL database system and picture data storage method | |
| US6665678B2 (en) | Method, system, and program for optimistic concurrency control for scrollable cursors in a database | |
| US10083227B2 (en) | On-the-fly determination of search areas and queries for database searches | |
| US8555018B1 (en) | Techniques for storing data | |
| EP2874077B1 (en) | Stateless database cache | |
| US9087105B2 (en) | Rule-based extraction, transformation, and loading of data between disparate data sources | |
| US8280907B2 (en) | System and method for managing access to data in a database | |
| CN102770849B (en) | Optimizing a data cache when applying user-based security | |
| AU2017367772B2 (en) | Generating, accessing, and displaying lineage metadata | |
| US9483513B2 (en) | Storing large objects on disk and not in main memory of an in-memory database system | |
| EP1637993A2 (en) | Impact analysis in an object model | |
| CN101510209A (en) | Method, system and server for implementing real time search | |
| CN100437590C (en) | Method for prefetching object | |
| AU2005239366A1 (en) | Partial query caching | |
| CN102867070A (en) | Method for updating cache of key-value distributed memory system | |
| WO2011130706A2 (en) | Methods and systems for performing cross store joins in a multi-tenant store | |
| CN105574054A (en) | Distributed cache range query method, apparatus and system | |
| CN103353901A (en) | Orderly table data management method and system based on Hadoop distributed file system (HDFS) | |
| CN102346744A (en) | Device for processing materialized table in multi-tenancy (MT) application system | |
| US20120310918A1 (en) | Unique join data caching method | |
| US11803550B2 (en) | Workload-aware column imprints | |
| CN106484694B (en) | Full-text search method and system based on distributed data base | |
| CN101963993B (en) | Method for fast searching database sheet table record | |
| CN102004800A (en) | Data query method and device of PDM (Product Data Management) system | |
| CN103559307A (en) | Caching method and device for query |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20110406 |