CN102163223A - Self-service query method and device thereof for background data - Google Patents
Self-service query method and device thereof for background data Download PDFInfo
- Publication number
- CN102163223A CN102163223A CN 201110084074 CN201110084074A CN102163223A CN 102163223 A CN102163223 A CN 102163223A CN 201110084074 CN201110084074 CN 201110084074 CN 201110084074 A CN201110084074 A CN 201110084074A CN 102163223 A CN102163223 A CN 102163223A
- Authority
- CN
- China
- Prior art keywords
- query
- parameter
- statement
- query argument
- data
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a self-service query method and a device thereof for background data. The method comprises the following steps of: filling query parameter information including condition type; analyzing the query parameter information to get a query parameter statement, and storing the query parameter statement as a query configuration file; generating a query interactive interface according to the query parameter statement or the query configuration file; and inputting a parameter value of the condition type in the query parameter information into the query interactive interface, and returning back query result. With the self-service query method and the device thereof for the background data, encyclopedia site background administrators can implement data query and data statistics by substituting the complex program development with the simple self-service configuration, under MediaWiki.
Description
Technical field
The present invention relates to a kind of querying method and device.Especially a kind of self-service querying method of back-end data and device that is applied to MediaWiKi.
Background technology
Wikipedia (wikipedia) is a multilingual encyclopaedical cooperation plan based on Wiki technology (a kind of authoring tool of multiple person cooperational), it also is a network encyclopedia of being write as with different language, its target and aim provide freely encyclopedia for the whole mankind---and write with their selected language and form, but be a dynamic free access and editor's global knowledge body.
MediaWiki is the program of building a station of setting up the wiki Website development, and also is present most widely used wiki program, runs on the PHP+MySQL environment.
Yet, the back-stage management function of MediaWiki is not very perfect, the inquiry and the statistics of back-end data flexibly are not provided, the website that uses MediaWiki to build also needs technician's development sequence to support the inquiry and the statistics of operation data, expend technical force, also reduced the efficient of operation.
Summary of the invention
The object of the invention is to provide self-service querying method of a kind of back-end data and device, is implemented under the MediaWiki, and encyclopaedia class website back-stage management person replaces numerous and diverse program development just can realize the inquiry and the statistics of data with simple self-service configuration.
The self-service querying method of back-end data of the present invention may further comprise the steps:
Fill in the query argument information that comprises the condition type;
Analyze described query argument information and draw the query argument statement, and described query argument statement is saved as the query configuration file;
According to described query argument statement or described query configuration file generated query interactive interface;
Import the parameter value of condition type described in the described query argument information at described inquiry interactive interface, return Query Result.
By keeper's configuration querying parameter information simply, just can generate visual inquiry interactive interface automatically according to these query argument information, made things convenient for the keeper to import actual conditions type parameter value and draw Query Result, do not needed to carry out complicated program development, operability strengthens.
Further, the data that the keeper provides according to database are filled in query context, conditional object field, display field, and the condition type is set.
Keeper and database interaction are filled in regard to the selection of having finished parameter information, make the webmaster web to finish the input of query argument information by self-service layoutprocedure under the situation that does not have the technician to participate in.
And, be the complete condition parameter with described condition type and the completion of described conditional object field, and generate described query argument information in conjunction with described query context, the described display field of filling in.
Exist under the nonstandard situation when website back-stage management person fills in, above-mentioned steps can be revised place lack of standardization wherein, makes it close to computer programming language gradually.
The described query argument information of verification, verification draws the query argument statement by then carrying out the described query argument information of described analysis, and described query argument statement saved as the query configuration file, verification is not by then providing error message, and the data of returning described keeper and providing according to database fill in query context, conditional object field, display field, and the condition type is set.
Verification makes inquiry realize self check, and validity and availability that can judgment data lay the foundation for drawing correct Query Information.
Further, described filling in the query argument information that comprises the condition type after the described query argument information of verification and verification are passed through, further comprises:
Described query argument information is saved as parameter configuration files.
Parameter configuration files belongs to the backup of query argument information, and the record of this inquiry is provided in the time of can be for needs.
The described query argument information of described analysis draws the query argument statement, and described query argument statement is saved as the query configuration file further comprises:
Analyze described complete condition parameter, obtain the qualification type and the parameter logic of data;
Analyze described query context, display field and described complete condition parameter, obtain SQL statement;
Analyze described display field, obtain the form head;
Qualification type and parameter logic, SQL statement and the form head of data are combined into the query argument statement and save as the query configuration file.
By analysis, for various readable object on next step generated query interactive interface and the parameter input field that can import provide foundation to query argument information.And the effect of backup has not only been played in the preservation of query configuration file, and the foundation of inquiring about when also conduct is repeatedly with the condition type has realized the once self-service configuration of pipeline person, repeatedly the effect that data are inquired about and added up.
Describedly further comprise according to described query argument statement or described query configuration file generated query interactive interface:
Qualification type and parameter logic according to described data generate relevant parameters value input field.
The concrete needs transmission instruction of keeper according to this inquiry is convenient in the generation of parameter value input field, realized that database data meets the data of querying condition by the instruction derivation.
The present invention also provides a kind of back-end data self-service inquiry unit, comprising:
Parameter is filled in device, is used to fill in the query argument information that comprises the condition type;
Analytical equipment is used to analyze described query argument information and draws the query argument statement, and described query argument statement is saved as the query configuration file;
The interface generating apparatus is used for according to described query argument statement or described query configuration file generated query interactive interface;
Exhibiting device is used for returning Query Result according to the parameter value of importing condition type described in the described query argument information at described inquiry interactive interface as a result.
Further, described parameter is filled in device and is also comprised with lower unit:
Data selection unit is used to the keeper that data in the database are provided, and fills in query context, conditional object field, display field, and the condition type is set;
Parameter completion unit, being used for described condition type and the completion of described conditional object field is the complete condition parameter, and generates described query argument information in conjunction with described query context, the described display field of filling in.
Verification unit is used for the described query argument information of verification.
Further, described parameter is filled in device and is also comprised with lower unit:
The parameter configuration generation unit is used for described query argument information is saved as parameter configuration files.
Further, described analytical equipment also comprises with lower unit:
The querying condition analytic unit is used to analyze described complete condition parameter, obtains the qualification type and the parameter logic of data;
The SQL statement analytic unit is used to analyze described query context, display field and described complete condition parameter, obtains SQL statement;
Form header analysis unit is used to analyze described display field, obtains the form head;
The query configuration generation unit is combined into qualification type and parameter logic, SQL statement and the form head of data the query argument statement and saves as the query configuration file.
Further, the input field generation unit is used for generating relevant parameters value input field according to the qualification type and the parameter logic of described data.
By self-service querying method of back-end data of the present invention and device, encyclopaedia class website technician is freed from the work of boring repeatedly exploitation query statistic, saved technical force, improved efficiency of operation.And make the encyclopaedia class website back-stage management person can once simple self-service configuration, repeatedly data inquired about and added up at any time, increased website back-stage management person to encyclopaedia class website operation situation the control ability.
Description of drawings
Below with reference to accompanying drawings and in conjunction with the embodiments the present invention is specifically described.
Fig. 1 is a basic skills process flow diagram of the present invention;
Fig. 2 is the apparatus structure synoptic diagram of embodiments of the invention;
Fig. 3 is the embodiments of the invention method flow diagram.
Embodiment
With reference to the accompanying drawings and by embodiments of the invention, technical scheme of the present invention is done detailed description.In the accompanying drawings, similar Reference numeral is represented similar component.
According to shown in Figure 1, the self-service querying method of a kind of back-end data of the present invention comprises S1, fills in the query argument information that comprises the condition type; S2, the described query argument information of analysis draw the query argument statement, and described query argument statement are saved as the query configuration file; S3, according to described query argument statement or described query configuration file generated query interactive interface; S4, import the parameter value of condition type described in the described query argument information, return Query Result at described inquiry interactive interface.
To inquire about the situation of creating entry in certain time period is example, and according to Fig. 2 and shown in Figure 3, in self-service querying method of back-end data of the present invention and device, step S1 fills in device 1 in parameter and fills in the query argument information that comprises the condition type.
Contain a plurality of data sources in the database, have many tables of data in each data source again.In the encyclopaedia class site databases of Wiki exploitation, be stored in the tables of data under one of them data source in the mode of field respectively about the various aspects of entry situation, for example the name of this data source is called docresource, the name of this tables of data is called T_WIKI_DOC, and the structure of table is as follows:
Wherein, Name classifies field name as, and Comment classifies the note of corresponding field as, and Data type classifies the data type and the display width of corresponding field as, data type such as the DOC_TITLE field is a variable length character type (varchar), and regulation character display width is 255; The data type of DOC_HIS_COUNT field is big integer type (bigint), and is defined as 12 character display widths; The data type of DOC_CREATED_TIME field is time type (timestamp), i.e. the timestamp represented of " YYYYMMDDhhmmss " form.In addition, int is the standard integer data type in the data type, and tinyint is unusual small integer data type.The situation of each entry all is stored in each field in the above table with the form of element.
Parameter is filled in device 1 and is also comprised: data selection unit 11, parameter completion unit 12, verification unit 13.It in the device 1 is by finishing with back-stage management person's interaction to filling in of query argument information that parameter is filled in.Comprise step S11 among the step S1, data selection unit 11 provides data in the database for the keeper, according to the data in keeper's the selection accessing database, realizes the interpolation of query context, conditional object field, display field and condition type.For example, this data selection unit 11 imports DSN earlier from database, and is loaded into keeper's operation interface such as combobox one with tabular form.After the keeper chose the docresource data source, data selection unit 11 was loaded into the tables of data title under the docresource data source keeper's operation interface such as combobox two with tabular form.After the keeper chose the T_WIKI_DOC tables of data, all field names during data selection unit 11 will be shown and the note of field were loaded into keeper's operation interface such as text box three with tabular form.So far, the keeper selects query context to finish, and promptly the keeper has selected all fields of entry of the T_WIKI_DOC tables of data under the docresource data source as query context.
Because the establishment situation of inquiry entry is being condition between certain period in the present embodiment, therefore set the condition that a time interval section promptly constitutes present embodiment for " creation-time " field, in data selection unit 11, the keeper selects DOC_CREATED_TIME (creation-time) in the text box three of list of fields, it is added in condition entry district such as the text box four, thereby finished the selection of conditional object field.Then this conditional object field " DOC_CREATED_TIME " is set to the condition type of time interval section, promptly has a start time and a concluding time.Thereby finished the setting of condition type.In addition, querying condition also comprises polytype, for example, character string, numerical value, numerical value segment etc., data selection unit 11 can be with the dissimilar type option that are set to respectively, represent numerical value as type one, on behalf of time interval section, type three, type two represent numerical value segment, type four to represent character.When the entry situation that has certain version number such as inquiry, then add DOC_HIS_COUNT (clauses and subclauses old version number) for the conditional object field and select type one to be the condition type; When such as the entry situation in certain section score value of inquiry, then add DOC_SCORE (these clauses and subclauses score value) for the conditional object field and select type three to be the condition type; When creating the situation of entry, then can add DOC_CREATOR_USER_NICK (clauses and subclauses founder's pet name) for the conditional object field and select type four to be the condition type such as certain founder of inquiry.The effect of condition type is to make prompting for completion complete condition parameter in the parameter completion unit 12, thereby further analyzes the qualification type and the parameter logic of data for analytical equipment 2, and analyzes SQL statement and lay the foundation.
In data selection unit 11, the keeper can also specify the field that finally will demonstrate in Query Result.Want to see that such as the keeper entry situation that shows in the Query Result comprises the entry name, version number, the entry score value, maximum contribution person, founder's pet name, creation-time and nearest edit session, the keeper adds doc_title (entry name) to the display field input field in such as text box five according to the list of fields in text box three operation interfaces so, doc_his_count (version number), doc_score (entry score value), doc_champion (maximum contribution person) doc_create_user_nick (founder's pet name), doc_create_time (creation-time) and doc_last_edit_time (edit session recently), thus needed all data of query argument information are selected to finish.
Step S1 comprises that also S12, parameter completion unit 12 are the complete condition parameter with described condition type and the completion of described conditional object field, and generates described query argument information in conjunction with described query context, the described display field of filling in.In the present embodiment, parameter completion unit 12 is a type two according to the condition type option, completion be " 1, start time, 2; 2, concluding time; 2 " thereby two end points of time interval section have been added, wherein " 1; the start time " and " 2, the concluding time " is meant respectively the parameter name of using " 1 " " 2 " conducts " start time " and " concluding time ", and definition can make the simple readability of code of step S2 analytical equipment 2 call parameters when transforming SQL statement like this.And then " 2 " of parameter " start time " " concluding time " back then represent condition type two, directly analyze the supplemental characteristic type and the parameter logic of condition among the performing step S2 according to these " 2 ".And then according to the conditional object field further completion be " 1, doc_create_time, start time, 2; 2, doc_create_time, concluding time, 2 ".Thereby finished the completion of described complete condition parameter.This complete condition parameter has just constituted query argument information with query context, display field.In addition, according to the content difference of keeper to the back-end data inquiry, can in step S1, define a self-service Query Name and suitably describe this query contents, also as the part of query argument information, such as in the present embodiment, it is DocCreatedByTime that the keeper can define self-service Query Name, is described as the entry information inquiry of creating in the time period.
Then by S13, the described query argument information of verification unit 13 verifications, verification is by then carrying out the analytical procedure of step S2, and verification is by then providing error message, and returns step S11, carries out again parameter and fills in.Parameter, supplemental characteristic type and parameter logic in 13 pairs of query argument information of verification unit are carried out verification, when matching each other then by verification, query argument information is passed to analytical equipment 2, be that DOC_CLICK_COUNT (clauses and subclauses number of clicks) belongs to the numeric type data such as the conditional object field when not matching, what the condition type option was selected but is type two---the time interval section, the two does not match, verification unit 13 can provide error message, and return data selected cell 11 carries out filling in of correlation parameter again.
Further, parameter is filled in device 1 and is also comprised parameter configuration files generation unit 14, is used for execution in step S14, described query argument information is saved as parameter configuration files.This parameter configuration files is the xml file, and xml is an extend markup language, is to be used for the data of description and the language of customize tag as required.Parameter configuration files is the data backup of filling in the query argument information that device 1 fills among the step S1 by parameter, during preservation, a node is added promptly in each provisional capital of query argument information:＜nodename〉＜query argument information〉＜/nodename 〉, and with＜sqlInfo-receive〉＜/sqlInfo-receive〉as the root node title.Parameter configuration files is following form in the present embodiment:
Wherein＜! [CDATA[]]〉make CDATA inside be plain text, its inner all the elements all can be ignored by the xml resolver.
The self-service querying method of back-end data of the present invention comprises that step S2, the described query argument information of analysis draw the query argument statement, and described query argument statement is saved as the query configuration file.Wherein, step S2 also comprise substep S21, analyze described complete condition parameter " 1, doc_create_time, start time, 2; 2, doc_create_time, concluding time, 2 ", obtain two end points and belong to time data type and parameter logic, promptly data fit is after the start time time, and meets before the concluding time.This is for providing basis according to this time data type and parameter logic generation relevant parameters input field among next step S3.
Step S2 also comprises substep S22, analyzes described query context, display field and described complete condition parameter, obtains SQL statement.In the present embodiment, according to T_WIKI_DOC tables of data and the display field under the docresource data source of adding among the step S1, determine the order behavior of SQL statement:
Wherein, Select from where belongs to the commonly used command in the SQL statement inquiry, is those skilled in the art's known technology.Wherein, doc_create_time＞=' ' and doc_create_time＜' ' in ' and ' ' be equivalent to the parameter name of start time and concluding time respectively, and can be according to giving different parameter values future when homogeneous is inquired about; "＞=" wherein, "＜" is comparison operator, is used for setting the condition that contains interval range." and " is logical operator, if promptly first condition and second condition are all set up, then the AND operational symbol shows a record.In addition comparison operator also comprise=,＞,＜,＜=,＜＞,!=,!＞,!＜, be used for setting different conditions respectively, logical operator also comprise OR (or), NO (non-).
Among the substep S23, analyze described display field, obtain the form head.According to the display field of adding among the step S1, determine form head corresponding entries project shown in next step S3, the interface generating apparatus 3.In the present embodiment, according to display field, obtain the form head for " entry name " " version number " " entry score value " " maximum contribution person " " founder's pet name " " creation-time " and " edit session recently ", be used to show the Query Result element of corresponding tables wresting portion.
And, in substep S24, qualification type and parameter logic, SQL statement and the form head of data is combined into the query argument statement and saves as the query configuration file.Just, qualification type and parameter logic, SQL statement and the form head of analyzing the data obtain just constituted the query argument statement together.Be that each provisional capital of query argument statement is increased a node equally, and with sqlInfo-analysis as the root node title, generated the xml file as the query configuration file:
Wherein, because 11 li of data selection unit, be to have selected data source earlier, could in the tables of data under this data source, select corresponding tables of data, so data source docresource does not need to appear in the SQL statement.But data source datasource uses when can be after the input parameter value of step S4 finishing inquiry by reading database, therefore＜and datasource〉＜! [CDATA[docresource]]〉＜/datasource〉the same with SQL statement, be to finish the required necessary node of one query, belong to the same level statement.
Then, analytical equipment 2 passes to interface generating apparatus 3 with the query argument statement, and in step S3, interface generating apparatus 3 will be according to described query argument statement or described query configuration file generated query interactive interface.Just, interface generating apparatus 3 generates visualization interface according to transmitting the query argument statement that comes, and this interface can be imported the condition type parameter value of this inquiry for the keeper, also can show the back-end data that meets this condition type parameter value.Wherein, what demonstrate according to the form head is the display field that the keeper is provided with in step S1, and step S3 also comprises substep S31, and promptly the subelement input field generation unit 31 of interface generating apparatus 3 generates relevant parameters value input field according to the qualification type and the parameter logic of described data.
In the present embodiment, " entry name " " version number " " entry score value " " maximum contribution person " " founder's pet name " " creation-time " and " edit session recently " have been demonstrated according to the form head.According to the qualification type of data and the condition type two of 2 representatives in the parameter logic, generate start time parameter value input frame and concluding time parameter value input frame, the keeper fills in parameter value according to " YYYYMMDDhhmmss " form among the step S4 in frame thereby limit.Therefore, the parameter value input field comprises at least one input frame.Certainly, also simultaneously start-up time control, displaying calendar and timetable are clicked the select time parameter value for the keeper.
At last, step S4, import the parameter value of condition type described in the described query argument information, return Query Result at described inquiry interactive interface.
In the present embodiment, the keeper imports the concrete parameter value of the start time and the concluding time of this inquiry.Such as stab 20110101090000 (09:00:00 on January 1st, the 1) parameter value of time to start with by time control select time, select time stabs the parameter value of 20110301090000 (09:00:00 on March 1st, 1) as the concluding time, then according to giving $1$ with 20110101090000 assignment in the SQL statement, 20110301090000 assignment are given $2$, thereby the t_wiki_doc tables of data in the reading database in the docresource data source, the data that will meet doc_create_time＞=20110101090000 and doc_create_time＜20110301090000 find, and list corresponding element in form successively, thereby finish this inquiry according to the field of form head.
When if the keeper reuses " the entry information inquiry of creating in the time period ", interface generating apparatus 3 still can be by the query configuration file of step S24 preservation, the xml file that for example self-service Query Name is DocCreatedByTime, generate corresponding inquiry interactive interface, do not need to carry out again again filling in and having analyzed of query argument information.Therefore the backup of query configuration file has guaranteed once self-service configuration, repeatedly the effect of data query.
More than be that a condition " time period " is inquired about, the present invention also can be provided with the inquiry of a plurality of conditions.For example: carry out the score value section entry information inquiry of establishment in the time period, other query argument information are constant, so, the conditional object field can be filled in two: DOC_CREATED_TIME and DOC_SCORE, the condition type will be selected type two time interval sections and type three numerical value segments respectively, through parameter completion unit 12 completions of step S12 be " 1, doc_create_time; start time, 2; 2, doc_create_time, concluding time, 2; 3, doc_score, minimum score value, 3; 4, doc_score, highest score, 3 ", and further be converted into following SQL statement form at the analytical equipment 2 of step S2:
Pass through step S3 generated query interface again, and in step S31, not only generated two input frames of the time parameter value of limiting time data type, also generated the minimum score value of parameter value and two input frames of highest score of limiting value type.According to the parameter value of keeper's input, reading database displays meeting above-mentioned two conditions of elements simultaneously then.
Should be appreciated that abovely to have been described in detail, should be appreciated that above explanation is illustrative and not restrictive, the order that provides in the present embodiment also is provided between the step of method by the preferred embodiments of the present invention technical scheme of the present invention.Those of ordinary skill in the art is reading on the basis of instructions of the present invention and can make amendment to the technical scheme that each embodiment put down in writing, and perhaps part technical characterictic wherein is equal to replacement; And these modifications or replacement do not make the essence of appropriate technical solution break away from the spirit and scope of various embodiments of the present invention technical scheme.Protection scope of the present invention is only limited by the claims of enclosing.
Claims (10)
1. the self-service querying method of back-end data is characterized in that, may further comprise the steps:
Fill in the query argument information that comprises the condition type;
Analyze described query argument information and draw the query argument statement, and described query argument statement is saved as the query configuration file;
According to described query argument statement or described query configuration file generated query interactive interface;
Import the parameter value of condition type described in the described query argument information at described inquiry interactive interface, return Query Result.
2. the self-service querying method of back-end data according to claim 1 is characterized in that, the described query argument information that comprises the condition type of filling in further comprises:
The data that the keeper provides according to database are filled in query context, conditional object field, display field, and the condition type is set;
With described condition type and the completion of described conditional object field is the complete condition parameter, and generates described query argument information in conjunction with described query context, the described display field of filling in;
The described query argument information of verification, verification draws the query argument statement by then carrying out the described query argument information of described analysis, and described query argument statement saved as the query configuration file, verification is not by then providing error message, and the data of returning described keeper and providing according to database fill in query context, conditional object field, display field, and the condition type is set.
3. the self-service querying method of back-end data according to claim 2 is characterized in that, described filling in the query argument information that comprises the condition type after the described query argument information of verification and verification are passed through, further comprises:
Described query argument information is saved as parameter configuration files.
4. the self-service querying method of back-end data according to claim 2 is characterized in that, the described query argument information of described analysis draws the query argument statement, and described query argument statement is saved as the query configuration file further comprises:
Analyze described complete condition parameter, obtain the qualification type and the parameter logic of data;
Analyze described query context, display field and described complete condition parameter, obtain SQL statement;
Analyze described display field, obtain the form head;
Qualification type and parameter logic, SQL statement and the form head of data are combined into the query argument statement and save as the query configuration file.
5. the self-service querying method of back-end data according to claim 4 is characterized in that, describedly further comprises according to described query argument statement or described query configuration file generated query interactive interface:
Qualification type and parameter logic according to described data generate relevant parameters value input field.
6. the self-service inquiry unit of back-end data is characterized in that, comprising:
Parameter is filled in device (1), is used to fill in the query argument information that comprises the condition type;
Analytical equipment (2) is used to analyze described query argument information and draws the query argument statement, and described query argument statement is saved as the query configuration file;
Interface generating apparatus (3) is used for according to described query argument statement or described query configuration file generated query interactive interface;
Exhibiting device (4) is used for returning Query Result according to the parameter value of importing condition type described in the described query argument information at described inquiry interactive interface as a result.
7. the self-service inquiry unit of back-end data according to claim 6 is characterized in that, described parameter is filled in device (1) and also comprised with lower unit:
Data selection unit (11) is used to the keeper that data in the database are provided, and fills in query context, conditional object field, display field, and the condition type is set;
Parameter completion unit (12), being used for described condition type and the completion of described conditional object field is the complete condition parameter, and generates described query argument information in conjunction with described query context, the described display field of filling in.
Verification unit (13) is used for the described query argument information of verification.
8. the self-service inquiry unit of back-end data according to claim 7 is characterized in that, described parameter is filled in device (1) and also comprised with lower unit:
Parameter configuration generation unit (14) is used for described query argument information is saved as parameter configuration files.
9. the self-service inquiry unit of back-end data according to claim 7 is characterized in that, described analytical equipment (2) also comprises with lower unit:
Querying condition analytic unit (21) is used to analyze described complete condition parameter, obtains the qualification type and the parameter logic of data;
SQL statement analytic unit (22) is used to analyze described query context, display field and described complete condition parameter, obtains SQL statement;
Form header analysis unit (23) is used to analyze described display field, obtains the form head;
Query configuration generation unit (24) is combined into qualification type and parameter logic, SQL statement and the form head of data the query argument statement and saves as the query configuration file.
10. the self-service inquiry unit of back-end data according to claim 9 is characterized in that, described interface generating apparatus (3) also comprises with lower unit:
Input field generation unit (31) is used for generating relevant parameters value input field according to the qualification type and the parameter logic of described data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110084074 CN102163223A (en) | 2011-04-02 | 2011-04-02 | Self-service query method and device thereof for background data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201110084074 CN102163223A (en) | 2011-04-02 | 2011-04-02 | Self-service query method and device thereof for background data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102163223A true CN102163223A (en) | 2011-08-24 |
Family
ID=44464450
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201110084074 Pending CN102163223A (en) | 2011-04-02 | 2011-04-02 | Self-service query method and device thereof for background data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102163223A (en) |
Cited By (19)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104361040A (en) * | 2014-10-29 | 2015-02-18 | 中国建设银行股份有限公司 | Method and device for customized query |
| CN106250104A (en) * | 2015-06-09 | 2016-12-21 | 阿里巴巴集团控股有限公司 | A kind of remote operating system for server, method and device |
| CN106610973A (en) * | 2015-10-21 | 2017-05-03 | 北京国双科技有限公司 | Television data query method and device |
| CN106874318A (en) * | 2016-06-08 | 2017-06-20 | 阿里巴巴集团控股有限公司 | A kind of method and device of information inquiry |
| CN107767010A (en) * | 2017-08-04 | 2018-03-06 | 平安科技（深圳）有限公司 | Range value data statistical method, electronic installation and computer-readable recording medium |
| CN107885502A (en) * | 2017-11-10 | 2018-04-06 | 广州市千钧网络科技有限公司 | Interface processing method, processing unit, interface managerial method and managing device |
| CN108572945A (en) * | 2018-03-09 | 2018-09-25 | 吉贝克信息技术（北京）有限公司 | Create method, system, storage medium and the electronic equipment of report |
| CN108984698A (en) * | 2018-07-05 | 2018-12-11 | 福建星瑞格软件有限公司 | A kind of modeling method of data bank service behavior |
| CN109313640A (en) * | 2016-03-31 | 2019-02-05 | 慧咨环球有限公司 | Method and system for data base optimization |
| CN109614098A (en) * | 2017-09-30 | 2019-04-12 | 北京国双科技有限公司 | The generation method and device of configuration interface |
| CN110109959A (en) * | 2019-04-30 | 2019-08-09 | 北京达佳互联信息技术有限公司 | Data processing method, device, server and storage medium |
| CN110598107A (en) * | 2019-09-09 | 2019-12-20 | 恩亿科(北京)数据科技有限公司 | Management method of query system and computer storage medium |
| CN111078961A (en) * | 2019-12-24 | 2020-04-28 | 用友网络科技股份有限公司 | Multi-data source query driving system, method, device and storage medium |
| WO2020083358A1 (en) * | 2018-10-25 | 2020-04-30 | 北京数安鑫云信息技术有限公司 | Visualized service data operating system, method, device and medium |
| CN111367703A (en) * | 2020-03-18 | 2020-07-03 | 北京奇艺世纪科技有限公司 | Troubleshooting method and device |
| CN111930777A (en) * | 2020-10-09 | 2020-11-13 | 武汉中科通达高新技术股份有限公司 | Query interface generation method and device, server and computer readable storage medium |
| CN112799659A (en) * | 2021-01-12 | 2021-05-14 | 杨飞 | Method, device and terminal for automatically generating data interface without programming |
| CN113407563A (en) * | 2021-06-04 | 2021-09-17 | 莱斯发展有限公司 | Query form generation method, device and equipment |
| CN113420044A (en) * | 2021-06-30 | 2021-09-21 | 平安国际智慧城市科技股份有限公司 | Data query method, device, equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101626393A (en) * | 2008-07-09 | 2010-01-13 | 北京摩软科技有限公司 | Mobile terminal with active information prompting function and method |
| CN101794226A (en) * | 2010-03-08 | 2010-08-04 | 山东大学 | Service software construction method and system adapting to multiple business abstraction levels |
| CN101997732A (en) * | 2009-08-14 | 2011-03-30 | 华为技术有限公司 | Method, device and system for inquiring service |
-
2011
- 2011-04-02 CN CN 201110084074 patent/CN102163223A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101626393A (en) * | 2008-07-09 | 2010-01-13 | 北京摩软科技有限公司 | Mobile terminal with active information prompting function and method |
| CN101997732A (en) * | 2009-08-14 | 2011-03-30 | 华为技术有限公司 | Method, device and system for inquiring service |
| CN101794226A (en) * | 2010-03-08 | 2010-08-04 | 山东大学 | Service software construction method and system adapting to multiple business abstraction levels |
Cited By (26)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104361040A (en) * | 2014-10-29 | 2015-02-18 | 中国建设银行股份有限公司 | Method and device for customized query |
| CN106250104B (en) * | 2015-06-09 | 2019-08-20 | 阿里巴巴集团控股有限公司 | A kind of remote operating system for server, method and device |
| CN106250104A (en) * | 2015-06-09 | 2016-12-21 | 阿里巴巴集团控股有限公司 | A kind of remote operating system for server, method and device |
| CN106610973A (en) * | 2015-10-21 | 2017-05-03 | 北京国双科技有限公司 | Television data query method and device |
| CN109313640B (en) * | 2016-03-31 | 2022-03-04 | 慧咨环球有限公司 | Method and system for database optimization |
| CN109313640A (en) * | 2016-03-31 | 2019-02-05 | 慧咨环球有限公司 | Method and system for data base optimization |
| CN106874318A (en) * | 2016-06-08 | 2017-06-20 | 阿里巴巴集团控股有限公司 | A kind of method and device of information inquiry |
| CN106874318B (en) * | 2016-06-08 | 2020-01-14 | 阿里巴巴集团控股有限公司 | Information query method and device |
| CN107767010A (en) * | 2017-08-04 | 2018-03-06 | 平安科技（深圳）有限公司 | Range value data statistical method, electronic installation and computer-readable recording medium |
| WO2019024238A1 (en) * | 2017-08-04 | 2019-02-07 | 平安科技（深圳）有限公司 | Range value data statistical method and system, electronic device, and computer readable storage medium |
| CN109614098A (en) * | 2017-09-30 | 2019-04-12 | 北京国双科技有限公司 | The generation method and device of configuration interface |
| CN107885502A (en) * | 2017-11-10 | 2018-04-06 | 广州市千钧网络科技有限公司 | Interface processing method, processing unit, interface managerial method and managing device |
| CN108572945A (en) * | 2018-03-09 | 2018-09-25 | 吉贝克信息技术（北京）有限公司 | Create method, system, storage medium and the electronic equipment of report |
| CN108984698A (en) * | 2018-07-05 | 2018-12-11 | 福建星瑞格软件有限公司 | A kind of modeling method of data bank service behavior |
| WO2020083358A1 (en) * | 2018-10-25 | 2020-04-30 | 北京数安鑫云信息技术有限公司 | Visualized service data operating system, method, device and medium |
| CN110109959A (en) * | 2019-04-30 | 2019-08-09 | 北京达佳互联信息技术有限公司 | Data processing method, device, server and storage medium |
| CN110109959B (en) * | 2019-04-30 | 2021-08-13 | 北京达佳互联信息技术有限公司 | Data processing method, device, server and storage medium |
| CN110598107A (en) * | 2019-09-09 | 2019-12-20 | 恩亿科(北京)数据科技有限公司 | Management method of query system and computer storage medium |
| CN111078961A (en) * | 2019-12-24 | 2020-04-28 | 用友网络科技股份有限公司 | Multi-data source query driving system, method, device and storage medium |
| CN111078961B (en) * | 2019-12-24 | 2023-09-15 | 用友网络科技股份有限公司 | Multi-data source query driving system, method, device and storage medium |
| CN111367703A (en) * | 2020-03-18 | 2020-07-03 | 北京奇艺世纪科技有限公司 | Troubleshooting method and device |
| CN111367703B (en) * | 2020-03-18 | 2024-03-29 | 北京奇艺世纪科技有限公司 | Fault checking method and device |
| CN111930777A (en) * | 2020-10-09 | 2020-11-13 | 武汉中科通达高新技术股份有限公司 | Query interface generation method and device, server and computer readable storage medium |
| CN112799659A (en) * | 2021-01-12 | 2021-05-14 | 杨飞 | Method, device and terminal for automatically generating data interface without programming |
| CN113407563A (en) * | 2021-06-04 | 2021-09-17 | 莱斯发展有限公司 | Query form generation method, device and equipment |
| CN113420044A (en) * | 2021-06-30 | 2021-09-21 | 平安国际智慧城市科技股份有限公司 | Data query method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102163223A (en) | Self-service query method and device thereof for background data | |
| CN111488145B (en) | Micro-service code generation system and method based on service domain data model library | |
| CN106528129B (en) | A kind of Web application interface generation system and method | |
| CN104866426B (en) | Software test integrated control method and system | |
| CN107273117B (en) | Programming-friendly agile code automatic generation system | |
| CN103530407B (en) | Method and device for generating rich text document | |
| US9514115B2 (en) | Method for creating form validation program and corresponding form interface according to result set metadata | |
| US20060293939A1 (en) | Design managing means, design tool and method for work breakdown structure | |
| CN106775770A (en) | The lookup method of query statement is built based on category information | |
| CN103810152A (en) | Visualized formula editor | |
| CN108762743A (en) | Data table operation code generation method and device | |
| CN101499063A (en) | Tracing-based database schema evolution method and system | |
| Jiang et al. | Towards reengineering web sites to web-services providers | |
| CN108920147A (en) | A kind of Web page construction method, calculates equipment and storage medium at device | |
| US20070162470A1 (en) | Method and apparatus for event transformation and adaptive correlation for monitoring business solutions | |
| Lundell et al. | UML model interchange in heterogeneous tool environments: An analysis of adoptions of XMI 2 | |
| US10505873B2 (en) | Streamlining end-to-end flow of business-to-business integration processes | |
| CN113127442B (en) | Method, device and storage medium for visualizing data model | |
| CN113032633A (en) | Method for customizing table by using reference data item | |
| Penadés et al. | A product line approach to the development of advanced emergency plans. | |
| CN103488477A (en) | Visual editing system and visual editing method of JAVA interface | |
| CN103885762A (en) | File dictionary assembly based file development tool and method | |
| CN113343656A (en) | Secondary editing method of chart configuration element data model | |
| Collet et al. | Feature modeling and separation of concerns with FAMILIAR | |
| Bernardi et al. | Web applications design evolution with UWA |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20110824 |