CN106504129A - A kind of database establishment method and device - Google Patents

A kind of database establishment method and device Download PDF

Info

Publication number
CN106504129A
CN106504129A CN201611270035.2A CN201611270035A CN106504129A CN 106504129 A CN106504129 A CN 106504129A CN 201611270035 A CN201611270035 A CN 201611270035A CN 106504129 A CN106504129 A CN 106504129A
Authority
CN
China
Prior art keywords
item name
construction process
construction
process data
data
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
Application number
CN201611270035.2A
Other languages
Chinese (zh)
Inventor
郝大鹏
刘贺玮
潘召南
杨吟兵
马敏
许亮
余毅
龙国跃
赵宇
郭宇
李敏
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
SICHUAN FINE ARTS INSTITUTE
Original Assignee
SICHUAN FINE ARTS INSTITUTE
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by SICHUAN FINE ARTS INSTITUTE filed Critical SICHUAN FINE ARTS INSTITUTE
Priority to CN201611270035.2A priority Critical patent/CN106504129A/en
Publication of CN106504129A publication Critical patent/CN106504129A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/08Construction
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2291User-Defined Types; Storage management thereof

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • General Health & Medical Sciences (AREA)
  • Human Resources & Organizations (AREA)
  • Data Mining & Analysis (AREA)
  • Software Systems (AREA)
  • Health & Medical Sciences (AREA)
  • Economics (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Marketing (AREA)
  • Primary Health Care (AREA)
  • Strategic Management (AREA)
  • Tourism & Hospitality (AREA)
  • General Business, Economics & Management (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

A kind of database establishment method and device provided in an embodiment of the present invention, belongs to technical field of data processing.Methods described includes:Obtain multiple construction process datas;Tree-shaped classification, the multiple classification paths of acquisition, multiple levels from low to high and corresponding at least one item name of each level are carried out according to the characteristic information of each construction process data to multiple construction process datas;Item name for the lowest hierarchical level in each classification path is respectively allocated corresponding storage location;According to the characteristic information of each construction process data, each described construction process data is respectively stored in the storage location corresponding to the item name in the lowest hierarchical level in corresponding classification path.The method is capable of the data that technique built by the preservation local-style dwelling houses of effectively specification, is prevented from losing the intangible cultural heritage of local-style dwelling houses construction technique, is preferably passed on.

Description

A kind of database establishment method and device
Technical field
The present invention relates to data processing field, in particular to a kind of database establishment method and device.
Background technology
Due to social change, modern architecture corrodes, the reason such as natural disaster and artificial destruction, China's Traditional Villages quantity It is greatly reduced, scale drastically reduces, integrity violations are serious, lacks the development guarantee for building Technology again.Traditional residence is sought It is intangible cultural heritage in imminent danger to build technique, it would be highly desirable to rescue and systematic protection.Local-style dwelling houses is that the people treats living problem The display of aspect wisdom, in the long-term practice of craftsman teachers, these wisdom are accumulated makees system for a whole set of craftsman, is among the people Construction technique and the crystallization of historical experience.But the conservative tradition that workmanship master and apprentice among the people mutually awards is limited to a certain extent The exchange and development of afforestation technique, is documented in addition less, is building main body tradition craftsman teacher today less and less, greatly The outstanding traditional technology of amount and construction experience are lost in, and the construction technique of traditional residence is urgently excavated, arranged and passes on.The opposing party Fade away, protect and pass due to lacking effective Technology protection in face, the traditional residence due to there is historical value in a large number The problems demand for holding China's Traditional Villages local-style dwelling houses history evolvement is solved, and is therefore collected, is arranged Traditional Villages local-style dwelling houses construction skill warp Test, be the very important ring of inheriting tradition vernacular architecture culture.
To sum up, set up one to there are historical document to be worth and study the Traditional Villages local-style dwelling houses construction process data of using value Storehouse, is that succession builds Technology with carrying forward the inevitable requirement of Chinese traditional culture, rescuing and passing on Traditional Villages local-style dwelling houses Urgent requirement.But, the distribution of traditional residence has a large capacity and a wide range, and it is various informative that each department craftsman makees skill, and various places construction skill is related Record and more lack.Often lack unified building method during the foundation of construction technological data bank and technical standard come right Local-style dwelling houses construction technique is preferably passed on and is preserved.
Content of the invention
In view of this, the purpose of the embodiment of the present invention is to provide a kind of database establishment method and device, the method energy Enough losses that local-style dwelling houses construction technique is preferably spread and is preserved, prevent local-style dwelling houses construction technique.
Embodiments of the invention are realized in:
A kind of database establishment method, methods described include:Obtain multiple construction process datas;To multiple construction works Skill data carry out tree-shaped classification according to the characteristic information of each construction process data, obtain multiple classification paths, from low to high Multiple levels and corresponding at least one item name of each level, wherein, in the same classification path, the class of lower-level Another name claims the item name for being subordinated to higher levels;In the same classification path, the item name of lowest hierarchical level is corresponding The characteristic information of one construction process data;For each classification path in lowest hierarchical level item name be respectively allocated corresponding Storage location;According to the characteristic information of each construction process data, each described construction process data is respectively stored into Correspondingly in the storage location corresponding to the item name in the lowest hierarchical level in classification path.
A kind of database establishment device, including:Acquisition module, for obtaining multiple construction process datas;Sort module, uses In tree-shaped classification being carried out to multiple construction process datas according to the characteristic information of each construction process data, obtain multiple points Class.path, multiple levels from low to high and corresponding at least one item name of each level, wherein, the same classification road In footpath, the item name of lower-level is subordinated to the item name of higher levels;Lowermost layer in the same classification path The item name of level corresponds to the characteristic information of a construction process data;Storage location distribute module, for classifying for each The item name of the lowest hierarchical level in path is respectively allocated corresponding storage location;Memory module, for according to each battalion The characteristic information of process data is built, each described construction process data is respectively stored into described minimum in corresponding classification path In the storage location corresponding to the item name in level.
A kind of database establishment method and apparatus provided in an embodiment of the present invention, obtains multiple construction works first in the method Skill data.Then according to the characteristic information of each construction process data carries out tree-shaped classification, multiple levels and each level is obtained Corresponding at least one item name.In two wherein adjacent levels, each classification of lower-level belongs to higher levels One classification, so can will be clearly more demarcated for the level of the information preserved in data base;Needing to search out less class name When title, the title for finding the larger classification that the less class name is much of one-level can be first needed, can enhanced convenience searching Corresponding information.The characteristic information of the corresponding construction process data of each item name of lowest hierarchical level, and be the lowermost layer Each item name of level distributes corresponding storage location, then be able to will be sought according to the characteristic information of construction process data accordingly Build process data and be respectively stored into corresponding storage location, just can be with root when the construction process data for needing inquiry related Searched according to the item name of each level successively.The database establishment method, can make construction process data carry out batch preservation And the more specification for preserving, can be effectively protected the cultural heritage that technique built by local-style dwelling houses, prevent local-style dwelling houses from building the loss of technique.
For enabling the above objects, features and advantages of the present invention to become apparent, preferred embodiment cited below particularly, and coordinate Appended accompanying drawing, is described in detail below.
Description of the drawings
In order to be illustrated more clearly that the technical scheme of the embodiment of the present invention, below by to be used attached needed for embodiment Figure is briefly described, it will be appreciated that the following drawings illustrate only certain embodiments of the present invention, and it is right to be therefore not construed as The restriction of scope, for those of ordinary skill in the art, on the premise of not paying creative work, can be with according to this A little accompanying drawings obtain other related accompanying drawings.
The block diagram of the overall hardware unit of the database establishment system that Fig. 1 is provided for present pre-ferred embodiments.
The method flow diagram of the database establishment method that Fig. 2 is provided for present pre-ferred embodiments.
The step of database establishment method that Fig. 3 is provided for present pre-ferred embodiments S110 particular flow sheet.
The tree-shaped classification relation figure of the toft shape of the database establishment method that Fig. 4 is provided for present pre-ferred embodiments.
Item name corresponding with Fig. 4 and item name numbering schematic diagram that Fig. 5 is provided for present pre-ferred embodiments.
The numbering of part rule list of the database establishment method that Fig. 6 is provided for present pre-ferred embodiments.
A kind of embodiment of the character portion storage of the database establishment method that Fig. 7 is provided for present pre-ferred embodiments Prototype drawing.
The database establishment method that Fig. 8 is provided for present pre-ferred embodiments storage interval set up partitioned file folder Schematic diagram.
The step of database establishment method that Fig. 9 is provided for present pre-ferred embodiments S140 particular flow sheet.
The high-level schematic functional block diagram of the database establishment device that Figure 10 is provided for present pre-ferred embodiments.
The function mould of the submodule of the acquisition module of the database establishment device that Figure 11 is provided for present pre-ferred embodiments Block schematic diagram.
The function mould of the submodule of the memory module of the database establishment device that Figure 12 is provided for present pre-ferred embodiments Block schematic diagram.
Icon:10- database establishment systems;101- memorizeies;102- storage controls;103- processors;104- peripheral hardwares Interface;105- input-output units;106- audio units;107- display units;110- acquisition modules;120- sort modules; 130- storage location distribute modules;140- memory modules;111- raw data acquisition submodules;112- raw data tables obtain son Module;113- builds process data acquisition submodule;141- partition holding submodules;142- data classification submodule;143- is deposited Storage submodule.
Specific embodiment
Below in conjunction with accompanying drawing in the embodiment of the present invention, to the embodiment of the present invention in technical scheme carry out clear, complete Ground description, it is clear that described embodiment is only a part of embodiment of the invention, rather than whole embodiment.Generally exist The component of the embodiment of the present invention described and illustrated in accompanying drawing can be arranged and be designed with a variety of configurations herein.Cause This, is not intended to limit claimed invention to the detailed description of the embodiments of the invention for providing in the accompanying drawings below Scope, but it is merely representative of the selected embodiment of the present invention.Embodiments of the invention are based on, those skilled in the art are not doing The every other embodiment obtained on the premise of going out creative work, belongs to the scope of protection of the invention.
It should be noted that:Similar label and letter represent similar terms in following accompanying drawing, therefore, once a certain Xiang Yi It is defined in individual accompanying drawing, then in subsequent accompanying drawing which further need not be defined and be explained.Meanwhile, the present invention's In description, term " first ", " second " etc. are only used for distinguishing description, and it is not intended that indicating or hint relative importance.
As shown in figure 1, being a kind of square frame signal of the overall hardware unit of database establishment system 10 that the present invention is provided Figure.The database establishment system 10 include database establishment device, memorizer 101, storage control 102, processor 103, Peripheral Interface 104, input-output unit 105, audio unit 106, display unit 107.
The memorizer 101, storage control 102, processor 103, Peripheral Interface 104, input-output unit 105, sound Frequency unit 106,107 each element of display unit are directly or indirectly electrically connected with each other, to realize the transmission or friendship of data Mutually.For example, these elements can pass through one or more communication bus each other or holding wire is realized being electrically connected with.The data Storehouse construction device includes that at least one can be stored in the memorizer 101 in the form of software or firmware (firmware) or solid Change the software function module in the operating system (operating system, OS) of the database establishment system 10.Described Processor 103 is used for executing the executable module stored in memorizer 101, the software that for example described database establishment device includes Functional module or computer program.
Wherein, memorizer 101 may be, but not limited to, random access memory (Random Access Memory, RAM), read only memory (Read Only Memory, ROM), programmable read only memory (Programmable Read-Only Memory, PROM), erasable read-only memory (Erasable Programmable Read-Only Memory, EPROM), Electricallyerasable ROM (EEROM) (Electric Erasable Programmable Read-Only Memory, EEPROM) etc.. Wherein, memorizer 101 is used for storage program, and the processor 103 executes described program after execute instruction is received, aforementioned Method performed by the server of the stream process definition that embodiment of the present invention any embodiment is disclosed can apply to processor 103 In, or realized by processor 103.
A kind of possibly IC chip of processor 103, the disposal ability with signal.Above-mentioned processor 103 can To be general processor, including central processing unit (Central Processing Unit, abbreviation CPU), network processing unit (Network Processor, abbreviation NP) etc.;Can also be digital signal processor (DSP), special IC (ASIC), Ready-made programmable gate array (FPGA) or other PLDs, discrete gate or transistor logic, discrete hard Part component.Can realize or execute disclosed each method in the embodiment of the present invention, step and logic diagram.General processor Can be microprocessor or the processor 103 can also be any conventional processor 103 etc..
The Peripheral Interface 104 is by various input/output devices coupled to processor 103 and memorizer 101.At some In embodiment, Peripheral Interface 104, processor 103 and storage control 102 can be realized in one single chip.Other one In a little examples, they can be realized by independent chip respectively.
Input-output unit 105 realizes user with the server (or local terminal) for being supplied to user input data Interaction.The input-output unit 105 may be, but not limited to, mouse and keyboard etc..
Audio unit 106 provides a user with audio interface, and which may include one or more mikes, one or more raises Sound device and voicefrequency circuit.
Display unit 107 provides an interactive interface and user between in the server (or local terminal) and (for example uses Family operation interface) or refer to user for display image data.In the present embodiment, the display unit 107 can be liquid Crystal display or touch control display.If touch control display, which can be the capacitance touching control for supporting single-point and multi-point touch operation Screen or resistance type touch control screen etc..Support that single-point and multi-point touch operation refer to that touch control display can be sensed and show from the touch-control The touch control operation that one or more positions are produced simultaneously on device, and transfer to processor 103 to enter the touch control operation for sensing Row is calculated and is processed.
Fig. 2 is referred to, is the number of the database establishment system 10 being applied to shown in Fig. 1 that present pre-ferred embodiments are provided Flow chart according to storehouse building method.Idiographic flow shown in Fig. 2 will be described in detail below.
Step S110, obtains multiple construction process datas.
In the present embodiment, construction process data refers specifically to the representational wood structure building of most Traditional Architectures in China Related data.For example, most representative, branch most widely lifts beam type, wears the related data of bucket type wood structure building.
Specifically, construction process data can be divided into:Traditional Villages folk building, local-style dwelling houses shape system, construction material, construction work The plates such as craftsman, construction instrument, construction operation, Housebuilder method, local-style dwelling houses decoration, local-style dwelling houses repairerment, Local Adaptation technology, construction custom Block, it should be noted that should not be interpreted as the limit to the present invention by the sorting technique of the construction process data in the present embodiment System, it is possibility to have other sorting techniques.Specific explanations will be made below to each construction process data that classifies above:
The content of " Traditional Villages folk building " plate includes " concept defining of traditional residence ", " history of traditional residence Evolution ", " Traditional Architectures are constituted substantially ", " Traditional Architectures feature " four parts.
The content of " local-style dwelling houses shape system " includes the title and common form of each placement members, ratio scale in Traditional Villages local-style dwelling houses Relation etc..It is broadly divided into " toft shape system ", " framework shape system ", " body of wall shape system ", " finishing shape system ", " roof-shaped system ", " Tenon shape Six parts of system ", divide under each several part and list related each component.
The content of " construction material " include traditional residence build a house common materials characteristic and choice requirement, processing or make stream Journey and often what position uses in folk building, the plate by " wood ", " brick ", " mortar ", " watt ", " stone ", " soil ", Eight parts of " bamboo ", " paint colour painting pigment " are constituted.
The content of " construction instrument " includes that each craftsman makees the common-size of common tool, using method, and the plate is by " carpentery workshop work Tool ", " brick and tile make instrument ", " masonry instrument ", " soil makees instrument ", " bamboo makees instrument ", " paint colour painting instrument " are constituted, all kinds of instruments Lower according to different purpose classifications, such as brick and tile make under instrument and be divided into " instrument of building a wall ", " dauber ", " plastering smooth instrument ", " measurement directional orientation tool ", " machining tool ", list each concrete instrument etc. again under which.
The content of " construction craftsman " includes that common craftsman makees work post, the mode of craftsman's skill succession, craftsman in traditional residence construction The type of organization of group and industry professional etiquette, and traditional craftsman employs mode etc., following " craftsman learns a skill, employs and passes on " with " craftsman teacher's essential information " two parts.
The content of " construction operation " is primarily to record Traditional Villages local-style dwelling houses construction substantially flow process, is divided into " addressing ", " moves The flat base of soil ", " framework processing ", " building a wall ", " Shang watt ", " finishing ", " moving in " five parts.
The content of " Housebuilder method " includes that the process steps of each component of Traditional Villages local-style dwelling houses, the plate are broadly divided into " toft engineering method ", " framework engineering method ", " body of wall engineering method ", " finishing engineering method ", " roof engineering method " five parts are constituted, and list phase under which Close each component.
" local-style dwelling houses decoration " is made up of " decoration technology " and " decorative patterns "." decoration technology " mainly illustrates the common local-style dwelling houses of China The type of decoration technology and concrete process steps, the plate content include " woodcarving craft ", " tile carving technique ", " ash modeling work Skill ", " stonework ", " hold technique ", " painting technology ", " colour painting technique " etc., the following concrete engineering method step of all kinds of techniques. The content of " decorative patterns " includes the implication of the decorative form, decorative patterns and behind of each position emphasis decorative position of local-style dwelling houses, its In include under " decorative form of emphasis decorative position " " stylobate decoration ", " framework decoration ", " wall body decoration ", " fitting-up ", Include " animal texturing ", " plant decorative pattern ", " geometry decorative pattern ", " word under " finial ", " implication of decorative patterns and behind " Decorative pattern ", " angle personage's decorative pattern ", " opera story decorative pattern ", " implements decorative pattern ", " combination decorative pattern ", " tower building decorative pattern ", " oneself The classification such as right thing stricture of vagina ", " auspicious pattern ", " stylized decorative pattern ".
" local-style dwelling houses repairerment " mainly illustrates common maintenance, the maintaining method of the normal damaged member of Traditional Villages local-style dwelling houses, is broadly divided into " toft repairerment ", " framework repairerment ", " body of wall repairerment ", " finishing is repaired ", " roof repairerment " five parts, list under which related each Component.
" construction custom " the mainly common etiquette and custom taboo during the construction of Traditional Villages local-style dwelling houses of explanation and formulas or directions put into verse, by building a house Step " addressing ", " breaking ground ", " standing tree erects room ", " upper beam ", " completion ", " entering residence ", " removal of home " carry out the book of final entry.
" Local Adaptation technology " refers to that the appropriate technology of traditional residence treatment in accordance with local conditions, content include " insect pest and bird pest Prevention Technique ", " anti-seismic technology ", " Radix Saposhnikoviae technology ", " fireproofing technique ", " shocking preventing technology ", " lighting technique ", " aeration technology ", " heating technology ", " heat-insulating technique ", " water discharge technology ", " moisture-proof dosing technology ", " aseptic technic " etc..
Fig. 3 is refer to, in step s 110, the concrete obtaining step for building process data can be divided into following steps:
Step S111, collection construction technique initial data.
Construction technique initial data, specifically can be understood as the construction process data of unprocessed mistake, contains construction work The content of skill data;The construction specific acquisition pattern of technique initial data can be take pictures, survey and draw, recording a video, recording, writing record Deng various ways.For example, by the technology craftsman of interview correlation folk building, then writing record, video recording, record etc.;Pass through The online correlation that obtains has information, then arranges and gets construction technique initial data.
Specific embodiment, to taking pictures for the applicable multi-angles such as the surface structure of local-style dwelling houses, construction material, construction instrument Record;Mapping is mainly used in the detailed ratio scale relation for recording and understanding architectural entity;The coherent concrete construction process of dynamic, Ins and outs etc., then be suitable for video camera record, but record a video usually need later stage further editing, can pixel compared with Install on high smart mobile phone or panel computer can the video recording application software (APP) of editing immediately cut to realize recording.? During interview instant to craftsman Shi Jinhang, we can record interview content in the way of use video recording or recording pen, behind again by content It is converted into word.During to craftsman teacher's spot coverage, the details for sightless building structure, the step of each component processing Rapid and details etc. we in addition to it can carry out itemized record with word, can help understand, record with skeletonizing, afterwards Remake further specification to arrange.
Step S112, obtains multiple construction technique raw data tables according to the construction technique initial data.
In step S112, by above-mentioned construction technique initial data typing computer and multiple battalion of electronics shelves are fabricated to Technique raw data table is built, or hand filling makes construction technique raw data table, builds the concrete of technique raw data table Form is not restricted.Same content topic is should be in each construction technique raw data table.Construction technique raw data table It is broadly divided into character portion, Picture section and video section, wherein video section can be with the video address filled in or video link The mode such as connect to represent.Character portion can be corresponding contents introduction, picture introduction, and introductory video etc..For example, in word Hold, word literature reference, figure is said, says that figure, picture number, title and source of data, this section figure are said number, tabulator, say that figure is comprehensive State, say figure numbering, title and source of data etc..Picture section should be the picture of the corresponding word content being put on request, photograph Piece, model sectional drawing or screen sectional drawing etc., Picture section should see image content clearly.In addition for audio-frequency unit can be by sound Frequency Content Transformation carries out being entered in construction technique raw data table for character information.Can also be filled out in the form of the link of address Write in construction technique raw data table.It should be noted that word can be included but is not limited in construction technique raw data table Symbol part, Picture section and video section.
Step S113, obtains multiple construction process datas.
Step S113, further by the character portion in construction technique raw data table, Picture section and video portion Grade and be optimized process, for example, character portion increases the reference source of word, and the explanation to related terms, to the construction work The summary of the entire content of skill raw data table, the record of related arrangement personnel, number information etc.;Picture section, for picture (" specification " in the present embodiment can refer to the size of picture, definition, size etc.) for not meeting specification carries out repainting behaviour Make (for example, drawings, scaling, cut out), or increase partial enlarged drawing (for example, the beam on roof, watt etc. structure) etc.;Video portion Point, further editing classification etc. can be carried out to video section.
Multiple construction process datas are carried out tree-shaped classification, obtain multiple classification paths, from low to high by step S120 Multiple levels and corresponding at least one item name of each level.
Fig. 4 is refer to, Fig. 4 shows the tree-shaped classification relation of the toft shape in construction process data.In the step In S120, inclusion relation of the level for characteristic feature range of information, in same classification path, the item name of lower-level It is subordinated to the item name of higher levels.Item name, represents the feature letter of different content informations, i.e. construction process data Breath.For example, in figure 4, it can be seen that highest level is toft shape system, the toft shape system includes Tai Ming and buried depth (i.e. toft shape A level under system);Wherein buried depth includes base of a pillar pier and blocks soil (base of a pillar pier is a level under buried depth with soil is blocked)." room Base shape system ", " platform is bright ", " buried depth " and " firing step " etc. are item name.Path " toft shape system-Tai Ming-soil lining stone, Phnom Penh ", " toft shape system-Tai Ming-step and ramp-firing step-firing step of complying with one's wishes " and " toft shape system-buried depth-base of a pillar pier " etc., road of as classifying Footpath.It should be noted that the item name of lowest hierarchical level corresponds to a construction technique number in the same classification path According to characteristic information.
In addition, for each item name can arrange corresponding explanation information, the explanation information can be class name Content summary of subordinate's level of the explanation of nouns of title, epoch brief introduction, or category title etc..
As shown in figure 5, after step S120, also including, each described item name of each level is compiled Number.Fig. 6 shows the numbering of part rule of the database establishment method, and each of which horizontal bar is same level, and each vertical hurdle is Same classification path.For example, folk building cataloguing, numbering is A;Construction technique cataloguing, numbering is B;Local-style dwelling houses building technology is catalogued, Numbering is C;Construction folk culture protection, numbering is D;Local adaptation technology and repairerment, numbering are E;Above-mentioned five class names Belong to the content under cataloguing texts and pictures storehouse (numbering is called A) classification path.Wherein, the letter of the numbering of each item name Breath is all subordinated to the information of the numbering of the item name of the last layer level corresponding to category title.As shown in figure 5, wherein, example As numbering " AAA0101 " be subordinated to numbering " AAA01 ", and for example, number " AAB010101 ", " AAB010102 ", " AAB010103 ", " AAB010104 ", " AAB010105 ", " AAB010106 " are subordinated to numbering " AAB0101 ";Higher levels Item name can be numbered using three letters respectively, each hierarchical relationship under which can be according to item name, often to next layer Level then increases two digits coding, and the entry of same level is 01,02,03 ... incremented by successively in order from left to right.Each volume Number information membership relation should also be as the membership relation of the item name corresponding to reference numeral.Additionally, the form of label can be with It is the forms such as letter, numeral, character and digit.When lookup after the storage that construction process data can so be caused more Convenient.Reference numeral that can also be on labelling in above-mentioned classification path on each construction process data, wherein can be to character Partly, Picture section and video section carry out single labelling, to facilitate corresponding lookup related content, and data inputting when Time realizes batch input.
For example, as shown in fig. 7, the figure shows a kind of storage template of embodiment of character portion, wherein it is divided into number According to item, data content and data explanation;Database accession number, In this Section, content details, picture number name is included in data item Claim source of data, figure is said, this section figure says number, human editor, word literature reference, say figure, say figure summarize, say figure numbering title and Source of data, this section say figure number, mapper.
Step S130, is that the item name of each lowest hierarchical level in path of classifying is respectively allocated corresponding storage location.
In step S130, the corresponding storage location can be, corresponding hardware storage apparatus, such as hard disk, The modes such as the file of subregion or foundation in disk, or other storage intervals, as shown in Figure 8.
Step S140, according to the characteristic information of each construction process data, by each construction process data point Do not store in the storage location corresponding to the item name in the lowest hierarchical level in corresponding classification path.Refer to Fig. 9, specifically, including:
Corresponding for described for each in lowest hierarchical level item name storage location is divided into character storage by step S141 Region, picture memory area and video storage, the file " Data ", " Image ", " Video " in such as Fig. 8 are corresponding respectively Character memory area, picture memory area and video storage.
Each described construction process data is decomposed into character portion, Picture section and video section by step S142.
Step S143, the character portion of each construction process data, Picture section and video section are stored respectively Arrive corresponding character storage area, picture storage area and video storage region.
Wherein step S140 is specifically included:
Corresponding for described for each in lowest hierarchical level item name storage location is divided into character storage by step S141 Region, picture memory area and video storage.
Each described construction process data is decomposed into character portion, Picture section and video section by step S142.
Step S143, will be corresponding respectively to the character portion of each construction process data, Picture section and video section Store character storage area, picture storage area and video storage region.Specifically, according to each construction process data Characteristic information, will be right to corresponding item name institute for each character portion storage corresponding to described construction process data In the character memory area that answers;The corresponding classification is arrived in Picture section storage corresponding to each described construction process data In picture memory area corresponding to title;Video section storage corresponding to each described construction process data is arrived corresponding In video storage corresponding to the item name.
It should be noted that looking into when make a look up in the data base of construction process data in the embodiment of the present invention Mode is looked for not to be restricted.For example, it is possible to carry out retrieval according to the item name of each level;Can be according to the word of character portion Language carries out retrieval;Numbering that can be according to corresponding to the item name of each level carries out retrieval.In addition can also, root According to the artificial lookup that store path is opened to each file.
The method can build more specification, the data base of the orderliness clearly construction process data of folk building, make battalion Building process data carries out the more specification that batch is preserved and preserved, and can be effectively protected the cultural heritage that technique built by local-style dwelling houses, Prevent local-style dwelling houses from building the loss of technique;Can easily search when needing using related construction process data and make With making local-style dwelling houses construction technique preferably be passed on.
Figure 10 is refer to, the embodiment of the present invention also provides a kind of database establishment device, and the device includes:
Acquisition module 110, for obtaining multiple construction process datas.
As shown in figure 11, specifically, the acquisition module 110 includes:
Raw data acquisition submodule 111, for gathering construction technique initial data;
Raw data table acquisition submodule 112, for obtaining multiple construction techniques according to the construction technique initial data Raw data table;
Construction process data acquisition submodule 113, for according to each construction technique raw data table, obtaining and being somebody's turn to do The corresponding construction process data of construction technique raw data table.
Sort module 120, for multiple characteristic informations for building process datas according to each construction process data Carry out tree-shaped classification, the multiple classification paths of acquisition, multiple levels from low to high and corresponding at least one classification of each level Title, wherein, in the same classification path, the item name of lower-level is subordinated to the item name of higher levels;Same In one classification path, the item name of lowest hierarchical level corresponds to the characteristic information of a construction process data.
Storage location distribute module 130, for being respectively allocated for the item name of the lowest hierarchical level in each classification path Corresponding storage location.
Memory module 140, for the characteristic information according to each construction process data, by each construction technique Data are respectively stored in the storage location corresponding to the item name in the lowest hierarchical level in corresponding classification path.
As shown in figure 12, specifically, memory module 140 includes:
Partition holding submodule 141, for by each classification path in the lowest hierarchical level the item name pair The storage location that answers is divided into character memory area, picture memory area and video storage;
Data classify submodule 142, for by each described construction process data be decomposed into character portion, Picture section and Video section;
Sub-module stored 143, for the characteristic information according to each construction process data, by each construction work Character portion corresponding to skill data is stored in the character memory area corresponding to the corresponding item name;By each institute State the Picture section corresponding to construction process data to store in the picture memory area corresponding to the corresponding item name; Video section storage corresponding to each described construction process data is deposited to the video corresponding to the corresponding item name In storage area domain.
A kind of database establishment method and apparatus provided in an embodiment of the present invention, obtains multiple construction works first in the method Skill data.Then according to the characteristic information of each construction process data carries out tree-shaped classification, multiple levels and each level is obtained Corresponding at least one item name.In two wherein adjacent levels, each classification of lower-level belongs to higher levels One classification, so can will be clearly more demarcated for the level of the information preserved in data base;Needing to search out less class name When title, the title for finding the larger classification that the less class name is much of one-level can be first needed, can enhanced convenience searching Corresponding information.The characteristic information of the corresponding construction process data of each item name of lowest hierarchical level, and be the lowermost layer Each item name of level distributes corresponding storage location, then be able to will be sought according to the characteristic information of construction process data accordingly Build process data and be respectively stored into corresponding storage location, just can be with root when the construction process data for needing inquiry related Searched according to the item name of each level successively.The database establishment method, can make construction process data carry out batch preservation And the more specification for preserving, can be effectively protected the cultural heritage that technique built by local-style dwelling houses, prevent local-style dwelling houses from building the loss of technique.
In several embodiments provided herein, it should be understood that disclosed apparatus and method, it is also possible to pass through Other modes are realized.Device embodiment described above is only schematically, for example flow chart and block diagram in accompanying drawing Show the device of multiple embodiments according to the present invention, the architectural framework in the cards of method and computer program product, Function and operation.At this point, each square frame in flow chart or block diagram can represent the one of module, program segment or a code Part, a part the holding comprising one or more logic functions for realization regulation of the module, program segment or code Row instruction.It should also be noted that in some are as the implementations that replaces, the function that marked in square frame can also be being different from The order marked in accompanying drawing occurs.For example, two continuous square frames can essentially be executed substantially in parallel, and they are sometimes Can execute in the opposite order, this is depending on involved function.It is also noted that every in block diagram and/or flow chart Individual square frame and the combination of block diagram and/or the square frame in flow chart, can use the special base for executing the function or action of regulation Realize in the system of hardware, or can combine to realize with specialized hardware and computer instruction.
In addition, each functional module in each embodiment of the invention can integrate to form an independent portion Divide, or modules individualism, it is also possible to which two or more modules are integrated to form an independent part.
If the function is realized using in the form of software function module and as independent production marketing or when using, can be with It is stored in a computer read/write memory medium.Such understanding is based on, technical scheme is substantially in other words The part contributed by prior art or the part of the technical scheme can be embodied in the form of software product, the meter Calculation machine software product is stored in a storage medium, is used including some instructions so that a computer equipment (can be individual People's computer, server, or network equipment etc.) execute all or part of step of each embodiment methods described of the invention. And aforesaid storage medium includes:USB flash disk, portable hard drive, read only memory (ROM, Read-Only Memory), random access memory are deposited Reservoir (RAM, Random Access Memory), magnetic disc or CD etc. are various can be with the medium of store program codes.Need Illustrate, herein, such as first and second or the like relational terms be used merely to by an entity or operation with Another entity or operation make a distinction, and not necessarily require or imply these entities or there is any this reality between operating The relation on border or order.And, term " including ", "comprising" or its any other variant are intended to the bag of nonexcludability Contain, so that a series of process, method, article or equipment including key elements not only includes those key elements, but also including Other key elements being not expressly set out, or also include the key element intrinsic for this process, method, article or equipment. In the absence of more restrictions, the key element for being limited by sentence "including a ...", it is not excluded that including the key element Process, method, also there is other identical element in article or equipment.
The preferred embodiments of the present invention are the foregoing is only, the present invention is not limited to, for the skill of this area For art personnel, the present invention can have various modifications and variations.All within the spirit and principles in the present invention, made any repair Change, equivalent, improvement etc., should be included within the scope of the present invention.It should be noted that:Similar label and letter exist Similar terms is represented in figure below, therefore, once being defined in a certain Xiang Yi accompanying drawing, is then not required in subsequent accompanying drawing Which is further defined and be explained.
The above, the only specific embodiment of the present invention, but protection scope of the present invention is not limited thereto, any Those familiar with the art the invention discloses technical scope in, change or replacement can be readily occurred in, should all be contained Cover within protection scope of the present invention.Therefore, protection scope of the present invention described should be defined by scope of the claims.

Claims (10)

1. a kind of database establishment method, it is characterised in that methods described includes:
Obtain multiple construction process datas;
Tree-shaped classification is carried out according to the characteristic information of each construction process data to multiple construction process datas, is obtained multiple Classification path, multiple levels from low to high and corresponding at least one item name of each level, wherein, the same classification In path, the item name of lower-level is subordinated to the item name of higher levels;Minimum in the same classification path The item name of level corresponds to the characteristic information of a construction process data;
Item name for the lowest hierarchical level in each classification path is respectively allocated corresponding storage location;
According to the characteristic information of each construction process data, each described construction process data is respectively stored into corresponding point In the storage location corresponding to the item name in the lowest hierarchical level in class.path.
2. method according to claim 1, it is characterised in that feature letter according to each construction process data Each described construction process data is respectively stored into the class name in the lowest hierarchical level in corresponding classification path by breath Claim the step in corresponding storage location, including:
Corresponding for the item name of the lowest hierarchical level in each classification path storage location is divided into character memory block Domain, picture memory area and video storage;
Each described construction process data is decomposed into character portion, Picture section and video section;
According to the characteristic information of each construction process data, by the character portion corresponding to each described construction process data Store in the character memory area corresponding to the corresponding item name;By corresponding to each described construction process data Picture section is stored in the picture memory area corresponding to the corresponding item name;By each construction process data Corresponding video section is stored in the video storage corresponding to the corresponding item name.
3. method according to claim 1, it is characterised in that described multiple construction process datas are sought according to each The characteristic information for building process data carries out tree-shaped classification, the multiple classification paths of acquisition, multiple levels from low to high and each layer After the step of level corresponding at least one item name, also include:
Each described item name of each level is numbered, the information of the numbering of each item name is subordinated to The information of the numbering of the item name of the last layer level corresponding to category title.
4. method according to claim 1, it is characterised in that described multiple construction process datas are sought according to each The characteristic information for building process data carries out tree-shaped classification, the multiple classification paths of acquisition, multiple levels from low to high and each layer After the step of level corresponding at least one item name, also include:
According to the item name, generate and the explanation information corresponding to category title.
5. method according to claim 1, it is characterised in that the step of the acquisition multiple construction process datas, including:
Collection construction technique initial data;
Multiple construction technique raw data tables are obtained according to the construction technique initial data;
According to each construction technique raw data table, the construction work corresponding with the construction technique raw data table is obtained Skill data.
6. method according to claim 5, it is characterised in that described obtained according to the construction technique initial data multiple The step of construction technique raw data table, including:
Voice data in the construction technique initial data is converted to character information;
According to the character information, the Word message, image information and video information in the construction technique initial data, obtain Multiple construction technique raw data tables.
7. method according to claim 6, it is characterised in that described according to each construction technique raw data table, The step of obtaining the construction process data corresponding with the construction technique raw data table, also includes:
The image information that specification is not met in each described construction technique raw data table is repainted, and is obtained and is redrawn figure As information;
Image information and each construction technique raw data table are redrawn according to described, is obtained and the construction technique initial data The corresponding construction process data of table.
8. a kind of database establishment device, it is characterised in that include:
Acquisition module, for obtaining multiple construction process datas;
Sort module, tree-shaped for carrying out according to each characteristic information for building process data to multiple construction process datas Classification, the multiple classification paths of acquisition, multiple levels from low to high and corresponding at least one item name of each level, its In, in the same classification path, the item name of lower-level is subordinated to the item name of higher levels;Same described In classification path, the item name of lowest hierarchical level corresponds to the characteristic information of a construction process data;
Storage location distribute module, for being respectively allocated corresponding depositing for the item name of the lowest hierarchical level in each classification path Storage space is put;
Memory module, for the characteristic information according to each construction process data, by each construction process data point Do not store in the storage location corresponding to the item name in the lowest hierarchical level in corresponding classification path.
9. device according to claim 8, it is characterised in that the memory module includes:
Partition holding submodule, for by the corresponding storage of the item name of the lowest hierarchical level in each classification path Position is divided into character memory area, picture memory area and video storage;
Data classification submodule, for being decomposed into character portion, Picture section and video portion by each described construction process data Point;
Sub-module stored, for the characteristic information according to each construction process data, by each construction process data Corresponding character portion is stored in the character memory area corresponding to the corresponding item name;By each construction Picture section corresponding to process data is stored in the picture memory area corresponding to the corresponding item name;By each Video section storage corresponding to the construction process data is to the video storage corresponding to the corresponding item name In.
10. device according to claim 8, it is characterised in that acquisition module includes:
Raw data acquisition submodule, for gathering construction technique initial data;
Raw data table acquisition submodule, for obtaining multiple construction technique initial datas according to the construction technique initial data Table;
Construction process data acquisition submodule, for according to each construction technique raw data table, obtaining and the construction work The corresponding construction process data of skill raw data table.
CN201611270035.2A 2016-12-30 2016-12-30 A kind of database establishment method and device Pending CN106504129A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201611270035.2A CN106504129A (en) 2016-12-30 2016-12-30 A kind of database establishment method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201611270035.2A CN106504129A (en) 2016-12-30 2016-12-30 A kind of database establishment method and device

Publications (1)

Publication Number Publication Date
CN106504129A true CN106504129A (en) 2017-03-15

Family

ID=58333483

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201611270035.2A Pending CN106504129A (en) 2016-12-30 2016-12-30 A kind of database establishment method and device

Country Status (1)

Country Link
CN (1) CN106504129A (en)

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109407973A (en) * 2018-09-19 2019-03-01 安徽均维信息科技有限公司 A kind of archives and information management Intelligentized regulating and controlling system
CN109492139A (en) * 2018-09-19 2019-03-19 安徽均维信息科技有限公司 A kind of intelligent archive Information Regulating method based on information classification
CN109711185A (en) * 2019-01-04 2019-05-03 杭州卓凯科技有限公司 Net based on MongoDB about goods vehicle platform data storage system and method
CN113010715A (en) * 2021-03-30 2021-06-22 通威太阳能(金堂)有限公司 Silicon wafer electroluminescence picture sorting method and device, electronic equipment and storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101984432A (en) * 2010-11-10 2011-03-09 百度在线网络技术(北京)有限公司 Method and device for constructing address database
CN103699648A (en) * 2013-12-26 2014-04-02 成都市卓睿科技有限公司 Tree-form data structure used for quick retrieval and implementation method of tree-form data structure
CN105117965A (en) * 2015-09-22 2015-12-02 中国科学院上海高等研究院 Management method and management system for history and culture information data, and server
CN104484777B (en) * 2015-01-06 2018-05-29 北京索为高科系统技术有限公司 process resource data management system and its construction method

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101984432A (en) * 2010-11-10 2011-03-09 百度在线网络技术(北京)有限公司 Method and device for constructing address database
CN103699648A (en) * 2013-12-26 2014-04-02 成都市卓睿科技有限公司 Tree-form data structure used for quick retrieval and implementation method of tree-form data structure
CN104484777B (en) * 2015-01-06 2018-05-29 北京索为高科系统技术有限公司 process resource data management system and its construction method
CN105117965A (en) * 2015-09-22 2015-12-02 中国科学院上海高等研究院 Management method and management system for history and culture information data, and server

Cited By (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109407973A (en) * 2018-09-19 2019-03-01 安徽均维信息科技有限公司 A kind of archives and information management Intelligentized regulating and controlling system
CN109492139A (en) * 2018-09-19 2019-03-19 安徽均维信息科技有限公司 A kind of intelligent archive Information Regulating method based on information classification
CN109711185A (en) * 2019-01-04 2019-05-03 杭州卓凯科技有限公司 Net based on MongoDB about goods vehicle platform data storage system and method
CN113010715A (en) * 2021-03-30 2021-06-22 通威太阳能(金堂)有限公司 Silicon wafer electroluminescence picture sorting method and device, electronic equipment and storage medium
CN113010715B (en) * 2021-03-30 2023-06-23 通威太阳能(金堂)有限公司 Silicon wafer electroluminescent picture sorting method and device, electronic equipment and storage medium

Similar Documents

Publication Publication Date Title
Moore Putting anthropology back together again: the ethnogenetic critique of cladistic theory
Hage et al. Island networks: Communication, kinship, and classification structures in Oceania
Chase et al. Urbanism and anthropogenic landscapes
CN106504129A (en) A kind of database establishment method and device
CN103810150A (en) Automatic relation nestable questionnaire generating method and device
CN110490980A (en) A kind of Virtual Construction template information processing system and method based on fixation and recognition
Heesche et al. Landscape-based transformation of young industrial landscapes
Zhang et al. GIS Based Procedural Modeling in 3D Urban Design
Garzulino et al. When GIS joins the conservation management plan of a 20th-century architectural heritage
Yang The social production of industrial heritage spaces in the background of cultural governance: a comparative study based on cases from taipei and Hong Kong
Suprapti et al. Archiving traditional houses through digital social mapping: an innovation approach for living heritage conservation in Java
Zawidzki Discrete optimization in architecture: Architectural & urban layout
CN111984795A (en) Ontology definition and modeling method for Chinese classical garden
CN106227864A (en) The most graphic data base and knowledge virtual map
Chen et al. From metropolis to allotment: Scaled system thinking in advancing landscape studio knowledge
Massimo et al. Landscape quality valuation for its preservation and treasuring
Ippoliti et al. An approach towards the construction of a digital atlas for the documentation of cloisters and courtyards in Ascoli Piceno
Fatima et al. Revitalizing the Cultural Heritage: Assessing the Historical Significance and Conservation Potential of Hindu Sites in Punjab, Pakistan
Turrina et al. The reconstruction of a dynamic inventory model toward shared HBIM libraries for vaulted systems
Chen et al. Research on the Development of Spatial Model and Value Perceptions of Lingnan’s “Water Cultural Heritage” in the Context of Generative Whole Theory
Baldissini Digital media and architectural drawings: a case study from Bramante
Arman et al. Arid Environments and Sustainability
Maietti et al. L'Academy Internazionale After the Damages [The After the Damages International Academy]
Wahyu Sejati Journal of Architecture and Urbanism Vol 46 No 1 (2022)
Garzulino et al. When GIS Joins the Conservation Management Plan of a 20th-Century Architectural Heritage. Sustainability 2021, 13, 3881

Legal Events

Date Code Title Description
C06 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: 20170315