Kirix Strata is a specialty desktop database tool designed for data processing and data analytics.[1] Strata includes a range of features to perform data analysis and create reports based on structured data from local files and external relational databases.
Developer(s) | Kirix Research LLC |
---|---|
Stable release | 5.0.5
/ December 1, 2023 |
Repository | github |
Operating system | Windows 7/10/11, Ubuntu Linux |
Type | Data processing, RDBMS |
License | MIT |
Website | www |
Kirix Strata is a free, open source product and is supported on both Microsoft Windows and Linux.
History
editKirix Research is a data analysis software company founded in January 2001.[2] In its early years the company specialized providing data analytic solutions for recovery auditing, including identifying duplicate payments, pricing errors, missed discounts and other overpayment errors in large corporate accounting systems.
In February 2005, Kirix launched Kirix Strata as a new desktop database for Windows and Linux at the LinuxWorld conference in Boston. The product combined some of the capabilities of a spreadsheet with those of a database management system and won the Product Excellence Award in the Best Desktop-Productivity-Business Application category.[3]
In July 2007, Kirix relaunched Strata in beta as a specialty desktop database for working with data from anywhere. Strata was officially released out of beta in April 2008 with the intention of bringing the simplicity of a spreadsheet to the world of tabular data.[4]
Features
editKirix Strata provides tools to view, manipulate and interact with structured data:
- Data Access: Tabular data formats, external databases (e.g., MySQL, Oracle) and local data files (e.g., Excel, Access, text-delimited data, and CSV files).
- Data Analysis: Sorts, filters, copies, queries, calculated fields and relationships.
- Reporting
- Scripting and Extensions: Data-enabled version of JavaScript with support for SQL.
- Operating system support:
- supports up to 18 exabytes per project; 60 billion records per table; 250 million table per project.
References
edit- ^ Hall, Mark. "Strata: A browser designed for analytics". Computerworld. Archived from the original on 2011-05-22. Retrieved 2008-05-07.
- ^ Guy, Sandra (2008-07-13). "Making Quick Work of Data". Chicago Sun Times. Retrieved 2008-07-13.
- ^ Scannell, Ed (17 February 2005). "Kirix Data Base App Debuts". InfoWorld. Retrieved 2015-09-05.
- ^ Powell, Ron. "B-EYE Spotlight Podcast". Business Intelligence Network. Retrieved 2008-07-15.
- ^ "Announcing Kirix Strata 4.5". Retrieved 10 October 2012.