Cloud Storage

Datometry Inspires Teradata and Oracle Customers to Shift to Cloud Without Changing the Code

Teradata is a notable identity for its advanced SQL engine designed for handling extreme complex functions such as recursive queries, unique syntax, and custom logic for parallelizing workloads. Additionally, it is also known for its scalability and performance. As a result, Teradata has skillfully positioned itself for organizations with the most challenging analytic issues, and it finally embraced the cloud aggressively.

Further, as representative of the modern cloud, the Redshifts, Synapses, Snowflakes, and BigQueries hyperscale the alternatives with pay-as-you-go pricing that provides more cost-efficient options to legacy Teradata platforms. Unfortunately, for several organizations, functionality gaps or source code and/or schema changes have been the roadblocks for migration.

Datometry says that the solution is not data virtualization but database virtualization. Its technique is to insert a runtime that performs as a buffer between your Teradata SQL statements and the target cloud environment. The strategy is to empower Teradata customers to run their Teradata queries on diverse targets without modifying or completely rewriting the existing SQL programs. Its Hyper Q product is including Oracle to the list of database sources.

The center of Datometry's approach is its trademarked hypervisor that emulates the SQL database calls on the go. It breaks down those complex calls, stored procedures, and/or macros into nuclear operations understandable by the target environment at the backend. Assuming that these operations are probably critical, it offers policy-based queueing that syncs with existing policies run on the source. It also gives JDBC and ODBC APIs for BI and ETL tools.

Certainly, Datometry is not the first to state not to change the existing codes. There are SQL translators, but Datometry claims that they might not be optimally effective. According to Datometry, code converters should handle approximately 60-70% of all workloads. The traditional way was adding the non-SQL code in the application to compensate for the variance between the Teradata SQL and SQL of the target database. Similarly, schema migration tools of cloud databases often miss the custom data types and structures.

But the question is whether Datometry can handle all the eccentricities of Teradata SQL? The organization claims that it has 99% coverage of Teradata workloads. Invariably, there is a cost involved- Datometry's virtualization layer will include 1-2% of overhead. Though they claim that with EPA ratings, your mileage will differ depending on the workloads, it is a small price to pay compared to the overhead cost of maintaining SQL code and schema conversion tools.

About four years ago, Datometry performed its initial proof of concept (POC) with SQL Server on HPE Superdome machines on-premises. Further, it has pivoted to support Azure Synapse and Google BigQuery in the cloud. Finally, as disclosed above, it has just announced a preview for Oracle. Most importantly, Datometry has not yet aimed at Amazon Redshift or Snowflake - so it still has a lot to work on.

Spotlight

Other News
Cloud Storage

TRG Screen Announces Acquisition of Xpansion for Reference Data Usage Management

PR Newswire: | January 25, 2024

TRG Screen, the leading provider of enterprise subscription spend and usage management software, today announced it has acquired Xpansion, the leading provider of cloud-based solutions for reference data usage monitoring in the financial services industry. The acquisition of Xpansion will further solidify TRG Screen's position as a global market leader in market data management solutions. Xpansion – established in 2013 – is focused on empowering data operations teams to proactively manage their usage, control costs and optimize data workflows. Xpansion's offerings include Xmon, Xprocess and Xplore, and provide real-time analytics, giving clients unprecedented transparency, visibility and control into their reference data usage. This deal consolidates TRG Screen's unique position as the only provider of enterprise subscription management capabilities spanning the whole spectrum of market data optimization, from spend and inventory tracking, through to usage and enquiry management, exchange reporting and compliance. "Xpansion and TRG Screen have been partners for many years. Bringing Xpansion into the TRG Screen family is a very logical next step for both companies, given our strong relationship and shared view that the industry demand for integrated usage management solutions is going to continue to grow," said TRG Screen CEO Leigh Walters. "Xpansion is an established firm with excellent customer satisfaction and retention, and highly experienced and industry respected leadership. We are very excited at the opportunities this acquisition brings." "We are thrilled to be joining TRG Screen," said Xpansion co-founder and CEO Amjad Zoghbi. "Reference data usage is one of the most complex aspects of market data management, and managing it correctly is essential to maintaining contractual compliance and ensuring clients are right-sizing their usage based on actual consumption and business need. I'm very pleased that Xpansion's customers, and team, will now be part of the best-of-breed solution with the industry's leading provider of market data management solutions." The acquisition demonstrates TRG Screen's ongoing commitment to servicing the needs of market data consumers, vendors and exchanges. Financial terms of the transaction were not disclosed. About TRG Screen TRG Screen is the leading provider of enterprise subscription management solutions. Founded in 1998, TRG Screen is uniquely differentiated by its ability to monitor both spend and usage of data and information services including market data, research, software licenses, consulting and other corporate expenses. TRG Screen's solutions provide its customers with full transparency into their vendor relationships and their subscription spend and usage, enabling them to optimize their enterprise subscriptions. TRG acquired Priory Solutions in 2016, Screen Group in 2018, Axon Financial Systems in 2019, Market Data Insights in 2020, and Jordan & Jordan's Market Data Reporting (MDR) business in 2021 and with these acquisitions is now positioned as the global market leader in the financial, legal, and professional services markets. TRG Screen's product portfolio includes subscription spend, usage, enquiry and compliance solutions. For more information visit trgscreen.com. Follow TRG Screen on LinkedIn, @TRG Screen, and on Twitter, @trgscreen. About Xpansion Xpansion delivers next-generation reference data solutions that empower financial institutions to streamline their reference data operations, reduce costs, enhance data quality, and improve data discovery. With a focus on customer satisfaction, continuous innovation and quick time to value, Xpansion is a trusted partner for financial institutions in the buy- and sell-side as well as solution providers in the industry.

Read More

Cloud Infrastructure Management

The Manufacturing Sector Experiences More Attacks in the Cloud than Any Other Industry

PR Newswire: | January 19, 2024

Netwrix, a cybersecurity vendor that makes data security easy, today revealed additional findings for the manufacturing sector from its survey of 1,610 IT and security professionals across more than 100 countries. According to the survey, 64% of companies in the manufacturing sector suffered a cyberattack during the preceding 12 months, which is similar to the finding among organizations overall (68%). However, it turned out that the manufacturing sector experiences more cloud infrastructure attacks than any other industry surveyed. Among manufacturing companies that detected an attack, 85% spotted phishing in the cloud compared to only 58% across all verticals; 43% faced user account compromise in the cloud as opposed to 27% among all industries; and 25% dealt with data theft by hackers in the cloud compared to 15% for organizations overall. "The manufacturing sector relies heavily on the cloud to work with their supply chain in real time. This makes their cloud infrastructure a lucrative target for attackers — infiltrating it enables them to move laterally and potentially compromise other linked organizations, as happened to one the world's top meat processing companies. Credential compromise or malware deployed via a phishing email is just the beginning of the attack," says Dirk Schrader, VP of Security Research at Netwrix. "The attack surface in the cloud is always expanding, so it's critical for manufacturing companies to adopt a defense-in-depth approach," adds Ilia Sotnikov, Security Strategist at Netwrix. "First, they must rigorously enforce the principle of least privilege to limit access to sensitive data, which ideally includes just-in-time access to eliminate unnecessary entry points for adversaries. They also need to gain deep visibility into when and how critical data in the cloud is being used so that IT teams can promptly spot potential threats. Finally, they need to be prepared to minimize the damage from incidents by having a comprehensive response strategy that is regularly exercised and updated." To learn more about security trends, check out the complete 2023 Hybrid Security Trends Report. About Netwrix Netwrix makes data security easy. Since 2006, Netwrix solutions have been simplifying the lives of security professionals by enabling them to identify and protect sensitive data to reduce the risk of a breach, and to detect, respond to and recover from attacks, limiting their impact. More than 13,500 organizations worldwide rely on Netwrix solutions to strengthen their security and compliance posture across all three primary attack vectors: data, identity and infrastructure.

Read More