Create dblink from oracle to memsql
Install required RPM packages Configure ODBC gateway Setup environment variable Configure listener.ora and tnsnames.ora Configure ODBC listener Create database link and test2 Environment: Database DB Name DB Version Host Name OS Version Oracle PCRADMN…
Tutorial Using MongoDB Aggregation Pipeline
Using data to answer interesting questions is what researchers are busy doing in today’s data driven world. Given huge volumes of data, the challenge of processing and analyzing it is a big one; particularly for statisticians or data analysts who…
http://biglogictech.com/ : Hadoop & MongoDB Classes
http://biglogictech.com/training/big-data-analytics/hadoop-architect-hadoop-consultant/ http://biglogictech.com/training/no-sql-databases/mongodb/ Our Popular Training Programs Big Data Expert Enroll Now MongoDB Expert Enroll Now
From MongoDB to Couchbase: How to Make the Switch
From MongoDB to Couchbase: How to Make the Switch Date: Wednesday, 18 November 2015 Time: 3 p.m. GMT In this webinar, I will: Explain the key differences between MongoDB and Couchbase — including the 7 common challenges with MongoDB that Couchbase overcomes…
AWS Aurora – it’s showtime for Amazon’s new RDS engine
AWS Aurora database engine is fully released, it’s time to see how it runs in the real world. For some time, AWS has offered managed relational databases (RDS) for MySQL, SQLServer, Oracle, and Postgres deployments. Now, after some months in…
MariaDB License pricing
MariaDB subscriptions extend MariaDB Server with the enterprise features and expertise necessary to support a database powering mission-critical applications in production, regardless of whether it’s running on premises, in the cloud or both (hybrid cloud). MariaDB Platform can be configured…
SQL Database Performance Tuning for Developers
Database tuning can be an incredibly difficult task, particularly when working with large-scale data where even the most minor change can have a dramatic (positive or negative) impact on performance. In mid-sized and large companies, most SQL database tuning…
How to Tune Microsoft SQL Server for Performance
How to Improve Microsoft SQL Server Performance | Toptal To retain its users, any application or website must run fast. For mission critical environments, a couple of milliseconds delay in getting information might create big problems. As database sizes grow…
Neo4j Cipher via Neo4j-shell
MATCH (a)-[r:ACTED_IN]->(m) RETURN a.name,r.roles, m.title :play movies MATCH (a)-[:ACTED_IN]->(m) RETURN a.name, m.title Number of movies : $match (n:Movie) return count(n) match (n:Movie) return count(n) match (n) return count(n) // Creating Movies CREATE (TheMatrix:Movie {title:’The Matrix’, released:1999, tagline:’Welcome to the Real…