WO2015048204A1 - Query building using schema - Google Patents
Query building using schema Download PDFInfo
- Publication number
- WO2015048204A1 WO2015048204A1 PCT/US2014/057322 US2014057322W WO2015048204A1 WO 2015048204 A1 WO2015048204 A1 WO 2015048204A1 US 2014057322 W US2014057322 W US 2014057322W WO 2015048204 A1 WO2015048204 A1 WO 2015048204A1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- query
- user interface
- user
- query builder
- schema
- Prior art date
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/332—Query formulation
- G06F16/3329—Natural language query formulation or dialogue systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/017—Gesture based interaction, e.g. based on a set of recognized hand gestures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
- G06F3/04817—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance using icons
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0481—Interaction techniques based on graphical user interfaces [GUI] based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
- G06F3/0482—Interaction with lists of selectable items, e.g. menus
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
- G06F3/04842—Selection of displayed objects or displayed text elements
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0484—Interaction techniques based on graphical user interfaces [GUI] for the control of specific functions or operations, e.g. selecting or manipulating an object, an image or a displayed text element, setting a parameter value or selecting a range
- G06F3/0485—Scrolling or panning
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/01—Input arrangements or combined input and output arrangements for interaction between user and computer
- G06F3/048—Interaction techniques based on graphical user interfaces [GUI]
- G06F3/0487—Interaction techniques based on graphical user interfaces [GUI] using specific features provided by the input device, e.g. functions controlled by the rotation of a mouse with dual sensing arrangements, or of the nature of the input device, e.g. tap gestures based on pressure sensed by a digitiser
- G06F3/0488—Interaction techniques based on graphical user interfaces [GUI] using specific features provided by the input device, e.g. functions controlled by the rotation of a mouse with dual sensing arrangements, or of the nature of the input device, e.g. tap gestures based on pressure sensed by a digitiser using a touch-screen or digitiser, e.g. input of commands through traced gestures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/103—Formatting, i.e. changing of presentation of documents
- G06F40/117—Tagging; Marking up; Designating a block; Setting of attributes
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/30—Creation or generation of source code
- G06F8/34—Graphical or visual programming
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/451—Execution arrangements for user interfaces
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/44—Arrangements for executing specific programs
- G06F9/451—Execution arrangements for user interfaces
- G06F9/452—Remote windowing, e.g. X-Window System, desktop virtualisation
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F9/00—Arrangements for program control, e.g. control units
- G06F9/06—Arrangements for program control, e.g. control units using stored programs, i.e. using an internal store of processing equipment to receive or retain programs
- G06F9/46—Multiprogramming arrangements
- G06F9/48—Program initiating; Program switching, e.g. by interrupt
- G06F9/4806—Task transfer initiation or dispatching
- G06F9/4843—Task transfer initiation or dispatching by program, e.g. task dispatcher, supervisor, operating system
- G06F9/485—Task life-cycle, e.g. stopping, restarting, resuming execution
- G06F9/4856—Task life-cycle, e.g. stopping, restarting, resuming execution resumption being on a different machine, e.g. task migration, virtual machine migration
Definitions
- At least some embodiments described herein relate to a query building mechanism in which a query builder component assists a user in generating queries to be used to populate user interface elements.
- a user interface control itself issues the query with appropriate query parameters and populates the corresponding user interface element with the appropriate query results.
- the query builder component helps select the appropriate query parameters for the user interface control.
- the query schemas are provided to the query builder component in consistent manner across a wide variety of possible user interface controls. Furthermore, the resulting query is provided in a uniform query format. Accordingly, the query builder component may be used for any user interface control, regardless of whether that user interface control is provided by a system, or by an application that runs in the system. Additionally, the user interface elements may be presented from a single class. Accordingly, the user interface element may appear consistent regardless of the identity of the user interface control, with customization occurring in the query parameters themselves.
- Figure 1 abstractly illustrates an example computing system in which the principles described herein may be employed
- Figure 4 illustrates a process whereby an abstract representation of a query may be transformed by different extensions into different query formats for submission to the underlying data source;
- Figure 5 illustrates an example of how the query builder component may be created via a user gesture
- Figure 6 illustrates an example query builder user interface in the case of a locked query
- Figure 8 illustrates a query builder user interface that may be provided for purposes of changing presentation options for the user interface element
- Figure 9 illustrates a user interface in which multiple data views (one for each query) are offered for a user interface element, and in which the user is given the option of generating further views using the query builder component.
- At least some embodiments described herein relate to a query building mechanism in which a query builder component assists a user in generating queries to be used to populate user interface elements.
- a user interface control itself issues the query with appropriate query parameters and populates the corresponding user interface element with the appropriate query results.
- the query builder component helps select the appropriate query parameters for the user interface control.
- the user interface control provides a query schema to the query builder component. For instance, this might be performed at the request of a user that is viewing a user interface element populated by the user interface control.
- the query schema identifies available query parameters that the user interface control is capable of using to populate a corresponding user interface element.
- the query builder component presents at least some of the available query parameters to the user, such that the user may edit these parameters.
- the query parameters may include query fields, and query rules.
- the query builder component gathers those edits and generates a query therefrom.
- the query schemas are provided to the query builder component in consistent manner across a wide variety of possible user interface controls. Furthermore, the resulting query is provided in a uniform query format. Accordingly, the query builder component may be used for any user interface control, regardless of whether that user interface control is provided by a system, or by an application that runs in the system - so long as the user interface control communicates the schema in the right manner, and is able to interpret the unified query format. Additionally, the user interface elements may be presented from a single class. Accordingly, the user interface element may appear consistent regardless of the identity of the user interface control, with customization occurring in the query parameters themselves.
- the user might be presented with presentation options for presenting the user interface element, but the presentation options may also be limited to options that would allow the user interface to retain a certain look and feel. Accordingly, the principles described herein may permit convenient generation of queries, and repopulation of user interface elements with different data, regardless of there being many different sources for the user interface controls.
- the principles described herein may enable a distributed and composite application in which the user may control information that they see, and otherwise customize the user interface to fit their needs. For instance, for data sets that are projected through different visual experiences (like grids, charts, summaries, and so forth), the user can change the parameters that result in getting that data from the data source. Users do this through a user experience that is standardized over a system.
- the principles described herein may be implemented using a computing system.
- the users may be engaging with a portal that displayed multiple user interface elements using a client computing system.
- the executable logic supporting the portal and providing visualizations thereon may also be performed using a computing system.
- the computing system may even be distributed. Accordingly, a brief description of a computing system will now be provided.
- Computing systems are now increasingly taking a wide variety of forms.
- Computing systems may, for example, be handheld devices, appliances, laptop computers, desktop computers, mainframes, distributed computing systems, or even devices that have not conventionally been considered a computing system.
- the term "computing system” is defined broadly as including any device or system (or combination thereof) that includes at least one physical and tangible processor, and a physical and tangible memory capable of having thereon computer-executable instructions that may be executed by the processor.
- the memory may take any form and may depend on the nature and form of the computing system.
- a computing system may be distributed over a network environment and may include multiple constituent computing systems.
- a computing system 100 typically includes at least one processing unit 102 and memory 104.
- the memory 104 may be physical system memory, which may be volatile, non-volatile, or some combination of the two.
- the term “memory” may also be used herein to refer to nonvolatile mass storage such as physical storage media. If the computing system is distributed, the processing, memory and/or storage capability may be distributed as well.
- the term "executable module” or “executable component” can refer to software objects, routines, or methods that may be executed on the computing system. The different components, modules, engines, and services described herein may be implemented as objects or processes that execute on the computing system (e.g., as separate threads).
- embodiments are described with reference to acts that are performed by one or more computing systems. If such acts are implemented in software, one or more processors of the associated computing system that performs the act direct the operation of the computing system in response to having executed computer- executable instructions.
- such computer-executable instructions may be embodied on one or more computer-readable media that form a computer program product.
- An example of such an operation involves the manipulation of data.
- the computer-executable instructions (and the manipulated data) may be stored in the memory 104 of the computing system 100.
- Computing system 100 may also contain communication channels 108 that allow the computing system 100 to communicate with other message processors over, for example, network 110.
- Embodiments described herein may comprise or utilize a special purpose or general-purpose computer including computer hardware, such as, for example, one or more processors and system memory, as discussed in greater detail below.
- Embodiments described herein also include physical and other computer-readable media for carrying or storing computer-executable instructions and/or data structures.
- Such computer-readable media can be any available media that can be accessed by a general purpose or special purpose computer system.
- Computer-readable media that store computer-executable instructions are physical storage media.
- Computer-readable media that carry computer- executable instructions are transmission media.
- embodiments of the invention can comprise at least two distinctly different kinds of computer-readable media: computer storage media and transmission media.
- Computer storage media includes RAM, ROM, EEPROM, CD-ROM or other optical disk storage, magnetic disk storage or other magnetic storage devices, or any other tangible medium which can be used to store desired program code means in the form of computer-executable instructions or data structures and which can be accessed by a general purpose or special purpose computer.
- program code means in the form of computer-executable instructions or data structures can be transferred automatically from transmission media to computer storage media (or vice versa).
- computer-executable instructions or data structures received over a network or data link can be buffered in RAM within a network interface module (e.g., a "NIC"), and then eventually transferred to computer system RAM and/or to less volatile computer storage media at a computer system.
- a network interface module e.g., a "NIC”
- NIC network interface module
- computer storage media can be included in computer system components that also (or even primarily) utilize transmission media.
- Computer-executable instructions comprise, for example, instructions and data which, when executed at a processor, cause a general purpose computer, special purpose computer, or special purpose processing device to perform a certain function or group of functions.
- the computer executable instructions may be, for example, binaries, intermediate format instructions such as assembly language, or even source code.
- the invention may be practiced in network computing environments with many types of computer system configurations, including, personal computers, desktop computers, laptop computers, message processors, hand-held devices, multi-processor systems, microprocessor-based or programmable consumer electronics, network PCs, minicomputers, mainframe computers, mobile telephones, PDAs, pagers, routers, switches, and the like.
- the invention may also be practiced in distributed system environments where local and remote computer systems, which are linked (either by hardwired data links, wireless data links, or by a combination of hardwired and wireless data links) through a network, both perform tasks.
- program modules may be located in both local and remote memory storage devices.
- the system offers a user interface (or a "portal") that displays multiple user interface elements that may also be called herein “parts”.
- the part acts as a container for the results of execution of one or more underlying user interface controls (also called herein simply "controls").
- the manner of display of the part may be customized, as may be the ordering and composition of the part with respect to other user interface elements.
- the execution of the controls often involves one or more underlying queries to retrieve information that is displayed in the part, or otherwise processed.
- the user may modify the underlying query that retrieves the information. This allows the users to further control the user experience in fundamental ways, such as defining the actual data that is being displayed. In accordance with the principles described herein, this capability is offered in a consistent way, which honors the constraints of the portal to provide a portal in which many contributors may offer parts without sacrificing a consistent look and feel of the portal. Accordingly, the query customizations described herein may be applied to any part, regardless of the contributor of the part.
- the principles described herein allow the user to filter different sets of displayed data, and do further queries on their data sources. Even though the data sources are different depending on the part, the representation of the query may share a common visual representation. For instance the common visual representation may be a set of conditions connected by logical connectors and, eventually, groupings.
- the query building capability includes a query builder user interface element that is displayed to a user and represents a user interface for authoring queries over data sources.
- the query building capability also includes a query building component that receives query schemas from the user interface control, manifests at least some of the query schemas via the query builder user interface element, and then builds a formal representation of a query based on user edits conducted through user interaction with the query builder user interface element.
- Figure 2 illustrates an environment 200 that shows collaborating elements that facilitate a query building capability.
- the environment 200 includes a user interface control 210, a query builder component 220, a query builder user interface 230, and a user interface element 240.
- the user interface control 210 is queriable in that it may generate a submit queries, and populate the corresponding user interface element 240 with at least a portion of the query results.
- a query builder component 220 exposes an input interface whereby the user interface control 210 may provide a query schema 201 to the query builder component (reference arrow 211).
- the query schema 201 identifies available parameters for composing queries that the corresponding user interface control 210 is capable of using to populate the corresponding user interface element 240.
- the query builder component 220 then proceeds to build a query corresponding to the schema.
- the query builder component 220 may proceed to build a distinct query in response to each of multiple schemas received various different times at the query builder component 220.
- the query builder component may operate as described herein to build multiple queries, each selectable to provide a different view of the user interface element.
- the query builder component 220 builds queries by generating a query builder user interface 230 (reference arrow 212).
- the query builder user interface 230 is built from a particular query builder user interface class and thus there is some similarity in appearance each time the query builder component 230 generates a query builder using interface.
- the query builder user interface 230 may be customized to the corresponding user interface control 210 by presenting at least some of the available query parameters to the user. In the case of query builder user interface 230, a name field, an age field, and a newness status field are presented to the user. At this point, the user may interact with the query builder user interface 230 to edit the query parameters.
- the query builder component 220 determines that a query is to be built based on the edited data in the query builder user interface 230 (reference arrow 213).
- the query builder component 220 then generates a query using the then current values of the available query parameters.
- the query is generated in a pre-existing format recognized by the user interface control 210.
- the user might select the Save button in the query builder user interface 230, causing the query builder component 220 to generate an Abstract Syntax Tree (AST) representation 202 of the query.
- AST Abstract Syntax Tree
- the Abstract Syntax Tree representation is an example of a uniform query format that the user interface element 210 may then access (reference arrow 214) from an output interface of the query builder component 220.
- the user interface control 210 then performs the query and provides the resulting data for presentation in the corresponding user interface element 240 (reference arrow 215).
- Figure 3 illustrates more specific example operations of the user interface control 310, the query builder component 320, and the query builder user interface 330, which may be examples of the respective elements 210, 220 and 230 of Figure 2.
- the "Control UX" represents an example query builder user interface.
- the query builder user interface 330 presents a user experience for authoring queries, the user experience being data driven from the schema provided by the part.
- the query builder user interface 330 presents at least some of the available query parameters to a user.
- the query builder user interface 330 shows date range fields, an "assigned to" field, a state field, and tags fields. Those fields may be defined by the query schema provided by the user interface control 310. Likewise, those queries are grouped in a certain way using logical operators. Such groupings may also be defined by the query schema provided by the user interface control 310. Thus, the schema defines available fields and rules for composing a query, and the query building user interface presents at least some of those fields and rules to a user for editing.
- a visual query created by a user results in an abstract query representation based on a portal-defined Abstract Syntax Tree (AST).
- This Abstract Syntax Tree is created by the query builder component 320, and represents the predicates of the query.
- the query is then passed to the user interface control 310 (i.e., the data layer or the owner of the data).
- the AST format may be uniform across the system so that all data sources and schemas will project the same user experience (e.g., display the same query builder control albeit driven by different data and schemas) and the same predicated definition (e.g., via the AST).
- the user interface control (or some other portion of the data layer) receives the AST and translates to their query format of choice.
- intrinsic parts may be offered by the system itself and have a standard component for execution abstract representations of a predicate in a certain format (e.g., OData).
- an application provider may have provided a set of parts for execution within the system.
- the application provider also includes a component for executing abstract representations of a predicate, but perhaps in a different format than the system.
- the data layer may thus translate the query format to an abstract representation of choice.
- the results are returned to the user interface element (or part) that projects the resulting data set on the screen.
- a primary connecting piece is the abstract predicate representation (AST with the query). Multiple user experiences can end up generating an instance of a predicate following this schema. Predicates can be later translated into different types of queries, depending on the target data source. For instance, the tree can be translated to OData predicates, SQL queries, and so forth.
- the available components (or fields) of the query are metadata-driven. By doing this, different configurations of predicates can be produced using the same stack (e.g. queries for bugs, web sites, team members, etc.).
- the query builder component is data-driven and results in a consistent experience regardless of which entity generated the part.
- Any application can provide a schema associated with any of their parts and as a result of getting a query builder component, the application will get an updated query based on user input.
- the AST that represents the query is a uniform abstraction in the system. Once an application (often referred to as an "extension" herein) receives a query, it is the applications responsibility to get the AST (the query representation) and transform it to a query to their underlying data repository. By default the system provides some converters to popular formats, but applications parse the AST and issue the query to the backend. The query builder itself does not run the query.
- the extension could also decide to not use the query builder control and generating their own UI (built out of our existing controls, so they still have user experience consistency). In this case, the same contracts apply (metadata + AST). This allows for extra flexibility and is an extensibility point.
- the query builder user interface can be initiated by a gesture.
- Figure 5 shows an example where that gesture is a right-click command, but that is just one of an infinitely variety of gestures that might be chosen.
- the query builder is displayed. This option might only be available for user interface controls that honor the query building contract that allows the part to be queriable as previously described.
- the queries generated by the query builder component can have two modes; namely, locked and unlocked.
- Figure 6 illustrates an example query builder user interface in the case of a locked query.
- the implementation is similar to the query building already described.
- the query builder control receives a schema with all the available presentation options. To preserve a consistent look and feel of the portion, the presentation options provided by the schema may be constrained to what is supported by the system. After the user inputs their desired selection, the selection is returned back to the originating part to be applied.
- the query builder control does not have any control over how data is presented in the actual part, but just presents available options and collects preferences from the user.
- Queries created with the query builder control can be saved and associated with the originator. By doing this, a user can have multiple data or presentation views that can be associated to a given part.
- Figure 9 illustrates a user interface in which multiple data views are offered for a part, and in which the user is given the option of generating further views (using the query builder control).
- the principles described herein provide a convenient manner for allowing users to control what data is being presented in a user interface element. Furthermore, such query building may be performed in a consistent manner regardless of whether the user interface element is an intrinsic or extrinsic user interface element. Furthermore, since any user interface element that is queriable may user the query building component, so long as the user interface element abides by the contract with the query builder component, this query building may be enabled in a composable system in which there are many contributors of user interface elements.
Abstract
A query building mechanism in which a query builder component assists a user in generating queries to be used to populate user interface elements. A control provides a query schema to the query builder component. The query schema identifies available query parameters that the control is capable of using to populate a corresponding user interface element. The query builder component presents at least some of the available query parameters the user, such that the user may edit these parameters. The query builder component gathers those edits and generates a query therefrom. The query parameters may be provided to the query builder component in consistent manner across a wide variety of possible user interface controls. Furthermore, the resulting query is provided in a uniform query format.
Description
QUERY BUILDING USING SCHEMA
BACKGROUND
[0001] Computing systems and networks have transformed the way we work, play, communicate. Information can now be accessed from remote locations, often at the click of a button. Data stores are often now quite larger, and may be queried for desired information. For instance, a user interface control may generate a query, issue the query to the data store, receive results from the data store, and display some or all of the results in a corresponding user interface control. Nevertheless, conventional queries can require some knowledge to build, and often such knowledge is not possessed by the typical user of the computing system. Furthermore, even for those familiar with a query language, generating queries may be quite time consuming and mentally taxing.
SUMMARY
[0002] At least some embodiments described herein relate to a query building mechanism in which a query builder component assists a user in generating queries to be used to populate user interface elements. A user interface control itself issues the query with appropriate query parameters and populates the corresponding user interface element with the appropriate query results. However, the query builder component helps select the appropriate query parameters for the user interface control.
[0003] The user interface control provides a query schema to the query builder component. For instance, this might be performed at the request of a user that is viewing a user interface element populated by the user interface control. The query schema identifies available query parameters that the user interface control is capable of using to populate a corresponding user interface element. The query builder component presents at least some of the available query parameters to the user, such that the user may edit these parameters. As examples, the query parameters may include query fields, and query rules. The query builder component gathers those edits and generates a query therefrom.
[0004] In some embodiments, the query schemas are provided to the query builder component in consistent manner across a wide variety of possible user interface controls. Furthermore, the resulting query is provided in a uniform query format. Accordingly, the query builder component may be used for any user interface control, regardless of whether that user interface control is provided by a system, or by an application that runs in the system. Additionally, the user interface elements may be presented from a single class. Accordingly, the user interface element may appear consistent regardless of the identity of
the user interface control, with customization occurring in the query parameters themselves.
[0005] In some embodiments, the user might be presented with presentation options for presenting the user interface element, but the presentation options may also be limited to options that would allow the user interface to retain a certain look and feel. Accordingly, the principles described herein may permit convenient generation of queries, and repopulation of user interface elements with different data, regardless of there being many different sources for the user interface controls.
[0006] This summary is provided to introduce a selection of concepts in a simplified form that are further described below in the Detailed Description. This Summary is not intended to identify key features or essential features of the claimed subject matter, nor is it intended to be used as an aid in determining the scope of the claimed subject matter.
BRIEF DESCRIPTION OF THE DRAWINGS
[0007] In order to describe the manner in which the above-recited and other advantages and features of the invention can be obtained, a more particular description of the invention briefly described above will be rendered by reference to specific embodiments thereof which are illustrated in the appended drawings. Understanding that these drawings depict only typical embodiments of the invention and are not therefore to be considered to be limiting of its scope, the invention will be described and explained with additional specificity and detail through the use of the accompanying drawings in which:
[0008] Figure 1 abstractly illustrates an example computing system in which the principles described herein may be employed;
[0009] Figure 2 illustrates an environment that shows collaborating elements that facilitate a query building capability;
[0010] Figure 3 illustrates another example illustrating more specific example operations of the user interface control, the query builder component, and the query builder user interface;
[0011] Figure 4 illustrates a process whereby an abstract representation of a query may be transformed by different extensions into different query formats for submission to the underlying data source;
[0012] Figure 5 illustrates an example of how the query builder component may be created via a user gesture;
[0013] Figure 6 illustrates an example query builder user interface in the case of a locked query;
[0014] Figure 7 illustrates an example query builder user interface in the case of a unlocked query;
[0015] Figure 8 illustrates a query builder user interface that may be provided for purposes of changing presentation options for the user interface element; and
[0016] Figure 9 illustrates a user interface in which multiple data views (one for each query) are offered for a user interface element, and in which the user is given the option of generating further views using the query builder component.
DETAILED DESCRIPTION
[0017] At least some embodiments described herein relate to a query building mechanism in which a query builder component assists a user in generating queries to be used to populate user interface elements. A user interface control itself issues the query with appropriate query parameters and populates the corresponding user interface element with the appropriate query results. However, the query builder component helps select the appropriate query parameters for the user interface control.
[0018] The user interface control provides a query schema to the query builder component. For instance, this might be performed at the request of a user that is viewing a user interface element populated by the user interface control. The query schema identifies available query parameters that the user interface control is capable of using to populate a corresponding user interface element. The query builder component presents at least some of the available query parameters to the user, such that the user may edit these parameters. As examples, the query parameters may include query fields, and query rules. The query builder component gathers those edits and generates a query therefrom.
[0019] In some embodiments, the query schemas are provided to the query builder component in consistent manner across a wide variety of possible user interface controls. Furthermore, the resulting query is provided in a uniform query format. Accordingly, the query builder component may be used for any user interface control, regardless of whether that user interface control is provided by a system, or by an application that runs in the system - so long as the user interface control communicates the schema in the right manner, and is able to interpret the unified query format. Additionally, the user interface elements may be presented from a single class. Accordingly, the user interface element may appear consistent regardless of the identity of the user interface control, with customization occurring in the query parameters themselves.
[0020] In some embodiments, the user might be presented with presentation options for presenting the user interface element, but the presentation options may also be limited to options that would allow the user interface to retain a certain look and feel. Accordingly, the principles described herein may permit convenient generation of queries, and repopulation of user interface elements with different data, regardless of there being many different sources for the user interface controls.
[0021] Thus, the principles described herein may enable a distributed and composite application in which the user may control information that they see, and otherwise customize the user interface to fit their needs. For instance, for data sets that are projected through different visual experiences (like grids, charts, summaries, and so forth), the user can change the parameters that result in getting that data from the data source. Users do this through a user experience that is standardized over a system.
[0022] The principles described herein may be implemented using a computing system. For instance, the users may be engaging with a portal that displayed multiple user interface elements using a client computing system. The executable logic supporting the portal and providing visualizations thereon may also be performed using a computing system. The computing system may even be distributed. Accordingly, a brief description of a computing system will now be provided.
[0023] Computing systems are now increasingly taking a wide variety of forms. Computing systems may, for example, be handheld devices, appliances, laptop computers, desktop computers, mainframes, distributed computing systems, or even devices that have not conventionally been considered a computing system. In this description and in the claims, the term "computing system" is defined broadly as including any device or system (or combination thereof) that includes at least one physical and tangible processor, and a physical and tangible memory capable of having thereon computer-executable instructions that may be executed by the processor. The memory may take any form and may depend on the nature and form of the computing system. A computing system may be distributed over a network environment and may include multiple constituent computing systems.
[0024] As illustrated in Figure 1 , in its most basic configuration, a computing system 100 typically includes at least one processing unit 102 and memory 104. The memory 104 may be physical system memory, which may be volatile, non-volatile, or some combination of the two. The term "memory" may also be used herein to refer to nonvolatile mass storage such as physical storage media. If the computing system is distributed, the processing, memory and/or storage capability may be distributed as well.
As used herein, the term "executable module" or "executable component" can refer to software objects, routines, or methods that may be executed on the computing system. The different components, modules, engines, and services described herein may be implemented as objects or processes that execute on the computing system (e.g., as separate threads).
[0025] In the description that follows, embodiments are described with reference to acts that are performed by one or more computing systems. If such acts are implemented in software, one or more processors of the associated computing system that performs the act direct the operation of the computing system in response to having executed computer- executable instructions. For example, such computer-executable instructions may be embodied on one or more computer-readable media that form a computer program product. An example of such an operation involves the manipulation of data. The computer-executable instructions (and the manipulated data) may be stored in the memory 104 of the computing system 100. Computing system 100 may also contain communication channels 108 that allow the computing system 100 to communicate with other message processors over, for example, network 110.
[0026] The computing system 100 also includes a display 112 on which a user interface, such as the user interfaces and portal described herein, may be rendered. Such user interfaces may be generated in computer hardware or other computer-represented form prior to rendering. The presentation and/or rendering of such user interfaces may be performed by the computing system 100 by having the processing unit(s) 102 execute one or more computer-executable instructions that are embodied on one or more computer- readable media. Such computer-readable media may form all or a part of a computer program product.
[0027] Embodiments described herein may comprise or utilize a special purpose or general-purpose computer including computer hardware, such as, for example, one or more processors and system memory, as discussed in greater detail below. Embodiments described herein also include physical and other computer-readable media for carrying or storing computer-executable instructions and/or data structures. Such computer-readable media can be any available media that can be accessed by a general purpose or special purpose computer system. Computer-readable media that store computer-executable instructions are physical storage media. Computer-readable media that carry computer- executable instructions are transmission media. Thus, by way of example, and not
limitation, embodiments of the invention can comprise at least two distinctly different kinds of computer-readable media: computer storage media and transmission media.
[0028] Computer storage media includes RAM, ROM, EEPROM, CD-ROM or other optical disk storage, magnetic disk storage or other magnetic storage devices, or any other tangible medium which can be used to store desired program code means in the form of computer-executable instructions or data structures and which can be accessed by a general purpose or special purpose computer.
[0029] A "network" is defined as one or more data links that enable the transport of electronic data between computer systems and/or modules and/or other electronic devices. When information is transferred or provided over a network or another communications connection (either hardwired, wireless, or a combination of hardwired or wireless) to a computer, the computer properly views the connection as a transmission medium. Transmissions media can include a network and/or data links which can be used to carry or desired program code means in the form of computer-executable instructions or data structures and which can be accessed by a general purpose or special purpose computer. Combinations of the above should also be included within the scope of computer-readable media.
[0030] Further, upon reaching various computer system components, program code means in the form of computer-executable instructions or data structures can be transferred automatically from transmission media to computer storage media (or vice versa). For example, computer-executable instructions or data structures received over a network or data link can be buffered in RAM within a network interface module (e.g., a "NIC"), and then eventually transferred to computer system RAM and/or to less volatile computer storage media at a computer system. Thus, it should be understood that computer storage media can be included in computer system components that also (or even primarily) utilize transmission media.
[0031] Computer-executable instructions comprise, for example, instructions and data which, when executed at a processor, cause a general purpose computer, special purpose computer, or special purpose processing device to perform a certain function or group of functions. The computer executable instructions may be, for example, binaries, intermediate format instructions such as assembly language, or even source code. Although the subject matter has been described in language specific to structural features and/or methodological acts, it is to be understood that the subject matter defined in the appended claims is not necessarily limited to the described features or acts described
above. Rather, the described features and acts are disclosed as example forms of implementing the claims.
[0032] Those skilled in the art will appreciate that the invention may be practiced in network computing environments with many types of computer system configurations, including, personal computers, desktop computers, laptop computers, message processors, hand-held devices, multi-processor systems, microprocessor-based or programmable consumer electronics, network PCs, minicomputers, mainframe computers, mobile telephones, PDAs, pagers, routers, switches, and the like. The invention may also be practiced in distributed system environments where local and remote computer systems, which are linked (either by hardwired data links, wireless data links, or by a combination of hardwired and wireless data links) through a network, both perform tasks. In a distributed system environment, program modules may be located in both local and remote memory storage devices.
[0033] The system offers a user interface (or a "portal") that displays multiple user interface elements that may also be called herein "parts". The part acts as a container for the results of execution of one or more underlying user interface controls (also called herein simply "controls"). The manner of display of the part may be customized, as may be the ordering and composition of the part with respect to other user interface elements.
[0034] The execution of the controls often involves one or more underlying queries to retrieve information that is displayed in the part, or otherwise processed. In accordance with the principles described herein, the user may modify the underlying query that retrieves the information. This allows the users to further control the user experience in fundamental ways, such as defining the actual data that is being displayed. In accordance with the principles described herein, this capability is offered in a consistent way, which honors the constraints of the portal to provide a portal in which many contributors may offer parts without sacrificing a consistent look and feel of the portal. Accordingly, the query customizations described herein may be applied to any part, regardless of the contributor of the part.
[0035] The principles described herein allow the user to filter different sets of displayed data, and do further queries on their data sources. Even though the data sources are different depending on the part, the representation of the query may share a common visual representation. For instance the common visual representation may be a set of conditions connected by logical connectors and, eventually, groupings.
[0036] The query building capability includes a query builder user interface element that is displayed to a user and represents a user interface for authoring queries over data sources. The query building capability also includes a query building component that receives query schemas from the user interface control, manifests at least some of the query schemas via the query builder user interface element, and then builds a formal representation of a query based on user edits conducted through user interaction with the query builder user interface element.
[0037] Figure 2 illustrates an environment 200 that shows collaborating elements that facilitate a query building capability. The environment 200 includes a user interface control 210, a query builder component 220, a query builder user interface 230, and a user interface element 240. The user interface control 210 is queriable in that it may generate a submit queries, and populate the corresponding user interface element 240 with at least a portion of the query results.
[0038] A query builder component 220 exposes an input interface whereby the user interface control 210 may provide a query schema 201 to the query builder component (reference arrow 211). The query schema 201 identifies available parameters for composing queries that the corresponding user interface control 210 is capable of using to populate the corresponding user interface element 240. The query builder component 220 then proceeds to build a query corresponding to the schema. Although only one user interface control 210 is illustrated in Figure 2, the query builder component 220 may proceed to build a distinct query in response to each of multiple schemas received various different times at the query builder component 220. Furthermore, even for a single user interface control, the query builder component may operate as described herein to build multiple queries, each selectable to provide a different view of the user interface element.
[0039] The query builder component 220 builds queries by generating a query builder user interface 230 (reference arrow 212). The query builder user interface 230 is built from a particular query builder user interface class and thus there is some similarity in appearance each time the query builder component 230 generates a query builder using interface. However, the query builder user interface 230 may be customized to the corresponding user interface control 210 by presenting at least some of the available query parameters to the user. In the case of query builder user interface 230, a name field, an age field, and a newness status field are presented to the user. At this point, the user may interact with the query builder user interface 230 to edit the query parameters.
[0040] At some point, the query builder component 220 determines that a query is to be built based on the edited data in the query builder user interface 230 (reference arrow 213). The query builder component 220 then generates a query using the then current values of the available query parameters. The query is generated in a pre-existing format recognized by the user interface control 210. For instance, in Figure 2, the user might select the Save button in the query builder user interface 230, causing the query builder component 220 to generate an Abstract Syntax Tree (AST) representation 202 of the query. The Abstract Syntax Tree representation is an example of a uniform query format that the user interface element 210 may then access (reference arrow 214) from an output interface of the query builder component 220. The user interface control 210 then performs the query and provides the resulting data for presentation in the corresponding user interface element 240 (reference arrow 215).
[0041] Figure 3 illustrates more specific example operations of the user interface control 310, the query builder component 320, and the query builder user interface 330, which may be examples of the respective elements 210, 220 and 230 of Figure 2. The "Control UX" represents an example query builder user interface. The query builder user interface 330 presents a user experience for authoring queries, the user experience being data driven from the schema provided by the part. The query builder user interface 330 presents at least some of the available query parameters to a user.
[0042] For instance, in this case, the query builder user interface 330 shows date range fields, an "assigned to" field, a state field, and tags fields. Those fields may be defined by the query schema provided by the user interface control 310. Likewise, those queries are grouped in a certain way using logical operators. Such groupings may also be defined by the query schema provided by the user interface control 310. Thus, the schema defines available fields and rules for composing a query, and the query building user interface presents at least some of those fields and rules to a user for editing.
[0043] A visual query created by a user results in an abstract query representation based on a portal-defined Abstract Syntax Tree (AST). This Abstract Syntax Tree is created by the query builder component 320, and represents the predicates of the query. The query is then passed to the user interface control 310 (i.e., the data layer or the owner of the data). The AST format may be uniform across the system so that all data sources and schemas will project the same user experience (e.g., display the same query builder control albeit driven by different data and schemas) and the same predicated definition (e.g., via the AST).
[0044] The user interface control (or some other portion of the data layer) receives the AST and translates to their query format of choice. For instance, intrinsic parts may be offered by the system itself and have a standard component for execution abstract representations of a predicate in a certain format (e.g., OData). On the other hand, an application provider may have provided a set of parts for execution within the system. The application provider also includes a component for executing abstract representations of a predicate, but perhaps in a different format than the system. The data layer may thus translate the query format to an abstract representation of choice. The results are returned to the user interface element (or part) that projects the resulting data set on the screen.
[0045] There is a high level of independence between each of the three layers illustrated in Figure 3. A primary connecting piece is the abstract predicate representation (AST with the query). Multiple user experiences can end up generating an instance of a predicate following this schema. Predicates can be later translated into different types of queries, depending on the target data source. For instance, the tree can be translated to OData predicates, SQL queries, and so forth.
[0046] Once the general tree representation is established, the available components (or fields) of the query are metadata-driven. By doing this, different configurations of predicates can be produced using the same stack (e.g. queries for bugs, web sites, team members, etc.).
[0047] The query builder component is data-driven and results in a consistent experience regardless of which entity generated the part. Any application can provide a schema associated with any of their parts and as a result of getting a query builder component, the application will get an updated query based on user input.
[0048] In some embodiments, the query building may not be made available to all parts. To be queriable, a part implements a certain contract that indicates that it can be queried. The contract exposes a query schema (that governs the user experience of the query builder) and receives back an AST with the query entered by the user. For instance, Figure 2 shows the implementation of the contract with the queriable user interface control 210 on the left offering (211) a schema (201). That schema drives the query builder user interface 230 shown on the right, in the manner previously described. The query builder control generates a corresponding AST, as previously described, and provides the AST with the query back to the user via the queriable part.
[0049] Query building is a data-driven task where the user experience is controlled by the query builder component. Users provide their schema and query instance, and in return receive an updated query (described using a common predicate structure).
[0050] As mentioned above, the AST that represents the query is a uniform abstraction in the system. Once an application (often referred to as an "extension" herein) receives a query, it is the applications responsibility to get the AST (the query representation) and transform it to a query to their underlying data repository. By default the system provides some converters to popular formats, but applications parse the AST and issue the query to the backend. The query builder itself does not run the query.
[0051] For instance, referring to Figure 4, the uniform abstraction 410 of the AST query is represented on the left. The uniform abstraction may be provided to any number of different extensions (e.g., Extension A through C on the right in Figure 3). The extension then transforms the AST to an appropriate query format for its backend. For instance, as illustrated in Figure 4, extension A transforms the uniform AST query into an OData query using an OData helper provided by the portal, extension B transforms the uniform AST query into a proprietary Uniform Resource Identifier (URI) using their proprietary logic, and extension C transforms the uniform AST query into a SQL sentence. The extensions themselves then submit the respective appropriately transformed query to their back end data. Alternatively, given the abstract AST representation, the extension could also decide to not use the query builder control and generating their own UI (built out of our existing controls, so they still have user experience consistency). In this case, the same contracts apply (metadata + AST). This allows for extra flexibility and is an extensibility point.
[0052] The query schema identifies the fields (which includes name, type, operations, and so forth) available to construct the query. These query parameters are passed as input to the query builder component, which then drives the query builder user interface. The query instance is the actual query entered by the user. This parameter is passed as input to the query builder component to show the current query and, the query is passed back to the user interface element once the query is modified by the user.
[0053] The query builder user interface can be initiated by a gesture. Figure 5 shows an example where that gesture is a right-click command, but that is just one of an infinitely variety of gestures that might be chosen. In the illustrated example of Figure 5, by selecting the "edit data" option, the query builder is displayed. This option might only be
available for user interface controls that honor the query building contract that allows the part to be queriable as previously described.
[0054] Building queries is a complex task and building them from scratch may not be an option for all users and all scenarios. Accordingly, in some embodiments, the queries generated by the query builder component can have two modes; namely, locked and unlocked.
[0055] In locked mode, the fields displayed in the query builder are the same. The user can enter the values for the fields but cannot alter the composition of the query. Figure 6 illustrates an example query builder user interface in the case of a locked query.
[0056] In unlocked mode, the user can compose queries as desired. Users can add, remove, change filters, group filters, change operators, change logical connectors, and so forth. Figure 7 illustrates an example query builder user interface in the case of an unlocked query.
[0057] The query builder control is not limited to altering data, but can also help to drive how the data is presented. Figure 8 illustrates a query builder user interface that may be provided for this purpose.
[0058] The implementation is similar to the query building already described. The query builder control receives a schema with all the available presentation options. To preserve a consistent look and feel of the portion, the presentation options provided by the schema may be constrained to what is supported by the system. After the user inputs their desired selection, the selection is returned back to the originating part to be applied. The query builder control does not have any control over how data is presented in the actual part, but just presents available options and collects preferences from the user.
[0059] Queries created with the query builder control can be saved and associated with the originator. By doing this, a user can have multiple data or presentation views that can be associated to a given part. Figure 9 illustrates a user interface in which multiple data views are offered for a part, and in which the user is given the option of generating further views (using the query builder control).
[0060] Accordingly, the principles described herein provide a convenient manner for allowing users to control what data is being presented in a user interface element. Furthermore, such query building may be performed in a consistent manner regardless of whether the user interface element is an intrinsic or extrinsic user interface element. Furthermore, since any user interface element that is queriable may user the query building component, so long as the user interface element abides by the contract with the
query builder component, this query building may be enabled in a composable system in which there are many contributors of user interface elements.
[0061] The present invention may be embodied in other specific forms without departing from its spirit or essential characteristics. The described embodiments are to be considered in all respects only as illustrative and not restrictive. The scope of the invention is, therefore, indicated by the appended claims rather than by the foregoing description. All changes which come within the meaning and range of equivalency of the claims are to be embraced within their scope.
Claims
1. A computer program product comprising one or more computer-readable storage media having thereon computer-executable instructions that are structured such that, when executed by one or more processors of a computing system, cause the computing system to instantiate and/or operate the following:
a query builder component that is configured to read schemas provided by controls associated with user interface elements, the schemas including a given schema provided by a given control identifying available query parameters that that the given control is capable of using to populate a corresponding user interface element, and
the query builder user interface configured to present at least some of the available query parameters to a user for editing by a user, and configured to generate a query based on the edits provided by the user.
2. The computer program product in accordance with Claim 1, the schema also describing presentation options for results of the query, the query builder user interface configured to present at least some of the presentation options to the user, and configured to provide user selection of the presentation options back to the given control.
3. The computer program product in accordance with Claim 2, the given control using the selected presentation options in order to present the user interface element.
4. The computer program product in accordance with Claim 1, the query builder user interface further configured to provide the generated query in a uniform format.
5. The computer program product in accordance with Claim 4, wherein the computer-executable instructions are further structured such that, when executed by the one or more processors of the computing system, cause the computing system to instantiate and/or operate the following:
a first query transforming component that transforms queries in the uniform form to a first specific format.
6. The computer program product in accordance with Claim 5, wherein the computer-executable instructions are further structured such that, when executed by the one or more processors of the computing system, cause the computing system to instantiate and/or operate the following:
a second query transforming component that transforms queries in the uniform form to a second specific format.
7. The computer program product in accordance with Claim 1, wherein the computer-executable instructions are further structured such that, when executed by the one or more processors of the computing system, cause the computing system to instantiate and/or operate the following:
a first control capable of running queries to populate a first user interface element and that offers a first schema identifying available parameters for composing the query.
8. A method for constructing a query using a query builder component, the method comprising:
an act of the query builder component receiving a schema from a user interface control, the schema identifying available parameters for composing queries that the user interface control is capable of using to populate a user interface element corresponding to the user interface control;
an act of the query builder component generating a query builder user interface that is customized to the user interface control by presenting at least some of the available parameters to a user;
an act of the query builder component determining that a query is to be constructed based on current values of the available parameters displayed in the query builder user interface; and
an act of the query builder component providing the query on an output interface that is accessible by the user interface component.
9. The method in accordance with Claim 8, the schema being a first schema, the user interface control being a first user interface control, the available parameters being first available parameters, the query being a first query, the user interface element being a first user interface element, the query builder user interface being a first query builder user interface, the method further comprising:
an act of the query builder component receiving a second schema from a second user interface control, the second schema identifying second available parameters for composing queries that the second user interface control is capable of using to populate a second user interface element corresponding to the second user interface control;
an act of the query builder component generating a second query builder user interface that is customized to the second user interface control by presenting at least some of the second available parameters to a user;
an act of the query builder component determining that a second query is to be constructed based on current values of the second available parameters displayed in the second query builder user interface; and
an act of the query builder component providing the second query on the output interface that is also accessible by the second user interface component.
10. A method in accordance with Claim 9, the first and second query builder user interface being of the same class, and the first and second query being of the same uniform format.
Applications Claiming Priority (24)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US201361884743P | 2013-09-30 | 2013-09-30 | |
US61/884,743 | 2013-09-30 | ||
US201361905101P | 2013-11-15 | 2013-11-15 | |
US201361905114P | 2013-11-15 | 2013-11-15 | |
US201361905129P | 2013-11-15 | 2013-11-15 | |
US201361905105P | 2013-11-15 | 2013-11-15 | |
US201361905111P | 2013-11-15 | 2013-11-15 | |
US201361905116P | 2013-11-15 | 2013-11-15 | |
US201361905119P | 2013-11-15 | 2013-11-15 | |
US201361905128P | 2013-11-15 | 2013-11-15 | |
US61/905,101 | 2013-11-15 | ||
US61/905,119 | 2013-11-15 | ||
US61/905,111 | 2013-11-15 | ||
US61/905,129 | 2013-11-15 | ||
US61/905,114 | 2013-11-15 | ||
US61/905,116 | 2013-11-15 | ||
US61/905,105 | 2013-11-15 | ||
US61/905,128 | 2013-11-15 | ||
US201361905243P | 2013-11-17 | 2013-11-17 | |
US201361905247P | 2013-11-17 | 2013-11-17 | |
US61/905,243 | 2013-11-17 | ||
US61/905,247 | 2013-11-17 | ||
US14/231,880 | 2014-04-01 | ||
US14/231,880 US20150095365A1 (en) | 2013-09-30 | 2014-04-01 | Query building using schema |
Publications (1)
Publication Number | Publication Date |
---|---|
WO2015048204A1 true WO2015048204A1 (en) | 2015-04-02 |
Family
ID=52741177
Family Applications (7)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/US2014/057322 WO2015048204A1 (en) | 2013-09-30 | 2014-09-25 | Query building using schema |
PCT/US2014/057324 WO2015048206A1 (en) | 2013-09-30 | 2014-09-25 | Rendering interpreter for visualizing data provided from restricted environment container |
PCT/US2014/057323 WO2015048205A1 (en) | 2013-09-30 | 2014-09-25 | Persisting state at scale across browser sessions |
PCT/US2014/057321 WO2015048203A1 (en) | 2013-09-30 | 2014-09-25 | Control and part compliant hierarchy |
PCT/US2014/057940 WO2015048602A1 (en) | 2013-09-30 | 2014-09-29 | Pan and selection gesture detection |
PCT/US2014/057938 WO2015048600A1 (en) | 2013-09-30 | 2014-09-29 | Extendable blade sequence along pannable canvas direction |
PCT/US2014/057939 WO2015048601A1 (en) | 2013-09-30 | 2014-09-29 | Context aware user interface parts |
Family Applications After (6)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/US2014/057324 WO2015048206A1 (en) | 2013-09-30 | 2014-09-25 | Rendering interpreter for visualizing data provided from restricted environment container |
PCT/US2014/057323 WO2015048205A1 (en) | 2013-09-30 | 2014-09-25 | Persisting state at scale across browser sessions |
PCT/US2014/057321 WO2015048203A1 (en) | 2013-09-30 | 2014-09-25 | Control and part compliant hierarchy |
PCT/US2014/057940 WO2015048602A1 (en) | 2013-09-30 | 2014-09-29 | Pan and selection gesture detection |
PCT/US2014/057938 WO2015048600A1 (en) | 2013-09-30 | 2014-09-29 | Extendable blade sequence along pannable canvas direction |
PCT/US2014/057939 WO2015048601A1 (en) | 2013-09-30 | 2014-09-29 | Context aware user interface parts |
Country Status (17)
Country | Link |
---|---|
US (11) | US20150095849A1 (en) |
EP (6) | EP3053028B1 (en) |
JP (2) | JP6465870B2 (en) |
KR (3) | KR102186865B1 (en) |
CN (6) | CN105683907B (en) |
AU (2) | AU2014324620A1 (en) |
BR (1) | BR112016004551A8 (en) |
CA (2) | CA2922725A1 (en) |
CL (1) | CL2016000729A1 (en) |
HK (1) | HK1222731A1 (en) |
IL (1) | IL244368A0 (en) |
MX (2) | MX2016003946A (en) |
PH (1) | PH12016500256A1 (en) |
RU (2) | RU2679540C2 (en) |
SG (2) | SG10201802632SA (en) |
TW (4) | TW201528106A (en) |
WO (7) | WO2015048204A1 (en) |
Families Citing this family (36)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
USD750112S1 (en) * | 2013-01-04 | 2016-02-23 | Samsung Electronics Co., Ltd. | Portable electronic device with graphical user interface |
US20150095849A1 (en) * | 2013-09-30 | 2015-04-02 | Microsoft Corporation | Dialogs positioned with action visualization |
USD745877S1 (en) * | 2013-10-17 | 2015-12-22 | Microsoft Corporation | Display screen with graphical user interface |
US10176218B2 (en) * | 2014-11-07 | 2019-01-08 | Sap Se | OData custom query composer |
US10452750B2 (en) | 2015-08-04 | 2019-10-22 | Google Llc | Systems and methods for interactively presenting a visible portion of a rendering surface on a user device |
US10990258B2 (en) * | 2015-08-04 | 2021-04-27 | Google Llc | Interactively presenting a visible portion of a rendering surface on a user device |
JP6812639B2 (en) * | 2016-02-03 | 2021-01-13 | セイコーエプソン株式会社 | Electronic devices, control programs for electronic devices |
US10289297B2 (en) * | 2016-08-26 | 2019-05-14 | Google Llc | Animating an image to indicate that the image is pannable |
US9871911B1 (en) * | 2016-09-30 | 2018-01-16 | Microsoft Technology Licensing, Llc | Visualizations for interactions with external computing logic |
KR102605332B1 (en) * | 2016-11-02 | 2023-11-23 | 주식회사 넥슨코리아 | Device and method to provide content |
US10796088B2 (en) * | 2017-04-21 | 2020-10-06 | International Business Machines Corporation | Specifying a conversational computer agent and its outcome with a grammar |
WO2018208047A1 (en) | 2017-05-09 | 2018-11-15 | Samsung Electronics Co., Ltd. | Method and system for managing and displaying application |
US10827319B2 (en) * | 2017-06-02 | 2020-11-03 | Apple Inc. | Messaging system interacting with dynamic extension app |
CN110019717B (en) * | 2017-12-15 | 2021-06-29 | 上海智臻智能网络科技股份有限公司 | Device for modifying multi-turn question-answering system |
CN110019718B (en) * | 2017-12-15 | 2021-04-09 | 上海智臻智能网络科技股份有限公司 | Method for modifying multi-turn question-answering system, terminal equipment and storage medium |
US11341422B2 (en) | 2017-12-15 | 2022-05-24 | SHANGHAI XIAOl ROBOT TECHNOLOGY CO., LTD. | Multi-round questioning and answering methods, methods for generating a multi-round questioning and answering system, and methods for modifying the system |
US11379252B1 (en) * | 2018-01-31 | 2022-07-05 | Parallels International Gmbh | System and method for providing layouts for a remote desktop session |
US11659003B2 (en) | 2018-08-30 | 2023-05-23 | International Business Machines Corporation | Safe shell container facilitating inspection of a virtual container |
US10902045B2 (en) * | 2018-09-18 | 2021-01-26 | Tableau Software, Inc. | Natural language interface for building data visualizations, including cascading edits to filter expressions |
US11048871B2 (en) * | 2018-09-18 | 2021-06-29 | Tableau Software, Inc. | Analyzing natural language expressions in a data visualization user interface |
CN109542563B (en) * | 2018-11-09 | 2022-06-07 | 优信数享(北京)信息技术有限公司 | Multi-state integrated android page management method, device and system |
US11385766B2 (en) | 2019-01-07 | 2022-07-12 | AppEsteem Corporation | Technologies for indicating deceptive and trustworthy resources |
EP3764210A1 (en) | 2019-07-08 | 2021-01-13 | dSPACE digital signal processing and control engineering GmbH | Display of display areas on a desktop |
US11089050B1 (en) * | 2019-08-26 | 2021-08-10 | Ca, Inc. | Isolating an iframe of a webpage |
US11455339B1 (en) | 2019-09-06 | 2022-09-27 | Tableau Software, LLC | Incremental updates to natural language expressions in a data visualization user interface |
US11474975B2 (en) | 2019-09-18 | 2022-10-18 | Microsoft Technology Licensing, Llc | Identity represented assets in a content management system |
US11199955B2 (en) * | 2019-10-02 | 2021-12-14 | Palantir Technologies Inc. | Enhanced techniques for building user interfaces |
CN110825766A (en) * | 2019-11-13 | 2020-02-21 | 恩亿科(北京)数据科技有限公司 | Query condition generation method and device, server and readable storage medium |
CN110995942B (en) * | 2019-12-06 | 2021-08-06 | 科大国创软件股份有限公司 | Soft switch automatic calling method and system based on interface visualization |
CN111177455A (en) * | 2019-12-31 | 2020-05-19 | 精英数智科技股份有限公司 | Method, device and equipment for determining cutting tooth load type of coal mining machine and storage medium |
CN111610912B (en) * | 2020-04-24 | 2023-10-10 | 北京小米移动软件有限公司 | Application display method, application display device and storage medium |
WO2022049220A2 (en) | 2020-09-02 | 2022-03-10 | Genmab A/S | Antibody therapy |
US11698933B1 (en) | 2020-09-18 | 2023-07-11 | Tableau Software, LLC | Using dynamic entity search during entry of natural language commands for visual data analysis |
US11301631B1 (en) | 2020-10-05 | 2022-04-12 | Tableau Software, LLC | Visually correlating individual terms in natural language input to respective structured phrases representing the natural language input |
CN112732243A (en) * | 2021-01-11 | 2021-04-30 | 京东数字科技控股股份有限公司 | Data processing method and device for generating functional component |
US11363050B1 (en) | 2021-03-25 | 2022-06-14 | Bank Of America Corporation | Information security system and method for incompliance detection in data transmission |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050131889A1 (en) * | 2003-12-11 | 2005-06-16 | International Business Machines Corporation | Intelligent data query builder |
US20060053096A1 (en) * | 2004-09-08 | 2006-03-09 | Oracle International Corporation | Natural language query construction using purpose-driven template |
Family Cites Families (180)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPS6362033A (en) * | 1986-09-02 | 1988-03-18 | Nec Corp | Display device for relative information |
WO1994024657A1 (en) * | 1993-04-20 | 1994-10-27 | Apple Computer Inc. | Interactive user interface |
US5625763A (en) * | 1995-05-05 | 1997-04-29 | Apple Computer, Inc. | Method and apparatus for automatically generating focus ordering in a dialog on a computer system |
JPH09245188A (en) * | 1996-03-12 | 1997-09-19 | Fujitsu Ltd | Graphic displaying method and its device |
US5845299A (en) | 1996-07-29 | 1998-12-01 | Rae Technology Llc | Draw-based editor for web pages |
US6049812A (en) | 1996-11-18 | 2000-04-11 | International Business Machines Corp. | Browser and plural active URL manager for network computers |
US6128632A (en) * | 1997-03-06 | 2000-10-03 | Apple Computer, Inc. | Methods for applying rubi annotation characters over base text characters |
US6091415A (en) * | 1997-05-02 | 2000-07-18 | Inventec Corporation | System and method for displaying multiple dialog boxes in a window display |
US5886694A (en) * | 1997-07-14 | 1999-03-23 | Microsoft Corporation | Method for automatically laying out controls in a dialog window |
US5995101A (en) * | 1997-10-29 | 1999-11-30 | Adobe Systems Incorporated | Multi-level tool tip |
US6236400B1 (en) * | 1998-04-02 | 2001-05-22 | Sun Microsystems, Inc. | Method and apparatus for controlling the display of hierarchical information |
US6473102B1 (en) | 1998-05-11 | 2002-10-29 | Apple Computer, Inc. | Method and system for automatically resizing and repositioning windows in response to changes in display |
US7801913B2 (en) | 1998-12-07 | 2010-09-21 | Oracle International Corporation | System and method for querying data for implicit hierarchies |
US6460060B1 (en) | 1999-01-26 | 2002-10-01 | International Business Machines Corporation | Method and system for searching web browser history |
JP2000331020A (en) * | 1999-05-21 | 2000-11-30 | Nippon Telegr & Teleph Corp <Ntt> | Method and device for information reference and storage medium with information reference program stored |
US6701513B1 (en) | 2000-01-14 | 2004-03-02 | Measurement Computing Corporation | Program-development environment for use in generating application programs |
US7243335B1 (en) * | 2000-02-17 | 2007-07-10 | Microsoft Corporation | Method and system for reducing coding complexity by providing intelligent manipulable defaults |
US6681383B1 (en) * | 2000-04-04 | 2004-01-20 | Sosy, Inc. | Automatic software production system |
US6473891B1 (en) | 2000-05-03 | 2002-10-29 | Lsi Logic Corporation | Wire routing to control skew |
US7062475B1 (en) | 2000-05-30 | 2006-06-13 | Alberti Anemometer Llc | Personalized multi-service computer environment |
US6750887B1 (en) | 2000-06-02 | 2004-06-15 | Sun Microsystems, Inc. | Graphical user interface layout manager |
US7171455B1 (en) | 2000-08-22 | 2007-01-30 | International Business Machines Corporation | Object oriented based, business class methodology for generating quasi-static web pages at periodic intervals |
US6919890B2 (en) | 2000-09-28 | 2005-07-19 | Curl Corporation | Grid and table layout using elastics |
US6640655B1 (en) * | 2000-10-03 | 2003-11-04 | Varco I/P, Inc. | Self tracking sensor suspension mechanism |
US6950198B1 (en) | 2000-10-18 | 2005-09-27 | Eastman Kodak Company | Effective transfer of images from a user to a service provider |
US7370040B1 (en) * | 2000-11-21 | 2008-05-06 | Microsoft Corporation | Searching with adaptively configurable user interface and extensible query language |
WO2002046878A2 (en) | 2000-12-06 | 2002-06-13 | American Express Travel Related Services Company, Inc. | Layout generator system and method |
US6760128B2 (en) | 2000-12-06 | 2004-07-06 | Eastman Kodak Company | Providing a payment schedule for utilizing stored images using a designated date |
JP2002182812A (en) * | 2000-12-14 | 2002-06-28 | Smg Kk | Site map display system |
US7233998B2 (en) | 2001-03-22 | 2007-06-19 | Sony Computer Entertainment Inc. | Computer architecture and software cells for broadband networks |
US7203678B1 (en) | 2001-03-27 | 2007-04-10 | Bea Systems, Inc. | Reconfigurable query generation system for web browsers |
US20020147963A1 (en) | 2001-04-09 | 2002-10-10 | Lee Rusty Shawn | Method and apparatus for generating machine control instructions |
US20020180811A1 (en) | 2001-05-31 | 2002-12-05 | Chu Sing Yun | Systems, methods, and articles of manufacture for providing a user interface with selection and scrolling |
US20030011638A1 (en) | 2001-07-10 | 2003-01-16 | Sun-Woo Chung | Pop-up menu system |
US6950993B2 (en) | 2001-08-02 | 2005-09-27 | Microsoft Corporation | System and method for automatic and dynamic layout of resizable dialog type windows |
US6944829B2 (en) | 2001-09-25 | 2005-09-13 | Wind River Systems, Inc. | Configurable user-interface component management system |
US7480864B2 (en) * | 2001-10-12 | 2009-01-20 | Canon Kabushiki Kaisha | Zoom editor |
US7620908B2 (en) | 2001-12-28 | 2009-11-17 | Sap Ag | Managing a user interface |
US20050066037A1 (en) * | 2002-04-10 | 2005-03-24 | Yu Song | Browser session mobility system for multi-platform applications |
CA2385224C (en) | 2002-05-07 | 2012-10-02 | Corel Corporation | Dockable drop-down dialogs |
US7065707B2 (en) | 2002-06-24 | 2006-06-20 | Microsoft Corporation | Segmenting and indexing web pages using function-based object models |
US7293024B2 (en) | 2002-11-14 | 2007-11-06 | Seisint, Inc. | Method for sorting and distributing data among a plurality of nodes |
US20080177994A1 (en) | 2003-01-12 | 2008-07-24 | Yaron Mayer | System and method for improving the efficiency, comfort, and/or reliability in Operating Systems, such as for example Windows |
US7000184B2 (en) * | 2003-01-24 | 2006-02-14 | The Cobalt Group, Inc. | Remote web site editing in a standard web browser without external software |
US20040165009A1 (en) * | 2003-02-20 | 2004-08-26 | International Business Machines Corporation | Expansion of interactive user interface components |
US7823077B2 (en) | 2003-03-24 | 2010-10-26 | Microsoft Corporation | System and method for user modification of metadata in a shell browser |
US7769794B2 (en) | 2003-03-24 | 2010-08-03 | Microsoft Corporation | User interface for a file system shell |
US7720616B2 (en) | 2003-05-07 | 2010-05-18 | Sureprep, Llc | Multi-stage, multi-user engagement submission and tracking process |
US7417644B2 (en) | 2003-05-12 | 2008-08-26 | Microsoft Corporation | Dynamic pluggable user interface layout |
US7669140B2 (en) | 2003-08-21 | 2010-02-23 | Microsoft Corporation | System and method for providing rich minimized applications |
US8230366B2 (en) | 2003-10-23 | 2012-07-24 | Apple Inc. | Dynamically changing cursor for user interface |
US8037420B2 (en) | 2003-12-04 | 2011-10-11 | International Business Machines Corporation | Maintaining browser navigation relationships and for choosing a browser window for new documents |
US20080109785A1 (en) | 2004-01-16 | 2008-05-08 | Bailey Bendrix L | Graphical Program Having Graphical and/or Textual Specification of Event Handler Procedures for Program Objects |
GB2411331A (en) * | 2004-02-19 | 2005-08-24 | Trigenix Ltd | Rendering user interface using actor attributes |
US7577938B2 (en) | 2004-02-20 | 2009-08-18 | Microsoft Corporation | Data association |
US7536672B1 (en) | 2004-03-05 | 2009-05-19 | Adobe Systems Incorporated | Management of user interaction history with software applications |
US7694233B1 (en) * | 2004-04-30 | 2010-04-06 | Apple Inc. | User interface presentation of information in reconfigured or overlapping containers |
CN100343802C (en) * | 2004-05-10 | 2007-10-17 | 华为技术有限公司 | Method and system for unifying users'interface |
US8453065B2 (en) | 2004-06-25 | 2013-05-28 | Apple Inc. | Preview and installation of user interface elements in a display environment |
US8046712B2 (en) | 2004-06-29 | 2011-10-25 | Acd Systems International Inc. | Management of multiple window panels with a graphical user interface |
US8117542B2 (en) * | 2004-08-16 | 2012-02-14 | Microsoft Corporation | User interface for displaying selectable software functionality controls that are contextually relevant to a selected object |
EP1779216A1 (en) | 2004-08-20 | 2007-05-02 | Rhoderick John Kennedy Pugh | Server authentication |
US7434173B2 (en) | 2004-08-30 | 2008-10-07 | Microsoft Corporation | Scrolling web pages using direct interaction |
US8819569B2 (en) | 2005-02-18 | 2014-08-26 | Zumobi, Inc | Single-handed approach for navigation of application tiles using panning and zooming |
US7728825B2 (en) * | 2005-03-22 | 2010-06-01 | Microsoft Corporation | Targeting in a stylus-based user interface |
US20060224951A1 (en) * | 2005-03-30 | 2006-10-05 | Yahoo! Inc. | Multiple window browser interface and system and method of generating multiple window browser interface |
US20060236264A1 (en) * | 2005-04-18 | 2006-10-19 | Microsoft Corporation | Automatic window resize behavior and optimizations |
US8195646B2 (en) | 2005-04-22 | 2012-06-05 | Microsoft Corporation | Systems, methods, and user interfaces for storing, searching, navigating, and retrieving electronic information |
US7721225B2 (en) | 2005-05-03 | 2010-05-18 | Novell, Inc. | System and method for creating and presenting modal dialog boxes in server-side component web applications |
US7730418B2 (en) | 2005-05-04 | 2010-06-01 | Workman Nydegger | Size to content windows for computer graphics |
US20070024646A1 (en) * | 2005-05-23 | 2007-02-01 | Kalle Saarinen | Portable electronic apparatus and associated method |
US20060282771A1 (en) | 2005-06-10 | 2006-12-14 | Tad Vinci | Verifying document compliance to a subsidiary standard |
US20070033522A1 (en) | 2005-08-02 | 2007-02-08 | Lin Frank L | System and method for dynamic resizing of web-based GUIs |
US7933632B2 (en) | 2005-09-16 | 2011-04-26 | Microsoft Corporation | Tile space user interface for mobile devices |
US8543824B2 (en) | 2005-10-27 | 2013-09-24 | Apple Inc. | Safe distribution and use of content |
US7954064B2 (en) | 2005-10-27 | 2011-05-31 | Apple Inc. | Multiple dashboards |
US8434021B2 (en) * | 2005-11-30 | 2013-04-30 | Microsoft Corporation | Centralized user interface for displaying contextually driven business content and business related functionality |
US7836303B2 (en) | 2005-12-09 | 2010-11-16 | University Of Washington | Web browser operating system |
US8898203B2 (en) | 2005-12-27 | 2014-11-25 | International Business Machines Corporation | Generating a separable query design object and database schema through visual view editing |
JP4635894B2 (en) | 2006-02-13 | 2011-02-23 | ソニー株式会社 | Information processing apparatus and method, and program |
JP4415961B2 (en) | 2006-03-15 | 2010-02-17 | ブラザー工業株式会社 | Removable media device and data control program |
US20070233854A1 (en) | 2006-03-31 | 2007-10-04 | Microsoft Corporation | Management status summaries |
US20070234195A1 (en) | 2006-04-03 | 2007-10-04 | National Instruments Corporation | Simultaneous update of a plurality of user interface elements displayed in a web browser |
US7685519B1 (en) * | 2006-07-18 | 2010-03-23 | Intuit Inc. | Process and apparatus for providing a customizable content tooltip |
US20080018665A1 (en) * | 2006-07-24 | 2008-01-24 | Jay Behr | System and method for visualizing drawing style layer combinations |
US8869027B2 (en) | 2006-08-04 | 2014-10-21 | Apple Inc. | Management and generation of dashboards |
US20080065974A1 (en) * | 2006-09-08 | 2008-03-13 | Tom Campbell | Template-based electronic presence management |
US7890957B2 (en) | 2006-09-08 | 2011-02-15 | Easyonme, Inc. | Remote management of an electronic presence |
US20080109714A1 (en) | 2006-11-03 | 2008-05-08 | Sap Ag | Capturing screen information |
US8082539B1 (en) | 2006-12-11 | 2011-12-20 | Parallels Holdings, Ltd. | System and method for managing web-based forms and dynamic content of website |
JP5031353B2 (en) | 2006-12-15 | 2012-09-19 | キヤノン株式会社 | Display device, control method, and program |
CN101004685A (en) * | 2007-01-08 | 2007-07-25 | 叶炜 | Method for realizing graphical user interface |
US9032329B2 (en) | 2007-03-23 | 2015-05-12 | Siemens Product Lifecycle Management Software Inc. | System and method for dialog position management |
US8321847B1 (en) | 2007-05-17 | 2012-11-27 | The Mathworks, Inc. | Dynamic function wizard |
US20080306933A1 (en) * | 2007-06-08 | 2008-12-11 | Microsoft Corporation | Display of search-engine results and list |
US10019570B2 (en) | 2007-06-14 | 2018-07-10 | Microsoft Technology Licensing, Llc | Protection and communication abstractions for web browsers |
US8065628B2 (en) | 2007-06-25 | 2011-11-22 | Microsoft Corporation | Dynamic user interface for previewing live content |
KR20090000507A (en) * | 2007-06-28 | 2009-01-07 | 삼성전자주식회사 | Method and apparatus of displaying information |
US8762880B2 (en) * | 2007-06-29 | 2014-06-24 | Microsoft Corporation | Exposing non-authoring features through document status information in an out-space user interface |
US7873746B2 (en) | 2007-07-27 | 2011-01-18 | Lagavulin Limited | User interface for a portable, image-processing transmitter |
US9009181B2 (en) * | 2007-08-23 | 2015-04-14 | International Business Machines Corporation | Accessing objects in a service registry and repository |
US8126840B2 (en) | 2007-10-22 | 2012-02-28 | Noria Corporation | Lubrication program management system and methods |
US8046353B2 (en) | 2007-11-02 | 2011-10-25 | Citrix Online Llc | Method and apparatus for searching a hierarchical database and an unstructured database with a single search query |
CN101499004A (en) * | 2008-01-31 | 2009-08-05 | 株式会社日立制作所 | System and method for connecting virtual machine and user interface |
JP2009193423A (en) * | 2008-02-15 | 2009-08-27 | Panasonic Corp | Input device for electronic equipment |
US20090254822A1 (en) | 2008-04-04 | 2009-10-08 | International Business Machines Corporation | Hi-efficiency wizard framework system and method |
US8219385B2 (en) | 2008-04-08 | 2012-07-10 | Incentive Targeting, Inc. | Computer-implemented method and system for conducting a search of electronically stored information |
JP4171770B1 (en) * | 2008-04-24 | 2008-10-29 | 任天堂株式会社 | Object display order changing program and apparatus |
US8375336B2 (en) * | 2008-05-23 | 2013-02-12 | Microsoft Corporation | Panning content utilizing a drag operation |
US8156445B2 (en) * | 2008-06-20 | 2012-04-10 | Microsoft Corporation | Controlled interaction with heterogeneous data |
US20100005053A1 (en) | 2008-07-04 | 2010-01-07 | Estes Philip F | Method for enabling discrete back/forward actions within a dynamic web application |
US8345014B2 (en) * | 2008-07-12 | 2013-01-01 | Lester F. Ludwig | Control of the operating system on a computing device via finger angle using a high dimensional touchpad (HDTP) touch user interface |
US8566741B2 (en) | 2008-08-29 | 2013-10-22 | Microsoft Corporation | Internal scroll activation and cursor adornment |
US8402381B2 (en) * | 2008-09-23 | 2013-03-19 | International Business Machines Corporation | Automatically arranging widgets of a model within a canvas using iterative region based widget relative adjustments |
US8095412B1 (en) | 2008-11-03 | 2012-01-10 | Intuit Inc. | Method and system for evaluating expansion of a business |
KR20100049474A (en) | 2008-11-03 | 2010-05-12 | 삼성전자주식회사 | A method for remote user interface session migration to other device |
US20120188286A1 (en) * | 2008-11-26 | 2012-07-26 | Lila Aps (Ahead.) | Dynamic image tiling |
US7962547B2 (en) | 2009-01-08 | 2011-06-14 | International Business Machines Corporation | Method for server-side logging of client browser state through markup language |
US20100229115A1 (en) | 2009-03-05 | 2010-09-09 | Microsoft Corporation | Zoomable user interface data generation |
US8806371B2 (en) * | 2009-03-26 | 2014-08-12 | Apple Inc. | Interface navigation tools |
US8819570B2 (en) * | 2009-03-27 | 2014-08-26 | Zumobi, Inc | Systems, methods, and computer program products displaying interactive elements on a canvas |
US20100251143A1 (en) | 2009-03-27 | 2010-09-30 | The Ransom Group, Inc. | Method, system and computer program for creating and editing a website |
US8819597B2 (en) | 2009-04-10 | 2014-08-26 | Google Inc. | Glyph entry on computing device |
US9213541B2 (en) | 2009-04-17 | 2015-12-15 | ArtinSoft Corporation, S.A. | Creation, generation, distribution and application of self-contained modifications to source code |
US20100287530A1 (en) | 2009-05-05 | 2010-11-11 | Borland Software Corporation | Requirements definition using interactive prototyping |
US8269737B2 (en) * | 2009-08-20 | 2012-09-18 | Hewlett-Packard Development Company, L.P. | Method and apparatus for interpreting input movement on a computing device interface as a one- or two-dimensional input |
IN2012DN02458A (en) | 2009-11-13 | 2015-08-21 | Irdeto Canada Corp | |
US8782562B2 (en) * | 2009-12-02 | 2014-07-15 | Dell Products L.P. | Identifying content via items of a navigation system |
US8407598B2 (en) | 2009-12-09 | 2013-03-26 | Ralph Lee Burton | Dynamic web control generation facilitator |
JP5523090B2 (en) * | 2009-12-25 | 2014-06-18 | キヤノン株式会社 | INPUT DEVICE, CONTROL METHOD FOR INPUT DEVICE, PROGRAM, AND STORAGE MEDIUM |
US8533667B2 (en) | 2009-12-30 | 2013-09-10 | International Business Machines Corporation | Call wizard for information management system (IMS) applications |
CN101763218A (en) * | 2010-01-06 | 2010-06-30 | 广东欧珀移动通信有限公司 | Input method for handheld equipment |
WO2011085387A2 (en) * | 2010-01-11 | 2011-07-14 | Everspeech, Inc. | Integrated data processing and transcription service |
EP2548200A4 (en) | 2010-03-19 | 2014-01-22 | Siemens Healthcare Diagnostics | System and method for changeable focus modal windows |
US8316323B2 (en) | 2010-03-26 | 2012-11-20 | Microsoft Corporation | Breadcrumb navigation through heirarchical structures |
US8631350B2 (en) * | 2010-04-23 | 2014-01-14 | Blackberry Limited | Graphical context short menu |
US20120089914A1 (en) * | 2010-04-27 | 2012-04-12 | Surfwax Inc. | User interfaces for navigating structured content |
US20110271184A1 (en) * | 2010-04-28 | 2011-11-03 | Microsoft Corporation | Client application and web page integration |
US9160756B2 (en) | 2010-05-19 | 2015-10-13 | International Business Machines Corporation | Method and apparatus for protecting markup language document against cross-site scripting attack |
JP5674779B2 (en) * | 2010-06-03 | 2015-02-25 | パナソニック インテレクチュアル プロパティ コーポレーション オブアメリカPanasonic Intellectual Property Corporation of America | Scroll device, scroll method, scroll program, and integrated circuit |
CN102270125A (en) * | 2010-06-04 | 2011-12-07 | 中兴通讯股份有限公司 | Device and method for developing Web application |
US20110314415A1 (en) * | 2010-06-21 | 2011-12-22 | George Fitzmaurice | Method and System for Providing Custom Tooltip Messages |
US8706854B2 (en) | 2010-06-30 | 2014-04-22 | Raytheon Company | System and method for organizing, managing and running enterprise-wide scans |
US8544027B2 (en) | 2010-07-30 | 2013-09-24 | Sap Ag | Logical data model abstraction in a physically distributed environment |
US8630462B2 (en) * | 2010-08-31 | 2014-01-14 | Activate Systems, Inc. | Methods and apparatus for improved motion capture |
JP2012069065A (en) * | 2010-09-27 | 2012-04-05 | Nintendo Co Ltd | Information processing program, and information processing device and method |
US8612366B2 (en) | 2010-09-29 | 2013-12-17 | Moresteam.Com Llc | Systems and methods for performing design of experiments |
US8990199B1 (en) | 2010-09-30 | 2015-03-24 | Amazon Technologies, Inc. | Content search with category-aware visual similarity |
US20120124555A1 (en) * | 2010-11-11 | 2012-05-17 | Codekko Software, Inc. | Optimization of Compiled Control Objects |
US9069577B2 (en) * | 2010-11-23 | 2015-06-30 | Apple Inc. | Grouping and browsing open windows |
CN102023749A (en) * | 2010-12-02 | 2011-04-20 | 广东宝莱特医用科技股份有限公司 | Area dragging treating method of list type control on touch screen interface of medical equipment |
US8612874B2 (en) * | 2010-12-23 | 2013-12-17 | Microsoft Corporation | Presenting an application change through a tile |
US20120191508A1 (en) | 2011-01-20 | 2012-07-26 | John Nicholas Gross | System & Method For Predicting Outcome Of An Intellectual Property Rights Proceeding/Challenge |
JP2012168790A (en) | 2011-02-15 | 2012-09-06 | Brother Ind Ltd | Display program and display device |
US9384183B2 (en) * | 2011-03-31 | 2016-07-05 | Infosys Limited | Method and system for reporting web standard non-compliance of web pages |
US9152616B2 (en) | 2011-04-28 | 2015-10-06 | Flipboard, Inc. | Template-based page layout for web content |
US9753699B2 (en) | 2011-06-16 | 2017-09-05 | Microsoft Technology Licensing, Llc | Live browser tooling in an integrated development environment |
US8566100B2 (en) | 2011-06-21 | 2013-10-22 | Verna Ip Holdings, Llc | Automated method and system for obtaining user-selected real-time information on a mobile communication device |
US8799862B2 (en) * | 2011-06-24 | 2014-08-05 | Alcatel Lucent | Application testing using sandboxes |
CN102253841B (en) * | 2011-08-09 | 2014-07-23 | 东莞兆田数码科技有限公司 | Small-scale graphical user interface system |
US20130080913A1 (en) * | 2011-09-22 | 2013-03-28 | Microsoft Corporation | Multi-column notebook interaction |
US8836654B2 (en) | 2011-10-04 | 2014-09-16 | Qualcomm Incorporated | Application window position and size control in (multi-fold) multi-display devices |
JP5553812B2 (en) * | 2011-10-26 | 2014-07-16 | 株式会社ソニー・コンピュータエンタテインメント | Scroll control device, terminal device, and scroll control method |
KR101888457B1 (en) | 2011-11-16 | 2018-08-16 | 삼성전자주식회사 | Apparatus having a touch screen processing plurality of apllications and method for controlling thereof |
US8799780B2 (en) | 2011-11-28 | 2014-08-05 | International Business Machines Corporation | Installation wizard with multidimensional views |
US8799988B2 (en) | 2012-01-25 | 2014-08-05 | Microsoft Corporation | Document communication runtime interfaces |
US20150058709A1 (en) * | 2012-01-26 | 2015-02-26 | Michael Edward Zaletel | Method of creating a media composition and apparatus therefore |
DE102013202782A1 (en) | 2012-02-20 | 2013-08-22 | Wixpress Ltd | Server-based web page design system that integrates dynamic layout and dynamic content |
KR101892567B1 (en) * | 2012-02-24 | 2018-08-28 | 삼성전자 주식회사 | Method and apparatus for moving contents on screen in terminal |
US9389872B2 (en) | 2012-03-16 | 2016-07-12 | Vmware, Inc. | Software wizard implementation framework |
EP2665042A1 (en) | 2012-05-14 | 2013-11-20 | Crytek GmbH | Visual processing based on interactive rendering |
US9043722B1 (en) * | 2012-06-19 | 2015-05-26 | Surfwax, Inc. | User interfaces for displaying relationships between cells in a grid |
US20140096042A1 (en) * | 2012-07-09 | 2014-04-03 | Aaron Tyler Travis | Method and system for generating and storing a collection of interactive browsers within a navigation plane |
US9195477B1 (en) | 2012-10-09 | 2015-11-24 | Sencha, Inc. | Device profiles, deep linking, and browser history support for web applications |
US9244971B1 (en) | 2013-03-07 | 2016-01-26 | Amazon Technologies, Inc. | Data retrieval from heterogeneous storage systems |
US9158518B2 (en) | 2013-03-11 | 2015-10-13 | Blackberry Limited | Collaborative application development environment using a connected device |
WO2014157908A1 (en) | 2013-03-27 | 2014-10-02 | Samsung Electronics Co., Ltd. | Device and method for displaying execution result of application |
US10410003B2 (en) | 2013-06-07 | 2019-09-10 | Apple Inc. | Multiple containers assigned to an application |
US20150095849A1 (en) * | 2013-09-30 | 2015-04-02 | Microsoft Corporation | Dialogs positioned with action visualization |
US9875116B2 (en) | 2013-11-26 | 2018-01-23 | Cellco Partnership | Sharing of a user input interface of an application session of one application between two or more applications |
-
2014
- 2014-04-01 US US14/231,912 patent/US20150095849A1/en not_active Abandoned
- 2014-04-01 US US14/231,891 patent/US9483549B2/en active Active
- 2014-04-01 US US14/231,917 patent/US20150095846A1/en not_active Abandoned
- 2014-04-01 US US14/231,897 patent/US9805114B2/en active Active
- 2014-04-01 US US14/231,869 patent/US9754018B2/en active Active
- 2014-04-01 US US14/231,862 patent/US9792354B2/en active Active
- 2014-04-01 US US14/231,880 patent/US20150095365A1/en not_active Abandoned
- 2014-04-01 US US14/231,873 patent/US20150095812A1/en not_active Abandoned
- 2014-04-01 US US14/231,905 patent/US9727636B2/en active Active
- 2014-04-01 US US14/231,883 patent/US9672276B2/en active Active
- 2014-04-01 US US14/231,846 patent/US20150095842A1/en not_active Abandoned
- 2014-08-28 TW TW103129730A patent/TW201528106A/en unknown
- 2014-09-24 TW TW103133046A patent/TW201528108A/en unknown
- 2014-09-24 TW TW103133045A patent/TW201516834A/en unknown
- 2014-09-25 EP EP14783734.8A patent/EP3053028B1/en active Active
- 2014-09-25 WO PCT/US2014/057322 patent/WO2015048204A1/en active Application Filing
- 2014-09-25 EP EP14825480.8A patent/EP3053031A1/en not_active Ceased
- 2014-09-25 KR KR1020167008327A patent/KR102186865B1/en active IP Right Grant
- 2014-09-25 CN CN201480053811.6A patent/CN105683907B/en active Active
- 2014-09-25 CN CN201480054151.3A patent/CN105683909B/en active Active
- 2014-09-25 WO PCT/US2014/057324 patent/WO2015048206A1/en active Application Filing
- 2014-09-25 TW TW103133249A patent/TW201528103A/en unknown
- 2014-09-25 WO PCT/US2014/057323 patent/WO2015048205A1/en active Application Filing
- 2014-09-25 EP EP14783733.0A patent/EP3053027A1/en not_active Ceased
- 2014-09-25 CN CN201480054050.6A patent/CN105593813B/en active Active
- 2014-09-25 WO PCT/US2014/057321 patent/WO2015048203A1/en active Application Filing
- 2014-09-29 EP EP14786398.9A patent/EP3053030A1/en not_active Withdrawn
- 2014-09-29 CN CN201480054049.3A patent/CN105593812A/en active Pending
- 2014-09-29 AU AU2014324620A patent/AU2014324620A1/en not_active Abandoned
- 2014-09-29 WO PCT/US2014/057940 patent/WO2015048602A1/en active Application Filing
- 2014-09-29 MX MX2016003946A patent/MX2016003946A/en unknown
- 2014-09-29 KR KR1020167008352A patent/KR20160063340A/en not_active Application Discontinuation
- 2014-09-29 EP EP14783748.8A patent/EP3053029A1/en not_active Ceased
- 2014-09-29 WO PCT/US2014/057938 patent/WO2015048600A1/en active Application Filing
- 2014-09-29 WO PCT/US2014/057939 patent/WO2015048601A1/en active Application Filing
- 2014-09-29 SG SG10201802632SA patent/SG10201802632SA/en unknown
- 2014-09-29 RU RU2016111604A patent/RU2679540C2/en not_active IP Right Cessation
- 2014-09-29 SG SG11201601888UA patent/SG11201601888UA/en unknown
- 2014-09-29 JP JP2016518686A patent/JP6465870B2/en not_active Expired - Fee Related
- 2014-09-29 RU RU2016111610A patent/RU2686822C2/en not_active IP Right Cessation
- 2014-09-29 MX MX2016004113A patent/MX2016004113A/en unknown
- 2014-09-29 JP JP2016518687A patent/JP6446038B2/en not_active Expired - Fee Related
- 2014-09-29 CA CA2922725A patent/CA2922725A1/en not_active Abandoned
- 2014-09-29 CA CA2922985A patent/CA2922985A1/en not_active Abandoned
- 2014-09-29 AU AU2014324618A patent/AU2014324618A1/en not_active Abandoned
- 2014-09-29 EP EP14790838.8A patent/EP3053017A1/en not_active Withdrawn
- 2014-09-29 CN CN201480053988.6A patent/CN105683908B/en not_active Expired - Fee Related
- 2014-09-29 CN CN201480053821.XA patent/CN105659199A/en active Pending
- 2014-09-29 KR KR1020167008368A patent/KR20160064115A/en not_active Application Discontinuation
- 2014-09-29 BR BR112016004551A patent/BR112016004551A8/en not_active Application Discontinuation
-
2016
- 2016-02-05 PH PH12016500256A patent/PH12016500256A1/en unknown
- 2016-03-01 IL IL244368A patent/IL244368A0/en unknown
- 2016-03-30 CL CL2016000729A patent/CL2016000729A1/en unknown
- 2016-09-14 HK HK16110904.6A patent/HK1222731A1/en unknown
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20050131889A1 (en) * | 2003-12-11 | 2005-06-16 | International Business Machines Corporation | Intelligent data query builder |
US20060053096A1 (en) * | 2004-09-08 | 2006-03-09 | Oracle International Corporation | Natural language query construction using purpose-driven template |
Non-Patent Citations (2)
Title |
---|
ANONYMOUS: "ACC97: How to Modify Query Properties in Microsoft Access", 31 January 2007 (2007-01-31), XP055161793, Retrieved from the Internet <URL:http://support.microsoft.com/kb/304451> [retrieved on 20150113] * |
MICHAEL BRYDON: "Access Tutorial 10: Parameter Queries", 24 August 1997 (1997-08-24), XP055161767, Retrieved from the Internet <URL:http://fisher.osu.edu/~muhanna.1/837/MSAccess/tutorials/param.pdf> [retrieved on 20150113] * |
Also Published As
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20150095365A1 (en) | Query building using schema | |
EP3435257B1 (en) | Metadata-based general request translator for distributed computer systems | |
US7802230B1 (en) | Heterogeneous software integration systems and methods | |
Maróti et al. | Next generation (meta) modeling: web-and cloud-based collaborative tool infrastructure. | |
US9122770B2 (en) | System and method for creating, managing, and reusing schema type definitions in services oriented architecture services, grouped in the form of libraries | |
US8180750B2 (en) | Support model integration system and method | |
US9959263B2 (en) | User interface form field expansion | |
US9275121B2 (en) | Interoperable shared query based on heterogeneous data sources | |
US9747353B2 (en) | Database content publisher | |
US20020123984A1 (en) | Dynamic query of server applications | |
US20060075382A1 (en) | Developing applications using configurable patterns | |
US20110088011A1 (en) | Automated Enterprise Software Development | |
US20060074967A1 (en) | Visual query modeling for configurable patterns | |
US10248386B2 (en) | Generating a software complex using superordinate design input | |
EP2676193A2 (en) | Automatically creating business applications from description of business processes | |
US20110202534A1 (en) | Storage Model for Information Related to Decision Making Process | |
EP3486798A1 (en) | Reporting and data governance management | |
US20160191431A1 (en) | Streamlining end-to-end flow of business-to-business integration processes | |
EP2203813A2 (en) | Declarative model interpretation | |
US10318524B2 (en) | Reporting and data governance management | |
Pialorsi | Microsoft SharePoint 2013 Developer Reference | |
US11132374B2 (en) | Property painter | |
Ed-Douibi et al. | Model-driven development of OData services: An application to relational databases | |
US20130031116A1 (en) | Modeled business object data import | |
US10922275B2 (en) | Universe automatic generation of business layer fragments |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
121 | Ep: the epo has been informed by wipo that ep was designated in this application |
Ref document number: 14783732 Country of ref document: EP Kind code of ref document: A1 |
|
DPE2 | Request for preliminary examination filed before expiration of 19th month from priority date (pct application filed from 20040101) | ||
NENP | Non-entry into the national phase |
Ref country code: DE |
|
122 | Ep: pct application non-entry in european phase |
Ref document number: 14783732 Country of ref document: EP Kind code of ref document: A1 |