Data Extraction, Transformation, And Loading (etl) Patents (Class 707/602)
  • Patent number: 10402484
    Abstract: Methods and systems of aligning annotation of fields of documents are provided. Training information that includes first measurement information pertaining to features of each of a plurality of fields associated with training clusters for documents of a document type is accessed. A first training cluster is annotated with a first name and the second training cluster is annotated with a second name. An electronic classification model is generated based on the training information. Second measurement information for features of fields associated with new clusters of a new document is accessed. Each of the new clusters is automatically annotated based on the second measurement information using the classification model. For example, a first new cluster that has fields of the first field type is annotated with the first name and a second new cluster that has fields of the second field type is annotated with the second name.
    Type: Grant
    Filed: October 27, 2011
    Date of Patent: September 3, 2019
    Assignee: ENTIT SOFTWARE LLC
    Inventors: Shahar Golan, Omer Barkol, Ruth Bergman, Ira Cohen, Gal Noy
  • Patent number: 10402398
    Abstract: Aspects described herein provide solutions to problems posed by a user. Input that includes a specified subject may be received from a user. A specified descriptor for the specified subject may be obtained from a hierarchical taxonomy associated with the specified subject. An information repository may be searched based on the specific descriptor, and entries stored at the information repository that are associated with the specific descriptor may be indicated in a list of results. The specific descriptor may be iteratively generalized to obtain generalized descriptors, and the information repository may be searched based on the generalized descriptors. The generalized descriptors may also be specialized to obtain specialized descriptors, and the information repository may be searched based on the specialized descriptors. The list of results may include entries stored at the information repository that are respectively associated with the generalized descriptors and the specialized descriptors.
    Type: Grant
    Filed: December 17, 2013
    Date of Patent: September 3, 2019
    Assignee: Nuance Communications, Inc.
    Inventors: Jan Vystrcil, Martin Labský, Ladislav Kunc, Tomás Macek, Jan Kleindienst
  • Patent number: 10394637
    Abstract: A system receives a source and a metadata layer that describes the source. The source may comprise source records with fields containing source data, and the metadata layer may include metadata comprising at least one of a field data type, a field data length, a field description, or a record length. The processor may further validate the metadata layer against the source and write results to a log. The processor may further be configured for transforming the source records into transformed records for a load ready file. The processor may further balance a number of records in the source against a number of transformed records in the load ready file to generate a transformation failure rate.
    Type: Grant
    Filed: September 4, 2015
    Date of Patent: August 27, 2019
    Assignee: AMERICAN EXPRESS TRAVEL RELATED SERVICES COMPANY, INC.
    Inventors: Rahul Agarwal, Sachin Arya, Sastry Durvasula, Harish Naik, Satish Narayanan
  • Patent number: 10394790
    Abstract: 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: Grant
    Filed: August 4, 2016
    Date of Patent: August 27, 2019
    Assignee: International Business Machines Corporation
    Inventor: Brian R. Muras
  • Patent number: 10387225
    Abstract: Certain examples described herein provide a data processing system and method adapted for event processing. These examples provide for distribution of data processing operations between server computing devices. In one case, a plurality of processing stages are implemented using computing instances on the server computing devices. In this case, the computing instances are assigned to the server computing devices in order to perform at least one data processing operation in parallel. Certain examples described herein then provide for the distribution of data between computing instances such that parallelism is maintained for data processing operations. In certain cases, a composite key is used. In this case, a composite key value is computed for a set of data fields associated with a data item to be processed. This key value is computed based on a data processing operation to be performed.
    Type: Grant
    Filed: September 30, 2015
    Date of Patent: August 20, 2019
    Assignee: Hewlett Packard Enterprise Development LP
    Inventors: Alain Guigui, Remi Verney, Denis Roger
  • Patent number: 10387389
    Abstract: A method, executed by a computer, for de-duplicating data includes receiving a dataset, pivoting the dataset along a set of columns that have a common domain to provide a pivoted dataset, de-duplicating the pivoted dataset to provide a de-duplicated dataset, and using the de-duplicated dataset. De-duplicating the pivoted dataset may include computing similarity scores for records that have different primary keys and merging records that have a similarity score that exceeds a selected threshold value. The method may include determining the set of columns having a common domain by referencing a business catalog and/or conducting a data classification operation on some or all of the columns of the dataset. The method may also include pivoting the dataset along another set of columns that have a different common domain. A computer system and computer program product corresponding to the method are also disclosed herein.
    Type: Grant
    Filed: September 30, 2014
    Date of Patent: August 20, 2019
    Assignee: International Business Machines Corporation
    Inventors: Namit Kabra, Yannick Saillet
  • Patent number: 10366085
    Abstract: An audit scoring system may include authorizing a user device to configure an audit for one or more form identification numbers. The system may receive values for each disposition associated with form data. The system may also assign values to each disposition such that a query can be performed against the audit using a form identification number associated with the form data.
    Type: Grant
    Filed: February 7, 2013
    Date of Patent: July 30, 2019
    Inventors: Ross Shanken, Emanuel I Wald, Atul Patel
  • Patent number: 10366112
    Abstract: Compiling test cases. The method may include uploading at least one extract, transform, load job (ETL job) and a plurality of test cases. The method may also include identifying a plurality of design features associated with the at least one uploaded ETL job. The method may further include identifying at least one feature change within the plurality of identified design features. The method may also include determining a plurality of related test cases within the plurality of uploaded test cases corresponding to the at least one identified feature change. The method may further include creating a test bucket based on a grouping of the determined plurality of related test cases. The method may also include adding at least one of a plurality of corresponding ETL jobs and a plurality of corresponding ETL job stages associated with the at least one identified feature change to the created test bucket.
    Type: Grant
    Filed: March 22, 2018
    Date of Patent: July 30, 2019
    Assignee: International Business Machines Corporation
    Inventors: Raghavendra R. Dhayapule, Ritesh K. Gupta, Sumit Kumar, Rajesh Phillips
  • Patent number: 10360204
    Abstract: An example technique for defining a user function can include receiving a user defined function that gathers data from a data source external to a database and returns the data to the database. The example technique for defining the user function can also include creating an instance of a programming class that extends from an application programming interface (API). The instance of the programming class including the user defined function. The example technique for defining the user function can also include executing the user defined function provided by the instance of the programming class.
    Type: Grant
    Filed: May 22, 2014
    Date of Patent: July 23, 2019
    Assignee: ENTIT SOFTWARE LLC
    Inventors: Qiming Chen, Meichun Hsu, Maria Guadalupe Castellanos
  • Patent number: 10360407
    Abstract: Embodiments of the present invention disclose a method, computer program product, and system for text author anonymization for de-identification of written text. This may be used to replace written text after learning text author writing characteristics, such frequently written terms, grammar patterns, grammar errors, and writing tone. Portions of the written text which may identify the text author may be replaced, for example the text author writing characteristics, social status, geographical location, and specific organization.
    Type: Grant
    Filed: April 10, 2017
    Date of Patent: July 23, 2019
    Assignee: International Business Machines Corporation
    Inventors: Itai Gordon, Peter Hagelund, Ilan D. Prager
  • Patent number: 10360602
    Abstract: A method for metering accelerator usage in a computing system includes receiving, from an accelerator, a set of metering rules, the metering rules including a unit of accelerator usage and a tariff per unit of accelerator usage. The unit of accelerator usage corresponds with an amount of work performed by the accelerator in executing data processing operations. The method may further include receiving on a first bus from a partition of the computing system a command block, the command block having data processing operations executable by the accelerator. The method may additionally include calculating, based on the command block and the set of metering rules, an accelerator usage value for the partition. The method may then include providing, on a second bus, the accelerator usage value.
    Type: Grant
    Filed: October 15, 2015
    Date of Patent: July 23, 2019
    Assignee: International Business Machines Corporation
    Inventors: Saravanan Devendra, Venkatesh Sainath
  • Patent number: 10360404
    Abstract: Embodiments of the present invention disclose a method, computer program product, and system for text author anonymization for de-identification of written text. This may be used to replace written text after learning text author writing characteristics, such frequently written terms, grammar patterns, grammar errors, and writing tone. Portions of the written text which may identify the text author may be replaced, for example the text author writing characteristics, social status, geographical location, and specific organization.
    Type: Grant
    Filed: February 25, 2016
    Date of Patent: July 23, 2019
    Assignee: International Business Machines Corporation
    Inventors: Itai Gordon, Peter Hagelund, Ilan D. Prager
  • Patent number: 10353913
    Abstract: A method for testing an extract, transform, load job (ETL job) is provided. The method may include receiving an uploaded ETL job. The method may also include executing a functionality test of the uploaded ETL job using a test bucket. The method may further include determining the executed functionality test produces a failure result. The method may also include creating at least one test sub-job corresponding to at least one stage within on the uploaded ETL job. The method may further include generating a plurality of test data for each of the at least one created test sub-job. The method may also include executing the at least one created test sub-job using the plurality of generated test data. The method may further include creating a report based on a plurality of results associated with the at least one executed test sub-job.
    Type: Grant
    Filed: June 14, 2018
    Date of Patent: July 16, 2019
    Assignee: International Business Machines Corporation
    Inventors: Raghavendra R. Dhayapule, Ritesh K. Gupta, Sumit Kumar, Rajesh Phillips
  • Patent number: 10331633
    Abstract: A method, system, and computer program product derive data schema for application to a data set. One or more processors generate a directed acyclic weighted graph that encodes data types and semantic types used by a data set. One or more processors assign estimated frequencies for each component of the directed acyclic weighted graph, where the estimated frequencies predict a likelihood of a particular data schema element being used by any data set. One or more processors traverse through paths in the directed acyclic weighted graph with a predetermined portion of the data set to determine a data schema that correctly defines data from the data set and identifies any errors in the data set, and then apply the data schema to the data set to generate clean data that is properly formatted.
    Type: Grant
    Filed: June 4, 2015
    Date of Patent: June 25, 2019
    Assignee: International Business Machines Corporation
    Inventors: Srinivasan Parthasarathy, Venkata N. Pavuluri, Deepak S. Turaga
  • Patent number: 10319044
    Abstract: Systems and methods that enable transaction oriented functions for a multidimensional database are provided. The systems and methods store a plurality of transactions in a multidimensional database, generate a first dimension including respective balances resulting from each of the transactions, and generate a second dimension identifying respective rules corresponding to each of the transactions.
    Type: Grant
    Filed: October 24, 2016
    Date of Patent: June 11, 2019
    Assignee: Oracle International Corporation
    Inventors: Donald Wayne Bean, Dinesh Balebail, Shailesh Phansalkar
  • Patent number: 10318535
    Abstract: A method, system, and processor-readable storage medium are directed towards generating a report derived from data, such as event data, stored on a plurality of distributed nodes. In one embodiment the analysis is generated using a “divide and conquer” algorithm, such that each distributed node analyzes locally stored event data while an aggregating node combines these analysis results to generate the report. In one embodiment, each distributed node also transmits a list of event data references associated with the analysis result to the aggregating node. The aggregating node may then generate a global ordered list of data references based on the list of event data references received from each distributed node. Subsequently, in response to a user selection of a range of global event data, the report may dynamically retrieve event data from one or more distributed nodes for display according to the global order.
    Type: Grant
    Filed: January 25, 2016
    Date of Patent: June 11, 2019
    Assignee: SPLUNK INC.
    Inventors: Steve Yu Zhang, Stephen Phillip Sorkin
  • Patent number: 10311206
    Abstract: Methods, devices, and systems (for outputting a case summary) receive an electronic medical record (EMR) for the medical patient, extract medical data from the EMR, provide a list of medical problems relevant to the EMR, identifying relations between the medical problems and the medical data using a question-answering (QA) system, and output the clinical summary for the EMR. The clinical summary comprises the list of medical problems, the medical data, and the relations.
    Type: Grant
    Filed: June 19, 2014
    Date of Patent: June 4, 2019
    Assignee: International Business Machines Corporation
    Inventors: Keerthana Boloor, Murthy V. Devarakonda, Ching-Huei Tsou, Dongyang Zhang
  • Patent number: 10310925
    Abstract: Metadata area legends are stored at a first location, such as a dedicated partition of a persistent data storage device (PDSD). The metadata area legends have a number of descriptors that describe a number of reserved metadata areas that lie at a second location that is logically separate from the first location, such as a regular partition of the PDSD. Requests to delete the metadata area legends, as well as requests to add new metadata area legends, can be verified to prevent the metadata area legends from being accidentally or maliciously changed.
    Type: Grant
    Filed: March 2, 2016
    Date of Patent: June 4, 2019
    Assignee: Western Digital Technologies, Inc.
    Inventors: Viacheslav Dubeyko, Adam Manzanares
  • Patent number: 10303448
    Abstract: Disclosed herein are methods, systems, and computer program products directed to a guidance engine. The guidance engine is configured to query a knowledge base for guidance with respect to a property of a software application. The guidance engine receives a responsive query from the knowledge base that is based on the property. The responsive query informs a user of the guidance engine how to address a vulnerability within the software application by performing a transform with respect to a property of the software application.
    Type: Grant
    Filed: May 15, 2017
    Date of Patent: May 28, 2019
    Assignee: Synopsys, Inc.
    Inventors: John Steven, Chris Schmidt, Jordan Tyler Thayer
  • Patent number: 10304062
    Abstract: A computer system architecture and method for providing compliance with data regulations, by: (a) collecting a data input stream with a data collection terminal; (b) using a compliance device driver resident in the data collection terminal to: (1) select data corresponding to pre-identified data compliance fields, and (2) apply a compliance markup language parser to generate pseudonymized data; and (c) using an automated compliance network appliance and an automated compliance server to: (1) transmit the pseudonymized data into immutable audit ledger, wherein the immutable audit ledger is assembled and verified by blockchain, and (2) transmit the data input stream into a data lake; (d) hosting access portals for accessing data: (1) stored in the data lake, and (2) stored in the immutable audit ledger.
    Type: Grant
    Filed: March 23, 2018
    Date of Patent: May 28, 2019
    Assignee: TD PROFESSIONAL SERVICES, LLC
    Inventor: Scott Hines
  • Patent number: 10296614
    Abstract: A present invention embodiment relates to inserting data to a data table, where the data table has multiple data records and involves at least one organizing attribute. The embodiment defines a set of data blocks having records of the data table and assigns to each data block of the set of data blocks a predefined maximum number of records of the data table or a predefined maximum amount of storage. Data records for each data block of the set of data blocks may be stored on a storage system. Further data records may be sorted based on values of the organizing attribute in the buffered data records. The sorted data records may be written on the storage system in their order. Attribute value information may be determined for the further data blocks for supporting query processing against the data table.
    Type: Grant
    Filed: December 7, 2016
    Date of Patent: May 21, 2019
    Assignee: International Business Machines Corporation
    Inventors: Thomas F. Boehme, Andreas Brodt, Oliver Schiller
  • Patent number: 10262049
    Abstract: Performing an extract, transform, and load (ETL) process. Column data is received by a stage of the ETL process. The size of the received column data is ascertained by the stage. In response to determining that the size of the column data exceeds a predefined threshold, the stage saves the column data and creates a data locator associated with the column data. The created data locator advances through successive downstream stages of the ETL process as a replacement for the column data.
    Type: Grant
    Filed: June 23, 2016
    Date of Patent: April 16, 2019
    Assignee: International Business Machines Corporation
    Inventors: Kalyanji Chintakayala, Krishna K. Bonagiri, Eric A. Jacobson
  • Patent number: 10248532
    Abstract: Methods, systems, and computer-readable media for implementing sensitive data usage detection using static analysis are disclosed. A specification of one or more operations exposed by a service in a service-oriented system is obtained from a repository. The names of the one or more operations are determined in the specification. The names of one or more parameters of the one or more operations are determined in the specification. The names of the one or more operations and the names of the one or more parameters are checked against a dictionary of sensitive terms. One or more sensitive operations are determined among the one or more operations. One or more consumers of the one or more sensitive operations are determined.
    Type: Grant
    Filed: September 15, 2015
    Date of Patent: April 2, 2019
    Assignee: Amazon Technologies, Inc.
    Inventors: Muhammad Wasiq, Jon Arron McClintock
  • Patent number: 10248694
    Abstract: A computer-implemented method includes inserting a bloom filter creation stage after an inner data source identification stage, wherein a join operation is to be performed to join an outer data source with the inner data source. The method inserts a bloom filter search stage after an outer data source identification stage, wherein each row of data from the outer data source is searched against a bloom filter for the inner data source during the bloom filter search stage. The method initializes a read on the inner data source. Subsequent to determining the bloom filter creation stage is complete, the method initializes a read on the outer data source. The method performs the join operation at a join stage.
    Type: Grant
    Filed: August 31, 2015
    Date of Patent: April 2, 2019
    Assignee: International Business Machines Corporation
    Inventors: Manish A. Bhide, Shyam R. Mudambi, Sriram K. Padmanabhan, Vivek S. Tirumalaraju
  • Patent number: 10250640
    Abstract: Method of organizing and storing data in an information infrastructure by either processing data throughput or a method for processing data throughput or data mining in a distributed computing system works using a tagging routine. The system and method operates on sensitive content (e.g., trade secrets) or select content (e.g., critical content) and applies configurable filters (expanding, contracting, hierarchical/orthogonal classifier filters) to separate and store sensitive/select data in designated, distributed data stores or to supplement data collections. Sensitive/select data stores may have security clearance requirements. Data output is controlled to provide one or more of storage in predetermined data stores, data mining, coping, transfer to other storage sites, supplemental data searches, and presentation subject to data inquiry.
    Type: Grant
    Filed: January 15, 2015
    Date of Patent: April 2, 2019
    Inventors: Ron M. Redlich, Martin A. Nemzow
  • Patent number: 10242063
    Abstract: A computer-implemented method includes inserting a bloom filter creation stage after an inner data source identification stage, wherein a join operation is to be performed to join an outer data source with the inner data source. The method inserts a bloom filter search stage after an outer data source identification stage, wherein each row of data from the outer data source is searched against a bloom filter for the inner data source during the bloom filter search stage. The method initializes a read on the inner data source. Subsequent to determining the bloom filter creation stage is complete, the method initializes a read on the outer data source. The method performs the join operation at a join stage.
    Type: Grant
    Filed: July 20, 2016
    Date of Patent: March 26, 2019
    Assignee: International Business Machines Corporation
    Inventors: Manish A. Bhide, Shyam R. Mudambi, Sriram K. Padmanabhan, Vivek S. Tirumalaraju
  • Patent number: 10229151
    Abstract: Embodiments include a method, system, and computer program product for acquiring a data repository, the data repository being associated with a log configured to receive metadata. Then, a content of the log with respect to at least one manipulation of the data repository is modified by adding first metadata of the metadata. Further, signatures that identify control statements configured to govern the at least one manipulation of the data repository are collected by adding second metadata of the metadata into the log.
    Type: Grant
    Filed: September 3, 2015
    Date of Patent: March 12, 2019
    Assignee: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: John C. Dayka, Mark A. Nelson, Kevin H. Peters
  • Patent number: 10223410
    Abstract: In one embodiment, a method includes obtaining a first data set from a first data source and a second data set from a second data source, the first data set including a first plurality of entities and the second data set including a second plurality of entities. The method also includes identifying a verified relationship between a first entity from the first plurality of entities and a second entity from the second plurality of entities and determining that a third entity from the first plurality of entities has a first same-as relationship with a fourth entity from the second plurality of entities based on one or more of the verified relationship or relationships between the first plurality of entities and the second plurality of entities. The method further includes generating first output data including the first same-as relationship.
    Type: Grant
    Filed: August 31, 2014
    Date of Patent: March 5, 2019
    Assignee: Cisco Technology, Inc.
    Inventors: Stephen Charles Tallamy, Laurent Edmond Pierre Bertrand, Pete Rai
  • Patent number: 10210228
    Abstract: Metadata is managed for different distributed federated workspaces. A distributed metadata infrastructure is provided for supporting at least two different distributed federated workspaces. The distributed metadata infrastructure monitors the at least two different distributed federated workspaces to identify common metadata between the at least two different distributed federated workspaces. The distributed metadata infrastructure presents a consistent view of the common metadata.
    Type: Grant
    Filed: May 29, 2015
    Date of Patent: February 19, 2019
    Assignee: International Business Machines Corporation
    Inventor: Charles K. Shank
  • Patent number: 10210187
    Abstract: Elements of a database object are removed. The database object is stored as a plurality of different object portions, where each object portion is associated with one or more versions of transaction identifiers stored separately from the database object. An oldest transaction identifier is determined for a transaction for which data portions of the database object remains visible. Each object portion is examined and object portions with a threshold amount of data to remove are determined based on a comparison of the transaction identifiers for those object portions and the oldest transaction identifier. Data from the database object are removed in response to a sufficient quantity of data is to be removed from object portions containing the threshold amount of data.
    Type: Grant
    Filed: August 2, 2016
    Date of Patent: February 19, 2019
    Assignee: International Business Machines Corporation
    Inventors: Daniel J. Dietterich, Jeffrey M. Keller
  • Patent number: 10212125
    Abstract: The subject matter described herein relates to methods, systems, and computer readable media for testing network equipment devices using connection-oriented protocols. In some examples, a method for testing a network equipment device under test (DUT) includes executing, by a network equipment test device, a test script to test the network equipment DUT using a connection-oriented protocol. The method includes inserting, during a connection establishment process of the connection-oriented protocol for a network flow to the network equipment DUT, a flow-identifying sequence number into a sequence number field of a first message of the network flow. The flow-identifying sequence number is a number uniquely identifying the network flow from other network flows. The method includes receiving a second message from the network equipment DUT and determining that the second message belongs to the network flow by extracting the flow-identifying sequence number from the second message.
    Type: Grant
    Filed: April 9, 2016
    Date of Patent: February 19, 2019
    Assignee: KEYSIGHT TECHNOLOGIES SINGAPORE (HOLDINGS) PTE. LTD.
    Inventors: Alexandru Badea, George Ciobanu, Emilian-Mihai Filipescu, Marius-Gabriel Ionescu
  • Patent number: 10210232
    Abstract: Systems, methods, and apparatuses can provide staged migration from one or more user accounts from a source system to a destination system using an application local to the source systems. The automated staged data migration can provide coordinated staged data migration of large amounts of data in a single automated process. The system can provide automated and remotely controlled staged migrations of data that may perform source system type detection and work with multiple types of systems.
    Type: Grant
    Filed: October 1, 2015
    Date of Patent: February 19, 2019
    Assignee: SKYKICK, INC.
    Inventors: Evan Richman, Todd Schwartz, Trent Robert Schwartz, Bradley Younge, John Dennis, Roger Neil Moore, Christopher Rayner
  • Patent number: 10204227
    Abstract: Embodiments of the invention relate to systems and methods for providing an anonymization engine. One embodiment of the present invention relates to a method comprising receiving a message directed at a recipient computer located outside a secure area by a privacy computer located within a secure area. The privacy computer may identify private information using a plurality of privacy rules and anonymize the message according to the plurality of privacy rules. Another embodiment may be directed to a method comprising receiving a request for sensitive data from a requesting computer. An anonymization computer may determine a sensitive data record associated with the request and may anonymize the sensitive data record by performing at least two of: removing unnecessary sensitive data entries from the sensitive data record, masking the sensitive data entries to maintain format, separating the sensitive data entries into associated data groupings, and de-contexting the data.
    Type: Grant
    Filed: April 19, 2017
    Date of Patent: February 12, 2019
    Assignee: Visa International Service Association
    Inventors: Sekhar Nagasundaram, Selim Aissi
  • Patent number: 10205728
    Abstract: Certain aspects and features of the present disclosure relate to systems and methods that generate machine-learning models to predict whether user devices are likely to meet defined objectives. For example, a machine-learning model can be generated to predict whether or not a user device is likely to access a resource. In some implementations, a semi-supervised model can be used to determine to what extent user devices are predicted to satisfy the defined objective(s). For example, a resource-affinity parameter can be generated as a result of inputting various data points into a semi-supervised model. The various data points can be access from a plurality of data sources, and can represent one or more activities or attributes associated with a user. The value of the resource-affinity parameter can be evaluated to determine the extent to which the user is likely to meet an objective.
    Type: Grant
    Filed: May 18, 2018
    Date of Patent: February 12, 2019
    Assignee: Live Nation Entertainment, Inc.
    Inventors: John Carnahan, Ajay Pondicherry, Vasanth Kumar
  • Patent number: 10191802
    Abstract: A cloud-based ETL system provides error detection, error correction and reporting of data integration flows hosted by cloud services. Categories of errors are identified using one or more checks at different points of a data integration flow and one or more actions selected based at least in part on the error category. A determination can be made whether the error category is fault tolerant and one or more actions can be selected based at least in part on the error fault tolerance to correct the error, restart a flow, or generate a notification assisting a user to correct the error.
    Type: Grant
    Filed: May 18, 2016
    Date of Patent: January 29, 2019
    Assignee: Oracle International Corporation
    Inventors: Ispati Nautiyal, Rajesh Balu
  • Patent number: 10176427
    Abstract: Techniques relating to managing “bad” or “imperfect” data being imported into a database system are described herein. A lifecycle technology solution helps receive data from a variety of different data sources of a variety of known and/or unknown formats, standardize it, fit it to a known taxonomy through model-assisted classification, store it to a database in a manner that is consistent with the taxonomy, and allow it to be queried for a variety of different usages. Auto-classification, enrichment, clustering model and model stacks, and/or other disclosed techniques, may be used in these and/or other regards.
    Type: Grant
    Filed: July 28, 2017
    Date of Patent: January 8, 2019
    Assignee: Xeeva, Inc.
    Inventors: Dilip Dubey, Dineshchandra Harikisan Rathi, Koushik Kumaraswamy
  • Patent number: 10163242
    Abstract: Techniques are disclosed for an energy grid data platform through which information associated with an electrical grid can be accessed by one or more entities. In some embodiments, an energy grid data platform includes one or more modeling engines configured to receive data associated with an electrical grid and generate data models describing various aspects of the electrical grid. For example an electrical grid model describing the state of the electrical grid at one or more points of connection may be based at least in part on data received from sensors at the edge of the electrical grid. As another example, a physical grid model describing the physical arrangement and logical relationships between physical objects associated with the electrical grid can be generated based at least in part on received imagery data.
    Type: Grant
    Filed: March 21, 2017
    Date of Patent: December 25, 2018
    Assignee: Gordon Todd Jagerson, Jr.
    Inventor: Gordon Todd Jagerson, Jr.
  • Patent number: 10158677
    Abstract: An example embodiment may include a security enforcement point device disposed within a managed network and a security decision point device disposed within a computational instance of a remote network management platform. The security decision point device may be configured to: receive a message by way of the managed network; parse the message to identify observable indicators of one or more of the security threats, where the observable indicators include at least one of a network addresses, a hyperlink, or a representation of an attached file; remotely query a security threat database for the observable indicators; receive, from the security threat database, an indication that the observable indicators are associated with a particular security threat, and transmit, to the security enforcement point device, a command to update its associated security policy such that the particular security threat is mitigated.
    Type: Grant
    Filed: March 29, 2018
    Date of Patent: December 18, 2018
    Assignee: ServiceNow, Inc.
    Inventors: Phillip DiCorpo, Jose Bernal, Eun-Sook Watson
  • Patent number: 10140355
    Abstract: Compiling test cases. The method may include uploading at least one extract, transform, load job (ETL job) and a plurality of test cases. The method may also include identifying a plurality of design features associated with the at least one uploaded ETL job. The method may further include identifying at least one feature change within the plurality of identified design features. The method may also include determining a plurality of related test cases within the plurality of uploaded test cases corresponding to the at least one identified feature change. The method may further include creating a test bucket based on a grouping of the determined plurality of related test cases. The method may also include adding at least one of a plurality of corresponding ETL jobs and a plurality of corresponding ETL job stages associated with the at least one identified feature change to the created test bucket.
    Type: Grant
    Filed: September 2, 2015
    Date of Patent: November 27, 2018
    Assignee: International Business Machines Corporation
    Inventors: Raghavendra R. Dhayapule, Ritesh K. Gupta, Sumit Kumar, Rajesh Phillips
  • Patent number: 10136016
    Abstract: A communication apparatus capable of performing facsimile communication includes at least one memory that stores a set of instructions and at least one processor. The processor executes the instructions to receive facsimile data, store the received facsimile data in a storage, generate a preview image based on the stored facsimile data, and transmit, according to a request for a preview image from an external device, the generated preview image to the external device. In addition, the stored facsimile data is deleted according to an instruction, but deletion of the facsimile data in the storage is prohibited while the external device is displaying the preview image of the facsimile data if the instruction is received from another external device.
    Type: Grant
    Filed: February 2, 2017
    Date of Patent: November 20, 2018
    Assignee: CANON KABUSHIKI KAISHA
    Inventor: Hikaru Sugita
  • Patent number: 10133778
    Abstract: Disclosed herein are system, method, and computer program product embodiments for utilizing join cardinality to improve the performance of query processing. An embodiment operates by a database engine receiving a query including a join operation on a first and a second table using a join predicate, and a tag for the join operation indicating a cardinality relationship between the first and the second table when satisfying the join predicate. Then, the database engine generates a query processing plan for performing the query. For the join operation, the database engine selects one of the first or the second tables to remove from the join operation based on a type of the join operation and the tag. Based on the selecting, the database engine may remove may the join operation and the selected table from the query processing plan.
    Type: Grant
    Filed: November 20, 2015
    Date of Patent: November 20, 2018
    Assignee: SAP SE
    Inventors: Taehyung Lee, Joo Young Yoon, Sang Il Song, Yongsik Yoon, Sung Heun Wi, Junhee Woo
  • Patent number: 10129112
    Abstract: Concepts and technologies are disclosed herein for workflow-based resource management. A process can execute a resource management application. The process can obtain load data that describes a resource load associated with resources. The processor can analyze the load data to detect a change in resource load associated with one of the resources and identify workflows that includes the resource. The workflows can include a description of how the resources are utilized during execution of a process by the resources. The processor can identify a relevant workflow that is associated with the process and issue commands to resources associated with the relevant workflow to proactively adjust capacity of the resources associated with the relevant workflow.
    Type: Grant
    Filed: August 14, 2014
    Date of Patent: November 13, 2018
    Assignee: AT&T Intellectual Property I, L.P.
    Inventor: Robert Todd Stephens
  • Patent number: 10120915
    Abstract: Methods and system are disclosed that provision contextual information associated with business data. In one aspect, a framework middleware receives a request via an application to establish connection. Upon processing the request, the application may establish connection with multiple databases associated with multiple business management systems via an adapter framework associated with the framework middleware. Based on the established connection, the business data from the multiple databases maybe retrieved via a real-time provisioning adapter framework associated with the framework middleware. Multiple routines in the framework middleware may be executed to trigger a system landscape transformation model to transform the retrieved business data. Based on parameters associated with the transformed business data, associated contextual information maybe determined. The determined contextual information may be provisioned by rendering the contextual information on a user interface.
    Type: Grant
    Filed: November 26, 2015
    Date of Patent: November 6, 2018
    Assignee: SAP SE
    Inventor: Meenakshi Sundaram P
  • Patent number: 10122798
    Abstract: A communication protocol and system is disclosed for network communications between a data service residing on a client that provides network communications between one or more mobile applications on a source and a network based on a process number. The shared data service communicates with a data service plug-in on the server side associated with the process number, in order to handle requests from the mobile applications that access the network through the data service. Predetermined network connection, priority, and additional rules can be used to control what plug-in can be reached through what type of network connection.
    Type: Grant
    Filed: December 28, 2016
    Date of Patent: November 6, 2018
    Assignee: Intermec IP Corp.
    Inventors: Garrick Fiala, Radek Kasal
  • Patent number: 10120923
    Abstract: Resources for data lineage discovery, data lineage analysis, role-based security, notification. The resources may include or involve machine readable memory that is configured to store a technical data element (“TDE”); a receiver that is configured to receive a query for data lineage information corresponding to a business element identifier; and a processor configured to: register a logical association between the business element identifier and the TDE; and formulate the data lineage information of the TDE associated with the business element identifier. The receiver may be configured to receive a criterion that is required to access one or more technical data elements (“TDEs”) associated with the business element identifier. The receiver may be configured to receive an election to receive a notification of a change of data lineage. The processor may be configured to toggle between a first data lineage graph and a second data lineage graph.
    Type: Grant
    Filed: November 30, 2015
    Date of Patent: November 6, 2018
    Assignee: Bank of America Corporation
    Inventors: Sean McClure, Alan G. Ennis
  • Patent number: 10114565
    Abstract: Methods and systems for managing, storing, and serving data within a virtualized environment are described. In some embodiments, a data management system may manage the extraction and storage of virtual machine snapshots, provide near instantaneous restoration of a virtual machine or one or more files located on the virtual machine, and enable secondary workloads to directly use the data management system as a primary storage target to read or modify past versions of data. The data management system may allow a virtual machine snapshot of a virtual machine stored within the system to be directly mounted to enable substantially instantaneous virtual machine recovery of the virtual machine.
    Type: Grant
    Filed: February 20, 2015
    Date of Patent: October 30, 2018
    Assignee: RUBRIK, INC.
    Inventors: Arvind Nithrakashyap, Kenny To, Jiangbin Luo, Sharvanath Pathak, Jonathan Derryberry
  • Patent number: 10108914
    Abstract: Morphing object types in enterprise content management systems is described. A text properties file is created that maps properties associated with an object type to properties associated with a new object type. A database associated with an enterprise content management system is queried to retrieve objects based on the object type. The objects are stored in a staging database. The objects are deleted from the database. Property tables are created in the database based on the new object type. The objects are migrated from the staging database to the newly created property tables based on the text properties file.
    Type: Grant
    Filed: May 31, 2017
    Date of Patent: October 23, 2018
    Assignee: Open Text Corporation
    Inventors: Michael T. Mohen, Christopher Dyde
  • Patent number: 10102274
    Abstract: A corpus of texts relating to a domain of knowledge may be searched by determining noun-pair proximity scores measuring associations between pairs of nouns that appear in the corpus and that are semantically related to the domain of knowledge. When a search term is received, the noun-pair proximity scores may be used (at least in part) to identify one or more related nouns that are strongly associated with the search term within the corpus. One or more texts may be selected from the corpus, texts in which the search term and the related nouns appear near each other in one or more places. The selected texts may be categorized and/or clustered based on the related nouns before being returned for presentation as SearchResults.
    Type: Grant
    Filed: March 17, 2014
    Date of Patent: October 16, 2018
    Assignee: NLPCore LLC
    Inventor: Varun Mittal
  • Patent number: 10102253
    Abstract: Elements of a database object are stored among a plurality of different storage regions, each storage region being associated with a first value range indicating upper and lower range values for element values within that storage region. An index is generated and maintained for one or more second value ranges that include range values that comprise subsets of the first value ranges. A query is processed that includes a query value and one or more storage regions to be read is determined by using one of the index and the first value ranges based on the query value relative to a second value range.
    Type: Grant
    Filed: March 11, 2015
    Date of Patent: October 16, 2018
    Assignee: International Business Machines Corporation
    Inventor: Garth A. Dickie
  • Patent number: 10095727
    Abstract: A data unification device for unifying data objects includes a retrieving entity, a first providing entity, a second providing entity, and an assembling entity. The retrieving entity is configured to retrieve unstructured data objects from a number of unstructured knowledge bases and structured data objects from a number of structured knowledge bases. The first providing entity is configured to provide a number of syntactic frames for each retrieved data object, wherein each syntactic frame include a syntactic concept, a syntactic concept-instance, and a syntactic concept-instance relationship. The second providing entity is configured to provide a number of semantic frames for each retrieved data object, wherein each semantic frame includes a semantic concept, a semantic concept-instance, and a semantic concept-instance relationship. The assembling entity is configured to assemble, for each retrieved data object, the provided syntactic frames and the provided semantic frames to one semantic object.
    Type: Grant
    Filed: February 27, 2014
    Date of Patent: October 9, 2018
    Assignee: Siemens Aktiengesellschaft
    Inventor: Ulli Waltinger