Knowledge Base Wiki

Search for LIMS content across all our Wiki Knowledge Bases.

Type a search term to find related articles by LIMS subject matter experts gathered from the most trusted and dynamic collaboration tools in the laboratory informatics industry.

Add links
Kirix Strata
Developer(s)Kirix Research LLC
Stable release
5.0.5 / December 1, 2023; 11 months ago (2023-12-01)
Repositorygithub.com/kirixresearch/strata
Operating systemWindows 7/10/11, Ubuntu Linux
TypeData processing, RDBMS
LicenseMIT
Websitewww.kirix.com

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.

Kirix Strata is a free, open source product and is supported on both Microsoft Windows and Linux.

History

Kirix 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

Kirix 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:
    • Microsoft Windows 7/10/11
    • Ubuntu Linux 10.04 and later (discontinued in October 2012[5])
  • supports up to 18 exabytes per project; 60 billion records per table; 250 million table per project.

References

  1. ^ Hall, Mark. "Strata: A browser designed for analytics". Computerworld. Archived from the original on 2011-05-22. Retrieved 2008-05-07.
  2. ^ Guy, Sandra (2008-07-13). "Making Quick Work of Data". Chicago Sun Times. Retrieved 2008-07-13.
  3. ^ Scannell, Ed (17 February 2005). "Kirix Data Base App Debuts". InfoWorld. Retrieved 2015-09-05.
  4. ^ Powell, Ron. "B-EYE Spotlight Podcast". Business Intelligence Network. Retrieved 2008-07-15.
  5. ^ "Announcing Kirix Strata 4.5". Retrieved 10 October 2012.