KENNETH – 페이지 1377 – 지락문화예술공작단

쿼리 실행의 속도를 높여 주는 Amazon Redshift 구체화 보기 기능 출시

2020-03-17 KENNETH 0

쿼리 실행의 속도를 높여 주는 Amazon Redshift 구체화 보기 기능 출시 Amazon Redshift에서는 테이블에서 질의한 보기(View)는 Amazon QuickSight 또는 Tableau 같은 BI(비즈니스 인텔리전스) 도구를 위해 사용할 수 있습니다. 다만, 사용 편의성과 유연성을 제공하지만 데이터 액세스의 속도를 높여 주지 않습니다. 성능이 중요한 경우, 데이터 엔지니어는 CTAS(create table as)를 사용합니다. CTAS는 질의에 의해 정의된 테이블입니다. 질의는 테이블 생성 시점에 실행되며 애플리케이션은 CTAS를 일반 테이블과 같이 사용할 수 있습니다. 단, CTAS 데이터 세트의 단점은 관련 데이터가 업데이트되었을 때 새로 고쳐지지 않는다는 것입니다. 뿐만 아니라, CTAS 정의는 데이터베이스 시스템에 저장되지 않습니다. 테이블이 CTAS에 의해 생성되었는지 여부를 알 수 없기 때문에 어느 CTAS를 새로 고쳐야 하며 어느 것이 최신인지 추적하기가 어렵습니다. 이제 Amazon Redshift를 위한 구체화 보기(Materialized View)를 도입합니다. MV(구체화 보기)는 질의 데이터를 포함하는 데이터베이스 객체입니다. 구체화된 보기는 캐시와 같습니다. 데이터 세트를 런타임 시 구축 및 계산하는 대신, 구체화된 보기는 보기를 생성하는 시점에 데이터를 사전 [ more… ]

Controlling table encryption in MySQL 8.0

2020-03-17 KENNETH 0

Controlling table encryption in MySQL 8.0 MySQL 5.7.11 introduced InnoDB transparent tablespace encryption, which enabled support for file-per-table tablespaces, and this feature is discussed in this blog. Later in MySQL 8.0.13, encryption for general tablespace was introduced. To improve usability of encryption handling, MySQL 8.0.16 added several features to enable, disable and enforce table encryption for tables within a schema, general tablespace or entire MySQL system.… Facebook Twitter LinkedIn Source: Controlling table encryption in MySQL 8.0

USN-4303-1: Linux kernel vulnerability

2020-03-17 KENNETH 0

USN-4303-1: Linux kernel vulnerability linux, linux-aws, linux-kvm vulnerability A security issue affects these releases of Ubuntu and its derivatives: Ubuntu 16.04 LTS Summary The system could be made to expose sensitive information. Software Description linux – Linux kernel linux-aws – Linux kernel for Amazon Web Services (AWS) systems linux-kvm – Linux kernel for cloud environments Details Paulo Bonzini discovered that the KVM hypervisor implementation in the Linux kernel could improperly let a nested (level 2) guest access the resources of a parent (level 1) guest in certain situations. An attacker could use this to expose sensitive information. Update instructions The problem can be corrected by updating your system to the following package versions: Ubuntu 16.04 LTS linux-image-4.4.0-1068-kvm – 4.4.0-1068.75 linux-image-4.4.0-1104-aws – 4.4.0-1104.115 linux-image-4.4.0-176-generic – 4.4.0-176.206 linux-image-4.4.0-176-generic-lpae – 4.4.0-176.206 linux-image-4.4.0-176-lowlatency – 4.4.0-176.206 linux-image-4.4.0-176-powerpc-e500mc – 4.4.0-176.206 linux-image-4.4.0-176-powerpc-smp – 4.4.0-176.206 linux-image-4.4.0-176-powerpc64-emb – 4.4.0-176.206 [ more… ]

USN-4303-2: Linux kernel (HWE) vulnerability

2020-03-17 KENNETH 0

USN-4303-2: Linux kernel (HWE) vulnerability linux-lts-xenial, linux-aws vulnerability A security issue affects these releases of Ubuntu and its derivatives: Ubuntu 14.04 ESM Summary The system could be made to expose sensitive information. Software Description linux-aws – Linux kernel for Amazon Web Services (AWS) systems linux-lts-xenial – Linux hardware enablement kernel from Xenial for Trusty Details USN-4303-1 fixed vulnerabilities in the Linux kernel for Ubuntu 16.04 LTS. This update provides the corresponding updates for the Linux Hardware Enablement (HWE) kernel from Ubuntu 16.04 LTS for Ubuntu 14.04 ESM. Paulo Bonzini discovered that the KVM hypervisor implementation in the Linux kernel could improperly let a nested (level 2) guest access the resources of a parent (level 1) guest in certain situations. An attacker could use this to expose sensitive information. Update instructions The problem can be corrected by updating your system to [ more… ]

USN-4302-1: Linux kernel vulnerabilities

2020-03-17 KENNETH 0

USN-4302-1: Linux kernel vulnerabilities linux, linux-aws, linux-aws-hwe, linux-gcp, linux-gke-4.15, linux-hwe, linux-kvm, linux-raspi2, linux-snapdragon vulnerabilities A security issue affects these releases of Ubuntu and its derivatives: Ubuntu 18.04 LTS Ubuntu 16.04 LTS Summary Several security issues were fixed in the Linux kernel. Software Description linux – Linux kernel linux-aws – Linux kernel for Amazon Web Services (AWS) systems linux-gke-4.15 – Linux kernel for Google Container Engine (GKE) systems linux-kvm – Linux kernel for cloud environments linux-raspi2 – Linux kernel for Raspberry Pi 2 linux-snapdragon – Linux kernel for Snapdragon processors linux-aws-hwe – Linux kernel for Amazon Web Services (AWS-HWE) systems linux-gcp – Linux kernel for Google Cloud Platform (GCP) systems linux-hwe – Linux hardware enablement (HWE) kernel Details Paulo Bonzini discovered that the KVM hypervisor implementation in the Linux kernel could improperly let a nested (level 2) guest access the resources [ more… ]