请输入您要查询的百科知识：

　

词条 Innovative Routines International
释义

  1. Products

  2. IRI CoSort

  3. IRI Voracity

  4. Other tools

     IRI FACT  IRI NextForm  IRI RowGen  IRI FieldShield  IRI CellShield  IRI DarkShield  IRI Chakra Max  IRI Workbench 

  5. References

  6. External links

{{coord|28.1422|-80.5822|display=title}}{{Infobox company
| name = IRI, The CoSort Company
| logo = Innovative Routines International logo.jpg
| logo_size = 200px
| 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, Chakra Max, Voracity
| homepage = www.iri.com
}}Innovative Routines International (IRI), Inc. is an American software company first known for bringing mainframe sort merge functionality into open systems.[1] 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.[2] In 2007, IRI's coroutine sort ("CoSort") became the first product to collate and convert multi-gigabyte XML and LDIF files,[3] join and lookup across multiple files,[4][5] and apply role-based data privacy functions (including AES-256 encryption) for fields within sensitive files.[6]

IRI is headquartered in Melbourne, Florida, United States, and has resale and support offices in 25 countries,[7] including France, Japan, South Africa, and Brazil.[8] Primary computing platform partners include HP,[9] IBM,[10] Fujitsu,[11] Intel,[12] Novell,[13] Red Hat, Sun Microsystems, and Microsoft.[14] CoSort users include: AIM Healthcare,[15] EDS,[16] HSBC Insurance,[17] and Thomson Reuters.[18] The company was named a 'Most Promising Big Data Solution Provider' by CIOReview in 2015 as it launched "Voracity" to support Hadoop processing, NoSQL data sources, etc.[19]

Products

IRI software is designed to transform, convert, report, and protect large data volumes rapidly in distributed, heterogeneous computing environments.[20] 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.[21] 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.[22]

IRI CoSort

CoSort was released for CP/M in 1978, DOS in 1980, Unix in the mid-eighties, and Windows in the early nineties,[23] and received a readership award from DMReview magazine in 2000,[24] 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.[25]

In 1992, CoSort added related data manipulation functions through a control language interface based on DEC VAX/VMS sort utility syntax,[26] which evolved through the years to handle file-based data integration and staging functions in data warehouse ETL operations:[27]

{{quote|

For data warehouse and data mart applications, CoSort performs source data extraction, data cleansing, sorting, reformatting, data type conversion, aggregation, and indexing, all in a single pass. Most operational data in commercial and public sector enterprises reside internally in sequential flat files, (relational) database tables, or are imported from data tapes and transmissions generated externally. These historical databases are optimized for ad hoc queries and transactions, rather than for extraction. CoSort accepts multiple input files (large-scale tables or flat-file data dumps), or records streaming through pipes, to perform conditional selection on records for downstream processes.|Dennis Hill, Database Trends Magazine, July 1999[28]}}

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,[29] application development, and data migration activities. Version 10 was released in 2018, adding support for semi-structured, streaming, and cloud data sources.

IRI Voracity

IRI Voracity is a data management platform released in 2016 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 profiling, ETL, metadata management, master data management, data federation, and multiple job design and control capabilities.[30]

Other tools

IRI CoSort, IRI FACT, IRI NextForm, and IRI RowGen are products in the IRI Data Manager suite. IRI FieldShield, IRI CellShield, IRI DarkShield, and IRI Chakra Max are products in the IRI Data Protector suite.

IRI FACT

FACT (FAst ExtraCT) is a high-performance unload utility for Oracle, 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.[31] FACT and CoSort used together "provide for rapid unloading and transformation of data in Oracle databases in support of ETL processes."[32]

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,[33] plus data types such as ASCII, EBCDIC, Unicode, and Packed Decimal.[34] Newer NextForm editions can structure data in unstructured sources, convert COBOL Vision files, and facilitate database migration and replication.[35]

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.[36][37] RowGen's GUI parses data models to define table layouts and relationships so database test sets are structurally and referentially correct.[38] RowGen can also transform and format test data during its generation.[39]

IRI FieldShield

FieldShield is a CoSort spin-off designed to protect data privacy in structured and semi-structured data sources.[40] The software protects personally identifiable information and other private data at the field or record level within database tables, files and other sources subject to data spill.[41] Privacy functions include AES encryption, data masking, and pseudonymization. Job details can be audited from a log file in XML format.[42]

IRI CellShield

CellShield is a data discovery and masking product designed for protecting data at the cell level in Microsoft Excel spreadsheets. CellShield comes in Personal and Enterprise editions, with the latter capable of finding and remediating PII in multiple files and sheets in drives and folders accessible on a local area network.

IRI DarkShield

DarkShield is a data discovery and masking product designed for protecting data hidden in so-called dark data, or unstructured file, repositories. DarkShield shares the same data searching, classification, and masking functionality with FieldShield and the CellShield Enterprise Edition in IRI Workbench.

IRI Chakra Max

Chakra Max is a data-centric audit and protection (DCAP) firewall for relational database activity monitoring, auditing and protection (DAM/DAP). Chakra Max uses defined policies to monitor, block, and control login access and SQL activity, perform dynamic data masking, and create secure, granular, query- and report-ready audit logs.

IRI Workbench

The Workbench is a graphical user interface (GUI) and integrated development environment (IDE) for all IRI software products, built on Eclipse™. The Workbench is a free, optional place to design, run, and manage data connections,[43] metadata, and jobs, and to use third-party plug-ins for business intelligence, data modeling, version control, etc.

References

1. ^Wilkinson, Stephanie, "Applications", UNIX Today! (November 14, 1988)
2. ^Miller, David B., DP Labs: "A Better Sort of Sort", HP Professional 7(2) (February 1993)
3. ^IPFrontline Article (June 11, 2007)
4. ^Complex Joins and Lookups Now Run Outside a DBMS, Information Management Online (August 21, 2007)
5. ^"CoSort v9", IBM Systems Magazine (November 2007)
6. ^Munshi, Renee, "CoSort Adds Data Protection at the Field Level", WindowsITPro (June 14, 2007)
7. ^{{cite web|url=http://www.iri.com/company|title=IRI web site|accessdate=July 21, 2009}}
8. ^{{cite web|url=http://www.gadcom.com.br/ultimas_noticias/ultimasnoticias_item.asp?cod=1562|title=3CON Brazil News}}
9. ^{{cite web|url=http://h21007.www2.hp.com/portal/site/dspp/menuitem.5070eb5189f3295ac6713f8da973a801/?partnerId=14369 hp|title=Infrastructure Partners}}
10. ^{{cite web|url=http://www-03.ibm.com/systems/z/solutions/isv/linuxproduct.html#section9|title=IBM System z Linux Products}}
11. ^{{cite web|url=https://solutions.ts.fujitsu.com/software-cat-i/vendor.php?id=100005645|title=Fujitsu Solutions Catalog}}
12. ^{{cite web|url=http://www.intel.com/cd/ids/developer/asmo-na/eng/19186.htm|title=Intel Early Release Program}}
13. ^{{cite web|url=http://developer.novell.com/yes/79343.htm|title=SUSE Linux YES Certification}}
14. ^{{cite web|url=http://www.microsoft.com/windowsserver/mainframe/partners.mspx|title=Microsoft Mainframe Migration Partners}}
15. ^Information Management Magazine (July 2008)
16. ^Information Management Magazine (July 2005)
17. ^Information Management Magazine (July/Aug 2009)
18. ^Information Management Magazine (Jan/Feb 2009)
19. ^https://drive.google.com/file/d/0By8hCrafiPThQTk1bVpYajZ5X3c/view?pli=1
20. ^Beall, Scott. K & Hodges, Robert L., Sort/Merge: Software Comparison Columns, Gartner Research DPRO-91136 (July 16, 2002)
21. ^Global Research Partners (July 23, 2007)
22. ^Data-Conversion.org (April 24, 2006)
23. ^IRI company history (retrieved August 1, 2009)
24. ^"DM Review 100", DM Review, 10(12), (December 2000)
25. ^{{cite web|url=http://searchdatamanagement.bitpipe.com/detail/RES/1210960409_748.html|title=IRI Whitepaper, "Third-Party Sort Replacement and Conversion Tool Examples"}}
26. ^Product Brief, Software Magazine (May 1992)
27. ^ITToolbox, Oracle Database Connections (June 25, 2009)
28. ^Hill, Dennis M., "CoSort: The Emerging ETL Engine", Database Trends (July, 1999)
29. ^Burleson, Donald K., "Hypercharging Oracle Data Loading" (February 1, 2004)
30. ^IRI Announces Total Data Management Platform, BusinessWire (December 1, 2015)
31. ^High Speed Oracle Data Extract and Reload. Burleson Consulting
32. ^Friedman, Ted, et al., "Magic Quadrant for Data Integration Tools", Gartner Report (September 22, 2008)
33. ^JAXenter Portal, IT Republik (June 11, 2007)
34. ^COBOL User Group, File Conversion Tools (retrieved August 3, 2009)
35. ^CoSort Journal (March, 2014)
36. ^{{cite web|url=http://www-304.ibm.com/jct09002c/gsdod/solutiondetails.do?solution=16936|title=IBM PartnerWorld Global Solutions Directory}}
37. ^OTN Partner News, Oracle Magazine (March, 2008)
38. ^SQL Server Magazine (November, 2008)
39. ^Information Management Magazine (July, 2007)
40. ^{{cite web|url=http://www.datagovernancesoftware.com/cat5_sensitive_data_privacy_monitoring.html|title=datagovernancesoftware.com/cat5}}
41. ^Jarvis, Darick, "5 Tips for Protecting Sensitive Data", Data Storage Connection (September 4, 2007)
42. ^Koopman, James, "Are You Compliant within Flat File Processing?" (April 13, 2009)
43. ^136 Data Sources and Targets (IRI Web Site, July, 2014)

External links

  • IRI, Inc. Home Page

2 : Companies based in Brevard County, Florida|Software companies based in Florida
随便看

　

开放百科全书收录14589846条英语、德语、日语等多语种百科知识，基本涵盖了大多数领域的百科知识，是一部内容自由、开放的电子版国际百科全书。

　

Copyright © 2023 OENC.NET All Rights Reserved
京ICP备2021023879号 更新时间：2024/11/11 8:37:57