Patents Examined by Wilson Lee
  • Patent number: 10176088
    Abstract: A first execution plan for a first version of a structured query language statement can be requested from a database management system. The first execution plan for the first version of the structured query language statement can be loaded into a first directed graph tree structure comprising a plurality of nodes. The first directed graph tree structure can be scanned to determine whether a full table scan for accessing requested data is represented by at least a one of the plurality of nodes of the directed graph tree structure. Responsive to determining that the full table scan for accessing the requested data is represented by the at least one of the plurality of nodes of the directed graph tree structure, a first indicator that indicates a fault condition can be output.
    Type: Grant
    Filed: January 27, 2017
    Date of Patent: January 8, 2019
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventor: Jonathan M. Harding
  • Patent number: 10169364
    Abstract: A method, including identifying, using a sampling ratio, a random number of logical data units. A hash is calculated for each of the identified logical data units, and a first histogram is computed indicating a duplication count of each of the calculated hashes. Based on respective frequencies of the calculated hashes, a second histogram is computed indicating observed frequencies of each of the duplication counts in the first histogram, and based on the sampling ratio and the second histogram, a target function is derived. A range of acceptable results is derived for the target function, and based on the range of the acceptable results, a set of plausible duplication frequency histograms is defined. A first given plausible duplication frequency histogram having a highest number of distinct logical data units is identified, and a second given plausible duplication frequency histogram having a lowest number of distinct logical data units is identified.
    Type: Grant
    Filed: January 13, 2016
    Date of Patent: January 1, 2019
    Assignee: International Business Machines Corporation
    Inventors: Danny Harnik, Ety Khaitzin, Dmitry Sotnikov
  • Patent number: 10162867
    Abstract: Methods, computing systems and computer program products implement embodiments of the present invention that include partitioning a dataset into a full set of logical data units, and selecting a sample subset of the full set, the sample subset including a random sample of the full set based on a sampling ratio. A set of target hash values are selected from a full range of hash values, and, using a hash function, a respective unit hash value is calculated for each of the logical data units in the sample subset. A histogram is computed that indicates a duplication count of each of the unit hash values that matches a given target hash value, and based on the histogram, a number of distinct logical data units in the full set is estimated.
    Type: Grant
    Filed: January 13, 2016
    Date of Patent: December 25, 2018
    Assignee: International Business Machines Corporation
    Inventors: Danny Harnik, Ety Khaitzin, Dmitry Sotnikov
  • Patent number: 10162824
    Abstract: Techniques for identifying video and/or audio content are presented. An identification management component (IMC) groups users determined to be at least potentially be watching the same content based on first content fingerprints associated with respective content viewed by the users on communication devices, and a defined matching criterion. IMC facilitates identifying the content associated with the group of users based on first content fingerprints associated with the group of users and first reference content fingerprints. IMC receives a second content fingerprint associated with a communication device of a user in the group, sends the second content fingerprint to a third-party identification component for comparison with second reference content fingerprints, and receives content identification information in response.
    Type: Grant
    Filed: March 6, 2017
    Date of Patent: December 25, 2018
    Assignee: Google LLC
    Inventors: Zbigniew Skolicki, Jurek Foryciarz, Jan Wicijowski, Grzegorz Glowaty
  • Patent number: 10157215
    Abstract: The system manages database structure updates. The system may receive, via a development gateway, a development script. The system may also copy, via a backup engine to an update module, an existing object code. The system may deploy, via an update engine, the development script directly to the database structure. The system may also generate new object code within the database structure associated with the existing object code. The system may determine, via a database health monitoring module, at least one of a successful deployment of the new object code or an unsuccessful deployment of the new object code.
    Type: Grant
    Filed: January 13, 2016
    Date of Patent: December 18, 2018
    Assignee: AMERICAN EXPRESS TRAVEL RELATED SERVICES COMPANY, INC.
    Inventors: Raymond L. Gardner, Srinivas Somavarapu
  • Patent number: 10152429
    Abstract: A query for data stored in a database that includes a set of segments is received at a computer system. The set of segments are divided into a plurality of columns and at least one column of the plurality of columns includes one or more fields. The system analyzes the query to determine fields required to be retrieved from the database. The system determines whether a required field of the query is located in a main memory of the computer system. The system creates an input/output request for a column containing the required field for a plurality of segments of the set of segments prior to executing the query.
    Type: Grant
    Filed: October 27, 2015
    Date of Patent: December 11, 2018
    Assignee: Medallia, Inc.
    Inventor: Thorvald Natvig
  • Patent number: 10146819
    Abstract: A method and system for database indexing, wherein a database index comprises at least one index include. The method and system includes obtaining the number of executions of each of a plurality of Structured Query Language (SQL) statements within a certain time period, respectively, wherein the plurality of SQL statements use the database index. For each of the at least one index include, calculating a number of hits of the index include according to the number of executions of each of the plurality of SQL statements. Further, obtaining a length of the index include, and calculating a hit frequency of the index include by using the number of hits and the length of the index include. The hit frequency equals the number of hits divided by the length.
    Type: Grant
    Filed: October 13, 2015
    Date of Patent: December 4, 2018
    Assignee: International Business Machines Corporation
    Inventors: Ge Song, Ke Wei Wei, Xin Ying Yang
  • Patent number: 10142314
    Abstract: The present disclosure presents a method and apparatus for processing an authentication request message in a social network. In order to resolve the problems of the inefficiency in confirming request to establish social relationship by a user and inadequacy of parameter provided for authentication under existing technologies, the present disclosure provides a method. The method includes: receiving, by a social network server, the authentication request message sent by a first client to a second client to establish a social relationship with the second client; determining, by the social network server, a relationship chain information indicative of an indirect social network relationship between the first client and the second client; and forwarding, by the social network server, the authentication request message and the obtained relationship chain information to the second client, the relationship chain information being used by the second client to authenticate the authentication request message.
    Type: Grant
    Filed: December 22, 2016
    Date of Patent: November 27, 2018
    Assignee: Alibaba Group Holding Limited
    Inventors: Jun Ye, Jianxiang Mo
  • Patent number: 10127297
    Abstract: In accordance with embodiments, there are provided mechanisms and methods for facilitating dynamic integration of disparate database architectures for efficient management of resources in an on-demand services environment in a multi-tenant environment according to one embodiment. In one embodiment and by way of example, a method includes receiving, at a first database platform, a job request in a first programming package, transforming the job request from the first programming package to a second programming package, transmitting the job request in the second programming package to a second database platform for processing. The job request may be processed at the second database platform that is independent of the first database platform. The method may further include receiving an output relating to the processing of the job request.
    Type: Grant
    Filed: November 23, 2015
    Date of Patent: November 13, 2018
    Assignee: salesforce.com, inc.
    Inventors: Narayan Bharadwaj, Prashant Kommireddi, Jed Crosby
  • Patent number: 10120948
    Abstract: Systems and methods for providing notifications based on geofencing search results are provided. In particular, in response to a search query from a user, a plurality of search results can be determined. One or more physical search results having an associated geographic location can be determined from the plurality of search results. A geofencing search result can be generated for at least one of the physical search results. The geofencing search result can include data for establishing a geofence proximate to the geographic location by a user device associated with the user. Upon selection of the geofencing search result by the user, the geofence can be established by the user device. Upon detecting entry into the established geofence, the user device can provide one or more notifications associated with the geofence and/or the search query to the user.
    Type: Grant
    Filed: October 13, 2015
    Date of Patent: November 6, 2018
    Assignee: GOOGLE LLC
    Inventor: Russell Quong
  • Patent number: 10120879
    Abstract: Retrieval of images of objects from a large-scale database of object images, based on a query image. The database may, for example, contain images of objects such as faces, vehicles, people and luggage. Semantic attributes such as doors or windows in the case of vehicles are used as high level semantic cues to determine identities of objects in the images. Salient visual characteristics of the images are labeled with attribute information, and a transformation is learned so as to transform the labeled visual characteristics into a discrimination vector that discriminates between the labels. A similarity metric is learned using the discrimination vectors, such that different images depicting the same object are determined to be close while those having different objects are determined to be far apart. Candidates are retrieved based on a query image, and a re-ranking step may be applied to improve results. Validation experiments are described.
    Type: Grant
    Filed: November 26, 2014
    Date of Patent: November 6, 2018
    Assignee: CANON KABUSHIKI KAISHA
    Inventors: Le An, Changjian Zou, Liyan Zhang, Bradley Scott Denney, Dariusz Dusberger
  • Patent number: 10102308
    Abstract: The present disclosure relates to methods, systems, and apparatuses for identifying related records in a database. The method includes receiving, via a network interface, a related records query, the related records query identifying at least one record stored in the electronic database, determining, based on transaction data, at least one related record that is related to the identified at least one record, determining, by a processor, that the at least one related record is unavailable, in response to determining that the at least one related record is unavailable, determining at least one keyword associated with the at least one related record, selecting at least one of one or more substitute records based at least in part on comparing the at least one keyword with a set of keywords associated with one or more substitute records, and providing the selected one or more substitute records as a response to the related records query.
    Type: Grant
    Filed: June 30, 2015
    Date of Patent: October 16, 2018
    Assignee: GROUPON, INC.
    Inventors: Suryanarayanan Parameswaran, Vivek Singh Solanki, Shubham Mittal
  • Patent number: 10089343
    Abstract: A computer-implemented method for building a hierarchy of elements depending on data disclosed in reports includes identifying one or more areas containing one or more elements in each of multiple reports which contain data, where the elements comprise parent elements and child elements. The method includes parsing the data of each of the elements to simulate relationship operations between the parent elements and the child elements until consistent aggregations are found, identifying data with a same unit and adjusting the data to have a same scale or a same precision, recursively searching the aggregated data by applying the found relationship operations to build a tree structure having at least a portion of the elements of each report built in the tree structure arranged in a hierarchy of elements and storing the tree structure, including a level of each of the elements and the relationship operation.
    Type: Grant
    Filed: November 18, 2015
    Date of Patent: October 2, 2018
    Assignee: SAP SE
    Inventor: Patrick Azoulay
  • Patent number: 10089325
    Abstract: In general, embodiments of the technology relate to a method and system for using micro objects to manage content. More specifically, embodiments of the technology relate to using micro objects to change and/or extend the functionality of the content management system such that the manner in which actions are applied to objects varies based the context of the request that specified an action to be performed on an object.
    Type: Grant
    Filed: June 30, 2015
    Date of Patent: October 2, 2018
    Assignee: Open Text Corporation
    Inventors: Michael Mohen, David Humby, Satyapal P. Reddy
  • Patent number: 10089380
    Abstract: A method is provided comprising: generating, by an electronic device, at least one context information log associated with content stored in a memory; grouping the content into a plurality of groups based on the at least one context information log; adding the plurality of groups to a first list, wherein each of the plurality of groups is associated with a respective time-out period; generating a first screen based on the first list, the first screen including a first group from the plurality; detecting an input to the first screen that selects the first group and in response, adding the first group to a second list; wherein the first group is removed from the first list when the respective time-out period of the first group expires, and the first group persists in the second list after the respective time-out period of the first group expires.
    Type: Grant
    Filed: December 29, 2014
    Date of Patent: October 2, 2018
    Assignee: Samsung Electronics Co., Ltd.
    Inventors: Yeonsun Choi, Hyunkyoung Kim, Yohan Lee, Sunok Kim, Sangwoo Lee, Kyoungmook Choi
  • Patent number: 10061865
    Abstract: An approach is provided to determine answer stability in a question answering (QA) system. In the approach, a question submitted to a question answering (QA) system is selected and data pertaining to a candidate answers generated by the QA system are analyzed. The analysis of the data results in a stability characteristic that pertains to the candidate answers. A confidence value associated with the candidate answers is adjusted based on the respective answer's stability characteristic. One or more of the candidate answers are provided to a requestor based on the adjusted confidence values.
    Type: Grant
    Filed: August 11, 2017
    Date of Patent: August 28, 2018
    Assignee: International Business Machines Corporation
    Inventors: Corville O. Allen, Lisa M. Bradley, Christina R. Carlson, Andrew R. Freed, Roderick C. Henderson
  • Patent number: 10061660
    Abstract: Embodiments provide granular recovery of virtual machine backups by generating the virtual machine backups comprising virtual disks that are configured as iSCSI targets; exposing, with an iSCSI server, the virtual disks as a logical unit number to an iSCSI client; performing SCSI read operations from the virtual disk using defined application program interfaces (APIs); and mounting a backup save set comprising the virtual disk files as a local disk on a computer where data recover is to be performed. Embodiments also emulate virtual disk storage as an iSCSI target by exposing the virtual disk as a logical unit number to an iSCSI client and mounting a backup save set as a local disk in an iSCSI server executing a backup process defining a granularity for data restore operations.
    Type: Grant
    Filed: October 27, 2015
    Date of Patent: August 28, 2018
    Assignee: EMC IP Holding Company LLC
    Inventors: Manjunath Jagannatha, Kiran Mv Kumar, Ravi Shankar Panem, Sridhar Surampudi
  • Patent number: 10055300
    Abstract: Systems and methods for backing up clustered databases such that production backups associated with the clustered databases are restorable with near zero downtime. First data indicative of a backup request of a clustered database is transmitted by a first computing device to a second computing device. The first computing device maps the backup staging disks to each of a plurality of nodes. The second computing device adds the mapped staging disks to a backup staging diskgroup on a primary node. The second computing device mounts the backup staging diskgroup to each of the plurality of nodes. The second computing device executes a full backup from at least one of the plurality of nodes to the backup staging diskgroup. The second computing device transmits a catalog of backup information to a database associated with the first computing device. The first computing device creates a snapshot of the first backup staging disk.
    Type: Grant
    Filed: January 12, 2016
    Date of Patent: August 21, 2018
    Assignee: Actifio, Inc.
    Inventors: Xiangdong Zhang, Madhav Mutalik, Satya Sri Kanth Palaparthi, Yeganjaiah Gottemukkula, Sachindra Kumar, Uday Tekade
  • Patent number: 10055471
    Abstract: A system may store a plurality of first records comprising a first variable in a first data storage format. The system may also store a plurality of second records comprising a second variable in a second data storage format. The first data storage format may have a different data structure than the second data storage format. The system may then generate a catalog including a first location of the first variable and a second location of the second variable. The first location identifies the first data storage format, which is where the first variable is stored. The second location identifies the second data storage format, which is where the second variable is stored. The system may then receive a request to access at least one of the first variable or the second variable and access the first variable and/or the second variable in response to the request.
    Type: Grant
    Filed: November 18, 2015
    Date of Patent: August 21, 2018
    Assignee: AMERICAN EXPRESS TRAVEL RELATED SERVICES COMPANY, INC.
    Inventors: Ambika Aggarwal, Ravi Arasan, Sandeep Bose, Debasish Das, Ravi K. Kaushik, Matthew Kent Meyer, Marimuthu Ponnambalam, Gurusamy Ramasamy, Jeremy D. Seideman
  • Patent number: 10049135
    Abstract: Context-based data analytics based on visual intuition, and generation of information contexts for conducting research, analysis, and/or decision making. A plurality of information objects (IOs) are generated, each IO indicative of a plurality of data points corresponding to an object among objects for which information in a first domain is obtained, by containing information values (IVs) based upon context data, an IV generated based upon a product of each target data point, a relevance value (RV) of the target data point, a confidence value (CV) of the target data point, and a bias value. Visually displaying the IVs in a three dimensional space based on a distance formula to represent a relative relationship indicative of relevance as gravitational forces between the IOs using a set of concentric spheres corresponding to the IOs.
    Type: Grant
    Filed: November 24, 2014
    Date of Patent: August 14, 2018
    Inventor: Ronald Gordon Whitley, Jr.