CN109766439A - The unlimited tree-shaped class definition and assigning method of statistical query software - Google Patents
The unlimited tree-shaped class definition and assigning method of statistical query software Download PDFInfo
- Publication number
- CN109766439A CN109766439A CN201811537445.8A CN201811537445A CN109766439A CN 109766439 A CN109766439 A CN 109766439A CN 201811537445 A CN201811537445 A CN 201811537445A CN 109766439 A CN109766439 A CN 109766439A
- Authority
- CN
- China
- Prior art keywords
- classification
- typonym
- things
- data
- rank
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The present invention relates to the unlimited tree-shaped class definitions and assigning method of statistical query software, including establish classification chart, classification appointment table sentence is associated with table, classification chart includes typonym, rank, number, sequence and typonym full name；Appointment table of classifying includes type number and things ID；Table top class specified when being associated with sentence according to application establishes such each node item data projection of correspondence.The constraint that is not previously set in present invention application, can unlimited multi-angle analysis things, mining data as far as possible is worth.Data void holes are largely reduced, data space is saved, is improved and is searched, statisticallys analyze efficiency.It is particularly advantageous to carry out existing thing data to compile and grinds or subject study, finds and arrange after all the premise that valid data are work.
Description
Technical field
The present invention relates to a kind of unlimited tree-shaped class definition and assigning method, in particular to a kind of nothings of statistical query software
Limit tree-shaped class definition and assigning method.
Background technique
Almost each article or things are owned by various definitions, belong to a variety of mode classifications in other words.Such as: Zhang Sanshi
Chinese are yellows, are Type B blood, are high school students etc., and Chinese can be subdivided into China further according to region
Mongolian Huhehaote City people from Xincheng District, people from Huimin District etc..In the statistical query for carrying out people, what can only be limited in advance has
Limit the inquiry of a mode classification.Such method in a particular application, the demand that can not be fully met.And because inquiry
Mode classification has limited, and causes inquiry mode inflexible.During researching and developing archive database management software, class is encountered
As demand: certain CD media belongs to electronic record, and there are many file in CD, and some belongs to quality document, and some belongs to section
Grind production file.Certain quality document belongs to the activity of certain turning quality problem to zero, while being the quality witness file of certain test again.
Study carefully its main cause, is because the classification quantity of analysis cannot be prejudged in advance when analyzing Article characteristic.Such as pork
And apple, food-classifying is belonged to, and be belonging respectively to meat and fruit, and be belonging respectively to high-protein high-fat class and homovitamin
Class has different suitable populations, taste, sugar content, the main place of production etc. feature.If each classification for analyzing things can
To understand or be defined as a multiway tree, how many multiway tree, might have infinite number of possibility actually.
Limited several classification are pre-defined, each class can edit bifurcated class, define identification code for each node of divergence.
When establishing item data table, each classification is a column.When something or other does not need the classification, it is not filled with the column.The prior art
The shortcomings that be poor expandability, while also causing a large amount of data void holes, result in waste of resources.The purpose of the present invention is to be not added
Limitation increases classification newly in application process, is stored just for effective things classification appointment relationship, while meeting and being convenient for
It searches and statisticallys analyze.
Summary of the invention
The technical problem to be solved in the present invention is to provide the unlimited tree-shaped class definition and assigning method of statistical query software,
There is limitation and inflexible to solve the problems, such as information query and statistics because of the division of classification.
To solve, the technical solution adopted by the present invention are as follows: unlimited tree-shaped point of statistical query software
Class definition and assigning method, including establish classification chart, classification appointment table and be associated with sentence with table, it is characterised in that: the classification chart
Including typonym, rank, number, sequence and typonym full name, the restrictive condition of the typonym is in same parent
Lower title is unique；The restrictive condition of the rank is positive integer；The restrictive condition of the number is that full table is unique, and each rank increases
Add 2 position digital codings；The sequence is the display sequencing under same parent；The typonym full name is will be from top class
Start, by every level-one until the title that the typonym of the same level is cascaded；The classification appointment table include type number and
Things ID, the type number are the numbers in classification chart；The things ID is call number in things table, and restrictive condition is to work as class
The identical lower things ID of front two of type number is unique；Specified top class, establishes such when the table association sentence is according to application
Correspondence each node item data projection.
The logical algorithm of classification searching and statistics of the invention, specified top class when being according to application, quickly establishing should
Each node item data projection of the correspondence of class.The present invention is to things creation and the asynchronous operation feature of Classification Management, from traditional
Limited hardness corresponding relationship is changed into unlimited class definition and assigns.
The present invention realizes unconfined tree-shaped class definition, and easily carries out classification and the appointment that is associated with of things, solves
Information query and statistics limited problem because of the division of classification.This method is primarily adapted for use in the various dimensions system of all kinds of big datas
Count the software development of inquiry.
Beneficial effect
The constraint that is not previously set in present invention application, can unlimited multi-angle analysis things, mining data as far as possible is worth.
Data void holes are largely reduced, data space is saved, is improved and is searched, statisticallys analyze efficiency.It is particularly advantageous to existing thing
Data compile and are ground or subject study, find and arrange after all the premise that valid data are work.
Detailed description of the invention
Fig. 1 classification of documents assigns surface chart；
Fig. 2 inquires surface chart by classification；
Fig. 3 statistic of classification surface chart.
Specific embodiment
The present invention will be further described in the following with reference to the drawings and specific embodiments.
The unlimited tree-shaped class definition and assigning method of statistical query software of the present invention, specifically:
1, classification chart: typonym, rank, number, sequence, typonym full name.The restrictive condition of typonym is same
Title is unique under parent.The restrictive condition of rank is positive integer (rank of top class is 1).The restrictive condition of number be full table only
One, each rank increases by 2 position digital codings, and (parent coding adds 2 codings of the same level, according to demand archive database management software
Enough using 2 every grade).Sequence is the display sequencing under same parent.Typonym full name is will to open from top class
Begin, by every level-one until the title that the typonym of the same level is cascaded, centre are separated with "-".
2, table: type number, things ID is assigned in classification.Type number is the number in classification chart, and things ID is things table
Middle call number.Restrictive condition is when the identical lower things ID of front two of type number is unique, and the meaning of representative is that a certain things exists
Certain node can only be belonged in certain classification.
3, operational administrative process: when increasing newly, editing things, first do not have to comprehend to belong to that classification.Carry out classification point
When analysis, classification multiway tree is established.Certain node of the things sorted out and classification is subjected to appointment operation again, completes to correspond to
Relationship storage and change.
4, lookup, the statistics of things are carried out according to classification.
The present invention has been successfully applied to " multi-medium file management system tested by six institute 601 of space flight " software, in the application
Prove the present invention be it is feasible, solve management problems conscientiously.
The present invention can also be applied to management category information system in addition to being applied in file data statistical query class management software
In the application of the other software such as system, big data analysis system.
Claims (2)
1. the unlimited tree-shaped class definition and assigning method of statistical query software, including establish classification chart, classification appointment table and table
It is associated with sentence, it is characterised in that:
The classification chart includes typonym, rank, number, sequence and typonym full name, the limitation item of the typonym
Part is that title is unique under same parent；The restrictive condition of the rank is positive integer；The restrictive condition of the number is full table
Uniquely, each rank increases by 2 position digital codings；The sequence is the display sequencing under same parent；The typonym
Full name is the title that since top class, every level-one will be cascaded up to the typonym of the same level；
The classification appointment table includes type number and things ID, and the type number is the number in classification chart；The things
ID is call number in things table, and restrictive condition is when the identical lower things ID of front two of type number is unique；
Specified top class when the table association sentence is according to application establishes such each node item data projection of correspondence.
2. unlimited tree-shaped class definition according to claim 1 and assigning method, it is characterised in that: the top of the classification chart
The rank of grade class is 1.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811537445.8A CN109766439A (en) | 2018-12-15 | 2018-12-15 | The unlimited tree-shaped class definition and assigning method of statistical query software |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811537445.8A CN109766439A (en) | 2018-12-15 | 2018-12-15 | The unlimited tree-shaped class definition and assigning method of statistical query software |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109766439A true CN109766439A (en) | 2019-05-17 |
Family
ID=66451881
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811537445.8A Pending CN109766439A (en) | 2018-12-15 | 2018-12-15 | The unlimited tree-shaped class definition and assigning method of statistical query software |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109766439A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110688374A (en) * | 2019-09-25 | 2020-01-14 | 政采云有限公司 | Method, device and medium for removing duplicate of layer data |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130036152A1 (en) * | 2011-08-02 | 2013-02-07 | Cavium, Inc. | Lookup front end packet output processor |
| CN103823868A (en) * | 2014-02-26 | 2014-05-28 | 中国科学院计算技术研究所 | Event recognition method and event relation extraction method oriented to on-line encyclopedia |
| CN104361111A (en) * | 2014-11-28 | 2015-02-18 | 青岛大学 | Automatic archive editing method |
| CN105357201A (en) * | 2015-11-12 | 2016-02-24 | 中国科学院信息工程研究所 | Access control method and system for object cloud storage |
| CN106372238A (en) * | 2016-09-13 | 2017-02-01 | 广州善融信息科技有限公司 | Method for realizing non-recursive unlimited classification based on database |
-
2018
- 2018-12-15 CN CN201811537445.8A patent/CN109766439A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130036152A1 (en) * | 2011-08-02 | 2013-02-07 | Cavium, Inc. | Lookup front end packet output processor |
| CN103823868A (en) * | 2014-02-26 | 2014-05-28 | 中国科学院计算技术研究所 | Event recognition method and event relation extraction method oriented to on-line encyclopedia |
| CN104361111A (en) * | 2014-11-28 | 2015-02-18 | 青岛大学 | Automatic archive editing method |
| CN105357201A (en) * | 2015-11-12 | 2016-02-24 | 中国科学院信息工程研究所 | Access control method and system for object cloud storage |
| CN106372238A (en) * | 2016-09-13 | 2017-02-01 | 广州善融信息科技有限公司 | Method for realizing non-recursive unlimited classification based on database |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110688374A (en) * | 2019-09-25 | 2020-01-14 | 政采云有限公司 | Method, device and medium for removing duplicate of layer data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104252445B (en) | Approximate repetitive file detection method and device | |
| CN102012900B (en) | An information retrieval method and system | |
| US7809771B2 (en) | Automatic reduction of table memory footprint using column cardinality information | |
| US20160012061A1 (en) | Similar document detection and electronic discovery | |
| CN106202514A (en) | Accident based on Agent is across the search method of media information and system | |
| WO2008154029A1 (en) | Data classification and hierarchical clustering | |
| Baralis et al. | CAS-Mine: providing personalized services in context-aware applications by means of generalized rules | |
| CN108446391A (en) | Processing method, device, electronic equipment and the computer-readable medium of data | |
| CN111506621A (en) | Data statistical method and device | |
| CN106484742A (en) | Log processing method and device | |
| CN107644050A (en) | A kind of querying method and device of the Hbase based on solr | |
| CN105095436A (en) | Automatic modeling method for data of data sources | |
| CN109766439A (en) | The unlimited tree-shaped class definition and assigning method of statistical query software | |
| CN105159898A (en) | Searching method and searching device | |
| CN109874032A (en) | The program special topic personalized recommendation system and method for smart television | |
| CN109063063B (en) | Data processing method and device based on multi-source data | |
| CN116881430A (en) | Industrial chain identification method and device, electronic equipment and readable storage medium | |
| CN112363996A (en) | Method, system, and medium for building a physical model of a power grid knowledge graph | |
| CN106775694A (en) | A kind of hierarchy classification method of software merit rating code product | |
| CN100403308C (en) | SQL load mining-based automatic design method for physical database | |
| US20100268723A1 (en) | Method of partitioning a search query to gather results beyond a search limit | |
| CN112784040B (en) | Vertical industry text classification method based on corpus | |
| CN112860899B (en) | Label generation method and device, computer equipment and computer readable storage medium | |
| CN104463627A (en) | Data processing method and device | |
| CN115510289A (en) | Data cube configuration method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20190517 |