CN106802938A - Client's hierarchical attribute dynamic creation method based on modularization - Google Patents
Client's hierarchical attribute dynamic creation method based on modularization Download PDFInfo
- Publication number
- CN106802938A CN106802938A CN201611256737.5A CN201611256737A CN106802938A CN 106802938 A CN106802938 A CN 106802938A CN 201611256737 A CN201611256737 A CN 201611256737A CN 106802938 A CN106802938 A CN 106802938A
- Authority
- CN
- China
- Prior art keywords
- client
- sql
- hierarchical attribute
- constraintss
- infrastructure component
- 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.)
- Withdrawn
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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24547—Optimisations to support specific applications; Extensibility of optimisers
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
-
- 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
- G06F16/835—Query processing
- G06F16/8365—Query optimisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Computational Linguistics (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Strategic Management (AREA)
- Marketing (AREA)
- Development Economics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to a kind of electric quotient data storehouse maintenance optimization field, there is provided the mobilism SQL query method based on XML configurations.Two or more HTML controls are constituted into infrastructure component；SQL constraintss to SQL database are set up to the infrastructure component；The configuration of the first XML file will be constituted comprising SQL constraintss and infrastructure component；Client's hierarchical attribute and first XML file are constituted into the 2nd XML configurations and obtains the SQL constraintss comprising client's hierarchical attribute.After using technical scheme, a hierarchical attribute is combined to various infrastructure components by one, though hierarchical attribute is more, infrastructure component is can be controlled within ten kinds；The SQL constraintss of optimized integration component.
Description
Technical field
The present invention relates to a kind of electric quotient data storehouse maintenance optimization field, more particularly to a kind of client's layering based on modularization
Attribute dynamic creation method.
Background technology
Increasingly competitive in the product of e-commerce field, it is to raise the management level to implement multi-zone supervision to client
With the only way of service level, in this way, could solve between people, the finiteness of wealth and goods and materials source and the diversity of customer demand
Contradiction, there is provided better than the products ＆ services of horizontal competition opponent.In the main product in the current field, client's layering is main logical
Cross and define different hierarchical attributes and screen client, and each hierarchical attribute then realizes front end exhibition by the splicing of HTML controls
Show, backstage then generates SQL constraintss for the attribute, and each hierarchical attribute is highly coupled with HTML controls, SQL,
It is difficult to be extended and safeguard, once there is problem or demand change, then need that whole flow process is carried out to recompile test, sternly
Have impact on the development progress of system again, and splicing HTML and SQL code, very disruptive code is readable, and causes to ask
Topic is difficult to investigate.
The content of the invention
In view of this, the present invention provides a kind of mobilism SQL query method based on XML configurations, realizes simplifying client point
The purpose of layer attribute generating mode.
In order to reach above-mentioned purpose of the invention, technical scheme is as follows.
Client's hierarchical attribute dynamic creation method based on modularization, realizes the conversion of HTML controls and SQL constraints, is easy to
Client is screened beneficial to client's hierarchical attribute, two or more HTML controls are constituted into infrastructure component；To the base set
Part sets up the SQL constraintss to SQL database；The first XML file will be constituted comprising SQL constraintss and infrastructure component to match somebody with somebody
Put；Client's hierarchical attribute and first XML file are constituted into the 2nd XML configurations and obtains the SQL comprising client's hierarchical attribute about
Beam condition.
Preferably, in certain embodiments, infrastructure component include choice box, input frame, radio box, check box, in the time
One kind and their cascade.
Preferably, in certain embodiments, the infrastructure component is configured with Database field parameter or value manner of comparison bar
Part.
Preferably, in certain embodiments, the SQL constraintss comprising client's hierarchical attribute can only comprising one kind
Infrastructure component can also be by various infrastructure components.
After using technical scheme, a hierarchical attribute is combined to various infrastructure components by one, layering
Though attribute is more, infrastructure component is can be controlled within ten kinds；The SQL constraintss of optimized integration component.It is each basis
The parameters such as component Configuration Database field, manner of comparison, the constraints of database, optimized integration component are assembled into according to parameter
To the conversion of SQL constraints；The infrastructure component combination of client's hierarchical attribute is configured in xml, be can configure one or more, and
Parameter needed for each infrastructure component is specified, then system can automatically generate the pattern of realizing of hierarchical attribute by configuring, and according to parameter
The SQL constraintss of hierarchical attribute are realized, it is achieved thereby that the modularization of client's hierarchical attribute, automation implementation.
The present inventor generally describes the features and advantages of the present invention in this content of the invention chapters and sections；However, of the invention
A pair all technical schemes based on spirit of the present invention by way of exhaustion are difficult to be enumerated.So, will below pass through
The citing implemented to the present invention, makes the spirit of the present invention have been able to clearly slap for those of ordinary skills
Hold, so, the other feature, advantage and the embodiment that are given are not known in the present invention for having checked ability of the invention
All it is clearly, it should therefore be understood that to repairing done by the present invention after having drawn the present invention for the those of ordinary skill of domain
All within the protection domain of this patent, the change pessimum technical scheme for being made on the basis of of the invention also belongs to for decorations and improvement
In in the protection domain of this patent.
Brief description of the drawings
Fig. 1 is embodiment of the present invention schematic diagram.
Specific embodiment
To enable the above objects, features and advantages of the present invention more obvious understandable, embodiment will be below enumerated to this
The specific embodiment of invention elaborates.Elaborate in the following description in order to fully understand specific reality of the invention
Example is applied, but, the present invention can be implemented with different from mode described below, and those skilled in the art can be without prejudice to this hair
Similar popularization is done in the case of bright intension.Therefore, the present invention is not limited by the specific embodiment of following discloses.
As shown in figure 1, the present embodiment be based on modularization client's hierarchical attribute dynamic creation method, by two or two with
On HTML controls composition infrastructure component；In the infrastructure component species of the present embodiment design, every kind of infrastructure component is representative,
Durability high, all infrastructure components and combinations thereof cover all client's hierarchical attribute requirements.Combination HTML controls are a basis
Component, infrastructure component configuration is stored in the first XML file.The SQL set up to above-mentioned infrastructure component to SQL database is constrained
Condition；I.e. according to the configuration parameter of infrastructure component, the SQL constraints create-rules of each infrastructure component are determined.To include
SQL constraintss constitute the configuration of the first XML file with infrastructure component；I.e. according to the binding characteristic of client's hierarchical attribute, it is configured
The combination and parameter of infrastructure component；And the rule of combination configuration of client's hierarchical attribute is saved in XML file.Again by visitor
Family hierarchical attribute constitutes the 2nd XML configurations and obtains the SQL constraintss comprising client's hierarchical attribute with first XML file,
Will the infrastructure component that includes of client's hierarchical attribute, the create-rule of the SQL constraintss according to each infrastructure component is combined into
The constraint database condition of attribute；According to it is between multiple client's hierarchical attributes and or relation, generate composite attribute SQL
Constraints.In this way, the SQL of generation composite attribute is constrained bar by the present embodiment, as long as the SQL statement of the generation is submitted to
Database processing, filters out the client that the attribute or combinations of attributes are included.
Above-mentioned client's hierarchical attribute dynamic creation method based on modularization of the present embodiment, infrastructure component includes selection
Frame, input frame, radio box, check box, the one kind in the time and their cascade.Infrastructure component is configured with Database field ginseng
Number or value manner of comparison condition.Additionally, the SQL constraintss comprising client's hierarchical attribute can only include a kind of infrastructure component
Can be by various infrastructure components.
Claims (4)
1. the client's hierarchical attribute dynamic creation method based on modularization, realizes the conversion of HTML controls and SQL constraints, is easy to profit
Client is screened in client's hierarchical attribute, it is characterised in that two or more HTML controls are constituted into infrastructure component；To institute
State infrastructure component and set up the SQL constraintss for arriving SQL database；An XML will be constituted comprising SQL constraintss and infrastructure component
File configuration；Client's hierarchical attribute and first XML file are constituted into the 2nd XML configurations to obtain comprising client's hierarchical attribute
SQL constraintss.
2. the client's hierarchical attribute generation method in modularization according to claim 1, it is characterised in that infrastructure component bag
Include choice box, input frame, radio box, check box, the one kind in the time and their cascade.
3. the client's hierarchical attribute generation method in modularization according to claim 1, it is characterised in that the base set
Part is configured with Database field parameter or value manner of comparison condition.
4. the client's hierarchical attribute generation method in modularization according to claim 1, it is characterised in that described comprising visitor
The SQL constraintss of family hierarchical attribute can only can also be by various infrastructure components comprising a kind of infrastructure component.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611256737.5A CN106802938A (en) | 2016-12-30 | 2016-12-30 | Client's hierarchical attribute dynamic creation method based on modularization |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201611256737.5A CN106802938A (en) | 2016-12-30 | 2016-12-30 | Client's hierarchical attribute dynamic creation method based on modularization |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN106802938A true CN106802938A (en) | 2017-06-06 |
Family
ID=58985335
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201611256737.5A Withdrawn CN106802938A (en) | 2016-12-30 | 2016-12-30 | Client's hierarchical attribute dynamic creation method based on modularization |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106802938A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1585945A (en) * | 2001-09-28 | 2005-02-23 | 甲骨文国际公司 | Mechanism for mapping XML schemas to object-relational database systems |
| CN1862538A (en) * | 2006-02-27 | 2006-11-15 | 华为技术有限公司 | Data configuration system and method for implementing data configuration |
| CN101872449A (en) * | 2010-06-25 | 2010-10-27 | 南京联创科技集团股份有限公司 | Customer information screening method |
| CN105183917A (en) * | 2015-10-15 | 2015-12-23 | 国家电网公司 | Multi-dimensional analysis method for multi-level storage data |
| CN105279269A (en) * | 2015-10-27 | 2016-01-27 | 中通服公众信息产业股份有限公司 | SQL generating method and system for supporting table free association |
-
2016
- 2016-12-30 CN CN201611256737.5A patent/CN106802938A/en not_active Withdrawn
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1585945A (en) * | 2001-09-28 | 2005-02-23 | 甲骨文国际公司 | Mechanism for mapping XML schemas to object-relational database systems |
| CN1862538A (en) * | 2006-02-27 | 2006-11-15 | 华为技术有限公司 | Data configuration system and method for implementing data configuration |
| CN101872449A (en) * | 2010-06-25 | 2010-10-27 | 南京联创科技集团股份有限公司 | Customer information screening method |
| CN105183917A (en) * | 2015-10-15 | 2015-12-23 | 国家电网公司 | Multi-dimensional analysis method for multi-level storage data |
| CN105279269A (en) * | 2015-10-27 | 2016-01-27 | 中通服公众信息产业股份有限公司 | SQL generating method and system for supporting table free association |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Costas et al. | Applying Goldratt’s Theory of Constraints to reduce the Bullwhip Effect through agent-based modeling | |
| CA2446809A1 (en) | General and reusable components for defining net-centric application program architectures | |
| CN102136109B (en) | Product structure tree-based design flow dynamic modeling method | |
| CN105320504A (en) | Visual software modeling method for constructing software view on basis of software meta view | |
| Prell et al. | Unequal carbon exchanges: The environmental and economic impacts of iconic US consumption items | |
| CN107017992A (en) | A kind of high-performance alliance block chain based on duplex structure | |
| CN110232178A (en) | Report generation method and device | |
| CN104346449A (en) | Data merging method and data merging device | |
| Chandan et al. | Lean start-up in market penetration using DMADV methodology: an empirical study | |
| CN110189185A (en) | A kind of rough house fitting-out work standard quotation system | |
| CN109697217A (en) | A kind of block chain transaction methods | |
| CN106802938A (en) | Client's hierarchical attribute dynamic creation method based on modularization | |
| KR101061146B1 (en) | Intelligent Home Business Model Supporting Device and Method | |
| CN105590249A (en) | Quotation information inquiry system, method and B2B purchasing management system | |
| CN103455551A (en) | Schedule data processing method and device based on performance resources | |
| CN105512895A (en) | Power transaction management method based on multi-factor combination modeling and power transaction management system thereof | |
| CN107273131A (en) | A kind of machine learning method applied to Configurable BOM | |
| CN102841892A (en) | Service encapsulation system and method of relational data | |
| US20150363711A1 (en) | Device for rapid operational visibility and analytics automation | |
| CN104317913A (en) | Screening method and screening device of attribute combination | |
| Tekinerdogan et al. | Modeling and reasoning about design alternatives of software as a service architectures | |
| CN108241981A (en) | A kind of CRM system | |
| CN104657476A (en) | On-line analytical processing method and system | |
| CN106096864A (en) | Service configuration device, system and method | |
| Sun et al. | Roadmapping the disruptive innovation based on technology system decomposition analysis |
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 | ||
| CB03 | Change of inventor or designer information | ||
| CB03 | Change of inventor or designer information |
Inventor after: Chen Biyong Inventor after: Fang Min Inventor after: Lv Ye Inventor before: Li Quanyou |
|
| WW01 | Invention patent application withdrawn after publication | ||
| WW01 | Invention patent application withdrawn after publication |
Application publication date: 20170606 |