Patents by Inventor Joshua Lockerman
Joshua Lockerman has filed for patents to protect the following inventions. This listing includes patent applications that are pending as well as patents that have already been granted by the United States Patent and Trademark Office (USPTO).
-
Patent number: 11138175Abstract: A database system stores both compressed and uncompressed data in a row-based database system. The database system converts a representation of data involving a set of rows of a source database table, each row comprising multiple values, into a representation involving a single row stored in a target database table, each column of the row comprising arrays of values from the set. The database system may perform type-specific compression of data when storing in the target database table. Accordingly, the database system may apply different compression schemes for different columns or sets of values obtained from the source database table and may group or order selected rows or store additional summary information to improve query performance to the target database table. The database system allows users to query data stored in compressed form. The database system combines compressed and uncompressed data at query time for efficient database analytics.Type: GrantFiled: February 26, 2021Date of Patent: October 5, 2021Assignee: Timescale, Inc.Inventors: Matvey Arye, Gayathri Priyalakshmi Ayyappan, Michael J. Freedman, Sven Klemm, David Kohn, Joshua Lockerman
-
Publication number: 20210191915Abstract: A database system stores both compressed and uncompressed data in a row-based database system. The database system converts a representation of data involving a set of rows of a source database table, each row comprising multiple values, into a representation involving a single row stored in a target database table, each column of the row comprising arrays of values from the set. The database system may perform type-specific compression of data when storing in the target database table. Accordingly, the database system may apply different compression schemes for different columns or sets of values obtained from the source database table and may group or order selected rows or store additional summary information to improve query performance to the target database table. The database system allows users to query data stored in compressed form. The database system combines compressed and uncompressed data at query time for efficient database analytics.Type: ApplicationFiled: February 26, 2021Publication date: June 24, 2021Inventors: Matvey Arye, Gayathri Priyalakshmi Ayyappan, Michael J. Freedman, Sven Klemm, David Kohn, Joshua Lockerman
-
Patent number: 11030189Abstract: Materialized views are maintained for time-series databases, to enable faster analytics over large data sets and to downsample data for storage savings. These materialized views are the result of computations on existing tables, such as aggregation, approximation, sampling, filtering, statistical estimates, and more. A materialized view is created on a base table, and continuously maintained, such that as changes are made to the base table, the materialized view is correspondingly updated. The database system records metadata identifying regions of the base table that have already been materialized. Subsequently, these invalidated regions are rematerialized. Queries ensure up-to-date results by combining data from the materialized view with results calculated at query time on the base table. Invalidation records and completion thresholds are used to determine which results should use records from the materialized table and which should be computed from records from the base table.Type: GrantFiled: April 17, 2020Date of Patent: June 8, 2021Assignee: Timescale, Inc.Inventors: Matvey Arye, Michael J. Freedman, David Kohn, Joshua Lockerman, Gayathri Priyalakshmi Ayyappan
-
Patent number: 10977234Abstract: A database system stores both compressed and uncompressed data in a row-based database system. The database system converts a representation of data involving a set of rows of a source database table, each row comprising multiple values, into a representation involving a single row stored in a target database table, each column of the row comprising arrays of values from the set. The database system may perform type-specific compression of data when storing in the target database table. Accordingly, the database system may apply different compression schemes for different columns or sets of values obtained from the source database table and may group or order selected rows or store additional summary information to improve query performance to the target database table. The database system allows users to query data stored in compressed form. The database system combines compressed and uncompressed data at query time for efficient database analytics.Type: GrantFiled: July 31, 2020Date of Patent: April 13, 2021Assignee: Timescale, Inc.Inventors: Matvey Arye, Gayathri Priyalakshmi Ayyappan, Michael J. Freedman, Sven Klemm, David Kohn, Joshua Lockerman
-
Patent number: 10963456Abstract: Materialized views are maintained for time-series databases, to enable faster analytics over large data sets and to downsample data for storage savings. These materialized views are the result of computations on existing tables, such as aggregation, approximation, sampling, filtering, statistical estimates, and more. A materialized view is created on a base table, and continuously maintained, such that as changes are made to the base table, the materialized view is correspondingly updated, either synchronously or asynchronously. The database system records metadata identifying regions of the base table that have already been materialized. Subsequently, these invalidated regions are rematerialized. Queries ensure up-to-date results by combining data from the materialized view with results calculated at query time on the base table. Invalidation records and completion thresholds are used to determine which results should use records from the materialized table and which from records from the base table.Type: GrantFiled: April 17, 2020Date of Patent: March 30, 2021Assignee: Timescale, Inc.Inventors: Matvey Arye, Michael J. Freedman, David Kohn, Joshua Lockerman, Gayathri Priyalakshmi Ayyappan
-
Patent number: 10936562Abstract: A database system stores both compressed and uncompressed data in a row-based database system. The database system converts a representation of data involving a set of rows of a source database table, each row comprising multiple values, into a representation involving a single row stored in a target database table, each column of the row comprising arrays of values from the set. The database system may perform type-specific compression of data when storing in the target database table. Accordingly, the database system may apply different compression schemes for different columns or sets of values obtained from the source database table and may group or order selected rows or store additional summary information to improve query performance to the target database table. The database system allows users to query data stored in compressed form. The database system combines compressed and uncompressed data at query time for efficient database analytics.Type: GrantFiled: July 31, 2020Date of Patent: March 2, 2021Assignee: Timescale, Inc.Inventors: Matvey Arye, Gayathri Priyalakshmi Ayyappan, Michael J. Freedman, Sven Klemm, David Kohn, Joshua Lockerman
-
Publication number: 20210034587Abstract: A database system stores both compressed and uncompressed data in a row-based database system. The database system converts a representation of data involving a set of rows of a source database table, each row comprising multiple values, into a representation involving a single row stored in a target database table, each column of the row comprising arrays of values from the set. The database system may perform type-specific compression of data when storing in the target database table. Accordingly, the database system may apply different compression schemes for different columns or sets of values obtained from the source database table and may group or order selected rows or store additional summary information to improve query performance to the target database table. The database system allows users to query data stored in compressed form. The database system combines compressed and uncompressed data at query time for efficient database analytics.Type: ApplicationFiled: July 31, 2020Publication date: February 4, 2021Inventors: Matvey Arye, Gayathri Priyalakshmi Ayyappan, Michael J. Freedman, Sven Klemm, David Kohn, Joshua Lockerman
-
Publication number: 20210034586Abstract: A database system stores both compressed and uncompressed data in a row-based database system. The database system converts a representation of data involving a set of rows of a source database table, each row comprising multiple values, into a representation involving a single row stored in a target database table, each column of the row comprising arrays of values from the set. The database system may perform type-specific compression of data when storing in the target database table. Accordingly, the database system may apply different compression schemes for different columns or sets of values obtained from the source database table and may group or order selected rows or store additional summary information to improve query performance to the target database table. The database system allows users to query data stored in compressed form. The database system combines compressed and uncompressed data at query time for efficient database analytics.Type: ApplicationFiled: July 31, 2020Publication date: February 4, 2021Inventors: Matvey Arye, Gayathri Priyalakshmi Ayyappan, Michael J. Freedman, Sven Klemm, David Kohn, Joshua Lockerman
-
Publication number: 20210034598Abstract: A database system stores both compressed and uncompressed data in a row-based database system. The database system converts a representation of data involving a set of rows of a source database table, each row comprising multiple values, into a representation involving a single row stored in a target database table, each column of the row comprising arrays of values from the set. The database system may perform type-specific compression of data when storing in the target database table. Accordingly, the database system may apply different compression schemes for different columns or sets of values obtained from the source database table and may group or order selected rows or store additional summary information to improve query performance to the target database table. The database system allows users to query data stored in compressed form. The database system combines compressed and uncompressed data at query time for efficient database analytics.Type: ApplicationFiled: July 31, 2020Publication date: February 4, 2021Inventors: Matvey Arye, Gayathri Priyalakshmi Ayyappan, Michael J. Freedman, Sven Klemm, David Kohn, Joshua Lockerman
-
Publication number: 20200334232Abstract: Materialized views are maintained for time-series databases, to enable faster analytics over large data sets and to downsample data for storage savings. These materialized views are the result of computations on existing tables, such as aggregation, approximation, sampling, filtering, statistical estimates, and more. A materialized view is created on a base table, and continuously maintained, such that as changes are made to the base table, the materialized view is correspondingly updated. The database system records metadata identifying regions of the base table that have already been materialized. Subsequently, these invalidated regions are rematerialized. Queries ensure up-to-date results by combining data from the materialized view with results calculated at query time on the base table. Invalidation records and completion thresholds are used to determine which results should use records from the materialized table and which should be computed from records from the base table.Type: ApplicationFiled: April 17, 2020Publication date: October 22, 2020Inventors: Matvey Arye, Michael J. Freedman, David Kohn, Joshua Lockerman, Gayathri Priyalakshmi Ayyappan
-
Publication number: 20200334254Abstract: Materialized views are maintained for time-series databases, to enable faster analytics over large data sets and to downsample data for storage savings. These materialized views are the result of computations on existing tables, such as aggregation, approximation, sampling, filtering, statistical estimates, and more. A materialized view is created on a base table, and continuously maintained, such that as changes are made to the base table, the materialized view is correspondingly updated, either synchronously or asynchronously. The database system records metadata identifying regions of the base table that have already been materialized. Subsequently, these invalidated regions are rematerialized. Queries ensure up-to-date results by combining data from the materialized view with results calculated at query time on the base table. Invalidation records and completion thresholds are used to determine which results should use records from the materialized table and which from records from the base table.Type: ApplicationFiled: April 17, 2020Publication date: October 22, 2020Inventors: Matvey Arye, Michael J. Freedman, David Kohn, Joshua Lockerman, Gayathri Priyalakshmi Ayyappan