Patents by Inventor Manoj Syamala
Manoj Syamala has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Publication number: 20170277655Abstract: A server system may include a cluster of multiple computers that are networked for high-speed data communications. Each of the computers has a remote direct memory access (RDMA) network interface to allow high-speed memory sharing between computers. A relational database engine of each computer is configured to utilize a hierarchy of memory for temporary storage of working data, including in order of decreasing access speed (a) local main memory, (b) remote memory accessed via RDMS, and (c) mass storage. The database engine uses the local main memory for working data, and additionally uses the RDMA accessible memory for working data when the local main memory becomes depleted. The server system may include a memory broker to which individual computers report their available or unused memory, and which leases shared memory to requesting computers.Type: ApplicationFiled: March 25, 2016Publication date: September 28, 2017Inventors: Sudipto Das, Feng Li, Manoj A. Syamala, Vivek R. Narasayya
-
Publication number: 20170163554Abstract: Described herein are technologies relating to computing resource allocation among multiple tenants. Each tenant may have a respective absolute reservation for rate-based computing resources, which is independent of computing resource reservations of other tenants. The multiple tenants vie for the rate-based computing resources, and tasks are scheduled based upon which tenants submit the tasks and the resource reservations of such tenants.Type: ApplicationFiled: February 16, 2017Publication date: June 8, 2017Inventors: Sudipto Das, Vivek Narasayya, Feng Li, Manoj Syamala
-
Patent number: 9602426Abstract: Described herein are technologies relating to computing resource allocation among multiple tenants. Each tenant may have a respective absolute reservation for rate-based computing resources, which is independent of computing resource reservations of other tenants. The multiple tenants vie for the rate-based computing resources, and tasks are scheduled based upon which tenants submit the tasks and the resource reservations of such tenants.Type: GrantFiled: May 6, 2014Date of Patent: March 21, 2017Assignee: Microsoft Technology Licensing, LLCInventors: Sudipto Das, Vivek Narasayya, Feng Li, Manoj Syamala
-
Publication number: 20160371307Abstract: Techniques for tenant performance isolation in a multiple-tenant database management system are described. These techniques may include providing a reservation of server resources. The server resources reservation may include a reservation of a central processing unit (CPU), a reservation of Input/Ouput throughput, and/or a reservation of buffer pool memory or working memory. The techniques may also include a metering mechanism that determines whether the resource reservation is satisfied. The metering mechanism may be independent of an actual resource allocation mechanism associated with the server resource reservation.Type: ApplicationFiled: August 31, 2016Publication date: December 22, 2016Inventors: Vivek R. Narasayya, Sudipto Das, Feng Li, Manoj A. Syamala, Hyunjung Park, Surajit Chaudhuri, Badrish Chandramouli
-
Patent number: 9477710Abstract: Techniques for tenant performance isolation in a multiple-tenant database management system are described. These techniques may include providing a reservation of server resources. The server resources reservation may include a reservation of a central processing unit (CPU), a reservation of Input/Output throughput, and/or a reservation of buffer pool memory or working memory. The techniques may also include a metering mechanism that determines whether the resource reservation is satisfied. The metering mechanism may be independent of an actual resource allocation mechanism associated with the server resource reservation.Type: GrantFiled: January 23, 2013Date of Patent: October 25, 2016Assignee: Microsoft Technology Licensing, LLCInventors: Vivek R. Narasayya, Sudipto Das, Manoj A. Syamala, Hyunjung Park, Surajit Chaudhuri, Badrish Chandramouli, Feng Li
-
Patent number: 9009124Abstract: A plurality of indicators representing a plurality of respective candidate database configurations may be obtained, each of the candidate database configurations including a plurality of database queries and a plurality of candidate database indexes associated with a database table. A portion of the candidate database indexes included in the plurality of database indexes may be selected based on skyline selection. An enumeration of the portion of the plurality of the candidate database indexes may be determined based on a greedy algorithm.Type: GrantFiled: June 17, 2011Date of Patent: April 14, 2015Assignee: Microsoft Technology Licensing, LLCInventors: Hideaki Kimura, Vivek Narasayya, Manoj Syamala
-
Publication number: 20140379924Abstract: Described herein are technologies relating to computing resource allocation among multiple tenants. Each tenant may have a respective absolute reservation for rate-based computing resources, which is independent of computing resource reservations of other tenants. The multiple tenants vie for the rate-based computing resources, and tasks are scheduled based upon which tenants submit the tasks and the resource reservations of such tenants.Type: ApplicationFiled: May 6, 2014Publication date: December 25, 2014Applicant: Microsoft CorporationInventors: Sudipto Das, Vivek Narasayya, Feng Li, Manoj Syamala
-
Patent number: 8805800Abstract: This patent application relates to granular and workload driven database index defragmentation techniques. These techniques allow for defragmenting individual index ranges, performing benefit analysis to estimate the impact of defragmenting indexes or index ranges, and leveraging such benefit analysis to provide automated workload-driven recommendations of index(es) or index range(s) to defragment.Type: GrantFiled: March 14, 2010Date of Patent: August 12, 2014Assignee: Microsoft CorporationInventors: Vivek Narasayya, Manoj Syamala
-
Publication number: 20140207740Abstract: Techniques for tenant performance isolation in a multiple-tenant database management system are described. These techniques may include providing a reservation of server resources. The server resources reservation may include a reservation of a central processing unit (CPU), a reservation of Input/Output throughput, and/or a reservation of buffer pool memory or working memory. The techniques may also include a metering mechanism that determines whether the resource reservation is satisfied. The metering mechanism may be independent of an actual resource allocation mechanism associated with the server resource reservation.Type: ApplicationFiled: January 23, 2013Publication date: July 24, 2014Applicant: MICROSOFT CORPORATIONInventors: Vivek R. Narasayya, Sudipto Das, Manoj A. Syamala, Hyunjung Park, Surajit Chaudhuri, Badrish Chandramouli, Feng Li
-
Publication number: 20130332428Abstract: The subject disclosure is directed towards defragmenting one or more ranges of a database index based upon actual usage statistics and policy. A range tracker tracks and uses statistics corresponding to actual I/O operations to determine whether the benefit of defragmenting a range sufficiently (based upon the policy) exceeds its cost. If so, the online range defragmenter automatically defragments the range in an online manner. The range tracker may be configurable to monitor less than all ranges of the index.Type: ApplicationFiled: June 11, 2012Publication date: December 12, 2013Applicant: MICROSOFT CORPORATIONInventors: Vivek Ravindranath Narasayya, Hyunjung Park, Manoj Syamala
-
Patent number: 8452754Abstract: A tool facilitating static analysis for database applications, such that the static analysis tool (SAT) can significantly enhance the ability for developers to identify security, correctness and performance problems in database applications during the development phase of an application lifecycle. A static analysis tool for database applications presents a framework for database applications using the ADO.NET data access APIs. The SAT framework consists of a core set of static analysis services upon which verticals such as workload extraction, SQL injection detection, identifying data integrity violations, and SQL performance analysis are built using the core services.Type: GrantFiled: May 8, 2009Date of Patent: May 28, 2013Assignee: Microsoft CorporationInventors: Vivek R. Narasayya, Arjun Dasgupta, Manoj A. Syamala
-
Publication number: 20120323929Abstract: A plurality of indicators representing a plurality of respective candidate database configurations may be obtained, each of the candidate database configurations including a plurality of database queries and a plurality of candidate database indexes associated with a database table. A portion of the candidate database indexes included in the plurality of database indexes may be selected based on skyline selection. An enumeration of the portion of the plurality of the candidate database indexes may be determined based on a greedy algorithm.Type: ApplicationFiled: June 17, 2011Publication date: December 20, 2012Applicant: MICROSOFT CORPORATIONInventors: Hideaki Kimura, Vivek Narasayya, Manoj Syamala
-
Publication number: 20110225164Abstract: This patent application relates to granular and workload driven database index defragmentation techniques. These techniques allow for defragmenting individual index ranges, performing benefit analyses to estimate the impact of defragmenting indexes or index ranges, and leveraging such benefit analyses to provide automated workload-driven recommendations of index(es) or index range(s) to defragment.Type: ApplicationFiled: March 14, 2010Publication date: September 15, 2011Applicant: Microsoft CorporationInventors: Vivek Narasayya, Manoj Syamala
-
Publication number: 20100287214Abstract: A tool facilitating static analysis for database applications, such that the static analysis tool (SAT) can significantly enhance the ability for developers to identify security, correctness and performance problems in database applications during the development phase of an application lifecycle. A static analysis tool for database applications presents a framework for database applications using the ADO.NET data access APIs. The SAT framework consists of a core set of static analysis services upon which verticals such as workload extraction, SQL injection detection, identifying data integrity violations, and SQL performance analysis are built using the core services.Type: ApplicationFiled: May 8, 2009Publication date: November 11, 2010Applicant: Microsoft CorporationInventors: Vivek R. Narasayya, Arjun Dasgupta, Manoj A. Syamala
-
Publication number: 20100262593Abstract: The described implementations relate to filtered index recommendations. In one case a filtered index recommendation (FIR) tool is configured to recommend a final set of filtered indexes to use with a workload. The final set is selected from a first set of candidate filtered indexes and a second set of merged filtered indexes.Type: ApplicationFiled: April 8, 2009Publication date: October 14, 2010Applicant: Microsoft CorporationInventors: Nicolas Bruno, Surajit Chaudhuri, Vivek R. Narasayya, Manoj A. Syamala
-
Publication number: 20060136358Abstract: An automated database tuning tool may include a user interface component and a tuning engine. The user interface may be a graphical component that interfaces with a user to collect configuration parameters for a tuning session for a specified database. The configuration parameters may be stored in a tuning database. A tuning engine that performs the actual tuning process may generate physical design recommendations and reports. The recommendations and reports may be stored in the tuning database, enabling the tuning tool to be run off-line or in background. Communication between components of the tuning tool may occur via stored procedures.Type: ApplicationFiled: December 21, 2004Publication date: June 22, 2006Applicant: Microsoft CorporationInventors: Dmitry Sonkin, Maciej Sarnowicz, Bruce Prang, Djana Milton, Arunprasad Marathe, Vivek Narasayya, Manoj Syamala, Sanjay Agrawal
-
Publication number: 20060085378Abstract: Internal communications within components of an automated physical database design tool may be conducted in a data description language such as XML. Inputs to and outputs from the automated physical database design tool may also be presented in the data description language (e.g., XML). The communications, inputs and outputs may comply with a schema for the data description language. The schema may be written in a schema language such as XSD. Inputs presented in the data description language may comprise tuning options. Outputs may comprise a proposed physical design for a database and reports.Type: ApplicationFiled: October 15, 2004Publication date: April 20, 2006Applicant: Microsoft CorporationInventors: Alexander Raizman, Arunprasad Marathe, Djana Ophelia Milton, Dmitry Sonkin, Lubor Kollar, Maciej Sarnowicz, Manoj Syamala, Raja Duddupudi, Sanjay Agrawal, Surajit Chaudhuri, Vivek Narasayya
-
Publication number: 20060085484Abstract: An automated physical database design tool may provide an integrated physical design recommendation for horizontal partitioning, indexes and indexed views, all three features being tuned together (in concert). Manageability requirements may be specified when optimizing for performance. User-specified configuration may enable the specification of a partial physical design without materialization of the physical design. The tuning process may be performed for a production server but may be conducted substantially on a test server. Secondary indexes may be suggested for XML columns. Tuning of a database may be invoked by any owner of a database. Usage of objects may be evaluated and a recommendation for dropping unused objects may be issued. Reports may be provided concerning the count and percentage of queries in the workload that reference a particular database, and/or the count and percentage of queries in the workload that reference a particular table or column.Type: ApplicationFiled: October 15, 2004Publication date: April 20, 2006Applicant: Microsoft CorporationInventors: Alexander Raizman, Arunprasad Marathe, Djana Milton, Dmitry Sonkin, Lubor Kollar, Maciej Sarnowicz, Manoj Syamala, Raja Duddupudi, Sanjay Agrawal, Surajit Chaudhuri, Vivek Narasayya