Abstract: Implementations of the present disclosure include receiving, by a query processing server, a first query, the first query including a syntax indicating that precision loss is allowed, processing, by the query processing server, the first query to provide a first QEP, optimization of which would result in precision loss in a generated query result, determining that the syntax is provided, and in response, optimizing the first QEP to provide an optimized QEP, executing the optimized QEP to generate a query result that includes data stored within a database system, the query result having reduced accuracy relative to a query result that would be generated based on the first QEP, and providing the query result as output from the database system.
Type:
Grant
Filed:
April 1, 2019
Date of Patent:
June 14, 2022
Assignee:
SAP SE
Inventors:
Johannes Merx, Taehyung Lee, Sung Heun Wi, Jin Uk Bae, Ki Hong Kim, Stefan Baeuerle, Florian Scheid
Abstract: A replicated service comprises N replicas deployed on compute nodes of a computer network, wherein the replicas are each configured to vote on a proposed transaction output by a leader of the replicas and certify the proposed transaction upon receiving qr*N first votes, where qr is a fractional value between 0 and 1 that represents a quorum required for certification. A method of approving a transaction in the replicated service includes receiving certifications from the replicas, and transmitting an approval of the transaction to the replicas for recording: (i) upon determining that at least qc*N certifications have been received, where qc is a fractional value between 0 and 1 that represents a quorum required for transaction approval and qc>qr, or (ii) upon determining that at least qr*N certifications have been received at the end of the time period equal to 2*?, where ? represents a network delay.
Abstract: A replicated service comprises N replicas deployed on compute nodes of a computer network, wherein the N replicas are each configured to vote on a proposed transaction output by a leader of the N replicas and certify the proposed transaction upon receiving qr*N first votes, where qr is a fractional value between 0 and 1 that represents a quorum required for certification. A method of approving a transaction in the replicated service includes receiving certifications from the N replicas, determining whether or not the certifications are received from at least qr*N replicas during a time period equal to 2*?, where ? represents a network delay between two compute nodes of the computer network, and transmitting an approval of the transaction to the replicas for recording by the replicas upon determining that at least qr*N certifications have been received at the end of the time period equal to 2*?.
Abstract: A method for accurately searching within a website is disclosed, which comprising: a search box obtaining a search term inputted and sending the search term to a dynamic matching unit; the dynamic matching unit performing query matching in different libraries according to a preset query rule to obtain search results, search results containing a plurality of merchandise information; ranking the search results according to a preset ranking rule, and displaying them in a pull-down list; each of the search results containing a merchandise name and a function button; and clicking the function button for jumping to a preset function page displaying the corresponding function information. In such a way, ranking of the search results is more reasonable and requirements. Meanwhile, the user can quickly perform such operations as search, read, download, and purchase, so as to reduce operation steps and improve user experience.