Kirix Strata
{{Short description|Specialty desktop database}}
{{Infobox software
| name = Kirix Strata
| logo = Image:Kirix-strata-logo-256.png
| screenshot = Image:Kirix-strata-screenshot.png
| caption = Kirix Strata 4.4.2 running on Windows XP
| developer = Kirix Research LLC
| latest_release_version = 5.4.0
| latest_release_date = {{Start date and age|2025|5|26}}
| operating system = Windows 10/11, Ubuntu Linux
| discontinued = no
| genre = Data processing, RDBMS
| license = MIT
| website = {{URL|www.kirix.com}}
| repo = {{URL|github.com/kirixresearch/strata}}
}}
Kirix Strata is a specialty desktop database tool designed for data processing and data analytics.{{cite web|url=http://blogs.computerworld.com/kirix_data_browser?rec=1 |title=Strata: A browser designed for analytics |publisher=Computerworld |last=Hall |first=Mark |access-date=2008-05-07 |url-status=dead |archive-url=https://web.archive.org/web/20110522081406/http://blogs.computerworld.com/kirix_data_browser?rec=1 |archive-date=2011-05-22 }} 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.{{cite news | url = http://nl.newsbank.com/nl-search/we/Archives?p_product=CSTB&p_theme=cstb&p_action=search&p_maxdocs=200&s_dispstring=(kirix)%20AND%20date(all)&p_field_advanced-0=&p_text_advanced-0=(%22kirix%22)&xcal_numdocs=20&p_perpage=10&p_sort=YMD_date:D&xcal_useweights=no | title = Making Quick Work of Data | publisher = Chicago Sun Times | last = Guy | first = Sandra | access-date = 2008-07-13 | date=2008-07-13}} 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.{{cite web | url = http://www.infoworld.com/article/2643790/database/kirix-data-base-app-debuts.html | title = Kirix Data Base App Debuts | publisher = InfoWorld | last = Scannell | first = Ed | date = 17 February 2005 | access-date = 2015-09-05}}
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.{{cite web | url = http://www.b-eye-network.com/listen/7935 | title = B-EYE Spotlight Podcast | publisher = Business Intelligence Network | last = Powell | first = Ron | access-date = 2008-07-15}}
Features
Kirix Strata provides tools to view, manipulate and interact with structured data:
- Data Access: Tabular data formats, external databases (e.g., MySQL, PostgreSQL, 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{{cite web|url=http://www.kirix.com/blog/2012/10/10/announcing-kirix-strata-45/|access-date=10 October 2012|title=Announcing Kirix Strata 4.5}})
- supports up to 18 exabytes per project; 60 billion records per table; 250 million table per project.