Tag: constraints

Feed: Planet MySQL; Author: MySQL Performance Blog; Borys Belinsky and Dmitriy Kostiuk  | April 20, 2018 |  Posted In: Amazon RDS, AWS, Database Monitoring, Events and Announcements, MongoDB, MySQL, Percona Monitoring and Management, Percona Server for MongoDB, Percona Server for MySQL, PMM PREVIOUS POST Percona Monitoring and Management (PMM) is a free and open-source platform for managing and monitoring MySQL® and MongoDB® performance. You can run PMM in your own environment for maximum security and reliability. It provides thorough time-based analysis for MySQL® and MongoDB® servers to ensure that your data works as efficiently as possible. We focused mainly on two features in 1.10.0, but there are also several notable improvements worth highlighting: ... Read More

Feed: Neo4j Graph Database Platform. Author: Bryce Merkl Sasaki. By Joe Depeau, Senior Pre-Sales Consultant, Neo4j | April 19, 2018  A great graph database use case that is starting to emerge is the use of graph technology as a way to better support the police and other law enforcement officials, which also has applications for other security and investigative use cases like anti-terrorism, border control, and social services.The main way practitioners are doing this is leveraging the POLE (Person, Object, Location, Event) data model for working with crime data.It turns out that the POLE data model is a great fit ... Read More

Feed: AWS Government, Education, & Nonprofits Blog. Author: publicsector. The Urban Institute is a Washington, D.C.-based policy research organization dedicated to developing evidence-based insights that improve decision making, strengthen communities, and make people’s lives better.As a leader in data-driven policy research, the Urban Institute was looking for a solution that would enable it to run sophisticated data analytics and microsimulation models with flexibility, speed, and accuracy. The organization was running complex, data-driven microsimulations developed over years, and wanted to evolve its processing platform while retaining select legacy code. They also hoped to improve information sharing, lower costs for storage and ... Read More

Feed: Planet PostgreSQL. Table of Contents On the last few years, PostgreSQL received several enhancements to process high-volume databases. This first post will try to list them. We will see that they can be splitted in different kinds: Parallelism Improvement of query processing Partitioning Access methods Maintenance tasks SQL features In order to maintain clarity, the explanation of each feature will remain brief. Note: this article was written during the development phase of version 11. I integrated new features of version 11. As long as it is not released, these features might be removed. I thank Guillaume Lelarge for his ... Read More

Feed: Planet PostgreSQL. Today, we’re going to begin a dive into the PostgreSQL Data Types. As my colleague Will Leinweber said recently in his talk Constraints: a Developer’s Secret Weapon that he gave at pgDay Paris: database constraints in Postgres are the last line of defense. The most important of those constraints is the data type, or the attribute domain in normalization slang. By declaring an attribute to be of a certain data type, then PostgreSQL ensures that this property is always true, and then implements advanced processing features for each data type, so that you may push the computation ... Read More

Feed: Hortonworks Blog – Hortonworks. Author: Wangda Tan. The Apache Hadoop community just announced the release of Apache Hadoop 3.1.0! This is the next big milestone in the Apache Hadoop 3.x line, the first one being the 3.0.0 release back in December 2017. It’s a significant release for many readers of this blog who are on the Apache Hadoop 2.x series. Important notes from the announcement: This release is *not* yet ready for production use. Critical issues are being ironed out via testing and downstream adoption. Production users should wait for a 3.1.1/3.1.2 release. The Hadoop community fixed 768 JIRAs ... Read More

Feed: Google Cloud Platform Blog. Author: GCP Team. By Brian Granatir, SmartCloud Engineering Team Lead, Smart Parking Part 3  You made it through all the fluff and huff! Welcome to the main event. Time for us to explore some key concepts in depth. Of course, we won't have time to cover everything. If you have any further questions, or recommendations for a follow-up (or a prequel . . . who does a prequel to a tech blog?), please don't hesitate to email me. "Indexing" in Google Cloud Bigtable In parts one & two, we mentioned Cloud Bigtable a lot. It's ... Read More

Author: . NuoDB Administrative Improvements There’s a new Sheriff coming to town… In the days of covered wagons and the open trail, the small towns in the west (you know the ones) with a single dirt main street lined on each side with storefronts, wooden boardwalks and horses tied to a rail, … they all had one thing in common -- a Sheriff in charge. And if there was anything important going on, or a decision was to be made, it involved the Sheriff. In NuoDB, a distributed SQL database that runs on-prem, in the cloud, or in containers, the ... Read More

Feed: James Serra's Blog. Author: James Serra. I often hear people say moving to the cloud does not save money, but frequently they don’t take into account the savings for indirect costs that are hard to measure (or the benefits you get that are simply not cost-related).  For example, the cloud allows you to get started in building a solution in a matter of minutes while starting a solution on-prem can take weeks or even months.  How do you put a monetary figure on that?  Or these other benefits that are difficult to put a dollar figure on: Unlimited storage ... Read More

Feed: All - O'Reilly Media. Author: Jesse Anderson. The two positions are not interchangeable—and misperceptions of their roles can hurt teams and compromise productivity.It’s important to understand the differences between a data engineer and a data scientist. Misunderstanding or not knowing these differences are making teams fail or underperform with big data. A key misunderstanding is the strengths and weaknesses of each position. I think some of these misconceptions come from the diagrams that are used to describe data scientists and data engineers. Figure 1. Overly simplistic venn diagram with data scientists and data engineers. Illustration by Jesse Anderson.Venn diagrams ... Read More