Informix Formation Speeds Data Transformation for Building Business Critical Data Warehouses.CHICAGO--(BUSINESS WIRE)--May 26, 1999-- Data Extraction, Transformation and Load Tool Combines Performance with Connectivity to All Informix Databases Informix(R) Corporation (Nasdaq:IFMX IFMX Informix Corporation ), the technology leader in enterprise database-powered solutions, today unveiled Formation(tm) 1.4 at the DCI (Display Control Interface) An Intel/Microsoft programming interface for full-motion video and games in Windows. It allowed applications to take advantage of video accelerator features built into the display adapter. - Data Warehouse World Conference in Chicago. Originally designed to handle the volume and speed/performance required for clickstream The trail of mouse clicks made by a user performing a particular operation on the computer. It often refers to linking from one page to another on the Web. data collection and processing, this powerful data extraction, transformation and load (ETL (Extract, Transform, Load) The functions performed when pulling data out of one database and placing it into another of a different type. ETL is used to migrate data, often from relational databases into decision support systems. ) tool now features complete native connectivity to all Informix databases--along with 28 new usability enhancements and faster performance through the automatic parallelism of smart components which can utilize all available CPU CPU in full central processing unit Principal component of a digital computer, composed of a control unit, an instruction-decoding unit, and an arithmetic-logic unit. resources during job execution. This enhanced performance and usability helps customers streamline the processing of their business critical data into enterprise-wide data warehouses. "Customers who rely upon high capacity and high performance extraction, transformation and loading See ETL. of source data into data warehouses will be pleased to know that our benchmark testing of Formation 1.4 has shown an average operator performance increase of 20 percent," said Bob Walters, vice president, business development, Informix Data Warehousing Division. "Now with complete native connectivity to all Informix databases and enhanced ease of use, Formation is the ETL tool of choice for unsurpassed performance for the manipulation of complex, business-critical data." Expanded Power and Flexibility in ETL Processing Formation eliminates the need to write complex custom code to collect, prepare and deliver data to the data warehouse environment by utilizing an innovative client/server architecture that allows the user to construct and deploy complex, multi-target transformation routines assisted by an intuitive, graphical user interface graphical user interface (GUI) Computer display format that allows the user to select commands, call up files, start programs, and do other routine tasks by using a mouse to point to pictorial symbols (icons) or lists of menu choices on the screen as opposed to having to . In addition to providing complete native connectivity to Informix Dynamic Server(tm) and Informix Dynamic Server with Advanced Decision Support Option(tm), Formation now offers native connectivity to Oracle8 Server, Informix Red Brick(R) Warehouse and Microsoft SQL Server A relational DBMS from Microsoft that is a major component of the Windows Server System. It is Microsoft's high-end client/server database and is closely integrated with Microsoft Visual Studio and the Microsoft Office System. . These critical features--along with surrogate key lookup and automatic parallelism--ensure greater ease of use in importing, exporting and sharing jobs and functions among users in disparate computing environments. Other features new to Formation include comprehensive ISO (1) See ISO speed. (2) (International Organization for Standardization, Geneva, Switzerland, www.iso.ch) An organization that sets international standards, founded in 1946. The U.S. member body is ANSI. 9000 compliance and multibyte character sets to support languages other than English LOTE or Languages Other Than English is the name given to language subjects at Australian schools. LOTEs have often historically been related to the policy of multiculturalism, and tend to reflect the predominant non-English languages spoken in a school's local area, the , such as the Kanji (human language, character) kanji - /kahn'jee/ (From the Japanese "kan" - the Chinese Han dynasty, and "ji" - glyph or letter of the alphabet. Not capitalised. Plural "kanji") The Japanese word for a Han character used in Japanese. characters of written Japanese. Smart Design and Smart Components for Smart Execution To provide sophisticated data extraction, transformation and load processing, Informix has enhanced Formation 1.4 with smarter design capabilities and smart components for more efficient execution. By enabling the generation of surrogate keys, Formation's 20 transformation-specific operators allow the seamless exchange of data from Windows NT to multi-processor UNIX boxes in production environments. Users with tight load windows and demanding transformation requirements will also appreciate the industry's most advanced join techniques, made possible by over 70 standard operator functions for manipulating numerous types of data critical to the enterprise. Smart Data Processing for the Corporate Data Warehouse The new features of Formation 1.4 will be critical to streamlining enterprise-wide operations along with enhancing the competitiveness of customers of previous versions of Formation as well as those new to the product. By providing an individual user with the ability to design, share and update custom features, customers will be able to exploit the capabilities of a single integrated application that extracts, cleanses, transforms and delivers data for integration into a single data store. Availability Formation 1.4 will be generally available in June of this year. About Informix Informix Corporation, based in Menlo Park, California Menlo Park is a city in San Mateo County, California in the United States of America. It is located at latitude 37°29' North, longitude 122°9' East. Menlo Park had 30,785 inhabitants as of the 2000 U.S. Census. , provides innovative database products that assist the world's major corporations to attain competitive advantage. Informix is widely recognized as the technology leader for corporate computing environments ranging from small workgroups to very large parallel processing applications. Informix's database server, application development tools, superior customer service, and strong partnerships enable the company to be at the forefront of major information technology solution areas including data warehousing, high performance OLTP (OnLine Transaction Processing) See transaction processing and OLCP. OLTP - On-Line Transaction Processing , and Web/e-commerce. For more information, contact the sales office nearest you or visit our Web site at www.informix.com. -0- Note to Editors: (c) 1999 Informix Corporation. All rights reserved. The following are trademarks of Informix Corporation or its affiliates, one or more of which may be registered in the U.S. or other jurisdictions: Informix(R), Informix Dynamic Server(tm), Formation(tm), Advanced Decision Support Option(tm) and Red Brick(R). Informix news releases are available at no charge through Business Wire's NewsOnDemand fax service. To immediately receive an index of available releases, call 1-800-356-0851. |
|
||||||||||||||||
Printer friendly
Cite/link
Email
Feedback
Reader Opinion