IN, NOT_IN and NOT EQUAL query operators for Firestore in Datastore Mode

We’re very pleased to announce that Firestore in Datastore mode now supports IN, Not IN, and Not Equal To operators.IN OperatorFirestore in Datastore Mode now supports the IN operator. With IN, you can query a specific field for multiple values (up to 10). You do this by passing in a list of all the values you want to query for, and Firestore in Datastore Mode will match any entity whose field equals one of those values.For example, if you had a database with entities of kind Orders and you wanted to find which orders had a “delivered” or “shipped” status, then you can now do something like this: Example:SELECT * FROM Orders WHERE status IN ARRAY(“delivered”, “shipped”)Let’s look at another example: say Orders has a field Category that contains a list of categories in which the products in the order may belong to. You can now run an IN query on the categories that you are looking for.Example:SELECT * FROM Orders WHERE Category IN ARRAY(“Home Decor”, “Home Improvements”)In this case, each entity would only be returned once in the query even though they match both the categories in the query.You are now also able to use ORDER BY on both IN and Equal. The query planner originally ignored ordering on an equality, but with the introduction of IN, ORDER BY queries on multiple-valued properties now become valuable. Please make sure to check out the official documentation for additional details.  You can also use the new Query Builder in the UI to use the IN operator.Not IN & Not Equal OperatorsYou can now query using Not IN, which will allow you to find all entities where a field is not in a list of values. For example, entities with kind Orders where the status field is Not IN [“shipped”, “ready to ship”].Example:SELECT * FROM Orders WHERE status NOT IN Array(“shipped”, “ready to ship”);Using Not IN via Query Builder in the UIWith Not Equal you can now query for entities where a field is not equal to some given value. For example, entities of kind Orders where the status field is not equal to the value “pending”.Example:SELECT * FROM Orders WHERE status != “pending”;Using Not Equal via Query Builder in the UINote that with Datastore’s multi-value behavior using Not IN and Not Equal requires only one element to match the given predicate. For instance, Category Not IN [“Home Decor”, “Home Improvements”] would still return both e1 and e2 since they contain the category “Kitchen” and “Living Room”.We hope these new additions enhance your development experience. We look forward to learning about how you’ve taken advantage of these new features, thank you! Please visit the official documentationto learn more.
Quelle: Google Cloud Platform

Investing in Differentiation brings great customer experiences and repeatable business

“Customer success is the cornerstone of our partner ecosystem and ensures our joint customers experience the innovation, faster time to value, and top notch skills from Google and Google Cloud Partners.”—Nina Harding, Global Chief, Partner Advantage Program.Our ecosystem is a strong, validated ally to help you drive business growth and solve complex challenges. Differentiation achievements help you select a partner with confidence, knowing that Google Cloud has verified their skills and customer success across our products, horizontal solutions and key industries.  In all cases, our partners have demonstrated their commitment to learning and ongoing training, demonstrated through earned certifications, Specialization and Expertise. To further refine the process of helping customers find the best partner fast, we recently introduced Net Promoter Score© within Partner Advantage.  This industry standard rating tool allows customers to provide feedback and insights on their successes with partners quickly and easily. We encourage you to work with your partners to share your success and provide feedback using Net Promoter Score.To find the most highly qualified, experienced partners the Google Cloud Partner Directory puts you in the driver’s seat. This purpose-built tool helps customers like you leverage partner Differentiation achievements to move forward with confidence as you start your next project.This new “How to find the right Google Cloud Partner” video shows you how to create a shortlist of potential partners by Region, and based on 14 different strategic solution categories or 100+ Expertise designations.To find a partner that meets your specific needs, or complements your capable team, look no further than Partner Advantage’s Differentiation framework and share in our congratulations to some partners that have achieved Specialization the past few quarters.Related ArticleStanding out to customers through the Partner Differentiation journeyLearn how Google Cloud Partner Advantage partners help customers solve real-world business challengesRead Article
Quelle: Google Cloud Platform

REWE Group accommodates growth spikes and enhances hybrid architecture with Google Cloud

Significant growth in our business partnerships at REWE Group in Austria has led to an unprecedented increase in traffic across our applications. As one of Europe’s largest retail and tourism groups, our burgeoning user base continues to emanate from a variety of sources including new retail partners, affiliate stores, and online customers from desktop and mobile applications. We serve millions of customers in the retail and tourism sectors worldwide and we onboarded Google Cloud services when our applications needed more flexibility and scalability. We needed to efficiently accommodate the dramatic seasonal and even weekly fluctuations we experienced as the pandemic increased our online shopping traffic. As traffic to our applications increased, our team began hosting our traffic-heavy data on a cluster in Google Kubernetes Engine (GKE), successfully leveraging the data management and storage of Cloud Spanner. As a fully managed relational database, Spanner provides unlimited scale, strong consistency, and up to 99.999% availability. By choosing this approach to deployment, we didn’t need to migrate our end user data and maintained a highly flexible cloud environment with an estimated 70 percent hosted in Google Cloud and 30 percent remaining on-premises.Cloud Spanner optimizes speed and performance for online customersGiven that some of the data we migrated was tied to the customer shopping experience on our applications, it was important that the solution we chose be highly secure and reliable. Google Cloud is known for offering the highest levels of availability, reliability, global scale, and security, enabling us to deliver the best possible experiences for our customers. While accessing Spanner through a Kubernetes cluster on Google Cloud, our team developed a ledger for each end user. As the single point of truth for all transactions across the company, the ledger contained two tables. In one, we input a variety of currencies and in the other, we maintained real-time records of the balance of each user in the currency of their purchase. We leveraged the industry-leading 99.999 percent availability SLA of Spanner to optimize the performance of our applications. Spanner also helped us improve the customer experience by providing consistent performance and accelerating the speed of applications and API calls during the purchase process.Spanner provided transactional consistency and accuracy for REWE’s several million users, automatically updating their data in real time as transactions took place. We were able to seamlessly scale the processing of transactions per day to almost double. Since the platform went live, more than 500 million successful transactions have been executed. The native integrations of Google Cloud made it easy to unify our data lifecycle, ensuring the highest performance of our infrastructure at every phase of our development.Query latency is always a critical thing for us, because we are deeply integrated into the point-of-sale applications in our store. If applications are too slow, it compromises the customer experience. However, thanks to Spanner, we are able to complete API calls extremely fast.Fully managed Google services increase team productivity and champion sustainabilityAs a fully managed service, Spanner gave us the freedom to focus on differentiating activities, while operating seamlessly on-premises and in the cloud. Our developers were empowered to iterate and deploy quickly, driving new opportunities for growth and cost reductions. As a company with a 90-year history and international impact, REWE has upheld a continued commitment to environmental efficiency and sustainability across the world. This mission aligns with Google’s goal of running fully carbon-free data centers by 2030. By leveraging Google’s carbon neutrality and sustainability services including waste diversion, use of renewable energy, and enhanced efficiency, we are continuing to optimize our business operations as we champion sustainability.Learn more about how your organization can get started with Spanner today.Related ArticleChange streams for Cloud Spanner: now generally availableCloud Spanner change streams are now generally available. With change streams, you can capture and stream out changes from your Cloud Spa…Read Article
Quelle: Google Cloud Platform

Digital transformation for manufacturers requires additional IT/OT security

While every industry is vulnerable to a ransomware attack, manufacturers are at a particular risk. While digitization and automation have helped transform the industry, it has simultaneously opened up new attack vectors within organizations. Now the most targeted industry, the manufacturing industry, has seen a 300 percent increase in cyberattacks in a single year.

Beyond the tremendous growth in attacks, manufacturing companies make an ideal target for hackers due to the high value of the companies themselves, the high costs of unplanned downtime, and the highly visible impact that downtime has on consumers’ daily lives. With the risks so high, an enterprise-level solution that provides visibility and protection like Microsoft Defender for IoT is essential.

Visibility is the first step to network protection

The number of connected industrial control system (ICS)/operational technology (OT) devices in manufacturing facilities continues to grow. The benefits for the operations side of the house are clear, but the lack of visibility into them poses serious security risks for chief information security officers (CISOs).

Manufacturers often have no way to identify and monitor what all their connected devices are doing and with whom or what they are communicating. Worse, all too often they lack even a simple inventory of all the connected devices they have in their facilities. In case of an attack, the lack of visibility means that they have no way of tracing the attack vector the hacker took, making them vulnerable to a second wave and delaying recovery and remediation.

Continuous monitoring without impacting productivity

Microsoft Defender for IoT not only creates asset maps within minutes of being turned on, but it also provides continuous monitoring of every device in every facility around the world. Microsoft’s Section 52 has access to tens of trillions of identity, endpoint, and other signals each day. The threat intelligence from this specialized IoT and ICS research team produces high-impact insights that help keep manufacturers safe from attacks.

The agentless nature of the system protects companies without impacting production, no matter the topology of the network or the regulations governing the industry. And, with round-the-clock protection, Microsoft Defender for IoT can alert the SecOps team about an intrusion any time, any place.

Security for networks in an age of IT and OT convergence

As their digital transformations have progressed, manufacturers have seen their IT and OT environments converge. The air gap between them that ensured production would continue even if IT assets were taken offline is increasingly a thing of the past. With these trendlines, forward-thinking CISOs and their boards are taking proactive steps to protect the entire company from cyber-physical attacks that could have huge costs to safety, production, reputation, and the bottom line.

Fortunately, Microsoft Defender for IoT can usually be deployed in less than a single day per facility and works right out of the box for large enterprises and small, niche facilities. With it, defenders of OT networks have a powerful new tool at their disposal to help keep hackers out and people, production, and profits safe.

For more information on how Microsoft Defender for IoT can help protect your business, visit Microsoft Defender for IoT | Microsoft Azure today.
Quelle: Azure