Merging Schemas Patents (Class 707/808)
  • Patent number: 8307012
    Abstract: Systems and methods are provided for schema mapping and the transformation of data. In accordance with one implementation, a computer-implemented method is provided that comprises loading a conceptual model, wherein the conceptual model contains at least one conceptual object, loading a source schema and a source instance, converting the source schema and the source instance into a source model, and acquiring, from the user, at least one forward mapping usable to map at least a source attribute of the source model to a conceptual attribute of the conceptual model, wherein the forward mapping includes a mapping formula. Further, the method may include loading a target schema and a target instance, converting the target schema and the target instance into a target model, and reverse mapping at least one of conceptual attributes of the conceptual model to a target attribute of the target model based on the forward mapping and the mapping formula.
    Type: Grant
    Filed: February 28, 2006
    Date of Patent: November 6, 2012
    Assignee: SAP AG
    Inventor: Susan Marie Thomas
  • Patent number: 8290989
    Abstract: A name of one or more entity classes of the data model may be refined to conform to a naming convention. A semantic meaning of each of the names and one or more attributes of each entity class may be determined. It may be determined that the name of a first entity class is semantically similar to the name of a second entity class based on a semantic distance between the semantic meaning of the names, where a substantial similarity may be determined between the first entity class and the second entity class by comparing the semantic meaning of the one or more attributes of the first entity class to the semantic meaning of the one or more attributes of the second entity class. The data model may be normalized based on the substantial similarity.
    Type: Grant
    Filed: November 12, 2008
    Date of Patent: October 16, 2012
    Assignee: SAP AG
    Inventors: Gunther Stuhec, Florian Gessner, Jens Lemcke
  • Patent number: 8271547
    Abstract: A method for proofing a prototype dynamic webpage version referencing first configuration data is disclosed. The prototype dynamic webpage can be derived from a live version referencing second configuration data and accessible via a live link. The method includes storing first configuration data in a configuration database also containing second configuration data, providing a prototype link to the prototype dynamic webpage version dissimilar from the live link; and returning, upon a prototype link request, the prototype dynamic webpage version, involving rendering the prototype dynamic webpage version based on the first configuration data without altering the live dynamic webpage version. Also disclosed is a dynamic webpage versioning system working off a configuration database and distinct versions of configuration data.
    Type: Grant
    Filed: May 30, 2006
    Date of Patent: September 18, 2012
    Assignee: ADP Dealer Services, Inc.
    Inventors: Donald H. Taylor, Wade A. Matveyenko, Rajan Krishnamurty
  • Patent number: 8250120
    Abstract: A method for merging media includes the steps of obtaining a first input from a first media device, the first input comprising first data corresponding to properties of one or more first media files, obtaining a second input from a second media device, the second input comprising second data corresponding to properties of one or more second media files, generating a merged list comprising one or more first selected media files of the first media files sharing a common property with at least one of the second media files and second selected media files of the second media files sharing the common property, and causing execution of one of the first selected media files, one of the second selected media files, or both.
    Type: Grant
    Filed: February 24, 2009
    Date of Patent: August 21, 2012
    Assignee: GM Global Technology Operations LLC
    Inventor: Michael J. Quinn
  • Patent number: 8244766
    Abstract: A data search and retrieval system that, in response to a search query, applies a model to search results to generate information to be returned to a user. The model may define characteristics of a persona such that the application of the model generates information consistent with the persona. A persona may be an individual person or a group of people having shared characteristics. A user may be presented with a list of identifiers of available models of personae. When the user selects a model of a particular persona to be applied, the information generated in return to the user may be consistent with the characteristics associated with the selected persona.
    Type: Grant
    Filed: April 13, 2010
    Date of Patent: August 14, 2012
    Assignee: Microsoft Corporation
    Inventors: Vijay Mital, Saurab Nog, Jason A. Wolf, John A. Payne
  • Patent number: 8243316
    Abstract: Disclosed herein is a method of preparing production tickets that involves selecting order data from at least a first data field in an ordering system, feeding the selected order data to a workflow management system, and generating a production ticket for a print production job using at least a portion of the selected order data to name the print production job. One embodiment employs a join identifier to include several related files on the same production ticket. Corresponding configuration tools and workflow management systems also are disclosed.
    Type: Grant
    Filed: July 29, 2011
    Date of Patent: August 14, 2012
    Assignee: Xerox Corporation
    Inventors: Donald M Pangrazio, III, Anthony J Leone, III, Michael J Evan, Connie C He, Nisha Pan, Yolanda Palomo
  • Patent number: 8239411
    Abstract: A first sorting unit includes a second sorting unit that sorts first frequency data for luminance based on a first table, a third sorting unit that sorts second frequency data for chrominance based on a second table, a fourth sorting unit that sorts third frequency data for chrominance based on a third table, and an updating unit that updates the second and third tables based on nonzero information on the first and second frequency data before the third and fourth sorting units start sorting.
    Type: Grant
    Filed: April 13, 2010
    Date of Patent: August 7, 2012
    Assignee: MegaChips Corporation
    Inventors: Yujiro Tani, Kazuyuki Takahashi
  • Publication number: 20120197949
    Abstract: A method to register visitors applies to many events, such as funerals. The method, deployed upon a computer, allows a user to select personalized services. The method also stores event organizer information common to various events. The method then automates the generation of invitations and tracking of RSVPs for an event. Then the method guides event visitors to enter information and comments through a computer into a database. The visitors do so upon a dedicated screen. Following an event, the method provides for production of a book compiling the information and comments of the visitors in a pleasing format suitable for long term use. The method also produces customized printed materials for mailing or emailing to event visitors.
    Type: Application
    Filed: January 27, 2012
    Publication date: August 2, 2012
    Inventors: Tamila N. Taylor, Kelvin J. Taylor
  • Patent number: 8234312
    Abstract: Systems and methods are provided for schema mapping and the transformation of data. In accordance with one implementation, a computer-implemented method is provided that includes the steps of simultaneously displaying to a user, via a graphical user interface, layouts of the first and second documents, wherein the first and second documents have different data schemas and are instantiated with elements containing data values, and acquiring one or more associations from the user to map a first element of the first document to a second element of the second document. The method further includes the steps of indicating to the user a second association between elements in the first and second documents based on the association acquired from the user, and storing the association including the layout data corresponding to the first and second elements.
    Type: Grant
    Filed: February 28, 2006
    Date of Patent: July 31, 2012
    Assignee: SAP AG
    Inventor: Susan Marie Thomas
  • Patent number: 8219596
    Abstract: In one embodiment the present invention includes a computer-implemented method of improving performance of schema matching. The method includes storing a matching topology that maps a first data structure to a second data structure. The method further includes identifying a first portion of the matching topology that is a candidate for improvement as determined according to an incidence graph. The method further includes rewriting the first portion of the matching topology with a second portion according to the incidence graph.
    Type: Grant
    Filed: March 8, 2010
    Date of Patent: July 10, 2012
    Assignee: Sap AG
    Inventor: Eric Peukert
  • Patent number: 8209301
    Abstract: A system (and method) of detecting an error in a database interaction, includes providing information about at least one of at least first and second software systems, and a mapping between at least a portion of the at least first and second software systems, and examining the at least one of the first and second software systems and the mapping to determine an error in an interaction between the at least first and second software systems.
    Type: Grant
    Filed: October 31, 2007
    Date of Patent: June 26, 2012
    Assignee: International Business Machines Corporation
    Inventors: Rajesh Bordawekar, Michael George Burke, Mukund Raghavachari, Oded Shmueli
  • Patent number: 8200702
    Abstract: A content management system (CMS) synchronization mechanism synchronizes content attributes, preferably in metadata, with content documents. For each of one or more content attributes (e.g. metadata fields), a respective content document context is associated. Each attribute is synchronized to content in the content document according to the associated context. Preferably, the content document contains multiple nested files, and context limits synchronization to a subset of files. Synchronization rules, enforced by a synchronization engine, define respective attributes and content to be synchronized, each rule having an associated context in the content document. Rules are preferably created in XML format, and parsed to produce a document object model upon which the synchronization engine operates.
    Type: Grant
    Filed: September 30, 2009
    Date of Patent: June 12, 2012
    Assignee: International Business Machines Corporation
    Inventors: David G. Herbeck, John E. Petri, John P. Ponthempilly
  • Patent number: 8195703
    Abstract: A computer program for inventorying a items with attributes. The items are recorded as encoded items by the program. The program maintains a contents table with attribute records each with an identity field, a name field, and a value field. There is an interface for inputting and retrieving item attribute values. Each encoded item is assigned a unique identity value. Each encoded item is represented by one or more attribute records, each storing (1) the unique identity value in the identity field, (2) an attribute type value associated with a particular attribute in the name field, and (3) an encoded value associated with the particular attribute in the value field.
    Type: Grant
    Filed: December 2, 2008
    Date of Patent: June 5, 2012
    Assignee: Cellco Partnership
    Inventor: Kenneth Whistler
  • Patent number: 8190596
    Abstract: A plurality of sources are registered. A plurality of schemas are constructed, based on the plurality of sources. A desired output is obtained as a conjunctive query. A list of potential connections between at least selected ones of the sources is provided. A plurality of join plans are developed, based on the connections.
    Type: Grant
    Filed: November 28, 2007
    Date of Patent: May 29, 2012
    Assignee: International Business Machines Corporation
    Inventors: Ullas B. Nambiar, Biplav Srivastava
  • Patent number: 8185553
    Abstract: A computer implemented method for generating a report that includes latent information, comprising receiving an input data stream that includes latent information, performing one of normalization, validation, and extraction of the input data stream, processing the input data stream to identify latent information within the data stream that is required for generation of a particular report, wherein said processing of the input data stream to identify latent information comprises of identifying a relevant portion of the input data stream, bounding the relevant portion of the input data stream, classifying and normalizing the bounded data, activating a relevant report template based on said identified latent information, populating said template with template-specified data, and processing the template-specified data to generate a report.
    Type: Grant
    Filed: May 15, 2008
    Date of Patent: May 22, 2012
    Assignee: Dictaphone Corporation
    Inventors: Alwin B. Carus, Harry J. Ogrinc
  • Patent number: 8180799
    Abstract: Methods, systems, and apparatus for dynamically creating tables to store received data. A form that includes data of one or more data types is received. Each of the data types is associated with a corresponding field type. The data types in the form are identified, and a storage location configured to store data of the field-type is accessed. Field types in the storage location are compared with those of the received data, and on determining that a portion of the data is of a data type that the storage location is not configured to store, the storage location is modified to store that portion of the data.
    Type: Grant
    Filed: April 12, 2010
    Date of Patent: May 15, 2012
    Assignee: FormRouter Inc.
    Inventors: James J. Healy, David Richard Conorozzo
  • Patent number: 8180810
    Abstract: Methods, systems and computer program products for interactive generation of integrated schemas. Exemplary embodiments include a method for schema integration, the method including recasting a first source schema into a first graph of concepts with HasA relationships, recasting a second source schema into a second graph of concepts with HasA relationships, identifying matching concepts in the first graph and the second graph based on correspondences between attributes of the concepts of the first and second graphs, producing an integrated schema, based on a fixed specification of matching concepts to merge, and generating a mapping from the first source schema to the integrated schema and from the second source schema to the integrated schema.
    Type: Grant
    Filed: August 21, 2008
    Date of Patent: May 15, 2012
    Assignee: International Business Machines Corporation
    Inventors: Laura Chiticarlu, Phokion Kolaitis, Lucian Popa
  • Patent number: 8180774
    Abstract: A system and method for obtaining and processing web-scale data are provided herein. More particularly, a web-scale data processing system and method for crawling, storing, processing, encoding, and/or serving web-scale data are disclosed.
    Type: Grant
    Filed: October 2, 2009
    Date of Patent: May 15, 2012
    Assignee: SEOmoz, Inc.
    Inventors: Benjamin Cappel Hendrickson, Nicholas Stefan Gerner
  • Patent number: 8150881
    Abstract: To provide a human relationships registering system, a method and a server for registering human relationships, a program for registering human relationships, and a medium storing human relationships registering program and readable by a computer, all of which are used to establish wide and close relationships with members having a variety of occupations or engaged in various technical fields and to obtain expert knowledge or information. The human relationships registering system comprises first data processing units 2 and 3 including sections for receiving personal data of a new member, and a second data processing unit including a section for storing the received personal data. The second data processing unit stores the personal data of the new member in correlation to an existing member when the existing member confirms the new member.
    Type: Grant
    Filed: October 29, 2010
    Date of Patent: April 3, 2012
    Assignees: Mekiki Co., Ltd., Mekiki Creates Co., Ltd.
    Inventors: Hikaru Deguchi, Kenichi Ninomiya
  • Patent number: 8135749
    Abstract: To provide a human relationships registering system, a method and a server for registering human relationships, a program for registering human relationships, and a medium storing human relationships registering program and readable by a computer, all of which are used to establish wide and close relationships with members having a variety of occupations or engaged in various technical fields and to obtain expert knowledge or information. The human relationships registering system comprises first data processing units 2 and 3 including sections for receiving personal data of a new member, and a second data processing unit including a section for storing the received personal data. The second data processing unit stores the personal data of the new member in correlation to an existing member when the existing member confirms the new member.
    Type: Grant
    Filed: October 29, 2010
    Date of Patent: March 13, 2012
    Assignees: Mekiki Co., Ltd., Mekiki Creates Co., Ltd.
    Inventors: Hikaru Deguchi, Kenichi Ninomiya
  • Patent number: 8135748
    Abstract: Disclosed is a method and system for selectively restoring file-level data from a disk image backup. In embodiments, a virtual machine backup may be performed by dividing a virtual machine virtual disk file into a plurality of discrete fixed-sized data blocks sharing a common index file that is stored on a backup medium, such as a hard drive, to form a backup set. Upon restoration of data from the backup set, individual blocks of the data set are compared to corresponding blocks of the target virtual machine file. Redundant data and unchanged blocks are skipped, and only those block which have changed are restored to the target file. In this manner network bandwidth and processor resources are conserved, and replication times decreased.
    Type: Grant
    Filed: April 12, 2010
    Date of Patent: March 13, 2012
    Assignee: PHD Virtual Technologies
    Inventors: James Rosikiewicz, Ronald T. McKelvey, Alexander D. Mittell
  • Patent number: 8135753
    Abstract: A dynamic information hierarchy may be provided. Logging data comprising a captured user event and a component ID associated with a hierarchical node may be stored in a raw data table. The stored data may be aggregated across the nodes of the hierarchy, stored in an aggregation table, and provided to a user in a report.
    Type: Grant
    Filed: July 30, 2009
    Date of Patent: March 13, 2012
    Assignee: Microsoft Corporation
    Inventor: Mingyang Zhao
  • Publication number: 20120059809
    Abstract: A computer-implemented method comprises receiving a request for content from a user, determining two user lists that are associated with the user, each user list including a definition that characterizes members of a respective user list, determining a consumer is a subscriber to the two user lists, determining the consumer has indicated a preference to target members that are included in both user lists, and providing an indication to the consumer for all users that are included in both user lists including providing the definitions associated with both user lists along with the request to the consumer.
    Type: Application
    Filed: August 30, 2011
    Publication date: March 8, 2012
    Applicant: GOOGLE INC.
    Inventors: Vadim Furman, Rajas Moonka, Anurag Agarwal
  • Patent number: 8121976
    Abstract: A method and apparatus for creating a schema definition from a language-specific metamodel of a data structure written in a legacy computer language involves walking through the nodes of the metamodel, and creating corresponding schema element objects in a schema tree that is serialized to create the schema definition. The creation of the schema element objects follows rules, and permits the definition of nested data structures having conjunctive-type and disjunctive-type membership.
    Type: Grant
    Filed: May 12, 2009
    Date of Patent: February 21, 2012
    Assignee: International Business Machines Corporation
    Inventors: Suman K. Kalia, Sheng Fang, John H. Green
  • Patent number: 8095871
    Abstract: A GUI (Graphical User Interface) supported specification method for form field extraction and database mapping in a computer system that includes converting a form file into a fixed electronic document format by using a GUI which is used to specify the form file and conversion parameters and extracting fields from the fixed electronic document format by using the GUI that is used to specify the fields to be extracted; and mapping the fields onto the database schema by using a GUI which is used to specify the mapping between the fields and the database schema.
    Type: Grant
    Filed: May 5, 2005
    Date of Patent: January 10, 2012
    Assignee: Siemens Corporation
    Inventors: Peiya Liu, Sridharan Palanivelu, Liang H. Hsu
  • Patent number: 8055623
    Abstract: Provided are a system and article of manufacture for merging metadata on files in a backup storage. A query is received for information on files from a file system for a client node. A determination is made of metadata for files in a backup storage for the client node stored external to backup sets. At least one backup set in the backup storage for the client node is processed to determine metadata for files included in at least one backup set. The determined metadata for files in the backup storage and for files included in at least one backup set is merged to form merged metadata. The query is executed against the merged metadata to determine files whose metadata satisfies the query. Results including information from the merged metadata on the determined files are returned.
    Type: Grant
    Filed: November 4, 2008
    Date of Patent: November 8, 2011
    Assignee: International Business Machines Corporation
    Inventors: Matthew Joseph Anglin, Ken Eugene Hannigan, Mark Alan Hayes, Avishai Haim Hochberg
  • Patent number: 8055498
    Abstract: The present invention automatically builds a contracted dictionary from a given list of multi-word proper names and performs fuzzy searches in the contracted dictionary. The contracted dictionary of proper names includes two linked trie-based dictionaries: a first dictionary is used to store single word names, each word name having an ID number; and a second dictionary is used to store multi-word names encoded with ID numbers. Information related to the multi-word names is also stored as a gloss to the terminal node of the multi-word entry of the trie-based dictionary. An approximate lookup for a multi-word name is conducted first for each word of the multi-word name using an approximate matching technique such as a phonetic proximity or a simple edit distance. Accordingly, N suggestions is determined for each word of the multi-word name under consideration. Then, multi-word candidates are assembled in ID notation.
    Type: Grant
    Filed: September 24, 2007
    Date of Patent: November 8, 2011
    Assignee: International Business Machines Corporation
    Inventors: Hisham El-Shishiny, Pavel Volkov
  • Publication number: 20110270844
    Abstract: A method, system and program product for data evolution on column oriented databases is disclosed. For an input evolution operation, reusable and non-reusable attributes are identified. For attributes in a target schema that cannot be reused from the source schema, data and bitmap indexes of those attributes are generated from source data and bitmap indexes. A decompose operation is disclosed for decomposing a table into two tables. A merge operation is disclosed in which only one input table can be reused for mergence. A second merge operation is disclosed in which both input tables cannot be reused for mergence.
    Type: Application
    Filed: May 3, 2010
    Publication date: November 3, 2011
    Applicant: INTERNATIONAL BUSINESS MACHINES CORPORATION
    Inventors: BIN HE, HUI-I HSIAO
  • Patent number: 8023134
    Abstract: Disclosed herein is a method of preparing production tickets that involves selecting order data from at least a first data field in an ordering system, feeding the selected order data to a workflow management system, and generating a production ticket for a print production job using at least a portion of the selected order data to name the print production job. One embodiment employs a join identifier to include several related files on the same production ticket. Corresponding configuration tools and workflow management systems also are disclosed.
    Type: Grant
    Filed: June 30, 2006
    Date of Patent: September 20, 2011
    Assignee: Xerox Corporation
    Inventors: Donald M. Pangrazio, III, Anthony J. Leone, III, Michael J. Evan, Connie C. He, Nisha Pan, Yolanda Palomo
  • Patent number: 8019794
    Abstract: A firmware repository includes an Extensible Markup Language (XML) description file. A system and method for managing the repository is described.
    Type: Grant
    Filed: April 2, 2007
    Date of Patent: September 13, 2011
    Assignee: Sharp Laboratories of America, Inc.
    Inventors: Rabindra Pathak, Eric Thomas Olbricht, Gregory Eugene Borchers
  • Patent number: 8019736
    Abstract: A present novel and non-trivial system and methods for exacting terrain elevation data contained in a plurality of terrain elevation databases or data sets, combining the terrain elevation data contained in each terrain elevation data set to produce a single, combined terrain database of a common resolution. A system is disclosed that could provide a processor with terrain elevation data from a plurality of terrain elevations data sets having differing resolution and accuracy parameters, a per-point error metric data from a plurality of error metric data sets, and a common resolution parameter. A method is disclosed which for combining terrain elevation data sets having difference resolutions into a single, combined terrain elevation data set having a common resolution utilizing a per-point error metric data from a plurality of error metric data sets.
    Type: Grant
    Filed: July 25, 2007
    Date of Patent: September 13, 2011
    Assignee: Rockwell Collins, Inc.
    Inventors: Alex Postnikov, Jason C. Wenger, Karen L. Walling, Andrew M. Pelzer, Victoria C. Bowman
  • Patent number: 7996759
    Abstract: One embodiment in accordance with the invention relates to inserting data (e.g., XML data) from a database into an electronic template form that includes a table. Furthermore, each table can expand to fit any amount of inserted data and can also expand onto additional pages. The additional pages may have the format of supplemental pages that include the expanded table or that of duplicate pages that also include the other information (e.g., brief description of the table, letterhead, etc.) that was included on the first page. The font size and space can be calculated along with the line wrap for the supplemental page format or duplicate page format.
    Type: Grant
    Filed: September 14, 2005
    Date of Patent: August 9, 2011
    Assignee: Oracle Internatonal Corporation
    Inventor: Osama Elkady
  • Patent number: 7995759
    Abstract: A system and method provide parallel compression of a single data stream is provided. A data stream entering a storage encryption processor is split by a splitting stage into a plurality of substantially equal segments. Each of the segments is stored in one of a first set of memories in a round robin fashion. Each memory has an associated compression core that reads the segments associated with each memory and compresses the data before storing the compressed segments in a second set of memories. A merging stage reads the compressed segments from the second set of memories and creates a single compressed data stream.
    Type: Grant
    Filed: September 28, 2006
    Date of Patent: August 9, 2011
    Assignee: NetApp, Inc.
    Inventor: Joakim Bengt Lennart Tolfmans
  • Patent number: 7979476
    Abstract: An information processing apparatus which makes it possible to insert data into any form template that is specified. A data input/output control system 104 as the information processing apparatus processes a form template including at least one field into which database data is inserted. An identifier management section 108 extracts identifiable identifiers from identifiers of fields on a plurality of different form templates.
    Type: Grant
    Filed: February 6, 2008
    Date of Patent: July 12, 2011
    Assignee: Canon Kabushiki Kaisha
    Inventor: Koji Inose
  • Patent number: 7970761
    Abstract: A content management system (CMS) includes a component identification mechanism for identifying components in a component-centric way that takes into account specified conditions for a link location in a compound document as well as component relationships and conditions. By using the relationships and conditions, a more intelligent choice may be made when identifying components for a particular link location. The identifying of components for a given link location in a compound document may be used by the content management system when auto-population is enabled, and may be used by the content management system to provide a list of candidate components to a user when auto-suggestion is enabled.
    Type: Grant
    Filed: February 26, 2008
    Date of Patent: June 28, 2011
    Assignee: International Business Machines Corporation
    Inventor: John E. Petri
  • Patent number: 7966291
    Abstract: A repository contains objects including facts about entities. Some objects might be associated with the same entity. An object merge engine identifies a set of merge candidate objects. A grouping module groups the merge candidate objects based on the values of facts included in the objects. An object comparison module compares pairs of objects in each group to identify evidence for and/or against merging the pair. Evidence for merging the pair exists if, e.g., the objects have a type in common or share an uncommon fact. Evidence against merging the pair exists if, e.g., the objects have differing singleton attributes. A graph generation module generates graphs describing the evidence for and/or against merging the pair. A merging module analyzes the graphs and merges objects associated with the same entity. The merged objects are stored in the repository.
    Type: Grant
    Filed: June 26, 2007
    Date of Patent: June 21, 2011
    Assignee: Google Inc.
    Inventors: Nemanja Petrovic, David Vespe, Alexander Kehlenbeck, Farhan Shamsi
  • Patent number: 7930680
    Abstract: XML Schema Designs for environment-specific types based on XML base types are disclosed. The invention provides a series of “base types” in the XML Schema. Each base type is in an environment-specific XML Schema namespace that disambiguates the environment's types from all other types defined by any other environment. The XML Schema Design then defines the final type as an anonymous type, derived from the environment-specific base type. The base type is defined with any XML Schema type facets that apply to all derivatives of the base type, and the anonymous final type is defined with additional XML Schema type facets to fully describe the type.
    Type: Grant
    Filed: July 8, 2005
    Date of Patent: April 19, 2011
    Assignee: Microsoft Corporation
    Inventors: Donald W. Dumitru, Joel M. Soderberg, Michael Rys
  • Patent number: 7908301
    Abstract: An XML join between XML documents can be performed by comparing XML elements between the XML documents, obtaining join-selection elements from a first XML document, obtaining join-required elements from one or more other XML documents, and performing the XML join using the elements in the first XML document and the join-required elements. The XML documents can be at different locations connected via a network. Where two XML documents are at different locations, the join-selection elements can be transmitted from a first location (of a first XML document) to a second location (of a second XML document). The join-required elements can be obtained at the second location and transmitted back to the first location. The XML join can then be performed at the first location.
    Type: Grant
    Filed: March 28, 2008
    Date of Patent: March 15, 2011
    Assignee: Infosys Technologies Ltd.
    Inventors: Srinivas Padmanabhuni, Sriram Anand, Krishnendu Kunti, Mohit Chawla
  • Publication number: 20110055291
    Abstract: A first data set is gathered from a first server computer, and second data set is gathered from a second server computer. The first server computer may include a first database storing first aspects of subscriber data and a first interface configured to access the first database. The second server computer may include a second database storing second aspects of subscriber data and a second interface configured to access the second database. The first data set and the second data set are transformed into an integrated data set by merging the first data set and the second data set into the integrated data set. A central interface configured to access the integrated data set and bypass the first interface and the second interface is provided. The central interface may be configured to concurrently display the first aspects of subscriber data and the second aspects of subscriber data through a computer.
    Type: Application
    Filed: August 31, 2009
    Publication date: March 3, 2011
    Inventors: Bryn Henderson, Walter G. Bullard, Lynn D. Larrow
  • Patent number: 7895174
    Abstract: Embodiments are provided to define relationships for merging template or database part tables with one or more database tables in a computer system. A database application may utilize a schema to receive metadata associated with a target database part table in one or more markup language elements. The database application may then receive metadata associated with a source database table to be joined with the target table in the schema elements. The database application may then receive join type metadata in the schema elements. The join type metadata may specify whether fields from the source table are to be merged into the target table or whether fields from the target table are to be merged into the source table. In response to receiving the target table metadata and the source table metadata, the database application may then merge the target and source tables utilizing the join type metadata.
    Type: Grant
    Filed: March 27, 2008
    Date of Patent: February 22, 2011
    Assignee: Microsoft Corporation
    Inventors: Michael J. McCormack, Scott T. Gardner, Andrew R. Miller, Sumit Chauhan, Jason A. Bould
  • Publication number: 20110040805
    Abstract: Techniques for parallel business intelligence and management are provided. Data is collected from a variety of disparate sources and from a variety of disparate network locations. The data is then filtered and normalized. Next, relationships between elements in the data are established and correlations are created between the elements. The elements are then tagged and integrated with other data of a distributed knowledge store to create customized business intelligence reports and customized data visualizations.
    Type: Application
    Filed: October 28, 2009
    Publication date: February 17, 2011
    Inventors: Stephen R. Carter, Lee Edward Lowry, Vernon Roger Holm, Atul Mahajan
  • Patent number: 7870166
    Abstract: Methods and Apparatus related to generating representations of information. The information may include menu information for merchants such as restaurants. Referring to menus, methods may include receiving potential information for a first menu, and receiving indications of associations of the information with the first menu and/or any number of additional menus. Information and/or associations may later be updated by a desired set of users.
    Type: Grant
    Filed: September 24, 2007
    Date of Patent: January 11, 2011
    Assignee: CFPH, LLC
    Inventor: Howard W. Lutnick
  • Patent number: 7831614
    Abstract: A method for generating a structured query language (SQL) script based on a template includes selecting one object from a plurality of objects in a data model. At least one instruction is selected based, at least in part, on a type of the selected object and, then, an associated template string is selected based on each selected instruction. At least a portion of a SQL script is automatically generated based on the one or more selected template strings.
    Type: Grant
    Filed: July 9, 2004
    Date of Patent: November 9, 2010
    Assignee: Computer Associates Think, Inc.
    Inventor: Tad A. Deffler
  • Publication number: 20100274821
    Abstract: Techniques described herein describe a schema and taxonomy matching process that uses clicklogs to map a schema for source data to a schema for target data. A search engine may receive source data that is structured using the source schema, and the search engine itself may contain target data structured using the target schema. Using query distributions derived from the clicklogs, the source schema may be mapped to the target schema. The mapping can be used to integrate the source data into the target data and to index the integrated data for a search engine.
    Type: Application
    Filed: April 22, 2009
    Publication date: October 28, 2010
    Applicant: Microsoft Corporation
    Inventors: Philip A. Bernstein, Arnab Nandi
  • Patent number: 7822782
    Abstract: A system implemented on a computer is disclosed for automatically identifying strains of partial or complete capsid sequences of picorna and caliciviruses, two of the most highly diverse ssRNA virus families.
    Type: Grant
    Filed: September 21, 2007
    Date of Patent: October 26, 2010
    Assignee: The University of Houston System
    Inventors: Sugoto Chakravarty, Dianhui Zhu, George E. Fox
  • Patent number: 7822718
    Abstract: Techniques are described for reliable restoration of archived configuration. For example, a device, such as a router, comprises a first memory to store operational configuration data and a second memory to store candidate configuration data. The candidate configuration data represents a working copy of the operational configuration data. The device further includes a control unit to lock the candidate configuration data, load archived configuration data to replace the locked candidate configuration data and commit the candidate configuration data to restore the archived configuration data as the operational configuration data of the device. In locking the candidate configuration, the device ensures reliable restoration of the candidate configuration by helping prevent the device from becoming both unreachable and inoperable.
    Type: Grant
    Filed: April 21, 2009
    Date of Patent: October 26, 2010
    Assignee: Juniper Networks, Inc.
    Inventors: Reid E. Wilson, Philip A. Shafer
  • Patent number: 7818349
    Abstract: An ultra-shared-nothing parallel database system includes at least one master node and multiple slave nodes. A database consisting of at least one fact table and multiple dimension tables is partitioned and distributed across the slave nodes of the database system so that queries are processed in parallel without requiring the transfer of data between the slave nodes. The fact table and a first dimension table of the database are partitioned across the slave nodes. The other dimension tables of the database are duplicated on each of the slave nodes and at least one of these other dimension tables is partitioned across the slave nodes.
    Type: Grant
    Filed: February 17, 2005
    Date of Patent: October 19, 2010
    Assignee: DATAllegro, Inc.
    Inventor: Stuart Frost
  • Patent number: 7818351
    Abstract: There is provided a database analysis program, a database analysis apparatus, and a database analysis method capable of detecting a relation between fields in a plurality of tables.
    Type: Grant
    Filed: November 1, 2006
    Date of Patent: October 19, 2010
    Assignee: Fujitsu Limited
    Inventors: Yoshihide Nomura, Tsuyoshi Kanai
  • Patent number: 7792840
    Abstract: Disclosed relates to a structure of two-level n-gram inverted index and methods of building the same, processing queries and deriving the index that reduce the size of n-gram inverted index and improves the query performance by eliminating the redundancy of the position information that exists in the n-gram inverted index. The inverted index of the present invention comprises a back-end inverted index using subsequences extracted from documents as a term and a front-end inverted index using n-grams extracted from the subsequences as a term. The back-end inverted index uses the subsequences of a specific length extracted from the documents to be overlapped with each other by n?1 (n: the length of n-gram) as a term and stores position information of the subsequences occurring in the documents in a posting list for the respective subsequences.
    Type: Grant
    Filed: August 9, 2006
    Date of Patent: September 7, 2010
    Assignee: Korea Advanced Institute of Science and Technology
    Inventors: Kyu-Young Whang, Min-Soo Kim, Jae-Gil Lee, Min-Jae Lee
  • Patent number: 7792839
    Abstract: The present system indexes a plurality of entries in a database that contains a database table having a base index. As a recent row is inserted in the database table, an index increment is generated based on the inserted row. Preferably, the index increment is smaller in size than the base index because it is recently generated. The smaller size of the index increment facilitates the management of the index increment. An index entry associated with the inserted row is added to the index increment, and the index increment is merged with the base index.
    Type: Grant
    Filed: November 10, 2005
    Date of Patent: September 7, 2010
    Assignee: International Business Machines Corporation
    Inventors: Namik Hrle, James Zu-Chia Teng