- Home
- Tag: Page
Posts tagged Page
Page – The basic unit of database file input/output. Database files may be organized into a set of fixed-sized pages containing data associated with one or more record occurrences (table rows).
Tag: Page
MySQL: Page compression revisited

Feed: Planet MySQL; Author: Kristian Köhntopp; Like I said, I never had much reason to use table compression, and only recently looked into the topic. MySQL Page Compression looks a lot easier at the database end of things, but relies on hole punching support in the file system. Let’s have a look at what that means. The original Unix filesystem saw the disk as a sea of blocks, which were represented in a free map as an array of bits. Files have numbers, which are an index into an array of so-called inode structures. Inodes store the files metadata and ... Read More
How to create a data leadership committee and get everyone on the same page
Feed: What's New. Author: Forbes BrandVoice. Editor's note: This article originally appeared in Forbes. Before we get started, why do I even need one? It’s now rare to find an executive who doesn't want their organization to be more data driven. Becoming a data-leading company requires not only data and analytics but also a data culture—a way of working that puts data at the heart of every decision. In companies with a data culture, everyone, regardless of their role, can find insights to improve the business. At many organizations, these cultures begin to take root upon the formation of a ... Read More
Andreas ‘ads’ Scherbaum: Dave Page
Feed: Planet PostgreSQL. Date: 03.05.2021 Tags: postgresql edb pgadmin core Category: Interviews Interviewed by: Andreas Scherbaum PostgreSQL is the World’s most advanced Open Source Relational Database. The interview series “PostgreSQL Person of the Week” presents the people who make the project what it is today. Read all interviews here. Please tell us about yourself, and where you are from. I’m Dave Page, also known as pgSnake on IRC, Twitter and so on. I grew up and continue to live near Oxford in the UK. I’ve been working on PostgreSQL for over 20 years, ... Read More
Dave Page: Regression Analysis in PostgreSQL with Tensorflow: Part 3 – Data Analysis
Feed: Planet PostgreSQL. In part 1 of this blog mini-series we looked at how to setup PostgreSQL so that we can perform regression analysis on our data using TensorFlow from within the database server using the pl/python3 procedural language. In part 2 we looked at how to understand and pre-process the data prior to training a neural network. In this third and find part, we'll use the data that we've prepared and optimised to train a network and then use it to analyse data - all from within a PostgreSQL database! Splitting the Data When we finished the last part of ... Read More
AWS Cost Categories introduces a details page
Feed: Recent Announcements. AWS Cost Categories is a feature within the AWS Cost Management product suite that enables you to group your cost and usage information into meaningful categories for your organization’s unique needs. You can define rules to categorize your costs using dimensions such as accounts, tags, services, charge types, and even other Cost Categories. Once Cost Categories are set up, you can use them across various products in the AWS Billing and Cost Management console. This includes AWS Cost Explorer, AWS Budgets, AWS Cost and Usage Reports (AWS CUR), and AWS Cost Anomaly Detection. Through a new details ... Read More
Data Dictionary vs. Business Glossary (and How They Can Get Your Business and IT Teams on the Same Page)

Feed: Alation. Author: Jason Lim. Alation, business glossary, data catalog, data dictionary, enterprise data catalog April 26, 2021 — In your organization, are you ever confused by different definitions of business terms? Do you ever wonder why the number of customers differs between two reports? I’m going to assume the answer is “yes.” And you are not alone. As an organization evolves, it’s natural for the language to evolve, too. That’s why it’s critical that important terms be defined, documented, and made visible to everyone. This aligns understanding, so that, for example, a term like “customer” means the same thing ... Read More
Dave Page: Regression Analysis in PostgreSQL with Tensorflow: Part 2 – Data Pre-processing
Feed: Planet PostgreSQL. In part 1 of this blog mini-series on machine learning, we looked at how to setup PostgreSQL so that we can perform regression analysis on our data using TensorFlow from within the database server using the pl/python3 procedural language. We also looked at some of the basics of pl/python3 as a primer for what is to come in this and part 3 of the series.In this part, we'll look into data pre-processing. In order to ensure that our regression analysis is as accurate as possible, we first need to analyse and understand the raw data. We can use ... Read More
Generating random lists of names with errors to explore fuzzy word matching
Feed: R-bloggers. Author: Keith Goldfeld. [This article was first published on ouR data generation, 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. Health data systems are not always perfect. This was made painfully obvious when a study I am involved with required a matched list of nursing home residents taken from one system with set results from PCR tests for COVID-19 drawn from another. Name spellings for the same person from the second ... Read More
New digital rewards and racer profile personalization features on the AWS DeepRacer console
Feed: Recent Announcements. AWS DeepRacer is the fastest way to get rolling with machine learning, giving developers the chance to learn ML hands-on with a 1/18th scale autonomous car, 3D virtual racing simulator, and the world’s largest global autonomous car racing league. With the 2021 AWS DeepRacer League Virtual Circuit now underway, developers have five times more opportunities to win physical prizes, such as exclusive AWS DeepRacer merchandise, AWS DeepRacer Evo devices, and even an expenses paid trip to AWS re:Invent 2021 to compete in the AWS DeepRacer Championship Cup. To make ML more fun and accessible to every developer, ... Read More
Replay the Execution of MySQL With RR (Record and Replay)

Feed: Planet MySQL; Author: Marcelo Altmann; Chasing bugs can be a tedious task, and multi-threaded software doesn’t make it any easier. Threads will be scheduled at different times, instructions will not have deterministic results, and in order for one to reproduce a particular issue, it might require the exact same threads, doing the exact same work, at the exact same time. As you can imagine, this is not straightforward. Let’s say your database is crashing or even having a transient stall. By the time you get to it, the crash has happened and you are stuck restoring service quickly and ... Read More
Recent Comments