Data Extraction, Transformation, And Loading (etl) Patents (Class 707/602)
  • Patent number: 8645331
    Abstract: A time-efficient means for identifying and processing cascading deletes due to referential constraint violations includes: logging, to an error file, all primary key (“PK”) errors detected during table load operations; building a foreign key (“FK”) index for each child table; recursively probing each relevant FK index to identify all loaded rows that violate a referential constraint due to a PK error; logging all identified FK errors to the error file; and using the (preferably sorted) error file contents to identify, mark and physically delete table rows that violate a referential constraint. The described cascade delete processing methods make only a single pass through the table data, using ordinary computer files to track and organize rows identified for deletion. Use of error files rather than tablescans (multiple passes through the loaded table data) can provide a significant reduction in table load times, especially for large or intricately “related” tables.
    Type: Grant
    Filed: December 28, 2009
    Date of Patent: February 4, 2014
    Assignee: BMC Software, Inc.
    Inventors: Christopher Y. Blaicher, Kerry C. Tenberg, Randol Keith Bright
  • Patent number: 8645468
    Abstract: Embodiments of the present invention address deficiencies of the art in respect to arbitrating polling results and provide a novel and non-obvious method, system and computer program product for collaborative arbitration of polling results in a collaborative environment. In an embodiment of the invention, a method for collaborative arbitration of polling results in a collaborative environment can be provided. The method can include placing a poll within a message and sending the message to a select group of collaborators in the collaborative environment. The method further can include receiving poll results from a collaborator in the select group in a reply to the message, extracting the poll results from the reply and placing the poll within a new message along with the extracted poll results. Thereafter, the new message can be sent to the select group.
    Type: Grant
    Filed: November 8, 2006
    Date of Patent: February 4, 2014
    Assignee: International Business Machines Corporation
    Inventors: Patrick O'Sullivan, Cynthia E. Barber-Mingo, Gary Denner, Ruthie D. Lyle, Carol S. Zimmet
  • Patent number: 8645314
    Abstract: An apparatus, system, and method are disclosed for communicating interactive forms and reports in messaging applications. The apparatus for communicating interactive forms and reports in messaging applications is provided with a plurality of modules configured to functionally execute the necessary steps of selecting a markup language instruction, copying the markup language instruction and post the markup language instruction into a clipboard as a markup language object, pasting the markup language object into a data entry field associated with a messaging application, and injecting the markup language object into a message transmission to a second messaging application. These modules in the described embodiments include a selection module, a copy module, a paste module, and an injection module.
    Type: Grant
    Filed: March 12, 2008
    Date of Patent: February 4, 2014
    Assignee: International Business Machines Corporation
    Inventors: Deanna Lynn Quigg Brown, Dinesh Chandra Coca, Louis Daniel Echevarria, Melissa Jorgette Garcia, Andrew Gary Hourselt, Elena Schneider, Nedzad Taljanovic
  • Patent number: 8645313
    Abstract: A system and method for indexing non-uniquely indexed entries in a report generated with a business intelligence system, such as, for example, an on-line analytical processing (OLAP) system. A dummy index is added to each index element returned in the report. Non-unique index elements receive different dummy indices to distinguish otherwise identical row elements. The dummy index is added to a base template and optionally also to a view template of a report generator of the OLAP system.
    Type: Grant
    Filed: May 27, 2005
    Date of Patent: February 4, 2014
    Assignee: Microstrategy, Inc.
    Inventors: Benjamin Li, Xinyi Wang, Xiaonan Han, Daniel Kerzner, Hanijanto Soewandi
  • Patent number: 8645315
    Abstract: A bookmark extracting apparatus accurately selects the most suitable bookmarks related to a website, being browsed at present, from bookmarks registered in advance. The bookmark extracting apparatus provides the selected bookmarks to a user. It includes a keyword extraction unit which extracts a keyword based on browsing history information of a website up to now, and a providing unit which provides a bookmark related to the keyword extracted by the extraction unit from a plurality of registered bookmarks, based on the keyword.
    Type: Grant
    Filed: December 6, 2011
    Date of Patent: February 4, 2014
    Assignee: NEC Corporation
    Inventor: Shoko Imai
  • Patent number: 8645487
    Abstract: A method and apparatus of requesting service between network devices in which the range of service between network devices can be flexibly managed, a network device capable of performing the method, and a storage medium thereof are provided. The network devices includes: a network device requesting a partner network device to send service information; and if service information of the partner network device is received, requesting a service to the partner network device based on the received service information.
    Type: Grant
    Filed: December 12, 2006
    Date of Patent: February 4, 2014
    Assignee: Samsung Electronics Co., Ltd.
    Inventors: Hyun-ah Sung, Dae-gyu Bae, Jin-woo Hong, Se-hoon Moon
  • Publication number: 20140032479
    Abstract: A method of processing geo-statistical data includes preparing a data log, extracting acoustic data and coordinate data from the data log, and aligning the acoustic data and the coordinate data. The method also includes cleaning and aggregating the coordinate data, validating the coordinate data geospatially, and creating an output.
    Type: Application
    Filed: July 23, 2013
    Publication date: January 30, 2014
    Inventors: Michael Lauenstein, Matthew Johnson
  • Patent number: 8639777
    Abstract: A method of redirecting a request (R_act) sent by a terminal equipment (STB) for control of a data stream (FL0) broadcast by a source (HE) in a telecommunications network. The method comprises: on reception of a request to control a data stream sent by a terminal equipment (STB), a step of obtaining info cation representing a current data stream control capacity for a plurality (11) of broadcast servers; a step of selecting, with the aid of the above information, a server (NTSSk0) from said plurality of servers able to control said data stream (FL0) broadcast by the source, a step of sending a request to capture this data stream to the selected server if it is not already capturing the data stream for at least one other terminal equipment; and a step of redirecting the control request to the selected server.
    Type: Grant
    Filed: September 8, 2009
    Date of Patent: January 28, 2014
    Assignee: France Telecom
    Inventors: Frédéric Fieau, Thang Vu Duong
  • Patent number: 8639652
    Abstract: A computer readable medium with executable instructions to receive a job and correlate a data store with each data source associated with the job. A first configuration profile is associated with the data store. A second configuration profile is specified for the data store. Dependent flows are identified. The dependent flow is updated to include additional configuration information derived from the second configuration profile.
    Type: Grant
    Filed: December 14, 2005
    Date of Patent: January 28, 2014
    Assignee: SAP France S.A.
    Inventors: Freda Xu, Wu Cao, Sridhar Ganti, Monfor Yee, Chien Ming Yueh
  • Patent number: 8639653
    Abstract: Methods, system, and computer program products for managing batch operations are provided. A method includes defining a window of time in which a batch will run by entering a batch identifier into a batch table, the batch identifier specifying a primary key of the batch table and is configured as a foreign key to a batch schedule table. The time is entered into the batch schedule table. The method further includes entering extract-transform-load (ETL) information into the batch table. The ETL information includes a workflow identifier, a parameter file identifier, and a location in which the workflow resides. The method includes retrieving the workflow from memory via the workflow identifier and location, retrieving the parameter file, and processing the batch, according to the process, workflow, and parameter file.
    Type: Grant
    Filed: December 12, 2008
    Date of Patent: January 28, 2014
    Assignee: AT&T Intellectual Property I, L.P.
    Inventor: Kyle Linder
  • Patent number: 8639654
    Abstract: A method for updating speed limit, service stop location, or other attributes for road segments in a digital map (18) by extrapolating probe data from a subset of probe data which has been profiled to have originated from trustworthy probe traces. Probe measurements from a plurality of probes is collected and profiled against known information. From this, a subset of trustworthy probes is identified, comprising those probe traces which observe the known attribute of interest within an acceptable range for a majority of the driving time. These trustworthy probe traces are tracked during travel on other road segments whose attribute data is unknown or unreliable. A specification for the unknown or unreliable attribute on the other road segments can be extrapolated based on the collected information from all of the trustworthy probe traces as they travel that road segment. The digital map (18) can then be updated by setting attribute information in relation to the extrapolated behavior data.
    Type: Grant
    Filed: December 31, 2009
    Date of Patent: January 28, 2014
    Assignee: TomTom Global Content B.V.
    Inventors: Gert Vervaet, Tim Bekaert, Pascal Clarysse
  • Publication number: 20140025625
    Abstract: A transformation method and system is provided. The method includes generating a data hub application configured to embed extract, transform, and load (ETL) processes. The data hub application is linked to source tables and target tables. Meta data associated with the source and target tables is transferred from virtual views of the data hub application to an ETL work area of the ETL processes. An ETL job is generated and linked to the data hub application. ETL processes are executed and results are determined.
    Type: Application
    Filed: September 30, 2013
    Publication date: January 23, 2014
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Arundhathi Erla, Ritesh K. Gupta, Madhusmita P. Patil, Swetha Patil, Ramesh Rajagopalan, Bijo A. Thomas
  • Patent number: 8635197
    Abstract: Described herein are methods, systems, apparatuses and products for efficient development of a rule-based system. An aspect provides a method including accessing data records; converting said data records to an intermediate form; utilizing intermediate forms to compute similarity scores for said data records; and selecting as an example to be provided for rule making at least one record of said data records having a maximum dissimilarity score indicative of dissimilarity to already considered examples.
    Type: Grant
    Filed: February 28, 2011
    Date of Patent: January 21, 2014
    Assignee: International Business Machines Corporation
    Inventors: Snigdha Chaturvedi, Tanveer Afzal Faruquie, L. Venkata Subramaniam
  • Patent number: 8635307
    Abstract: A system for policy-based applications may be developed by using non-device specific policies that are executed on a policy engine. During installation, available sensor devices are identified by metadata that describes the devices within a taxonomy of sensor devices, and a separate device policy may be installed and executed by each sensor device. The policy engine, in conjunction with the sensor devices operating a device policy, may be execute a wide range of applications. In many applications, a sensor device may detect that a first policy engine is not available and send communications to a second policy engine that may be accessed through the Internet.
    Type: Grant
    Filed: February 8, 2007
    Date of Patent: January 21, 2014
    Assignee: Microsoft Corporation
    Inventors: Greg Parks, Ruston Panabaker, Andrew Fuller
  • Patent number: 8635252
    Abstract: XBRL data may be automatically mapped back and forth between an XBRL instance an set of automatically generated flat tables, where each table represents the projection of a single hypercube.
    Type: Grant
    Filed: March 19, 2012
    Date of Patent: January 21, 2014
    Assignee: XBRL Cloud, Inc.
    Inventors: Cliff Binstock, Brian Milnes
  • Patent number: 8631050
    Abstract: A transformation engine is disclosed that retrieves source data from a plurality of disparate data sources and provides source data that is consistent and normalized. the transformation engine comprises a plurality of interfaces that receive source data from a plurality of disparate databases. The source data comprises a plurality of data elements. The transformation engine further comprises a converter that aggregates and converts the received source data so that the plurality of data elements are recognizable as being substantially equivalent; a data processor that formats the received source data by merging and preparing the received source data; and a business rule applicator that filters the received source data.
    Type: Grant
    Filed: March 8, 2013
    Date of Patent: January 14, 2014
    Assignee: Eliving, LLC
    Inventor: Noel G. Gayle
  • Patent number: 8626704
    Abstract: A map update data supply device and method includes an update map database of per section versions of an update data file, and a request update data extraction unit for extracting a request update section and an update data file. A safeguard update data extraction unit extracts a safeguard update section to safeguard a road network connection between adjacent sections. An integrated data generation unit integrates all versions of the update data file for each extracted request update section and generates a request update integrated data file. The integrated data generation unit integrates, per safeguard update section, versions of the update data file up to the update safeguard version for each extracted safeguard update section, and generates a safeguard update integrated data file. An integrated data supply unit supplies the generated request update integrated data file and the safeguard update integrated data file to a navigation device.
    Type: Grant
    Filed: January 13, 2011
    Date of Patent: January 7, 2014
    Assignee: Aisin Aw Co., Ltd.
    Inventor: Kimiyoshi Sawai
  • Publication number: 20140006338
    Abstract: A big data analytics system obtains a plurality of manufacturing parameters associated with a manufacturing facility. The big data analytics system identifies first real-time data from a plurality of data sources to store in memory-resident storage based on the plurality of manufacturing parameters. The plurality of data sources are associated with the manufacturing facility. The big data analytics system obtains second real-time data from the plurality of data sources to store in distributed storage based on the plurality of manufacturing parameters.
    Type: Application
    Filed: June 27, 2013
    Publication date: January 2, 2014
    Inventors: Scott Watson, Jamini Samantaray, John Scoville, James Moyne
  • Publication number: 20140006339
    Abstract: A method, system and computer program product for identifying reference data tables in an Extract-Transform-Load (ETL) process, by identifying, by operation of one or more computer processors, at least a first reference data operator in the process, wherein the first reference data operator references one or more tables and evaluating at least a first table referenced by the reference data operator to determine whether the first table is a reference data table by assigning a score to the first table, wherein the score is indicative of the likelihood that the first table is a reference data table and wherein a reference data table contains a set of values that describes other data.
    Type: Application
    Filed: August 28, 2013
    Publication date: January 2, 2014
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Dan J. MANDELSTEIN, Ivan M. Milman, Martin A. Oberhofer, Sushain Pandit
  • Patent number: 8620856
    Abstract: A computer program product comprises a computer useable medium. The computer useable medium has a computer readable program such that when the computer readable medium is executed on a computer, the computer is caused to provide a data interface between an adapter component and one or more application interface components for a runtime application. Further, the computer is caused to establish a cursor that iterates over a plurality of data objects within a data set of the runtime application. In addition, the computer is caused to establish an accessor that provides access to a data element of the data object. The computer is also caused to provide the cursor and the accessor to the adapter component so that the adapter component accesses data through the one or more application interface components of the runtime application.
    Type: Grant
    Filed: January 18, 2008
    Date of Patent: December 31, 2013
    Assignee: International Business Machines Corporation
    Inventors: John Henry Green, Travis Eli Nelson, Piotr Przybylski, Paul Stanley, Suraksha Vidyarthi
  • Patent number: 8620857
    Abstract: Separate subsystems are dedicated to handle fact and dimension data storage and retrieval in an optimized manner. Each subsystem acquires, processes, and stores its data separately in a manner appropriate to the characteristics of that data. A query engine combines the data from each subsystem at query time. When a user queries the system, the query engine interacts with each of the subsystems to fetch the data needed to generate a single result set.
    Type: Grant
    Filed: August 13, 2012
    Date of Patent: December 31, 2013
    Assignee: Google Inc.
    Inventors: Benjamin Weinberger, Manoj Plakal, Will Robinson
  • Patent number: 8620936
    Abstract: In accordance with one or more embodiments, a system for facilitating transfer of data and information over a network includes a database component for storing data and information related to a machine and at least one part thereof, a communication component adapted to communicate with a user via a user device over the network, and a processing component adapted to receive a request for data and information from the user over the network via the user device and process the request by retrieving data and information from the database component related to the machine or the at least one part thereof specified by the user passed with the request. The communication component is adapted to transfer the data and information related to the machine or the at least one part thereof from the database component to the user device for viewing by the user on the user device.
    Type: Grant
    Filed: May 5, 2008
    Date of Patent: December 31, 2013
    Assignee: The Boeing Company
    Inventors: Peter J. Lake, Diana L. Herman, Kenneth D. Bouvier, Matthew K. Fay
  • Patent number: 8620995
    Abstract: The present invention relates to a method for modifying a digital document, comprising steps of detecting embedded data contained in the document; extracting said data from said document; storing said data as a separate file; and replacing said extracted data in said document with a reference to said file. The method may be performed by a transcoding server in order to increase the overall performance of a mobile client terminal equipped with a web browser.
    Type: Grant
    Filed: September 19, 2007
    Date of Patent: December 31, 2013
    Assignee: Opera Software ASA
    Inventor: Håkon Wium Lie
  • Patent number: 8615531
    Abstract: Generally described, the present invention is directed to a network operating system that provides more effective ways of leveraging the connectivity of computer networks. In one embodiment, an XML virtual machine is implemented that accepts high-level application code written in an XML programming language as input. Functionality is provided to interpret or translate the application code written in an XML programming language into code that is suitable for execution across computer platforms. Moreover, the XML virtual machine supports the Model View Controller (MVC) design paradigm that facilitates true data abstraction from applications to a common data model. Multi-instance applications, with each instance potentially supporting multiple views, may be created and executed.
    Type: Grant
    Filed: September 29, 2008
    Date of Patent: December 24, 2013
    Assignee: Xcerion Aktiebolag
    Inventor: Daniel Arthursson
  • Patent number: 8615483
    Abstract: The present invention provides a method of transferring content from a file and a database. In this case, the file includes content instances, each content instance being associated with a respective field, and each field having a respective type. The transfer is achieved by determining the type of each field, and then storing each content instance in a store in accordance with the determined field type of the associated field. Each content instance can then be transferred to the database in accordance with the determined field type. A similar procedure is provided for creating XML files based on content within the database.
    Type: Grant
    Filed: November 26, 2008
    Date of Patent: December 24, 2013
    Assignee: Tralee Software Pty. Ltd.
    Inventor: Jonathon Peter Irons
  • Patent number: 8615587
    Abstract: A data query instruction for execution is received, wherein execution of the data query instruction is to cause a data transfer into or from a data warehouse. The data warehouse includes data servers that are communicatively coupled for data transfer through a link aggregation group having at least two data links. Responsive to receiving the data query instruction and prior to or at least partially overlapping with execution of the data query instruction to cause the data transfer, which of the number of data servers are to receive or transmit data as part of the data transfer is identified; for each of the identified data servers, a minimum number of the at least two data links that are needed for the data transfer are identified; and if inactive, the minimum number of the at least two data links for each of the identified data servers are activated.
    Type: Grant
    Filed: January 11, 2011
    Date of Patent: December 24, 2013
    Assignee: International Business Machines Corporation
    Inventors: Gaurav Mehrotra, Laurent S. Mignet, Abhinay R. Nagpal, Sandeep R. Patil
  • Patent number: 8612530
    Abstract: Various embodiments are directed to testing a pass-through device under test. For example, a computer system may receive a scenario describing a model of a message exchange involving the device under test, which specifies, for at least one message a source address location, a destination address location, and an identifier location. The computer system may also execute a plurality of instances of the scenario. Executing each instance may comprise generating a first outgoing message based on the model of the message exchange; and transmitting the first outgoing message to the device under test. Additionally, the computer system may receive and apply a filter to the first forwarded message from the device under test. Applying the filter may extract a second message exchange identifier value from the identifier location of the first forwarded message. Using the second message exchange identifier, the first forwarded message may be matched to at least one outgoing message.
    Type: Grant
    Filed: October 24, 2011
    Date of Patent: December 17, 2013
    Assignee: Mu Dynamics, Inc.
    Inventors: Dmitrijs F. Sapovalovs, Sundar Vasan, Kowsik Guruswamy
  • Publication number: 20130332407
    Abstract: The present invention relates to data cleansing, and in particular performing the semantic standardization process within a database before the transform portion of the extract-transform-load (ETL) process. Provided are a method, system and computer program product for standardizing data within a database engine, configuring the standardization function to determine at least one standardized value for at least one data value by applying the standardization table in a context of at least one data value, receiving a database query identifying the standardization function, at least one database value and the context of the data, and invoking the standardization function.
    Type: Application
    Filed: June 11, 2012
    Publication date: December 12, 2013
    Applicant: International Business Machines Corporation
    Inventors: Tanveer A. Faruquie, Mukesh K. Mohania, L. V. Subramaniam, Charles D. Wolfson
  • Publication number: 20130332408
    Abstract: The present invention relates to data cleansing, and in particular performing the semantic standardization process within a database before the transform portion of the extract-transform-load (ETL) process. Provided are a method, system and computer program product for standardizing data within a database engine, configuring the standardization function to determine at least one standardized value for at least one data value by applying the standardization table in a context of at least one data value, receiving a database query identifying the standardization function, at least one database value and the context of the data, and invoking the standardization function.
    Type: Application
    Filed: July 31, 2013
    Publication date: December 12, 2013
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: Tanveer A. Faruquie, Mukesh K. Mohania, L. V. Subramaniam, Charles D. Wolfson
  • Patent number: 8606744
    Abstract: Embodiments of the invention enable data to be moved from one or more external sources into a database system. A plurality of processes are executed concurrently. Each of the processes are executable to move data from at least a portion of the one or more external sources into the database system, so that executing the plurality of processes concurrently moves data from different portions of the one or more external sources into the database system in parallel. Execution of the plurality of processes are coordinated from the database system.
    Type: Grant
    Filed: May 31, 2002
    Date of Patent: December 10, 2013
    Assignee: Oracle International Corporation
    Inventors: Benoit Dageville, Allen Brumm
  • Patent number: 8606745
    Abstract: A system provides images or questions to multiple game participants and receives labels or answers in response thereto. The system uses the labels or answers for various data gathering purposes.
    Type: Grant
    Filed: October 3, 2011
    Date of Patent: December 10, 2013
    Assignee: Google Inc.
    Inventors: Taher Haveliwala, Benedict Gomes, Amitabh K Singhal
  • Publication number: 20130325791
    Abstract: A system and method for analyzing data from a plurality of computer environments. A user may search for computer environments that meet a certain criterion. The computer environments are authenticated and data is copied from the computer environments to a memory location. The data may be marked so that a user may determine which computer environment provided the data. The user may add notations to the data during a review. Changes to data on the computer environments may be provided to a user using a syndication feed.
    Type: Application
    Filed: August 2, 2013
    Publication date: December 5, 2013
    Inventors: Jason Shiffer, Matthew Frazier, Sean Cunningham, Scott Hogsten, Eric Helvey, Theodore Wilson
  • Publication number: 20130325792
    Abstract: A system and method for analyzing data from a plurality of computer environments. A user may search for computer environments that meet a certain criterion. The computer environments are authenticated and data is copied from the computer environments to a memory location. The data may be marked so that a user may determine which computer environment provided the data. The user may add notations to the data during a review. Changes to data on the computer environments may be provided to a user using a syndication feed.
    Type: Application
    Filed: August 2, 2013
    Publication date: December 5, 2013
    Inventors: Jason Shiffer, Matthew Frazier, Sean Cunningham, Scott Hogsten, Eric Helvey, Theodore Wilson
  • Publication number: 20130325790
    Abstract: An enterprise application integration system (EAIS) is disclosed that enables customer service applications to access and share data with enterprise information systems in real time.
    Type: Application
    Filed: June 3, 2013
    Publication date: December 5, 2013
    Inventor: Suresh SRINIVASAN
  • Publication number: 20130325788
    Abstract: A method and system for archiving data is provided. The method includes an extraction stage, a load stage, and a production merge stage. In the extraction stage, incoming files from a source system are extracted, where each incoming file has data records. Upon determining that the incoming files are of different data record types, the incoming files are split by record type. The files are also parsed. In a load stage, all files from a load ready directory are placed together in a single batch with a common RUNID for each data record type. In a production merge stage, all files made available from the load stage are processed. The processed files are loaded into a data warehouse. Each stage operates independently of any other stage. Each stage is also iterative and circular.
    Type: Application
    Filed: May 31, 2012
    Publication date: December 5, 2013
    Applicant: Cellco Partnership d/b/a Verizon Wireless
    Inventors: Arthur James Brown, Steve Bilodeau
  • Publication number: 20130325789
    Abstract: An example implementation includes a system having one or more processors, a definition module, a data store, and a workflow module. The definition module is executable by the one or more processors to determine a first semantic element for a first operation included in a first application interface representing a first service and a second semantic element for a second operation included in a second application interface representing a second service, such as an enterprise service bus. The definition module may further determine a mapping of the first semantic element with the second sematic element. The data store is configured to store the mapping of the first semantic element with the second sematic element by the definition module. The workflow module is executable by the one or more processors to integrate the first application interface with the second service based on the mapping.
    Type: Application
    Filed: May 31, 2013
    Publication date: December 5, 2013
    Inventors: Pavitra Krishnan, William Jeffrey Bridwell, Chandra Shekar Bommasamudra
  • Patent number: 8600930
    Abstract: Provided is a conversation assistance device which enables a user to easily search for a desired content. The conversation assistance device includes an input unit, a memory unit, a processing unit, and an output unit. A template database stored in the memory unit includes a plurality of templates. Each of the templates associates category sentences in a plurality of languages with a keyword. A keyword is specified by one keyword expression and one or more character inputs (keyword reading). When the input unit receives any of the plurality of character inputs, an example sentence selection unit retrieves one of the templates having a keyword corresponding to the input character.
    Type: Grant
    Filed: July 23, 2009
    Date of Patent: December 3, 2013
    Assignee: Sharp Kabushiki Kaisha
    Inventors: Ichiko Sata, Norihide Iida
  • Patent number: 8600960
    Abstract: Processing proposed changes to data includes notifying a server of a proposed change to master data, receiving, from the server, an indication as to whether there is a concurrent change to the master data, where the concurrent change corresponds to a change to the master data in addition to the proposed change, and deciding whether to make the proposed change or to abort the change.
    Type: Grant
    Filed: April 14, 2006
    Date of Patent: December 3, 2013
    Assignee: SAP AG
    Inventors: Uwe E. Fischer, Paresh Deshpande, Biju Jatheendran
  • Patent number: 8600929
    Abstract: A method and computer system for aggregating data from a plurality of operational databases are provided. It is determined if a transformation script stored in storage of a computer system has been modified. Delta data extracted from said operational databases and specified by the transformation script is automatically merged and transformed if the transformation script is unmodified. All data extracted from said operational databases and specified by the transformation script is automatically merged and transformed if the transformation script is unmodified.
    Type: Grant
    Filed: March 30, 2010
    Date of Patent: December 3, 2013
    Assignee: Trapeze Software Inc.
    Inventor: Chacko Kattithara Paul
  • Publication number: 20130318032
    Abstract: Third party data embedding may be provided. Data associated with a third party provider may be saved in a native application save file. If a save file opened by the application is determined to comprise third party data, the application may determine whether an appropriate data provider is available. The application may connect to the data provider and provide on-demand, asynchronous access to the third party data upon request from a user.
    Type: Application
    Filed: April 23, 2013
    Publication date: November 28, 2013
    Applicant: Microsoft Corporation
    Inventor: Microsoft Corporation
  • Publication number: 20130318030
    Abstract: A central data warehouse includes embedded data marts. These embedded data marts, referred to as workspaces, are assigned centrally manage data by reference only but rely directly on the centrally managed data and the underlying infrastructure. Workspaces still allow departments in an enterprise to perform certain actions on their own (like adding new data and building new models) without having to instantiate copies of the centrally managed data in a locally managed data mart.
    Type: Application
    Filed: May 23, 2012
    Publication date: November 28, 2013
    Applicant: SAP AG
    Inventors: Klaus Nagel, Rainer Schaefer, Silvia Bratz, Marcus Hoepfner, Patrick Winkler, Matthias Jensen, Dirk Janning
  • Publication number: 20130318033
    Abstract: A method for operating an automation device, into the memory of which an automation solution has been loaded, wherein a technology-oriented control interpreter accesses a data warehouse of the automation solution, and is able to control external commands by virtue of such commands being analyzed and being implemented according to the analysis, where the technology-oriented control interpreter extracts at least one entity designation and at least one instruction from a respective command, the technology-oriented control interpreter searches for an object matching the entity designation in the data warehouse of the automation solution and, in the event of success, checks whether the instruction contained in the command has been defined for the found object, and where the technology-oriented control interpreter causes execution of the instruction for the found object.
    Type: Application
    Filed: May 23, 2013
    Publication date: November 28, 2013
    Inventor: Rudolf POHLAN
  • Publication number: 20130318034
    Abstract: Representative embodiments of a distributed processing method of facilitating interactive analytics of streaming data records by receiving the data records at a plurality of distributed computational nodes, establishing and storing dimensions corresponding to attributes of the data records, parsing the streaming data records to identify matches to at least one of the dimensions and based thereon, reducing the number of data records to create a targeted subset of the data, re-distributing the targeted subsets of the streaming data records among the distributed computational nodes in accordance with the dimensions stored on the nodes, updating a database storing measures of the dimensions in accordance with the targeted subsets of the streaming data records, and using the database to respond to a query based on measures associated with one or more of the dimensions.
    Type: Application
    Filed: May 23, 2013
    Publication date: November 28, 2013
    Inventors: Jaskaran Singh Bawa, Bijay Singh Bisht, Anand Vivek Srivastava, Sumanta Kumar Bhowmik, Atul Kumar Saraf
  • Publication number: 20130318031
    Abstract: Representative embodiments of a distributed processing method of facilitating interactive analytics of streaming data records by receiving the data records at a plurality of distributed computational nodes, establishing and storing dimensions corresponding to attributes of the data records, parsing the streaming data records to identify matches to at least one of the dimensions and based thereon, reducing the number of data records to create a targeted subset of the data, re-distributing the targeted subsets of the streaming data records among the distributed computational nodes in accordance with the dimensions stored on the nodes, updating a database storing measures of the dimensions in accordance with the targeted subsets of the streaming data records, and using the database to respond to a query based on measures associated with one or more of the dimensions.
    Type: Application
    Filed: March 15, 2013
    Publication date: November 28, 2013
    Inventors: Jaskaran Singh Bawa, Bijay Singh Bisht, Anand Vivek Srivastava, Sumanta Kumar Bhowmik, Atul Kumar Saraf
  • Patent number: 8595182
    Abstract: The present invention relates to systems and methods for file association over a network. In an embodiment, a computer-implemented method for file association over a network includes determining a file type associated with a requested file and determining an uploader corresponding to a file type of the requested file. The method further includes executing the determined uploader in order to call at least one remote application associated with the file type of the requested file. In another embodiment, a system for making a file association over a network is provided. The system includes a file type mapper, at least one uploader, and an uploader data structure. In a further embodiment, a system for making a file association over a network includes a file type mapper, a universal uploader, and a universal uploader data structure.
    Type: Grant
    Filed: November 7, 2008
    Date of Patent: November 26, 2013
    Assignee: Google Inc.
    Inventor: Jeffrey Nelson
  • Patent number: 8595181
    Abstract: The present invention is directed to methods and systems for rendering perceivable stimuli representative of information processing by a multi-tenant architecture that pre-fetches a portion of a subset of data on a multi-tenant architecture and emulates a result set of data in accordance with a report definition. To that end the method comprises identifying a subset of data on the multi-tenant architecture that is subject to a report definition. A portion of the subset is pre-fetched and analyzed to emulate a result. The emulated result is transmitted to a computer system of a user of the multi-tenant architecture. Perceivable stimuli is generated on the user computer system, in response to receiving the emulated result.
    Type: Grant
    Filed: April 25, 2011
    Date of Patent: November 26, 2013
    Assignee: salesforce.com, inc.
    Inventor: Guillaume Le Stum
  • Patent number: 8589336
    Abstract: Methods and systems for providing a framework for automated storage processes and flexible workflow are disclosed. The framework provides a user workflow design tool to create and/or customize workflow automation processes without needing to write software code. Additionally, the workflow design tool provides a mechanism that allows the workflow to make decisions, such as selecting storage resources.
    Type: Grant
    Filed: April 25, 2011
    Date of Patent: November 19, 2013
    Assignee: Netapp, Inc.
    Inventors: Assaf Levy, Roy Alon, Michael Yakobi, Ofer Nivy, Vered Rosen
  • Patent number: 8589366
    Abstract: Systems and techniques for extracting data from unstructured documents are described. One such method involves assigning one or more labels to one or more nodes in a first object model of a first web page; comparing a second object model of a second web page to the first object model; if the first object model matches the second object model to a determined degree, extracting from the second web page data associated with nodes in the second object model that match labeled nodes in the first object model; and providing the extracted data for storage in a structured database in a manner associated with the labels.
    Type: Grant
    Filed: November 1, 2007
    Date of Patent: November 19, 2013
    Assignee: Google Inc.
    Inventors: Haakan Younes, Charles F. Schafer, III
  • Publication number: 20130304693
    Abstract: Implementations of complex software solutions are accompanied with an intrinsic conflict between requirements, such as an ever-growing complexity of enterprise software solutions versus a demand for more and more shortened implementation cycles. Various embodiments include at least one of systems methods and software to address such conflicts. One method embodiment includes receiving a request to assemble a virtual appliance from at least one deployment template, the request including characteristic data representative of at least one virtual appliance functional and deployment requirement. In response to the received request, such embodiments may query a template warehouse to identify and deployment templates from a template warehouse to a data storage device to form a virtual appliance. The virtual appliance may then be packaged into a transport data structure and stored. The transport data structure may then be transported by various means to a target virtual machine and deployed therein.
    Type: Application
    Filed: May 9, 2013
    Publication date: November 14, 2013
    Applicant: SAP AG
    Inventors: Peter Jaeger, Ralf Lindenlaub
  • Patent number: 8583593
    Abstract: A relational database warehouse system with query optimization capabilities is described that allows for speedy identification of sets of records of interest from amongst tens of millions of records. The records of interest may include complex derived attributes, generated, at least in part, by aggregating data from a plurality of records in base data tables. In various embodiments, the query optimization capabilities allow the database warehouse system to identify conditions under which normal query execution may be replaced by one or more optimized execution methods, including, for example, eliminating unnecessary inner join operations on base data tables specified by a query, re-ordering the execution of group-by operations and left-outer join operations to greatly reduce the size of join tables produced while processing a query, and/or consolidating a set of segmentation queries for execution in one pass over the records of the database.
    Type: Grant
    Filed: November 18, 2011
    Date of Patent: November 12, 2013
    Assignee: Experian Information Solutions, Inc.
    Inventor: Venkat R. Achanta