Data file discovery, visualization, and importing

• US 8,862,646 B1
• Filed: 03/25/2014
• Issued: 10/14/2014
• Est. Priority Date: 03/25/2014
• Status: Active Grant

• Current Assignee: Plusamp Incorporated
• Original Assignee: Plusamp Incorporated
• Inventors: Murayama, Toshihiro, Yeskel, William Harris, Epstein, Jonathan
• Primary Examiner(s): Casanova, Jorge A
• Application Number:
  US14/225,139
• Time in Patent Office: 203 Days
• Field of Search: 707/736, 707/831, 715/835
• US Class Current: 707/831
• CPC Class Codes: G06F 16/168 Details of user interfaces specifically adapted to file systems, e.g. browsing and visualisation, 2d or 3d GUIs query results presentation G06F16/156
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 3/0481 based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance

Abstract

Various data source locations storing files can be accessed and/or crawled. At each location, files can be identified. These files can be analyzed to obtain attributes characterizing such file. Thereafter, a visualization can be generated in a graphical user interface that takes the form of data map that characterizes the identified files along two or more dimensions, with each dimension being based on a different attribute of the file. For example, the vertical dimension can be based on a number of columns and the horizontal dimension can be based on a number of rows. The graphical user interface can include graphical user interface elements associated with each identified file. These elements, when activated, can cause complementary information characterizing the corresponding identified file to be displayed. The elements can then be used to import or otherwise utilize one of the identified files into an application (such as a spreadsheet software application.

Claims

1. A method for implementation by one or more data processors forming part of at least one computing system, the method comprising:

accessing or crawling, by at least one data processor, data source locations available to a user to identify files comprising data;

analyzing, by at least one data processor, each identified file to obtain attributes characterizing the file;

generating, by at least one data processor in a graphical user interface, a data map characterizing the identified files along at least two dimensions, a first dimension being based on a first attribute of the corresponding identified file, a second dimension being based on a second attribute of the corresponding identified file, each identified file having a corresponding graphical user interface element, wherein the first attribute comprise a number of rows of a corresponding table and the second attribute comprises a number of columns of the corresponding table;

receiving, by at least one data processor, user-generated input activating one of the graphical user interface elements with a corresponding identified file; and

initiating, by at least one data processor, importation of the identified file corresponding to the activated graphical user interface element into an application;

wherein at least one identified file is individually parsed into two or more components, the attributes are obtained for each component and each component has a different corresponding graphical user interface element within the data map.

2. A method as in claim 1, wherein a size and/or color of each graphical user interface element is based on a further attribute of the corresponding identified file that is different from the first attribute and the second attribute.

3. A method as in claim 1, wherein a shape of each graphical user interface element is based on a further attribute of the corresponding identified file that is different from the first attribute and the second attribute.

4. A method as in claim 1, wherein the data map characterizes the identified files along at least one other dimension with each dimension being based on a different attribute of the corresponding identified file.

5. A method as in claim 1, wherein the data within each identified file comprises tabular data.

6. A method as in claim 1, further comprising:

displaying, by at least one data processor, complementary information characterizing the corresponding identified file in response to the user-generated input.

7. A method as in claim 1, wherein the data source locations are selected from a group consisting of:

local data stores, network accessible data stores, e-mail servers, and cloud-based data storage services.

8. A method as in claim 1, wherein the attributes are selected from a group consisting of:

identified file location, a number of rows, a number of columns, file size, file creation date, application that generated the identified file, file modification date, file access dates, number of times the file has been accessed, file type, author, data ranges, data formats, and keywords contained within the file.

9. A method as in claim 1, wherein the data comprises data to render at least one pivot table.

10. A method as in claim 1, wherein each component comprises a separate set of tabular data.

11. A method as in claim 1, wherein the identified files have types selected from a group consisting of:

.acv, .adp, .ai, .aif, .aiff, .air, .amp, .aod, .aps, .asc, .asf, .aspx, .att, .atf, .atx, .au, .avi, .aux, .bak, .bas, .bck, .bin, .bd, .bkf, .bmc, .bmp, .bud, .cbl, .cc, .cd, .cct, .cda, .cdd, .cdr, .cdt, .cdx, .cfm, .cfml, .clp, .cpp, .cs, .csproj, .cst, .csv .ctl, .ctx, .cur, .cwf, .cxx, .dat, .db, .dbc, .dbf, .dbquery, .dbx, .dir, .doc, .docx, .dot, .dotm, .dotx, .drw, .dwf, .dwfx, .dwg, .dwt, .dxb, .dxf, .dxr, .eml, .eps, .eps2, .exe, .fla, .flk, .fly, .fm, .fp5, .fp7, .frm, .gvp, .gz, .gzip, .hlp, .ht, .htc, .htm, .html, hta, .iif, .img, .ind, .isd, .ism, .iso, .iss, .iwp, .jad, .jar, .java, .jfif, .jgw, .jhtm, .jhtml, .jnl, .job, .jpg, .jpeg, .js, .lab, ldf, .ldif, .lgo, .lha, .lit, .lnk, .lock, .log1, .log2, .lzh, .mlv, .m2ts, .m3u, .m4a, .m4r, .map, .maq, .mar, .marc, .mat, .mco, .md5, .mdb, .mde, .mdf, .mdi, .mdmp, .mht, .mid, .mif, .mim, .mix, .mmap, .mod, .modd, .moff, .mot, .mov, .movie, .moz, .mp2, .mp3, .mp4, .mpe, .mpeg, .mpg, .mpt, .msg, .msdvd, .msg, .msi, .msm, .msp, .mst, .msv, .myd, .myi, .nch, .ncb, .nk2, .nn, .nrg, .nws, .o, .obj, .oca, .ocx, .odc, .oft, .ops, .opt, .pab, .pal, .par, .par2, .part, .pbm, .pce, pdd, .pde, .pdf, .pic, .pict, .pid, .pif, .pip, .pjp, .jpjeg, .pmd, .png, .pot, .ppm, .ppt, .prf, .prn, .ps, .psd, .psp, .pst, .pub, .qif, .qt, .r00, .r01, .r02, .r03, .r04, .r05, .ra, .ram, .rar, .raw, .rc, .rdi, .reg, .rm, .rpc, .rtf, .rtx, .sas, .sas7dbat, .sas7bvew, .sav, .sbl, .sbx, .scf, .scr, .sea, .sfx, .sh, .smi, .snd, .snp, .spo, .sps, .sql, .sqlite, .sqm, .stc, .std, .sti, .stm, .sv7, .sxc, .sxg, .sxm, .sxp, .sxw, .syd, .syo, .sys, .tab, .tar, .tif, .tiff, .tib, .tmb, .tmd, .tsv, .txt, .vb, .vbproj, .vbs, .vbx, .vcf, .vhd, .vm, .vsd, .vsi, .vsix, .vspscc, .vsscc, .vssscc, .wab, .wav, .wave, .wdb, .wer, .whb, .win, .wk1, .wk2, .wk3, .wk4, .wks, .wma, .wmv, .wms, .wmz, .wor, .wp, .wp2, .wp3, .wp4, .wpd, .wpp, .wps, .wpt, .prf, .wrj, .wrl, .wrz, .wtv, .wvf, .wvx, .xhtml, .xla, .xlam, .xlb, .xlc, .xld, .xlk, .xll, .xlm, .xlr, .xls, .xlsb, .xlsm, .xlsx, .xlt, .xltm, .xlv, .xlw, .xml, .xps, .xrp, .xsd, .xslt, .xspf, .xtf, .xxx, zip, .zipx, and .zix format files.

12. A non-transitory computer program product storing instructions which, when executed by one or more data processors forming part of at least one computing system, result in operations comprising:

accessing or crawling, by at least one data processor, data source locations available to a user to identify files comprising data;

analyzing, by at least one data processor, each identified file to obtain attributes characterizing the file;

generating, by at least one data processor in a graphical user interface, a data map characterizing the identified files along at least two dimensions, a first dimension being based on a first attribute of the corresponding identified file, a second dimension being based on a second attribute of the corresponding identified file, each identified file having a corresponding graphical user interface element, wherein the first attribute comprise a number of rows of a corresponding table and the second attribute comprises a number of columns of the corresponding table;

receiving, by at least one data processor, user-generated input activating one of the graphical user interface elements with a corresponding identified file; and

initiating, by at least one data processor, importation of the identified file corresponding to the activated graphical user interface element into an application;

wherein at least one identified file is individually parsed into two or more components, the attributes are obtained for each component and each component has a different corresponding graphical user interface element within the data map.

13. A computer program product as in claim 12, wherein a size and/or color of each graphical user interface element is based on a further attribute of the corresponding identified file that is different from the first attribute and the second attribute.

14. A computer program product as in claim 12, wherein a shape of each graphical user interface element is based on a further attribute of the corresponding identified file that is different from the first attribute and the second attribute.

15. A computer program product as in claim 12, wherein the data map characterizes the identified files along at least one other dimension with each dimension being based on a different attribute of the corresponding identified file.

16. A computer program product as in claim 12, wherein the data within each identified file comprises tabular data.

17. A computer program product as in claim 12, wherein the operations further comprise:

displaying, by at least one data processor, complementary information characterizing the corresponding identified file in response to the user-generated input.

18. A computer program product as in claim 12, wherein the data source locations are selected from a group consisting of:

local data stores, network accessible data stores, e-mail servers, and cloud-based data storage services.

19. A computer program product as in claim 12, wherein the attributes are selected from a group consisting of:

identified file location, a number of rows, a number of columns, file size, file creation date, application that generated the identified file, file modification date, file access dates, number of times the file has been accessed, file type, author, data ranges, data formats, and keywords contained within the file.

20. A computer program product as in claim 12, wherein the data comprises data to render at least one pivot table.

21. A computer program product as in claim 12, wherein each component comprises a separate set of tabular data.

22. A computer program product as in claim 12, wherein the identified files have types selected from a group consisting of:

.acv, .adp, .ai, .aif, .aiff, .air, .amp, .aod, .aps, .asc, .asf, .aspx, .att, .atf, .atx, .au, .avi, .aux, .bak, .bas, .bck, .bin, .bd, .bkf, .bmc, .bmp, .bud, .cbl, .cc, .cd, .cct, .cda, .cdd, .cdr, .cdt, .cdx, .cfm, .cfml, .clp, .cpp, .cs, .csproj, .cst, .csv .ctl, .ctx, .cur, .cwf, .cxx, .dat, .db, .dbc, .dbf, .dbquery, .dbx, .dir, .doc, .docx, .dot, .dotm, .dotx, .drw, .dwf, .dwfx, .dwg, .dwt, .dxb, .dxf, .dxr, .eml, .eps, .eps2, .exe, .fla, .flk, .fly, .fm, .fp5, .fp7, .form, .gvp, .gz, .gzip, .hlp, .ht, .htc, .htm, .html, hta, .iif, .img, .ind, .isd, .ism, .iso, .iss, .iwp, .jad, .jar, .java, .jfif, .jgw, .jhtm, .jhtml, .jnl, .job, .jpg, .jpeg, .js, .lab, .ldf, .ldif, lgo, .lha, .lit, .lnk, .lock, .log1, .log2, .lzh, .m1v, .m2ts, .m3u, .m4a, .m4r, .map, .maq, .mar, .marc, .mat, .mco, .md5, .mdb, .mde, .mdf, .mdi, .mdmp, .mht, .mid, .mif, .mim, .mix, .mmap, .mod, .modd, .moff, .mot, .mov, .movie, .moz, .mp2, .mp3, .mp4, .mpe, .mpeg, .mpg, .mpt, .msg, .msdvd, .msg, .msi, .msm, .msp, .mst, .msv, .myd, .myi, .nch, .ncb, .nk2, .nn, .nrg, .nws, .o, .obj, .oca, .ocx, .odc, .oft, .ops, .opt, .pab, .pal, .par, .par2, .part, .pbm, .pce, pdd, .pde, .pdf, .pic, .pict, .pid, .pif, .pip, .pjp, .jpjeg, .pmd, .png, .pot, .ppm, .ppt, .prf, .prn, .ps, .psd, .psp, .pst, .pub, .qif, .qt, .r00, .r01, .r02, .r03, .r04, .r05, .ra, .ram, .rar, .raw, .rc, .rdi, .reg, .rm, .rpc, .rtf, .rtx, .sas, .sas7dbat, .sas7bvew, .sav, .sbl, .sbx, .scf, .scr, .sea, .sfx, .sh, .smi, .snd, .snp, .spo, .sps, .sql, .sqlite, .sqm, .stc, .std, .sti, .stm, .sv7, .sxc, .sxg, .sxm, .sxp, .sxw, .syd, .syo, .sys, .tab, .tar, .tif, .tiff, .tib, .tmb, .tmd, .tsv, .txt, .vb, .vbproj, .vbs, .vbx, .vcf, .vhd, .vm, .vsd, .vsi, .vsix, .vspscc, .vsscc, .vssscc, .wab, .wav, .wave, .wdb, .wer, .whb, .win, .wk1, .wk2, .wk3, .wk4, .wks, .wma, .wmv, .wms, .wmz, .wor, .wp, .wp2, .wp3, .wp4, .wpd, .wpp, .wps, .wpt, .prf, .wrj, .wrl, .wrz, .wtv, .wvf, .wvx, .xhtml, .xla, .xlam, .xlb, .xlc, .xld, .xlk, .xll, .xlm, .xlr, .xls, .xlsb, .xlsm, .xlsx, .xlt, .xltm, .xlv, .xlw, .xml, .xps, .xrp, .xsd, .xslt, .xspf, .xtf, .xxx, zip, .zipx, and .zix format files.

23. A system comprising:

one or more data processors; and

memory storing instructions which, when executed by the one or more data processors, result in operations comprising;

accessing or crawling data source locations available to a user to identify files comprising data;

analyzing each identified file to obtain attributes characterizing the file;

generating, in a graphical user interface, a data map characterizing the identified files along at least two dimensions, a first dimension being based on a first attribute of the corresponding identified file, a second dimension being based on a second attribute of the corresponding identified file, each identified file having a corresponding graphical user interface element, wherein the first attribute comprise a number of rows of a corresponding table and the second attribute comprises a number of columns of the corresponding table;

receiving user-generated input activating one of the graphical user interface elements with a corresponding identified file; and

initiating importation of the identified file corresponding to the activated graphical user interface element into an application;

wherein at least one identified file is individually parsed into two or more components, the attributes are obtained for each component and each component has a different corresponding graphical user interface element within the data map.

24. A system as in claim 23, wherein a size and/or color of each graphical user interface element is based on a further attribute of the corresponding identified file that is different from the first attribute and the second attribute.

25. A system as in claim 23, wherein a shape of each graphical user interface element is based on a further attribute of the corresponding identified file that is different from the first attribute and the second attribute.

26. A system as in claim 23, wherein the data map characterizes the identified files along at least one other dimension with each dimension being based on a different attribute of the corresponding identified file.

27. A system as in claim 23, wherein the data within each identified file comprises tabular data.

28. A system as in claim 23, wherein the operations further comprise:

displaying, by at least one data processor, complementary information characterizing the corresponding identified file in response to the user-generated input.

29. A system as in claim 23, wherein the data source locations are selected from a group consisting of:

local data stores, network accessible data stores, e-mail servers, and cloud-based data storage services.

30. A system as in claim 23, wherein the attributes are selected from a group consisting of:

identified file location, a number of rows, a number of columns, file size, file creation date, application that generated the identified file, file modification date, file access dates, number of times the file has been accessed, file type, author, data ranges, data formats, and keywords contained within the file.

31. A system as in claim 23, wherein the data comprises data to render at least one pivot table.

32. A system as in claim 23, wherein each component comprises a separate set of tabular data.

33. A system as in claim 23, wherein the identified files have types selected from a group consisting of:

.acv, .adp, .ai, .aif, .aiff, .air, .amp, .aod, .aps, .asc, .asf, .aspx, .att, .atf, .atx, .au, .avi, .aux, .bak, .bas, .bck, .bin, .bd, .bkf, .bmc, .bmp, .bud, .cbl, .cc, .cd, .cct, .cda, .cdd, .cdr, .cdt, .cdx, .cfm, .cfml, .clp, .cpp, .cs, .csproj, .cst, .csv .ctl, .ctx, .cur, .cwf, .cxx, .dat, .db, .dbc, .dbf, .dbquery, .dbx, .dir, .doc, .docx, .dot, .dotm, .dotx, .drw, .dwf, .dwfx, .dwg, .dwt, .dxb, .dxf, .dxr, .eml, .eps, .eps2, .exe, .fla, .flk, .fly, .fm, .fp5, .fp7, .frm, .gvp, .gz, .gzip, .hlp, .ht, .htc, .htm, .html, hta, .iif, .img, .ind, .isd, .ism, .iso, .iss, .iwp, .jad, .jar, .java, .jfif, .jgw, .jhtm, .jhtml, .jnl, .job, .jpg, .jpeg, .js, .lab, .ldf, .ldif, .lgo, .lha, .lit, lnk, .lock, .log1, .log2, .lzh, .m1v, .m2ts, .m3u, .m4a, .m4r, .map, .maq, .mar, .marc, .mat, .mco, .md5, .mdb, .mde, .mdf, .mdi, .mdmp, .mht, .mid, .mif, .mim, .mix, .mmap, .mod, .modd, .moff, .mot, .mov, .movie, .moz, .mp2, .mp3, .mp4, .mpe, .mpeg, .mpg, .mpt, .msg, .msdvd, .msg, .msi, .msm, .msp, .mst, .msv, .myd, .myi, .nch, .ncb, .nk2, .nn, .nrg, .nws, .o, .obj, .oca, .ocx, .odc, .oft, .ops, .opt, .pab, .pal, .par, .par2, .part, .pbm, .pce, pdd, .pde, .pdf, .pic, .pict, .pid, .pif, .pip, .pjp, .jpjeg, .pmd, .png, .pot, .ppm, .ppt, .prf, .prn, .ps, .psd, .psp, .pst, .pub, .qif, .qt, .r00, .r01, .r02, .r03, .r04, .r05, .ra, .ram, .rar, .raw, .rc, .rdi, .reg, .rm, .rpc, .rtf, .rtx, .sas, .sas7dbat, .sas7bvew, .sav, .sbl, .sbx, .scf, .scr, .sea, .sfx, .sh, .smi, .snd, .snp, .spo, .sps, .sql, .sqlite, .sqm, .stc, .std, .sti, .stm, .sv7, .sxc, .sxg, .sxm, .sxp, .sxw, .syd, .syo, .sys, .tab, .tar, .tif, .tiff, .tib, .tmb, .tmd, .tsv, .txt, .vb, .vbproj, .vbs, .vbx, .vcf, .vhd, .vm, .vsd, .vsi, .vsix, .vspscc, .vsscc, .vssscc, .wab, .wav, .wave, .wdb, .wer, .whb, .win, .wk1, .wk2, .wk3, .wk4, .wks, .wma, .wmv, .wms, .wmz, .wor, .wp, .wp2, .wp3, .wp4, .wpd, .wpp, .wps, .wpt, .prf, .wrj, .wrl, .wrz, .wtv, .wvf, .wvx, .xhtml, .xla, .xlam, .xlb, .xlc, .xld, .xlk, .xll, .xlm, .xlr, .xls, .xlsb, .xlsm, .xlsx, .xlt, .xltm, .xlv, .xlw, .xml, .xps, .xrp, .xsd, .xslt, .xspf, .xtf, .xxx, zip, .zipx, and .zix format files.