Teradata promote global database technology change

Teradata promote global database technology change

The smartest database software, the most intelligent analysis

China, Suzhou--the world's leading data analysis solutions manufacturer Teradata (Teradata Corporation, NYSE: TDC) announced the global release of the Teradata database 14 databases, The database has more than 80 new features and 60 new built-in analytics capabilities to provide customers with transformative database technology to support a breakthrough business intelligence strategy.

Teradata Database 14 has advanced the development of global databases technology with the combination of integrated ranks, market-leading innovations for improved workload management, multi-temperature data usage, sequential data functionality, security, and application portability.

"The Teradata database is the operating foundation of our important customers, which makes their business intelligence environment run faster, smarter and more intuitive," says Scott Gnau, president of Teradata Laboratories. Teradata's approach is to allow customers to leverage the right amount of memory and storage, including solid-state drives and hard drives, to deliver the best performance data warehouse at the most competitive price. ”

A database that specializes in column and line analysis

Teradata Company integrates the vertical column (columnar) functionality into the design of the Teradata database, while optimizing other robust database functions. By consolidating the vertical functions into the database core architecture, all functions complement each other and achieve the results that cannot be achieved when separated. This consolidation provides users with a mixture of row and column databases to address the most diverse performance challenges in the most comprehensive way. "The Teradata function helps customers provide faster, more accurate analysis for more people," Gnau. This unmatched performance and flexibility can provide support for organizations with large data volumes, growing user populations, and better intelligent requirements, and are implemented on existing platforms. For”

Unlike relational database management systems that store data in rows (rows), column databases store data in columns. Each method has a unique advantage when working alone, depending on the application and the data type. However, Teradata's new column functionality can provide customers with the advantages of both methods, helping Teradata databases run faster, provide a higher compression rate, and the most comprehensive environment.

Workload Management

Teradata Workload management can provide support for enterprises to take full advantage of diverse data types and proprietary applications from a variety of sources. Today, the volume of data is expanding rapidly, including massive amounts of traditional data, as well as new large data generated by social media, network interaction, E-commerce, sensors and mobile devices.

Industry-leading Teradata workload management now introduces virtual partitioning to allocate system resources among teams or business units within a single company. Once the user priority setting is completed, the Teradata database dynamically manages resources across the system to ensure that the workload is properly supported.

For example, the marketing department gets the highest priority for system resource allocations to support Web site boarding products and runs as a tactical workload. In comparison, strategic marketing teams that engage in customer segmentation analysis get fewer resources because of their lower priority. In addition, the financial department can define a completely different workload management plan within its partition based on application and calendar combinations, and the financial statements can have the highest priority as needed when closing the month or quarter.

Industry's only intelligent "cold"/"hot" data storage solution

With the increasing popularity of large data, the database urgently needs enough intelligence to determine the "hot" or "cold" data for the organization dynamically. Teradata databases increase the use of hybrid storage for smarter, more intelligent data management, "hot" data is most frequently used, and "cold" data is used least. Hotter, more pervasive data needs to be kept in the fastest storage device, while less active and colder data can be moved into slower and more economical storage devices.

The Teradata database has the only intelligent virtual storage solution in the industry that automates migration, compression, or decompression of cold data between different drives for optimal performance and storage space utilization. Teradata automated self-help management design without operator intervention. Cold data can be compressed up to 5 times times maximum, keeping disk storage costs to a minimum. In addition, Teradata database 14 can use the natural decompression format to save commonly used data, avoiding the repetitive decompression process to optimize performance.

With the help of Teradata column database function, the target of data temperature measurement is clearer, so that the highest system efficiency can be achieved. By physically storing each column of data separately, the automated temperature tracking mechanism measures the temperature in each data field in a row and applies data storage and compression accordingly. For example, if the customer number and product SKU in a large sales table are used in most business intelligence queries, the two columns of data will be stored in the fast storage. At the same time, the infrequently used data in the sales table is automatically compressed and stored in slower storage.

The first time sequential function to create a global image

The first implementation of the Teradata database enables customers to capture and track changes in their company as the business progresses by capturing and tracking the organization's business at any point in time. The Teradata database timing function has been enhanced to create business panorama at any point in time, anywhere in the world.

Security

The new Teradata column-level security enhances security performance, allowing only the information that is appropriately authorized to access granularity (granular level). For example, a regional sales manager may have access to the overall sales data in other regions, while prohibiting access to the registration information and remuneration of individual salespeople. At the same time, HR or Sales managers can only see the ratings of each salesperson in the incentive plan, but not the totals or range data. Security levels can be deepened and divided as needed.

Application and Data migration

The migration capabilities of Teradata Database 14 have been expanded to easily migrate applications and data from other poorly performing platforms and to seamlessly address emerging large data issues. New features in the Teradata database enable easier migration of data and associated applications from other vendors ' databases.

The Teradata database is a high-performance analysis engine that will make all of its dedicated platform series powerful. It includes Teradata dynamic Enterprise-class data Warehouse platform, special platform for Data Warehouse, ultra-high performance special platform, huge data special platform and special platform for Data mart. In addition, Teradata Database 14 offers a software mart and Teradata Express for cloud computing solutions.

As part of its data warehousing solution, Teradata has established a wide range of partnerships with industry-leading software vendors to jointly provide support services to customers. The following partners have tested and provided technical support for Teradata 14: Ab initio Software, Ataccama Corporation, Atanasoft, Attensity, Ibm:infosphere Information Server, infosphere change Data Capture, Infosphere Optim, Infosphere Guardium, IBM Cognos Business FDI (validation tests have been completed and will be supported within 90 days of the final release), Informatica Corp., information Builders, Kxen, McAfee, Inc., Microsoft Corporation, MicroStrategy, Narus, OPNET Technologies, Inc., protegrity, SAS (testing and certification in progress), Tableau Software, Thomson Reuters, voltage Security, Ward Analytics and Wherescape.

(Responsible editor: Lu Guang)