Visualizing performance in Red Hat Enterprise Linux 8.4 web console

Performance is a critical focus area of improvement with every release of Red Hat Enterprise Linux (RHEL). With RHEL 8.4, we introduced several key performance enhancements for system administrators and performance engineers to enable simpler troubleshooting experiences, richer  visualization of performance metrics, and deeper performance insights. In this blog, we will go over some of these capabilities.
Quelle: CloudForms

U.S. Navy Technology with Google Cloud and STS Jumpstart Expansion Across DoD and Beyond

The U.S. Navy spends billions annually to fight rust and corrosion on its ships. Of course, this is to be expected given its vessels are largely made of steel. However, inspections of ships, aircraft and vehicles are a time-consuming and critical part of keeping the U.S. Navy at top performance.  To address this issue, Google Cloud and Simple Technology Solutions (STS)—a Google Cloud partner and 8a HUBZone small business specializing in cloud solutions for the federal government—successfully completed the first phase of its project to help identify rust and corrosion in hard-to-reach places of ships, funded by the Department of Navy (DON) Small Business Innovation Research program. With the successful completion of phase one, STS and Google Cloud teams are now kicking off its second phase. In the first phase, STS built a corrosion detection and analysis solution using Google Cloud’s artificial intelligence/machine learning (AI/ML) platform. Leveraging Google’s native computer-vision capabilities and commercial drones, the team successfully identified “corrosion of interest” in aerial images of vessels, with confidence scores of more than 90% with very few false positives. This was an engineering feat that required complex integration between emerging software and hardware technologies.  Phase two of the project aims to achieve the same corrosion detection capability across any required platform. As such, the solution will be expanded to include aircraft, buildings, bridges, and other infrastructure across the Department of Defense (DoD), and other commercial verticals, like oil and gas, construction, and maritime shipping.  With commercialization and speed-to-market being the priority, STS will also add a front-end user interface (UI) to the solution in phase two. The UI will include interactive 3D models of the platform to map detection of severe corrosion to the exact location on the vessel or aircraft. This will allow inspectors to use the solution independently in the field and best prioritize where they spend their time.  “The objective for the project was not only intended for ships, aircraft, or vehicles, but also to truly transcend all forms of corrosion across industries,” said Steve McKee, lead for DON’s Naval Enterprise Sustainment Technology Team. “The corrosion problem is not unique to the Navy, or to the Department of Defense. There are ramifications for the defense industry, maritime shipping, aviation, mining, and more. There are countless sectors for which this solution will have a resounding impact. We believe the entire defense ecosystem will benefit.” Expanding AI / ML platform detection and analysis capabilities is a complex engineering challenge and will require extensive new data collection, expanded sensor capabilities, and new algorithms, including: New data collection: STS is partnering with DroneUp, a commercial drone flight services company, to collect new platform corrosion images using semi-autonomous drones. In addition to automating data collection, DroneUp will show the interiors of vessels and tanks—not just the exterior. Several groups within the Department of the Navy, the Department of the Air Force, and other federal agencies are contributing a trove of corrosion data across platforms to expedite training the new models. This collaboration is a testament to the pervasiveness of the corrosion detection and inspection challenges. Expanded sensor capabilities:Images and RGB color model and camera sensors data are not sufficient to detect corrosion on all platforms. For example, infrared or multi-spectral sensors are required for aircraft, as thick coats of paint typically cover the corrosion, making it invisible to the naked eye. Similarly, submarines and ships have anechoic tiles, or surfaces that are coated in rubber. An “ecosystem of sensor data” is required to achieve platform agnosticism and maximize commercialization potential.  New algorithms: New data technologies and models will be developed corresponding to the various  sensor inputs and then fused with the solution. The existing model will also be enhanced to include a categorization schema to prioritize inspector activities. This application of AI / ML combined with drone imagery showcases one of the many possibilities for this technology across the DoD and beyond. As this collaboration continues to phase two, Google Cloud and STS will continue to work toward ways to further expand this corrosion detection model, and ultimately improve the process for corrosion across all types of infrastructure. To learn more about our solutions for the Federal Government, visit cloud.google.com/solutions/federal-government. 
Quelle: Google Cloud Platform

Have a cool summer with BigQuery user-friendly SQL

With summer just around the corner, things are really heating up. But you’re in luck because this month BigQuery is supplying a cooler full of ice cold refreshments with this release of user-friendly SQL capabilities. We are pleased to announce three categories of BigQuery user-friendly SQL launches: Powerful Analytics Features, Flexible Schema Handling, and New Geospatial Tools.Powerful Analytics FeaturesThese powerful SQL analytics features provide greater flexibility to analysts for organizing, filtering, and rendering data in BigQuery than ever before. You can enable spreadsheet-like functionality on summarized data using PIVOT and UNPIVOT and filter irrelevant data in analytic functions using QUALIFY.Through this section, we will become familiar with these new features through examples using the BigQuery Public dataset, usa_names.PIVOT/UNPIVOT (Preview)One of the most time-consuming tasks for data analytics practitioners is wrangling data into the right shape. SQL is great for wrangling data, but sometimes you want to reformat a table as you would in a spreadsheet, pivoting rows and columns interchangeably. To support this use case, we are pleased to introduce PIVOT and UNPIVOT operators in BigQuery. PIVOT creates columns from unique values in rows by aggregating values, and UNPIVOT reverses this action.The example below uses PIVOT on bigquery-public-data.usa_names.usa_1910_current to show the number of males and females born each year, representing each gender as a column. Then UNPIVOT reverses this action.QUALIFY (Preview)More advanced users of SQL know the power of analytic functions (aka window functions). These functions compute values over a group of rows, returning a single result for each row. For example, customers use analytic functions to compute a grand total, subtotal, moving average, rank, and more. With the announcement of support for QUALIFY, BigQuery users can now filter on the results of analytic functions by using the QUALIFY clause. QUALIFY belongs in the family of query clauses used for filtering along with WHERE and HAVING. The WHERE clause is used to filter individual rows in a query. The HAVING clause is used to filter aggregate rows in a result set after aggregate functions and GROUP BY clauses. The QUALIFY clause is used to filter results of analytic functions. To show the utility of QUALIFY, the example below uses QUALIFY to return the top 3 female names from each year in the last decade using from bigquery-public-data.usa_names.usa_1910_current. Flexible Schema HandlingNew SQL for administrators and data engineers enables table renaming for data pipeline processes, as well as flexible column management.Table Rename (GA)In data pipeline processes, tables are often created and then renamed so that they can make way for the next iteration of the pipeline run. To accomplish this, customers need a mechanism by which they can create a table and then subsequently rename it. Now if customers want to change this name using SQL, they can. Using the simple syntax that ALTER TABLE RENAME TO provides, customers will be able to rename a table after creation to clear the way for the next iteration of tables in the data pipeline.DROP NOT NULL constraints on a column (GA)While BigQuery has historically provided many tools available in the UI, CLI and APIs, we know that many administrators prefer interfacing with the database using SQL. BigQuery recently released DDL statements which enable data administrators to provision and manage datasets and tables, greatly simplifying provisioning and management. Today, we continue the next addition in this line of releases by announcing ALTER COLUMN DROP NOT NULL constraint on a column:ALTER COLUMN DROP NOT NULL allows the administrator to remove the NOT NULL constraint from a column in BigQuery.CREATE VIEW with column list (GA)Views are used ubiquitously by BigQuery customers to capture business logic. Oftentimes, BigQuery users have business requirements to assign aliases to columns in views. Now BigQuery supports doing so upon view creation in a column name list format with the release of CREATE VIEW with column list syntax.New Geospatial ToolsST_POINTN, ST_STARTPOINT, and ST_ENDPOINTGeospatial data is incredibly valuable to data analytics customers dealing with data from the physical world. BigQuery has very strong geospatial function support to help customers process marketing data, track storms, or manage self-driving cars. Particularly for analyzing vehicle or location tracking data, we’re thrilled to provide three new functions to allow users to easily extract or filter on key points:  ST_POINTNST_STARTPOINTST_ENDPOINTFor example, when working with vehicle histories,  ST_POINTN, ST_STARTPOINT, and ST_ENDPOINT allow users to extract elements such as the start and the end of a trip. For identifying origin-destination pairs these functions will make that task much easier.As sure as a hot summer day pairs well with an ice-cold beverage, these new user-friendly SQL features in BigQuery pair well with your data analytics workflows. To learn more about BigQuery, visit our website, and get started immediately with the free BigQuery Sandbox.
Quelle: Google Cloud Platform