CN104615602B - Query interface automatically generates realization device and its method - Google Patents
Query interface automatically generates realization device and its method Download PDFInfo
- Publication number
- CN104615602B CN104615602B CN201310541749.2A CN201310541749A CN104615602B CN 104615602 B CN104615602 B CN 104615602B CN 201310541749 A CN201310541749 A CN 201310541749A CN 104615602 B CN104615602 B CN 104615602B
- Authority
- CN
- China
- Prior art keywords
- query
- input
- interface
- information
- query object
- 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.)
- Active
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- User Interface Of Digital Computer (AREA)
Abstract
The invention belongs to computer application technologies, it discloses a kind of query interface and automatically generates realization device and its method, solve in the prior art that query interface development amount is big, and computer application system is changed, is upgraded, the operation such as dilatation when need to do the exploitation of query interface synchronized update, lead to the problem of further development amount of increasing developer.Using the present invention, so that the query interface development amount for possessing C/S the and B/S system of a large amount of query objects greatly reduces, a secondary design is only needed, can be achieved with the inquiry of batch query object, and query interface style high unity.And after the business change, upgrading, dilatation of computer application system, developer only needs upgrade database, it can be achieved with query object to increase, delete, modify, without upgrading to client, therefore reduce the development amount of developer to a certain extent.
Description
Technical field
The present invention relates to computer application technology more particularly to a kind of data are inquired and shown by query interface
Query interface automatically generates realization device and its method.
Background technique
Currently, inquiring and showing that data are a kind of very common computer application, existing calculating by query interface
In machine application system, this query interface is usually that be directed to known query object pre-designed, rather than was inquiring
It is automatically generated in journey.For such method, if be used in the computer application system for possessing a large amount of query objects, develop
Personnel are often very big for the development amount of query interface.Such as by taking reporting system as an example, every kind of report being generated in system
The data set of inquiry character unification fixed condition is required, and format as requested is presented, the work of interface development has:
Which 1, in order to tell custom system to provide report, available all report types are shown on interface
Come.
2, in order to obtain a certain selected report data to be presented, the number of inquiry character unification group specified conditions is needed
According to collection, at this moment need design interface to allow user to input this group of specified conditions, i.e. design querying condition interface.Due to various differences
The querying condition of report be not quite similar, therefore every kind of report will individually designed respective querying condition interface.
3, every kind of report tableau format is all different, such as different reports, column content is not quite similar, even
Its different style of different reports, therefore also need for the respective display interface of every kind of Report Form Design.
It is well known that the number of species of various reports are numerous in reporting system, it is not difficult by above-mentioned interface development work
It learns, the query interface design method provided using the prior art, in the report interface development process of reporting system, exploit person
The development amount of member is huge.
In addition, with the change, upgrading, dilatation etc. of computer application system business, query object is also faced with increase, repairs
The demand change, deleted, for example, there is in reporting system and need sporadically to increase by user's requirement, delete certain reports,
Or the demand of some reports of modification.It may then need all to carry out more three above-mentioned actions at this point for query interface
Newly, the workload of developer is thus undoubtedly further increased, and for C/S(Client/Server, client computer/clothes
Be engaged in device structure) computer application system for, the problem of upgrading to client also have to be faced with.
Summary of the invention
It is big in order to solve query interface development amount in the prior art, and become to computer application system
More, it needs to do the exploitation of query interface synchronized update when upgrading, dilatation etc. operate, cause further to increase opening for developer
The problem of sending out workload, the embodiment of the present invention are designed to provide a kind of inquiry for inquiring and showing data by query interface
Interface auto-generating realization device and its method.
In order to reach the purpose of the present invention, the present invention is implemented with the following technical solutions:
A kind of query interface automatically generates realization device comprising:
Database maintains through the associated object structure table of external key one and query object table and passes through external key
Two input/output lists to associate with the query object table;
Enquiry module, for inquiring object structure table and query object in database when computer application system starts
Table, to obtain all query objects and catalog structure information;It is further used for selecting query object by user interface in user
Afterwards, the input/output list in database is inquired, accordingly to obtain the input/output information of query object;And be further used for according to
According to the query object table in received query argument inquiry database, to obtain query result;
Interface generation module, for all query objects and catalog structure information that obtain from enquiry module to be given tissue
And strategy is presented at least one preset catalogue and is presented;It is further used for according to the query object obtained from enquiry module
Input/output information generates the interface element for receiving user input query condition, and defeated according to interface element generation querying condition
Enter interface;And be further used for triggering inquiry operation after user is by querying condition input interface input inquiry condition, and
The querying condition is converted into corresponding query argument and passes to enquiry module;And
Result display module, for obtaining the query result from enquiry module and showing.
Preferably, the object structure table saves the catalog structure information of query object;The query object table saves
The one-to-one relationship of each query object and its storing process;And the input/output list saves each query object
Input parameter and output column information, wherein the input paramete information indicates on querying condition input interface for receiving
The choice box or input box form of user input query condition.
Preferably, the interface generation module passes through reflection according to the input parameter of the query object obtained from enquiry module
Mode generate the interface element for receiving user input query condition, and combine the interface element and the query object other
Attribute information generates querying condition input interface.
Preferably, the query object table also saves query result display type attribute information, and creates humanized
Information and creation time attribute information.
Preferably, result display module is used to believe according to query result display type attribute corresponding with respective queries object
Breath shows the query result.
A method of it applies query interface as described above to automatically generate realization device and realizes that query interface automatically generates,
Maintenance is looked into query object table and by external key two with described by the associated object structure table of external key one in the database
Ask the input/output list that Object table associates, which comprises
Object structure table and query object table of the enquiry module when computer application system starts in inquiry database, with
Obtain all query objects and catalog structure information, all query objects and mesh that interface generation module will be obtained from enquiry module
Directory structures information is given tissue and is presented at least one preset catalogue presentation strategy;
After user selects query object by user interface, enquiry module inquires the input and output in database accordingly
Table, to obtain the input/output information of query object, interface generation module is defeated according to the query object obtained from enquiry module
Enter output information and generate the interface element for receiving user input query condition, and generates querying condition input according to the interface element
Interface;
Inquiry operation is triggered after user is by querying condition input interface input inquiry condition, interface generation module should
Querying condition is converted into corresponding query argument and passes to enquiry module, and enquiry module inquires number according to received query argument
According to the query object table in library, to obtain query result;
And result display module is shown the query result obtained from enquiry module.
Preferably, the object structure table saves the catalog structure information of query object;The query object table saves
The one-to-one relationship of each query object and its storing process;And the input/output list saves each query object
Input parameter and output column information, wherein the input paramete information indicates on querying condition input interface for receiving
The choice box or input box form of user input query condition.
Preferably, the interface generation module passes through reflection according to the input parameter of the query object obtained from enquiry module
Mode generate the interface element for receiving user input query condition, and combine the interface element and the query object other
Attribute information generates querying condition input interface.
Preferably, the query object table also saves query result display type attribute information, and creates humanized
Information and creation time attribute information.
Preferably, result display module is used to believe according to query result display type attribute corresponding with respective queries object
Breath shows the query result.
Compared with prior art, clear the invention enables the C/S and B/S(Browser/Server that possess a large amount of query objects
Look at device/server mode) the query interface development amount of system greatly reduces, only needs a secondary design, can be achieved with batch and look into
Ask the inquiry of object, and query interface style high unity.And in the business change, upgrading, expansion of computer application system
Rong Hou, developer only need upgrade database, can be achieved with query object and increase, delete, modify, without to client liter
Grade, therefore reduce the development amount of developer to a certain extent.
Detailed description of the invention
Fig. 1 is that query interface provided in an embodiment of the present invention automatically generates realization device structural schematic diagram;
Fig. 2 is that query interface provided in an embodiment of the present invention automatically generates implementation method flow diagram;
Fig. 3 is that the query interface that a specific embodiment of the invention provides automatically generates implementation method flow diagram;
The realization, functional characteristics and excellent effect of the object of the invention, below in conjunction with specific embodiment and attached drawing do into
The explanation of one step.
Specific embodiment
Technical solution of the present invention is described in further detail in the following with reference to the drawings and specific embodiments, so that this
The technical staff in field can better understand the present invention and can be practiced, but illustrated embodiment is not as to limit of the invention
It is fixed.
It should be appreciated that " first " " second " is used for description purposes only, and does not have in the description of the embodiment of the present invention
In indication or suggestion relative importance or implicitly indicate the quantity of indicated technical characteristic.
As shown in Figure 1, a kind of query interface provided in an embodiment of the present invention automatically generates realization device comprising:
Database 50, maintain by the associated object structure table 501 of external key 1 and query object table 502, with
And the input/output list 503 to be associated by external key 2 505 with the query object table 502;Object structure table 501 passes through outer
Key 1 is associated with query object table 502, indicates object directory belonging to query object.Input/output list 503 has recorded all
The input and output column information of query object, and be associated with by external key 2 505 with input/output list 503, it is indicated that with query object
Corresponding input/output.Wherein, major key is for uniquely indicating the record in table, and the external key is the master created in sublist
The copy of key is uniquely recorded for referring to back in parent table.
Enquiry module 30, for computer application system starting when from database 50 obtain query object bibliographic structure and
The information (such as associated storing process and the information such as require as the result is shown) of all query objects, selection based on user behaviour
Make to obtain the querying condition of single query object from database 50, export result description and require as the result is shown, and is based on using
The querying condition of family input calls storing process corresponding with query object to obtain query result automatically from database 50.
Specifically, for inquiring object structure table 501 and query object table in database 50 when computer application system starts
502, to obtain all query objects and catalog structure information;It is further used for passing through the selection inquiry pair of user interface 10 in user
As rear, the input/output list 503 in database 50 is inquired, accordingly to obtain the input/output information of query object;And into one
It walks for inquiring the query object table 502 in database 50 according to received query argument, to obtain query result, specifically,
In the present embodiment, enquiry module 30 is obtained according to received query argument and the associated storing process of query object, and holds accordingly
Mobile state SQL(Structured Query Language, structured query language) inquiry database 50, to obtain inquiry knot
Fruit, wherein the storing process is exactly a function, is used to receive input parameter, and return the result.
Interface generation module 20, for generating the bibliographic structure interface that all query objects are presented, single query object is connect
Receive querying condition input interface and the single query Object Query interface as the result is shown of the querying condition of user's input;Specifically
Ground, for by all query objects and catalog structure information that are obtained from enquiry module 30 give tissue and at least one it is preset
Catalogue is presented tactful (such as tree construction presentation) and is presented;It is further used for according to the query object obtained from enquiry module 30
Input/output information generate receive user input query condition interface element, and according to the interface element generate querying condition
Input interface;And be further used for triggering inquiry operation after user is by querying condition input interface input inquiry condition,
And the querying condition is converted into corresponding query argument and passes to enquiry module 30.
And result display module 40, for obtaining the query result from enquiry module 30 and showing.Specifically,
Inquiry output description and query result display based on query object require, and show query result in a desired manner.In this reality
It applies in example, as shown in Figure 1, when the result display module 40 is shown the query result, it is final still by described
User interface 10 specifically shows.
In the present embodiment, the database 50 also saves bibliographic structure, the inquiry of query object in addition to recording data
The description of the querying condition, query result of object, the display of query result require, the corresponding storage of inquiry operation of query object
Process.For example, the object structure table 501 saves the catalog structure information of query object, have in the object structure table 501
Higher level's catalogue of a field record catalogue, enquiry module 30 can constitute query object by inquiring all object directories accordingly
Bibliographic structure;In the database 50, the corresponding storing process of each query object to respond the inquiry operation of user,
Therefore the query object table 502 saves the one-to-one relationship of each query object Yu its storing process;And it is described defeated
Enter input parameter and output column information that output table 503 saves each query object.
In database 50, each query object can have input parameter and output column.These attributes are all stored in input
It exports in this data structure of table 503.One query object corresponds to multiple input parameters, or without input parameter and one
Query object is certain to be corresponding with one or more output column.And it is different to input the form of expression that parameter and output are listed in interface
Sample, wherein the input paramete information indicates on querying condition input interface for receiving the selection of user input query condition
Frame or input box form, and output listing is now column in table as the result is shown.So in the present embodiment, input can be defined
Output identification field is to distinguish input parameter and output column.
It is different to input parameter, there is the different forms of expression on interface, selection of time frame in this way, numberical range selection
Interface control of the frame according further to some other reception users input of application definition.Therefore, in the present embodiment, can define
" column data type " field is to distinguish a variety of different input parameters.
There are also the forms of expression that attribute determines interface for output column, such as whether can sort, count, screen,
It can be indicated by corresponding field.And in the present embodiment, output column can also have one to indicate whether there is son report
The mark of table then clicks output column if there is subreport on interface, and system can be arranged according to input parameter and the output
As the condition that subreport generates, a new subreport is generated.
Correspondingly, in the present embodiment, the interface generation module 20 is according to the query object obtained from enquiry module 30
Input parameter generated by way of reflection receive user input query condition interface element, and combine the interface element and
Other attribute informations of the query object generate querying condition input interface, such as binding time choice box, all input parameters pair
The other information of the interface element (may have one or more, it is also possible to not have), query object answered, such as title, description, creation
People, and the interface element (such as button) of triggering inquiry operation, generate querying condition input interface.
In addition, the query object table 502 also describes other attributes of query object, such as also save query result
Display type attribute information and founder's attribute information and creation time attribute information.These attribute informations, which describe, to be looked into
Presentation information of the object on interface is ask, pointing out if query result display type attribute information should be with list, report still
Other modes show query result, wherein the list, report can also continue to the list or the report that are subdivided into which kind of respective type
Table.
In the present embodiment, result display module 40 is used for according to query result display type corresponding with respective queries object
Attribute information shows the query result.Query result display type of the result display module 40 based on query object, selection
A kind of result presentation mode (list, report etc.), and according to the output column information of query object, it generates each in gauge outfit and table
The form of expression (whether can sort, screen, counting) of column receives the query result that database 50 returns, and fills data.
In conjunction with Fig. 1, and refering to what is shown in Fig. 2, the embodiment of the invention also provides a kind of application query interfaces as described above
It automatically generates realization device and realizes the method that query interface automatically generates, maintenance is related by external key 1 in database 50
The object structure table 501 of connection associates with query object table 502 and by external key 2 505 with the query object table 502
Input/output list 503, which comprises
The object structure table 501 and look into that S10, enquiry module 30 are inquired in database 50 in computer application system starting
Object table 502 is ask, to obtain all query objects and catalog structure information, interface generation module 20 will be obtained from enquiry module 30
All query objects and catalog structure information give tissue and strategy be presented at least one preset catalogue being presented;
S20, user by user interface 10 select query object after, enquiry module 30 is inquired in database 50 accordingly
Input/output list 503, to obtain the input/output information of query object, interface generation module 20 is obtained according to from enquiry module 30
The input/output information of query object generate the interface element for receiving user input query condition, and it is raw according to the interface element
At querying condition input interface;
S30, inquiry operation, interface generation module are triggered after user is by querying condition input interface input inquiry condition
The querying condition is converted into corresponding query argument and passes to enquiry module 30 by 20, and enquiry module 30 is according to received inquiry
Query object table 502 in parameter query database 50, to obtain query result;
S40 and, result display module 40 is shown the query result obtained from enquiry module 30.
In the present embodiment, the object structure table 501 saves the catalog structure information of query object;The query object
Table 502 saves the one-to-one relationship of each query object Yu its storing process;And the input/output list 503 saves
The input parameter and output column information of each query object, wherein the input paramete information indicates that querying condition inputs boundary
For receiving the choice box or input box form of user input query condition on face.
In the present embodiment, input parameter of the interface generation module 20 according to the query object obtained from enquiry module 30
The interface element for receiving user input query condition is generated by way of reflection, and combines the interface element and the inquiry pair
Other attribute informations of elephant generate querying condition input interface.
In the present embodiment, the query object table 502 also saves query result display type attribute information, and creation
Humanized information and creation time attribute information.
In the present embodiment, result display module 40 is used for according to query result display type corresponding with respective queries object
Attribute information shows the query result.
In conjunction with Fig. 1 and refering to what is shown in Fig. 3, it illustrates give birth to automatically using realization query interface provided in an embodiment of the present invention
At method flow diagram, specifically comprising following steps:
When step 1, computer application system starting, enquiry module 30 inquires bibliographic structure and institute in database 50 automatically
There is the information of query object, all query objects are organized with bibliographic structure;
20 step 2, interface generation module query objects organized are shown to the use of client in the form of tree structure
Family interface 10 other than using tree structure Display directory, can also use other structures, certainly in order to which user finds
Query object;
Step 3, user select a query object, choose an inquiry pair for example, by using the form of mouse-click left button
As;
Step 4, enquiry module 30 start the input parameter of query object and defeated from database 50 based on the selection of user
It falls out;
Step 5, interface generation module 20 generate the corresponding interface element of input parameter in a manner of reflection, and organize other
Interface element generates querying condition input interface and is shown to user interface 10;
Querying condition input interface in step 6, user interface 10 receives the querying condition input of user, and receives user
The querying triggering of input acts;
The input of step 7, interface generation module 20 based on user generates query argument;
Step 8, enquiry module 30 receive query argument, and the corresponding storing process of query object is called looked into
Ask result;
Step 9, result display module 40 display type and output column information based on query object select corresponding data
Presentation mode (such as list, report etc.) generates gauge outfit, and determine each column the form of expression (for example whether can sort, screen,
Statistics etc.), query result data are filled, and as the result is shown in user interface 10.
The above description is only a preferred embodiment of the present invention, is not intended to limit the scope of the invention, all utilizations
Equivalent structure or equivalent flow shift made by description of the invention and accompanying drawing content is applied directly or indirectly in other correlations
Technical field, be included within the scope of the present invention.
Claims (10)
1. a kind of query interface automatically generates realization device characterized by comprising
Database, maintain by the associated object structure table of external key one and query object table and by external key two with
The input/output list that the query object table associates;
Enquiry module, for inquiring object structure table and query object table in database when computer application system starts,
To obtain all query objects and catalog structure information;It is further used for after user selects query object by user interface,
The input/output list in database is inquired, accordingly to obtain the input/output information of query object;And it is further used for foundation
Query object table in received query argument inquiry database, to obtain query result;
Interface generation module, for by all query objects and catalog structure information that are obtained from enquiry module give tissue and with
At least one preset catalogue is presented strategy and is presented;It is further used for the input according to the query object obtained from enquiry module
Output information generates the interface element for receiving user input query condition, and generates querying condition according to the interface element and input boundary
Face;And it is further used for triggering inquiry operation after user is by querying condition input interface input inquiry condition, and should
Querying condition is converted into corresponding query argument and passes to enquiry module;And
Result display module, for obtaining the query result from enquiry module and showing.
2. query interface as described in claim 1 automatically generates realization device, which is characterized in that the object structure table saves
The catalog structure information of query object;The query object table saves each query object and a pair for its storing process
It should be related to;And the input/output list saves the input parameter and output column information of each query object, wherein described
Input paramete information indicates on querying condition input interface for receiving the choice box or input frame shape of user input query condition
Formula.
3. query interface as claimed in claim 2 automatically generates realization device, which is characterized in that the interface generation module according to
It is generated by way of reflection according to the input parameter of the query object obtained from enquiry module and receives user input query condition
Interface element, and other attribute informations of the interface element and the query object is combined to generate querying condition input interface.
4. query interface as claimed in claim 3 automatically generates realization device, which is characterized in that the query object table is also protected
Query result display type attribute information and founder's attribute information and creation time attribute information are deposited.
5. query interface as claimed in claim 4 automatically generates realization device, which is characterized in that result display module be used for according to
The query result is shown according to query result display type attribute information corresponding with respective queries object.
6. a kind of method that query interface automatically generates, which is applied to query interface as described in claim 1, automatically generates realization dress
In setting, which is characterized in that maintenance passes through the associated object structure table of external key one and query object table, Yi Jitong in the database
Cross the input/output list that external key two associates with the query object table, which comprises
Object structure table and query object table of the enquiry module when computer application system starts in inquiry database, to obtain
All query objects and catalog structure information, interface generation module is by all query objects obtained from enquiry module and catalogue knot
Structure information is given tissue and is presented at least one preset catalogue presentation strategy;
After user selects query object by user interface, enquiry module inquires the input/output list in database accordingly, with
Obtain the input/output information of query object, input and output of the interface generation module according to the query object obtained from enquiry module
Information generates the interface element for receiving user input query condition, and generates querying condition input interface according to the interface element;
In user by triggering inquiry operation after querying condition input interface input inquiry condition, interface generation module is by the inquiry
Condition is converted into corresponding query argument and passes to enquiry module, and enquiry module inquires database according to received query argument
In query object table, to obtain query result;
And result display module is shown the query result obtained from enquiry module.
7. method as claimed in claim 6, which is characterized in that the object structure table saves the bibliographic structure of query object
Information;The query object table saves the one-to-one relationship of each query object Yu its storing process;And the input
Output table saves the input parameter and output column information of each query object, wherein the input paramete information expression is looked into
Ask the choice box or input box form on condition UI for receiving user input query condition.
8. the method for claim 7, which is characterized in that the interface generation module is looked into according to what is obtained from enquiry module
The input parameter for asking object generates the interface element for receiving user input query condition by way of reflection, and combines the interface
Other of element and the query object attribute information generate querying condition input interface.
9. method according to claim 8, which is characterized in that the query object table also saves query result display type
Attribute information and founder's attribute information and creation time attribute information.
10. method as claimed in claim 9, which is characterized in that result display module is used for foundation and respective queries object pair
The query result display type attribute information answered shows the query result.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201310541749.2A CN104615602B (en) | 2013-11-05 | 2013-11-05 | Query interface automatically generates realization device and its method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201310541749.2A CN104615602B (en) | 2013-11-05 | 2013-11-05 | Query interface automatically generates realization device and its method |
Publications (2)
Publication Number | Publication Date |
---|---|
CN104615602A CN104615602A (en) | 2015-05-13 |
CN104615602B true CN104615602B (en) | 2019-09-20 |
Family
ID=53150052
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201310541749.2A Active CN104615602B (en) | 2013-11-05 | 2013-11-05 | Query interface automatically generates realization device and its method |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN104615602B (en) |
Families Citing this family (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN106776644B (en) * | 2015-11-24 | 2019-11-29 | 大唐软件技术股份有限公司 | A kind of reporting system configuration method and device |
CN106776638A (en) * | 2015-11-24 | 2017-05-31 | 大唐软件技术股份有限公司 | Database operation method and device |
CN106815271B (en) * | 2015-12-02 | 2020-11-06 | 北京国双科技有限公司 | Query condition generation method and device |
CN105824637B (en) * | 2016-03-17 | 2019-03-12 | 中国银行股份有限公司 | Method for inquiring customization and system |
CN106874321B (en) * | 2016-06-24 | 2020-04-21 | 阿里巴巴集团控股有限公司 | Pluggable data retrieval method and device |
CN107665228B (en) * | 2017-05-10 | 2019-12-20 | 平安科技(深圳)有限公司 | Associated information query method, terminal and equipment |
CN109614098A (en) * | 2017-09-30 | 2019-04-12 | 北京国双科技有限公司 | The generation method and device of configuration interface |
CN108984623B (en) * | 2018-06-14 | 2020-11-03 | 东软集团股份有限公司 | Data query condition generation method and device, storage medium and electronic equipment |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1806241A (en) * | 2003-06-13 | 2006-07-19 | 微软公司 | Database query user interface |
CN102110161A (en) * | 2011-02-24 | 2011-06-29 | 中兴通讯股份有限公司 | Method and device for backing up and recovering multi-service database |
CN102855250A (en) * | 2011-06-30 | 2013-01-02 | 北京新媒传信科技有限公司 | Method and system for display output of user information |
CN103365646A (en) * | 2012-04-11 | 2013-10-23 | 怡丰联合(北京)科技有限责任公司 | Form user-defined, logical definition and processing method based on script engine |
Family Cites Families (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9529842B2 (en) * | 2009-12-28 | 2016-12-27 | International Business Machines Corporation | Dynamically creating queries to find related records in a database |
-
2013
- 2013-11-05 CN CN201310541749.2A patent/CN104615602B/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1806241A (en) * | 2003-06-13 | 2006-07-19 | 微软公司 | Database query user interface |
CN102110161A (en) * | 2011-02-24 | 2011-06-29 | 中兴通讯股份有限公司 | Method and device for backing up and recovering multi-service database |
CN102855250A (en) * | 2011-06-30 | 2013-01-02 | 北京新媒传信科技有限公司 | Method and system for display output of user information |
CN103365646A (en) * | 2012-04-11 | 2013-10-23 | 怡丰联合(北京)科技有限责任公司 | Form user-defined, logical definition and processing method based on script engine |
Also Published As
Publication number | Publication date |
---|---|
CN104615602A (en) | 2015-05-13 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104615602B (en) | Query interface automatically generates realization device and its method | |
AU2021269367B2 (en) | Device, system, and method of website building by utilizing data lists | |
CN106528129B (en) | A kind of Web application interface generation system and method | |
US9727836B2 (en) | Systems and methods for generating data visualization dashboards | |
US8195698B2 (en) | Hierarchy manager for master data management | |
US7818328B2 (en) | API for obtaining unambiguous representation of objects in a relational database | |
CN110688117B (en) | Interface designer and platform based on JavaWeb and page configuration method thereof | |
US8010909B1 (en) | Derived hierarchy methods and system for definition, visualization and editing of data | |
US8886646B2 (en) | Field extensibility for analytical reports | |
CN101673372A (en) | Method and device for updating bill of material | |
US9147040B2 (en) | Point-in-time query system | |
CA2371724A1 (en) | System and method for defining prompts using declarative principles | |
US20100138449A1 (en) | Forests of dimension trees | |
CN105760370A (en) | Plug-in type report framework technology | |
JP2006524376A (en) | Generic database schema | |
US8832601B2 (en) | ETL tool utilizing dimension trees | |
López et al. | A component-based approach for engineering enterprise mashups | |
US20130086037A1 (en) | Encapsulated, model-centric aggregation of data from differentiated data sources | |
US20240143580A1 (en) | Method and system for dynamic query parameters through interactive user interface controls | |
CN113434530A (en) | Form management method and device, electronic equipment and medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
CB02 | Change of applicant information |
Address after: 518057 Energy Storage Building, 3099 South Keyuan Road, Yuehai Street, Nanshan District, Shenzhen City, Guangdong Province Applicant after: Shenzhen Liwei Zhilian Technology Co., Ltd. Address before: 518057 Nanshan District science and technology zone, Guangdong, Zhejiang Province, South Road, building W1-A, the first floor of the building, building two Applicant before: Shenzhen ZTE NetView Technology Co., Ltd. |
|
CB02 | Change of applicant information | ||
GR01 | Patent grant | ||
GR01 | Patent grant |