2 reasons a federated database isn’t such a slam-dunk

DAVID LINTHICUM | March 8, 2019

article image
It’s often the first problem you solve when moving to the cloud: Your enterprise is using dozens, sometime hundreds, of different heterogenous databases, and now you need to bind them together into hundreds of virtual views of the data in the cloud.What’s good about this is that you don’t need to migrate to new databases, or even move the data from where it’s being currently hosted in the cloud. After all, there may be applications that are dependent on that data, and the last thing you want to do is to store redundant data. So, you federate. That gives you logical centralization of data without having to change where the data is physically stored, cloud or not.But not so fast. There are roadblocks to consider. Here are my top two.First, performance. You can certainly mix data from an object-based database, a relational database, and even unstructured data, using centralized and virtualized metadata-driven view. But your ability to run real-time queries on that data, in a reasonable amount of time, is another story. The dirty little secret about federated database systems (cloud or not) is that unless you’re willing to spend the time it takes to optimize the use of the virtual database, performance issues are likely to pop up that make the use of a federated database, well, useless. By the way, putting the federated database in the cloud won’t help you, even if you add more virtual storage and compute to try to brute-force the performance.

Spotlight

TransOrg Analytics

TransOrg is an award-winning specialist data science company which leverages machine learning and artificial intelligence as a medium to drive business growth. It believes in solving real business problems with measurable success with a motto to democratize access to analytics across an enterprise with the ease of automated machine learning solutions on the cloud.

OTHER ARTICLES

Researchers Explore Details of Critical VMware Vulnerability

Article | April 17, 2020

Researchers have published the details of an investigation into CVE-2020-3952, a major vulnerability in VMware's vCenter that was disclosed and patched on April 9. The flaw was given a CVSS score of 10. CVE-2020-3952 exists in VMware's Directory Service (vmdir), which is a part of VMware vCenter Server, a centralized management platform for virtualized hosts and virtual machines. Through vCenter Server, the company says, an administrator can manage hundreds of workloads. The platform uses single sign-on (SSO), which includes vmdir, Security Token Service, an administration server, and the vCenter Lookup Service. Vmdir is also used for certificate management for the workloads vCenter handles.

Read More

Is Your On-Premises Existence Under Scrutiny? VMware Cloud on Dell EMC Offers a Solution

Article | February 26, 2020

For many IT teams and organizations, maintaining an on-premises infrastructure has become an increasing challenge. The introduction of the public cloud, along with the wholesale perception that running workloads in the public cloud is less expensive and provides an equivalent environment for previously on-premises workloads have captured significant attention. While the popularity of the public cloud is an undeniable force, without considering the disadvantages of relocating applications from on-premises data centers to the public cloud organizations are unable to make a balanced business decision. From the finance perspective, the traditional process of accounting for expensive capital-funded on-premises infrastructure updates creates extra work accounting for the infrastructure assets across the life span of the equipment. For accounting teams – the main allure of moving to the public cloud is that it eliminates the significant capital spend necessary to refresh the infrastructure every few years, replacing that cost with a more manageable monthly bill from the public cloud provider.

Read More

ProtonVPN iOS app now supports the OpenVPN protocol

Article | May 7, 2020

Your ProtonVPN iOS app is now better equipped to fight censorship and offers more flexible connection options with the launch of OpenVPN for iOS. The OpenVPN protocol is one of the best VPN protocols because of its flexibility, security, and because it is more resistant to blocks. You now have the option to switch between the faster IKEv2 protocol and the more stable and censorship-resistant OpenVPN protocol.

Read More

NVIDIA Providing Free GPU Virtualization Software Access for Remote Workers

Article | March 24, 2020

To support companies needing quick setup and support for remote workers, NVIDIA is expanding their free, 90-day virtual GPU software evaluation from 128 to 500 licenses. With vGPU software licenses, companies can use their on-premises NVIDIA GPUs to provide accelerated virtual infrastructure so people can work and collaborate from anywhere. Companies can also temporarily repurpose NVIDIA GPUs being used on other projects to support their remote workers. NVIDIA offers a variety of customized vGPU software to meet diverse workplace needs; all three tiers of the company’s specialized vGPU software are available through the expanded free licensing. In addition to providing high performance and reducing latency for remote workers, NVIDIA vGPU software ensures protection for sensitive data and digital assets, which remain in the data center and aren’t saved to local client devices. This is an important security requirement for remote work across many industries, including visual effects and design, as well as for research and development.

Read More

Spotlight

TransOrg Analytics

TransOrg is an award-winning specialist data science company which leverages machine learning and artificial intelligence as a medium to drive business growth. It believes in solving real business problems with measurable success with a motto to democratize access to analytics across an enterprise with the ease of automated machine learning solutions on the cloud.

Events