公开(公告)号：US07743333B2

公开(公告)日：2010-06-22

申请号：US11097065

申请日：2005-04-01

申请人： Mehul D. Bastawala ,  Lakshminarayanan Chidambaran ,  Sreenivas Gollapudi ,  Sanjay Kaluskar ,  Srinath Krishnaswamy ,  Debashish Chatterjee

发明人： Mehul D. Bastawala ,  Lakshminarayanan Chidambaran ,  Sreenivas Gollapudi ,  Sanjay Kaluskar ,  Srinath Krishnaswamy ,  Debashish Chatterjee

IPC分类号： G06F3/00

CPC分类号： G06F17/30457

摘要： A system, method, computer program and system for suspending a result set and continuing from a suspended result set for a scrollable cursor is disclosed. The rows from a row source corresponding to the scrollable cursor result set are suspended into storage so that when a fetch is requested the data can be sent (continued) from the suspended storage and does not depend on the original scrollable cursor row source or session to be available.

摘要翻译： 公开了一种用于暂停结果集并从用于可滚动游标的暂停结果集继续的系统，方法，计算机程序和系统。 来自与可滚动光标结果集相对应的行源的行被暂停到存储器中，使得当请求提取时，可以从挂起的存储器发送（继续）数据，并且不依赖于原始可滚动光标行源或会话 能得到的。

公开(公告)号：US07613710B2

公开(公告)日：2009-11-03

申请号：US11097422

申请日：2005-04-01

申请人： Mehul D. Bastawala ,  Lakshminarayanan Chidambaran ,  Sreenivas Gollapudi ,  Sanjay Kaluskar ,  Srinath Krishnaswamy ,  Debashish Chatterjee

发明人： Mehul D. Bastawala ,  Lakshminarayanan Chidambaran ,  Sreenivas Gollapudi ,  Sanjay Kaluskar ,  Srinath Krishnaswamy ,  Debashish Chatterjee

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

CPC分类号： G06F17/30501 ,  G06F17/3041

摘要： A system, method, computer program and system for suspending a result set and continuing from a suspended result set for a cursor is disclosed. The rows from a row source corresponding to the cursor result set are suspended into storage so that when a fetch is requested the data can be sent (continued) from the suspended storage and does not depend on the original cursor row source or session to be available.

摘要翻译： 公开了一种系统，方法，计算机程序和系统，用于暂停结果集并从停止的游标结果集继续。 来自与光标结果集相对应的行源的行被暂停到存储器中，使得当请求提取时，可以从挂起的存储器发送（继续）数据，并且不依赖于原始光标行源或会话可用 。

公开(公告)号：US07580971B1

公开(公告)日：2009-08-25

申请号：US09953490

申请日：2001-09-10

申请人： Sreenivas Gollapudi ,  Debashis Saha ,  Anindo Roy ,  Lakshminarayanan Chidambaran ,  Debashish Chatterjee

发明人： Sreenivas Gollapudi ,  Debashis Saha ,  Anindo Roy ,  Lakshminarayanan Chidambaran ,  Debashish Chatterjee

IPC分类号： G06F15/16

CPC分类号： G06F17/30474 ,  G06F17/3048 ,  H04L67/1097

摘要： A method and apparatus for efficiently processing data requests in a network oriented n-tier database environment is presented. According to one embodiment of the invention, certain or all data from the tables of a database server device can be maintained in tables on the client device in a client side database cache server system. This local cache allows the network oriented n-tier database system to eliminate the expense of repetitive network transmissions to respond to duplicate queries for the same information. Additionally, the local client device may also keep track of what data is cached on peer network nodes. This allows the client to request that data from a peer database cache server and off load that burden from the database server device. Moreover, the local client may also keep statistics regarding the frequency of requested data in order to optimize the data set maintained in the local database cache server.

摘要翻译： 提出了一种在面向网络的n层数据库环境中有效处理数据请求的方法和装置。 根据本发明的一个实施例，来自数据库服务器设备的表的某些或所有数据可以在客户机侧数据库高速缓存服务器系统中的客户端设备的表中维护。 该本地缓存允许面向网络的n层数据库系统消除重复网络传输的费用，以响应相同信息的重复查询。 此外，本地客户端设备还可以跟踪在对等网络节点上高速缓存哪些数据。 这允许客户端从对等数据库缓存服务器请求数据，并从数据库服务器设备卸载负担。 此外，本地客户端还可以保持关于所请求数据的频率的统计信息，以便优化本地数据库缓存服务器中维护的数据集。

公开(公告)号：US20090100180A1

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

申请号：US12338651

申请日：2008-12-18

申请人： Lakshminarayanan Chidambaran ,  Debashish Chatterjee ,  James W. Stamos

发明人： Lakshminarayanan Chidambaran ,  Debashish Chatterjee ,  James W. Stamos

IPC分类号： G06F15/173

CPC分类号： G06F9/5088

摘要： An approach migrates database sessions from a database server on which performance and resource availability requirements are not being met to another database server. Because workload is removed from the database server not meeting these requirements, improved performance there is promoted. Furthermore, the approach switches the users in a way that attempts to keep performance and resource availability levels at the database server receiving the database sessions within goals for performance and resource availability.

摘要翻译： 一种方法将数据库会话从数据库服务器迁移到哪个性能和资源可用性要求未被满足到另一个数据库服务器。 因为从不符合这些要求的数据库服务器中删除工作负载，因此提升了性能。 此外，该方法以一种尝试在数据库服务器上保持性能和资源可用性级别的方式切换用户，以在性能和资源可用性的目标内接收数据库会话。

公开(公告)号：US06721809B1

公开(公告)日：2004-04-13

申请号：US09643318

申请日：2000-08-21

申请人： Anindo Roy ,  M. Shoaib Lari ,  Sreenivas Gollupudi ,  Debashis Saha ,  Lakshminarayanan Chidambaran ,  Debashish Chatterjee

发明人： Anindo Roy ,  M. Shoaib Lari ,  Sreenivas Gollupudi ,  Debashis Saha ,  Lakshminarayanan Chidambaran ,  Debashish Chatterjee

IPC分类号： G06F900

CPC分类号： G06F9/44521

摘要： One embodiment of the present invention provides a system that modifies a function defined within an application programming interface (API) so that the function includes additional code. The system receives an additional code module to be integrated into the function within the API. The system also receives a command to integrate the additional code module into the function. This command is received through a pre-defined function within the API for integrating additional code into functions within the API. In response to the command, the system links the additional code into the function so that the additional code module is executed when the function is called. In one embodiment of the present invention, linking the additional code module into the function involves linking the additional code module as an entry function that is executed at the beginning of the function. In one embodiment of the present invention, linking the additional code module into the function involves linking the additional code module as an exit function that is executed at the end of the function. In one embodiment of the present invention, linking the additional code module into the function involves linking the additional code module as a replacement for original code for the function.

摘要翻译： 本发明的一个实施例提供一种修改在应用编程接口（API）内定义的功能的系统，使得该功能包括附加代码。 系统接收一个附加的代码模块，以集成到API内的函数中。 该系统还接收一个将附加代码模块集成到该功能中的命令。 该命令通过API中的预定义函数接收，用于将附加代码集成到API中的函数中。 响应命令，系统将附加代码链接到函数中，以便在调用函数时执行附加代码模块。 在本发明的一个实施例中，将附加代码模块链接到功能中涉及将附加代码模块链接为在功能开始时执行的输入函数。 在本发明的一个实施例中，将附加代码模块链接到功能中涉及将附加代码模块链接为在功能结束时执行的退出函数。 在本发明的一个实施例中，将附加代码模块链接到功能中涉及链接附加代码模块作为功能的原始代码的替换。

公开(公告)号：US06675195B1

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

申请号：US08873644

申请日：1997-06-11

申请人： Debashish Chatterjee ,  Lekshminarayanan “Luxi” Chidambaran

发明人： Debashish Chatterjee ,  Lekshminarayanan “Luxi” Chidambaran

IPC分类号： G06F1516

CPC分类号： H04L29/06 ,  H04L67/40

摘要： A method and apparatus can improve the performance of a server and clients by storing commands sent to the server until a command is received that fills the capacity of the apparatus to store the commands or that will cause the server to provide information beyond acknowledgment of or completion of the command. The commands are then set to the server software for execution. The server then processes as a group the commands stored, returning a single response, and eliminating the overhead that could have been incurred in providing multiple responses or processing the commands separately.

摘要翻译： 一种方法和装置可以通过存储发送到服务器的命令来提高服务器和客户端的性能，直到接收到填满设备存储命令的容量的命令，或将导致服务器提供超出确认或完成的信息 的命令。 然后将命令设置为服务器软件以执行。 然后，服务器作为组存储命令，返回单个响应，并消除可能在提供多个响应或单独处理命令时可能引起的开销。

公开(公告)号：US6112197A

公开(公告)日：2000-08-29

申请号：US86753

申请日：1998-05-29

申请人： Debashish Chatterjee ,  Sreenivas Gollapudi

发明人： Debashish Chatterjee ,  Sreenivas Gollapudi

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  Y10S707/99933 ,  Y10S707/99942 ,  Y10S707/99952

摘要： A method and apparatus for is provided for efficiently transmitting multiple rows of data to a client station. The client station generates a query that is transmitted to a remotely located server, which in turn generates a query result. The server transmits the first row of data from the query result to the client. The remaining rows of data are transmitted by first calculating the difference between successive rows of data. Next, the server sends only the unique rows resulting from the calculated row difference to the client. The server also send an indication of the number of non-repeated value columns detected in order to allow reconstruction of the query result by the client station.

摘要翻译： 提供了一种用于有效地将多行数据传输到客户站的方法和装置。 客户端站产生一个发送到位于远程的服务器的查询，这又产生一个查询结果。 服务器将第一行数据从查询结果发送给客户端。 通过首先计算连续的数据行之间的差异来传送剩余的数据行。 接下来，服务器将仅从计算出的行差产生的唯一行发送给客户端。 服务器还发送检测到的非重复值列的数量的指示，以允许客户端重建查询结果。