Data Warehouse, Data Mart, Online Analytical Processing (olap), Decision Support Systems Patents (Class 707/600)
  • Patent number: 10289709
    Abstract: A first block in a page chain can be assigned to a first dictionary for a first column of a database. The page chain can include a plurality of dictionary blocks allocated to a plurality of dictionaries of a plurality of columns including the first column such that the plurality of dictionary blocks is interleaved in the page chain. A new unique value to be added to the first column can be appended to an end of the first dictionary. The plurality of dictionaries can be loaded from the page chain into memory of one or more computers performing operations of a database management system. The loading can include scanning the page chain a single time and assigning the plurality of dictionary blocks to the respective dictionaries of the plurality of dictionaries.
    Type: Grant
    Filed: November 23, 2015
    Date of Patent: May 14, 2019
    Assignee: SAP SE
    Inventors: Steffen Geissinger, Ivan Schreter
  • Patent number: 10263856
    Abstract: Embodiments disclosed herein generally relate to techniques for providing a visualization of connectivity between components in a computer network. One embodiment provides a method which includes receiving a configuration of a network comprising a plurality of components within a physical layer and a virtual layer. The method also includes generating a resource diagram identifying connections that are accessible among the components of the physical layer and components of the virtual layer. The method further includes, upon receiving a selection of one of the components, determining a subset of the plurality of components that are connected to the selected component, and altering the resource diagram to provide a visualization, within the resource diagram, of the connections between the selected component and the determined subset of the plurality of components.
    Type: Grant
    Filed: March 21, 2016
    Date of Patent: April 16, 2019
    Assignee: International Business Machines Corporation
    Inventors: Eric P. Fried, Carol B. Hernandez, Susan T. K. Jasinski, Kyle E. Johnson, Kevin J. Kokal, Andrew J. Lin, Jeremy J. Miller, Natalie J. Miller, Amartey S. Pearson, Joshua R. Teal
  • Patent number: 10262054
    Abstract: The upgrading of a relational database on multiple of machines (e.g., a service) that perform data operations via stored procedures. The upgrade occurs without changing the functionality of the set of one or more stored procedures. Accordingly, even if the machine itself is not upgraded, the machines can still interface with the database via the set of one or more stored procedures. The upgrade of the relational database occurs by adding occur by adding new table(s) to the relational database, and thereafter adding new stored procedures to the stored procedure store, the new stored procedures referencing parameters of the new tables. Since the machines that interface with the relational database can still operate on the upgraded database using the old stored procedures, each machine may then be upgraded in an orderly manner to interface with the new stored procedures.
    Type: Grant
    Filed: January 21, 2016
    Date of Patent: April 16, 2019
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Zhong Zheng, Haibo Lin, Silan Wang
  • Patent number: 10262017
    Abstract: Provided are methods, systems, and computer readable media for user interaction with database methods and systems. In an aspect, a user interface can be generated to permit dynamic display generation to view data. The system can comprise a visualization component to dynamically generate one or more visual representations of the data to present in the state space.
    Type: Grant
    Filed: June 28, 2017
    Date of Patent: April 16, 2019
    Assignee: QLIKTECH INTERNATIONAL AB
    Inventor: Håkan Wolgé
  • Patent number: 10257049
    Abstract: Embodiments disclosed herein generally relate to techniques for providing a visualization of connectivity between components in a computer network. One embodiment provides a method which includes receiving a configuration of a network comprising a plurality of components within a physical layer and a virtual layer. The method also includes generating a resource diagram identifying connections that are accessible among the components of the physical layer and components of the virtual layer. The method further includes, upon receiving a selection of one of the components, determining a subset of the plurality of components that are connected to the selected component, and altering the resource diagram to provide a visualization, within the resource diagram, of the connections between the selected component and the determined subset of the plurality of components.
    Type: Grant
    Filed: June 30, 2015
    Date of Patent: April 9, 2019
    Assignee: International Business Machines Corporation
    Inventors: Eric P. Fried, Carol B. Hernandez, Susan T. K. Jasinski, Kyle E. Johnson, Kevin J. Kokal, Andrew J. Lin, Jeremy J. Miller, Natalie J. Miller, Amartey S. Pearson, Joshua R. Teal
  • Patent number: 10242059
    Abstract: A computer-implemented method for executing a query specification can include evaluating the query specification by a first computing device to identify a candidate expression in the query specification to be executed by a second computing device hosting a source of data specified in the candidate expression. A cost estimate for executing the candidate expression at the first computing device is determined. Whether the cost estimate of executing the candidate expression at the first computing device is greater than a threshold is determined. The candidate expression is replaced with a native query function when the cost estimate of executing the candidate expression at the first computing device is greater than the threshold. The native query function can be executed at the second computing device. It can be determined whether a runtime context is necessary, and if necessary, a context parameter is injected into the native query function.
    Type: Grant
    Filed: May 30, 2014
    Date of Patent: March 26, 2019
    Assignee: International Business Machines Corporation
    Inventors: Lin Luo, Martin Petitclerc
  • Patent number: 10225363
    Abstract: Just in time delivery of a consistent user profile to overlapping user sessions, where a first user session issues a request for a first file of a user profile to a server agent. Upon receiving the request, the server agent retrieves the first file from a base user profile, and just in time delivers the retrieved first file to the first user session. The user, via a second user session executing simultaneously with the first user session, issues a request to the server agent for the first file and a second file of the user profile. Upon receiving the request, the server agent identifies a modified version of the first file in a provisional user profile, retrieves the modified first file from the provisional user profile and the second file from the base user profile, and just in time delivers both files to the second user session.
    Type: Grant
    Filed: August 23, 2016
    Date of Patent: March 5, 2019
    Assignee: Citrix Systems, Inc.
    Inventors: Joseph Nord, Richard Hayton
  • Patent number: 10216805
    Abstract: Methods, systems, and apparatus, including computer programs encoded on a computer storage medium, for dynamically generating and configuring pre-aggregated datasets optimized for responding to particular types of data requests made against a large sub-optimal multidimensional dataset are disclosed. A dynamic aggregator monitors the query types and response latencies associated with queries made against the large multidimensional dataset. The dynamic aggregator defines pre-aggregated datasets based on the types of queries received from users and calculates a respective benefit score for each pre-aggregated dataset. The benefit score of each pre-aggregated dataset can be based on the recorded latencies and query count for the pre-aggregated dataset. The dynamic aggregator can decide whether to generate and/or maintain particular pre-aggregated datasets based on the current values of the benefit scores associated with the particular pre-aggregated datasets.
    Type: Grant
    Filed: August 11, 2016
    Date of Patent: February 26, 2019
    Assignee: Google LLC
    Inventors: Chao Cai, Eric W. Ewald, Cameron M. Tangney, Sagnik Nandy
  • Patent number: 10191949
    Abstract: Systems and methods for transforming a similarity matrix used to generate content item recommendation lists are described. The system may determine a weight (used to transform the similarity matrix) sufficient to place one or more content items on the content item recommendation list or at a particular position on the recommendation list. The transformed similarity matrix may further be reduced in size, and content recommendations may be generated using the transformed or reduced similarity matrix.
    Type: Grant
    Filed: June 18, 2015
    Date of Patent: January 29, 2019
    Assignees: NBCUniversal Media, LLC, Comcast Cable Communications, LLC, Agency for Science, Technology and Research
    Inventors: Sheau Ng, Oliver Jojic, Amit Bagga, Hassan Sayyadi-Harikandehei, Sujoy Roy, Wei Yun Yau, Kong Wah Wan
  • Patent number: 10186058
    Abstract: Various techniques for visualizing cross-pivoted tables are disclosed herein. In one embodiment, a method includes determining if a first dimension and a second dimension of a cross-pivoted table contain non-numerical values, the cross-pivoted table having a plurality of data points each dependent upon a first value in the first dimension and a second value in the second dimension. In response to determining that the first dimension and the second dimension contain non-numerical first and second values, the non-numerical first and second values can be converted to corresponding numerical first and second values. The method can then include plotting, on a display, a visual representation of the plurality of data points of the cross-pivoted table using the numerical first and second numerical values as first and second axis, respectively.
    Type: Grant
    Filed: November 11, 2015
    Date of Patent: January 22, 2019
    Assignee: Microsoft Technology Licensing, LLC
    Inventors: Igor Peev, Ehab Sobhy, Lewey Geselowitz, Paavany Jayanty
  • Patent number: 10187481
    Abstract: In one embodiment, a method includes a server computing device receiving several notifications from several different software applications on a client computing device associated with a user. A notification is sent by a software application on a client computing, indicates a user interaction with a software application has occurred, and identifies the application sending the notification. The server correlates each received notification with the appropriate user and stores information associated with the correlated notification.
    Type: Grant
    Filed: December 12, 2012
    Date of Patent: January 22, 2019
    Assignee: Facebook, Inc.
    Inventors: Teck Chia, Deborah Liu, Vijaye Raji
  • Patent number: 10176827
    Abstract: Various embodiments provide a tool, referred to herein as “Active Lab” that can be used to develop, debug, and maintain knowledge bases. These knowledge bases (KBs) can then engage various applications, technology, and communications protocols for the purpose of task automation, real time alerting, system integration, knowledge acquisition, and various forms of peer influence. In at least some embodiments, a KB is used as a virtual assistant that any real person can interact with using their own natural language. The KB can then respond and react however the user wants: answering questions, activating applications, or responding to actions on a web page.
    Type: Grant
    Filed: January 15, 2008
    Date of Patent: January 8, 2019
    Assignee: VERINT AMERICAS INC.
    Inventor: Tanya M. Miller
  • Patent number: 10169406
    Abstract: Embodiments of the present invention relate to a method, program product, and system for managing the percentage of unpopulated cells in a multidimensional data structure during the servicing of multidimensional analytical queries. In an embodiment, a multidimensional data structure is stored in a memory location of a computing device, wherein the multidimensional data structure includes a dimension that is a subset of a plurality of dimensions included in a relational database. The computing device determines a frequency of utilization of a dimension to service a multidimensional query request. The computing device combines the dimension with the multidimensional data structure responsive to the frequency of utilization.
    Type: Grant
    Filed: September 17, 2014
    Date of Patent: January 1, 2019
    Assignee: International Business Machines Corporation
    Inventors: Vijay Bharti, Jeremiah Joseph, Hemant K. Sivaswamy, Kamalpreet Sapna, Rohit Jain
  • Patent number: 10157393
    Abstract: In at least one embodiment, a trust rating system and method provide a precise and accurate, structured (yet adaptable and flexible), quantifying way of expressing historical trustworthiness so the user or decision maker can make more informed decisions on the data or information being evaluated.
    Type: Grant
    Filed: October 12, 2016
    Date of Patent: December 18, 2018
    Assignee: Right90, Inc.
    Inventor: Dean Skelton
  • Patent number: 10147173
    Abstract: A method for identifying a plurality of features of interest in a seismic image includes ranking each feature of interest. The method also includes modeling a relationship between the rank of each feature of interest and a user rating of the feature of interest. The method further includes updating the ranking of the plurality of features of interest, including (1) receiving a user rating for one feature of interest that has not been previously rated by a user; (2) updating the model of the relationship between the rank of each feature of interest and the user rating of the feature of interest based on the user rating; (3) applying the model to the ranking of the plurality of features of interest; and (4) repeating steps (1)-(3) until a termination criterion is met.
    Type: Grant
    Filed: December 31, 2015
    Date of Patent: December 4, 2018
    Assignees: GENERAL ELECTRIC COMPANY, EXXONMOBIL UPSTREAM RESEARCH COMPANY
    Inventors: Xiaojie Huang, Ali Can, Shubao Liu, Mark W. Dobin, Mary Johns, Leslie A. Wahrmund
  • Patent number: 10140360
    Abstract: The present inventors devised, among other things, an online legal research system with improved user controls. One exemplary system allows users to enter a query in a query input region that automatically expands to accommodate the length of the query field. The exemplary system also responds to the query by automatically directing it to an appropriate database, saving the user from having to choose among the myriad databases within the system. The exemplary system also provides user-specific folders for not only selected documents or excerpts from documents, but also annotating these documents with notes. The system enables the user to determine whether to make the notes private or publicly available.
    Type: Grant
    Filed: December 31, 2008
    Date of Patent: November 27, 2018
    Assignee: Thomson Reuters Global Resources Unlimited Company
    Inventor: Michael Dahn
  • Patent number: 10127503
    Abstract: A set of available values is obtained corresponding to a set of data fields associated with a dimension member in a set of dimension members corresponding to a dimension in a set of dimensions of an object. Each possible combination of dimension members is computed for the object. For a data field of a dimension member of a dimension, a normalized value is computed based on values of the data field for each dimension member in the dimension. A combined data field value is computed for a possible combination of the object as a product of the normalized value of the data field in each dimension member that participates in the possible combination. A set of combined data field values corresponding to all possible combinations is analyzed to identify a possible combination having a property. A control component of a physical environment is adjusted according to the identified possible combination.
    Type: Grant
    Filed: October 21, 2015
    Date of Patent: November 13, 2018
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventor: William J. Hladik, Jr.
  • Patent number: 10108799
    Abstract: A method for security auditing of database transactions is provided in the illustrative embodiments. For a specified period, an available capacity of a computing resource in a data processing system usable to analyze a database protocol packet. The database protocol packet is stored in a shared memory during a data communication. A number of database protocol packets expected in the shared memory during the specified period is determined. Determining a second number of database protocol packets that can be analyzed using the available capacity of the computing resource is computed. During the specified period, the second number of database protocol packets is caused to be selected from every number of database protocol packets stored in the shared memory for analysis using the computing resource during the specified period.
    Type: Grant
    Filed: August 27, 2015
    Date of Patent: October 23, 2018
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventor: Leonid Rodniansky
  • Patent number: 10095790
    Abstract: A centralized control center system for searching and managing one or more objects on granular object level in one or more datacenters is provided. The control center system includes a memory unit, and a processor. The memory unit stores a database and a set of modules. The processor executes the set of modules. The set of modules includes a search module, a topology view module, and an orphan object visibility module. The search module is configured to search and retrieve the one or more objects based on a search query. The topology view module is configured to display the one or more objects connected to the one or more datacenters in a hierarchy. The orphan object visibility module is configured to display (i) an object without a parent object, and (ii) a pool without a parent pool.
    Type: Grant
    Filed: July 14, 2015
    Date of Patent: October 9, 2018
    Inventors: Anand Purusothaman, Murali Palanisamy
  • Patent number: 10095733
    Abstract: A database processing system can support applications of an online transaction processing (OLTP) archetype and of an online analytical processing (OLAP) archetype. Hybrid archetypes can also be supported to implement hybrid scenarios. Requests for services are routed to an appropriate engine for fulfillment. User interface assets can be served by a shared infrastructure. Seamless navigation from one archetype to another can be supported in an insight-to-action scenario.
    Type: Grant
    Filed: October 7, 2014
    Date of Patent: October 9, 2018
    Assignee: SAP SE
    Inventors: Frank Brunswig, Holger Bohle, Markus Cherdron, Reiner Hammerich, Alexander Lingg, Hans-Juergen Richstein, Tobias Stein, Gregor Tielsch, Luc Walterthum
  • Patent number: 10095741
    Abstract: The disclosed embodiments relate to a system that updates a context that facilitates evaluating qualitative search terms for an attribute during query processing. During operation, the system extracts a value for the attribute from each data item in a set of data items. Next, the system updates the context based on the extracted attribute values, wherein the context includes a concept-mapping for one or more qualitative search terms applied to the attribute, and wherein each concept-mapping associates a given attribute value with a numerical compatibility index that indicates a compatibility between the given attribute value and a corresponding qualitative search term.
    Type: Grant
    Filed: June 3, 2015
    Date of Patent: October 9, 2018
    Assignee: Splunk, Inc.
    Inventors: Michael E. Cormier, William E. Thackrey, Earl D. Cox
  • Patent number: 10078685
    Abstract: Data gathering and re-presentation tools provided by a service to a client organization enable data to be acquired in an automated manner from a multiplicity of systems (e.g., proprietary databases and other data storage, handling, and management systems) and then re-present the acquired data in any layout and in format in accordance with specifications provided by the client and/or third party. The tools execute routines to validate the acquired data to ensure its completeness and logical accuracy as well as enrich the data with data from other sources or data that is derived from the acquired data. The processed data is organized and transformed into specified end states and routed to appropriate recipients in the client organization.
    Type: Grant
    Filed: January 9, 2013
    Date of Patent: September 18, 2018
    Inventors: W. C. Taylor, III, Michael S. Ackerman, Devlin P. McConagly
  • Patent number: 10055747
    Abstract: A consumer portal enables consumers to review data collected about those consumers in a privacy-protected manner, through authentication using personally identifiable information (PII) and a linking service supported by a marketing database. Once consumers review this data, they may then edit this data or determine whether they wish it to be used for marketing purposes. They are also presented with various opt-out facilities. The consumer portal is accessible by computers, tablets, smartphones, and other computing devices with Internet-access capabilities.
    Type: Grant
    Filed: June 18, 2014
    Date of Patent: August 21, 2018
    Assignee: Acxiom Corporation
    Inventors: Rochelle Sherman, Joshua Freeman, Jennifer Barrett Glasgow, David Nash, Ann Kennedy
  • Patent number: 10055135
    Abstract: An apparatus comprises a processor to receive a plurality of values of a data set, the data set comprising a first value, a second value, and a third value; calculate and store a first delta corresponding to the first value, wherein the first delta is equal to the difference between the first value and the second value; and calculate and store a second delta corresponding to the second value, wherein the second delta is equal to the difference between the second value and the third value.
    Type: Grant
    Filed: August 18, 2016
    Date of Patent: August 21, 2018
    Assignee: Intel Corporation
    Inventors: James D. Guilford, Vinodh Gopal
  • Patent number: 10042911
    Abstract: Methods and arrangements for discovering entity types for a set of records. A set of records is input, with each record comprising attributes with associated attribute values. The records are grouped into candidate entity types in view of at least one of: the attribute values of the records, at least one domain ontology and at least one dimension hierarchy. An interestingness measure of each candidate entity type is calculated, via estimating interestingness based on at least one factor selected from the group consisting of: a correlation between attribute values of records, a number of attributes, a log of queries issued to a server, and an average group size for candidate entity types. At least one candidate entity type is validated based on the calculated interestingness measures. Other variants and embodiments are broadly contemplated herein.
    Type: Grant
    Filed: July 30, 2013
    Date of Patent: August 7, 2018
    Assignee: International Business Machines Corporations
    Inventors: Prasad M. Deshpande, Salil R. Joshi, Mukesh Kumar Mohania, Karin Murthy, Scott Schumacher, Bruhathi H. Sundarmurthy
  • Patent number: 10033714
    Abstract: A computer-implemented method for generating a contextual panel interface with a first interactive display portion for depicting a plurality of selectable datasets associated with the query context, a second interactive display portion for depicting a plurality of selectable measures associated with the query context and with at least one of the plurality of selectable datasets, a third interactive display portion for depicting a plurality of selectable dimensions associated with the query context and with at least one of the plurality of selectable datasets, and an interactive tool display portion configured to determine a query context in response to receiving a search query and to populate the first, second, and third interactive display portions.
    Type: Grant
    Filed: September 17, 2015
    Date of Patent: July 24, 2018
    Assignee: Business Objects Software, Ltd
    Inventor: Alexis Naibo
  • Patent number: 9996536
    Abstract: Aspects include creating a profile for a user from user account data and a user activity log, searching an indexed repository for keywords matching elements from the user account data and the user activity log, and retrieving documents from the indexed repository that are identified based on the searching. Aspects further include creating a custom portal for the user that includes the documents.
    Type: Grant
    Filed: November 10, 2017
    Date of Patent: June 12, 2018
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Donna K. Byron, Renee F. Decker, Suzanne L. Estrada, Aditya S. Gaitonde, Daniel M. Jamrog, John A. Morganti, Samir J. Patel, Joseph F. Zaffarano
  • Patent number: 9886347
    Abstract: According to an aspect, a database management system (DBMS) is operated to perform data replication. The DBMS includes a source database and a target database. The source database includes a plurality of first tables respectively comprising one or more first columns, and the target database includes a plurality of second tables respectively comprising one or more second columns. Each of multiple ones of the first columns is mapped to one of the second columns, and each one of the second columns is adapted to store replicated data changes of the first column mapped to the second column. Each of the second columns has an assigned update time, the update time being a moment in time when the second column most recently received incremental data changes from its mapped first column. The DBMS operates to process requested database statements while providing data replication.
    Type: Grant
    Filed: January 8, 2015
    Date of Patent: February 6, 2018
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Namik Hrle, Daniel Martin, Chandrasekaran Mohan, Sunil K. Sarin, James D. Spyker, Yongfeng Yao
  • Patent number: 9853913
    Abstract: Provisioning resources into the cloud is a constantly increasing technical challenge as more cloud service providers emerge, each offering disparate computing platforms, services, assets, supported technical components, and other features. A multi-cloud network proxy controls and normalizes the tagging data applicable across the multiple cloud service providers. The network proxy provides a central control mechanism for discovering, monitoring, and updating complex tagging data applied to the technical components provisioned with the cloud service providers. The network proxy also dynamically generates technical component request interfaces that include specifically prioritized metadata tags.
    Type: Grant
    Filed: August 25, 2015
    Date of Patent: December 26, 2017
    Assignee: Accenture Global Services Limited
    Inventors: Roger Foskett, Catherine Ruth Gulsvig Wood
  • Patent number: 9805081
    Abstract: A system and method for record linkage includes performing an entity augmentation process for linking new data records with existing entities in a database. Performing the entity augmentation process includes performing an exact matching sub-process that includes accessing existing entity unique identifier (UID) keys in a memory cache layer and comparing a new data record UID key to the existing entity UID keys.
    Type: Grant
    Filed: March 10, 2014
    Date of Patent: October 31, 2017
    Assignee: ZEPHYR HEALTH, INC.
    Inventors: Tony C. Scott, Cesar Augusto Arevalo Aguilera, Aaron A. Chaiclin, Sven Christoffer Junkergard
  • Patent number: 9807064
    Abstract: A method is provided for performing distributed backup and retrieval of data. Data is sent by a plurality of client devices to be processed by a server and then stored in a database. A subset of the processed data stored in the database is backed up to each of the plurality of client devices. For the one or more particular client devices owned by a user, the subset of processed data stored on the one or more particular client devices is the subset of processed data that is associated with the user. The server and client device is updated to maintain the same state of processed data in the database and the backup. In the event of failure of either the database or a client device, processed data may be restored using the processed data stored on the database or the backup stored on the plurality of client devices.
    Type: Grant
    Filed: February 1, 2016
    Date of Patent: October 31, 2017
    Assignee: TiVo Solutioins Inc.
    Inventors: James Barton, Brain Beach, Adam Feder
  • Patent number: 9785404
    Abstract: Computer-implemented systems, methods, and computer-readable media for analyzing data in one or more artifacts and creating a modifiable data network includes: extracting the key elements from the one or more artifacts; identifying relationship among the key elements for each of the one or more artifacts; determining a first frequency of each of the key elements; determining a second frequency for each relationship among the key elements; creating a data network showing the key elements and the relationship among the key elements; and enabling a user to modify the data network based on one or more of: the key elements; the relationship among the key elements; the first frequency; and the second frequency.
    Type: Grant
    Filed: May 22, 2013
    Date of Patent: October 10, 2017
    Assignee: Infosys Limited
    Inventor: Sanal Kumar Sundaresan Nair
  • Patent number: 9786170
    Abstract: Embodiments are disclosed for scheduling and presenting notifications, via an in-vehicle computing system, to a driver of a vehicle. In some embodiments, a method for an in-vehicle computing system includes receiving data regarding a notification for presentation to a driver of a vehicle. The method further includes, based on a driver profile, adjusting a timing of presenting the notification to the driver via the in-vehicle computing system, wherein the driver profile is generated based on past driving behavior associated with the driver.
    Type: Grant
    Filed: January 6, 2015
    Date of Patent: October 10, 2017
    Assignee: Harman International Industries, Incorporated
    Inventors: Tirtha Roy, William Taranowski, Ilya Pautov, Ryan Speer
  • Patent number: 9747312
    Abstract: Computer implemented methods for storing ad hoc relations between previously unrelated database objects assigned to different database structures using an electronic computing device are presented, the methods including: causing the electronic computing device to define at least three database structures: structure A, structure B and structure C, where each of the at least three database structures each includes a number of objects, where there exists at least one relation between objects of structure A and objects of structure B, and where there exists at least one relation between objects of structure B and objects of structure C; filtering data of structure A; accessing structure B using a first selected relation between structure A and structure B; storing information about filtering of structure A and information on a first selected path between structure A and structure B; filtering results obtained from structure B.
    Type: Grant
    Filed: August 27, 2014
    Date of Patent: August 29, 2017
    Assignee: PILAB S.A.
    Inventor: Krystian Piecko
  • Patent number: 9727597
    Abstract: Provided are methods, systems, and computer readable media for user interaction with database methods and systems. In an aspect, a user interface can be generated to permit dynamic display generation to view data. The system can comprise a visualization component to dynamically generate one or more visual representations of the data to present in the state space.
    Type: Grant
    Filed: May 20, 2014
    Date of Patent: August 8, 2017
    Assignee: QLIKTECH INTERNATIONAL AB
    Inventor: Håkan Wolgé
  • Patent number: 9727613
    Abstract: Embodiments of the present application relate to a distributed data stream processing method, a distributed data stream processing device, a computer program product for processing a raw data stream and a distributed data stream processing system. A distributed data stream processing method is provided. The method includes dividing a raw data stream into a real-time data stream and historical data streams, processing the real-time data stream and the historical data streams in parallel, separately generating respective results of the processing of the real-time data stream and the historical data streams, and integrating the generated processing results.
    Type: Grant
    Filed: December 21, 2015
    Date of Patent: August 8, 2017
    Assignee: Alibaba Group Holding Limited
    Inventors: Xu Zhang, Zhixiong Yang, Jia Xu, Zhonghua Deng
  • Patent number: 9690834
    Abstract: Methods for data management and corresponding systems and computer-readable mediums. A method includes receiving first native data in a first native format associated with a first native application. The method includes converting and storing the first native data in a transfer format as first transfer data. The method includes parsing the first transfer data to produce first converted data, in a converted format, that corresponds to the first native data. The method includes building a first native application model, corresponding to the first native data, according to the first converted data. The method includes displaying the first native application model in a view corresponding to the first native application.
    Type: Grant
    Filed: March 3, 2015
    Date of Patent: June 27, 2017
    Assignee: SIEMENS PRODUCT LIFECYCLE MANAGEMENT SOFTWARE INC.
    Inventors: Basavaraju Chandra, Srinivas Tennety, Ganesh Chormule
  • Patent number: 9686149
    Abstract: An information processing system includes an information processing device, a storage unit, a relay unit, and an update unit. The information processing device is an element of an information processing system. The storage unit stores integral information obtained by integrating information about the information processing device expressed as component information of the information processing system. The relay unit receives communication information including an update command for updating of the component information addressed to the information processing device, and transmits first communication information including the update command addressed to the information processing device and second communication information including the update command. The update unit receives the second communication information, and updates the integral information based on an update command included in the second communication information.
    Type: Grant
    Filed: August 8, 2013
    Date of Patent: June 20, 2017
    Assignee: FUJITSU LIMITED
    Inventors: Shinya Kitajima, Yasuhide Matsumoto, Shinji Kikuchi, Yukihiro Watanabe, Fumi Iikura
  • Patent number: 9665365
    Abstract: A method for transparently upgrading derived database objects commences upon analysis of the data dictionary definition for an initial derived database object as compared to the data dictionary definition for a patched derived database object, then determining if a regenerated instance of the derived database object would be logically different from the initial derived database object. The determination is based on comparisons of the definitions of the initial derived database objects and patched definitions of respective database objects. The method produces a regenerated instance of the derived database object when a regenerated instance of the patched derived database object would be logically different from the initial derived database object. The method will suppress the production of a regenerated instance when a regenerated instance of the derived database object would not be logically different from the initial derived database object.
    Type: Grant
    Filed: August 11, 2015
    Date of Patent: May 30, 2017
    Assignee: ORACLE INTERNATIONAL CORPORATION
    Inventors: George Buzsaki, Murali Krishna Kumanduri, Mark Warren
  • Patent number: 9652287
    Abstract: Among other things, requests are received for tasks to be performed in a database. The tasks include tasks that will cause changes in data of the database and other tasks that must be executed on data in the database that is consistent time-wise. At least some of the data that will be changed by the change-causing tasks comprises data that must remain time-wise consistent for the other tasks. The other tasks are executed in the database while the change-causing tasks are also being executed in the database, without requiring a replication or reconfiguration of the database.
    Type: Grant
    Filed: January 5, 2015
    Date of Patent: May 16, 2017
    Assignee: Miosoft Corporation
    Inventors: Mark D. A. van Gulik, Todd Lyle Smith, Jordan Paul Barrette, Albert B. Barabas, Ernst M. Siepmann
  • Patent number: 9639596
    Abstract: Processing data of a data warehouse is provided and includes receiving, by a processing device, user input to create simple filter objects. Each filter object defines an ad hoc subset of a respective dimension of a dimension table of the data warehouse. User input is received to create a filtered operation object that specifies an operation and a plurality of the simple filter objects. The ad hoc subset differs from all subsets defined in the dimension table.
    Type: Grant
    Filed: October 9, 2015
    Date of Patent: May 2, 2017
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Iliyana P. Ivanova, Christoph Lingenfelder, Christoph H. Sieb, Simone Zerfass
  • Patent number: 9633059
    Abstract: A computer program product to optimize a database is provided. A processor determines a frequency of search for a plurality of columns in a table. A processor determines a length of the plurality of columns. A processor determines a rank for the plurality of columns based, at least in part, on both the frequency of search and the length of the plurality of columns. A processor generates a first set of combinations of the plurality of columns. A processor determines an optimization of the first set of combinations of the plurality of columns. A processor selects an optimal combination of the first set of combinations, wherein the optimization of the optimal combination is greater than the optimization for all other combinations in the first set of combinations. A processor moves the plurality of columns excluded from the optimal combination.
    Type: Grant
    Filed: August 11, 2016
    Date of Patent: April 25, 2017
    Assignee: International Business Machines Corporation
    Inventors: Shuo Li, Shu Hua Liu, Xin Ying Yang, Jian W. Zhang
  • Patent number: 9621539
    Abstract: A method and apparatus for secure access to a computer network and for safeguarding the confidentiality and privacy of data stored and distributed by the network is disclosed. The method and apparatus addresses both limiting access to the computer network to those who are authorized to have access as well as the privacy of the information stored in the network.
    Type: Grant
    Filed: January 30, 2004
    Date of Patent: April 11, 2017
    Inventors: William H. Shawn, Frederick J. Murphy
  • Patent number: 9619501
    Abstract: The index scan device acquires information on a search space in a multi-dimensional space corresponding to a search range of a query; sets, as a search point, a data point corresponding to at least one of a minimum and a maximum of values obtained by changing each data point in the multi-dimensional space to be one-dimensional, from among data points contained in the search space or the partial search space; identifies index data associated with a partial space containing the search point; estimates a boundary line passing through the search space on the basis of identification information on the partial space obtained from the identified index data; and determines, from among divided search spaces obtained by dividing the search space by the estimated boundary line.
    Type: Grant
    Filed: January 10, 2013
    Date of Patent: April 11, 2017
    Assignee: NEC Corporation
    Inventor: Shoji Nishimura
  • Patent number: 9613228
    Abstract: Architecture that provides a secure environment in which data (e.g., code, instructions, files, images, etc.) can be opened and run by a client application. Once opened the data can be viewed (in a “protected view”) by the user without incurring risk to other client processing and systems. Accordingly, the architecture mitigates malicious attacks by enabling users to preview untrusted and potentially harmful data (e.g., files) in a low risk manner. Files opened in the protected view are isolated from accessing key resources on the client computer and provides the user a safer way to read files that can contain dangerous content. The protected view also provides a seamless user experience. The user is unaware that the client is operating on data in a different mode and allows for the reduction of security prompts.
    Type: Grant
    Filed: March 18, 2015
    Date of Patent: April 4, 2017
    Assignee: MICROSOFT TECHNOLOGY LICENSING, LLC
    Inventors: Vikas Malhotra, Benjamin E. Canning, Daniel B. Jump, David C LeBlanc, Benjamen E. Ross, James Campbell, Brian Carver, Joshua Pollock
  • Patent number: 9600389
    Abstract: A method and associated system for method for generating performance and capacity statistics that consists of a processor receiving statistical information from a set of monitoring entities that monitor characteristics of one or more computing resources. The processor formats the received statistics for storage in a raw-data repository, then filters and processes the data to extract data items necessary to generate predefined reports and to place the extracted data in a format consistent with historical information. The processor then merges the filtered, formatted data with the historical information to create an integrated history of the characteristics and stores the integrated history in a history repository. This integrated history is automatically translated into reports customized to requirements of particular support personnel, which are then forwarded to local devices from which the support personnel may select, customize, and review the reports.
    Type: Grant
    Filed: January 29, 2014
    Date of Patent: March 21, 2017
    Assignee: International Business Machines Corporation
    Inventors: Aldair F. Filho, Phillip Sung Won Oh
  • Patent number: 9576266
    Abstract: A material harmonization disposition system is provided to harmonize disparate material databases by identifying volumes of common database inventory parts and operating as a database authorizing tool for declaring and recording common inventory parts in categorized manner for disposition.
    Type: Grant
    Filed: March 15, 2013
    Date of Patent: February 21, 2017
    Assignee: UNITED AIRLINES, INC.
    Inventors: Fred Meyer, Thao Phan, Edward F. Pozzi, Jr.
  • Patent number: 9569469
    Abstract: Methods and systems are provided for populating a database with data associated with a specific task. The method comprises creating a work package specification for a work package associated with the specific task, creating a task specification within the work package specification, creating a view specification within the task specification, and creating a task network comprising tasks that when performed in a desired sequence populates the database with the data associated with the specific task.
    Type: Grant
    Filed: July 26, 2013
    Date of Patent: February 14, 2017
    Assignee: HONEYWELL INTERNATIONAL INC.
    Inventors: Jeff vanderZweep, Nagabhushana Rao Begur, Tim Felke, Raghupathy Kolandavelu
  • Patent number: 9542469
    Abstract: In the context of data administration in enterprises, an effective manner of providing a central data warehouse, particularly via employing a tool that helps by analyzing existing data and reports from different business units. In accordance with at least one embodiment of the invention, such a tool analyzes the data model of an enterprise and proposes alternatives for building a new data warehouse. The tool, in accordance with at least one embodiment of the invention, models the problem of identifying fact/dimension attributes of a warehouse model as a graph cut on a Dependency Analysis Graph (DAG). The DAG is built using existing data models and the report generation scripts. The tool also uses the DAG for generation of ETL (Extract, Transform Load) scripts that can be used to populate the newly proposed data warehouse from data present in the existing schemas.
    Type: Grant
    Filed: August 25, 2010
    Date of Patent: January 10, 2017
    Assignee: International Business Machines Corporation
    Inventors: Vishal Singh Batra, Manish Anand Bhide, Mukesh Kumar Mohania, Sumit Negi
  • Patent number: 9544704
    Abstract: Disclosed herein are systems, methods, and computer-readable storage device for analyzing a first audiofile, to yield a first analysis, wherein the first analysis identifies a first segment of a first plurality of segments within the first audiofile, the first segment being one of a most interesting segment, a most important segment, a most relevant segment, and a most representative segment. A same analysis can be performed on a second audiofile, to yield a second analysis, wherein the second analysis identifies a second segment of a second plurality of segments within the second audiofile, the second segment comprising one of a most interesting segment, a most important segment, a most relevant segment, and a most representative segment. The first segment is presented as a representative segment of the first audiofile and the second segment is presented as a representative of the second audiofile within a three-dimensional audio space.
    Type: Grant
    Filed: July 16, 2015
    Date of Patent: January 10, 2017
    Assignee: Avaya Inc.
    Inventor: Ajita John