Innovative Routines International
{{Short description|American software company}}
{{coord|28.1422|-80.5822|display=title}}
{{Infobox company
| name = IRI, The CoSort Company
| logo =
| logo_size =
| type = Private
| foundation =
| location_city = Melbourne, Florida
| location_country = USA
| locations =
| num_employees =
| industry = Data processing, Sorting, Data integration, Test data, Data masking, Data conversion
| products = CoSort, Fast Extract (FACT), NextForm, RowGen, FieldShield, CellShield, DarkShield, Voracity
| homepage = [http://www.iri.com/ www.iri.com]
}}
Innovative Routines International (IRI), Inc. is an American software company first known for bringing mainframe sort merge functionality into open systems.Wilkinson, Stephanie, "Applications", UNIX Today! (November 14, 1988) IRI was the first vendor to develop a commercial replacement for the Unix sort command, and combine data transformation and reporting in Unix batch processing environments.Miller, David B., DP Labs: "A Better Sort of Sort", HP Professional 7(2) (February 1993) In 2007, IRI's coroutine sort ("CoSort") became the first product to collate and convert multi-gigabyte XML and LDIF files,IPFrontline Article (June 11, 2007) join and lookup across multiple files,[http://www.information-management.com/news/1091091-1.html Complex Joins and Lookups Now Run Outside a DBMS], Information Management Online (August 21, 2007)"CoSort v9", IBM Systems Magazine (November 2007) and apply role-based data privacy functions (including AES-256 encryption) for fields within sensitive files.Munshi, Renee, "CoSort Adds Data Protection at the Field Level", WindowsITPro (June 14, 2007)
IRI is headquartered in Melbourne, Florida, United States, and has resale and support offices in 25 countries,{{cite web|url=http://www.iri.com/company|title=IRI web site|accessdate=July 21, 2009}} including France, Japan, South Africa, and Brazil.{{cite web|url=http://www.gadcom.com.br/ultimas_noticias/ultimasnoticias_item.asp?cod=1562|title=3CON Brazil News|access-date=2009-07-30|archive-url=https://web.archive.org/web/20110706152510/http://www.gadcom.com.br/ultimas_noticias/ultimasnoticias_item.asp?cod=1562|archive-date=2011-07-06|url-status=dead}}
Products
IRI software is designed to transform, convert, report, and protect large data volumes rapidly in distributed, heterogeneous computing environments.Beall, Scott. K & Hodges, Robert L., Sort/Merge: Software Comparison Columns, Gartner Research DPRO-91136 (July 16, 2002) These functions are built into the CoSort package or through spin-offs for data extraction, generation, security, and migration. Each tool uses the same graphical IDE built on Eclipse, and metadata format for defining and manipulating data.[http://www.itweb.co.za/office/spi/0707230813.htm Global Research Partners] (July 23, 2007) IRI's open data definition file format is also supported by AnalytiX DS and Meta Integration Technology (MITI) so that third-party ETL, BI, and data modeling tool users can convert or re-use their existing metadata in IRI product environments.[http://www.allbusiness.com/technology/software-services-applications/5393340-1.html Data-Conversion.org] (April 24, 2006)
IRI CoSort
CoSort was released for CP/M in 1978, DOS in 1980, Unix in the mid-eighties, and Windows in the early nineties,[http://www.iri.com/company/history IRI company history] (retrieved August 1, 2009) and received a readership award from DMReview magazine in 2000,"DM Review 100", DM Review, 10(12), (December 2000) CoSort was initially designed as a file sorting utility, and added interfaces to replace or convert the sort program parameters used in IBM Infosphere DataStage, Informatica, Micro Focus COBOL, JCL, NATURAL, SAS, and SyncSort Unix.{{cite web|url=http://searchdatamanagement.bitpipe.com/detail/RES/1210960409_748.html|title=IRI Whitepaper, "Third-Party Sort Replacement and Conversion Tool Examples"}}
In 1992, CoSort added related data manipulation functions through a control language interface based on DEC VAX/VMS sort utility syntax,Product Brief, Software Magazine (May 1992) which evolved through the years to handle file-based data integration and staging functions in data warehouse ETL operations:[http://it.toolbox.com/blogs/database-solutions/everyone-has-data-integration-problems-whats-your-solution-32512 ITToolbox, Oracle Database Connections] (June 25, 2009)
CoSort Version 9 releases, begun in 2007, can simultaneously transform, convert, report, and/or protect data for ETL, business intelligence, change data capture, database load and query,[http://www.orafaq.com/node/12 Burleson, Donald K., "Hypercharging Oracle Data Loading"] (February 1, 2004) application development, and data migration activities. Version 10 was released in 2018, adding support for semi-structured, streaming, and cloud data sources. Version 10.5 provided more functional and source support updates in 2021.
IRI Voracity
IRI Voracity is a data management platform released in 2017 for data discovery, integration, migration, governance, and analytics. It consolidates key data curation activities in the IRI Workbench GUI (built on Eclipse (software), and transforms data in the CoSort engine or optionally in MapReduce, Spark, Spark Stream, Storm, or Tez. Voracity includes most standalone IRI tools, and adds data classification, data profiling, data quality, ETL, metadata management, master data management, change data capture, data federation, and multiple job design and control capabilities.[http://www.businesswire.com/news/home/20151201006460/en/ IRI Announces Total Data Management Platform, BusinessWire] (December 1, 2015)
=IRI FACT=
FACT (FAst ExtraCT) is a high-performance unload utility for Oracle, IBM Db2, Sybase ASE and IQ, SQL Server, MySQL, Altibase, and Tibero. It exports large tables in parallel to flat files for archive, ETL, reorg, reporting and other applications.[http://www.dba-oracle.com/t_export_high_performance.htm High Speed Oracle Data Extract and Reload.] Burleson Consulting FACT and CoSort used together "provide for rapid unloading and transformation of data in Oracle databases in support of ETL processes."Friedman, Ted, et al., "Magic Quadrant for Data Integration Tools", Gartner Report (September 22, 2008)
=IRI NextForm=
NextForm is a data migration spin-off from CoSort functionality designed to convert between structured file formats such as CSV, ISAM, LDIF, and XML,[http://it-republik.de/jaxenter/news/Transforming-and-Converting-Huge-XML-and-LDIF-Files-Made-Easy-036219.html JAXenter Portal, IT Republik] (June 11, 2007) plus data types such as ASCII, EBCDIC, Unicode, and Packed Decimal.[http://www.cobug.com/cobug/docs/fileconver0038.html COBOL User Group, File Conversion Tools] {{Webarchive|url=https://web.archive.org/web/20090301052405/http://cobug.com/cobug/docs/fileconver0038.html |date=2009-03-01 }} (retrieved August 3, 2009) Newer NextForm editions can structure data in unstructured sources, convert COBOL Vision files, and facilitate database migration and replication.[http://cache.nebula.phx3.secureserver.net/obj/M0VDODkwMTAwNUI2N0FFQzg5MkQ6ZDA3ZWY2YzVhYTNjMjQ1Yzg1MmZkYjE1MTE5NTkzOWQ6Ojo6 CoSort Journal] (March, 2014)
=IRI RowGen=
RowGen is designed to generate test data in production table, file, and report formats for prototype database population, compliance, outsourcing, and application prototyping projects.{{cite web|url=http://www-304.ibm.com/jct09002c/gsdod/solutiondetails.do?solution=16936|title=IBM PartnerWorld Global Solutions Directory}}OTN Partner News, Oracle Magazine (March, 2008) RowGen's GUI parses data models to define table layouts and relationships so database test sets are structurally and referentially correct.[http://www.sqlmag.com/Article/ArticleID/100303/sql_server_100303.html SQL Server Magazine] (November, 2008) RowGen can also transform and format test data during its generation.[http://www.information-management.com/issues/20070701/1087536-1.html Information Management Magazine] (July, 2007)
=IRI FieldShield=
FieldShield is a CoSort spin-off designed to protect data privacy in structured and some semi-structured data sources.{{cite web|url=http://www.datagovernancesoftware.com/cat5_sensitive_data_privacy_monitoring.html|title=datagovernancesoftware.com/cat5}} The software classifies and masks personally identifiable information and other private data at the field or record level within database tables, files and other sources subject to data spill.[http://www.datastorageconnection.com/download.mvc/5-Tips-For-Protecting-Sensitive-Data-iBy-Dari-0002 Jarvis, Darick, "5 Tips for Protecting Sensitive Data"] {{Webarchive|url=https://web.archive.org/web/20110708233801/http://www.datastorageconnection.com/download.mvc/5-Tips-For-Protecting-Sensitive-Data-iBy-Dari-0002 |date=2011-07-08 }}, Data Storage Connection (September 4, 2007) Privacy functions include AES encryption, data masking, and pseudonymization. Job details can be audited from a log file in XML format.[http://www.jameskoopmann.com/2009/04/are-you-compliant-within-flat-file-processing Koopman, James, "Are You Compliant within Flat File Processing?"] (April 13, 2009)
=IRI DarkShield=
DarkShield is another data classification and data masking product front-ended in IRI Workbench for finding and protecting personally identifiable information in structured, semi-structured and unstructured sources on-premise or in the cloud. DarkShield shares data classes and masking functions with FieldShield and also supports flat files and relational databases, but is purpose-built for NoSQL databases, images (in BMP, GIF, JPG, PNG, TIF and DICOM format), signatures,[https://www.prnewswire.com/news-releases/iri-adds-signature-detection-and-redaction-to-darkshield-302240731.html PRNewswire] (September 2024) and files in JSON, XML, HL7, X12, FHIR, raw text, Parquet, PDF, Microsoft Office, and audio formats. DarkShield runs self-hosted on Windows or Linux hardware and can reach files in Amazon S3, Azure Blob, Google Cloud Platform, and SharePoint Online.[https://www.streetinsider.com/Press+Releases/Innovative+Routines+International+%28IRI%29%2C+Inc.+Announces+DarkShield+V5/22967968.html Street Insider] (March 2024) It combines search and mask operations in the same job and can run from the GUI, command-line or API to support DevOps pipelines, dynamic data masking, and load balancing.
References
{{reflist|2}}
External links
- [http://www.iri.com IRI, Inc. Home Page]
Category:Companies based in Brevard County, Florida