Patents Assigned to Hasso-Plattner-Institut Fur Softwaresystemtechnik GmbH
-
Patent number: 10528532Abstract: A computer implemented method for integrating data into a target database may include: providing a plurality of source databases which each may include a relational schema and data for integration into the target database; generating at least one complexity model based on the relational schema and data of each source database, each complexity model indicating at least one inconsistency between two or more of the data sources which may be require to be resolved to integrate the data from the data sources into the target database; and generating an effort model that may include an effort value for each inconsistency indicated by each complexity model, each effort value indicating at least one of a time period and a financial cost to resolve the inconsistency to integrate data from the data sources into the target database.Type: GrantFiled: June 30, 2014Date of Patent: January 7, 2020Assignees: Qatar Foundation, Hasso-Plattner-Institut Für Softwaresystemtechnik GmbHInventors: Paolo Papotti, Felix Naumann, Sebastian Kruse, El Kindi Rezig
-
Patent number: 10089142Abstract: The present invention provides methods and system, including computer program products, implementing and using techniques for providing tasks of different classes with access to CPU time provided by worker threads of a database system. In particular, the invention relates to such a database-system-implemented method comprising the following steps: inserting the tasks to a queue of the database system; and executing the tasks inserted to the queue by worker threads of the database system according to their order in the queue; characterized in that the queue is a priority queue; and in that the method further comprises the following steps: assigning each class to a respective priority; and in that the step of inserting the tasks to the queue includes: associating each task with the respective priority assigned to its class.Type: GrantFiled: August 20, 2014Date of Patent: October 2, 2018Assignee: Hasso-Plattner-Institut Fur Softwaresystemtechnik GmbHInventors: Hasso Plattner, Martin Grund, Johannes Wust
-
Patent number: 9740741Abstract: The invention relates to a computer system for both online transaction processing and online analytical processing, comprising: a processor coupled to a database, the database comprising the database comprising: a main store (116) for storing records, a differential buffer (114) for receiving and buffering added or deleted or modified records, the differential buffer being coupled to the main store, a schema comprising records stored in the main store and records stored in the differential buffer, and a cache store (112) for caching a result of a query against the schema; and a cache controller (106) executable by the processor and communicatively coupled to the database, the cache controller being configured for: storing the result of the query in the cache store; receiving an analytical request; and determining, in response to the received request, an up-to-date result of the query by (216): accessing the cache store to obtain the cached result; determining the records of the schema that have been added orType: GrantFiled: February 10, 2014Date of Patent: August 22, 2017Assignee: Hasso-Plattner-Institut Fur Softwaresystemtechnik GmbHInventors: Hasso Plattner, Stephan Mueller, Jens Krueger, Juergen Mueller, Christian Schwarz
-
Patent number: 9626421Abstract: A system includes a relational database management system component and a column-oriented data processing component. The relational database system component stores database information in a row format. The column oriented data processing component stores the database information in a column format. In response to a database update request, the relational database management system component updates the database information stored in the row format; the relational database management system component notifies the column-oriented data processing component of the database update request; and the column-oriented data processing component updates the database information stored in said column format. In response to a query request, the column-oriented data processing component generates a query response based on the database information stored in said column format. In this manner, the system is able to generate up-to-date reports without the need for extraction, translation and loading procedures.Type: GrantFiled: September 19, 2008Date of Patent: April 18, 2017Assignee: Hasso-Plattner-Institut Fur Softwaresystemtechnik GmbHInventors: Hasso Plattner, Anja Bog, Jan Schaffner, Jens Krueger, Alexander Zeier
-
Patent number: 9542424Abstract: The invention relates to a computer-implemented method for dynamically and horizontally partitioning a table of a relational database, wherein the table comprises records, wherein the records are mapped to a plurality of states, wherein the table is horizontally partitioned into a plurality of partitions, and wherein the plurality of states is mapped to the plurality of partitions. The method comprises the steps of changing the assignment of a first record from a first state to a second state, wherein the first state is mapped to a first partition, wherein the second state is mapped to a second partition, wherein the first partition is not the second partition, and storing the first record in the second partition. The invention further relates to a computer system implementing the abovementioned method for dynamically and horizontally partitioning a table of a relational database.Type: GrantFiled: June 30, 2010Date of Patent: January 10, 2017Assignee: Hasso-Plattner-Institut Fur Softwaresystemtechnik GmbHInventors: Hasso Plattner, Martin Grund, Jens Krueger, Alexander Zeier
-
Patent number: 9542445Abstract: The invention relates to a computer system and a corresponding method and a corresponding computer-readable medium. The computer system is suitable for determining the result of a join. Based on the access pattern of an application, the computer system infers that a particular subjoin is empty. The computer system then excludes the inferred-empty subjoin when performing the join, performing a more efficient and faster database join operation.Type: GrantFiled: May 30, 2014Date of Patent: January 10, 2017Assignee: Hasso-Plattner-Institut Fur Softwaresystemtechnik GmbHInventors: Hasso Plattner, Stephan Mueller, Jens Krueger, Juergen Mueller, Anisoara Nica
-
Patent number: 9424332Abstract: A system and method of determining an earliest delivery date for a demand on the basis of a fact table stored in a database, where the demand indicates both a desired date and a desired quantity for items from a stock, where a fact time series is comprised by and/or deducible from the fact table, and where the fact time series comprises fact tuples indicating both a fact date and a change in quantity of stock items that occurred on this fact date. The method includes generating an aggregated time series from the fact time series by defining and/or obtaining discrete time intervals, and generating, for at least one discrete time interval, an aggregated tuple indicating both its corresponding discrete time interval and the aggregated change in quantity of stock items that occurred in its corresponding discrete time interval.Type: GrantFiled: November 8, 2013Date of Patent: August 23, 2016Assignee: HASSO-PLATTNER-INSTITUT FUR SOFTWARESYSTEMTECHNIK GMBHInventors: Hasso Plattner, Alexander Zeier, Christian Tinnefeld, Stephan Heinz Mueller, Sebastian Hillig
-
Patent number: 9424282Abstract: A system and method that dynamically adapts to workload changes and adopts the best possible physical layout on the fly—while allowing simultaneous updates to the table. A process continuously and incrementally computes the optimal physical layout based on workload changes and determines whether or not switching to this new layout would be beneficial. The system can perform online reorganization of hybrid main memory databases with a negligible overheard, leading up to three orders of magnitude performance gains when determining the optimal layout of dynamic workloads and providing guarantees on the worst case performance of our system.Type: GrantFiled: March 5, 2013Date of Patent: August 23, 2016Assignee: HASSO-PLATTNER-INSTITUT FUR SOFTWARESYSTEMTECHNIK GMBHInventors: Hasso Plattner, Martin Grund, Jens Krueger
-
Patent number: 9256839Abstract: In one embodiment the present invention relates to a method for navigating within a database containing business objects. The method includes the steps of providing a preconfigured model comprising preconfigured business object types and preconfigured associations of the business object types, identifying a reference to a business object instance within a software object and determining a primary business object type corresponding to the business object instance, providing links to at least one secondary business object type associated with the primary business object type in accordance with the preconfigured business model, and retrieving from the database at least one attribute of at least one business object instance within the secondary business object type associated to the primary business object type in accordance with the preconfigured model. In this manner, a user may more easily navigate the database.Type: GrantFiled: May 7, 2010Date of Patent: February 9, 2016Assignee: HASSO-PLATTNER-INSTITUT FUR SOFTWARESYSTEMTECHNIK GMBHInventors: Hasso Plattner, Alexander Zeier, Matthias Uflacker, Cafer Tosun, Janek Schumann, Kok Thim Chew
-
Publication number: 20150120698Abstract: The invention relates to a computer system and a corresponding method and a corresponding computer-readable medium according to the invention. The computer system is suitable for determining the result of a join. The computer system may be distributed system.Type: ApplicationFiled: May 30, 2014Publication date: April 30, 2015Applicant: Hasso-Plattner-Institut für Softwaresystemtechnik GmbHInventors: Hasso Plattner, Stephan Mueller, Jens Krueger, Juergen Mueller, Anisoara Nica
-
Patent number: 9015812Abstract: The invention relates to a method for granting an inquirer querying a repository access to the repository, a communication protocol between a client and a server, and a system for controlling access of at least one inquirer to a repository. The repository typically stores event data relating to traceable products. The aspects according to teaching disclosed herein may be for example implemented as security extensions for existing repositories providing a finer granularity of access rights and means to prevent an exposure of data sets considered sensitive. The security extensions disclosed herein may be implemented to protect access to any kind of client/server application wherein the server is exposing sensitive data.Type: GrantFiled: May 22, 2013Date of Patent: April 21, 2015Assignee: Hasso-Plattner-Institut fur Softwaresystemtechnik GmbHInventors: Hasso Plattner, Matthieu-Patrick Schapranow
-
Publication number: 20140310232Abstract: The invention relates to a computer system for both online transaction processing and online analytical processing, comprising: a processor coupled to a database, the database comprising the database comprising: a main store (116) for storing records, a differential buffer (114) for receiving and buffering added or deleted or modified records, the differential buffer being coupled to the main store, a schema comprising records stored in the main store and records stored in the differential buffer, and a cache store (112) for caching a result of a query against the schema; and a cache controller (106) executable by the processor and communicatively coupled to the database, the cache controller being configured for: storing the result of the query in the cache store; receiving an analytical request; and determining, in response to the received request, an up-to-date result of the query by (216): accessing the cache store to obtain the cached result; determining the records of the schema that have been added orType: ApplicationFiled: February 10, 2014Publication date: October 16, 2014Applicant: Hasso-Plattner-Institut für Softwaresystemtechnik GmbHInventors: Hasso Plattner, Stephan Mueller, Jens Krueger, Juergen Mueller, Christian Schwarz
-
Patent number: 8832123Abstract: In general, methods and apparatus, including computer program products, implementing and using techniques for providing a discovery service in a unique identifier network are described. Said discovery service is suitable for tracking and tracing a query item represented by a unique identifier in a unique identifier network. In particular, a filter method for a containment-aware discovery service is described.Type: GrantFiled: December 28, 2011Date of Patent: September 9, 2014Assignee: Hasso-Plattner-Institut für Softwaresystemtechnik GmbHInventors: Hasso Plattner, Alexander Zeier, Mueller Juergen
-
Patent number: 8832145Abstract: In general, methods and apparatus, including computer program products, implementing and using techniques for providing a discovery service in a unique identifier network are described. Said discovery service is suitable for tracking and tracing a query item represented by a unique identifier in a unique identifier network. In particular, a search method for a containment-aware discovery service is described.Type: GrantFiled: December 28, 2011Date of Patent: September 9, 2014Assignee: Hasso-Plattner-Institut für Softwaresystemtechnik GmbHInventors: Hasso Plattner, Alexander Zeier, Mueller Juergen
-
Patent number: 8756686Abstract: In general, methods and apparatus, including computer program products, implementing and using techniques for providing a discovery service in a unique identifier network are described. Said discovery service is suitable for tracking and tracing a query item represented by a unique identifier in a unique identifier network. In particular, a communication protocol for a containment-aware discovery service is described.Type: GrantFiled: December 28, 2011Date of Patent: June 17, 2014Assignee: Hasso-Plattner-Institut für Softwaresystemtechnik GmbHInventors: Hasso Plattner, Alexander Zeier, Mueller Juergen
-
Patent number: 8601038Abstract: A system and method of determining an earliest delivery date for a demand on the basis of a fact table stored in a database, where the demand indicates both a desired date and a desired quantity for items from a stock, where a fact time series is comprised by and/or deducible from the fact table, and where the fact time series comprises fact tuples indicating both a fact date and a change in quantity of stock items that occurred on this fact date. The method includes generating an aggregated time series from the fact time series by defining and/or obtaining discrete time intervals, and generating, for at least one discrete time interval, an aggregated tuple indicating both its corresponding discrete time interval and the aggregated change in quantity of stock items that occurred in its corresponding discrete time interval.Type: GrantFiled: October 7, 2011Date of Patent: December 3, 2013Assignee: Hasso-Plattner-Institut fur Softwaresystemtechnik GmbHInventors: Hasso Plattner, Alexander Zeier, Christian Tinnefeld, Stephan Heinz Mueller, Sebastian Hillig
-
Publication number: 20130232176Abstract: A system and method that dynamically adapts to workload changes and adopts the best possible physical layout on the fly—while allowing simultaneous updates to the table. A process continuously and incrementally computes the optimal physical layout based on workload changes and determines whether or not switching to this new layout would be beneficial. The system can perform online reorganization of hybrid main memory databases with a negligible overheard, leading up to three orders of magnitude performance gains when determining the optimal layout of dynamic workloads and providing guarantees on the worst case performance of our system.Type: ApplicationFiled: March 5, 2013Publication date: September 5, 2013Applicant: HASSO-PLATTNER-INSTITUT FUR SOFTWARESYSTEMTECHNIK GMBHInventor: HASSO-PLATTNER-INSTITUT FUR SOFTWARESYSTEMTECHNIK GMBH
-
Publication number: 20130007024Abstract: In general, methods and apparatus, including computer program products, implementing and using techniques for providing a discovery service in a unique identifier network are described. Said discovery service is suitable for tracking and tracing a query item represented by a unique identifier in a unique identifier network. In particular, a filter method for a containment-aware discovery service is described.Type: ApplicationFiled: December 28, 2011Publication date: January 3, 2013Applicant: Hasso-Plattner-Institut fur Softwaresystemtechnik GmbHInventors: Hasso Plattner, Alexander Zeier, Mueller Juergen
-
Publication number: 20130006989Abstract: In general, methods and apparatus, including computer program products, implementing and using techniques for providing a discovery service in a unique identifier network are described. Said discovery service is suitable for tracking and tracing a query item represented by a unique identifier in a unique identifier network. In particular, a search method for a containment-aware discovery service is described.Type: ApplicationFiled: December 28, 2011Publication date: January 3, 2013Applicant: Hasso-Plattner-Institut fur Softwaresystemtechnik GmbHInventors: Hasso Plattner, Alexander Zeier, Juergen Mueller
-
Publication number: 20130007847Abstract: In general, methods and apparatus, including computer program products, implementing and using techniques for providing a discovery service in a unique identifier network are described. Said discovery service is suitable for tracking and tracing a query item represented by a unique identifier in a unique identifier network. In particular, a communication protocol for a containment-aware discovery service is described.Type: ApplicationFiled: December 28, 2011Publication date: January 3, 2013Applicant: Hasso-Plattner-Institut für Softwaresystemtechnik GmbHInventors: Hasso Plattner, Alexander Zeier, Mueller Juergen