投稿時間:2023-01-27 05:29:39 RSSフィード2023-01-27 05:00 分まとめ(35件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
AWS	AWS Partner Network (APN) Blog	Prometeia Launches New Wealth Management SaaS Platform with Support from AWS SaaS Factory	https://aws.amazon.com/blogs/apn/prometeia-launches-new-wealth-management-saas-platform-with-support-from-aws-saas-factory/	Prometeia Launches New Wealth Management SaaS Platform with Support from AWS SaaS FactoryAs with most industry segments Financial services are experiencing a shift towards the Software as a Service SaaS business and delivery model Explore how partnering with the AWS SaaS Factory team Prometeia created a new platform as a software as a service SaaS solution on Amazon Web Services AWS	2023-01-26 19:56:04
AWS	AWS Game Tech Blog	The Game Developer’s Guide to AWS re:Invent 2022	https://aws.amazon.com/blogs/gametech/the-game-developers-guide-to-aws-reinvent-2022/	The Game Developer s Guide to AWS re Invent AWS re Invent was back in full force in with over members of the global cloud community coming together in Las Vegas for the th edition of the conference With dozens of new products launched and hundreds of breakout sessions to attend there is always too much for one person to cover in four …	2023-01-26 19:51:24
AWS	AWS	Cake DeFi drives the industry frontier in blockchain innovation and DeFi solutions with AWS	https://www.youtube.com/watch?v=o8oJnRNRxoQ	Cake DeFi drives the industry frontier in blockchain innovation and DeFi solutions with AWSCake DeFi is a fully transparent highly innovative fintech platform dedicated to providing easy access to DeFi services and applications enabling users both retail and institutional to generate returns from their crypto and digital assets With AWS as the backbone of Cake DeFi Enterprise the startup has been able to accelerate the delivery of cutting edge products for their customers while remaining flexible on their infrastructure costs To support latency optimisation and allow their products to easily scale they have leveraged AWS Auto Scaling and are integrating with AWS development tools such as the AWS CDK to allow swift cloud deployment Learn more at Subscribe More AWS videos More AWS events videos ABOUT AWSAmazon Web Services AWS is the world s most comprehensive and broadly adopted cloud platform offering over fully featured services from data centers globally Millions of customers ーincluding the fastest growing startups largest enterprises and leading government agencies ーare using AWS to lower costs become more agile and innovate faster AWS AmazonWebServices CloudComputing	2023-01-26 19:59:34
AWS	AWS - Webinar Channel	Getting Started with Amazon Aurora Serverless v2	https://www.youtube.com/watch?v=6RfQA4nE9oU	Getting Started with Amazon Aurora Serverless vAmazon Aurora is a MySQL and PostgreSQL compatible relational database built for the cloud that combines the performance and availability of traditional enterprise databases with the simplicity and cost effectiveness of open source databases Amazon Aurora Serverless is an on demand autoscaling configuration for Aurora It automatically scales capacity up or down based on your application s needs With Amazon Aurora Serverless v you can scale database workloads instantly to hundreds of thousands of transactions per second and adjust capacity in fine grained increments to provide just the right amount of database resources for your application needs There is no database capacity for you to manage You pay only for the capacity your application consumes and you can save up to of your database cost compared to the cost of provisioning capacity for peak load In this session you will learn how Aurora Serverless v can help you operate even the most demanding database workloads worry free and how you can get started today	2023-01-26 19:29:44
AWS	AWS - Webinar Channel	Getting Started with Amazon DocumentDB Observability and Monitoring	https://www.youtube.com/watch?v=R1iOxZq9bv0	Getting Started with Amazon DocumentDB Observability and MonitoringAmazon DocumentDB with MongoDB compatibility is a fully managed native JSON database designed for scaling enterprise workloads Amazon DocumentDB provides you the flexibility of a document database without the time consuming database administration tasks freeing you to focus on innovation In this session learn about the Amazon DocumentDB features you can use to determine health and performance of your cluster visualize workloads improve operational performance and audit events performed on your cluster	2023-01-26 19:17:53
AWS	AWS - Webinar Channel	Analytics in 15: Build a Data Warehouse with Zero Infrastructure Management	https://www.youtube.com/watch?v=Y-hunnXMIbo	Analytics in Build a Data Warehouse with Zero Infrastructure ManagementAt re Invent Amazon RDS customers gained access to a number of exciting new features and capabilities Two of these were Amazon RDS Optimized Writes and Amazon RDS Optimized Reads Optimized Writes built on top of the new AWS Nitro System Torn Write Prevention feature allow you to improve your database s write transaction throughput by up to x in RDS for MySQL at no additional cost For customers looking for faster query processing capabilities can use Optimized Reads to achieve up to x faster query processing in Amazon RDS for MySQL and Amazon RDS for MariaDB at no additional cost In this webinar learn more about each of these features how they help improve the performance of your databases and how to enable them if you aren t already benefitting from them today	2023-01-26 19:12:28
海外TECH	MakeUseOf	How to Fix Missing Tabs in Windows 11 File Explorer	https://www.makeuseof.com/fix-missing-tabs-windows-11-file-explorer/	explorer	2023-01-26 19:16:16
海外TECH	MakeUseOf	The 5 Best Android Games to Play One-Handed	https://www.makeuseof.com/the-best-android-games-to-play-one-handed/	android	2023-01-26 19:01:15
海外TECH	DEV Community	What are Materialized Views? A 5-Minute Introduction	https://dev.to/educative/what-are-materialized-views-a-5-minute-introduction-11nk	What are Materialized Views A Minute IntroductionBrittney Parker has always been interested in software and databases and expanding her education of all things technical She has taken numerous coding bootcamps and development workshops to further her education in the tech space Brittney is a writer for Girls Write Tech which specializes in technical writing content and aims to encourage more female developers to share their knowledge In the world of computing a database is an organized collection of data that is typically both stored and accessed electronically from within a computer system A database management system otherwise known as a DBMS is a piece of software that allows end users along with various applications to interact with the database itself to both collect and analyze the information contained inside All of this is important to understand within the context of materialized views which play an important role in how users interact with and extract value from databases in a variety of situations Today we will discuss materialized views in detail with examples This tutorial at a glance What is a Materialized View Why use Materialized Views How to create a Materialized ViewMaterialized View vs ViewMaterialized View vs TableWhat to learn next What is a Materialized View A materialized view is a particular type of database object that contains any results derived from a query Think of this like a replica of a target master from a particular moment in time Materialized views are precomputed They will periodically cache query results to improve a database s performance Depending on the situation it could be a local copy of data that is stored somewhere remotely or it could be the product of a join result or it could even be the summary of said data that was created using an aggregate function Materialized views were first implemented by the Oracle Database and have been available in every version from i on Additional environments that support materialized views include PostgreSQL SQL Server Sybase SQL Anywhere BigQuery and more Materialized View ExamplesFor example let s say you have a database with two tables one contains the number of employees in your business and the other contains the number of departments in your business Using a materialized view you could query the database to retrieve all the employees who are associated with a particular department Or say you have a database with two tables one for the total number of sales you ve made and one for the total amount of revenue you re generating You could use a materialized view to see how much revenue each sale brings with it in real time Why Use Materialized ViewsEvery single time you query a database you always accrue some type of cost Even something as seemingly straightforward as a query still means that you are parsing validating planning optimizing and executing that query which equates to CPU time memory usage opportunity costs and more As your application continues to grow and become more demanding naturally you re looking for opportunities to reduce those costs as much as possible This is where materialized views come into play Because the results of a materialized view are maintained in memory they are only updated when it is expressly necessary to do so Because of that they can significantly reduce your overall costs as opposed to querying tables or using logical views Pros of Materialized ViewsImprove performance by precomputing expensive operationsIncrease the speed of queries on very large databasesEfficiently execute expensive queries or expensive parts of your queries Cons of Materialized ViewsNot every database type supports materialized viewsMaterialized views are read onlyYou cannot create keys constraints triggers or articles For more on why you should use a materialized view check out this article from Materialize How to create a Materialized ViewTo create a materialized view in the tool you re working with you can use a DML statement to create a basic table load data into it and create a materialized view as a result An example of an SQL command that could be used to create a materialized view is as follows CREATE OR REPLACE SECURE MATERIALIZED VIEW IF NOT EXISTS lt name gt COPY GRANTS lt column list gt COMMENT lt string literal gt CLUSTER BY lt expr gt lt expr gt AS lt select statement gt An example of a command in Oracle that could be used to create a materialized view is as follows CREATE MATERIALIZED VIEW MV MY VIEWREFRESH FAST START WITH SYSDATE NEXT SYSDATE AS SELECT FROM lt table name gt An example of a command for PostgreSQL that could be used to create a materialized view is as follows CREATE MATERIALIZED VIEW MV MY VIEW WITH storage parameter value TABLESPACE tablespace name AS SELECT FROM lt table name gt Version and newer natively support materialized views Materialized View vs ViewSo what are the major differences between a view and materialized view and why should you use one over the other The view is a very particular type of virtual table that is created using the command Create View It contains all data obtained from a relevant query expression If you re working with one or even multiple base tables or views you can use this to create a View You can also query your View in the same way you would use one of those base tables The key thing to understand is that a View is always computed every time it is used or accessed in any way Because of this you re always getting the most updated data in any View that you query If you make any type of update to the content in a View it will always be pushed back and updated in the original table Likewise the reverse is also true any changes that are made to the original base table are instantly reflected in the View What this means however is that the performance of a View will always be slower than that of a materialized view The major advantage is that a View doesn t actually require storage space You can also have total control over which users can or cannot view sensitive information within the database itself A materialized view on the other hand is a physical copy of those original base tables Think of it more like a photograph of the original base table The key difference is that a materialized view will not be updated every time it is interacted with If you don t go through the trouble of updating it manually you can do so with the help of certain pre defined triggers The upshot is that a materialized view will always respond faster to a query than a traditional View would but you could also be retrieving stale data if you re not careful Materialized View vs TableThe answer to that question within the context of environments like Oracle or MySQL ultimately comes down to a concept called dynamic query rewriting It s key to understand that a materialized view won t properly define the relationships between data and the original base table It will also allow users to pre compute expensive joins and aggregations as well Likewise the materialized view will also have certain options that can be used to automatically refresh the data being queried Not only will this ultimately improve the ease of maintenance but it will also go a long way towards improving efficiency as well because those changes can be tracked by row To put it another way the materialized view will always be in sync with the real data in the table You don t actually have to go out of your way to do anything because at that point the database will do it for you What to learn nextMaterialized views are a great way to reduce costs during the development of your application especially as it continues to grow Not only will you save wall clock time but you ll increase efficiency and save things like CPU time and memory usage too thus translating into actual monetary savings before you know it But there is more to learn To continue your learning next you should check out these concepts Creating materialized views with Big QueryJoining a materialized viewSuspending updatesUsing shared data with materialized viewsTo get some hands on practice with databases check out Educative s course Database Design Fundamentals for Software Engineers In this course you ll learn about the fundamental concepts of databases You will also be exposed to techniques like normalization that help to increase the efficiency of databases Happy learning Continue reading about databases on EducativeWhat are SQL Joins Types of SQL joins explainedWhat are database schemas minute guide with examples Tips for Query Optimization in SQL Servers Start a discussionWhy do you like using materialized view Was this article helpful Let us know in the comments below	2023-01-26 19:17:24
海外TECH	Engadget	DOJ says it disrupted a major global ransomware group	https://www.engadget.com/hive-ransomware-doj-fbi-disruption-193249866.html?src=rss	DOJ says it disrupted a major global ransomware groupThe US Department of Justice has spent months infiltrating and disrupting the Hive ransomware group the agency announced on Thursday The DOJ says Hive has targeted over victims in more than countries extorting hundreds of millions of dollars in ransom payments Working with German and Netherlands law enforcement the FBI seized Hive s servers and websites allegedly slowing the group s ability to attack and extort new victims It first infiltrated Hive s network in July providing over decryption keys to Hive s current victims and more than keys to previous victims ーpreventing over million in ransom payments The agency hasn t announced any arrests However it s still investigating the group according toNBC News Hive used a ransomware as a service RaaS model where administrators essentially the ringleaders create ransomware strains with easy to use interfaces The administrators then recruit affiliates who use the ransomware software to carry out the theft ーand likely much of the risk For example Hive would steal a victim s data and encrypt their system The affiliate would then demand a ransom in exchange for the decryption key and a promise not to publish the data Of course it would frequently target the most sensitive data to apply maximum pressure If the victims pay affiliates and administrators would split the ransom Those unwilling to pay would find their data leaked on the web MANDEL NGAN via Getty ImagesThe US Cybersecurity and Infrastructure Security Agency CISA says Hive gained access through single factor logins via Remote Desktop VPNs exploiting FortiToken software based access key vulnerabilities and phishing emails with malicious attachments “Last night the Justice Department dismantled an international ransomware network responsible for extorting and attempting to extort hundreds of millions of dollars from victims in the United States and around the world said US Attorney General Merrick Garland today “We will continue to work both to prevent these attacks and to provide support to victims who have been targeted And together with our international partners we will continue to disrupt the criminal networks that deploy these attacks The FBI recommends victims contact their local FBI field office	2023-01-26 19:32:49
海外TECH	Engadget	New York’s flood sensor network will soon expand across the city	https://www.engadget.com/floodnet-new-york-city-flood-sensor-network-expansion-190352651.html?src=rss	New York s flood sensor network will soon expand across the cityNew York City s first flood monitoring network is set to expand Thanks to million in funding from the city the number of flood prone areas FloodNet monitors with its sensors will increase from to across all five boroughs The expansion is expected to start next month and take up to five years Data from the sensors is fed into a free web dashboard that residents city agencies researchers and anyone else can use to stay on top of and react to flood threats The dashboard receives water level readings from the sensors in real time An interactive map shows where when and how rapidly water is rising whether that s due to seawater surges at the coast or stormwater drains not being able to handle floods The dashboard also includes historical data which can help people to track the frequency and severity of floods over time Researchers from New York University The City University of New York Brooklyn College and the Science and Resilience Institute developed FloodNet They had assistance from the mayor s Office of Climate amp Environmental Justice the NYC Office of Technology amp Innovation and neighborhood community groups FloodNet s solar powered sensors are low cost and open source They use ultrasound to measure changes in water levels and wirelessly transfer data to a gateway hub which then sends the information to FloodNet s servers and the dashboard Sea levels in the city have risen by a foot in the last century according to the New York City Panel on Climate Change They re expected to increase by between another eight and inches by around and between and inches by the end of the century More detailed flood data can help city planners and others prepare for permanent water level rises along with weather events like hurricanes that can quickly wreak havoc	2023-01-26 19:03:52
海外科学	NYT > Science	Biden Administration Bans Mining in Boundary Waters Wilderness	https://www.nytimes.com/2023/01/26/climate/mining-ban-boundary-waters-copper.html	Biden Administration Bans Mining in Boundary Waters WildernessA year moratorium on new mining activity for more than acres of federal land in Minnesota could deal a fatal blow to a proposed Twin Metals copper nickel mine	2023-01-26 19:57:25
海外科学	NYT > Science	The Sierra Club Tries to Move Past John Muir, George Floyd and #MeToo	https://www.nytimes.com/2023/01/24/climate/ben-jealous-sierra-club.html	The Sierra Club Tries to Move Past John Muir George Floyd and MeTooAfter a public reckoning and the departure of its executive director the nation s largest environmental organization has tapped Ben Jealous as its new leader	2023-01-26 19:17:33
医療系	医療介護 CBnews	生産性向上、業務効率化に偏れば職員の心を壊す-快筆乱麻！masaが読み解く介護の今（85）	https://www.cbnews.jp/news/entry/20230126202406	介護事業	2023-01-27 05:00:00
ニュース	BBC News - Home	No penalties for 'innocent' tax errors, HMRC boss says	https://www.bbc.co.uk/news/uk-politics-64410490?at_medium=RSS&at_campaign=KARANGA	chairman	2023-01-26 19:07:48
ニュース	BBC News - Home	Egypt archaeology: Gold-covered mummy among latest discoveries	https://www.bbc.co.uk/news/world-middle-east-64415816?at_medium=RSS&at_campaign=KARANGA	discoveriesthe	2023-01-26 19:18:47
ニュース	BBC News - Home	Leeds St James's Hospital: Man charged with planning terror attack	https://www.bbc.co.uk/news/uk-england-leeds-64420363?at_medium=RSS&at_campaign=KARANGA	scare	2023-01-26 19:23:54
ニュース	BBC News - Home	Elle Edwards: Man arrested over Christmas Eve pub shooting	https://www.bbc.co.uk/news/uk-england-merseyside-64419791?at_medium=RSS&at_campaign=KARANGA	christmas	2023-01-26 19:29:52
ニュース	BBC News - Home	Kolo Toure: Wigan Athletic sack boss after no wins from nine games in charge	https://www.bbc.co.uk/sport/football/64361824?at_medium=RSS&at_campaign=KARANGA	toure	2023-01-26 19:48:44
ビジネス	ダイヤモンド・オンライン - 新着記事	農作物「作った分だけ安くなる」を解決！日本一のトマト農家が明かす農業経営の落とし穴【動画】 - カリスマ農家の「儲かる農業」	https://diamond.jp/articles/-/316067	農作物「作った分だけ安くなる」を解決日本一のトマト農家が明かす農業経営の落とし穴【動画】カリスマ農家の「儲かる農業」農業経営における成長の落とし穴、「作っただけ安くなる」を解消するには耕作放棄地からスタートし、トマト生産量日本一にまで成長を遂げた農業法人サラダボウル。	2023-01-27 04:50:00
ビジネス	ダイヤモンド・オンライン - 新着記事	島根銀行が「企業支援のプロ」招聘で大改革、他行が恐れる法人営業変貌 - 橋本卓典の銀行革命	https://diamond.jp/articles/-/316746	企業支援	2023-01-27 04:45:00
ビジネス	ダイヤモンド・オンライン - 新着記事	景気を表す「ドクター・カッパー」年初は堅調、2023年以降の銅価格トレンドは？ - 政策・マーケットラボ	https://diamond.jp/articles/-/316695	騰勢	2023-01-27 04:40:00
ビジネス	ダイヤモンド・オンライン - 新着記事	筑附小・現役国語教師に聞く、子どもが「本好き」になるために親ができること - ニュース3面鏡	https://diamond.jp/articles/-/316509	筑波大学	2023-01-27 04:35:00
ビジネス	ダイヤモンド・オンライン - 新着記事	ドラッグストア「100m以内に乱立」の裏事情、激戦の裏で“淘汰”される業界も - 今週もナナメに考えた　鈴木貴博	https://diamond.jp/articles/-/316745	新大久保	2023-01-27 04:30:00
ビジネス	ダイヤモンド・オンライン - 新着記事	岸田首相が“異次元増税”に挑戦、「日本には増税余地がまだある」論の欺瞞 - ＤＯＬ特別レポート	https://diamond.jp/articles/-/316709	少子化対策	2023-01-27 04:25:00
ビジネス	ダイヤモンド・オンライン - 新着記事	伊藤園「お～いお茶」が400億本売れた裏に俳句あり、ラベルに載せる真の狙い - ヒットの裏側	https://diamond.jp/articles/-/316327	伊藤園「おいお茶」が億本売れた裏に俳句あり、ラベルに載せる真の狙いヒットの裏側伊藤園が年に発売した「おいお茶」は、年月に累計販売本数が億本を突破した。	2023-01-27 04:20:00
ビジネス	ダイヤモンド・オンライン - 新着記事	コロナ「2類相当か5類か」の論争が不毛な訳、思考停止していないか - 上久保誠人のクリティカル・アナリティクス	https://diamond.jp/articles/-/316712	コロナ「類相当か類か」の論争が不毛な訳、思考停止していないか上久保誠人のクリティカル・アナリティクス岸田文雄首相が、新型コロナウイルスの位置付けを「類相当」から「類」に変更する方針を明らかにし、議論を呼んでいる。	2023-01-27 04:10:00
ビジネス	ダイヤモンド・オンライン - 新着記事	頭のいい人は「交渉成功」のためにどんな準備をしているのか - 頭がいい人の交渉術	https://diamond.jp/articles/-/316729	頭のいい人は「交渉成功」のためにどんな準備をしているのか頭がいい人の交渉術書籍『頭のいい人の対人関係誰とでも対等な関係を築く交渉術』の著者が、交渉術について解説する本連載。	2023-01-27 04:05:00
GCP	Google Cloud Platform Japan 公式ブログ	BigQuery ML で多変量時系列予測を行う方法	https://cloud.google.com/blog/ja/products/data-analytics/how-to-do-multivariate-time-series-forecasting-in-bigquery-ml/	まとめ上記の例では、多変量時系列予測モデルを作成し、そのモデルを使用して将来の値を予測し、予測結果を評価する方法を説明しました。	2023-01-26 20:10:00
GCP	Google Cloud Platform Japan 公式ブログ	[インフォグラフィック] 金融サービスのデジタル トランスフォーメンションを安全に推進する	https://cloud.google.com/blog/ja/topics/financial-services/four-phases-of-security-transformation-in-financial-services/	金融サービス機関にとって、クラウドコンピューティングのテクノロジーとサービスを導入することは、さまざまなセキュリティリスクに対応するために革新的かつより効果的な方法を取り入れるチャンスでもあります。	2023-01-26 20:00:00
GCP	Google Cloud Platform Japan 公式ブログ	データサイロを増やすことなくデータ サイエンス ワークロードを実行する	https://cloud.google.com/blog/ja/products/data-analytics/run-data-science-workloads-without-creating-more-data-silos/	組織が複雑でも、データアーキテクチャが複雑である必要はないこのグローバル消費財企業は、データレイクでデータを一元管理しており、アクセスポリシーを使用して各リージョンの財務チームが該当地域に関するデータにのみアクセスできるようにしています。	2023-01-26 19:20:00
ビジネス	東洋経済オンライン	京急1000形､なぜ｢最大勢力｣にまで増えたのか 同じ形式の中にさまざまな"派閥"が存在する | ベテラン車両の肖像 | 東洋経済オンライン	https://toyokeizai.net/articles/-/648506?utm_source=rss&utm_medium=http&utm_campaign=link_back	三浦半島	2023-01-27 04:30:00
GCP	Cloud Blog JA	BigQuery ML で多変量時系列予測を行う方法	https://cloud.google.com/blog/ja/products/data-analytics/how-to-do-multivariate-time-series-forecasting-in-bigquery-ml/	まとめ上記の例では、多変量時系列予測モデルを作成し、そのモデルを使用して将来の値を予測し、予測結果を評価する方法を説明しました。	2023-01-26 20:10:00
GCP	Cloud Blog JA	[インフォグラフィック] 金融サービスのデジタル トランスフォーメンションを安全に推進する	https://cloud.google.com/blog/ja/topics/financial-services/four-phases-of-security-transformation-in-financial-services/	金融サービス機関にとって、クラウドコンピューティングのテクノロジーとサービスを導入することは、さまざまなセキュリティリスクに対応するために革新的かつより効果的な方法を取り入れるチャンスでもあります。	2023-01-26 20:00:00
GCP	Cloud Blog JA	データサイロを増やすことなくデータ サイエンス ワークロードを実行する	https://cloud.google.com/blog/ja/products/data-analytics/run-data-science-workloads-without-creating-more-data-silos/	組織が複雑でも、データアーキテクチャが複雑である必要はないこのグローバル消費財企業は、データレイクでデータを一元管理しており、アクセスポリシーを使用して各リージョンの財務チームが該当地域に関するデータにのみアクセスできるようにしています。	2023-01-26 19:20:00