Creating data warehouse views for input tables
AssigneeSigma Computing, Inc.
InventorsGREGORY G. OWEN, STIPO JOSIPOVIC, IAN GARDNER, JAMES L. GALE, KANG-HUA WU
Life of this patent
Estimating the term…
Abstract
Creating data warehouse views for input tables including: selecting, by a workbook manager, a subset of columns of an input table stored in a cloud-based data warehouse, wherein the subset of columns excludes one or more metadata columns of the input table; generating, by the workbook manager, a view of the input table based on the subset of columns; and storing, by the workbook manager, the view of the input table in the cloud-based data warehouse.
Claims20
A method for creating data warehouse views for input tables, the method comprising:
- selecting, by a workbook manager, a subset of columns of an input table stored in a cloud-based data warehouse, wherein the subset of columns excludes one or more metadata columns of the input table;
- generating, by the workbook manager, a view of the input table based on the subset of columns;
- and
- storing, by the workbook manager, the view of the input table in the cloud-based data warehouse.
An apparatus for creating data warehouse views for input tables, the apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions that, when executed by the computer processor, cause the apparatus to carry out the steps of:
- selecting, by a workbook manager, a subset of columns of an input table stored in a cloud-based data warehouse, wherein the subset of columns excludes one or more metadata columns of the input table;
- generating, by the workbook manager, a view of the input table based on the subset of columns;
- and
- storing, by the workbook manager, the view of the input table in the cloud-based data warehouse.
A computer program product for creating data warehouse views for input tables, the computer program product disposed upon a computer readable medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out the steps of:
- selecting, by a workbook manager, a subset of columns of an input table stored in a cloud-based data warehouse, wherein the subset of columns excludes one or more metadata columns of the input table;
- generating, by the workbook manager, a view of the input table based on the subset of columns;
- and
- storing, by the workbook manager, the view of the input table in the cloud-based data warehouse.
Dependencies are inferred from the claim text.