Data Warehouse, Data Mart, Online Analytical Processing (olap), Decision Support Systems Patents (Class 707/600)
-
Patent number: 9621539Abstract: 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: GrantFiled: January 30, 2004Date of Patent: April 11, 2017Inventors: William H. Shawn, Frederick J. Murphy
-
Patent number: 9613228Abstract: 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: GrantFiled: March 18, 2015Date of Patent: April 4, 2017Assignee: MICROSOFT TECHNOLOGY LICENSING, LLCInventors: Vikas Malhotra, Benjamin E. Canning, Daniel B. Jump, David C LeBlanc, Benjamen E. Ross, James Campbell, Brian Carver, Joshua Pollock
-
Patent number: 9600389Abstract: 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: GrantFiled: January 29, 2014Date of Patent: March 21, 2017Assignee: International Business Machines CorporationInventors: Aldair F. Filho, Phillip Sung Won Oh
-
Patent number: 9576266Abstract: 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: GrantFiled: March 15, 2013Date of Patent: February 21, 2017Assignee: UNITED AIRLINES, INC.Inventors: Fred Meyer, Thao Phan, Edward F. Pozzi, Jr.
-
Patent number: 9569469Abstract: 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: GrantFiled: July 26, 2013Date of Patent: February 14, 2017Assignee: HONEYWELL INTERNATIONAL INC.Inventors: Jeff vanderZweep, Nagabhushana Rao Begur, Tim Felke, Raghupathy Kolandavelu
-
Patent number: 9544704Abstract: 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: GrantFiled: July 16, 2015Date of Patent: January 10, 2017Assignee: Avaya Inc.Inventor: Ajita John
-
Patent number: 9542469Abstract: 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: GrantFiled: August 25, 2010Date of Patent: January 10, 2017Assignee: International Business Machines CorporationInventors: Vishal Singh Batra, Manish Anand Bhide, Mukesh Kumar Mohania, Sumit Negi
-
Patent number: 9535979Abstract: A query is received that includes two or more facets of a multidimensional inverted index for a collection of documents. Each document is associated with at least one facet. Generation of the multidimensional inverted index includes creating one or more entries. Each entry includes a combination of two or more facets and a posting list of indications for the documents associated with respective facets of each entry. Each indication identifies a document. Generation of the index also includes determining documents associated with respective facets of the combination of each entry. The multidimensional inverted index is searched for an entry having the combination of two or more facets included in the query and a search result is returned. An indication for a document may be included in a posting list if it is determined that the document is associated with each facet of the combination of facets of the entry.Type: GrantFiled: June 21, 2013Date of Patent: January 3, 2017Assignee: International Business Machines CorporationInventors: Rohan A. Ambasta, Bharath Ganesh, Parag S. Gokhale, Chandrashekhar Jain
-
Patent number: 9507718Abstract: Disclosed are methods, systems, paradigms and structures for managing cache memory in computer systems. Certain caching techniques anticipate queries and caches the data that may be required by the anticipated queries. The queries are predicted based on previously executed queries. The features of the previously executed queries are extracted and correlated to identify a usage pattern of the features. The prediction model predicts queries based on the identified usage pattern of the features. The disclosed method includes purging data from the cache based on predefined eviction policies that are influenced by the predicted queries. The disclosed method supports caching time series data. The disclosed system includes a storage unit that stores previously executed queries and features of the queries.Type: GrantFiled: April 16, 2013Date of Patent: November 29, 2016Assignee: Facebook, Inc.Inventors: Samuel Rash, Timothy Williamson
-
Patent number: 9471613Abstract: Methods and systems allow indexing references to documents of a database according to database reference profiles. Documents may then be located in the database using decoding protocols based on the database reference profiles. To this end, the documents are stored in the database and searchable terms extracted therefrom are associated with posting lists. Each posting list is divided into blocks of M database references. The blocks are encoded according to a pattern that depends on the M database references. A corresponding pointer to a table of encoding patterns is appended to each block. When a query is received for a searchable term, blocks are extracted from a posting list corresponding to the searchable term and a pointer for each block is used to extract a decoding protocol related to an encoding pattern for the block.Type: GrantFiled: August 19, 2015Date of Patent: October 18, 2016Assignee: YANDEX EUROPE AGInventor: Petr Sergeevich Popov
-
Patent number: 9465831Abstract: This technology relates to method and optimization systems for optimizing storage of multi-dimensional data in data storage. The method comprises analyzing a plurality of queries received over period of time from one or more client machines. Then, a query pattern is determined from plurality of queries. Based on query pattern dimensionality of data is identified for determining data storage strategy. The dimensionality is characterized into 11 dimensions comprising 4 standard level dimensions and 7 higher level dimensions. A highest dimension out of 7 higher dimensions is parallel data storage dimension. Based on storage strategy, at least one of data and columns of a table is segmented in data storage. Next, data is stored in remote data storage when data is an element of last higher level dimension. Then, higher level dimensions are fragmented into one or more smaller level dimensions when data is element greater than 11 dimensions.Type: GrantFiled: September 4, 2014Date of Patent: October 11, 2016Assignee: Wipro LimitedInventor: Abhishek Gunjan
-
Patent number: 9466021Abstract: A processing device of an information processing system is configured to detect bursts of activity associated with a particular user, to map the bursts to tasks performed by the user, to generate a user model based on the mapping of bursts to tasks, and to provide personalized query processing to the user based on the user model. The user model may comprise a Hidden Markov Model. In one embodiment, a query is received from the user in a current time window, and a model parameter is obtained. Based on the model parameter, a most likely task for the user in the current time window is identified, and based on the query, the most likely task, and user classification, search results are ranked for presentation to the user. The processing device may be configured to communicate the user model to a cloud service provider, and to receive from the cloud service provider the ranked search results determined based on the user model.Type: GrantFiled: January 15, 2014Date of Patent: October 11, 2016Assignee: EMC CorporationInventors: Jidong Chen, Hang Guo, David Stephen Reiner
-
Patent number: 9460134Abstract: A method, system and computer program product are provided for reorganizing a database table according to a set of queries. More specifically, the table is reorganized such that random I/O is reduced by more tightly grouping together rows in the table associated with each of the referencing queries. This enables more associated rows from a given table relevant to a query to be read into memory for a given I/O operation.Type: GrantFiled: May 29, 2014Date of Patent: October 4, 2016Assignee: International Business Machines CorporationInventor: Brian R. Muras
-
Patent number: 9456317Abstract: A social messaging hub provides communication services including intelligent presence detection messaging for a data enabled device having Internet network access capabilities. In one embodiment, a user is given a registered phone number and has multiple devices with unique IP addressable identifications which serve as a source and destination identifiers of the associated data enabled devices. The hub receives device and default location information, sets geofence boundaries, receives a notification of device positions and then delivers messages based on the proximity of devices to each other and user preferences.Type: GrantFiled: March 4, 2015Date of Patent: September 27, 2016Assignee: Heywire, Inc.Inventor: Adam Kornafeld
-
Patent number: 9442996Abstract: An approach for enabling collaborative development of a database application is provided. Specifically, this approach provides a database development and collaboration tool (DDCT), which can be utilized by multiple developers involved in a particular software project, to enable automated synchronization and database version control by allowing a database development language and data changes to be stored in a metadata form that is general to more than one database management system (DBMS). Each developer is united and able to collaborate through the system, thus ensuring that a change to a database structure and/or data in a static data table created in a particular database language by one developer is automatically incorporated in the overall development process. Furthermore, the DDCT provides the opportunity to maintain a single repository entry for more than one DBMS, which simplifies synchronization.Type: GrantFiled: January 15, 2014Date of Patent: September 13, 2016Assignee: International Business Machines CorporationInventors: Marina A. Greenstein, Galina Grunin, Maria N. Schwenger, Pandikumar Swamikrishnan
-
Patent number: 9442993Abstract: A metadata management system receives metadata changes and automatically updates a metadata architecture which maps the data. The metadata changes may be received through a simple user interface by a user or administrator. Once received, the system may automatically update schemas and data transformation code to process data according to the new data mapping preference. The system may handle metadata updates in a multi-tenant system having one or more applications per tenant, and may update data for a single tenant and 1 or more tenant applications in a multitenancy.Type: GrantFiled: February 11, 2013Date of Patent: September 13, 2016Assignee: DELL PRODUCTS L.P.Inventors: David Tung, Hon Yuk Chan, Ketan Bengali, Sasmita Patra, Ming Chang
-
Patent number: 9430473Abstract: A method 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: GrantFiled: December 22, 2015Date of Patent: August 30, 2016Assignee: International Business Machines CorporationInventors: Shuo Li, Shu Hua Liu, Xin Ying Yang, Jian W. Zhang
-
Patent number: 9418101Abstract: Provided are techniques for generating a relational query. Information is collected from a query specification and a model for an On-Line Analytical Processing (OLAP) query having at least a first expression and a second expression. The collected information is used to generate a relational query to retrieve report data to be used to satisfy the first expression and the second expression.Type: GrantFiled: September 12, 2012Date of Patent: August 16, 2016Assignee: International Business Machines CorporationInventors: Xiaowen He, Lin Luo, Martin Petitclerc
-
Patent number: 9411838Abstract: A method, system and computer program product are provided for reorganizing a database table according to a set of queries. More specifically, the table is reorganized such that random I/O is reduced by more tightly grouping together rows in the table associated with each of the referencing queries. This enables more associated rows from a given table relevant to a query to be read into memory for a given I/O operation.Type: GrantFiled: February 14, 2014Date of Patent: August 9, 2016Assignee: International Business Machines CorporationInventor: Brian R. Muras
-
Patent number: 9413825Abstract: Managing file objects in a data storage system includes providing a plurality of metadata servers, each metadata server having information for only a subset of file objects in the storage system, each subset for each of the metadata servers being less than a total number of file objects for the system and includes providing at least one metadata location server, where an entity accessing a specific file object of the system determines which of the metadata servers contains data for the specific file object by first accessing the at least one metadata location server. Information for the subset of file objects may include a table having file identifiers and metadata location information. The metadata location information may point to data storage for a metadata object for a file.Type: GrantFiled: October 31, 2007Date of Patent: August 9, 2016Assignee: EMC CorporationInventors: Fernando Oliveira, Stephen Fridella, Rossen Dimitrov, Patrick Eaton
-
Patent number: 9378254Abstract: An approach is provided to copy records between tables in a relational database. In the approach, a Structured Query Language (SQL) table COPY statement is received with the COPY statement identifying a source table and a target table. Table column names are retrieved from a metadata that corresponds to the source table. The retrieved table column names are used to generate an SQL statement that includes an INSERT INTO clause pertaining to the target table and a SELECT clause pertaining to the source table, wherein the INSERT INTO clause includes a set of target column names and wherein the SELECT clause includes a set of corresponding source column names.Type: GrantFiled: March 15, 2013Date of Patent: June 28, 2016Assignee: International Business Machines CorporationInventors: Karla Bester, Allan T. Chandler, Mark A. Shewell, Stephen J. Yates
-
Patent number: 9367872Abstract: Embodiments of the present disclosure relate to a data analysis system that may automatically generate memory-efficient clustered data structures, automatically analyze those clustered data structures, automatically tag and group those clustered data structures, and provide results of the automated analysis and grouping in an optimized way to an analyst. The automated analysis of the clustered data structures (also referred to herein as data clusters) may include an automated application of various criteria or rules so as to generate a tiled display of the groups of related data clusters such that the analyst may quickly and efficiently evaluate the groups of data clusters. In particular, the groups of data clusters may be dynamically re-grouped and/or filtered in an interactive user interface so as to enable an analyst to quickly navigate among information associated with various groups of data clusters and efficiently evaluate those data clusters in the context of, for example, a fraud investigation.Type: GrantFiled: December 22, 2014Date of Patent: June 14, 2016Assignee: PALANTIR TECHNOLOGIES INC.Inventors: Alexander Visbal, James Thompson, Marvin Sum, Jason Ma, Bing Jie Fu, Ilya Nepomnyashchiy, Devin Witherspoon, Vicktoria Lai, Steven Berler, Alexei Smaliy, Suchan Lee
-
Patent number: 9361622Abstract: A dashboard application can enable a user to quickly view data (and, in a particular aspect, data from one or more business applications) in an efficient manner. The dashboard application can be used to view data about one or more metrics that reflect the performance of a business, as derived from data maintained (perhaps in an associated data store) by the business application(s). The dashboard application may be configurable by a user to allow the user to select one or more dimensions of the data in order to filter and/or categorize the data for display.Type: GrantFiled: May 9, 2007Date of Patent: June 7, 2016Assignee: ORACLE INTERNATIONAL CORPORATIONInventors: Yu-Feng Gu, Lujiang Liu, Kimberly Jacot, Anthony H. Cheng
-
Patent number: 9348861Abstract: The capturing of change data of deferred updates begins with the receipt of an update request call for one or more changes to a database. A processing of the update request call is deferred until a commit point is issued, where call information associated with the update request call is determined, and the call information is stored and associated with the update request call. During a processing of the commit point, data information for the one or more changes to the database is determined. The data information for the one or more changes is combined with the stored call information associated with the update request call.Type: GrantFiled: September 10, 2013Date of Patent: May 24, 2016Assignee: International Business Machines CorporationInventors: Terry L. Krein, Francis J. Ricchio, Judy Y. Tse, Gregory W. Vance
-
Patent number: 9336246Abstract: According to one embodiment of the present invention, a system determines key relationships between database tables and includes a computer system including at least one processor. The system determines a sampling range for one or more matching columns between first and second database tables. The matching columns satisfy one or more matching criteria and the sampling range is based on quantities of distinct values within the matching columns. Data is sampled from the first and second database tables in accordance with the sampling ranges to determine a sample set. Keys between the first and second database tables are determined based on matching between columns within the sample set. Embodiments of the present invention further include a method and computer program product for determining key relationships between database tables in substantially the same manner described above.Type: GrantFiled: February 28, 2012Date of Patent: May 10, 2016Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Alexander Gorelik, Sharad Santhanam, Lev M. Tsentsiper
-
Patent number: 9275111Abstract: A method, system, and a computer program product for converting asymmetric requests into symmetric requests are disclosed. In a first aspect, the method comprises a computer partitioning a query into a set of partitions along a dimension of a multi-dimensional data source, wherein each partition of the set of partitions comprises more than one member and the query has a query result count. The method includes the computer creating a candidate query for each partition of the set of partitions, wherein each candidate query has a candidate query result count. Responsive to a determination that the query result count is greater than a sum of the candidate query result counts, the method includes the computer substituting the query with the candidate queries.Type: GrantFiled: March 15, 2013Date of Patent: March 1, 2016Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventor: Ahmad E. El-Moslimany
-
Patent number: 9262476Abstract: A system and method of batch query processing includes accumulating data queries in a query holding area of a query assistant running in a computer server, separating the accumulated data queries into a plurality of partitions, ordering the partitions, ordering the accumulated data queries within each of the partitions, and processing the accumulated data queries in an order based on the ordering of the partitions and the ordering of the data queries within each of the partitions. Each of the partitions includes data queries with a respective from-type. Each respective from-type is associated with a combination of storage tables accessed by each of the data queries in a corresponding partition. In some examples, ordering the accumulated data queries within each of the partitions includes processing the data queries in each partition against a test data set and ordering the data queries based on results of the processing.Type: GrantFiled: January 10, 2014Date of Patent: February 16, 2016Assignee: RED HAT, INC.Inventors: Filip Eliá{hacek over (s)}, Filip Nguyen
-
Patent number: 9250963Abstract: 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: GrantFiled: November 19, 2012Date of Patent: February 2, 2016Assignee: Alibaba Group Holding LimitedInventors: Xu Zhang, Zhixiong Yang, Jia Xu, Zhonghua Deng
-
Patent number: 9208463Abstract: One or more processing devices access a service definition for a service provided by one or more entities that each produce machine data or about which machine data is generated. The service definition identifies the entities that provide the service and, for each entity, identifying information for locating machine data pertaining to that entity. The processing devices access a key performance indicator (KPI) for the service that is defined by a search query that produces a value derived from the machine data pertaining to the entities identified in the service definition. The value indicates how the service is performing at a point in time or during a period of time and indicates a state of the KPI. A graphical interface is displayed and an indication of at least one threshold, which defines an end of a range of values representing a state of the KPI, for the KPI is received.Type: GrantFiled: October 30, 2014Date of Patent: December 8, 2015Assignee: Splunk Inc.Inventors: Alok Anant Bhide, Brian John Bingham, Tristan Antonio Fletcher, Brian Reyes
-
Patent number: 9201981Abstract: The various embodiments of the invention provide software and metadata structures for a data processing system and method, for applications such as marketing campaign management, speech recognition and signal processing. An exemplary system embodiment includes a first data repository adapted to store a plurality of entity and attribute data; a second data repository adapted to store a plurality of entity linkage data; a metadata data repository adapted to store a plurality of metadata modules, with a first metadata module having a plurality of selectable parameters, received through a control interface, and having a plurality of metadata linkages to a first subset of metadata modules; and a multidimensional data structure. The control interface may modify the plurality of selectable parameters in response to received control information.Type: GrantFiled: May 24, 2014Date of Patent: December 1, 2015Assignee: Experian Marketing Solutions, Inc.Inventors: Joseph Kevin Anzalone, Nevzat Hurkan Balkir, Len Cavers, Brian L. Foreman
-
Patent number: 9196255Abstract: It is inter alia disclosed to identify one or more target vectors from a plurality of candidate vectors, each candidate vector having sorted elements and being associated with a respective class of one or more code vectors of a codebook and at least one of the candidate vectors being associated with a respective class of two or more code vectors that comprise the respective candidate vector and at least one code vector obtainable from the respective candidate vector by one of permutation and signed permutation, the target vectors having, among all candidate vectors of the plurality of candidate vectors, smallest distances towards a at least sorted representation of an input vector.Type: GrantFiled: November 26, 2010Date of Patent: November 24, 2015Assignee: Nokia Technologies OyInventors: Adriana Vasilache, Lasse Juhani Laaksonen, Anssi Sakari Rämö, Mikko Tapio Tammi
-
Patent number: 9189532Abstract: In accordance with embodiments, there are provided mechanisms and methods for locally defining related reports using a global definition. These mechanisms and methods for locally defining related reports using a global definition can provide a single global definition that is applicable to various reports. The ability to provide such single global definition can enable multiple local definitions that are report specific to be configured, at least in part, using the single global definition.Type: GrantFiled: November 29, 2011Date of Patent: November 17, 2015Assignee: salesforce.com, inc.Inventors: Thomas J. Tobin, Vladislav Eroshin, Zuye Zheng, Patrick Louie, Jeremiah Lu, Arunkumaran Varadharajan
-
Patent number: 9177248Abstract: Techniques for analyzing and synthesizing complex knowledge representations (KRs) may utilize an atomic knowledge representation model including an elemental data structure and knowledge processing rules that are machine-readable. The elemental data structure may include a universal kernel and customized modules, which may represent knowledge that is generally applicable to a population and knowledge that is specifically applicable to individual data consumers, respectively. A method of constructing an elemental data structure may include analyzing first information to identify a first elemental component associated with a data consumer, and adding the first elemental component to a customized module corresponding to the data consumer. The method may also include analyzing second information to identify a second elemental component associated with a population, and adding the second elemental component to the universal kernel.Type: GrantFiled: September 10, 2012Date of Patent: November 3, 2015Assignee: Primal Fusion Inc.Inventors: Peter Joseph Sweeney, Ihab Francis Ilyas
-
Patent number: 9152599Abstract: A method for managing cache memories includes providing a computerized system including a shared data storage system (CS) configured to interact with several local servers that serve applications using respective cache memories, and access data stored in the shared data storage system; providing cache data information from each of the local servers to the shared data storage system, the cache data information comprising cache hit data representative of cache hits of each of the local servers, and cache miss data representative of cache misses of each of the local servers; aggregating, at the shared data storage system, at least part of the cache hit and miss data received and providing the aggregated cache data information to one or more of the local servers; and at the local servers, updating respective one or more cache memories used to serve respective one or more applications based on the aggregated cache data information.Type: GrantFiled: June 18, 2013Date of Patent: October 6, 2015Assignee: International Business Machines CorporationInventors: Stephen L. Blinick, Lawrence Y. Chiu, Evangelos S. Eleftheriou, Robert Haas, Yu-Cheng Hsu, Xiao-Yu Hu, Ioannis Koltsidas, Paul H. Muench, Roman Pletka
-
Patent number: 9116973Abstract: An in-memory computing system for conducting on-line transaction processing and on-line analytical processing includes system tables in main memory to store runtime information. A statistics server can access the runtime information to collect monitoring data and generate historical data and other system performance metrics.Type: GrantFiled: October 29, 2013Date of Patent: August 25, 2015Assignee: SAP SEInventor: Marc-Philip Werner
-
Patent number: 9098617Abstract: An initial data analytic plan for analyzing a given data set associated with a given data problem is defined. At least a portion of original data in the given data set is conditioned to generate conditioned data. At least one model is selected to analyze at least one of the original data and the conditioned data. The at least one selected model is executed on at least one of a portion of the original data and a portion of the conditioned data. Results of the model execution are communicated to at least one entity, the results comprising a refined data analytic plan for analyzing the given data set. One or more computing resources are provisioned to implement the refined data analytic plan. The defining, conditioning, selecting, executing, communicating and provisioning steps are performed on one or more processing elements associated with a computing system and automate a data analytics lifecycle.Type: GrantFiled: September 27, 2012Date of Patent: August 4, 2015Assignee: EMC CorporationInventors: Wayne A. Pauley, Jr., Stephen Todd, Rhonda Baldwin, David Dietrich
-
Publication number: 20150149400Abstract: An in-memory computing system for conducting on-line transaction processing and on-line analytical processing includes system tables in main memory to store runtime information. A statistics services can access the runtime information using script procedures stored in the main memory to collect monitoring data and generate historical data and other system performance metrics while maintaining the runtime data and generated data in the main memory.Type: ApplicationFiled: April 2, 2014Publication date: May 28, 2015Applicant: SAP AGInventors: Marc-Philip Werner, Wolfgang Auer
-
Patent number: 9043307Abstract: Statistics for a pattern matching predicate are generated using stored character statistics. A first structure stores, for each of a plurality of character positions, frequently occurring characters in that character position, and a count of the number of occurrences of that character. A second structure stores frequently occurring characters that are subsequent to the frequently occurring characters stored in the first structure, and a probability of occurrence of each frequently occurring subsequent character. To form an estimate of the number of tuples matching a pattern matching predicate, statistics are retrieved for the matching characters in each matching position in the predicate, and then combined to produce the estimate. In the event a statistic is not stored for a desired character, the available statistics are used to make an estimate by accumulating statistics for other characters, and then calculating average frequency of occurrence of characters that do not have stored statistics.Type: GrantFiled: May 15, 2008Date of Patent: May 26, 2015Assignee: International Business Machines CorporationInventors: Abdo Esmail Abdo, Travis Michael Drucker
-
Patent number: 9037612Abstract: Information from multiple databases is retrieved and stored on a database storage system. Multiple point-in-time copies are obtained for each database. A point-in-time copy retrieves data changed in the database since the retrieval of a previous point-in-time copy. A virtual database (VDB) is created by creating a set of files in the data storage system. Each file in the set of files created for a VDB is linked to the database blocks on the database storage system associated with a point-in-time copy of the source database. The set of files associated with the VDB are mounted on a database server allowing the database server to read from and write to the set of files. Workflows based on VDBs allow various usage scenarios based on databases to be implemented efficiently, for example, testing and development, backup and recovery, and data warehouse building.Type: GrantFiled: October 21, 2013Date of Patent: May 19, 2015Assignee: Delphix Corp.Inventors: Charlie Li Zha, Jedidiah Yueh, Alok Kumar Srivastava
-
Patent number: 9031900Abstract: In accordance with aspects of the disclosure, a system and methods may be provided for integrating software layers in OLAP including receiving, at an OLAP engine, a dynamic result set structure passed from an application layer via one or more other software layers. The dynamic result set structure may include a description of entities for a target layer. The system and methods may include enhancing raw data, at the OLAP engine, acquired from a database associated with a source layer based on the description of entities for the dynamic result set structure and passing one or more references to one or more memory locations for data elements in the dynamic result set structure from the OLAP engine to the application layer via the one or more other software layers for acquiring each data element associated with each corresponding reference in the dynamic result set structure.Type: GrantFiled: January 18, 2012Date of Patent: May 12, 2015Assignee: SAP SEInventors: Zoltan Albrecht, Sebastian Schroetel
-
Patent number: 9031982Abstract: A service delivery platform receives a request for a catalogue. The system obtains subscriber-specific multi-media catalogue entries based on profile information stored with the service delivery platform. The system sends the subscriber-specific catalogue entries along with service details of the subscription back to the subscriber.Type: GrantFiled: August 22, 2008Date of Patent: May 12, 2015Assignee: Accenture Global Services LimitedInventors: Laura Martino, Domenico De Luca, Roberto Privitera
-
Patent number: 9026487Abstract: In one embodiment, a system is provided. The system includes a first client. The system also includes an analysis server coupled to the first client. The system further includes a first customer database of information coupled to the analysis server. The first customer database is to embody forecast data and to receive essentially real-time updates to the forecast data. The first customer database supports an OLAP cube associated with the analysis server.Type: GrantFiled: November 3, 2008Date of Patent: May 5, 2015Assignee: Right90, Inc.Inventors: Kim Orumchian, Art Stabenow, Dean Skelton, David Petiot
-
Patent number: 9021125Abstract: There is disclosed a data switch in combination with a proxy controller, the data switch being configured for routing data traffic and control traffic between at least one input/output (I/O) device and at least one server including a memory having an address space including set of data buffers and a list of command/status descriptors. The data switch is configured to: i) distinguish between different types of traffic by examining packet headers; ii) route data traffic directly between the at least one I/O device and the at least one server; and iii) route control traffic by way of the proxy controller. In this way, I/O devices can be virtualized, since only the control traffic (which generally comprises less than 10% of the bandwidth) needs be processed by the proxy controller.Type: GrantFiled: December 5, 2008Date of Patent: April 28, 2015Assignee: Micron Technology, Inc.Inventor: Marek Piekarski
-
Publication number: 20150112953Abstract: The ability to store fact data and related dimensions is improved by having a single fact data structure connected to a plurality of dimensional structures via a bridge structure, which take the position of the data structure.Type: ApplicationFiled: September 24, 2014Publication date: April 23, 2015Applicant: Omnition Analytics, LLCInventors: Kishore Nair, Eric T Shannon
-
Publication number: 20150106325Abstract: Techniques are described for managing aggregation of data in a distributed manner, such as for a particular client based on specified configuration information. The described techniques may include storing aggregated data values for an OLAP cube or other data structure in a distributed manner, such as in some situations in a distributed hash table. The aggregated data values to be stored may be generated in various manners, such as by performing multi-stage data manipulation operations—for example, a map-reduce architecture may be used, with a first stage involving the use of one or more specified map functions to be performed, and with at least a second stage involving the use of one or more specified reduce functions to be performed.Type: ApplicationFiled: December 16, 2014Publication date: April 16, 2015Inventors: Richard J. Cole, Alan D. Mock
-
Patent number: 9002778Abstract: In various embodiments, methods define an analysis window for a dimensional model in accordance with a window template and a starting point. One or more aggregate definitions are produced based on the analysis window. In another embodiment, the dimensional model comprises a time dimension, and the window template is associated with the time dimension. In yet another embodiment, the starting point is changed to a new starting point, and a new analysis window is defined using the new starting point.Type: GrantFiled: June 22, 2004Date of Patent: April 7, 2015Assignee: International Business Machines CorporationInventors: John Squires Poelman, Gary Robinson, Alvin Hon Lam So
-
Patent number: 8996695Abstract: Provided is a computing-system monitor configured to monitor a plurality of computing-systems each having a plurality of monitored computing-instances. The computing-system monitor may include a plurality of collectors, each collector executed by one of a plurality of monitored computing-instances, wherein the plurality of monitored computing-instances each are part of one of a plurality of separately monitored computing systems, and wherein each of the collectors is operable to output metrics of a corresponding monitored computing-instance executing that collector. The computing-system monitor may also include an analytics platform, the analytics platform having a plurality of analytic computing-instances, the analytics platform being operable to receive metrics output by the plurality of collectors, calculate statistics with the analytic computing-instances based on the received metrics, and output the calculated statistics.Type: GrantFiled: April 16, 2013Date of Patent: March 31, 2015Assignee: CopperEgg CorporationInventors: Eric Paul Anderson, Scott Conrad Johnson, David Perdue, Luke Ehresman, Robert B. Gordon
-
Patent number: 8996448Abstract: A method and a system for determining a skill matrix of an employee is provided. The method comprises analyzing the employee's folksonomic behavior and consequently creating the skill matrix of the employee. Folksonomy comprises creating one or more tags to annotate and categorize web content. The system includes a Tag Cloud Management Module, a Tag Cluster Generator Module and a Skill Matrix Generator Module. The Tag Cloud Management Module is configured to generate a tag cloud, wherein the tag cloud includes one or more tags created by the employee while browsing content of interest. The Tag Cluster Generator Module is configured to create one or more groups/clusters of one or more tags included in the tag cloud, based on one or more technologies related to the one or more tags. The Skill Matrix Generator Module is configured to analyze the created one or more clusters of tags to determine the skill matrix of the employee.Type: GrantFiled: June 30, 2011Date of Patent: March 31, 2015Assignee: Infosys LimitedInventor: Rajarshi Bhose
-
Publication number: 20150088805Abstract: Approaches, techniques, and mechanisms are disclosed for improved caching in database systems that deal with multiple data access patterns, such as in database systems that interface with both OLTP and Data Warehouse clients. A cache is deployed between a database server and a storage system that stores data units. Some of the data units accessed by the database server are buffered within the cache. The data units may be associated with data access patterns, such as a random data access pattern or a scan data access pattern, in accordance with which the database server is or appears to be accessing the data units. A processor selects when to cache data units accessed by the database server, based at least on the associated data access patterns. Recent access counts may also be stored for the data units, and may further be utilized to select when to cache data units.Type: ApplicationFiled: September 17, 2014Publication date: March 26, 2015Inventors: Sarat B. Kakarla, Jia Shi, Selcuk Aya, Kothanda Umamageswaran, Juan R. Loaiza
-
Patent number: 8990145Abstract: A first data mining model and a second data mining model are compared. A first data mining model M1 represents results of a first data mining task on a first data set D1 and provides a set of first prediction values. A second data mining model M2 represents results of a second data mining task on a second data set D2 and provides a set of second prediction values. A relation R is determined between said sets of prediction values. For at least a first record of an input data set, a first and second probability distribution is created based on the first and second data mining models applied to the first record. A distance measure d is calculated for said first record using the first and second probability distributions and the relation. At least one region of interest is determined based on said distance measure d.Type: GrantFiled: August 19, 2011Date of Patent: March 24, 2015Assignee: International Business Machines CorporationInventors: Christoph Lingenfelder, Pascal Pompey, Michael Wurst