Database Query Processing Patents (Class 707/769)
  • Patent number: 10291766
    Abstract: An information processing method and apparatus in the field of mobile communications technologies is provided. In the method, a first terminal obtains, during a call with a second terminal by using voice information sent by the second terminal, to-be-obtained information and object information of an object to which the to-be-obtained information belongs. The first terminal determines at least one category to which the to-be-obtained information belongs and determines a group that is in any category of the at least one category and corresponding to the object to which the to-be-obtained information belongs. The first terminal searches information in the corresponding group in any category for target information associated with the object information and processes the target information with no manual searching being performed.
    Type: Grant
    Filed: July 30, 2015
    Date of Patent: May 14, 2019
    Assignee: HUAWEI TECHNOLOGIES CO., LTD.
    Inventors: Wenmei Gao, Hao Jing, Yahui Wang, Xiaojuan Li, Hongrui Jiang, Xiyong Wang
  • Patent number: 10282354
    Abstract: In particular embodiments, a method includes receiving, from a client device associated with a first user of an online social network, an unstructured text query, parsing the text query to identify one or more n-grams, determining a score for each n-gram, wherein the score for each n-gram is a probability that the n-gram corresponds to a particular data object of a plurality of data objects associated with the online social network, identifying one or more data objects based on the scores of their corresponding n-grams, each identified data object corresponding to at least one of the n-grams, and generating one or more structured queries that each comprise references to one or more of the identified data objects.
    Type: Grant
    Filed: September 7, 2016
    Date of Patent: May 7, 2019
    Assignee: Facebook, Inc.
    Inventors: Yofay Kari Lee, Michael Benjamin Cohen, Maxime Boucher, Alisson Gusatti Azzolini, Xiao Li, Lars Eilstrup Rasmussen
  • Patent number: 10284707
    Abstract: An information transmitting method includes the following steps: generating a connecting code and displaying the connecting code on a display of the information sending device; receiving a second unique identity from the server; obtaining contents selected by a user; generating an information sending request; and sending the information sending request to the server. According to above information transmitting method, by establishing a connection between two terminals, or two browser applications, information of different categories can be efficiently transmitted from one terminal to the other terminal. In addition, this disclosure also publishes an information transmitting device and an information transmitting system.
    Type: Grant
    Filed: April 6, 2018
    Date of Patent: May 7, 2019
    Assignee: TENCENT TECHNOLOGY (SHENZHEN) COMPANY LIMITED
    Inventor: Yisha Lu
  • Patent number: 10282442
    Abstract: Data from a database object are processed. Transaction information for a set of data of the database object is stored separate from the set of data in an allocated storage space, where the transaction information indicates visibility of the set of data to other transactions. A map structure is generated indicating storage of the set of data and the allocated storage space of the transaction information. The transaction information is altered in response to a transaction to the set of data to alter visibility of the set of data. Altering the transaction information is accomplished by providing updated transaction information within a new storage space in accordance with the transaction to the set of data and generating a descriptor for the transaction indicating an existing location of the set of data and the new storage space.
    Type: Grant
    Filed: April 21, 2015
    Date of Patent: May 7, 2019
    Assignee: International Business Machines Corporation
    Inventor: Daniel J. Dietterich
  • Patent number: 10275357
    Abstract: In a multi-level cache system, a logic may be responsible for calculating the appropriate sizes for a database cache and a key-value store. Reception circuitry may receive a hit rate for the database cache, a reuse distance for the key-value store, and a user-selected quality of server. An adaption calculator may then calculate a target size for the database cache and a target size for the key-value store. Transmission circuitry may then transmit the target size for the database cache and the target size for the key-value store for use in the multi-level cache system.
    Type: Grant
    Filed: April 11, 2016
    Date of Patent: April 30, 2019
    Assignee: SAMSUNG ELECTRONICS CO., LTD.
    Inventors: Inseok Stephen Choi, Byoung Young Ahn, Yang Seok Ki
  • Patent number: 10277663
    Abstract: Features are provided for the asynchronous transmission of media files that are part of, or otherwise associated with, user-created content posts. The media file transmissions are asynchronous in nature because the media files are transmitted in parallel background processes while users continue creating content posts or performing other computing tasks. The client devices on which the media file transmissions are initiated can manage the establishment of connections to a network-accessible content management system, and also manage the continued transmission of the media files to the content management system while the users perform other tasks using the client devices.
    Type: Grant
    Filed: June 24, 2016
    Date of Patent: April 30, 2019
    Assignee: Amazon Technologies, Inc.
    Inventors: Sohrab Andaz, Aditya Madduri Karanam, Rajendra Kumar Vippagunta
  • Patent number: 10275530
    Abstract: A system and method which may allow a requester to post a search query and get time-sensitive responses from other users who are best suited to respond to the search query. The system may find out such best suited responders based on their location, activity and time affinity/proximity to the search query, and forward the search query to them. The system may then return the responses to the requester. The system may also be able to automatically answer search queries based on users' historical query-response activities. By matching a search query with users knowledgeable about it, the invention may help a requester to get timely and accurate responses to his search query.
    Type: Grant
    Filed: February 2, 2009
    Date of Patent: April 30, 2019
    Assignee: EXCALIBUR IP, LLC
    Inventors: Chris Kalaboukis, Elizabeth F. Churchill, Athellina Athsani
  • Patent number: 10275399
    Abstract: A ValueID corresponding to a value to be searched for in a database column can be determined by finding a match in a dictionary for the database column. A row of an index vector for the database column at which to begin a scan for the ValueID can be identified by reading a ValueID lookup table that maps each unique ValueID to a starting position in the index vector for the database column. The ValueID can not occur in the index vector prior to the starting position. The index vector can be scanned beginning at the starting position to find at least one occurrence of the ValueID corresponding to the value being searched, and a result that includes one or more row locations in the database column corresponding to the at least one occurrence in the index vector of the ValueID corresponding to the value being searched can be returned.
    Type: Grant
    Filed: November 17, 2015
    Date of Patent: April 30, 2019
    Assignee: SAP SE
    Inventors: Peter Steinemann, Thomas Legler
  • Patent number: 10275802
    Abstract: The present disclosure provides a system and method for forecasting client needs using interactive communication. A Messaging server may retrieve client profiles stored in a client database. Messaging server formulates questions to be included in interactive questionnaires or message(s). The messaging server sends the formulated interactive questionnaires to a client computing device. The client computing device sends the responses back to messaging server for updating the client profiles stored in the client database. Forecasting engine employs the updated information in the client profiles to predict client's behavior that may be used for forecasting client needs based on the updated information received from the interactive questionnaire or message(s). Forecasting engine generates financial indicators and needs forecast reports that may be sent to one or more agent computing devices or an automated product matching engine.
    Type: Grant
    Filed: December 19, 2014
    Date of Patent: April 30, 2019
    Assignee: Massachusetts Mutual Life Insurance Company
    Inventors: Gareth Ross, Tricia Walker
  • Patent number: 10275417
    Abstract: A file management system includes a management server, and an electronic device connectable to the management server through a network. The management server includes a first storage unit that stores therein a first workflow that defines first processing, which is executed with a first event as a trigger, for a file, and a first control unit that monitors, based on the first workflow, the first event and executes the first processing if the first event occurs. The electronic device includes a second storage unit that stores therein a second workflow that defines second processing, which is executed with a second event different from the first event as a trigger and in which a final processing operation generates the first event, for the file, and a second control unit that monitors, based on the second workflow, the second event and executes the second processing when the second event occurs.
    Type: Grant
    Filed: January 16, 2015
    Date of Patent: April 30, 2019
    Assignee: Kyocera Document Solutions Inc.
    Inventor: Ayaka Ikejima
  • Patent number: 10268709
    Abstract: Database servers may maintain a database according to a database schema. A database change management system can include a profile service configured to collect database profile information and a simulation service configured to receive a set of changes to be simulated for the database and simulate an application of the set of changes to the database. A forecast service can be configured to receive a result of a simulation from the simulation service and database profile information and generate a report indicative of a prediction of a failure or success of an implementation of the set of changes.
    Type: Grant
    Filed: March 7, 2014
    Date of Patent: April 23, 2019
    Assignee: Datical, Inc.
    Inventors: Charles Steven Suehs, Peter J. Pickerill, Robert E. Reeves, Daniel P. Nelson
  • Patent number: 10268689
    Abstract: A system includes a computing device including a processor programmed to receive data identifying a mental state of a user, the data including at least one of a user physical condition and a user communication. Based on the mental state data, the processor is programmed to assign one or more stored keywords to the user, and provide media content to the user based on the keywords assigned to the user based on the mental state data.
    Type: Grant
    Filed: January 28, 2016
    Date of Patent: April 23, 2019
    Assignee: DISH Technologies L.L.C.
    Inventors: Prakash Subramanian, Nicholas Brandon Newell
  • Patent number: 10270820
    Abstract: Various systems and methods for streaming an impromptu community are described herein. In one example, a system for streaming impromptu communities includes a data storage device, a community analyzer, and a publisher. In an example, the data storage device can store a number of incoming data sets, wherein each data set identifies a time and location for the origin of the data, a media instance, and an identification of an origin device or origin user. In an example, the community analyzer can operate from the data storage device to use a processor in order to calculate an IC boundary and generate an impromptu community (IC) indicator based on the proximity and temporality of the number of incoming data sets. In an example, the processor can modify the number of data sets to include the IC indicator.
    Type: Grant
    Filed: February 2, 2016
    Date of Patent: April 23, 2019
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Gina D. Venolia, John C. Tang, Kori Inkpen, William A. Hamilton
  • Patent number: 10248810
    Abstract: A method of automatically modifying a computer data query is disclosed herein. The modification of the computer data query can be performed to restrict access to data. The computer data query can be modified by receiving the computer data query, identifying tables in the query and retrieving providers associated with the tables identified in the query. These providers can be linked to one or several predicates. These predicates can be retrieved and used to modify the query. The modified query can then be used to retrieve data from one or several tables identified within the query.
    Type: Grant
    Filed: January 23, 2018
    Date of Patent: April 2, 2019
    Assignee: Pearson Education, Inc.
    Inventor: Gary J. Bisaga
  • Patent number: 10250661
    Abstract: In a method of controlling a real-time conference session there is a first user and a second user connected to a media processing unit. The first user has a passive mode wherein data is received at and transmitted by the first users communication terminal as passive data but not received by the communication terminal of the second user and an active mode wherein the data received and transmitted by the first user's terminal and received by the second user's terminal as active data. When the first user switches from the passive mode to the active mode there is a duration of the conference call that is left to be transmitted to the second user. That portion has been recorded and is played at a faster rate to the second user.
    Type: Grant
    Filed: July 9, 2018
    Date of Patent: April 2, 2019
    Assignee: Unify Patente GmbH & Co. KG
    Inventors: Jurgen Totzke, Vasileios Giatilis, Charidimos Tzedakis, Kleoniki Markou, Labros Pappas
  • Patent number: 10248408
    Abstract: A zero downtime upgrade of a source system to a target system is initiated. The source system and the target system operate in a first database layer and a second database layer. Thereafter, differences in structure and/or database type are computed between a source table in the source system and a target table in the target system in each of the two different database layers. The data is then migrated, using the computing differences and in the second database layer, from the source table to the target table. The upgrade procedure is later terminated after completion of the migration of the data. Related apparatus, systems, techniques and articles are also described.
    Type: Grant
    Filed: September 18, 2014
    Date of Patent: April 2, 2019
    Assignee: SAP SE
    Inventors: Steffen Meissner, Juergen Specht
  • Patent number: 10242223
    Abstract: Controlling access to nodes in a relational graph at query time by using an approximate membership query (AMQ) filter and ordered queries based on historic grants or denials of access according to security context enables a more efficient querying of the relational graph while preserving access controls. Security contexts that grant or deny access to a node are stored in an associated AMQ filter and are queried according to the subject's security context in an order based on the frequency at which the security contexts have previously granted or denied access to nodes in the relational graph.
    Type: Grant
    Filed: February 27, 2017
    Date of Patent: March 26, 2019
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Tor Kreutzer, Steffen Viken Valvag, Dag Steinnes Eidesen, Amund Kronen Johansen, Peter Dahle Heen, Jan-Ove Almli Karlberg, Jon Meling, Age Kvalnes
  • Patent number: 10242000
    Abstract: Distributed, consistent utility-preserving data masking is provided by retrieving an original value from a data table; initiating a communication with a mapping service to ascertain whether or not a masking table of the mapping service includes a fictionalized value associated with the original value; when the masking table does not include a fictionalized value associated with the original value, producing a fictionalized value for the original value wherein the fictionalized value preserves at least one utility function of the original value, updating the mapping service to include the fictionalized value in the masking table, and applying a first masking operation by replacing the retrieved original value with the fictionalized value.
    Type: Grant
    Filed: May 27, 2016
    Date of Patent: March 26, 2019
    Assignee: International Business Machines Corporation
    Inventors: Spyridon Antonatos, Stefano Braghin, Aris Gkoulalas-Divanis, Olivier Verscheure
  • Patent number: 10242056
    Abstract: Computer implemented methods for database hierarchy-independent data drilling are presented including: a. selecting one of at least two database structures each having data, where the at least two database structures include, at least two distinct paths that lead from a first of the at least two database structures to a second of the at least two database structures, where a path logically relates at least two data structures which are otherwise directly unrelated using data structures and data structures' relations, and a database information schema that provides information about the at least two database structures including information regarding relations between data structures; b. setting the selected database structure as a current data drilling state; and c. finding at least one related data structure corresponding with the selected database structure for the current data drilling state utilizing the database information schema.
    Type: Grant
    Filed: June 26, 2014
    Date of Patent: March 26, 2019
    Assignee: DATAWALK SPOLKA AKCYJNA
    Inventor: Krystian Piecko
  • Patent number: 10242331
    Abstract: In various implementations, a supplemental system may be provided. The supplemental system may be coupled to business intelligence environment(s) to facilitate visual identification of meaningful differences. In some implementations, expressions to exclude may be identified and specifications associated with BI Artifacts may be instrumented based on the expressions to exclude. Enhanced Business Intelligence Artifact Outputs may be generated to visually identify differences between BI Artifact Outputs that are not associated with expressions to exclude.
    Type: Grant
    Filed: July 28, 2017
    Date of Patent: March 26, 2019
    Assignee: Motio, Inc.
    Inventor: Lance W. Hankins
  • Patent number: 10242258
    Abstract: In an example embodiment, a fuzzy join operation is performed by, for each pair of records, evaluating a first plurality of features for both records in the pair of records by calculating term frequency-inverse term frequency (TF-IDF) for each token of each field relevant to each feature and based on the calculated TF-IDF for each token of each field relevant to each feature, computing a similarity score based on the similarity function by adding a weight assigned to the TF-IDF for any token that appears in both records. Then a graph data structure is created, having a node for each record in the plurality of records and edges between each of the nodes, except, for each record pair having a similarity score that does not transgress a first threshold, causing no edge between the nodes for the record pair to appear in the graph data structure.
    Type: Grant
    Filed: October 30, 2015
    Date of Patent: March 26, 2019
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Songtao Guo, Christopher Matthew Degiere, Aarti Kumar, Alex Ching Lai, Xian Li
  • Patent number: 10237350
    Abstract: A database proxy includes a request processor, a cache, a database plugin, and interfaces for coupling the database proxy client devices, other database proxies, and database servers. The request processor is configured to receive a read request from a client, determine whether the read request is assigned to the database proxy, and return results of the read request to the client. When the read request is not assigned to the database proxy, the read request is forwarded to another database proxy. When the read request is assigned to the database proxy, the read request is processed using data stored in the cache when the results are stored in the cache or forwarded to the database plugin, which forwards the read request to a database server, receives the results from the database server, and returns the results to the request processor for storage in the cache.
    Type: Grant
    Filed: November 7, 2016
    Date of Patent: March 19, 2019
    Assignee: RENIAC, INC.
    Inventors: Chidamber Kulkarni, Aditya Alurkar, Pradeep Mishra, Prasanna Sukumar, Vijaya Raghava, Raushan Raj, Rahul Sachdev, Gurshaant Singh Malik, Ajit Mathew, Prasanna Sundararajan
  • Patent number: 10229212
    Abstract: Examples of the present disclosure describe systems and methods of identifying good and bad abandonment using gesture movement. In aspects, user feedback signals may be received by a client device in response to the viewing and/or navigation of query results. The feedback signals may be provided to a framework for determining and/or analyzing query abandonment. The framework may identify gesture data in the feedback signals and extract feature data from the gesture data. The feature data may be provided to a metrics component to determine metrics and/or satisfaction values for the feature data. The metrics and/or feature data may be used to train a predictive model to identify good abandonment in query results.
    Type: Grant
    Filed: August 8, 2016
    Date of Patent: March 12, 2019
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Imed Zitouni, Ahmed Hassan Awadallah, Aidan Crook, Bradley Wethington, Kyle Williams
  • Patent number: 10229206
    Abstract: One or more techniques and/or systems are provided for augmenting a social snippet with an augmentation tagline. For example, a search user may submit a search query through a search interface (e.g., “algebra help” search query). An entity associated with the search query may be identified (e.g., a math professor). A set of taglines associated with the entity may be retrieved (e.g., descriptive information about the math professor extracted from social networks, documents, websites, etc.). A social snippet for the entity may be augmented with an augmentation tagline selected from the set of taglines or generated based upon information relating to the entity. The augmented social snippet may be displayed through the search interface, and the augmentation tagline may indicate a relevance of the entity to the search user (e.g., an indication that the math professor teaches algebra at a university attended by the search user).
    Type: Grant
    Filed: August 2, 2013
    Date of Patent: March 12, 2019
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Omar Alonso, Vasileios Kandylas, Justin Ormont
  • Patent number: 10223426
    Abstract: Systems are provided for providing a contextualized set of help topics. A user interaction contextualization system receives a search request for help topics from a user device, responsive to which the user interaction contextualization system retrieves an uncontextualized set of help topics from a help topics index. The user interaction contextualization system may collect and analyze contextual data from various data sources, and real-time and historical user engagement data associated with the user. The user interaction contextualization system may then use the collected data to generate a contextualized set of help topics.
    Type: Grant
    Filed: May 25, 2016
    Date of Patent: March 5, 2019
    Assignee: Bank of America Corporation
    Inventors: Cameron Wadley, Jiyoung Choi, Hamid Dalglijli, Thomas H. Judge, Britton T. Farrell, Katherine Dintenfass, Craig Terrill, Susan Varghese, Minh Vuong
  • Patent number: 10216445
    Abstract: One embodiment provides an apparatus. The apparatus include a device storage logic. The device storage logic is to determine a key-based pointer based, at least in part, on a key included in an input key-value (KV) pair received from a host device and to determine whether a unique input KV data block included in the input KV pair is duplicated in a nonvolatile memory circuitry of a storage device.
    Type: Grant
    Filed: June 30, 2017
    Date of Patent: February 26, 2019
    Assignee: Intel Corporation
    Inventors: Peng Li, Jawad B. Khan, Sanjeev N. Trika, Vinodh Gopal
  • Patent number: 10216166
    Abstract: Third party developed control logic for automation controllers is provided to customers using a communication network. At least one tool is provided for a third party to develop control logic for an automation controller. The automation controller is remotely located from the communication network. A hardware platform on which to operate the control logic is selected. Once built, the control logic is linked to at least one operational characteristic of the hardware platform such that the control logic is operable to perform at least one predetermined function of the automation controller using the hardware platform.
    Type: Grant
    Filed: June 29, 2012
    Date of Patent: February 26, 2019
    Assignee: GENERAL ELECTRIC COMPANY
    Inventor: Kenneth Pierson Dickie
  • Patent number: 10217221
    Abstract: A system for place recognition is described herein. The system for place recognition comprises a plurality of sensors, a memory, and a processor. The memory is to store instructions and is communicatively coupled to the plurality of sensors. The processor is communicatively coupled to the plurality of sensors and the memory. When the processor is to execute the instructions, the processor is to detect features in a current frame and extract descriptors of the features of the current frame. The processor is also to generate a vocabulary tree using the descriptors and determine candidate key frames based on the vocabulary tree and detected features. The processor also is to perform place recognition via a first stage matching and a second stage matching.
    Type: Grant
    Filed: September 29, 2016
    Date of Patent: February 26, 2019
    Assignee: Intel Corporation
    Inventors: Haowei Liu, Daniel Joseph Mirota, Samer Samir Barakat, Mohamed Selim Ben Himane
  • Patent number: 10217224
    Abstract: In accordance with some embodiments of the disclosed subject matter, a method and a system for recommending and sharing customized multimedia route planning are provided. The method includes: receiving a query image from a user, the query image containing an object-of-interest of the user, performing an integrative segmentation process to determine one or more contours of the object-of-interest in the query image; determining a route having a maximum area overlap with the one or more contours of object-of-interest on a map image; generating an output image including the object-of-interest and the route; and recommending the output image to the user, and sharing the output image on a social network platform.
    Type: Grant
    Filed: December 22, 2016
    Date of Patent: February 26, 2019
    Assignee: TCL RESEARCH AMERICA INC.
    Inventors: Xinpeng Liao, Xiaobo Ren, Haohong Wang
  • Patent number: 10210263
    Abstract: Methods, systems, and apparatus, for receiving a native application search result that identifies a native application and a first URI that causes the native application to display a native application page that includes content responsive to the query; determining, at the user device, whether the user device has a native application installed that can process the first uniform resource identifier (URI) of the native application search result; in response to determining that the user device does not have a native application installed that can process the first URI, processing, at the user device, a second URI that can be processed by the first application, where the second URI, when processed, causes the first application to display a first application page that includes content responsive to the query; wherein the content included in the first application page and the content included in the native application page are synchronized content.
    Type: Grant
    Filed: June 23, 2015
    Date of Patent: February 19, 2019
    Assignee: Google LLC
    Inventors: Jaehyun Yeom, Dong Ha Lee
  • Patent number: 10209689
    Abstract: A system and approach of importing data from site controllers as history imports with a history service by a supervisor in conjunction with a host processor. The history service may reconfigure the history imports to provide the history service virtually full control over the history imports. The history service may runs a history import cycle to ensure that virtually all enabled history imports are performed. The history service may establish a list of history imports to be processed at a beginning of the history import cycle. The history import cycle may query virtually all history imports in an order on a last success time of a history import operation where an oldest time is first on the list. The history service may ensure a maximum number of history imports are running by querying for a count of history imports of an in progress state.
    Type: Grant
    Filed: September 23, 2015
    Date of Patent: February 19, 2019
    Assignee: Honeywell International Inc.
    Inventors: Jerry Marti, Prabhat Ranjan, Bandi Narayanaswamy
  • Patent number: 10204123
    Abstract: A method for accessing and automatically correlating data from a plurality of external data sources that includes: A) defining at least two sets of data by querying a plurality of existing external data sources using user application software, a central computer and user defined search statements; B) generating a computer program code which provides access to the external data sources; C) loading the sets of data in a memory of the central computer using the computer program code to gain access to the external data sources; D) storing references which specify links to each of the sets of data provided by the external data sources in a data storage of the central computer; and E) automatically correlating data from the sets of data by using the referenced sets of data using at least one rule of correlation included in the user application software.
    Type: Grant
    Filed: January 25, 2013
    Date of Patent: February 12, 2019
    Assignee: DATAWERKS HOLDING GMBH
    Inventor: Oswaldo Cavalcanti Dantas, Jr.
  • Patent number: 10203867
    Abstract: A device displays a listing of items in an item data display area on a display. The device receives an indication of a pinch gesture from a touch-enabled screen and scales a facet of the item data to produce a scaled-facet listing responsive to the pinch gesture. The device scales by modifying a degree of a characteristic corresponding with a facet of the item data displayed in the scaled-data display area in an increasing amount responsive to the pinch-in gesture. The modifying further comprises producing a scaled-out listing implemented as an updated portion of item data having a temporal indicator that is later than an initial display of item data by an amount proportional to a magnitude of a pinch gesture characteristic corresponding to the pinch-in gesture. Finally, the device displays the scaled-facet listing as an updated set of item data.
    Type: Grant
    Filed: May 30, 2014
    Date of Patent: February 12, 2019
    Assignee: eBay Inc.
    Inventors: Han-Shen Yuan, Ryan Melcher, Steve Yankovich
  • Patent number: 10204135
    Abstract: Techniques are described for materializing pre-computed results of expressions. In an embodiment, a set of one or more column units are stored in volatile or non-volatile memory. Each column unit corresponds to a column that belongs to an on-disk table within a database managed by a database server instance and includes data items from the corresponding column. A set of one or more virtual column units, and data that associates the set of one or more column units with the set of one or more virtual column units, are also stored in memory. The set of one or more virtual column units includes a particular virtual column unit storing results that are derived by evaluating an expression on at least one column of the on-disk table.
    Type: Grant
    Filed: May 4, 2016
    Date of Patent: February 12, 2019
    Assignee: Oracle International Corporation
    Inventors: Aurosish Mishra, Shasank K. Chavan, Allison L. Holloway, Jesse Kamp, Ramesh Kumar, Zhen Hua Liu, Niloy Mukherjee, Amit Ganesh, Tirthankar Lahiri, Vineet Marwah
  • Patent number: 10198927
    Abstract: One variation of a method for detecting and handling falls by residents of a facility includes: receiving a notification for a fall event from a resident wearable device associated with a resident; determining a location of the resident within a facility at a time of the fall; in response to the notification, distributing a fall response prompt to a set of computing devices, each computing device associated with a care provider; in response to receipt of a fall response confirmation from a first computing device, deescalating the fall response prompt at a second computing device; and, in response to proximity of the first computing device to the resident wearable device, authorizing edit permissions for an electronic incident report by a first care provider exclusive of a second care provider.
    Type: Grant
    Filed: January 25, 2018
    Date of Patent: February 5, 2019
    Assignee: PHILIPS NORTH AMERICA LLC
    Inventors: Vikram Devdas, Dan Erichsen, Kenneth Wagner, Richard Heaton
  • Patent number: 10200446
    Abstract: A method for user-desired delay estimation for mobile-cloud applications includes: collecting, by a mobile device, data for a mobile application using at least one of sensors, an application logger and a user feedback module of the mobile device; inferring, by the mobile device, a quality of experience based on the collected data; determining, by the mobile device, a desired delay based on the inferred quality of experience; and offloading, by the mobile device, a task to a cloud together with the desired delay.
    Type: Grant
    Filed: March 5, 2015
    Date of Patent: February 5, 2019
    Assignee: DEUTSCHE TELEKOM AG
    Inventors: Pan Hui, Shengkai Zhang, Christoph Peylo
  • Patent number: 10198500
    Abstract: A system and method dynamically analyze documents to determine relevancy of a document relatively quickly and efficiently. Potentially relevant documents can be determined using a search string and then converted into corresponding document data structures for analysis. Keywords can be used to identify documents of interest from the document data structures. Tools are provided to assess the relevancy of documents, including tools to determine the frequency of keywords in the documents, to compare documents, and to contrast documents. Algorithms are provided that use prior searches to determine sets of relevant documents. Adaptive search methods are provided that refine searching during analysis to reduce a number of documents that are not sufficiently relevant. A dynamic relevancy matrix can be generated that provides access to keyword frequency and associated keyword frequency for a plurality of documents.
    Type: Grant
    Filed: March 13, 2018
    Date of Patent: February 5, 2019
    Assignee: Aplix Research, Inc.
    Inventor: Philip Wai-Sin Ching
  • Patent number: 10192200
    Abstract: Contact data for contacts of a user is stored. Each of the contacts is ranked (e.g., based on stored profile information for each contact). In one embodiment, each of the contacts is classified as either a local contact or a directory contact based on the ranking to provide local contacts and directory contacts. The local contacts are provided for local storage on a user device of the user. A directory contact is provided to the user device from the directory contacts by the server (e.g., in response to a query from the user device).
    Type: Grant
    Filed: December 4, 2012
    Date of Patent: January 29, 2019
    Assignee: OATH INC.
    Inventor: Joshua Robert Russell Jacobson
  • Patent number: 10191944
    Abstract: Techniques are provided for de-normalizing semi-structured hierarchical data into a virtual table. At least a portion of semi-structured data document collection is denormalized for improving the execution of queries that involves a traversal of the semi-structured data hierarchy of the semi-structured data document collection, in an embodiment. Based on the extracted schema of the semi-structured data, a de-normalized arrangement is generated, in which the hierarchical relationship of the semi-structured data is converted into a set of columns. The denormalized arrangement is materialized by applying the de-normalized arrangement onto the semi-structured data. The materialized arrangement, the virtual table, may be stored on a persistent storage or kept in volatile memory. The virtual table may be stored in one format on the persistent storage and in another format in the volatile memory.
    Type: Grant
    Filed: March 23, 2016
    Date of Patent: January 29, 2019
    Assignee: Oracle International Corporation
    Inventors: Zhen Hua Liu, Beda Hammerschmidt, Douglas McMahon, Ying Lu
  • Patent number: 10185579
    Abstract: An object persistence mechanism is disclosed that enables the generation of software objects that have persistent data and a mutable key. A mutable key capability is advantageous in a variety of applications, such as monitoring a set of users and their login status on a plurality of media servers (e.g., an email server, an instant messaging server, a voice mail server, a video server, an audio-conferencing server, etc.). Implementations based on the Enterprise JavaBean specification are disclosed for three illustrative embodiments of the present invention. The illustrative embodiments of the present invention can also be implemented in accordance with object persistence mechanisms other than Enterprise JavaBeans.
    Type: Grant
    Filed: May 15, 2006
    Date of Patent: January 22, 2019
    Assignee: Avaya Inc.
    Inventor: Reinhard Peter Klemm
  • Patent number: 10185976
    Abstract: Shopping systems, user interfaces, and methods that provide a user a way to quickly and seamlessly shop and purchase from an advertisement at the moment of discovery of the product(s) within the advertisement. A user can use a mobile device to scan the advertisement using an application that resides on the mobile device. The advertisement is then recognized to determine recognized products appearing in the advertisement. A list of products from the recognized products is then displayed on the display screen of the mobile device to enable the user to shop and, if desired, purchase one or more of the products.
    Type: Grant
    Filed: June 30, 2015
    Date of Patent: January 22, 2019
    Assignee: Target Brands Inc.
    Inventor: Mark Lofthus
  • Patent number: 10180951
    Abstract: A database system may maintain a plurality of log records at a distributed storage system. Each of the plurality of log records may be associated with a respective change to a data page. A snapshot may be generated that is usable to read the data as of a state corresponding to the snapshot. Generating the snapshot may include generating metadata that is indicative of a particular log identifier of a particular one of the log records. Generating the snapshot may be performed without additional reading, copying, or writing of the data.
    Type: Grant
    Filed: March 7, 2014
    Date of Patent: January 15, 2019
    Assignee: Amazon Technologies, Inc.
    Inventors: Anurag Windlass Gupta, Pradeep Jnana Madhavarapu, Samuel James McKelvie, Neal Fachan
  • Patent number: 10169984
    Abstract: A method for transmitting data in a wireless system, wherein the wireless system includes a first server, a relay device, and at least one appliance. The method includes that the relay device is connected to the first server through a local area network; determine whether there is a state information sent from the appliance being stored in the relay device; if so, send the state information to the first server; otherwise, send a first interactive command to the first server, wherein the first interactive command corresponds to a situation that there is no state information being stored in the relay device; send a second interactive command to the first server, and then interrupt a connection with the first server, wherein the second interactive command requests the first server to interrupt a connection with the relay device. Whereby, the first server could determine whether the relay device transmits data normally.
    Type: Grant
    Filed: November 13, 2017
    Date of Patent: January 1, 2019
    Assignee: GRAND MATE CO., LTD.
    Inventors: Chung-Chin Huang, Chin-Ying Huang, Hsin-Ming Huang, Hsing-Hsiung Huang, Yen-Jen Yeh, Yung-She Lin
  • Patent number: 10169438
    Abstract: Determining common table definitions in distributed databases includes receiving a query at a node in a distributed database. The query targets a logical table. Upon determining the logical table is locally defined, one of the local definition and a network definition is selected to use. The network definition is independently established for shared logical table names. The selected definition is used and propagated with the query through the distributed database. Upon determining the logical table is not locally defined, an initial query is issued to other nodes in network to find the network definition for the logical table, the network definition is stored in memory, and the selected definition is propagated through the distributed database with the query.
    Type: Grant
    Filed: January 13, 2016
    Date of Patent: January 1, 2019
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventor: David R. Vyvyan
  • Patent number: 10169472
    Abstract: In one embodiment, a method includes receiving, from a client device that corresponds to a user of an online social network, an input that comprises free-form text; determining, through application of natural-language processing of the free-form text, an affinity declaration for an object associated with the online social network; determining an affinity coefficient between respective user and the object; adjusting the determined affinity coefficient based on social-networking information of the user, wherein the social-networking information reinforces or reduces the determined affinity coefficient; and upon determining that the determined affinity coefficient is above a threshold coefficient, creating or modifying an edge connection in a social graph between a user node corresponding to the user and a concept node corresponding to the object.
    Type: Grant
    Filed: March 13, 2018
    Date of Patent: January 1, 2019
    Assignee: Facebook, Inc.
    Inventor: Erick Tseng
  • Patent number: 10171645
    Abstract: An information transmitting method includes the following steps: generating a connecting code and displaying the connecting code on a display of the information sending device; receiving a second unique identity from the server; obtaining contents selected by a user; generating an information sending request; and sending the information sending request to the server. According to above information transmitting method, by establishing a connection between two terminals, or two browser applications, information of different categories can be efficiently transmitted from one terminal to the other terminal. In addition, this disclosure also publishes an information transmitting device and an information transmitting system.
    Type: Grant
    Filed: July 20, 2017
    Date of Patent: January 1, 2019
    Assignee: TENCENT TECHNOLOGY (SHENZHEN) COMPANY LIMITED
    Inventor: Yisha Lu
  • Patent number: 10169686
    Abstract: A sample set of images is received. Each image in the sample set may be associated with one or more social cues. Correlation of each image in the sample set with an image class is scored based on the one or more social cues associated with the image. Based on the scoring, a training set of images to train a classifier is determined from the sample set. In an embodiment, an extent to which an evaluation set of images correlates with the image class is determined. The determination may comprise ranking a top scoring subset of the evaluation set of images.
    Type: Grant
    Filed: August 5, 2013
    Date of Patent: January 1, 2019
    Assignee: Facebook, Inc.
    Inventors: Lubomir Bourdev, Balamanohar Paluri
  • Patent number: 10169461
    Abstract: One or more processors determine a first amount of data that was provided to a program by a data source. One or more processors analyze a degree of usage of the first amount of data by the program. One or more processors determine a second amount of data that was used by the program based, at least in part, on the degree of usage. The second amount of data is a portion of the first amount of data.
    Type: Grant
    Filed: March 23, 2016
    Date of Patent: January 1, 2019
    Assignee: International Business Machines Corporation
    Inventor: Steve McDuff
  • Patent number: 10169415
    Abstract: Methods, systems, and apparatus, including computer programs encoded on computer storage media, for restarting a query using a token. One of the methods includes receiving, by a computer from a requesting device, a query; determining, using a data storage system, a current result responsive to the query; generating, using the current result, a restart token that represents operations performed to determine a plurality of results responsive to the query including the current result responsive to the query and that can be used to determine a new result responsive to the query that was not included in the plurality of results responsive to the query; and providing, to the requesting device, a message that includes a) first data for the restart token that represents operations performed to determine the plurality of results responsive to the query and b) second data for the current result responsive to the query.
    Type: Grant
    Filed: September 14, 2016
    Date of Patent: January 1, 2019
    Assignee: Google LLC
    Inventors: Yevgeniy Kogan, Rajesh Rao, Sergey Melnik
  • Patent number: RE47384
    Abstract: An information processing apparatus includes a memory that includes a first storage area and a second storage area and a processor that generates link information to access the file stored in the first storage area, in the second storage area associated with the user identification information associated with the first storage area, requests a notification server that transmits a notification, with identification information that identifies a communication apparatus that corresponds to the user identification information associated with the first storage area, and transfers, in response to a request from the communication apparatus that receives the notification, the link information stored in the second storage area associated with the user identification information corresponding to the communication apparatus and that further transfers, in response to access of the file by the communication apparatus using the link information, the file obtained from the first area to the communication apparatus.
    Type: Grant
    Filed: January 31, 2018
    Date of Patent: May 7, 2019
    Assignee: RICOH COMPANY, LTD.
    Inventors: Shuuichi Nakamura, Shinya Mukasa