Tag: Amazon Aurora

Feed: AWS Partner Network (APN) Blog. Author: Noora Husseini. By Noora Husseini, Lead Data Scientist at TIBCO SoftwareBy Mariano Luna, Sr. Manager, Cloud and Technology Alliances at TIBCO SoftwareBy Dilip Rajan, Partner Solutions Architect at AWSIn March 2020, TIBCO Software—an integration, analytics, and event-processing software provider—launched an analytics app to track the spread and impact of the COVID-19 pandemic in real-time, over local regions worldwide. The goal of this analytics app is to enable organizations to assess the potential impact of the COVID-19 pandemic on their business fabric, using sound data science and data management principles, in the context of ... Read More

Feed: Recent Announcements. A query plan is a sequence of steps used to access data in a relational database management system (DBMS). The DBMS query optimizer choses from many alternative ways to execute a given query, with widely varying performance. Because query optimizers are imperfect, database users and administrators sometimes need to manually examine and tune the plans to get better performance. Correlating this performance data can take hours without specialized expertise.  RDS Performance Insights allows all database users to identify the most resource intensive SQL queries and from where they originated on a visual dashboard in seconds. Now, RDS ... Read More

Feed: Recent Announcements. Applications communicate with databases by establishing connections, which consume memory and compute resources on the database server. Many applications, including those built on modern serverless architectures, can open a large number of database connections or frequently open and close connections. This can stress the database memory and compute, leading to slower performance and limited application scalability. RDS Proxy sits between your application and its database to pool and share established database connections, improving database efficiency and application scalability. In case of a failure, RDS Proxy automatically connects to a standby database instance while preserving connections from your ... Read More

Feed: AWS Big Data Blog. Amazon QuickSight is a fast, cloud-powered, business intelligence service that makes it easy to deliver insights and integrates seamlessly with your data lake built on Amazon Simple Storage Service (Amazon S3). QuickSight users in your organization often need access to only a subset of columns for compliance and security reasons. Without having a proper solution to enforce column-level security, you have to develop additional solutions, such as views, data masking, or encryption, to enforce security.QuickSight accounts can now take advantage of AWS Lake Formation column-level authorization to enforce granular-level access control for their users. Overview ... Read More

Feed: AWS Big Data Blog. Content, such as breaking news or sports scores, requires updates in near-real-time. To stay up to date, you may be constantly refreshing your browser or mobile app. Building APIs to deliver this content at speed and scale can be challenging. In this post, I present an alternative to an API-based approach. I outline the concept and virtues of a log-based architecture, a software architecture that uses a commit log to capture data changes to easily build new services, and databases on other services’ full datasets. These data changes can also be content for the web ... Read More

Feed: Recent Announcements. Aurora Serverless is an on-demand, auto-scaling configuration for Amazon Aurora (MySQL-compatible and PostgreSQL-compatible editions), where the database will automatically start up, shut down, and scale capacity up or down based on your application's needs. It's a simple, cost-effective option for infrequent, intermittent, or unpredictable workloads. With Amazon Aurora Serverless, you no longer have to provision or manage database capacity. You simply create an endpoint through the Amazon RDS Management Console, and Aurora Serverless handles the rest. You pay by the second, and only when the database is in use. Aurora Serverless with MySQL 5.7 compatibility is supported ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Phil de Valence. By Phil de Valence, Principal Solutions Architect for Mainframe Modernization at AWSAmazon Web Services (AWS) CEO Andy Jassy says, “The main reasons that organizations are moving to the cloud are speed and agility.” Mainframes typically host core business processes and data. To stay competitive, customers have to quickly transform their mainframe workloads for agility while preserving resiliency and reducing costs. There is a challenge in defining the agility attributes and prioritizing the corresponding transformations for maximum business value in the least amount of time. In this post, I will describe ... Read More

Feed: Recent Announcements. An Aurora Global Database is a single database that spans multiple AWS regions, enabling low latency global reads and disaster recovery from region-wide outages. Today’s launch enhances Global Database by making the location of the primary region transparent to the application. Writes can be sent to a read replica in a secondary region, and will be seamlessly forwarded to the writer in the primary region over a secure communication channel. Aurora sets up this channel so you don’t need to worry about any additional networking setup. Check out this blog to find out how to enable your ... Read More

Feed: Recent Announcements. The Data API enables you to invoke SQL commands against an Aurora Serverless database through an HTTPS API endpoint. To see all the regions in which Data API is available and to get started, refer our documentation. You can learn about building Serverless applications on Aurora Serverless using Data API in our 10-minute tutorial.   ... Read More

Feed: AWS for SAP. Author: Patrick Leung. For a long time, on-premises SAP projects involved lots of upfront requirement analyses, evaluation, and sizing processes to minimize risk. In practice, we’ve encountered many situations where, after weeks of planning, those initial decisions will have to change. Your SAP architecture must be flexible enough to respond quickly to business demand, implement solutions quickly, refine based on feedback, and repeat. In this blog post, we use SAP Commerce as an example to demonstrate how you can have an agile SAP architecture on AWS. We start with a minimum lovable product (MLP), then walk ... Read More