Sap Se

Leonardo Silva Rosa

Ioannis Kostis

Michael Te Uhle

Florian Maier

Atul Rajendra Prasad Tiwari

Neetha Jambigi

Michael Wilking

Felix Schabernack

Joshua Hammesfahr

Embodiments enforce user access rights to a data view, by initially generating a replication table of the view. The replication table may include all view data to which any user is entitled. This replication table may be generated during a first database session having a first value for a session variable. Next, a data access control structure is applied to the replication table to produce output comprising a subset of the view data for a specific user. This output may be produced during a second database session having a second value for the session variable. By initially generating the view replication table up front, processing resources are conserved in later stages when access control structures are applied to grant view access rights to particular users. Alternative embodiments may implement access control to data views, through the creation and storage of derived views.

Persisted data views supporting access control

Systems and methods include acquisition of a database system workload comprising a plurality of database queries, replay of the database system workload on each of a plurality of database systems to generate a plurality of failed events, each of the plurality of failed events associated with a plurality of attributes, assignment of a root cause to each of the plurality of failed events, and training of a classification model, based on the plurality of failed events an assigned root causes, to infer an output root cause based on an input plurality of attributes.

Using workload data to train error classification model

Growing community of inventors

Porto Alegre, Brazil

Leonardo Silva Rosa