公开(公告)号：US20090100029A1

公开(公告)日：2009-04-16

申请号：US11873407

申请日：2007-10-16

申请人： Namit Jain ,  Anand Srinivasan ,  Shailendra Kumar Mishra

发明人： Namit Jain ,  Anand Srinivasan ,  Shailendra Kumar Mishra

IPC分类号： G06F7/00 ,  G06F15/16

CPC分类号： G06F17/30548

摘要： A new continuous query to a data stream management system (DSMS) may use a silent relation whose source does not provide any heartbeats. During execution of any given operator, the DSMS processes data from one input (“active input”) using its time stamp as if the same time stamp is received from another input whose relation has fallen silent (“empty input”), if one or more predetermined conditions are met. One predetermined condition is that the empty input's operator has all its own inputs silent. And another predetermined condition is that a maximum time stamp that is currently present among all the inputs of the empty input's operator is equal to a time stamp that was last received from these same inputs. When both conditions are met, previously received data from the empty input is time stamped with the same time stamp as the most recently received data from the active input.

摘要翻译： 对数据流管理系统（DSMS）的新的连续查询可以使用其源不提供任何心跳的无声关系。 在执行任何给定的操作者期间，DSMS使用其时间戳来处理来自一个输入（“活动输入”）的数据，就好像从另一个输入中接收到相同时间标记的关系已经下沉（“空输入”），如果一个或 更符合规定的条件。 一个预定的条件是空输入的运算符具有所有自己的输入静音。 并且另一个预定条件是当前存在于空输入运算符的所有输入中的最大时间戳等于从这些相同输入最后接收的时间戳。 当满足这两个条件时，来自空输入的先前接收到的数据与来自活动输入的最近接收的数据具有相同的时间标记的时间戳。

公开(公告)号：US07409397B2

公开(公告)日：2008-08-05

申请号：US11172674

申请日：2005-06-30

申请人： Namit Jain ,  Syam Pannala ,  Sam Idicula ,  Nipun Agarwal ,  Eric Sedlar ,  Vikram Kapoor

发明人： Namit Jain ,  Syam Pannala ,  Sam Idicula ,  Nipun Agarwal ,  Eric Sedlar ,  Vikram Kapoor

IPC分类号： G06F17/30

CPC分类号： G06F17/30171 ,  G06F17/30233 ,  Y10S707/99931 ,  Y10S707/99942 ,  Y10S707/99943

摘要： A method and apparatus for performing network file system (NFS) operations across a plurality of servers is provided. At a first server, a filehandle for a particular file is generated based, at least in part, on an identifier that uniquely identifies the particular file relative to all other files within a file system repository. The file system repository may be implemented in a database. The identifier may also be stored in the database. The first server sends a client the filehandle. The client may thereafter send another request for the performance of a file operation, containing the filehandle, to a different server. The second server may read the filehandle and use the identifier to locate the file within the repository against which to perform the file operation without receiving, from the first server, information that associates the filehandle with the file.

摘要翻译： 提供了一种用于在多个服务器上执行网络文件系统（NFS）操作的方法和装置。 在第一服务器上，至少部分地基于唯一地标识特定文件相对于文件系统存储库内的所有其他文件的标识符生成特定文件的文件句柄。 文件系统存储库可以在数据库中实现。 标识符也可以存储在数据库中。 第一台服务器向客户端发送文件句柄。 然后，客户端可以向包含文件句柄的文件操作执行另一请求，到不同的服务器。 第二服务器可以读取文件句柄并且使用标识符来定位要在其中执行文件操作的存储库内的文件，而不从第一服务器接收将文件句柄与该文件相关联的信息。

公开(公告)号：US20070150432A1

公开(公告)日：2007-06-28

申请号：US11317101

申请日：2005-12-22

申请人： Sivasankaran Chandrasekar ,  Nipun Agarwal ,  Namit Jain ,  Ravi Murthy

发明人： Sivasankaran Chandrasekar ,  Nipun Agarwal ,  Namit Jain ,  Ravi Murthy

IPC分类号： G06F17/30

CPC分类号： G06F17/2247 ,  G06F17/30908

摘要： A method and apparatus for loading an XML document into memory is provided. A client loads one or more array elements into a first partition of an array that is maintained in memory. Each array element represents an XML element of an XML document. Upon determining that an amount of data maintained in the first partition exceeds a first threshold, the client subsequently loads array elements into a new partition of the array. Upon determining that an amount of data maintained in the memory of the client exceeds a second threshold, the array elements of the least recently used partition are persistently stored in a database without persistently storing the entire XML document. When the last XML element of the XML document is loaded into a partition of the array, that partition is persistently stored in the database, thereby causing the entire XML document to be stored in the database.

摘要翻译： 提供了一种将XML文档加载到存储器中的方法和装置。 客户端将一个或多个数组元素加载到内存中维护的数组的第一个分区中。 每个数组元素表示XML文档的XML元素。 在确定在第一分区中维护的数据量超过第一阈值时，客户端随后将数组元素加载到阵列的新分区中。 在确定在客户端的存储器中维护的数据量超过第二阈值时，最近最少使用的分区的数组元素被持久地存储在数据库中，而不会持续存储整个XML文档。 当XML文档的最后一个XML元素加载到数组的分区中时，该分区将永久存储在数据库中，从而使整个XML文档存储在数据库中。

公开(公告)号：US20070130157A1

公开(公告)日：2007-06-07

申请号：US11294894

申请日：2005-12-05

申请人： Namit Jain ,  Nipun Agarwal ,  Ravi Murthy ,  Syam Pannala ,  Vikram Kapoor ,  Eric Sedlar

发明人： Namit Jain ,  Nipun Agarwal ,  Ravi Murthy ,  Syam Pannala ,  Vikram Kapoor ,  Eric Sedlar

IPC分类号： G06F17/30

CPC分类号： G06F17/30504 ,  G06F17/30115 ,  Y10S707/99931 ,  Y10S707/99943

摘要： A method and apparatus for performing file system operations involving a link is provided. A request to perform a file system operation involving a link is received from a client at a database server. The link may establish a relationship a source resource has to a target resource. The source resource and the target resource may be stored within a repository implemented by a storage medium, such as a database. The database server may perform the file system operation by storing, in the database, one or more link records that identifies the link between the first resource and the second resource. File system operations, such as a NFS file system operation, which involve links may be performed at a database management system.

摘要翻译： 提供一种用于执行涉及链接的文件系统操作的方法和装置。 从数据库服务器的客户端接收到执行涉及链接的文件系统操作的请求。 该链接可以建立源资源与目标资源的关系。 源资源和目标资源可以存储在由诸如数据库的存储介质实现的存储库中。 数据库服务器可以通过在数据库中存储标识第一资源和第二资源之间的链接的一个或多个链接记录来执行文件系统操作。 可以在数据库管理系统中执行涉及链接的诸如NFS文件系统操作的文件系统操作。

公开(公告)号：US20070005604A1

公开(公告)日：2007-01-04

申请号：US11172674

申请日：2005-06-30

申请人： Namit Jain ,  Syam Pannala ,  Sam Idicula ,  Nipun Agarwal ,  Eric Sedlar ,  Vikram Kapoor

发明人： Namit Jain ,  Syam Pannala ,  Sam Idicula ,  Nipun Agarwal ,  Eric Sedlar ,  Vikram Kapoor

IPC分类号： G06F17/30

CPC分类号： G06F17/30171 ,  G06F17/30233 ,  Y10S707/99931 ,  Y10S707/99942 ,  Y10S707/99943

摘要： A method and apparatus for performing network file system (NFS) operations across a plurality of servers is provided. At a first server, a filehandle for a particular file is generated based, at least in part, on an identifier that uniquely identifies the particular file relative to all other files within a file system repository. The file system repository may be implemented in a database. The identifier may also be stored in the database. The first server sends a client the filehandle. The client may thereafter send another request for the performance of a file operation, containing the filehandle, to a different server. The second server may read the filehandle and use the identifier to locate the file within the repository against which to perform the file operation without receiving, from the first server, information that associates the filehandle with the file.

摘要翻译： 提供了一种用于在多个服务器上执行网络文件系统（NFS）操作的方法和装置。 在第一服务器上，至少部分地基于唯一地标识特定文件相对于文件系统存储库内的所有其他文件的标识符生成特定文件的文件句柄。 文件系统存储库可以在数据库中实现。 标识符也可以存储在数据库中。 第一台服务器向客户端发送文件句柄。 然后，客户端可以向包含文件句柄的文件操作执行另一请求，到不同的服务器。 第二服务器可以读取文件句柄并且使用标识符来定位要在其中执行文件操作的存储库内的文件，而不从第一服务器接收将文件句柄与该文件相关联的信息。

公开(公告)号：US20070005603A1

公开(公告)日：2007-01-04

申请号：US11172472

申请日：2005-06-29

申请人： Namit Jain ,  Syam Pannala ,  Sam Idicula ,  Nipun Agarwal ,  Eric Sedlar ,  Vikram Kapoor

发明人： Namit Jain ,  Syam Pannala ,  Sam Idicula ,  Nipun Agarwal ,  Eric Sedlar ,  Vikram Kapoor

IPC分类号： G06F17/30

CPC分类号： G06F17/30171 ,  G06F17/30233 ,  Y10S707/99931 ,  Y10S707/99942 ,  Y10S707/99943

摘要： A method and apparatus for sharing state information among a plurality of servers is provided. A first server receives a request to perform a file operation, such as a NFS file system operation. Thereafter, the first server updates state information to reflect a change in state associated with processing the request. The first server then causes state update information, which identifies the change in state that was made at the first server, to be propagated to a second server. The second server updates state information, stored at the second server, to reflect the change in state associated with processing the request at the first server. Advantageously, a client may send a series of stateful file operations to either the first server or the second server, even if processing any one of the stateful file operation requests requires knowledge of the state of processing prior requests in the series of requests.

摘要翻译： 提供了一种用于在多个服务器之间共享状态信息的方法和装置。 第一服务器接收执行诸如NFS文件系统操作之类的文件操作的请求。 此后，第一服务器更新状态信息以反映与处理请求相关联的状态变化。 然后，第一服务器导致状态更新信息，其标识在第一服务器处进行的状态的改变，以被传播到第二服务器。 第二服务器更新存储在第二服务器处的状态信息，以反映与在第一服务器处理请求相关联的状态变化。 有利地，客户机可以向第一服务器或第二服务器发送一系列有状态的文件操作，即使处理有状态文件操作请求中的任何一个需要知道在一系列请求中处理先前请求的状态。

公开(公告)号：US07158981B2

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

申请号：US11315835

申请日：2005-12-21

申请人： Nipun Agarwal ,  Eric Sedlar ,  Ravi Murthy ,  Namit Jain

发明人： Nipun Agarwal ,  Eric Sedlar ,  Ravi Murthy ,  Namit Jain

IPC分类号： G06F17/00 ,  G06F7/00

CPC分类号： G06F17/30595 ,  G06F17/30917 ,  Y10S707/99931 ,  Y10S707/99933 ,  Y10S707/99942 ,  Y10S707/99943 ,  Y10S707/99945

摘要： A hierarchy may be explicitly or implicitly reflected in existing data maintained external to hierarchy structures. Such hierarchies are referred to herein as a “pre-existing hierarchies”. Techniques are described herein for capturing a pre-existing hierarchy in hierarchy structures. After a pre-existing hierarchy has been captured, there exist two independent sets of data that reflect the hierarchy: the external hierarchy definition and the internal hierarchy definition. Changing either hierarchy definition changes the hierarchy. Therefore, to maintain a consistent reflection of the hierarchy, the internal hierarchy definition must be modified in response to changes made to the external hierarchy definition, and the external hierarchy definition must be modified in response to changes made to the internal hierarchy definition. Various techniques are described for maintaining consistency between the two hierarchy definitions.

摘要翻译： 层次结构可以在层次结构外部维护的现有数据中显式或隐式地反映出来。 这样的层次结构在本文中称为“预先存在的层级”。 这里描述了用于在层次结构中捕获预先存在的层次结构的技术。 在捕获了一个预先存在的层次结构之后，存在反映层次结构的两个独立的数据集：外部层次结构定义和内部层次结构定义。 更改层次结构定义会更改层次结构。 因此，为了保持层次结构的一致反映，必须根据对外部层次结构定义所做的更改来修改内部层次结构定义，并且必须根据对内部层次结构定义的更改来修改外部层次结构定义。 描述了用于维持两个层次结构定义之间的一致性的各种技术。

公开(公告)号：US20060117049A1

公开(公告)日：2006-06-01

申请号：US10999864

申请日：2004-11-29

申请人： Namit Jain ,  Fei Ge ,  Ravi Murthy ,  Subramanian Muralidhar ,  Nipun Agarwal ,  Eric Sedlar

发明人： Namit Jain ,  Fei Ge ,  Ravi Murthy ,  Subramanian Muralidhar ,  Nipun Agarwal ,  Eric Sedlar

IPC分类号： G06F17/00

CPC分类号： G06F17/30091 ,  G06F17/30233 ,  Y10S707/99931

摘要： A method and apparatus for processing path-based database operations is provided. According to one aspect, a “parent row ID” column is added to a directory links table. For each row in the table, the value of the “parent row ID” column indicates the row ID, in the table, of the node that is that row's node's parent in the file hierarchy. To determine whether a particular node is within a specified path of the file hierarchy, the particular node's pathname is derived by visiting child-to-parent links indicated in the table and prepending, to the front of a pathname being constructed for the particular node, node names indicated in the visited rows. Each parent node's row in the directory links table is located using the “parent row ID” column of the child node's row. The resulting pathname is compared with the specified path to determine whether the particular node exists therein.

公开(公告)号：US20050171945A1

公开(公告)日：2005-08-04

申请号：US11088340

申请日：2005-03-23

申请人： Carol Colrain ,  Namit Jain ,  Juan Loaiza

发明人： Carol Colrain ,  Namit Jain ,  Juan Loaiza

IPC分类号： G06F17/00 ,  G06F17/30

CPC分类号： G06F17/3048 ,  G06F17/30433 ,  Y10S707/99934 ,  Y10S707/99953

摘要： A system and method for enabling a second database instance to more quickly process a request to execute a database statement that has previously been executed by a first database instance is described. In one embodiment, the method involves sending the database statement from the first database instance to the second database instance, and generating by the second database instance one or more structures needed to prepare the statement for execution, such as a parse tree and an execution plan for the statement. If at some point in the future, the second database instance receives a request to execute the same statement, the above structures can be used for execution, thereby eliminating the need for one or more potentially time-consuming operations, such as generation of a parse tree or execution plan for the statement.

公开(公告)号：US20050050092A1

公开(公告)日：2005-03-03

申请号：US10648600

申请日：2003-08-25

申请人： Namit Jain ,  Nipun Agarwal ,  Ravi Murthy

发明人： Namit Jain ,  Nipun Agarwal ,  Ravi Murthy

IPC分类号： G06F17/00 ,  G06F17/30

CPC分类号： G06F17/30917

摘要： Techniques and systems are disclosed for directly storing semistructured data in a database. According to one aspect, a client application reads data that comprises instances of a parent type. The client application invokes routines associated with the parent type. An array is created for storing instances of the parent type. These routines invoke routines associated with a child type of the parent type. An array is created for storing instances of the child type. The arrays are populated with values specified in the data. According to one aspect, some columns of the arrays may be populated with other values to be stored in hidden columns of database tables. The client application converts the arrays into a data stream that conforms to the format of the database's data blocks. The client application then streams the data to a database server, which writes the data blocks directly into one or more data blocks in the database.

摘要翻译： 公开了用于将半结构化数据直接存储在数据库中的技术和系统。 根据一个方面，客户端应用读取包含父类型的实例的数据。 客户端应用程序调用与父类型相关联的例程。 创建一个数组来存储父类型的实例。 这些例程调用与父类型的子类型相关联的例程。 创建一个数组来存储子类型的实例。 数组用数据中指定的值填充。 根据一个方面，阵列的一些列可以用其他值填充以存储在数据库表的隐藏列中。 客户端应用程序将阵列转换为符合数据库数据块格式的数据流。 然后，客户端应用程序将数据流传输到数据库服务器，数据库服务器将数据块直接写入数据库中的一个或多个数据块。