CN108681589A - Structured query language instruction generation method based on index system and device - Google Patents
Structured query language instruction generation method based on index system and device Download PDFInfo
- Publication number
- CN108681589A CN108681589A CN201810462636.6A CN201810462636A CN108681589A CN 108681589 A CN108681589 A CN 108681589A CN 201810462636 A CN201810462636 A CN 201810462636A CN 108681589 A CN108681589 A CN 108681589A
- Authority
- CN
- China
- Prior art keywords
- data
- index
- query language
- structured query
- data subject
- 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.)
- Granted
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The structured query language instruction generation method and device that the invention discloses a kind of based on index system, wherein the structured query language instruction generation method based on index system includes：According to tables of data, structure includes the index system of multiple index models and Data subject fairground；Data subject in Data subject fairground is configured, configuration data corresponding with Data subject is obtained；According to configuration data, structured query language instruction corresponding with Data subject is generated；It is instructed using structured query language, obtains access service.According to technical solution provided by the invention, can fast and automatically, be flexibly generated suitable various businesses demand structured query language instruction, establish the relationship maps relationship between index system and SQL services, effectively meet various businesses demand, the uniqueness that ensure that data target efficiently avoids the inconsistent problem of index bore.
Description
Technical field
The present invention relates to technical field of data processing, and in particular to a kind of structured query language based on index system refers to
Enable generation method and device.
Background technology
With the rapid development of information technology, having welcome the big data epoch, need to carry out data processing to mass data.One
As be by data carry out analyzing processing, convert data to the understandable dimension of user, provide from possible each dimension
Spend obtain user needs data target, obtain visual report, so as to user quickly and intuitively understand business development and
Determine that business carries out strategy.In the prior art, report is obtained generally by following two processing modes.Wherein, the first
Processing mode be various data processing scripts are obtained by manual compiling structured query language instruction (i.e. SQL instructions), and
Data source and report displaying are associated binding, this processing mode needs to expend a large amount of human cost, treatment effeciency compared with
Low, report association process complexity is cumbersome, is unfavorable for uniformly safeguarding.Second of processing mode is associated based on tables of data, multilist
Mode automatically generates SQL instructions, is then bound with the visualization interface of report, maintenance of this processing mode to tables of data
Measure it is larger, between tables of data can exist overlap index, when some tables of data changes, other tables of data do not perceive,
Cause serious data quality problem.
Invention content
In view of the above problems, it is proposed that the present invention overcoming the above problem in order to provide one kind or solves at least partly
State the structured query language instruction generation method and device based on index system of problem.
According to an aspect of the invention, there is provided a kind of structured query language based on index system instructs generation side
Method, this method include：
According to tables of data, structure includes the index system of multiple index models and Data subject fairground；
Data subject in Data subject fairground is configured, configuration data corresponding with Data subject is obtained；
According to configuration data, structured query language instruction corresponding with Data subject is generated；
It is instructed using structured query language, obtains access service.
Further, according to tables of data, structure include multiple index models and Data subject fairground index system into
One step includes：
Tables of data is handled, multiple index models are established；
According to multiple index models, foundation includes the Data subject fairground of multiple Data subjects, obtains index system.
Further, tables of data is handled, establishes multiple index models and further comprises：
Using the wide table of the data in tables of data and/or mid-module table as data model, to the metadata of data model into
Multiple index models are established in row analyzing processing.
Further, multiple index models include：Basic dimension index model, metric index model, virtual dimension index
Model, derivative index model and parameter model.
Further, the Data subject in Data subject fairground is configured, obtains configuration corresponding with Data subject
Data further comprise：
Essential information, component and/or report page template identification are configured for Data subject, is obtained corresponding with Data subject
Configuration data.
Further, component includes：Summarize component, detailed component, trend component and download component.
Further, it is being somebody's turn to do after generating structured query language instruction corresponding with Data subject according to configuration data
Method further includes：
According to configuration data, report displayed page instruction corresponding with Data subject is generated；
It is instructed using structured query language instruction and report displayed page, obtains Report Forms Service.
Further, it according to configuration data, generates report displayed page instruction corresponding with Data subject and further comprises：
According to configuration data, extensible markup language instruction corresponding with Data subject is generated；
According to the report page template identification in configuration data, from the default report page based on extensible stylesheet table transfer language
Report page template corresponding with report page template identification is inquired in face die plate fairground；
Page Template instruction corresponding to extensible markup language instruction and the report page template inquired is subjected to group
It closes, generates the instruction of report displayed page.
Further, it is instructed using structured query language, obtains access service and further comprise：
It executes corresponding with Data subject structured query language to instruct, obtains data query result, and by data query
As a result it is back to access service call end.
According to another aspect of the present invention, a kind of data query method based on index system is provided, this method includes：
Obtain the inquiry constraints that user is arranged in the data query page；
According to inquiry constraints, instructed to server-side request structured query language corresponding with inquiry constraints；
It is instructed using structured query language, obtains data query result.
Further, it is instructed using structured query language, obtains data query result and further comprise：
Structured query language is instructed and carries out dissection process, obtains executable structure query language instructions；
Executable structure query language instructions are executed, data query result is obtained.
According to another aspect of the present invention, a kind of structured query language instruction generation dress based on index system is provided
It sets, which includes：
Index system establishment module is suitable for according to tables of data, and structure includes multiple index models and Data subject fairground
Index system；
Configuration module obtains corresponding with Data subject suitable for being configured to the Data subject in Data subject fairground
Configuration data；
Generation module is suitable for, according to configuration data, generating structured query language instruction corresponding with Data subject；
Service module of fetching obtains access service suitable for being instructed using structured query language.
Further, index system establishment module is further adapted for：
Tables of data is handled, multiple index models are established；
According to multiple index models, foundation includes the Data subject fairground of multiple Data subjects, obtains index system.
Further, index system establishment module is further adapted for：
Using the wide table of the data in tables of data and/or mid-module table as data model, to the metadata of data model into
Multiple index models are established in row analyzing processing.
Further, multiple index models include：Basic dimension index model, metric index model, virtual dimension index
Model, derivative index model and parameter model.
Further, configuration module is further adapted for：
Essential information, component and/or report page template identification are configured for Data subject, is obtained corresponding with Data subject
Configuration data.
Further, component includes：Summarize component, detailed component, trend component and download component.
Further, generation module is further adapted for：According to configuration data, report displaying corresponding with Data subject is generated
The page instructs；
The device further includes：Report Forms Service module, suitable for being referred to using structured query language instruction and report displayed page
It enables, obtains Report Forms Service.
Further, generation module is further adapted for：
According to configuration data, extensible markup language instruction corresponding with Data subject is generated；
According to the report page template identification in configuration data, from the default report page based on extensible stylesheet table transfer language
Report page template corresponding with report page template identification is inquired in face die plate fairground；
Page Template instruction corresponding to extensible markup language instruction and the report page template inquired is subjected to group
It closes, generates the instruction of report displayed page.
Further, access service module is further adapted for：
It executes corresponding with Data subject structured query language to instruct, obtains data query result, and by data query
As a result it is back to access service call end.
According to another aspect of the present invention, a kind of data query arrangement based on index system is provided, which includes：
Acquisition module, the inquiry constraints being arranged in the data query page suitable for obtaining user；
Request module is suitable for according to inquiry constraints, to server-side request structuring corresponding with inquiry constraints
Query language instructions；
Enquiry module is suitable for being instructed using structured query language, obtains data query result.
Further, enquiry module is further adapted for：
Structured query language is instructed and carries out dissection process, obtains executable structure query language instructions；
Executable structure query language instructions are executed, data query result is obtained.
According to another aspect of the present invention, a kind of computing device is provided, including：Processor, memory, communication interface and
Communication bus, processor, memory and communication interface complete mutual communication by communication bus；
For memory for storing an at least executable instruction, it is above-mentioned based on index system that executable instruction makes processor execute
The corresponding operation of structured query language instruction generation method.
According to another aspect of the present invention, a kind of computer storage media is provided, at least one is stored in storage medium
Executable instruction, executable instruction make processor execute the structured query language instruction generation side based on index system as above-mentioned
The corresponding operation of method.
According to another aspect of the invention, a kind of computing device is provided, including：Processor, memory, communication interface and
Communication bus, processor, memory and communication interface complete mutual communication by communication bus；
For memory for storing an at least executable instruction, it is above-mentioned based on index system that executable instruction makes processor execute
The corresponding operation of data query method.
In accordance with a further aspect of the present invention, a kind of computer storage media is provided, at least one is stored in storage medium
Executable instruction, executable instruction make processor execute such as the above-mentioned corresponding operation of data query method based on index system.
According to technical solution provided by the invention, it is based on tables of data, constructs unified index model and Data subject collection
City completes the foundation of index system, and by way of modularization, can fast and automatically, be flexibly generated it is suitable various
The structured query language of business demand instructs, and not only increases instruction formation efficiency, reduces the manpower write needed for instruction
Cost, but also the relationship maps relationship between index system and SQL services is established, effectively meeting various businesses needs
It asks；In addition, the technical solution can ensure the uniqueness of data target, the inconsistent problem of index bore is efficiently avoided,
Structured query language instruction generating mode is optimized, can unified safeguard and effectively management easily be carried out to tables of data.
Above description is only the general introduction of technical solution of the present invention, in order to better understand the technical means of the present invention,
And can be implemented in accordance with the contents of the specification, and in order to allow above and other objects of the present invention, feature and advantage can
It is clearer and more comprehensible, below the special specific implementation mode for lifting the present invention.
Description of the drawings
By reading the detailed description of hereafter preferred embodiment, various other advantages and benefit are common for this field
Technical staff will become clear.Attached drawing only for the purpose of illustrating preferred embodiments, and is not considered as to the present invention
Limitation.And throughout the drawings, the same reference numbers will be used to refer to the same parts.In the accompanying drawings：
Fig. 1 a show the structured query language instruction generation method according to the ... of the embodiment of the present invention based on index system
Flow diagram；
Fig. 1 b show the structure schematic diagram of index system；
The flow diagram for the data query method based on index system that Fig. 2 shows according to the ... of the embodiment of the present invention；
Fig. 3 shows the structured query language command generating device according to the ... of the embodiment of the present invention based on index system
Structure diagram；
Fig. 4 shows the structure diagram of the data query arrangement according to the ... of the embodiment of the present invention based on index system；
Fig. 5 shows a kind of structural schematic diagram of computing device according to the ... of the embodiment of the present invention.
Specific implementation mode
The exemplary embodiment of the disclosure is more fully described below with reference to accompanying drawings.Although showing the disclosure in attached drawing
Exemplary embodiment, it being understood, however, that may be realized in various forms the disclosure without should be by embodiments set forth here
It is limited.On the contrary, these embodiments are provided to facilitate a more thoroughly understanding of the present invention, and can be by the scope of the present disclosure
Completely it is communicated to those skilled in the art.
Fig. 1 a show the structured query language instruction generation method according to the ... of the embodiment of the present invention based on index system
Flow diagram, as shown in Figure 1a, this method comprises the following steps：
Step S100, according to tables of data, structure includes the index system of multiple index models and Data subject fairground.
This method can be executed by server-side.It builds to obtain index system in order to be based on tables of data, need to tables of data
It is handled, establishes multiple index models, then according to the multiple index models established, foundation includes multiple Data subjects
Data subject fairground, to obtain index system.Specifically, tables of data may include thering is the wide table of data and narrower table, may be used also
It include the corresponding tables of data of each layer data model such as high-level model, intermediate layer model and underlying model.Wherein, data
Wide table refers to that field is relatively more, the more tables of data of dimension hierarchy that includes, usually by the relevant index of business-subject, dimension
Degree, Attribute Association together, count convenient for access；Narrower table refers to that field is fewer, the dimension hierarchy that includes is fewer
Tables of data.During data modeling, it is generally divided into high-level model foundation, middle layer model foundation and underlying model and establishes three
Level, wherein high-level model belongs to entity relationship layer, and underlying model belongs to physical layer, it is established complete high-level model
Afterwards, an intermediate layer model will be established to each entity identified in high-level model, is equivalent to and establishes item set.
The present invention, can be by the wide table of data and/or mid-module in tables of data during establishing multiple index models
Table carries out analyzing processing as data model, to the metadata of data model, to establish multiple index models.Mid-module table
It refer to the corresponding tables of data of middle layer model.Multiple index models may include：Basic dimension index model, Measure Indexes mould
Type, virtual dimension index model, derivative index model and parameter model.It specifically, can be in the metadata of data model
Field carry out analyzing processing, it is abstract to obtain basic dimension index, Measure Indexes, virtual dimension index, derivative index and calculating
Index, to obtain basic dimension index model, metric index model, virtual dimension index model, derivative index model and meter
Calculate index model.Wherein, basic dimension index is for describing inquiry constraint, Classifying Sum, the associated major key of multilist and external key, degree
Figureofmerit is used for the fact that describe business procedure data, and factual data is generally the decimal data of integer or floating type, empty
Quasi- dimension index is used to describe dimension index and the associated major key of multilist originally no in self-defined inquiry constraint, tables of data
With external key title inconsistence problems, derivative index is the Measure Indexes after defining qualifier, and parameter is by mathematics
The index obtained after operation.
After establishing multiple index models, corresponding multiple Data subjects are determined, obtain including multiple data
The Data subject fairground of theme.Wherein, index model can be with the correspondence of multi-to-multi, such as a data master with Data subject
The corresponding multiple index models of topic.The Data subject fairground, which has, ensures index model unification, unduplicated feature.Art technology
The Data subject in Data subject fairground can be arranged in personnel according to actual needs, be not specifically limited herein.For example, Data subject
It may include：Marketing data theme, transaction data theme, commodity data theme, data on flows theme, coupon data theme or
Service commodity certificate Data subject, wherein discount coupon can be the coupons suitable for service location or completely subtract certificate etc., service commodity
Certificate can be coupons or the convertible note etc. for exchanging practical business service.Obtaining multiple index models and Data subject
After fairground, that is, the structure to index system is completed, the structure schematic diagram of index system can be as shown in Figure 1 b, according to multiple numbers
Multiple index models are established according to table 111, are basic dimension index model 121, metric index model 122, virtual dimension respectively
Index model 123, derivative index model 124 and parameter model 125 establish packet then according to above-mentioned multiple index models
Data subject fairground 130 containing multiple Data subjects 131.
Step S101 configures the Data subject in Data subject fairground, obtains configuration corresponding with Data subject
Data.
After the structure for the system of hitting the target, it is also necessary to match to each Data subject in Data subject fairground
It sets.Specifically, it can be that Data subject configures essential information, component and/or report page template identification etc., obtain and Data subject
Corresponding configuration data.Wherein, essential information may include：Name information and description information etc.；Component may include：Summarize component,
Detailed component, trend component and download component etc.；Report page template identification can be report page template ID etc..In concrete application
In, the process configured to Data subject can be broadly divided into 4 steps, and step 1 is from multiple numbers in Data subject fairground
According to one Data subject configured of selection in theme, and it is selected Data subject configuration name information and description
The essential informations such as information；Step 2 is for selected Data subject configuration querying constraints；Step 3 is for selected number
Required different component is configured according to theme；Step 4 is for selected Data subject distribu-tion index calculation.Wherein,
Data subject can be supported multi-threaded to be freely associated with；A variety of operators, parameter branch are supported during configuration querying constraints
It holds optional and essential；During configuration component, the component of configuration is supported to may include but be not limited to：Summarize component, detailed group
Part, trend component and download component etc.；Index calculation may include but be not limited to：Basic method of summary and customizing method,
Basic method of summary may include：Sum functions and count functions etc., customizing method may include：Calculate output and compound output
Deng, it calculates and exports to carry out calculation processing to the summarized results obtained based on basic method of summary, it is compound to export as to data pair
As and/or based on the obtained summarized results of basic method of summary carries out combined processing, such as calculates output and may include data pair
As the summarized results of A and the summarized results of data object B carry out processing etc. of being divided by, compound output may include utilizing the sides join ()
Method such as handles at the data object A and data object B.In addition, can also be that Data subject configures corresponding report page template
Mark, determines report page template used by the Data subject.
Step S102 generates structured query language instruction corresponding with Data subject according to configuration data.
In order to obtain access service with for users to use, after obtaining configuration data corresponding with Data subject,
It also needs, according to configuration data, to generate structured query language instruction (i.e. SQL instructions) corresponding with Data subject, and will be generated
SQL corresponding with Data subject instruction store to server-side.Wherein, SQL is a kind of data base querying and programming language,
Support nesting of statements, service-transparency that there are the advantages such as great flexibility, powerful migration and portability.
Wherein, during generating SQL instructions corresponding with Data subject, default SQL can be based on and instruct create-rule
SQL instructions corresponding with Data subject are generated automatically according to configuration data.Those skilled in the art can set according to actual needs
Default SQL instructions create-rule is set, is not specifically limited herein.For example, what default SQL instructions create-rule can export needs
The table name of tables of data used in index, inquiry, the association being grouped between the basic dimension index being based on, different data theme
Mode, used basic dimension index, inquiry constraints and qualifier etc. are provided, in addition, default SQL instructions generate
Rule may also dictate that the index for being not engaged in grouping cannot be exported individually, need to carry out calculation process to it using Aggregation Operator,
And based on identical basic dimension index or identical virtual dimension index as multilist Correlation Criteria etc..The present invention passes through
The mode of modularization, can quickly, be flexibly generated suitable various businesses demand structured query language instruction, establish finger
Relationship maps relationship between mark system and SQL services, effectively meets various businesses demand.
Step S103, is instructed using structured query language, obtains access service.
After generating structured query language instruction corresponding with Data subject, so that it may utilize structured query language
Instruction obtains access service.Specifically, structured query language instruction corresponding with Data subject is executed, data query is obtained
As a result, and data query result is back to access service call end.Wherein, the structuring corresponding with Data subject generated
Query language instructions can be used as a part for access information on services, by executing structured query language corresponding with Data subject
Instruction can easily obtain data query result, data query result is then back to access service call end, for taking
Number service call end uses.Specifically, different structured query language can be corresponding with (such as detailed component) for some components
Instruction, then the structuralized query corresponding to same component in structured query language corresponding with Data subject being instructed
Sound instruction is combined, and is then concurrently executed, and implementing result gathers as data query knot after the completion of execution
Fruit.
Optionally, after step s 102, this method may also include：According to configuration data, generate corresponding with Data subject
Report displayed page instruction；It is instructed using structured query language instruction and report displayed page, obtains Report Forms Service.Separately
Outside, report displayed page instruction corresponding with Data subject can will be also generated to store to server-side.It specifically, can first basis
Configuration data generates extensible markup language instruction (i.e. XML instructions) corresponding with Data subject, then according in configuration data
Report page template identification, from the default report page template fairground based on extensible stylesheet table transfer language inquiry and report
Page Template identifies corresponding report page template, the report page template that then extensible markup language is instructed and inquired
Corresponding Page Template instruction is combined, and generates the instruction of report displayed page.
During generating XML instructions corresponding with Data subject, default XML can be based on and instruct create-rule automatically
XML instructions corresponding with Data subject are generated according to configuration data.Those skilled in the art can be arranged default according to actual needs
XML instructs create-rule, is not specifically limited herein.It may include there is report in XML corresponding with the Data subject instructions generated
The modularization information of the table page, such as summarize the relevant information such as component, detailed component, trend component, download component.
In order to easily generate the instruction of report displayed page, extensible stylesheet table transfer language (XSLT) can be in advance based on
It establishes and presets report page template fairground, XSLT is that can instruct XML for instructing the language converted to XML and convert
For the description language of arbitrary text, therefore default report page template fairground is established using XSLT, can easily by with
The corresponding XML instructions of Data subject are combined with the Page Template instruction corresponding to report page template, to rapidly give birth to
It is instructed at report displayed page corresponding with Data subject is obtained.
Default report page template fairground includes multiple report page templates, and report page template includes entire content
Configuration, component Configuration and element arrangements etc., wherein entire content configuration includes mainly the basic layout information of report page,
Component Configuration include summarize region configuration, the configuration of detailed region, the configuration of trend region and download area configuration of territory etc. match confidence
Breath, element arrangements include the configuration information of specific element, including but not limited to：Text search frame, drop-down search box, thumbnail
The configuration information of aggregating element, list etc..There is incidence relation, tool between entire content configuration, component Configuration and element arrangements
Body is：Component Configuration is constituted based on element arrangements, entire content configuration is constituted based on component Configuration.
Can be each one-to-one report of report page template-setup for the ease of distinguishing and using report page template
Page Template identifies.In the case where being configured with corresponding report page template identification for Data subject, according in configuration data
Report page template identification, can rapidly be inquired from default report page template fairground and the report page template mark
Corresponding report page template is known, then by XML corresponding with Data subject instructions and the page corresponding to report page template
Template instruction is combined, and generates the instruction of report displayed page.
After generating structured query language instruction corresponding with Data subject and the instruction of report displayed page, so that it may
It is instructed using structured query language instruction and report displayed page, obtains Report Forms Service.Specifically, structuralized query language is utilized
Speech instruction obtains corresponding data query result, instructs to obtain report page pattern using report displayed page, then by data
Query result is rendered on report page corresponding with report page pattern.
Structured query language provided in this embodiment based on index system instructs generation method, is based on tables of data, structure
Unified index model and Data subject fairground have been built, has completed the foundation of index system, and by way of modularization, energy
Enough fast and automatically, it is flexibly generated the structured query language instruction of suitable various businesses demand, instruction is not only increased and generates
Efficiency reduces the human cost write needed for instruction, but also establishes the relationship maps between index system and SQL services
Relationship effectively meets various businesses demand；In addition, the technical solution can ensure the uniqueness of data target, effectively
The inconsistent problem of index bore is avoided, structured query language instruction generating mode is optimized, it can be easily to data
Table carries out unified safeguard and effectively management.
The flow diagram for the data query method based on index system that Fig. 2 shows according to the ... of the embodiment of the present invention, such as
Shown in Fig. 2, this method comprises the following steps：
Step S200 obtains the inquiry constraints that user is arranged in the data query page.
When user needs to carry out data query, inquiry can be constrained in the data query page of data query client
Condition is configured, then in step s 200, obtaining the inquiry constraints that user is arranged in the data query page.
Step S201, according to inquiry constraints, to server-side request structuralized query corresponding with inquiry constraints
Sound instruction.
Structured query language instruction corresponding with Data subject is stored in server-side, then obtaining user setting
Inquiry constraints after, can according to inquiry constraints, to server-side request with inquire the corresponding structuring of constraints
Query language instructions.Server-side inquiry structure corresponding with inquiry constraints in the structured query language instruction stored
Change query language instructions, and the structured query language inquired instruction is returned into data query client.
Step S202, is instructed using structured query language, obtains data query result.
It since acquired structured query language instruction has service logic, can not directly execute, therefore also need pair
Structured query language instruction carries out dissection process, obtains executable structure query language instructions, then executes executable knot
Structure query language instructions, to obtain data query result.
Data query method provided in this embodiment based on index system can constrain item according to the inquiry of user setting
Part, easily request is instructed to corresponding structured query language from server-side, then structured query language is utilized to instruct,
It is quickly obtained data query result, improves efficiency data query, allows users to readily obtain data query result, have
Improve to effect the convenience that user obtains data query result.
Fig. 3 shows the structured query language command generating device according to the ... of the embodiment of the present invention based on index system
Structure diagram, as shown in figure 3, the device includes：It index system establishment module 310, configuration module 320, generation module 330 and takes
Number service module 340.
Index system establishment module 310 is suitable for：According to tables of data, structure includes multiple index models and Data subject collection
The index system in city.
Wherein, index system establishment module 310 is further adapted for：Tables of data is handled, multiple index models are established；
According to multiple index models, foundation includes the Data subject fairground of multiple Data subjects, obtains index system.Specifically, refer to
Mark system builds module 310 using the wide table of the data in tables of data and/or mid-module table as data model, to data model
Metadata carries out analyzing processing, establishes multiple index models.Specifically, multiple index models include：Basic dimension index model,
Metric index model, virtual dimension index model, derivative index model and parameter model.
Configuration module 320 is suitable for：Data subject in Data subject fairground is configured, is obtained corresponding with Data subject
Configuration data.
Wherein, configuration module 320 is further adapted for：Essential information, component and/or report page mould are configured for Data subject
Panel sign obtains configuration data corresponding with Data subject.Specifically, component includes：Summarize component, detailed component, trend group
Part and download component.
Generation module 330 is suitable for：According to configuration data, structured query language instruction corresponding with Data subject is generated.
Access service module 340 is suitable for：It is instructed using structured query language, obtains access service.
Wherein, access service module 340 is further adapted for：Structured query language corresponding with Data subject is executed to refer to
It enables, obtains data query result, and data query result is back to access service call end.
Optionally, generation module 330 is further adapted for：According to configuration data, report exhibition corresponding with Data subject is generated
Show that the page instructs.Specifically, generation module 330 generates extensible markup language corresponding with Data subject according to configuration data
Instruction；According to the report page template identification in configuration data, from the default report page based on extensible stylesheet table transfer language
Report page template corresponding with report page template identification is inquired in template fairground；Extensible markup language is instructed and inquired
To report page template corresponding to Page Template instruction be combined, generate report displayed page instruction.
The device further includes：Report Forms Service module 350 is suitable for utilizing structured query language instruction and report displayed page
Instruction, obtains Report Forms Service.
Structured query language command generating device provided in this embodiment based on index system is based on tables of data, structure
Unified index model and Data subject fairground have been built, has completed the foundation of index system, and by way of modularization, energy
Enough fast and automatically, it is flexibly generated the structured query language instruction of suitable various businesses demand, instruction is not only increased and generates
Efficiency reduces the human cost write needed for instruction, but also establishes the relationship maps between index system and SQL services
Relationship effectively meets various businesses demand；In addition, the technical solution can ensure the uniqueness of data target, effectively
The inconsistent problem of index bore is avoided, structured query language instruction generating mode is optimized, it can be easily to data
Table carries out unified safeguard and effectively management.
Fig. 4 shows the structure diagram of the data query arrangement according to the ... of the embodiment of the present invention based on index system, such as Fig. 4
Shown, which includes：Acquisition module 410, request module 420 and enquiry module 430.
Acquisition module 410 is suitable for：Obtain the inquiry constraints that user is arranged in the data query page.
Request module 420 is suitable for：According to inquiry constraints, to server-side request structure corresponding with inquiry constraints
Change query language instructions.
Enquiry module 430 is suitable for：It is instructed using structured query language, obtains data query result.
Wherein, enquiry module 430 instructs structured query language and carries out dissection process, obtains executable structureization inquiry
Sound instruction executes executable structure query language instructions, obtains data query result.
Data query arrangement provided in this embodiment based on index system can constrain item according to the inquiry of user setting
Part, easily request is instructed to corresponding structured query language from server-side, then structured query language is utilized to instruct,
It is quickly obtained data query result, improves efficiency data query, allows users to readily obtain data query result, have
Improve to effect the convenience that user obtains data query result.
The present invention also provides a kind of nonvolatile computer storage media, computer storage media is stored at least one can
It executes instruction, the structured query language based on index system that executable instruction can perform in above-mentioned any means embodiment refers to
Enable generation method.
Fig. 5 shows a kind of structural schematic diagram of computing device according to the ... of the embodiment of the present invention, the specific embodiment of the invention
The specific implementation of computing device is not limited.
As shown in figure 5, the computing device may include：Processor (processor) 502, communication interface
(Communications Interface) 504, memory (memory) 506 and communication bus 508.
Wherein：
Processor 502, communication interface 504 and memory 506 complete mutual communication by communication bus 508.
Communication interface 504, for being communicated with the network element of miscellaneous equipment such as client or other servers etc..
Processor 502 can specifically execute the above-mentioned structuralized query language based on index system for executing program 510
Correlation step in speech instruction generation method embodiment.
Specifically, program 510 may include program code, which includes computer-managed instruction.
Processor 502 may be central processor CPU or specific integrated circuit ASIC (Application
Specific Integrated Circuit), or be arranged to implement the integrated electricity of one or more of the embodiment of the present invention
Road.The one or more processors that computing device includes can be same type of processor, such as one or more CPU；Also may be used
To be different types of processor, such as one or more CPU and one or more ASIC.
Memory 506, for storing program 510.Memory 506 may include high-speed RAM memory, it is also possible to further include
Nonvolatile memory (non-volatile memory), for example, at least a magnetic disk storage.
Program 510 specifically can be used for so that processor 502 execute in above-mentioned any means embodiment based on index body
The structured query language of system instructs generation method.The specific implementation of each step may refer to above-mentioned based on index in program 510
The structured query language instruction of system generates corresponding description in corresponding steps and unit in embodiment, and this will not be repeated here.
It is apparent to those skilled in the art that for convenience and simplicity of description, the equipment of foregoing description and module
Specific work process can refer to corresponding processes in the foregoing method embodiment description, and details are not described herein.
The present invention also provides a kind of nonvolatile computer storage media, computer storage media is stored at least one can
It executes instruction, executable instruction can perform the data query method based on index system in above-mentioned any means embodiment.
The present invention also provides a kind of computing devices, including：Processor, memory, communication interface and communication bus, processing
Device, memory and communication interface complete mutual communication by communication bus；Memory is for storing at least one executable finger
It enables, executable instruction makes processor execute the above-mentioned corresponding operation of data query method based on index system.The calculating is set
Standby structural schematic diagram is identical as the structural schematic diagram of computing device shown in fig. 5, and details are not described herein again.
Algorithm and display be not inherently related to any certain computer, virtual system or miscellaneous equipment provided herein.
Various general-purpose systems can also be used together with teaching based on this.As described above, it constructs required by this kind of system
Structure be obvious.In addition, the present invention is not also directed to any certain programmed language.It should be understood that can utilize various
Programming language realizes the content of invention described herein, and the description done above to language-specific is to disclose this hair
Bright preferred forms.
In the instructions provided here, numerous specific details are set forth.It is to be appreciated, however, that the implementation of the present invention
Example can be put into practice without these specific details.In some instances, well known method, structure is not been shown in detail
And technology, so as not to obscure the understanding of this description.
Similarly, it should be understood that in order to simplify the disclosure and help to understand one or more of each inventive aspect,
Above in the description of exemplary embodiment of the present invention, each feature of the invention is grouped together into single implementation sometimes
In example, figure or descriptions thereof.However, the method for the disclosure should be construed to reflect following intention：It is i.e. required to protect
Shield the present invention claims the more features of feature than being expressly recited in each claim.More precisely, as following
Claims reflect as, inventive aspect is all features less than single embodiment disclosed above.Therefore,
Thus the claims for following specific implementation mode are expressly incorporated in the specific implementation mode, wherein each claim itself
All as a separate embodiment of the present invention.
Those skilled in the art, which are appreciated that, to carry out adaptively the module in the equipment in embodiment
Change and they are arranged in the one or more equipment different from the embodiment.It can be the module or list in embodiment
Member or component be combined into a module or unit or component, and can be divided into addition multiple submodule or subelement or
Sub-component.Other than such feature and/or at least some of process or unit exclude each other, it may be used any
Combination is disclosed to all features disclosed in this specification (including adjoint claim, abstract and attached drawing) and so to appoint
Where all processes or unit of method or equipment are combined.Unless expressly stated otherwise, this specification (including adjoint power
Profit requires, abstract and attached drawing) disclosed in each feature can be by providing the alternative features of identical, equivalent or similar purpose come generation
It replaces.
In addition, it will be appreciated by those of skill in the art that although some embodiments described herein include other embodiments
In included certain features rather than other feature, but the combination of the feature of different embodiments means in of the invention
Within the scope of and form different embodiments.For example, in the following claims, embodiment claimed is appointed
One of meaning mode can use in any combination.
The all parts embodiment of the present invention can be with hardware realization, or to run on one or more processors
Software module realize, or realized with combination thereof.It will be understood by those of skill in the art that can use in practice
Microprocessor or digital signal processor (DSP) are come one of some or all components in realizing according to embodiments of the present invention
A little or repertoire.The present invention is also implemented as setting for executing some or all of method as described herein
Standby or program of device (for example, computer program and computer program product).It is such to realize that the program of the present invention deposit
Storage on a computer-readable medium, or can have the form of one or more signal.Such signal can be from because of spy
It downloads and obtains on net website, either provide on carrier signal or provide in any other forms.
It should be noted that the present invention will be described rather than limits the invention for above-described embodiment, and ability
Field technique personnel can design alternative embodiment without departing from the scope of the appended claims.In the claims,
Any reference mark between bracket should not be configured to limitations on claims.Word "comprising" does not exclude the presence of not
Element or step listed in the claims.Word "a" or "an" before element does not exclude the presence of multiple such
Element.The present invention can be by means of including the hardware of several different elements and being come by means of properly programmed computer real
It is existing.In the unit claims listing several devices, several in these devices can be by the same hardware branch
To embody.The use of word first, second, and third does not indicate that any sequence.These words can be explained and be run after fame
Claim.
Claims (10)
1. a kind of structured query language based on index system instructs generation method, the method includes：
According to tables of data, structure includes the index system of multiple index models and Data subject fairground；
Data subject in the Data subject fairground is configured, configuration data corresponding with the Data subject is obtained；
According to the configuration data, structured query language instruction corresponding with the Data subject is generated；
It is instructed using the structured query language, obtains access service.
2. the structured query language according to claim 1 based on index system instructs generation method, wherein described
According to tables of data, structure includes that the index system in multiple index models and Data subject fairground further comprises：
The tables of data is handled, multiple index models are established；
According to the multiple index model, foundation includes the Data subject fairground of multiple Data subjects, obtains the index body
System.
3. the structured query language according to claim 2 based on index system instructs generation method, wherein described right
The tables of data is handled, and is established multiple index models and is further comprised：
Using the wide table of the data in the tables of data and/or mid-module table as data model, to first number of the data model
According to analyzing processing is carried out, multiple index models are established.
4. generation method is instructed according to structured query language of the claim 1-3 any one of them based on index system,
In, the multiple index model includes：Basic dimension index model, metric index model, virtual dimension index model, derivation refer to
Mark model and parameter model.
5. generation method is instructed according to structured query language of the claim 1-4 any one of them based on index system,
In, the Data subject in the Data subject fairground configures, and obtains configuration number corresponding with the Data subject
According to further comprising：
Essential information, component and/or report page template identification are configured for the Data subject, is obtained and the Data subject pair
The configuration data answered.
6. a kind of data query method based on index system, the method includes：
Obtain the inquiry constraints that user is arranged in the data query page；
According to the inquiry constraints, structured query language corresponding with the inquiry constraints is asked to refer to server-side
It enables；
It is instructed using the structured query language, obtains data query result.
7. a kind of structured query language command generating device based on index system, described device include：
Index system establishment module is suitable for according to tables of data, and structure includes the finger of multiple index models and Data subject fairground
Mark system；
Configuration module obtains and the Data subject pair suitable for being configured to the Data subject in the Data subject fairground
The configuration data answered；
Generation module is suitable for, according to the configuration data, generating structured query language instruction corresponding with the Data subject；
Service module of fetching obtains access service suitable for being instructed using the structured query language.
8. a kind of data query arrangement based on index system, described device include：
Acquisition module, the inquiry constraints being arranged in the data query page suitable for obtaining user；
Request module, is suitable for according to the inquiry constraints, and knot corresponding with the inquiry constraints is asked to server-side
Structure query language instructions；
Enquiry module is suitable for being instructed using the structured query language, obtains data query result.
9. a kind of computing device, including：Processor, memory, communication interface and communication bus, the processor, the storage
Device and the communication interface complete mutual communication by the communication bus；
The memory makes the processor execute as right is wanted for storing an at least executable instruction, the executable instruction
Ask the corresponding operation of structured query language instruction generation method based on index system described in any one of 1-5.
10. a kind of computer storage media, an at least executable instruction, the executable instruction are stored in the storage medium
Processor is set to execute the structured query language instruction generation side based on index system as described in any one of claim 1-5
The corresponding operation of method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810462636.6A CN108681589B (en) | 2018-05-15 | 2018-05-15 | Index system based structured query language instruction generation method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810462636.6A CN108681589B (en) | 2018-05-15 | 2018-05-15 | Index system based structured query language instruction generation method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN108681589A true CN108681589A (en) | 2018-10-19 |
| CN108681589B CN108681589B (en) | 2020-09-04 |
Family
ID=63806212
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810462636.6A Active CN108681589B (en) | 2018-05-15 | 2018-05-15 | Index system based structured query language instruction generation method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108681589B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109840246A (en) * | 2019-01-31 | 2019-06-04 | 北京三快在线科技有限公司 | It is a kind of for calculating the method and device of the historical data of target signature |
| CN110647549A (en) * | 2019-09-29 | 2020-01-03 | 北京卓信智恒数据科技股份有限公司 | Data index analyzing and executing method and device based on business dynamic modeling |
| CN111125092A (en) * | 2019-11-18 | 2020-05-08 | 贝壳技术有限公司 | Service index query method and device |
| CN112286929A (en) * | 2020-06-08 | 2021-01-29 | 上海柯林布瑞信息技术有限公司 | Method and device for generating multi-dimensional data set and computer readable storage medium |
| CN112860696A (en) * | 2021-02-07 | 2021-05-28 | 中国邮政储蓄银行股份有限公司 | Data query method and device and data query model |
| CN113127490A (en) * | 2021-04-23 | 2021-07-16 | 山东英信计算机技术有限公司 | Key name generation method and device and computer readable storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103678413A (en) * | 2012-09-25 | 2014-03-26 | 金蝶软件（中国）有限公司 | Method and device for displaying dynamic column of report |
| CN104361140A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Dynamically generated data model configuration device and method |
| CN104714949A (en) * | 2013-12-11 | 2015-06-17 | 航天信息股份有限公司 | Method for customizing report dynamically |
| WO2017147013A1 (en) * | 2016-02-25 | 2017-08-31 | Microsoft Technology Licensing, Llc | Query response using mapping to parameterized report |
| CN107169070A (en) * | 2017-05-08 | 2017-09-15 | 山大地纬软件股份有限公司 | The constructing system and its method in a kind of social security index warehouse based on big data |
| US20170286497A1 (en) * | 2016-04-05 | 2017-10-05 | Fractal Industries, Inc. | System for capture, analysis and storage of time series data from sensors with heterogeneous report interval profiles |
| CN107577805A (en) * | 2017-09-26 | 2018-01-12 | 华南理工大学 | A kind of business service system towards the analysis of daily record big data |
-
2018
- 2018-05-15 CN CN201810462636.6A patent/CN108681589B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103678413A (en) * | 2012-09-25 | 2014-03-26 | 金蝶软件（中国）有限公司 | Method and device for displaying dynamic column of report |
| CN104714949A (en) * | 2013-12-11 | 2015-06-17 | 航天信息股份有限公司 | Method for customizing report dynamically |
| CN104361140A (en) * | 2014-12-10 | 2015-02-18 | 用友软件股份有限公司 | Dynamically generated data model configuration device and method |
| WO2017147013A1 (en) * | 2016-02-25 | 2017-08-31 | Microsoft Technology Licensing, Llc | Query response using mapping to parameterized report |
| US20170286497A1 (en) * | 2016-04-05 | 2017-10-05 | Fractal Industries, Inc. | System for capture, analysis and storage of time series data from sensors with heterogeneous report interval profiles |
| CN107169070A (en) * | 2017-05-08 | 2017-09-15 | 山大地纬软件股份有限公司 | The constructing system and its method in a kind of social security index warehouse based on big data |
| CN107577805A (en) * | 2017-09-26 | 2018-01-12 | 华南理工大学 | A kind of business service system towards the analysis of daily record big data |
Non-Patent Citations (2)
| Title |
|---|
| 刘欣桓: "基于数据仓库的商业银行报表系统设计与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
| 周豪: "大数据量下的实时数据报表系统的设计与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109840246A (en) * | 2019-01-31 | 2019-06-04 | 北京三快在线科技有限公司 | It is a kind of for calculating the method and device of the historical data of target signature |
| CN110647549A (en) * | 2019-09-29 | 2020-01-03 | 北京卓信智恒数据科技股份有限公司 | Data index analyzing and executing method and device based on business dynamic modeling |
| CN111125092A (en) * | 2019-11-18 | 2020-05-08 | 贝壳技术有限公司 | Service index query method and device |
| CN112286929A (en) * | 2020-06-08 | 2021-01-29 | 上海柯林布瑞信息技术有限公司 | Method and device for generating multi-dimensional data set and computer readable storage medium |
| CN112860696A (en) * | 2021-02-07 | 2021-05-28 | 中国邮政储蓄银行股份有限公司 | Data query method and device and data query model |
| CN112860696B (en) * | 2021-02-07 | 2024-04-12 | 中国邮政储蓄银行股份有限公司 | Data query method and device and data query model |
| CN113127490A (en) * | 2021-04-23 | 2021-07-16 | 山东英信计算机技术有限公司 | Key name generation method and device and computer readable storage medium |
| CN113127490B (en) * | 2021-04-23 | 2023-02-24 | 山东英信计算机技术有限公司 | Key name generation method and device and computer readable storage medium |
| US11941032B2 (en) | 2021-04-23 | 2024-03-26 | Shandong Yingxin Computer Technologies Co., Ltd. | Key name generation method and apparatus and non-transitory computer-readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN108681589B (en) | 2020-09-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108664638A (en) | Report form generation method based on index system and device | |
| CN108681589A (en) | Structured query language instruction generation method based on index system and device | |
| Calvanese et al. | Ontology-driven extraction of event logs from relational databases | |
| Ryan et al. | Process modeling for simulation | |
| CN107533453A (en) | System and method for generating data visualization application | |
| JP2021012740A (en) | Compound control | |
| CN109144997A (en) | Data correlation method, device and storage medium | |
| CN108628608A (en) | A kind of method and device of data visualization | |
| US20170329786A1 (en) | Data flow design with static and dynamic elements | |
| CN107644286A (en) | Workflow processing method and device | |
| CN112199086A (en) | Automatic programming control system, method, device, electronic device and storage medium | |
| US8639712B2 (en) | Method and module for creating a relational database schema from an ontology | |
| US9304746B2 (en) | Creating a user model using component based approach | |
| Sagebaum et al. | Expression templates for primal value taping in the reverse mode of algorithmic differentiation | |
| CN104346383A (en) | Data access control method and system | |
| CN106779594A (en) | A kind of Workflow management method based on Activiti | |
| CN113268227A (en) | Zero-code visualization software development platform and development method | |
| CN106445645B (en) | Method and apparatus for executing distributed computing task | |
| García-García et al. | NDT-Driver: a Java tool to support QVT transformations for NDT | |
| CN114270313A (en) | Computer-implemented method, computer program and physical computing environment | |
| Naranjo et al. | PRIMROSe: a graph-based approach for enterprise architecture analysis | |
| CN108874395A (en) | Hard Compilation Method and device during a kind of modularization stream process | |
| Tapera et al. | Flywheeltools: data curation and manipulation on the flywheel platform | |
| US20230394212A1 (en) | Equivalence checking of synthesized logic designs using generated synthesis history | |
| Chalkiopoulos | Programming mapreduce with scalding |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |