Refimprove date April 2007 Infobox Company company name Teradata Corporation company logo Image Teradata ... index.php?symbol TDC&page quotesearch title Company Profile for Teradata Corp TDC accessdate ... http www.teradata.com www.teradata.com Teradata Corporation nyse TDC is a vendor specializing in Data ... used by companies to manage data warehouses for analytics and business intelligence purposes. Teradata ... title NCR Completes Teradata Spin Off date October 1, 2007 ref Teradata is led by Mike Koehler, the former ... amr teradata ncr split biz logistics cx jh 0109tera.html title NCR To Spinoff Teradata date work Forbes ref Teradata s headquarters are in Miamisburg, Ohio Miamisburg , Ohio . Introduction Teradata is a Computer ... management system RDBMS with the same name. Teradata was a division of the NCR Corporation, which acquired the Teradata Company on February 28, 1991. Teradata s revenues in 2005 were almost 1.5 billion ... spin off Teradata as an independently traded company, ref cite press release url http www.ncr.com ... off was completed October 1 of the same year, with Teradata trading under the New York Stock Exchange ... Teradata Spin Off ref Teradata Enterprise Data Warehouses are often accessed via ODBC , JDBC ... systems via a combination of batch and trickle loads. Teradata acts as a single data store that can .... Technology Teradata is a massive parallelism massively parallel processing system running a shared nothing architecture . The Teradata DBMS is linearly and predictably scalable in all dimensions of a database ... for enterprise data warehousing applications. Teradata is offered on Intel servers interconnected by the proprietary BYNET messaging fabric. Teradata systems are offered with either Teradata branded ... reported that Teradata would begin using solid state device s SSD in a new product to be released in 2010 called the Teradata Extreme Performance Appliance. The data appliance holds about 20TB ... 17, 2009 ref The new appliance can scale from 7TB to 200TB and like other Teradata products ... more details
FastLoad is a Teradata utility. Teradata FastLoad Initial Table Load This parallel load utility is designed to move large volumes of data collected from data sources on channel and network attached clients into empty tables in the Teradata Database. You can execute Teradata FastLoad from many client platforms, mainframe, or load server to move data into the Teradata Database. FastLoad typically offers higher performance levels than a standard application program written to load data to an empty database because data allocation, conversion, movement, and loading are automatic and performed in parallel, Features Initial table load Delimited or fixed format input Description FastLoad is a command driven utility to load large data into an empty table on a Teradata Relational Database Management System RDBMS . You can load data from Disk or tape files on a channel attached client system Input files on a network attached workstation User defined input module INMOD routines to select, validate, and preprocess input data Any other device providing properly formatted source data FastLoad uses multiple database sessions to load data. Constraints on the use of fastload are the target table must be empty no access read or write is allowed on the target table while loading only a single table can be loaded in one job An alternative to fastload is MultiLoad which does not have the above restrictions, but also has a significantly slower load performance. Supported Platforms NCR UNIX SVR4 MP RAS IBM z OS MVS Microsoft Windows 2000, XP, and Server 2003 Sun Solaris SPARC HP UX IBM AIX Red Hat Linux SUSE Linux Enterprise Server from Novell A Sample Script pre sessions 2 errlimit 25 logon tdpid username,password CREATE TABLE employee EmpNo SMALLINT FORMAT 9 5 BETWEEN 10001 AND 32001 NOT NULL ... t page 94244 index.html title Teradata Load & Unload Utilities date March 2010 See also FastExport External links Fast Export Category Data warehousing products Category Teradata de Teradata ... more details
Advert date December 2007 Teradata Parallel Transporter TPT is a Teradata load utility, typically used in data warehousing . Teradata Parallel Transporter Teradata Parallel Transporter TPT is a Parallel computing parallel multi function load environment. It provides scalable access to data sources from a single interface using a single SQL like scripting language or an open API. It provides a completely parallel environment. Dozens of files can be loaded using a single script. TPT utilizes system resources efficiently by allowing distribution of the workload across CPUs, eliminating bottlenecks in data loading process. Each user can create a job that is, a string of TPT commands that allows them to perform operations, such as heterogeneous data access, data integrity checks, data merging, and data loads in batch or near real time. Teradata Parallel Transporter provides a set of open APIs that enables integration of third party tools or custom applications. It was designed to use the different Teradata Load and Unload Utilities under a single infrastructure. So, based on the protocols of fastload, multiload, tpump and fastexport, new operators were developed and they are named as Load, Update, Stream and Export respectively. Apart from the four operators, there are more operators like Selector, Inserter, Dataconnector, and ODBC . Features Single infrastructure for all loading needs using single scripting language Integrated API to interface with ETL tools and custom programs Completely parallel Combines functionality of TeradataTeradata FastLoad FastLoad , MultiLoad , FastExport , and TPump Supported Platforms NCR UNIX SVR4 MP RAS IBM z OS MVS Microsoft Windows 2000, XP, Vista and Server 2003 Sun Solaris SPARC HP UX IBM AIX Red Hat Linux SUSE Linux Enterprise Server from Novell External links http tptapiwrapper.codeplex.com .Net Wrapper for the Teradata Parallel Transporter API Category Data warehousing products Category Teradata ... more details
Summary logo fur REQUIRED Article Teradata Use Org HIGHLY RECOMMENDED Source http www.teradata.com Darryl ?tag dell ADDITIONAL INFORMATION Used for Owner Website History Commentary OVERRIDE FIELDS Description Portion Low resolution Purpose Replaceability other information Licensing Non free logo History of File Teradata Logo.jpg 2008 12 14T05 02 45Z User Adam sk Adam sk User talk Adam sk Talk Special Contributions Adam sk contribs 382 bytes nowiki logo fur REQUIRED Article Teradata Use Org HIGHLY RECOMMENDED Source http www.teradata.com Darryl ?tag dell ADDITIONAL INFORMATION Used for Owner Website History Commentary OVERRIDE FIELDS Description nowiki 2008 12 14T05 02 44Z User Adam sk Adam sk User talk Adam sk Talk Special Contributions Adam sk contribs 190x68 40462 bytes ... more details
FastLoad may refer to Teradata FastLoad , a database utility Epyx FastLoad , a peripheral cartridge for the Commodore 64 computer disambig ... more details
Advert date December 2007 BTEQ is a Teradata utility. BTEQ stands for Basic TEradata Query . BTEQ SQL Query Capability BTEQ, available as part of the Teradata Utility Pack, is a general purpose, command based tool that enables users to communicate with one or more Teradata Databases. BTEQ provides an interactive or batch interface that allows a user to submit SQL statements, import and export data, and generate reports. BTEQ provides report formatting options where queried data is formatted and returned to the screen, file, or printer. Scripts are sent from the client to the Teradata Database where the actual process occurs. BTEQ can also be used to import and export data between client and database tables. BTEQ s streamed package format design ensures fast processing and effective resource utilization. Features Report formatting Ad hoc query tool Database administration Best for small data volumes Definition BTEQ is an abbreviation of Basic Teradata Query. It is a general purpose, command based program that allows users on a workstation to communicate with one or more Teradata RDBMS systems, and to format reports for both print and screen output. Using BTEQ a user submits SQL queries to the Teradata RDBMS. BTEQ formats the results and returns them to the screen, a file, or to a designated printer. Supported Platforms NCR UNIX SVR4 MP RAS IBM z OS MVS and USS z OS VM Microsoft Windows 2000, XP, and Server 2003 Sun Solaris SPARC Sun Solaris Opteron IBM AIX HP UX PA RISC and IA64 SUSE Linux SUSE and Red Hat Linux External links http www.teradata.com t tools and utilities load and unload Teradata Load & Unload Utilities See also Category Data warehousing products Category Teradata de Teradata ... more details
Advert date December 2007 TPump is a Teradata utility designed to continuously move data from data sources into Teradata tables without locking the affected table. TPump provides near real time data into data warehouses. TPump can be used to insert, update, upsert, and delete data in the Teradata Database. TPump uses row hash locks, meaning users can run queries while it s updating the Teradata Warehouse. Overview TPump uses standard Teradata SQL to achieve moderate to high data loading rates to the Teradata RDBMS. Multiple sessions and multistatement request are typically used to increase throughput. TPump provides an alternative to MultiLoad for the low volume batch maintenance of large databases under control of a Teradata system. Instead of updating Teradata databases overnight, or in batches throughout the day, TPump updates information in real time, acquiring every bit of data from the client system with low processor utilization. It does this through a continuous feed of data into the data warehouse, rather than the traditional batch updates. Continuous updates results in more accurate, timely data. And, unlike most load utilities, TPump uses row hash locks rather than table level locks. This allows users to run queries while TPump is running. This also means that TPump can be stopped instantaneously. TPump also provides a dynamic throttling feature that enables it to run all out during batch windows, but within limits when it may impact other business uses of the Teradata RDBMS. Operators can specify the number of statements run per minute, or may alter throttling minute by minute, if necessary. TPump s main attributes are Simple, hassle free setup doesn t require ... from other databases. TPump is also able to transform that data on the fly before sending it to Teradata ... SPARC IBM HP UX External links http www.teradata.com t page 94244 index.html Teradata Load & Unload Utilities See also Category Data warehousing products Category Teradata de Teradata ... more details
context date February 2011 FastExport is a computer program released by the company Teradata . The program is the reverse of the Teradata FastLoad . FastExport is a utility that exports large data sets from Teradata tables or views to a client system for processing, generating large reports, or for loading data into a smaller database. FastExport can export data to both channel or network attached client systems. The program also provides session control and data handling specifications for the data transfer operations. The program is available for various operating system s, including Microsoft Windows and Red Hat Linux . Usage FastExport is a command driven utility that uses multiple sessions to quickly transfer large amounts of data from tables and views of the Teradata Relational Database Management System RDBMS to a client based application. Users can export data from any table or view to which you have the SELECT access privilege. The destination for the exported data can be A file on a channel attached or network attached client system An Output Modification OUTMOD routine written to select, validate, and preprocess the exported data A Sample Script pre .LOGTABLE utillog define restart log .LOGON tdpz user,pswd DBC logon string .BEGIN EXPORT specify export function SESSIONS 20 number of sessions to be used .LAYOUT UsingData define the input data .FIELD ProjId Char 8 values for the SELECT .FIELD WkEnd Date constraint clause. .IMPORT INFILE ddname1 identify the file that LAYOUT UsingData contains the input data .EXPORT OUTFILE ddname2 identify the destination file for exported data SELECT EmpNo, Hours FROM CHARGES provide the SQL SELECT WHERE WkEnd WkEnd statement with values AND Proj ID ProjId provided by the IMPORT ORDER BY EmpNo command .END EXPORT terminate the export ... link url http www.teradata.com t page 94244 index.html titre Teradata Load & Unload Utilities date March 2010 See also Category Data warehousing products Category Teradata de Teradata ... more details
Summary logo fur REQUIRED Article Britton Lee, Inc. Use Org HIGHLY RECOMMENDED Source Scanned from 1988 ShareBase material ADDITIONAL INFORMATION Used for company logo of defunct company Owner ShareBase was purchased and absorbed by Teradata in 1990 Website History Commentary OVERRIDE FIELDS Description Portion Low resolution Purpose Replaceability To my knowledge, this logo hasn t been used since 1990 and is unavailable from other sources other information Licensing Non free logo ... more details
to a certain customer, etc. The definitions of the ADW active elements are quoted from Teradata Active ... Warehouse eb4923 ?type WP title The Active Data Warehouse page 3 accessdate 2010 11 18 author Teradata publisher Teradata ref Active Access Front line users access the data warehouse for operational ... BI, Teradata ref cite web url http www.teradata.com t white papers Critical Success Factors ... accessdate 2010 11 18 author Teradata, Informatica and Microstrategy date 2007 08 publisher Teradata ... 2010 11 18 author Teradata, Informatica and Microstrategy date 2007 08 work publisher Teradata ... more details
Infobox Company company name Kickfire, Inc. company logo company type Private foundation 2006 location Santa Clara, California products Kickfire Analytic Appliance industry Enterprise Software & Database Management & Data Warehousing Kickfire, Inc. was an analytic database appliance manufacturer. ref http www.informationweek.com news business intelligence warehouses showArticle.jhtml 3Bjsessionid ILOZEZHH5SMDSQSNDLQSKH0CJUNN2JVN?articleID 210602420&cid tab art bi Information Week Data Warehouse Market Heats Up ref It was acquired by Teradata in August 2010. ref http www.infoworld.com d the industry standard teradata buys analytics vendor kickfire 496 InfoWorld Teradata buys analytics vendor Kickfire ref The Kickfire appliance utilizes FPGA hardware acceleration techniques for SQL databases. Features column oriented database column store , which increases performance of sequential record access at the expense of common transactional operations such as single record retrieval, updates, and deletes. ref Monash, C Are row oriented RDBMS obsolete? http www.dbms2.com 2007 01 22 are row oriented rdbms obsolete DBMS2 , January 22, 2007 ref MySQL integrated as a storage engine Plug in computing plug in , with special modifications to the optimizer to allow query rewrite optimizations over a column store. An FPGA based Query Processor Module which attaches via external PCI X bus to a base linux server module. The QPM features a dataflow architecture and implements relational algebra in run time reconfigurable hardware for SQL join execution. Data compression Compression , which reduces I O bandwidth requirements. High compression is possible because columns of homogeneous datatype are stored together and because updates to the main store are batched. ref Monash, C Mike Stonebraker on database compression comments , http www.dbms2.com 2007 03 24 comments stonebraker data compression DBMS2 , March 24, 2007 ref The base server module BSM runs on CentOS . The QPM integrates with ... more details
TPT may refer to TPT Software , Time Partition Testing TPT College , Thiagarajar Polytechnic College Teradata Parallel Transporter Transaction privilege tax , a gross receipts tax levied by the State of Arizona Twin Cities Public Television , an organization that operates television stations in Minneapolis St. Paul, Minnesota Tara Palmer Tomkinson Trans Pennine Trail , a long distance path in the north of England Trailer park trash abbreviation Tramway de Pithiviers Toury , a French railway The Pineapple Thief , an indie rock new prog band from England Thalia s Pine Tree RPG , a Percy Jackson RPG TP T may refer to A target practice round with tracer disambig de TPT it TPT nl TPT ... more details
. Teradata , Tandem Computers Tandem , Britton Lee, Inc. Britton Lee , and Sequent Computer Systems ... Teradata s initial product as the first DW appliance or Britton Lee s ref cite web title Teradata Goes Appliance, Officially quote Teradata effectively established the DW appliance market a quarter ... support requirements url http blogs.forrester.com james kobielus 08 04 22 teradata goes appliance ... two significant database machine vendors were Britton Lee and Teradata. And since Britton Lee eventually sold out to Teradata after a brief name change to ShareBase , Teradata is entitled to whatever ... 15, 2008 accessdate 2011 01 15 ref Note Teradata acquired Britton Lee renamed ShareBase in June, 1990. ref name sharebase cite journal title Teradata Corp. suffers first quarterly loss in four years ... Others disagree, considering appliances as a disruptive technology for Teradata ref cite web title ... as a front end to their Teradata warehouse to calculate aggregates. So when they want to do ... appliances could be a disruptive technology for Teradata url http www.itbusinessedge.com cm community ... TeraData maintain their leadership position. ref http www.dbms2.com 2007 10 19 gartner 2007 magic ... more details
TDC is a three letter acronym that may refer to Hong Kong Trade Development Council TDC A S , a Danish communications company TDC, the U.S. ticker symbol for Teradata Corporation time to digital converter , a device in signal processing Top dead center , the position farthest from the crankshaft of a piston in a reciprocating engine Torpedo Data Computer , a piece of naval technology Total delivery cost Troph e des champions Tristan da Cunha http www.thedarkcloak.com TheDarkCloak Illustrator and Digital Artist Theta Delta Chi Tokyo Dome City Texas Department of Criminal Justice , formerly the Texas Department of Corrections Probation workplace Trainee Detective Constable , the most junior British police Criminal Investigation Department CID rank equivalent to probationer. Type Directors Club Thor diesel club Thor Diesel Club , FMCA Chapter for owners of a http ThorMotorCoach.com Thor Motor Coach Diesel Motorhome disambig da TDC flertydig de TDC es TDC fr TDC it TDC nl TDC ja TDC sv TDC ... more details
Advert date August 2010 Trillium Software is located in Billerica, Massachusetts , United States . It is a division of Harte Hanks headquartered in San Antonio, Texas , with divisions worldwide . Trillium Software is rated among the leaders in the data quality space, according to industry analyst Gartner , as depicted by the Gartner data quality magic quadrant. Trillium Software is also a leader in data quality, according to analyst Forrester . Trillium Software offers data quality and data profiling software and consulting services. Trillium Software offers several software solutions designed to automate the process of improving data quality. The solutions offer data discovery, data quality, data enrichment and data monitoring. Trillium Software solutions are most commonly used in projects involving large amounts of name address and parts data, such as Master data management MDM , data warehousing , Oracle Applications, Teradata Data Warehouse Applications, customer relationship management CRM , and enterprise resource planning ERP . External links http www.trilliumsoftware.com Trillium Software website Category Software companies of the United States ... more details
Primary sources date November 2009 The IBM Data Warehousing Balanced Configuration Unit is a family of data warehousing server computing s from IBM . IBM introduced the Balanced Configuration Unit BCU for AIX operating system AIX in 2005, and the BCU for Linux in 2006. The BCU is a balanced combination of computer server computing server hardware cpus, I O channel s, and storage combined with IBM DB2 DB2 Data Warehouse Edition DB2 DWE software to form a data warehouse appliance like system to compete with systems such as Greenplum , DATAllegro , Netezza Performance Server , and Teradata . See also http www 03.ibm.com press us en pressrelease 20433.wss IBM Linux Solution Optimizes Enterprise Data Warehousing . External links IBM s InfoSphere Balanced Warehouse web page http www 01.ibm.com software data infosphere balanced warehouse DEFAULTSORT Ibm Balanced Configuration Unit Category IBM computers Balanced Category Server hardware compu hardware stub ... more details
Notability date September 2009 unreferenced date January 2010 lowercase title daytaOhio is a non profit organization on the campus of Wright State University in Dayton, Ohio . Markets served daytaOhio serves a broad range of industries and market segments. These industries include Medical Energy Defense Architecture Retail Economic aspects Reducing time to market for new product development Securing zero defects in production arenas Delivering documented human performance enhancements to optimize effectiveness Re engineering processes to achieve more with less Interpreting and communicating concise information from complex data arrays daytaOhio s R.C. Appenzeller Visualization Laboratory, on the campus of Wright State University, is powered by Barco, a display and visualization systems and solutions company. Partners Barco CDO Technologies Cincinnati Bell CincyTech Dayton Region The Eastpoint Group Ginko Systems James Gregory Associates LexisNexis Lucrum MTC Technologies National Composite Center Online Computer Library Center Solve Interactive Standard Register TDH Marketing Teradata Thompson Hine UES, Inc. Wright Brothers Institute Wright State University Category Non profit organizations based in Ohio ... more details
Unreferenced stub auto yes date December 2009 Orphan date February 2009 Context date October 2009 The DBC 1012 Data Base Computer was introduced by Teradata Corporation in the early 1980s as a back end data base management system for mainframe computers. The DBC 1012 harnessed multiple Intel microprocessors, each with its own dedicated disk drive by interconnecting them with the YNET switching network in a massively parallel system. The DBC 1012 was designed to manage databases up to one Terabyte 1,000,000,000,000 characters in size. The major components of the DBC 1012 architecture included Mainframe Resident Software to manage users and transfer data Interface Processor IFP the hardware connection between the mainframe and the DBC 1012 YNET a purpose built system interconnect that supported broadcast and sorting Access Module Processor AMP the unit of parallelism includes microprocessor, disk drive, file system, and database software System Console and Printer TEQUEL TEradata QUEry Language an extension of SQL The DBC 1012 was designed to scale up to 1024 YNET interconnected processor disk units. row database Rows of a Table database relation table were distributed by hashing on the primary index . The DBC 1012 used a 474 megabyte Winchester disk drive with an average seek time of 18 milliseconds. The disk drive was capable of transferring data at 1.9 MB s although in practice the sustainable data rate was lower because the IO pattern tended towards random access and transfer lengths of 8 to 12 kilobytes. The processor cabinet was 60 inches high and 27 inches wide, weighed 450 pounds, and held up to 8 microprocessor units. The storage cabinet was 60 inches high and 27 inches wide, weighed 625 pounds, and held up to 4 disk storage units. The DBC 1012 preceded the advent of Redundant array of independent disks RAID technology, so data protection was provided by the FALLBACK feature, which kept a logical copy of rows of a relation on different AMP ... more details
Unreferenced date September 2009 A parallel database system seeks to improve performance through parallelization of various operations, such as loading data, building indexes and evaluating queries. Although data may be stored in a distributed fashion, the distribution is governed solely by performance considerations. Parallel databases improve processing and input output speeds by using multiple CPU s and disks in parallel. Centralized and client server database systems are not powerful enough to handle such applications. In parallel processing, many operations are performed simultaneously, as opposed to serial processing, in which the computational steps are performed sequentially. Parallel databases can be roughly divided into three categories Shared memory In hardware Shared memory architecture , where multiple Central processing unit processors share the main memory space, as well as mass storage e.g. hard disk drive s . Shared disk architecture , where each node has its own main memory, but all nodes share mass storage, usually a storage area network . In practice, each node usually also has multiple processors. Shared nothing architecture , where each node has its own mass storage as well as main memory. Example parallel databases Objectivity DB IBM DATABASE2 Teradata References Communications of the ACM http portal.acm.org citation.cfm?id 129894 Parallel database systems the future of high performance database systems DEFAULTSORT Parallel Database Category Types of databases database stub de Paralleles Datenbanksystem ... more details
Infobox Software name Boeing Spatial Query Server logo Image Boeing Logo.svg 240px center screenshot File Sqs viewer.jpg 255px center caption Screenshot of SQS Viewer running under Microsoft Windows Windows developer The Boeing Company released December 2001 latest release version 3.6 latest release date November 2007 programming language size operating system Silicon Graphics SGI , Solaris operating system Solaris , Linux , Microsoft Windows Windows Windows 2000 2000 , Windows 2003 2003 & Windows XP XP language genre Geodatabase license List of software licenses Pay Licensed Closed Source Proprietary software Proprietary website http active.boeing.com mission systems products index.cfm?content include sqs.cfm&pageid m32779 Boeing SQS The Boeing Company s Spatial Query Server is a commercially available product which enables a Sybase database to contain spatial features. Geometric Types Circle Ellipse Point a point in 2D space. x,y plane. Voxel a point in 3D space. x,y,z volume. Polygon Polygon n Polygon set Gpolygon Gpolygon n Gpolygon set Line Line n Line set Rectangle Rectangle set Llbox Llbox set See also Sybase Spatial Implementation Sybase Spatial Implementation External links http active.boeing.com mission systems products index.cfm?content include sqs.cfm&pageid m32779 Boeing SQS http active.boeing.com mission systems products docs SQS 3.6 Release Notes.pdf Release Notes for Version 3.6 http active.boeing.com mission systems products docs 2006 SQS MS.pdf Product Brochure http www.teradata.com td page 115221 Teradata Magazine Spatial Query Server SQS Article Category Proprietary database management systems ... more details
, Tao Venture Partners Mar 2007 Bruce Scott employee 4 of Oracle corp & Rick Glick CTO of Teradata .... Seventeen year veteran of Teradata, and former CTO of Teradata s Database Engineering group. Competitors Oracle Corporation Teradata Greenplum Vertica References reflist External links http www.paraccel.com ... more details
7.1.3 and higher SAPDB Adaptive Server Enterprise Sybase Sunopsis XML Driver JDBC Edition TeradataTeradata Warehouse ThinkSQL RDBMS Vertica Analytic Database See also SQL Comparison of database tools ... more details
Encyclopedia
top
