公开(公告)号：US06397227B1

公开(公告)日：2002-05-28

申请号：US09347994

申请日：1999-07-06

申请人： Johannes Klein ,  Robbert C. Van der Linden ,  Raj K. Rathee ,  Anoop Sharma

发明人： Johannes Klein ,  Robbert C. Van der Linden ,  Raj K. Rathee ,  Anoop Sharma

IPC分类号： G06F1730

CPC分类号： G06F17/30516 ,  G06F17/30348 ,  G06F17/30377 ,  G06F17/30418 ,  Y10S707/99938

摘要： A database management system includes an execution engine that, upon rollback of an aborted transaction, has the ability to set fields of the rows that are updated or deleted by the transaction prior to aborting. In particular, when a select, update or delete statement includes a “set on rollback” clause, the respective table access operator of the execution engine modifies the “before image” of each row that is stored by the transaction log manager. The modified before image includes the field updates specified by the set on rollback clause. If a transaction associated with the statement aborts, when the transaction log manager restores the before images of each row that was deleted or updated by the transaction, the restored before images include the field updates specified by the set on rollback clause.

摘要翻译： 数据库管理系统包括一个执行引擎，在中止事务的回滚之后，能够在中止之前设置事务更新或删除的行的字段。 特别地，当select，update或delete语句包括“set on rollback”子句时，执行引擎的相应表访问操作符修改由事务日志管理器存储的每一行的“before image”。 修改后的图像包括由rollback子句中指定的字段更新。 如果与该语句关联的事务中止，则当事务日志管理器恢复由事务删除或更新的每一行的先前图像时，恢复的映像之前包括由rollback子句设置的字段更新。

公开(公告)号：US08375194B2

公开(公告)日：2013-02-12

申请号：US12788706

申请日：2010-05-27

申请人： Viral S. Shah ,  Sudhir R. Shetiya ,  Anoop Sharma ,  Lars B. Plum

发明人： Viral S. Shah ,  Sudhir R. Shetiya ,  Anoop Sharma ,  Lars B. Plum

IPC分类号： G06F9/26 ,  G06F9/34

CPC分类号： G06F12/023 ,  G06F17/30138

摘要： There is provided a computer-executed method of freeing memory. One exemplary method comprises receiving a message from a user process. The message may specify a virtual address for a memory segment. The virtual address may be mapped to the memory segment. The memory segment may comprise a physical page. The method may further comprise identifying the physical page based on the virtual address. Additionally, the method may comprise freeing the physical page without unmapping the memory segment.

摘要翻译： 提供了一种计算机执行的释放内存的方法。 一种示例性方法包括从用户进程接收消息。 消息可以指定内存段的虚拟地址。 虚拟地址可以被映射到存储器段。 存储器段可以包括物理页面。 该方法还可以包括基于虚拟地址来识别物理页面。 另外，该方法可以包括释放物理页面而不取消映射存储器段。

公开(公告)号：US08104020B2

公开(公告)日：2012-01-24

申请号：US12541086

申请日：2009-08-13

申请人： Anoop Sharma ,  Ramu Korlipara ,  Binh Nguyen

发明人： Anoop Sharma ,  Ramu Korlipara ,  Binh Nguyen

IPC分类号： G06F9/44

CPC分类号： G06F11/3688

摘要： A method and system to automate software testing using sniffer side and browser side recording and a toolbar interface are described. In one embodiment, a system tests programming code associated with a website and creates a first test case. In another embodiment, the system includes a testing device having a test interface to enable a user to initiate a first test case and to store a first HTML representation and a first XML representation of encrypted web pages viewed during the first test case. In another embodiment, the system includes a sniffer server that operates as a proxy server for the website and stores a second HTML representation and a second XML representation of unencrypted web pages viewed during the first test case. The system may include a hosting server that hosts the website and receives the first and the second HTML and XML representations from the testing device and the sniffer server when the test case is terminated via the test interface.

摘要翻译： 描述了使用嗅探器侧和浏览器侧记录以及工具栏界面来自动化软件测试的方法和系统。 在一个实施例中，系统测试与网站相关联的编程代码并创建第一测试用例。 在另一个实施例中，系统包括具有测试接口的测试设备，以使用户能够发起第一测试用例并存储在第一测试用例期间查看的第一HTML表示和加密网页的第一XML表示。 在另一个实施例中，系统包括嗅探器服务器，其作为网站的代理服务器操作，并存储在第一测试用例期间查看的未加密网页的第二HTML表示和第二XML表示。 当测试用例经由测试界面终止时，系统可以包括托管网站并且从测试设备和嗅探器服务器接收第一和第二HTML和XML表示的托管服务器。

公开(公告)号：US08015239B2

公开(公告)日：2011-09-06

申请号：US10969738

申请日：2004-10-19

申请人： Anoop Sharma ,  Makarand Kulkarni ,  I-Chin Chen ,  Nadir Hussain ,  Corey Innis

发明人： Anoop Sharma ,  Makarand Kulkarni ,  I-Chin Chen ,  Nadir Hussain ,  Corey Innis

IPC分类号： G06F15/16

CPC分类号： G06F11/3688

摘要： A method and system to reduce false positives within an automated software-testing environment using a comparator module, a filter application module, and a preview generator module is provided. In one exemplary embodiment, a method within a testing system for testing web pages associated with a current version website by automatically generating filter data by comparing differences between a plurality of iterations of a test case executed on a previous version website, automatically generating error data by executing the test case on the current version website, and detecting differences between the previous version and the current version of the website by applying filtering rules within the filter data to the error data to remove false positives.

摘要翻译： 提供了一种使用比较器模块，滤波器应用模块和预览发生器模块在自动化软件测试环境中减少误报的方法和系统。 在一个示例性实施例中，一种测试系统内的方法，用于通过比较在先前版本网站上执行的测试案例的多个迭代之间的差异自动生成过滤器数据来自动生成与当前版本网站相关联的网页，自动生成错误数据 在当前版本的网站上执行测试用例，并通过在过滤器数据中应用过滤规则来检测错误数据以清除误报，从而检测先前版本和当前版本的网站之间的差异。

公开(公告)号：US5511190A

公开(公告)日：1996-04-23

申请号：US376026

申请日：1995-01-20

申请人： Anoop Sharma ,  Hansjorg Zeller

发明人： Anoop Sharma ,  Hansjorg Zeller

IPC分类号： G06F17/30

CPC分类号： G06F17/30489 ,  Y10S707/99931

摘要： A structured query language (SQL) grouping and aggregation system and method that incorporates hash-based techniques, several overflow handling strategies and statistics-based process-selection criteria. The method can execute SQL group-by queries on distributed database tables or tables stored locally to the database management system (DBMS) processor executing the grouping method. Hash-based techniques allow groupings and aggregates to be generated on the fly through the use of partial aggregates maintained in primary memory. Where primary memory is limited, groups and aggregates are still generated for as many groups as can be maintained in primary memory, while various overflow procedures are provided for buffering ungrouped data and writing that data to an overflow disk file for later processing. In one overflow procedure, raw data from groups that cannot be aggregated in primary memory are buffered then written to the overflow disk file. In a second overflow procedure, ungroupable raw data is formatted the same as data being aggregated in the group table, buffered, and then written to the overflow file. In a third overflow procedure, ungroupable raw data is partially aggregated in an output buffer maintained in primary memory before being written to the overflow file maintained in secondary memory. Database table statistics maintained by a cataloger are consulted to determine whether hash-based grouping or conventional sort based grouping should be used to execute a group-by query. The system is adaptable to running a grouping query against a partitioned database on distributed processors.

摘要翻译： 一种结构化查询语言（SQL）分组和聚合系统和方法，其中集成了基于哈希的技术，几种溢出处理策略和基于统计的流程选择标准。 该方法可以对分布式数据库表或本地存储的数据库管理系统（DBMS）处理器执行分组方法执行SQL组查询。 基于哈希的技术允许通过使用在主内存中维护的部分聚合来即时生成分组和聚合。 在主存储器受限的情况下，仍然为主存储器中可维护的组生成组和聚合，同时提供各种溢出过程以缓冲未分组数据，并将该数据写入溢出磁盘文件以备后续处理。 在一个溢出过程中，将缓冲不能在主内存中聚合的组的原始数据，然后写入溢出磁盘文件。 在第二个溢出过程中，不可分组的原始数据被格式化为在组表中聚合的数据相同，缓冲，然后写入溢出文件。 在第三个溢出程序中，将未分组的原始数据部分地聚合在主存储器中保存的输出缓冲区中，然后再写入保存在辅助存储器中的溢出文件。 查询由编目员维护的数据库表统计信息，以确定是否应使用基于散列分组或基于常规分类的分组来执行逐组查询。 该系统适用于针对分布式处理器上的分区数据库运行分组查询。

公开(公告)号：US08666966B2

公开(公告)日：2014-03-04

申请号：US12362702

申请日：2009-01-30

申请人： Venkatesan N. Ranganathan ,  Andrew D. Therber ,  Anoop Sharma ,  Hansjorg Zeller

发明人： Venkatesan N. Ranganathan ,  Andrew D. Therber ,  Anoop Sharma ,  Hansjorg Zeller

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  G06F17/30445 ,  G06F17/30516

摘要： A system and method for providing parallel result streams for database queries is provided. The system includes a network including a client, a server, and a database. The client executes an application and sends a query to the server. In response, the server compiles the query to produce a query plan, executes statements in the query plan and sends parallel result streams to the client.

摘要翻译： 提供了一种用于为数据库查询提供并行结果流的系统和方法。 该系统包括包括客户端，服务器和数据库的网络。 客户端执行应用程序并向服务器发送查询。 作为响应，服务器编译查询以产生查询计划，在查询计划中执行语句，并将并行结果流发送到客户端。

公开(公告)号：US08140961B2

公开(公告)日：2012-03-20

申请号：US11986593

申请日：2007-11-21

申请人： Brian Shaun Vickery ,  Anoop Sharma ,  Vinita Subramanian

发明人： Brian Shaun Vickery ,  Anoop Sharma ,  Vinita Subramanian

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

CPC分类号： G06F17/30339 ,  G06F17/30486

摘要： An automated method to align column values to proper byte boundaries for rapid scanning in a parallel processing database system. A table definition is received having a logical order of fields. The fields are re-ordered to create a physical order of fields. The physical order of fields has fixed length fields having a same byte alignment requirement positioned adjacent to each other in descending order from largest size to smallest size, and wherein a first fixed length field in the physical order is aligned on a proper byte boundary. Other embodiments, aspects and features are also disclosed.

摘要翻译： 一种自动化方法，用于将列值对齐到适当的字节边界，以便在并行处理数据库系统中进行快速扫描。 接收到具有字段的逻辑顺序的表定义。 这些字段被重新排序以创建字段的物理顺序。 场的物理顺序具有固定长度字段，其具有相对于彼此相邻的相同字节对齐要求，从最大尺寸到最小尺寸的降序，并且其中物理顺序上的第一固定长度字段在适当的字节边界上对齐。 还公开了其它实施例，方面和特征。

公开(公告)号：US20060101403A1

公开(公告)日：2006-05-11

申请号：US10969736

申请日：2004-10-19

申请人： Anoop Sharma ,  Ramu Korlipara ,  Binh Nguyen

发明人： Anoop Sharma ,  Ramu Korlipara ,  Binh Nguyen

IPC分类号： G06F9/44

CPC分类号： G06F11/3688

摘要： A method and system to automate software testing using sniffer side and browser side recording and a toolbar interface are described. In one embodiment, a system tests programming code associated with a website and creates a first test case. In another embodiment, the system includes a testing device having a test interface to enable a user to initiate a first test case and to store a first HTML representation and a first XML representation of encrypted web pages viewed during the first test case. In another embodiment, the system includes a sniffer server that operates as a proxy server for the website and stores a second HTML representation and a second XML representation of unencrypted web pages viewed during the first test case. The system may include a hosting server that hosts the website and receives the first and the second HTML and XML representations from the testing device and the sniffer server when the test case is terminated via the test interface.

公开(公告)号：US20120054215A1

公开(公告)日：2012-03-01

申请号：US12868895

申请日：2010-08-26

申请人： Michael J. Hanlon ,  Anoop Sharma ,  Subbarao Kakarlamudi ,  Selvaganesan Govindarajan

发明人： Michael J. Hanlon ,  Anoop Sharma ,  Subbarao Kakarlamudi ,  Selvaganesan Govindarajan

IPC分类号： G06F17/30

CPC分类号： G06F17/30306 ,  Y10S715/968

摘要： There is provided a computer-implemented method of modifying a query executing in a database management system. The method comprises sending a no-wait message for the query to a control broker. The method also comprises receiving a reply to the no-wait message from the control broker. The reply to the no-wait message specifies a modification to the query. Additionally, the method comprises performing the modification.

摘要翻译： 提供了一种修改在数据库管理系统中执行的查询的计算机实现的方法。 该方法包括向控制代理发送用于查询的不等待消息。 该方法还包括从控制代理接收对不等待消息的回复。 对等待消息的回复指定了查询的修改。 另外，该方法包括执行修改。

公开(公告)号：US20100198855A1

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

申请号：US12362702

申请日：2009-01-30

申请人： VENKATESAN N. RANGANATHAN ,  Andrew D. Therber ,  Anoop Sharma ,  Hansjorg Zeller

发明人： VENKATESAN N. RANGANATHAN ,  Andrew D. Therber ,  Anoop Sharma ,  Hansjorg Zeller

IPC分类号： G06F17/30

CPC分类号： G06F17/30595 ,  G06F17/30445 ,  G06F17/30516

摘要： A system and method for providing parallel result streams for database queries is provided. The system includes a network including a client, a server, and a database. The client executes an application and sends a query to the server. In response, the server compiles the query to produce a query plan, executes statements in the query plan and sends parallel result streams to the client.

摘要翻译： 提供了一种用于为数据库查询提供并行结果流的系统和方法。 该系统包括包括客户端，服务器和数据库的网络。 客户端执行应用程序并向服务器发送查询。 作为响应，服务器编译查询以产生查询计划，在查询计划中执行语句，并将并行结果流发送到客户端。