公开(公告)号：US20140006344A1

公开(公告)日：2014-01-02

申请号：US14014302

申请日：2013-08-29

Applicant: Oracle International Corporation

Inventor： JANAKI NARASINGHANALLUR ,  MIN-HANK HO ,  ERIC SEDLAR ,  THOMAS KEEFE ,  CHON HEI LEI ,  VIKRAM PESATI

IPC: G06F17/30

CPC classification number: G06F17/30289 ,  G06F17/3056

Abstract: A method and apparatus are described for sharing a session to access a database. A database server receives, in a session, a session context identifier and a command. The session context identifier identifies a session context to use for the session. The session context is a set of information or commands that plug into a session state and specify how commands in the session are to be performed for a particular user or privilege level. In response to receiving the identifier, the database server associates the session context with the database session for the connection. The database server uses the session context to process the command. The session context may then be detached from the session, allowing another user to attach to the session via another session context.

Abstract translation: 描述了一种用于共享会话以访问数据库的方法和装置。 数据库服务器在会话中接收会话上下文标识符和命令。 会话上下文标识符标识用于会话的会话上下文。 会话上下文是一组插入会话状态的信息或命令，并指定如何为特定用户或特权级别执行会话中的命令。 响应于接收到标识符，数据库服务器将会话上下文与连接的数据库会话相关联。 数据库服务器使用会话上下文来处理命令。 然后会话上下文可以从会话分离，允许另一用户经由另一会话上下文附加到会话。

公开(公告)号：US20190065552A1

公开(公告)日：2019-02-28

申请号：US16117367

申请日：2018-08-30

Applicant: Oracle International Corporation

Inventor： MATTHIAS BRANTNER ,  LAURENT DAYNES ,  PIT FENDER ,  BENJAMIN SCHLEGEL ,  ANANTHA KIRAN KANDUKURI ,  HASSAN CHAFI ,  ERIC SEDLAR ,  JUERGEN CHRIST ,  LUCAS BRAUN ,  BASTIAN HOSSBACH ,  ALEXANDER ULRICH ,  HARSHAD KASTURE

IPC: G06F17/30

Abstract: Herein are computerized techniques for deploying JavaScript and TypeScript stored procedures and user-defined functions into a database management system (DBMS). In an embodiment, a computer generates a SQL call specification for each subroutine of one or more subroutines encoded in a scripting language. The generating is based on a signature declaration of the subroutine. Each subroutine comprises a definition of a stored procedure or a user-defined function. The computer packages the definition and the SQL call specification of each subroutine into a single bundle file. The definition and the SQL call specification of each subroutine are deployed into a DBMS from the single bundle file. Eventually, the SQL call specification of at least one subroutine is invoked to execute the definition of the subroutine in the DBMS.

公开(公告)号：US20150186543A1

公开(公告)日：2015-07-02

申请号：US14608029

申请日：2015-01-28

Applicant: Oracle International Corporation

Inventor： SAM IDICULA ,  NIPUN AGARWAL ,  RAVI MURTHY ,  ERIC SEDLAR

IPC: G06F17/30 ,  G06F12/02 ,  G06F12/08

CPC classification number: G06F17/30893 ,  G06F12/0246 ,  G06F12/0817 ,  G06F12/0833 ,  G06F17/30091 ,  G06F17/30595 ,  G06F2212/62 ,  G06F2212/622 ,  G06F2212/7204

Abstract: A method and apparatus for processing path-based database operations is provided. According to one aspect, a path cache is maintained. For each hierarchical node that is traversed during a path-determining operation, it is determined whether a cache entry corresponding to that node is already contained in the path cache. If such a cache entry is already contained in the path cache, then the path indicated in that cache entry is used to complete the pathname for the node for which the operation is being performed. As a result, hierarchically higher nodes do not need to be traversed to complete the operation. Alternatively, if such a cache entry is not already contained in the path cache, then a cache entry for the node currently being traversed is generated and inserted into the path cache for use in subsequent path-determining operations.

Abstract translation: 提供了一种用于处理基于路径的数据库操作的方法和装置。 根据一个方面，维护路径高速缓存。 对于在路径确定操作期间遍历的每个分级节点，确定与该节点相对应的高速缓存条目是否已经包含在路径高速缓存中。 如果这样的缓存条目已经包含在路径缓存中，则使用该缓存条目中指示的路径来完成正在执行该操作的节点的路径名。 因此，不需要遍历层次更高的节点来完成操作。 或者，如果这样的高速缓存条目尚未包含在路径高速缓存中，则生成用于当前正在遍历的节点的高速缓存条目并将其插入到路径高速缓存中以用于随后的路径确定操作。