Category: MongoDB

Feed: Cloud Data Transformation Software | Matillion. Author: Laura Malins, ETL Product Manager; Laura Malins, ETL Product ManagerA customer came to us who had lots of data in a MongoDB with many nested elements. Including both arrays and structs. Their previous workflow was to load this data into an Amazon Redshift table. The MongoDB component within Matillion ETL for Amazon Redshift would then flatten the top-level objects, but this still left many nested arrays. Therefore, a Transformation job was used to flatten the remaining arrays and JSON structures by cross joining to a sequencer table to catch each array element ... Read More

Feed: DivvyCloud. Author: David Mundy; < Back to Resource Library Wired broke the story last week that security researchers discovered Verifications.io’s (an email validation firm) unprotected, publicly accessible MongoDB database containing 150 gigabytes-worth of detailed, plaintext marketing data—including 763 million unique email addresses. The trove, as Wired reported, is not only massive but also unusual; it contained data about individual consumers as well as suspected “business intelligence data,” like employee and revenue figures from various organizations.DivvyCloud’s Chris DeRamus (CTO) explains this recent leak in more depth “The data exposed in this leak of nearly 809 million records is unique, and ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy. “Apps without search is like Google homepage without the search bar.” It’s hard to design an app without a good search.  These days, it’s also hard to find a database without a built-in search. MySQL to NoSQL, Sybase to Couchbase, every database has text search support — built-in like Couchbase or via integration to Elastic — as is the case in Cassandra. Unlike SQL, text search functionality isn’t standardized. Every application needs best of the breed search, but not every database provides the same text search functionality. It’s important to understand the available feature, ... Read More

Feed: Planet NoSQL. Author: Keshav Murthy. As an application architect, eventually, you’d to choose the database or database service to power your newest application or a micro-service. Selecting one of the databases among relational databases was easier.  The use cases were roughly divided into OLTP and OLAP (decision support). The workload differences between OLTP and OLAP were well known. OLTP workloads consist of short transactions on few random rows, expecting millisecond responses on pre-compiled queries; OLAP workloads consist of data loads, long-running queries scanning millions of rows of a fact table of a star/snowflake schema. Each had the performance benchmark ... Read More

Feed: Blog. Author: Rick F. van der Lans; It can’t have escaped your attention that, in recent years, numerous new database platforms have been introduced on the market. Products such as Amazon Redshift, Apache Cassandra, Google BigQuery, and MongoDB are all new database products developed to support massive query workloads, complex analytical queries, high-end transactional workloads, and big data ingestion rates. Some of them have been designed to benefit from cloud-based hardware architectures and others have been optimized to use the massive parallelization power of GPUs.To be able to exploit one of these new database servers, migration is necessary. But ... Read More

Feed: Severalnines. In the past four posts of the blog series, we covered deployment of clustering/replication (MySQL/Galera, MySQL Replication, MongoDB & PostgreSQL), management & monitoring of your existing databases and clusters, performance monitoring and health and in the last post, how to make your setup highly available through HAProxy and MaxScale.So now that you have your databases up and running and highly available, how do you ensure that you have backups of your data? You can use backups for multiple things: disaster recovery, to provide production data to test against development or even to provision a slave node. This last ... Read More

Feed: Puppet Blog Feed. Author: Ben Ford; Each year the Puppet community puts our collective heads together and selects some outstanding community members to recognize, and this year was no different. We had a lot of really great nominees and a few clear leaders. I'm sure that none of you will be surprised by who we selected. This year it seems that the focus was on some of the non-technical parts of being a good community member, like encouraging others or building a welcoming environment. Each of our winners embodies that ethos and is a real positive presence to have.The ... Read More

Feed: Blog. Author: dailybusinessstudy; Many database professionals have historically worked with traditional relational database management systems (DBMS) such as Microsoft SQL Server, DB2, Sybase, and Oracle which use the Structured Query Language (SQL) language. In fact, relational databases and SQL have been around for over 30 years now. They are well entrenched and will be around for many years to come. However, over roughly the most recent decade there have been numerous developments in the database market.  You most likely have wondered about NoSQL and big data. You also probably have heard of names such a MongoDB, Neo4j, Cassandra, and ... Read More

Feed: The Connector by Workato. Author: Hannah Herman; Last year, Gartner announced it would no longer evaluate enterprise content management (ECM) vendors in a Magic Quadrant. Instead, it has shifted its focus to content services. In light of this announcement, many tech pundits have concurred with Gartner: enterprise content management is officially dead. Like any headline, however, this proclamation inspires the question: is it really? The truth is that businesses still produce a huge amount of content every day. So they also still need to manage that content—even if the way they do so is changing. A key goal of ... Read More

Feed: Blog. Author: Bert Scalzo; Many database professionals have historically worked with traditional relational database management systems (DBMS) such as Microsoft SQL Server, DB2, Sybase, and Oracle which use the Structured Query Language (SQL) language. In fact, relational databases and SQL have been around for over 30 years now. They are well entrenched and will be around for many years to come. However, over roughly the most recent decade there have been numerous developments in the database market.  You most likely have wondered about NoSQL and big data. You also probably have heard of names such a MongoDB, Neo4j, Cassandra, ... Read More