Microsoft Technology Licensing, LLC

Amazon Technologies, Inc.

Brian L Welcker

Dennis Tighe

Matthew Walters

Jason David Carlson

Gur Kimchi

George G Robertson

Bongshin Lee

Roland Lucas Fernandez

Danyel Aharon Fisher

Murali R Krishnan

Christopher Alan Hays

Jason Joseph Weber

B Scott Ruble

Christian Olaf Abeln

Lisa Renee Mueller

Stella Yick Chan

Morten Holm-Peterson

Anoop Gupta

Matthew Jay Kotler

Michael J McCormack

Benjamin Edward Rampson

Ted Cyrek

Eran Megiddo

Tanmoy Dutta

Anastasia Paushkina

Daniel C Battagin

Robert G Hawking

Johnny S Campbell

Brian Russell Glaeske

Kyle Stapley Young

Aravind Ramarathinam

Liviu Asnash

Robert Alan Meyers

Sandor Loren Maurice

Michael Victor Ehrenberg

Wayne C Higgins

Timothy Garry Dwyer

Christian Bernd Schormann

Lev Boris Nachmanson

Carolyn Khanh Chau

Jakob Peter Nielsen

Julianne Prekaski

Alexey Kuznetsov

Rajeev V Karunakaran

Michael M Santos

William Guthrie Morein

Adrian L Orth

Amit Purohit

Lawrence Douglas Webley

Kevin M Honeyman

Mario Tayah

Ira Levin

Benjamin L Chronister

Jagdeep Singh Sidhu

Yuhui Yuan

Tudor M Trufinescu

Joshua W Lee

Alexander Martynov

Barry James Givens

Aaron Stephen Meyers

Prasant Sivadasan

Ray J Ridl

Julie B Hagen

John P Burrows

Sunil Garg

Ahmed K Kamal

Ramakrishna Dwivedula

Babak Nakhayi Ashtiani

Sachin Honnudike

Serhii Poliakov

Thomas G Patton

James H Mlodgenski

Sachin Shrikrishna Panvalkar

Wing Kin Thomas Chan

Jeremy S Ellsworth

Sundaresan Krishnamurthy

Qian Jiang

Parijatham Santosh Kumar Vodela

Chris R Garty

Claudia Betz-Haubold

Rupa Mantravadi

Mikkel Ronne Jakobsen

Olga Kulyk

Kipper V Jewsbury

Techniques for query execution against relational databases using connection pooling are described. According to some embodiments, a query processing service is disclosed that enables users to execute queries against target relational databases implemented by a relational database service. The service receives query requests originated by a client application at a web service endpoint and identifies a connection to a particular target database. In some examples, the query request is a Hyper Text Transfer Protocol (HTTP) message comprising a query to be executed by a target database instance within the provider network. The service transmits the query for execution at the target database via the connection and obtains a query result based on the execution of the query. The service transforms the query result into a format suitable for the client and transmits a query response to the client.

SQL execution over HTTP for relational databases using connection pooling

A proxy server acts as an intermediary between a database client and a database server. The proxy server is configured with a set of user-defined rules. When a request is received from the database client, the proxy server may apply rules that modify, route, reject, log, or pass the request to the database server. Individual rules may be based on attributes of the client computer system, database server, or the request itself. In one embodiment, a rule may be used to translate a request from a format provided by the client into a format preferred by a destination database. In one embodiment, a rule may route a particular request to one of a number of databases based on the nature of the request.

Database proxy

A database proxy server provides a web service interface such as a representational state transfer ('REST') interface to a relational database. The proxy server maps a request submitted via the web service interface to a database interface. In some examples, the web service interface is a stateless REST interface that maps particular SQL statements or subroutines to a request submitted via a particular URL. A web client is able to pass parameters with a request using either URL encoding (the GET method) or within the body of the request (the POST method). The proxy server generates one or more database commands that correspond to the request. The database commands are submitted to the relational database, and the relational database performs the database commands to fulfil the request.

Database rest API

A proxy server acts as an intermediary between a database client and a database server. The proxy server establishes and maintains a set of logical connections to the database server. The proxy server receives a request from the database client, and generates a set of database commands that, when performed by the database server, are capable of fulfilling the request. The proxy server selects a particular logical connection from the set of logical connections based at least in part on a characteristic of the request, and submits the set of database commands to the database server via the selected particular logical connection. In various examples, the particular logical connection is selected so that various performance, efficiency, and security objectives are achieved.

Database proxy connection management

A proxy server receives requests from a client computer system and generates corresponding sets of database commands that are capable of fulfilling the requests when submitted to a database server. The proxy server may repeat processing associated with a particular request more than once under different operational conditions in order to improve future performance. In some examples, the proxy server submits a particular database command sequence to the database server using various operational parameters, and measures the performance of each submission to identify a particular set of operational parameters to be applied to the database server with future submissions. In another example, the proxy server determines a number of alternative command sequences that fulfill a particular request, and measures the performance of each of the alternative command sequences to determine how command sequences are generated for future requests.

Database command replay

A system (and corresponding methodology) by which a user can interact directly with visual data is provided. The system employs associations and relationships between visual data objects to automatically update objects based upon a change in other objects. The innovation also provides specialized controls (e.g., dashboard tools/controls) that facilitate manipulation of visual data. As there can be numerous manners in which a user can interact with visualization data, the innovation enables a specialized set of controls to be identified and provided to a user thereby reducing overwhelming effects of a large number of controls.

Dashboard controls to manipulate visual data

A computer system displays a user interface display with a user input mechanism that can be actuated in order to identify a set of resources, and corresponding capacities. A team configuration is stored in memory and reflects the configuration of the resources and corresponding capacities that were identified. A task dependency structure is obtained, and is indicative of an underlying project. Resources from the stored team configuration, and corresponding capacities, are assigned to the tasks in the task dependency structure and the team configuration is updated, in memory, to reflect the assignments. A display is generated that shows the state of the underlying memory, and that is indicative of a remaining capacity and a consumed capacity.

Controlling resource allocation with automated consumption against a work breakdown structure

A workspace display includes a plurality of different groups, each group including a plurality of different components. Each group corresponds to a task, set of tasks or topic of information related to a user's role. The particular components included in each group are user interface display elements that are each related to an item of content within the corresponding group. The workspace display has filter mechanisms that are actuated to filter the content displayed in the components on the workspace display.

Filtering content on a role tailored workspace

Various types of data can be collected into a data set and related content and/or related concepts across the data in the data set and/or across search histories can be displayed as a visual representation. The related content/concepts can be presented as a function of incremental revealing of relationships. After reviewing the visual representation, a user can customize the data set and relationships by specifically excluding a related data segment. The visual representation can be applied across multiple searches or other obtained data. Through interaction with the visual representation, a user can drill down into common linkages of the data to more narrowly focus on a subset of the data and/or to refocus a search result and/or to provide annotations.

Using visual techniques to manipulate data

A processing device may include a WYSIWYG tool for designing two-dimensional visual layouts. The processing device may display a visual layout including a first object component and a second object component. The first object component, or an object subcomponent thereof, may be moved or resized, or an object subcomponent of the second object component may be moved or resized. When an edge of the first object component or an edge of the object subcomponent, thereof, is within a snapping distance of an edge of the object subcomponent of the second object component, the processing device may attempt to align the edges and may display an indicator indicating alignment of the edges. The first object component or the object subcomponent, thereof, may be drawn to an aligned position with the object subcomponent of the second object component while the aligned edges are within the snapping distance.

Automatic alignment with subcomponents on a visual layout

Indexing and storage of context of a plurality of interactive points within an interactive document is provided. The context of the interactive points within the document is stored in a server such that it can be located by the server via the index. Furthermore, information may be received at the server identifying context data for an interactive point stored in the server upon a user activating the interactive point within the document. The server may then transmit to a client the context data stored by the server identified by the information received.

Interactive document information storage and delivery

A graphical user interface and method of use thereof that allows users to interact with an entity relationship model. The user interface includes zones that allow users to navigate among the entities, roles and fields to create queries that are run against the model. Clicking on an entity in the shows the available fields for the entity. Users can drag and drop entities and fields onto a design surface to quickly and easily build queries. Rules are applied when either an entity or a field is dropped onto the design surface based upon the item being dropped (either an entity or a field), the position of the drop and also the properties that are associated with the item. Entities may be grouped and filtered to sort and limit the results of the query. After query is run, the results may be displayed in a separate area to the user.

User interface mechanism to formulate complex query against an entity relationship model

User values and selections are collected and provided to a report server that customizes a generically defined report pursuant to the user values and selections. An ordered set of report parameters is declared in the definition of a report and then this parameter definition is used to drive user prompting and execution of the report. As parameter values are collected in sequence order, a value retrieved or specified by the user for one parameter may be used to generate the set of the allowed values or default value of a parameter later in the sequence. Parameters are dynamically presented to the user. After values for all parameters been retrieved or specified, a report is generated by the report server.

Declarative sequenced report parameterization

Systems and methods for supporting custom report layouts allow features that may be available to supported report layouts to also be made available to custom layouts. A custom layout definition may first meet a set of report definition criteria so that it is recognizable to report processing software. A design tool is provided that may be used to create such a custom layout definition. The custom layout may then be passed to report processing software. The report processing software can initially process the custom layout, and provide it with any features available in the initial processing stage. The reporting software may provide an interface for custom processing of the custom layout. The interface may be accessible to custom layout builder objects. Custom layout builder objects can be designed to use the report building components provided through the interface to build a custom report layout.

Systems and methods for supporting custom graphical representations in reporting software

A method, system, and apparatus for discovering and connecting to data sources are provided. A system is provided that includes a server computer operative to maintain a centrally managed repository of data connection definitions. A client computer is also provided including an application program capable of consuming data from a data source. When a request is received by the application to connect to a data source, a list of available sources is retrieved from the server computer. If one of the data sources in the list is selected, a data connection file is retrieved and utilized to connect to the data source. If a report is opened by the application that includes a reference to a data source, the repository is utilized to confirm the connection to the data source.

Method, system, and apparatus for discovering and connecting to data sources

Growing community of inventors

Redmond, WA, United States of America

Brian L Welcker