Data Extraction, Transformation, And Loading (etl) Patents (Class 707/602)
-
Patent number: 8645331Abstract: 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: GrantFiled: December 28, 2009Date of Patent: February 4, 2014Assignee: BMC Software, Inc.Inventors: Christopher Y. Blaicher, Kerry C. Tenberg, Randol Keith Bright
-
Patent number: 8645468Abstract: 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: GrantFiled: November 8, 2006Date of Patent: February 4, 2014Assignee: International Business Machines CorporationInventors: Patrick O'Sullivan, Cynthia E. Barber-Mingo, Gary Denner, Ruthie D. Lyle, Carol S. Zimmet
-
Patent number: 8645314Abstract: 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: GrantFiled: March 12, 2008Date of Patent: February 4, 2014Assignee: International Business Machines CorporationInventors: Deanna Lynn Quigg Brown, Dinesh Chandra Coca, Louis Daniel Echevarria, Melissa Jorgette Garcia, Andrew Gary Hourselt, Elena Schneider, Nedzad Taljanovic
-
Patent number: 8645313Abstract: 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: GrantFiled: May 27, 2005Date of Patent: February 4, 2014Assignee: Microstrategy, Inc.Inventors: Benjamin Li, Xinyi Wang, Xiaonan Han, Daniel Kerzner, Hanijanto Soewandi
-
Patent number: 8645315Abstract: 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: GrantFiled: December 6, 2011Date of Patent: February 4, 2014Assignee: NEC CorporationInventor: Shoko Imai
-
Patent number: 8645487Abstract: 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: GrantFiled: December 12, 2006Date of Patent: February 4, 2014Assignee: Samsung Electronics Co., Ltd.Inventors: Hyun-ah Sung, Dae-gyu Bae, Jin-woo Hong, Se-hoon Moon
-
Publication number: 20140032479Abstract: 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: ApplicationFiled: July 23, 2013Publication date: January 30, 2014Inventors: Michael Lauenstein, Matthew Johnson
-
Patent number: 8639777Abstract: 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: GrantFiled: September 8, 2009Date of Patent: January 28, 2014Assignee: France TelecomInventors: Frédéric Fieau, Thang Vu Duong
-
Patent number: 8639652Abstract: 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: GrantFiled: December 14, 2005Date of Patent: January 28, 2014Assignee: SAP France S.A.Inventors: Freda Xu, Wu Cao, Sridhar Ganti, Monfor Yee, Chien Ming Yueh
-
Patent number: 8639653Abstract: 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: GrantFiled: December 12, 2008Date of Patent: January 28, 2014Assignee: AT&T Intellectual Property I, L.P.Inventor: Kyle Linder
-
Patent number: 8639654Abstract: 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: GrantFiled: December 31, 2009Date of Patent: January 28, 2014Assignee: TomTom Global Content B.V.Inventors: Gert Vervaet, Tim Bekaert, Pascal Clarysse
-
Publication number: 20140025625Abstract: 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: ApplicationFiled: September 30, 2013Publication date: January 23, 2014Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Arundhathi Erla, Ritesh K. Gupta, Madhusmita P. Patil, Swetha Patil, Ramesh Rajagopalan, Bijo A. Thomas
-
Patent number: 8635197Abstract: 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: GrantFiled: February 28, 2011Date of Patent: January 21, 2014Assignee: International Business Machines CorporationInventors: Snigdha Chaturvedi, Tanveer Afzal Faruquie, L. Venkata Subramaniam
-
Patent number: 8635307Abstract: 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: GrantFiled: February 8, 2007Date of Patent: January 21, 2014Assignee: Microsoft CorporationInventors: Greg Parks, Ruston Panabaker, Andrew Fuller
-
Patent number: 8635252Abstract: 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: GrantFiled: March 19, 2012Date of Patent: January 21, 2014Assignee: XBRL Cloud, Inc.Inventors: Cliff Binstock, Brian Milnes
-
Patent number: 8631050Abstract: 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: GrantFiled: March 8, 2013Date of Patent: January 14, 2014Assignee: Eliving, LLCInventor: Noel G. Gayle
-
Patent number: 8626704Abstract: 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: GrantFiled: January 13, 2011Date of Patent: January 7, 2014Assignee: Aisin Aw Co., Ltd.Inventor: Kimiyoshi Sawai
-
Publication number: 20140006338Abstract: 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: ApplicationFiled: June 27, 2013Publication date: January 2, 2014Inventors: Scott Watson, Jamini Samantaray, John Scoville, James Moyne
-
Publication number: 20140006339Abstract: 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: ApplicationFiled: August 28, 2013Publication date: January 2, 2014Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Dan J. MANDELSTEIN, Ivan M. Milman, Martin A. Oberhofer, Sushain Pandit
-
Patent number: 8620856Abstract: 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: GrantFiled: January 18, 2008Date of Patent: December 31, 2013Assignee: International Business Machines CorporationInventors: John Henry Green, Travis Eli Nelson, Piotr Przybylski, Paul Stanley, Suraksha Vidyarthi
-
Patent number: 8620857Abstract: 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: GrantFiled: August 13, 2012Date of Patent: December 31, 2013Assignee: Google Inc.Inventors: Benjamin Weinberger, Manoj Plakal, Will Robinson
-
Patent number: 8620936Abstract: 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: GrantFiled: May 5, 2008Date of Patent: December 31, 2013Assignee: The Boeing CompanyInventors: Peter J. Lake, Diana L. Herman, Kenneth D. Bouvier, Matthew K. Fay
-
Patent number: 8620995Abstract: 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: GrantFiled: September 19, 2007Date of Patent: December 31, 2013Assignee: Opera Software ASAInventor: Håkon Wium Lie
-
Patent number: 8615531Abstract: 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: GrantFiled: September 29, 2008Date of Patent: December 24, 2013Assignee: Xcerion AktiebolagInventor: Daniel Arthursson
-
Patent number: 8615483Abstract: 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: GrantFiled: November 26, 2008Date of Patent: December 24, 2013Assignee: Tralee Software Pty. Ltd.Inventor: Jonathon Peter Irons
-
Patent number: 8615587Abstract: 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: GrantFiled: January 11, 2011Date of Patent: December 24, 2013Assignee: International Business Machines CorporationInventors: Gaurav Mehrotra, Laurent S. Mignet, Abhinay R. Nagpal, Sandeep R. Patil
-
Patent number: 8612530Abstract: 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: GrantFiled: October 24, 2011Date of Patent: December 17, 2013Assignee: Mu Dynamics, Inc.Inventors: Dmitrijs F. Sapovalovs, Sundar Vasan, Kowsik Guruswamy
-
Publication number: 20130332407Abstract: 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: ApplicationFiled: June 11, 2012Publication date: December 12, 2013Applicant: International Business Machines CorporationInventors: Tanveer A. Faruquie, Mukesh K. Mohania, L. V. Subramaniam, Charles D. Wolfson
-
Publication number: 20130332408Abstract: 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: ApplicationFiled: July 31, 2013Publication date: December 12, 2013Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATIONInventors: Tanveer A. Faruquie, Mukesh K. Mohania, L. V. Subramaniam, Charles D. Wolfson
-
Patent number: 8606744Abstract: 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: GrantFiled: May 31, 2002Date of Patent: December 10, 2013Assignee: Oracle International CorporationInventors: Benoit Dageville, Allen Brumm
-
Patent number: 8606745Abstract: 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: GrantFiled: October 3, 2011Date of Patent: December 10, 2013Assignee: Google Inc.Inventors: Taher Haveliwala, Benedict Gomes, Amitabh K Singhal
-
Publication number: 20130325791Abstract: 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: ApplicationFiled: August 2, 2013Publication date: December 5, 2013Inventors: Jason Shiffer, Matthew Frazier, Sean Cunningham, Scott Hogsten, Eric Helvey, Theodore Wilson
-
Publication number: 20130325792Abstract: 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: ApplicationFiled: August 2, 2013Publication date: December 5, 2013Inventors: Jason Shiffer, Matthew Frazier, Sean Cunningham, Scott Hogsten, Eric Helvey, Theodore Wilson
-
Publication number: 20130325790Abstract: 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: ApplicationFiled: June 3, 2013Publication date: December 5, 2013Inventor: Suresh SRINIVASAN
-
Publication number: 20130325788Abstract: 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: ApplicationFiled: May 31, 2012Publication date: December 5, 2013Applicant: Cellco Partnership d/b/a Verizon WirelessInventors: Arthur James Brown, Steve Bilodeau
-
Publication number: 20130325789Abstract: 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: ApplicationFiled: May 31, 2013Publication date: December 5, 2013Inventors: Pavitra Krishnan, William Jeffrey Bridwell, Chandra Shekar Bommasamudra
-
Patent number: 8600930Abstract: 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: GrantFiled: July 23, 2009Date of Patent: December 3, 2013Assignee: Sharp Kabushiki KaishaInventors: Ichiko Sata, Norihide Iida
-
Patent number: 8600960Abstract: 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: GrantFiled: April 14, 2006Date of Patent: December 3, 2013Assignee: SAP AGInventors: Uwe E. Fischer, Paresh Deshpande, Biju Jatheendran
-
Patent number: 8600929Abstract: 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: GrantFiled: March 30, 2010Date of Patent: December 3, 2013Assignee: Trapeze Software Inc.Inventor: Chacko Kattithara Paul
-
Publication number: 20130318032Abstract: 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: ApplicationFiled: April 23, 2013Publication date: November 28, 2013Applicant: Microsoft CorporationInventor: Microsoft Corporation
-
Publication number: 20130318030Abstract: 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: ApplicationFiled: May 23, 2012Publication date: November 28, 2013Applicant: SAP AGInventors: Klaus Nagel, Rainer Schaefer, Silvia Bratz, Marcus Hoepfner, Patrick Winkler, Matthias Jensen, Dirk Janning
-
Publication number: 20130318033Abstract: 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: ApplicationFiled: May 23, 2013Publication date: November 28, 2013Inventor: Rudolf POHLAN
-
Publication number: 20130318034Abstract: 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: ApplicationFiled: May 23, 2013Publication date: November 28, 2013Inventors: Jaskaran Singh Bawa, Bijay Singh Bisht, Anand Vivek Srivastava, Sumanta Kumar Bhowmik, Atul Kumar Saraf
-
Publication number: 20130318031Abstract: 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: ApplicationFiled: March 15, 2013Publication date: November 28, 2013Inventors: Jaskaran Singh Bawa, Bijay Singh Bisht, Anand Vivek Srivastava, Sumanta Kumar Bhowmik, Atul Kumar Saraf
-
Patent number: 8595182Abstract: 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: GrantFiled: November 7, 2008Date of Patent: November 26, 2013Assignee: Google Inc.Inventor: Jeffrey Nelson
-
Patent number: 8595181Abstract: 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: GrantFiled: April 25, 2011Date of Patent: November 26, 2013Assignee: salesforce.com, inc.Inventor: Guillaume Le Stum
-
Patent number: 8589336Abstract: 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: GrantFiled: April 25, 2011Date of Patent: November 19, 2013Assignee: Netapp, Inc.Inventors: Assaf Levy, Roy Alon, Michael Yakobi, Ofer Nivy, Vered Rosen
-
Patent number: 8589366Abstract: 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: GrantFiled: November 1, 2007Date of Patent: November 19, 2013Assignee: Google Inc.Inventors: Haakan Younes, Charles F. Schafer, III
-
Publication number: 20130304693Abstract: 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: ApplicationFiled: May 9, 2013Publication date: November 14, 2013Applicant: SAP AGInventors: Peter Jaeger, Ralf Lindenlaub
-
Patent number: 8583593Abstract: 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: GrantFiled: November 18, 2011Date of Patent: November 12, 2013Assignee: Experian Information Solutions, Inc.Inventor: Venkat R. Achanta