Table application programming interfaces (APIs)

• US 9,208,208 B2
• Filed: 11/26/2014
• Issued: 12/08/2015
• Est. Priority Date: 03/15/2013
• Status: Active Grant

• Current Assignee: The MathWorks, Inc.
• Original Assignee: The MathWorks, Inc.
• Inventors: Hicklin, Joseph F., Perkins, Peter C.
• Primary Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US14/554,605
• Publication Number:
  US 20150081748A1
• Time in Patent Office: 377 Days
• Field of Search: 707/791, 707/803, 719/328
• US Class Current: 1/1
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 40/177 of tables; using ruled lines
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

A device receives, in a technical computing environment (TCE), a first variable with a first data type and a particular number of rows, and receives a second variable with a second data type and the particular number of rows. The second data type may be different than the first data type. The device receives a command to create a table based on the first variable and the second variable, and creates, based on the command, a heterogeneous table that includes the first variable and the second variable. The device stores the heterogeneous table, and/or provides the heterogeneous table for display.

Claims

1. A method, executed on a device, comprising:

receiving, in a technical computing environment (TCE), a first variable with a first data type and a particular number of rows,

the receiving the first variable being performed by the device;

receiving a second variable with a second data type and the particular number of rows,

the second data type being different than the first data type, and

the receiving the second variable being performed by the device;

receiving a command to create a table based on the first variable and the second variable,

the command including a syntax of;

table(VAR1, VAR2),

where table corresponds to the command, VAR1 corresponds to the first variable, and VAR2 corresponds to the second variable, and

the receiving the command being performed by the device;

creating, based on the command, a heterogeneous table that includes the first variable and the second variable,

the creating the heterogeneous table being performed by the device; and

storing the heterogeneous table,

the storing the heterogeneous table being performed by the device.

2. The method of claim 1, further comprising:

providing the heterogeneous table for display.

3. The method of claim 1, further comprising:

receiving variable names for the first variable and the second variable; and

receiving row names for rows of the first variable and rows of the second variable

where creating the heterogeneous table comprises;

creating the heterogeneous table based on the command, the variable names, and the row names,

the heterogeneous table including the variable names for columns of the heterogeneous table, and

the heterogeneous table including the row names for rows of the heterogeneous table.

4. The method of claim 1, further comprising:

receiving a file name for a file;

receiving a file type associated with the file;

receiving another command to write the heterogeneous table to the file;

writing, based on the other command, the heterogeneous table to the file with the file name and the file type; and

storing the file.

5. The method of claim 4, where the other command includes a syntax of:

writetable(T, FILENAME, FILETYPE), and

where writetable corresponds to the other command, T corresponds to the heterogeneous table, FILENAME corresponds to the file name, and FILETYPE corresponds to the file type.

6. The method of claim 5, where the file type indicates a default file type.

7. The method of claim 4, where the file type includes one of:

a text file type,

a spreadsheet file type, or

an xport file type.

8. The method of claim 1, further comprising:

receiving a file name for a file,

receiving a file type associated with the file,

receiving another command to read the heterogeneous table from the file, and

reading, based on the other command, the heterogeneous table from the file with the file name and the file type.

9. The method of claim 8,

where the other command includes a syntax of:

readtable(FILENAME, FILETYPE), and

where readtable corresponds to the other command, FILENAME corresponds to the file name, and FILETYPE corresponds to the file type.

10. The method of claim 9, where the file type includes one of:

a text file type,

a spreadsheet file type, or

an xport file type.

11. The method of claim 1, further comprising:

receiving a file name for a file;

receiving another command to write the heterogeneous table to the file; and

writing, based on the other command, the heterogeneous table to the file with the file name,

where the other command includes a syntax of;

write(T, FILENAME), and

where write corresponds to the other command, T corresponds to the heterogeneous table, and FILENAME corresponds to the file name.

12. The method of claim 1, further comprising:

receiving another command to write the heterogeneous table to a file; and

writing, based on the other command, the heterogeneous table to the file,

where the other command includes a syntax of;

write(T),

where write corresponds to the other command, and

where T corresponds to the heterogeneous table.

13. A non-transitory computer-readable medium for storing instructions, the instructions comprising:

one or more instructions that, when executed by a processor of a device, cause the processor to;

receive, in a technical computing environment (TCE), a first variable with a first data type and a particular number of rows,

receive a second variable with a second data type and the particular number of rows,

the second data type being different than the first data type,

receive a command to create a table based on the first variable and the second variable,

the command including a syntax of;

table(VAR1, VAR2),

where table corresponds to the command, VAR1 corresponds to the first variable, and VAR2 corresponds to the second variable,

create, based on the command, a heterogeneous table that includes the first variable and the second variable, and

store the heterogeneous table.

14. The non-transitory computer-readable medium of claim 13, where the instructions further comprise:

one or more instructions that, when executed by the processor, cause the processor to;

provide the heterogeneous table for display.

15. The non-transitory computer-readable medium of claim 13, where the instructions further comprise:

one or more instructions that, when executed by the processor, cause the processor to;

receive variable names for the first variable and the second variable,

receive row names for rows of the first variable and rows of the second variable, and

where the one or more instructions to create the heterogeneous table comprise;

one or more instructions that, when executed by the processor, cause the processor to;

create the heterogeneous table based on the command, the variable names, and the row names,

the heterogeneous table including the variable names for columns of the heterogeneous table, and

the heterogeneous table including the row names for rows of the heterogeneous table.

16. The non-transitory computer-readable medium of claim 13, where the instructions further comprise:

one or more instructions that, when executed by the processor, cause the processor to;

receive a file name for a file,

receive a file type associated with the file,

receive another command to write the heterogeneous table to the file,

write, based on the other command, the heterogeneous table to the file with the file name and the file type, and

store the file.

17. The non-transitory computer-readable medium of claim 16, where the other command includes a syntax of:

writetable(T, FILENAME, FILETYPE), and

where writetable corresponds to the other command, T corresponds to the heterogeneous table, FILENAME corresponds to the file name, and FILETYPE corresponds to the file type.

18. The non-transitory computer-readable medium of claim 17, where the file type indicates a default file type.

19. The non-transitory computer-readable medium of claim 16, where the file type includes one of:

a text file type,

a spreadsheet file type, or

an xport file type.

20. The non-transitory computer-readable medium of claim 13, where the instructions further comprise:

one or more instructions that, when executed by the processor, cause the processor to;

receive a file name for a file,

receive a file type associated with the file,

receive another command to read the heterogeneous table from the file, and

read, based on the other command, the heterogeneous table from the file with the file name and the file type.

21. The non-transitory computer-readable medium of claim 20,

where the other command includes a syntax of:

readtable(FILENAME, FILETYPE), and

where readtable corresponds to the other command, FILENAME corresponds to the file name, and FILETYPE corresponds to the file type.

22. The non-transitory computer-readable medium of claim 21, where the file type includes one of:

a text file type,

a spreadsheet file type, or

an xport file type.

23. The non-transitory computer-readable medium of claim 13,

where the instructions further comprise:

one or more instructions that, when executed by the processor, cause the processor to;

receive a file name for a file,

receive another command to write the heterogeneous table to the file, and

write, based on the other command, the heterogeneous table to the file,

where the other command includes a syntax of;

write(T, FILENAME), and

where write corresponds to the other command, T corresponds to the heterogeneous table, and FILENAME corresponds to the file name.

24. The non-transitory computer-readable medium of claim 13,

where the instructions further comprise:

one or more instructions that, when executed by the processor, cause the processor to;

receive another command to write the heterogeneous table to a file, and

write, based on the other command, the heterogeneous table to the file,

where the other command includes a syntax of;

write(T),

where write corresponds to the other command, and

where T corresponds to the heterogeneous table.

28. The device of claim 15, where the other command includes a syntax of:

writetable(T, FILENAME, FILETYPE), and

where writetable corresponds to the other command, T corresponds to the heterogeneous table, FILENAME corresponds to the file name, and FILETYPE corresponds to the file type.

29. The device of claim 28, where the file type indicates a default file type.

25. A device comprising:

one or more processors to;

receive, in a technical computing environment (TCE), a first variable with a first data type and a particular number of rows,

receive a second variable with a second data type and the particular number of rows,

the second data type being different than the first data type,

receive a command to create a table based on the first variable and the second variable,

the command including a syntax of;

table(VAR1, VAR2),

where table corresponds to the command, VAR1 corresponds to the first variable, and VAR2 corresponds to the second variable,

create, based on the command, a heterogeneous table that includes the first variable and the second variable,

store the heterogeneous table, and

provide the heterogeneous table for display.

26. The device of claim 25,

where the one or more processors are further to:

receive variable names for the first variable and the second variable, and

receive row names for rows of the first variable and rows of the second variable, and

where, when creating the heterogeneous table, the one or more processors are to;

create the heterogeneous table based on the command, the variable names, and the row names,

the heterogeneous table including the variable names for columns of the heterogeneous table, and

the heterogeneous table including the row names for rows of the heterogeneous table.

27. The device of claim 25, where the one or more processors are further to:

receive a file name for a file,

receive a file type associated with the file,

receive another command to write the heterogeneous table to the file,

write, based on the other command, the heterogeneous table to the file with the file name and the file type, and

store the file.

30. The device of claim 27, where the file type includes one of:

a text file type,

a spreadsheet file type, or

an xport file type.

31. The device of claim 27, where the one or more processors are further to:

receive a file name for a file,

receive a file type associated with the file,

receive another command to read the heterogeneous table from the file, and

read, based on the other command, the heterogeneous table from the file with the file name and the file type.

32. The device of claim 31,

where the other command includes a syntax of:

T=readtable(FILENAME, FILETYPE), and

where T corresponds to the heterogeneous table, readtable corresponds to the other command, FILENAME corresponds to the file name, and FILETYPE corresponds to the file type.

33. The device of claim 32, where the file type includes one of:

a text file type,

a spreadsheet file type, or

an xport file type.

34. The device of claim 25,

where the one or more processors are further to:

receive a file name for a file,

receive another command to write the heterogeneous table to the file, and

write, based on the other command, the heterogeneous table to the file,

where the other command includes a syntax of;

write(T, FILENAME), and

where write corresponds to the other command, T corresponds to the heterogeneous table, and FILENAME corresponds to the file name.

35. The device of claim 25,

where the one or more processors are further to:

receive another command to write the heterogeneous table to a file, and

write, based on the other command, the heterogeneous table to the file,

where the other command includes a syntax of;

write(T),

where write corresponds to the other command, and

where T corresponds to the heterogeneous table.