Limitations of a Managed Cloud Database ServiceWith the advent of cloud computing, several managed services for databases have become available. Whether to use a managed cloud database service from a cloud provider depends on several factors, and it may not be the best choice for everyone. Knowing the limitations can help you decide whether it makes sense for you.
Choosing between MySQL and PostgreSQLMySQL and PostgreSQL are the top two open source relational databases, and they have a lot in common. So how can developers choose between them? The application should guide the features that need to be prioritized. Here’s how the two databases compare with regard to the features that most relational databases support.
When to Use MapReduce with Big DataMapReduce is a programming model for distributed computation on big data sets in parallel. It's a module in the Apache Hadoop open source ecosystem, and a range of queries may be done based on the algorithms available. Here's when it's suitable (and not suitable) to use MapReduce for generating and processing data.
Trusting Your Data: Garbage In, Garbage OutPoor quality input will always produce faulty output. Improper validation of data input can affect more than just security; it can also affect your ability to make effective business decisions. Bad data can have impacts on how you make quantitative decisions or create reports, if you can’t trust the data you receive.
Migrating a Database? Consider These Factors FirstDatabase migration is usually performed with a migration tool or service. Migrating one database to another actually involves migrating the schemas, tables, and data; the software itself is not migrated. Whatever the reason for migration, before you start, explore the options and take these considerations into account.
Before Data Analysis, You Need Data PreparationOne of the prerequisites for any type of analytics in data science is data preparation. Raw data usually has several shortcomings in structure, format, and consistency, so first it has to be converted to a usable form. These are some types of data preparation you can conduct to make your data useful for analysis.
Exploring Big Data Options in the Apache Hadoop EcosystemWith the emergence of the World Wide Web came the need to manage large, web-scale quantities of data, or “big data.” The most notable tool to manage big data has been Apache Hadoop. Let’s explore some of the open source Apache projects in the Hadoop ecosystem, including what they're used for and how they interact.
When to Use Different Types of NoSQL DatabasesWeb-scale data requirements are greater than at a single organization, and data is not always in a structured format. NoSQL databases are a good choice for a larger scale because they're flexible in format, structure, and schema. Let’s explore different kinds of NoSQL databases and when it’s appropriate to use each.
