Tag: Database

Feed: Planet MySQL; Author: Oracle MySQL Group; Oracle Live. On Wednesday, December 2, the world’s most popular open source database takes a leap forward in the cloud. Edward Screven, Oracle’s chief corporate architect, will share MySQL innovation that enables you to reduce cost and complexity while accelerating business insights.  We have really exciting news for MySQL users, including some amazing testimonials from early adopters who will share their experiences. And, yes of course, there will be benchmarks! Join us on this very special day in the history of MySQL. Watch the live event, and following the announcement, join us for a ... Read More

Feed: Planet MySQL; Author: Michael McLaughlin; -- Use sakila database. USE sakila;   -- Add a prequel_id column to the sakila.film table. ALTER TABLE film ADD (series_name varchar(20)), ADD (series_number int unsigned), ADD (prequel_id int unsigned);   -- ALTER TABLE film   -- Set primary to foreign key local variable. SET @sv_film_id = 0;   -- Insert Harry Potter films in sakila.film table with classic values clause. INSERT INTO film ( title , description , release_year , language_id , original_language_id , rental_duration , rental_rate , length , replacement_cost , rating , special_features , last_update , series_name , series_number , prequel_id ... Read More

Feed: R-bloggers. Author: Econometrics and Free Software. Some weeks ago I tweeted this: GUIs were a mistake — Bruno Rodrigues (@brodriguesco) October 9, 2020 you might think that I tweeted this as an unfunny joke, but it’s not. GUIs were one of the worstthings to happen for statisticians. Clickable interfaces for data analysis is probably one of thegreatest source of mistakes and errors in data processing, very likely costing many millions tocompanies worldwide and is a source of constant embarassment when mistakes happen which cost thereputation, and money, of institutions or people. Remember the infamous Excel mistake by Reinhard and ... Read More

Feed: Planet PostgreSQL. pgBackRest is a well-known powerful backup and restore tool. It offers a lot of possibilities. In this post, we’ll see how to setup a dedicated repository host to backup a PostgreSQL 3-nodes cluster. The repository host will be called backup-srv and the 3 PostgreSQL nodes in Streaming Replication: pg1-srv, pg2-srv, pg3-srv. All the nodes will be running on CentOS 7. If you’re familiar with Vagrant, here’s a simple Vagrantfile to initiate 4 virtual machines using those names: # Vagrantfile Vagrant.configure(2) do |config| config.vm.box = 'centos/7' config.vm.provider 'libvirt' do |lv| lv.cpus = 1 lv.memory = 1024 end nodes ... Read More

Feed: Planet PostgreSQL. Well, we've already discussed isolation and made a digression regarding the low-level data structure. And we've finally reached the most fascinating thing, that is, row versions (tuples).Tuple headerAs already mentioned, several versions of each row can be simultaneously available in the database. And we need to somehow distinguish one version from another one. To this end, each version is labeled with its effective "time" (xmin) and expiration "time" (xmax). Quotation marks denote that a special incrementing counter is used rather than the time itself. And this counter is the transaction identifier.(As usual, in reality this is more ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Yusuf Ali. By Yusuf Ali, Solution Architect & Delivery Lead – FujitsuBy Rob Evans, Application Transformation Product Manager – FujitsuBy Eric Payeur, Director – Head of Application Modernization, Mainframe Migration – FujitsuBy Serge Moro and Addy Dubhashi – AWS In the last two decades, the financial services market has been undergoing significant transformation driven by the competition of new market entrants, customer demand, and regulation. This transformation is powered by new technology, including cloud services. Furthermore, COVID-19 has brought severe disruption to traditional operations and raised the need of accelerated digital engagement and ... Read More

Feed: AWS Public Sector Blog. Author: Subash D'Souza. Modern data engineering covers several key components of building a modern data lake. Most databases and data warehouses, to an extent, do not lend themselves well to a DevOps model. DataOps grew out of frustrations trying to build a scalable, reusable data pipeline in an automated fashion. DataOps was founded on applying DevOps principles on top of data lakes to help build automated solutions in a more agile manner. With DataOps, users apply principles of data processing on the data lake to curate and collect the transformed data for downstream processing. One ... Read More

Feed: AWS Partner Network (APN) Blog. Author: Derek Belt. This year, AWS re:Invent 2020 is being held as a free, three-week virtual conference. All of us at Amazon Web Services (AWS) are excited to connect with AWS Partners from around the globe. To help you prepare, we’ve rounded up a number of things to check out (virtually, of course). Global Partner Summit Please join us for the annual Global Partner Summit (GPS) at AWS re:Invent 2020. Global Partner Summit offers content and activities designed specifically for AWS Partners and prospective partners alike. Throughout GSP, partners will learn how to leverage ... Read More

Feed: Planet MySQL; Author: Severalnines; Whenever application security is mentioned, people think of securing applications against some of the most frequent attacks such as injection, broken authentication, sensitive data exposure, and the like. However, while these attacks are prevalent, knowing how to protect your application from them alone will not be sufficient - especially when you’re running MySQL. Today we are going to look at a different side of security - we are going to look into how to properly secure MySQL. As MySQL security is a pretty big thing, treat this post as the start of a series of ... Read More

Feed: R-bloggers. Author: Marcel Austenfeld. [This article was first published on R – Bio7, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here) Want to share your content on R-bloggers? click here if you have a blog, or here if you don't. 20.11.2020 A new version of Bio7 is available. This update comes with a plethora of new features, improvements and bugfixes. Bio7 3.2 Dark theme enabled using the spatstat package examples and plots. For those who don’t know Bio7. The application Bio7 is an integrated development environment for ecological modeling, scientific image ... Read More