•   
  •   
  •   

Technology Push-down query capabilities: Five questions to ask your cloud BI provider

00:46  12 march  2021
00:46  12 march  2021 Source:   zdnet.com

With a $10 billion cloud-computing deal snarled in court, the Pentagon may move forward without it

  With a $10 billion cloud-computing deal snarled in court, the Pentagon may move forward without it The Joint Enterprise Defense Infrastructure contract, known as JEDI, has been bogged down in litigation for years. The Pentagon is finding ways to move on without it. The weight of two long-running lawsuits has the Defense Department openly questioning whether JEDI will still be worth the trouble if the court seeks to depose former president Donald Trump and other former officials. And the success of some of the Pentagon’s other, quieter cloud initiatives is lending new weight to the idea that JEDI’s one-cloud-to-rule-them-all strategy may not be necessary in the first place.

Modern cloud DBMSes and legacy on-premises DBMSes have different levels of APIs, customization, and tuning — make sure you map the push - down query data journey for each of the DBMSes that are relevant to your environment. Does the remote DBMS platform require an installation of a component Use the data mapping exercise to optimize your data and BI architecture, minimize data movement, and satisfy internal data audits and regulatory compliance. We will be exploring this in detail as part of our upcoming Forrester Wave™ evaluation on BI platforms. If you have more questions , post a comment

Push - Down Query Capabilities : Five Questions To Ask Your Cloud BI Provider . Boris Evelson 9 hours ago. Forrester has just published 2019 refreshes of our enterprise business intelligence ( BI ) platform Wave™ evaluations. As the BI market and the technology continue to evolve, so does our research. This year, we emphasized: New market segmentation by both vendor-managed and client-managed platforms, which roughly equate to on-premises and cloud -based platforms, respectively, but not quite.

Software-as-a-service (SaaS) offers many benefits, including but not limited to elasticity: the ability to shrink and grow storage and compute resources on demand. Clients of most leading enterprise business intelligence (BI) platforms enjoy this cloud elasticity benefit but at a cost. Ultimately, elasticity requires both application and data components (compute and store) to be elastic, and therefore, cloud-native BI platforms require that on-premises data be ingested into the cloud platform before it can be analyzed. But not all organizations are ready to let go of their data from inside their firewalls, and they are not ready to commit to a single cloud provider -- most are opting for a hybrid on-premises and multicloud environment.

Why the mainframe is alive and thriving

  Why the mainframe is alive and thriving Mainframes are still going strong after 70 years.As with each wave, pundits, analysts, and industry watchers have forecasted the death of the mainframe. Yet, the venerable mainframe has prevailed.

Get Help with Power BI . Desktop. Query Editor on Power BI Cloud . I would like to know if I can access the Query Editor to transform my Data with Power BI Cloud ? Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Ask Question . Asked 1 year, 9 months ago. Do both of these provide the predicate pushdown optimization? Thank you. LEFT JOIN with ON filter does not require additional OR condition because it filters right table before join, this query works as expected and easy to understand Get terminal status for termcap capabilities .

background pattern © ZDNet

Top Cloud Providers

a screen shot of a person: Top cloud providers: AWS, Microsoft Azure, and Google Cloud, hybrid, SaaS players © Provided by ZDNet Top cloud providers: AWS, Microsoft Azure, and Google Cloud, hybrid, SaaS players

Top cloud providers: AWS, Microsoft Azure, and Google Cloud, hybrid, SaaS players

Here's a look at how the cloud leaders stack up, the hybrid market, and the SaaS players that run your company as well as their latest strategic moves.

Read More

So how do such organizations balance the need for a hybrid environment with all the benefits they can get from an elastic, modern cloud-based BI platform? The answer is: a push-down query capability -- pushing an SQL query to an on-premises (or a different cloud platform) database management system (DBMS) and only moving the result set (the result of the query, not the entire database [DB]) to the cloud platform. But some data -- the result set -- still needs to move to the cloud in order to populate reports and dashboards.

WandaVision: 10 Burning Questions We Have After Watching the Finale

  WandaVision: 10 Burning Questions We Have After Watching the Finale (Warning: This post contains spoilers from WandaVision’s finale. Read at your own risk!) That’s a wrap on WandaVision! The series, which explored grief and trauma through its titular heroine, closed the book on Westview with a stacked finale that saw Wanda finally setting the townsfolk free by bringing the Hex down — but not before

A cloud service provider (CSP) is a company that offers one or more pieces of cloud computing functionality including SaaS, PaaS, and IaaS. Likely, the first thing you’ll discover when looking for a cloud service provider is that there’s a very large number to choose from. As with web hosting providers , not all cloud service providers are equal. By asking these questions , in no particular order except the first, you can quickly eliminate many potential providers from your list. 1. What Cloud Computing Services Do You Provide ?

Push - Down Query Capabilities : Five Questions To Ask Your Cloud BI Provider . Boris Evelson 47 mins ago. Software-as-a-service (SaaS) offers many benefits including but not limited to elasticity – the ability to shrink and grow storage and compute resources on demand. Clients of most leading enterprise business intelligence ( BI ) platforms enjoy this cloud elasticity benefit, but at a cost.

It's 9 a.m. Do You Know Where Your Data Is?

To understand exactly how much on-premises data moves to the cloud and when, even in a push-down query scenario, you need to consider the following components of your BI platform, where data can reside at any moment during BI operations (SQL, OLAP): remote (on-premises or on a different public cloud) DBMS, the platform's DBMS (disk or in-memory), the platform's app server cache, and the platform's full or browser-based client. Then go through the following Q&A with your tech experts and your cloud BI platform provider and map data locations throughout the push-down query data journey.

  • Describe your data journey through the four components during the initial SQL or MDX query. This will help you map physical locations of the data set (or subsets) when you first run a report or pull up a dashboard.

  • Describe the data journey through the four components when a drill-through to detail or a drill-across to a different dimension require an update to the result set. This will help you map physical locations of the data set (or subsets) during every click as you are analyzing the results -- slice and dice.

    Oracle applies the lessons of the pandemic to update Fusion Cloud Applications

      Oracle applies the lessons of the pandemic to update Fusion Cloud Applications Leaders in the app dev team say the changes improve risk management for supply chains and integrate multiple business processes seamlessly.Catherine You, vice president of product development at Oracle, showed off the augmented reality capabilities in a demo that illustrated the decision-making process behind a customer request for a bigger line of credit.

    These are questions that you should ask your potential cloud providers . This will help reduce risk and set expectations when setting up and operating with virtual servers.

    Here are five key questions to ask any potential UCaaS provider before making a decision that will affect your business each and every day: 1. Is your UC solution a true cloud offering? ( Ask for a supporting explanation.) This is an extremely important question as it could impact your organization, and your Partner with UC providers that offer cloud communications expertise to help you design a solution to meet your specific business needs and implement the solution in lockstep with your Project Management organization. Tip: If you find a UC provider that tells you their solution is so simple that implementation

  • Once a connection between a cloud BI platform and a remote DB is made and an initial push-down query is executed, do all subsequent queries still need to go through the BI app server on the cloud, or is there now a direct connection between your BI full client/browser and the DB? In the latter scenario, if both your PC and the DB are on-premises but the BI platform is on the cloud, the subsequent data movement can all happen inside your firewall. This will help you get an extra level of comfort that no data leaves your firewall.

  • Are all remote DBMSes supported in the same manner for push-down query capability? Modern cloud DBMSes and legacy on-premises DBMSes have different levels of APIs, customization and tuning -- make sure you map the push-down query data journey for each of the DBMSes that are relevant to your environment.

  • Does the remote DBMS platform require an installation of a component from the BI platform? The nirvana of push-down query capability is to minimize data movement as much as possible. This requires bidirectional "smart" communication between the BI platform and a remote DBMS beyond just processing a query and returning the result set -- usually achieved by installing a BI platform component (an agent program or a stored procedure) in the target DBMS.

Use the data mapping exercise to optimize your data and BI architecture, minimize data movement, and satisfy internal data audits and regulatory compliance.

To understand the business and technology trends critical to 2021, download Forrester's complimentary 2021 Predictions Guide here.

This post was written by VP and Principal Analyst Boris Evelson, and it originally appeared here.

Britain's Prince Philip dies at age 99 .
As the longest-serving consort, Prince Philip supported his wife, Queen Elizabeth, throughout the transformation of a once-global British Empire."His Royal Highness passed away peacefully this morning at Windsor Castle," the royal family announced. "Further announcements will be made in due course. The Royal Family join with people around the world in mourning his loss.

usr: 0
This is interesting!