CN104598592A - XML (Extensive Markup Language)-based database custom method and system - Google Patents
XML (Extensive Markup Language)-based database custom method and system Download PDFInfo
- Publication number
- CN104598592A CN104598592A CN201510028731.1A CN201510028731A CN104598592A CN 104598592 A CN104598592 A CN 104598592A CN 201510028731 A CN201510028731 A CN 201510028731A CN 104598592 A CN104598592 A CN 104598592A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- xml
- user
- data management
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/80—Information retrieval; Database structures therefor; File system structures therefor of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML
- G06F16/83—Querying
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Storage Device Security (AREA)
Abstract
The invention discloses an XML (Extensive Markup Language)-based database custom method, which is characterized in that the method comprises the following steps of according to user demands, describing an XML description file and database structure description information in a personalized database organization structure; on the basis of the personalized database organization structure, describing a personalized data management structure by the format of an XML document; on the basis of the personalized data management structure, managing and maintaining a database by the personalized data management structure. According to the technical scheme disclosed by the invention, the personalized customization of a database table structure and a data index query item is realized on the basis of the XML description file; on the basis of the XML description file and the database structure description information, the personalized customization of the database organization structure is realized; on the basis of user group permission control, the security management mode of data is realized.
Description
Technical field
The present invention relates to database, particularly relate to a kind of database customizing method based on XML and system.
Background technology
Along with the fast development of IT application in enterprises, the exploitation of product is no longer for single department or individual enterprise, and relates to even multiple enterprise of multiple department.In this case, product data usually with inorganization or histioid formal distribution in each Specialty Design teacher or single department hand, cause the drawbacks such as data user rate is low, double counting, shortage of data, be difficult to the sharing application forming data.Data management mode is in the past all for certain series products or certain department usually, specific aim is clear and definite, there are fixing organization structure and application model, are difficult to realize data content, data structure, the skimble-scamble data management of data base organization's structure and data sharing application.For the isomerism problem of this data, need to provide a kind of global data model to unify the source data pattern of isomery.The application system of the heterogeneous database existed in prior art, such as multidatabase system (multidatabase system as in CIMS) or federated database system adopt the data pattern of relation or object as global schema usually, but it can not meet user individual customized demand completely.In general, the global schema of isomeric data application must meet: 1, can describe various data layout, no matter it is structurized or semi-structured, and no matter whether it supports all query languages or simple text query; 2, be easy to the process accordingly such as issue, exchanges data, the data after process can be issued and be convenient to apply swapping data easily in a variety of formats.Along with the development of XML and correlation technique and application, XML not only becomes a kind of standard of application swapping data, is also one of technology of the important information exchange standard of WWW and expression.This form to edit, and easily resolves, and can be expressed as structure or the semi-structured information of any type.
Therefore, a kind of global data model that can personalize based on XML is needed to unify the source data of isomery, to ensure to be adapted to opening, development environment better (such as, the virtual company environment of enterprise) in data management, improve the sharing application of data, meet the personalized customization demand of user.
Summary of the invention
The technical problem to be solved in the present invention is to provide a kind of database customizing method based on XML and system, is difficult to realize data content, data structure, the skimble-scamble data management of data base organization's structure and data sharing application to overcome in prior art.
For solving the problems of the technologies described above, the present invention adopts following technical proposals:
Based on a database customizing method of XML, the step of the method comprises
S1, need to be described the XML description document in the institutional framework of individuation data storehouse and Database structure description information according to user;
S2, based on individuation data storehouse institutional framework, the form of XML document is utilized to be described individuation data management structure;
S3, based on individuation data management structure, individuation data management structure is utilized to administer and maintain database.
Preferably, described step S1 comprises
Data of description library structure is carried out by the hierarchical relationship of definition database institutional framework;
Utilize the mode definition database rank of adding database level another name and claiming in different database ranks;
The membership of XML description document to database table and database is utilized to be described.
Preferably, described individuation data management structure comprises the information description of data list structure.
Preferably, described step S2 is included in the document of XML format, to the title of column data item every in described tables of data, type, the data length of data item with whether search index item is described.
Preferably, described step S3 comprises
Under XML description document in data management structure is uploaded to corresponding database level by user, as required tables of data is safeguarded, data query, amendment and deletion;
User data is identified automatically by user's level of confidentiality and authority, obtains the details of these data.
Preferably, described data can be increased one by one according to the form of data structure XML description document, be uploaded by the form batch of excel file or file.
The self-defined system of database based on XML, described system comprises
Database sharing unit, needs to be described the XML description document in the institutional framework of individuation data storehouse and Database structure description information according to user;
Data management structure construction unit, based on individuation data storehouse institutional framework, utilizes the form of XML document to be described individuation data management structure;
Data Management Unit, based on individuation data management structure, utilizes individuation data management structure to administer and maintain database.
Preferably, described database sharing unit comprises
Level describing module, for the hierarchical relationship of definition database institutional framework;
Database rank definition module, utilizes the mode definition database rank of adding database level another name title in different database ranks;
Membership describing module, utilizes the membership of XML description document to database table and database to be described.
Preferably, described Data Management Unit comprises
Management data table module, need to safeguard tables of data according to user, data query, amendment and deletion;
Identification module, identifies by user's level of confidentiality and authority automatically to user data, obtains the details of these data.
Beneficial effect of the present invention is as follows:
Technical scheme of the present invention achieves based on XML description document, realizes the personalized customization to database table structure and data directory query term; Based on XML description document and the structure personalized customization of Database structure description information realization data base organization; Organize control of authority based on user, realize the security management pattern of data.
Accompanying drawing explanation
Below in conjunction with accompanying drawing, the specific embodiment of the present invention is described in further detail;
Fig. 1 illustrates a kind of schematic diagram of the database customizing method based on XML.
Embodiment
As shown in Figure 1, the invention discloses a kind of database customizing method based on XML, the step of the method comprises and needs to be described S1 to the XML description document in the institutional framework of individuation data storehouse and Database structure description information according to user, and this step comprises further carrys out data of description library structure by the hierarchical relationship of definition database institutional framework; Utilize the mode definition database rank of adding database level another name and claiming in different database ranks; The membership of XML description document to database table and database is utilized to be described.Based on individuation data storehouse institutional framework, the form of XML document is utilized to be described S2 to individuation data management structure, the information that individuation data management structure comprises data list structure describes, in the document of XML format, to the title of column data item every in described tables of data, type, the data length of data item with whether search index item is described.Based on individuation data management structure, individuation data management structure is utilized to administer and maintain S3 to database, this step comprises under the XML description document in data management structure uploads to corresponding database level by user, as required tables of data is safeguarded, data query, amendment and deletion; User data is identified automatically by user's level of confidentiality and authority, obtains the details of these data.In Database Systems, under the XML description document of data management structure is uploaded to corresponding database level by user, user increases data one by one according to the form of data structure XML description document, or by the form batch uploading data of excel and text.After data upload success, user can carry out tables of data maintenance, data query, amendment, deletion etc. and administer and maintain merits and demerits.The identification of data base management system (DBMS) to customization data is that Database Systems show which data of which database according to user's level of confidentiality and authority automatic discrimination.
The present invention further discloses the self-defined system of a kind of database based on XML, described system comprises database sharing unit, need to be described the XML description document in the institutional framework of individuation data storehouse and Database structure description information according to user, described database sharing unit comprises level describing module, for the hierarchical relationship of definition database institutional framework; Database rank definition module, utilizes the mode definition database rank of adding database level another name title in different database ranks; Membership describing module, utilizes the membership of XML description document to database table and database to be described.Data management structure construction unit, based on individuation data storehouse institutional framework, utilizes the form of XML document to be described individuation data management structure.Data Management Unit, based on individuation data management structure, utilize individuation data management structure to administer and maintain database, described Data Management Unit comprises management data table module, need to safeguard tables of data according to user, data query, amendment and deletion; Identification module, identifies by user's level of confidentiality and authority automatically to user data, obtains the details of these data.
Below by one group of embodiment, the present invention will be further described:
The first step builds individuation data storehouse institutional framework
User carries out the customization of data base organization's structure according to demand, comprise Database structure description information and
XML description document.Database structure description information is the hierarchical relationship by definition database institutional framework, carry out data of description library structure, in Database Systems, user adds database level another name as required and claims in different database ranks, complete other definition of database level, a database rank can comprise multiple lower floors rank.XML description document, for the membership of descriptive data base table and database, example is as follows:
After XML file definition, can carry out the description of database class information in Database Systems, under this rank, add corresponding XML description document, the descriptor in this XML file is other information of this database level.
Second step builds individuation data management structure
Build the descriptor that individuation data management structure needs the data list structure such as customization data list structure, data directory query term.The information of data list structure describes the title comprising data list structure composition and every column data item, the data type of data item, data length and whether search index item, and example is as follows:
Data type is varchar2 and blob type mainly, when running into long article notebook data or picture, selects blob type; The value of query is " yes ", when Database Systems are inquired about, as querying condition, when the value of query is " no ", can not occur in Database Systems as querying condition; When the value of show is " yes ", during data query information, this column data information is directly shown at the database page, when the value of show is " no ", click the particular content just checking this column data in detail, data type if the value of blob, show is necessary for no, based on the above-mentioned personalized customization realizing data directory query term.
Administering and maintaining of 3rd step data
In Database Systems, under the XML description document of data management structure is uploaded to corresponding database level by user, user increases data one by one according to the form of data structure XML description document, or by the form batch uploading data of excel and text.After data upload success, user can carry out tables of data maintenance, data query, amendment, deletion etc. and administer and maintain merits and demerits.The identification of data base management system (DBMS) to customization data is that Database Systems show which data of which database according to user's level of confidentiality and authority automatic discrimination, thus realizes the security management pattern of data.
In sum, technical scheme of the present invention achieves based on XML description document, realizes the personalized customization to database table structure and data directory query term; Based on XML description document and the structure personalized customization of Database structure description information realization data base organization; Organize control of authority based on user, realize the security management pattern of data.
Obviously; the above embodiment of the present invention is only for example of the present invention is clearly described; and be not the restriction to embodiments of the present invention; for those of ordinary skill in the field; can also make other changes in different forms on the basis of the above description; here cannot give exhaustive to all embodiments, every belong to technical scheme of the present invention the apparent change of extending out or variation be still in the row of protection scope of the present invention.
Claims (9)
1. based on a database customizing method of XML, it is characterized in that, the step of the method comprises
S1, need to be described the XML description document in the institutional framework of individuation data storehouse and Database structure description information according to user;
S2, based on individuation data storehouse institutional framework, the form of XML document is utilized to be described individuation data management structure;
S3, based on individuation data management structure, individuation data management structure is utilized to administer and maintain database.
2. database customizing method according to claim 1, is characterized in that, described step S1 comprises
Data of description library structure is carried out by the hierarchical relationship of definition database institutional framework;
Utilize the mode definition database rank of adding database level another name and claiming in different database ranks;
The membership of XML description document to database table and database is utilized to be described.
3. database customizing method according to claim 1, is characterized in that, the information that described individuation data management structure comprises data list structure describes.
4. database customizing method according to claim 3, it is characterized in that, described step S2 is included in the document of XML format, to the title of column data item every in described tables of data, type, the data length of data item with whether search index item is described.
5. database customizing method according to claim 1, is characterized in that, described step S3 comprises
Under XML description document in data management structure is uploaded to corresponding database level by user, as required tables of data is safeguarded, data query, amendment and deletion;
User data is identified automatically by user's level of confidentiality and authority, obtains the details of these data.
6. the database customizing method according to claim 1-5 any one, is characterized in that, described data can increase one by one according to the form of data structure XML description document, uploaded by the form batch of excel file or file.
7., based on the self-defined system of database of XML, it is characterized in that, described system comprises
Database sharing unit, needs to be described the XML description document in the institutional framework of individuation data storehouse and Database structure description information according to user;
Data management structure construction unit, based on individuation data storehouse institutional framework, utilizes the form of XML document to be described individuation data management structure;
Data Management Unit, based on individuation data management structure, utilizes individuation data management structure to administer and maintain database.
8. database customizing method according to claim 7, is characterized in that, described database sharing unit comprises
Level describing module, for the hierarchical relationship of definition database institutional framework;
Database rank definition module, utilizes the mode definition database rank of adding database level another name title in different database ranks;
Membership describing module, utilizes the membership of XML description document to database table and database to be described.
9. database customizing method according to claim 7, is characterized in that, described Data Management Unit comprises
Management data table module, need to safeguard tables of data according to user, data query, amendment and deletion;
Identification module, identifies by user's level of confidentiality and authority automatically to user data, obtains the details of these data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510028731.1A CN104598592A (en) | 2015-01-20 | 2015-01-20 | XML (Extensive Markup Language)-based database custom method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510028731.1A CN104598592A (en) | 2015-01-20 | 2015-01-20 | XML (Extensive Markup Language)-based database custom method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104598592A true CN104598592A (en) | 2015-05-06 |
Family
ID=53124377
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510028731.1A Pending CN104598592A (en) | 2015-01-20 | 2015-01-20 | XML (Extensive Markup Language)-based database custom method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104598592A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107992292A (en) * | 2017-11-29 | 2018-05-04 | 商派软件有限公司 | A kind of method defined by schema forms progress database |
| CN108280193A (en) * | 2018-01-26 | 2018-07-13 | 北京金雨科创自动化技术股份有限公司 | By importing data come the method and system of Fast Construction product database |
| CN110096620A (en) * | 2016-06-06 | 2019-08-06 | 福建榕基软件股份有限公司 | The mapping method and its system of database table and XML message |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1567301A (en) * | 2003-06-23 | 2005-01-19 | 华为技术有限公司 | Method and apparatus for accessing database |
| CN1604082A (en) * | 2003-08-29 | 2005-04-06 | 微软公司 | Mapping architecture for arbitrary data models |
| US20050131895A1 (en) * | 2003-12-16 | 2005-06-16 | Software Ag | Method for searching a database and database |
| CN101059799A (en) * | 2006-04-20 | 2007-10-24 | 上海宝信软件股份有限公司 | Method for introducing regular file into data base |
| CN101067814A (en) * | 2007-05-10 | 2007-11-07 | 浪潮集团山东通用软件有限公司 | Mapping conversion method between data access level Xml format data and relational data |
| US8335851B1 (en) * | 2012-03-12 | 2012-12-18 | Ringcentral, Inc. | Network resource deployment for cloud-based services |
-
2015
- 2015-01-20 CN CN201510028731.1A patent/CN104598592A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1567301A (en) * | 2003-06-23 | 2005-01-19 | 华为技术有限公司 | Method and apparatus for accessing database |
| CN1604082A (en) * | 2003-08-29 | 2005-04-06 | 微软公司 | Mapping architecture for arbitrary data models |
| US20050131895A1 (en) * | 2003-12-16 | 2005-06-16 | Software Ag | Method for searching a database and database |
| CN101059799A (en) * | 2006-04-20 | 2007-10-24 | 上海宝信软件股份有限公司 | Method for introducing regular file into data base |
| CN101067814A (en) * | 2007-05-10 | 2007-11-07 | 浪潮集团山东通用软件有限公司 | Mapping conversion method between data access level Xml format data and relational data |
| US8335851B1 (en) * | 2012-03-12 | 2012-12-18 | Ringcentral, Inc. | Network resource deployment for cloud-based services |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110096620A (en) * | 2016-06-06 | 2019-08-06 | 福建榕基软件股份有限公司 | The mapping method and its system of database table and XML message |
| CN110096620B (en) * | 2016-06-06 | 2021-02-26 | 福建榕基软件股份有限公司 | Mapping method and system for database table and XML message |
| CN107992292A (en) * | 2017-11-29 | 2018-05-04 | 商派软件有限公司 | A kind of method defined by schema forms progress database |
| CN108280193A (en) * | 2018-01-26 | 2018-07-13 | 北京金雨科创自动化技术股份有限公司 | By importing data come the method and system of Fast Construction product database |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102789491B (en) | A kind of configurable data subscription and delivery system and method thereof | |
| CN104598592A (en) | XML (Extensive Markup Language)-based database custom method and system | |
| CN103473332A (en) | Data archive repository with virtual test architecture | |
| Bellatreche et al. | Referential horizontal partitioning selection problem in data warehouses: Hardness study and selection algorithms | |
| Delmelle et al. | Methods for space-time analysis and modeling: An overview | |
| CN103995832A (en) | Complex relational data storage technology implementation method based on separation of attributes and relations | |
| Kharlamov et al. | Modeling, querying, and mining uncertain XML data | |
| El Yazidi et al. | FMAMS: fuzzy mapping approach for mediation systems | |
| Holanda et al. | Query languages in nosql databases | |
| Thalos | Existentialism and Existential Theology | |
| Liu et al. | Distributed databases | |
| Morgain | Feminism and Anthropology | |
| Moro | Celebrity | |
| Franz‐Guess et al. | Eukoenenia spelaea, Palpigradi: Nervous System | |
| Kong YuanYuan et al. | Practice of management of auto-reporting of communicable diseases based on electronic medical records. | |
| Brin et al. | Characterization of Anopheles gambiae Slc26a5 and potential role in malaria | |
| Mechelen et al. | Two‐mode Clustering | |
| Bellatreche | A Genetic Algorithm for Selecting Horizontal Fragments | |
| Mandal | Intertext | |
| Wartenberg | Family Wage | |
| Hudis | Labor Theory of Value | |
| Potter | L emoine, A nn | |
| Brown et al. | Family Lineage | |
| Isaja | Raw Data Connection Services and Tools | |
| Sinkovics | International channel management |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150506 |
|
| RJ01 | Rejection of invention patent application after publication |