Microsoft Technology Licensing, LLC

Tsvi M Reiter

Ajay Kalhan

Srikumar Rangarajan

Milind Madhukar Joshi

Srikanth Avadhanam

Dean Charles McCrae

Stuart Glasson

Uno Junghans

Julia Lisovaya

Jesper Boelsmand

Mogens Nielsen

Oliver Morrison

A system and method of enforcing Enterprise Resource Planning ('ERP') software object permissions in a three-tiered architecture is provided. A user connects to the three-tiered architecture via an enhanced client, which connects to a database server via a middle-tier server. The database server stores code and permission information for each database object. When a user connects to the system, the user's permissions are retrieved and stored at the middle-tier server. The user may then access data by instantiating objects at the middle-tier server by compiling and executing code retrieved from the database server. The middle-tier server performs permission checking for accessing database objects and provides environments for executing both managed and unmanaged code. The middle-tier server can perform permission checking for users and objects without accessing the database server.

Enforcement of object permissions in enterprise resource planning software

A method and system for controlling an application server in order to provide application services to clients while maintaining synchronization between records of tables of a database server. An application server retrieves records of tables and stores them locally on the application server. When a client requests some fields of a record of a table, the application server generates a bookmark that uniquely identifies the record. The bookmark may contain a table identifier and a record identifier or a query identification and an identifier of a record within the query result. The bookmark is opaque to the client and only the application server need know how to interpret its contents. When the application server provides the requested fields of the record to the client, it also provides the record bookmark to the client. When the client wants to identify the record, it uses the bookmark provided by the application server.

Synchronization of records of a table using bookmarks

A method and system for creating an index for a database table of records in a computer environment having a plurality of processing units wherein each processing unit has access to the database table. The method first determines partition delimiters wherein each partition delimiter separates the database table into non-overlapping partitions of records. Each of these partitions is dedicated to one processing unit for index creation. Next, each processing unit independently creates a sub-index, i.e., different processing units create at least two sub-indexes. Last, the method merges the sub-indexes together to create a final index related to the database table.

Method and system for creating a database table index using multiple processors

Growing community of inventors

Copenhagen, Denmark

Tsvi M Reiter