Patents Represented by Attorney, Agent or Law Firm Hickman Palermo
  • Patent number: 8209322
    Abstract: Techniques for optimizing queries are provided. In one technique, a query optimizer determines that two tables involved in equi-joins with one other table return unique rows. The query optimizer further determines that the rows returned by one of the tables is a subset of the rows returned by the other table. The query optimizer then determines that one of the two tables involved in the equi-joins can be eliminated. In another technique, a query optimizer determines that group-by placement may be used on a query that specifies a table. The query optimizer further determines that a view that (1) replaces the table and (2) results from the group-by placement is a subset of an existing view. The query optimizer further determines that each view is unique. The query optimizer selects an execution plan that does not join any tables or views with the resulting view or with the specified table.
    Type: Grant
    Filed: August 21, 2007
    Date of Patent: June 26, 2012
    Assignee: Oracle International Corporation
    Inventor: Rafi Ahmed
  • Patent number: 8209361
    Abstract: Techniques are described herein for efficient and scalable processing of complex sets of XML schemas. The techniques described herein provide for reducing duplication of schema elements in volatile memory by building an XML schema in-memory model that stores repeating schema elements in in-memory data structures that are separate from in-memory data structures that store the parent schema elements which logically include or otherwise refer to the repeating schema elements. The techniques described herein also provide for faster generation of an in-memory model of an XML schema by pre-loading, in data structures on persistent storage, of schema elements from dependent XML schemas that are referenced and/or incorporated by the XML schema.
    Type: Grant
    Filed: January 19, 2010
    Date of Patent: June 26, 2012
    Assignee: Oracle International Corporation
    Inventors: Sam Idicula, Asha Tarachandani, Sivasankaran Chandrasekar, Vijay Medi, Ali Tabar, Nipun Agarwal
  • Patent number: 8209762
    Abstract: An approach is provided for printing locked print data using user and print data authentication. The approach is applicable to a wide variety of contexts and implementations and includes the use of bi-directional security measures to ensure a secure transmission of a document to a printer and secure retrieval of the document from the printer by one or more intended recipients. In particular, the bi-directional security measures ensure that: 1) the document is received only by the intended recipient designated by the creator, 2) both the document's creator and the intended recipient are successfully authenticated, 3) the document received by the intended recipient is the document that was created by the creator, and 4) the document received by the intended recipient is identical to the document created by the creator.
    Type: Grant
    Filed: June 24, 2008
    Date of Patent: June 26, 2012
    Assignee: Ricoh Company, Ltd.
    Inventor: Jiang Hong
  • Patent number: 8209384
    Abstract: A system for managing an instant messaging conversation in a persistent context is provided. The system has an archiving feature for convenient access to the conversation, even after the conversation has ceased.
    Type: Grant
    Filed: October 23, 2007
    Date of Patent: June 26, 2012
    Assignee: Yahoo! Inc.
    Inventors: Allen Tom, Adrien Cahen, Bryce Glass, Xavier Legros
  • Patent number: 8209294
    Abstract: A method and apparatus for managing data in a partitioned data storage space is provided. Data referencing a new data item to be stored in the data storage space is received. It is determined that the data item does not pertain to any previously created partition. In response to the determination, a new partition is automatically created in the data storage space. The partition is mapped to a new set of values, such as to a next unpartitioned interval of dates or numbers.
    Type: Grant
    Filed: June 15, 2007
    Date of Patent: June 26, 2012
    Assignee: Oracle International Corporation
    Inventors: Shrikanth Shankar, Ananth Raghavan, Badhri G. Varanasi
  • Patent number: 8208159
    Abstract: In an embodiment, a computer-implemented method comprises receiving an application identifier value associated with a printed application; receiving a media size; receiving a machine identifier value associated with a first document processing machine; determining programming instructions for a second document processing machine based on said received application identifier value, media size, and machine identifier value.
    Type: Grant
    Filed: April 4, 2008
    Date of Patent: June 26, 2012
    Assignee: Ricoh Company, Ltd.
    Inventors: Kurt Knodt, Ronald M. Conescu, Yue Liu
  • Patent number: 8203952
    Abstract: A method and apparatus for using network traffic logs for search enhancement is disclosed. According to one embodiment, network usage is tracked by generating log files. These log files among other things indicate the frequency web pages are referenced and modified. These log files or information from these log files can then be used to improve document ranking, improve web crawling, determine tiers in a multi-tiered index, determine where to insert a document in a multi-tiered index, determine link weights, and update a search engine index.
    Type: Grant
    Filed: July 7, 2008
    Date of Patent: June 19, 2012
    Assignee: Yahoo! Inc.
    Inventors: Arkady Borkovsky, Douglas M. Cook, Jean-Marc Langlois, Tomi Poutanen, Hongyuan Zha
  • Patent number: 8205072
    Abstract: A method of providing endpoint security for a session on an untrusted computer accessing data on a networked server is disclosed. A virtual secure desktop is created on the untrusted computer that protects the user's applications running in the virtual secure desktop from malicious code and encrypts all data. Data to be written to the hard drive is stored in a secure vault. The secure vault is completely encrypted and erased at the end of the virtual secure desktop session. The virtual secure desktop may be created by creating a separate user session on the untrusted computer and linking the separate user session to the secure vault. Alternatively, the virtual secure desktop may be created by intercepting calls the Native API and redirecting requests from the virtual secure desktop session to the secure vault.
    Type: Grant
    Filed: July 22, 2004
    Date of Patent: June 19, 2012
    Assignee: Cisco Technology, Inc.
    Inventors: Gregoire Alexandre Gentil, Alireza Malekzadeh
  • Patent number: 8204228
    Abstract: In an embodiment, a fast group key management re-registration is described. One computer-implemented method comprises, at a key server: receiving a registration request from a network element to join a group of network elements managed by the key server; generating and storing a group member registration state comprising information identifying the network element within the group of network elements; generating a token using information from the group member registration state, wherein the token identifies the network element within the group; deleting the group member registration state for the network element at the key server; generating an encrypted token by encrypting the token using a secret key that is local to the key server; sending the encrypted token to the network element; receiving the encrypted token along with a re-registration request from the network element to re-join the group of network elements; and re-registering the network element using the encrypted token.
    Type: Grant
    Filed: December 9, 2008
    Date of Patent: June 19, 2012
    Assignee: Cisco Technology, Inc.
    Inventors: Brian Weis, David McGrew
  • Patent number: 8204892
    Abstract: A method, computer-readable medium, and machine are provided for boosting the performance of sort operations. A database server performs an operation on a set of data. The operation uses disk space such as a temporary tablespace. The disk space belongs to a disk group in which data is stored according to a level of redundancy. A determination is made as to whether the operation is a sort operation. If the operation is not a sort operation, then at least part of a result of the operation is stored on the disk space according to the level of redundancy specified for the disk group. If the operation is a sort operation, then only a single copy of the at least part of the result is stored without storing a redundant copy of the at least part of the result. Optionally, backup information sufficient to re-perform the sort operation may also be stored.
    Type: Grant
    Filed: October 26, 2009
    Date of Patent: June 19, 2012
    Assignee: Oracle International Corporation
    Inventor: Vijay Balebail
  • Patent number: 8204967
    Abstract: A method is disclosed for dynamically creating encapsulation and decapsulation chains and segmenting the packet-forwarding plane. A distributed router may comprise multiple cards, each exposing a subset of the router's physical interfaces. Some physical interfaces may be configured to send/receive only certain types and destinations of data packets. Some cards might not expose any physical interfaces configured to send/receive a particular type and destination of packet, making encapsulation and/or decapsulation chains for virtual interfaces that process data packets of the particular type useless on those cards. Therefore, instead of always creating both encapsulation and decapsulation chains for a virtual interface on a card, an aspect of the method dynamically determines which of the encapsulation and decapsulation chains are useful for a virtual interface on that card, and creates only those chains that are useful on that card.
    Type: Grant
    Filed: April 14, 2004
    Date of Patent: June 19, 2012
    Assignee: Cisco Technology, Inc.
    Inventors: Rajiv Goel, Jianyu Chen, Scott Molloy, Chung T. Nguyen, David Ward, John Bettink, Peramanayagam Marimuthu
  • Patent number: 8199699
    Abstract: Techniques and systems for automatically configuring devices to interact with “legacy” wireless access points (“WAPs”) are disclosed. According to one technique, a user programs a WPS-enabled WAP with the configuration information of a “legacy” WAP. This makes the WPS-enabled WAP “aware” of the “legacy” WAP. When any other user brings his device within discovery range of the WPS-enabled WAP, the WPS-enabled WAP sends, to that device, a list of the WAPs of which the WPS-enabled WAP is aware. The device's user selects one of the WAPs (e.g., a “legacy” WAP) from the list. The WPS-enabled WAP receives the user's selection and sends, to the device, the configuration information for the selected WAP. The user's device configures itself, using the configuration information, to interact with the selected WAP. Thereafter, the user's device can access a network through the selected WAP, even if the selected WAP is a “legacy” WAP.
    Type: Grant
    Filed: October 26, 2007
    Date of Patent: June 12, 2012
    Assignee: Ricoh Company, Ltd.
    Inventor: James Woo
  • Patent number: 8200612
    Abstract: In processing a query on multidimensional data in a multidimensional schema, a multidimensional database server performs various processes to limit the amount of data that is extracted from the database and presented to a relational database server in response to the request. A subset of data is identified to extract from the multidimensional data, based on the query. In various embodiments, cell-filtering, measure-filtering, and column-filtering criteria identified from the query are used to filter the subset of data, in order to return a minimized set of multidimensional data values from the subset of data. Therefore, computational resources are conserved with respect to further processing by the relational database server in response to the query.
    Type: Grant
    Filed: May 6, 2004
    Date of Patent: June 12, 2012
    Assignee: Oracle International Corporation
    Inventors: Ekrem Soylemez, Caleb Welton, Gregory Dorman, Matthew Dombroski, Albert A. Hopeman, IV, Igor Lubashev, Lev Margulis, Christopher Kearney, James Carey
  • Patent number: 8200613
    Abstract: An approach for reconciling a data warehouse includes automatically identifying, based upon a change made to a definition of an object, one or more other objects in the data warehouse that are affected by the change made to the definition of the object. The object and the other objects may be any type or form of data, for example, database tables or routines, and the invention is not limited to any particular type of object. Dependency analysis is used to evaluate dependency data to identify the one or more other objects affected by the change made to the definition of the object. The dependency data specifies dependencies between the object and the one or more other objects. The dependency data may also specify dependencies between the one or more other objects. As described in more detail hereinafter, the dependency data used may vary depending upon a particular function to be performed.
    Type: Grant
    Filed: November 12, 2002
    Date of Patent: June 12, 2012
    Assignee: Oracle International Corporation
    Inventors: Winnie Tak Yu Wan, Adrian Graham Scott, Zili Fan
  • Patent number: 8200658
    Abstract: 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.
    Type: Grant
    Filed: June 13, 2011
    Date of Patent: June 12, 2012
    Assignee: Oracle International Corporation
    Inventors: Carol L. Colrain, Namit Jain, Juan R. Loaiza
  • Patent number: 8200679
    Abstract: Techniques are provided for estimating the cardinality of a virtual result table that is produced by executing path-based table functions within a query, such as the XMLTABLE function. Some path-based table functions apply a path expression to input from a base table of XML documents to select rows to produce the result table. Path statistics are collected for the path expressions for the base table. The path statistics are used to estimate the cardinalities of the result table. The estimated cardinality of the result table is useful for estimating costs of query execution plans that are generated for the query.
    Type: Grant
    Filed: December 4, 2008
    Date of Patent: June 12, 2012
    Assignee: Oracle International Corporation
    Inventors: Ning Zhang, Sam Idicula, Sivasankaran Chandrasekar, Nipun Agarwal
  • Patent number: 8195830
    Abstract: Techniques are provided for efficiently transferring documents (or files) between a client device and a WS-enabled device. A document is divided into a plurality of distinct chunks. Each chunk is packaged in a separate SOAP message. Each SOAP message includes a document identifier and a data transmission serial number (DTSN). The DTSN uniquely identifies a particular chunk of the document relative to the other chunks of the document. After one or more chunks of the document are transferred, the size of one or more subsequent chunks is adjusted based on changes in the client device, the WS-enabled device, and/or the network connection. Thereafter, each of the one or more subsequent chunks of the document is either larger or smaller than the one or more chunks that were already transferred.
    Type: Grant
    Filed: June 24, 2009
    Date of Patent: June 5, 2012
    Assignee: Ricoh Company, Ltd.
    Inventor: Lifen Tian
  • Patent number: 8194099
    Abstract: A method and apparatus for displaying digital images on a display is provided. A set of items from a sequence of items is displayed. The sequence of items includes one or more undisplayed items that do not belong to the set of items. The set of items are displayed, in an arrangement that includes a plurality of lines, in an order that corresponds to the sequence. In response to user input that selects a particular item from the set of items, it is determined whether the number of lines, in the plurality of lines, that precede the line containing the particular item is less than a first predetermined threshold. If that is the case, a line of undisplayed items that precede the set of items is displayed, while a line of displayed items that follow the particular item is ceased to be displayed.
    Type: Grant
    Filed: February 24, 2010
    Date of Patent: June 5, 2012
    Assignee: Apple Inc.
    Inventors: Randy Ubillos, Laurent Perrodin, Dan Waylonis
  • Patent number: 8195702
    Abstract: Techniques are provided for processing a CREATE INDEX statement that avoids one or more locks on the underlying table. The processing of such a statement may be divided into a build phase and a cooperation phase. During the build phase, a journal table is created and published. A snapshot of the table is obtained after the last DML transaction (that was pending at the time the journal table was published) commits. The index is built based on the state of the table as of the snapshot. Any changes to the table while the index is built are recorded in the journal table. During the cooperation phase, the index is partially published. A subsequent DML statement determines whether any changes in the journal table affect the same data as the subsequent DML statement. If so, then those changes are applied to the index followed by the subsequent DML statement.
    Type: Grant
    Filed: July 30, 2007
    Date of Patent: June 5, 2012
    Assignee: Oracle International Corporation
    Inventors: Shrikanth Shankar, Ramesh Kumar, Krishna Kunchithapadam, Ananth Raghavan, Dheeraj Pandey, Amit Ganesh, Joy M. Forsythe
  • Patent number: D661697
    Type: Grant
    Filed: May 28, 2010
    Date of Patent: June 12, 2012
    Assignee: Vocality International Ltd.
    Inventor: Martin Saunders