Category: MongoDB

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

Feed: Blog. Author: Ron Huizenga; We are pleased to announce the general availability (GA) of IDERA ER/Studio 17.1ER/Studio 17.1 contains improvements and enhancements in a number of areas within the product suite: Data Architect: SQL Server 2017 has been added as a new platform version, allowing customers to differentiate between SQL Server 2017 physical models (forward & reverse engineering) and earlier versions. MongoDB 3.2, 3.4, 3.6 have been added as new platform versions, giving customers the ability to work with newer MongoDB versions.  MongoDB have now dropped support for all earlier versions prior to 3.2, since 3.2 and later use ... Read More

Feed: Blog. Author: aniltexascowboy; Howdy!Introduction: In this blog post, we will show you how easy it is to connect to MySQL and PostgreSQL via ODBC. As you are aware we can reverse engineer databases natively with  SQL Server  Oracle Hive Sybase ASE Azure SQLDB and MongoDB However, there are still databases out there that need to be reverse engineered. Why do you need to reverse Engineer MySQL / PostgreSQL? Ability to gather the database design Remodel the database Push the changes back to the database What you will need ER/Studio Data Architect - Any edition MySQL and PostgreSQL ODBC Drivers ... Read More