Spreadsheet program-based data classification for source target mapping

A technology for electronic forms and user data, which is applied in the fields of electronic digital data processing, program control devices, special data processing applications, etc., can solve the problems of time-consuming, increased data update, correction, expansion costs, etc.

Inactive Publication Date: 2013-04-17
MICROSOFT TECH LICENSING LLC
View PDF4 Cites 5 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This is time consuming and can be frustrating, and adds to the expe...

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Spreadsheet program-based data classification for source target mapping
  • Spreadsheet program-based data classification for source target mapping
  • Spreadsheet program-based data classification for source target mapping

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] overview

[0021] The disclosed aspects provide means for mapping or labeling (eg, manually or automatically) external datasets to classify their attributes into standard information types. Within a spreadsheet application, a user may perform the same or a similar function (or the function may be automatically performed) on his own data spreadsheet-based dataset. Once attributes are classified, other automated processes can be performed. Such automated processes include automatic mapping of external data providers and dataset detection, union and intersection of spreadsheet datasets with external datasets, automatic values ​​and entities for the purpose of improving the data quality of spreadsheet-based datasets matching, and information transfer.

[0022] One aspect relates to a system including a mapping manager component and a revision component. The mapping manager component is configured to perform an automatic correlation between a user spreadsheet schema assoc...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The subject disclosure relates to third party cloud schema matching to a user's data. The user can select the type of data to be looked up from an external source in order for the user's data to be augmented with data from the external source. The user can be presented with a list of service providers that support the selected type of data. Columns from the user's data are associated with supported lookup information types either automatically or manually. Based on the association, data from the external data source is automatically mapped to the user's data and updates are selectively applied to the user's data.

Description

technical field [0001] The present invention relates generally to spreadsheet programs, for example, to spreadsheet-based data classification for source-to-target mapping. Background technique [0002] As computing technology advances and computing devices become more ubiquitous, using a computer has become commonplace for everyday activities. For example, an individual may utilize cloud data services in a cloud computing environment. Cloud computing can provide various computing capabilities (eg, software, data access, storage services, etc.) without requiring users (eg, end users) to be aware of the physical location and / or configuration of the systems delivering the services. [0003] Additionally, users of spreadsheet programs maintain tabular datasets on spreadsheets. Often, users want to correct, improve, and / or augment the data in their spreadsheets (eg, for advertising purposes, for updated information for various purposes, etc.) by interacting with external data s...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
IPC IPC(8): G06F17/30G06F9/44
CPCG06F40/18G06F40/151
Inventor C·埃金斯
Owner MICROSOFT TECH LICENSING LLC
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap