Database

Partitioning in Database

Reading Time: 3 minutes To speed up the query processing, we need to efficiently manage data. And partitioning the database is considered as one of the ways to enhance the processing speed. Using Partitioning, we can divide the data based on some value/field, so that data belonging to different groups are identified easily(may be stored on different nodes), and therefore processing a query won’t require a Full Table Scan, Continue Reading

SQL made easy and secure with Slick

Reading Time: 5 minutes Slick stands for Scala Language-Integrated Connection Kit. It is Functional Relational Mapping (FRM) library for Scala that makes it easy to work with relational databases. Slick can be considered as a replacement of writing SQL queries as Strings with a nicer API for handling connections, fetching results and using a query language, which is integrated more nicely into Scala. You can write your database queries Continue Reading

An Introduction to CockroachDB !!!

Reading Time: 3 minutes Hello Folks, Today we are going to discuss about the Resilient SQL Database. As we know database is a main part for any organization or business.  We say that we have many databases in the present, developers are left with a small range of options: Traditional RDBMS: Traditional Database is known for the Transaction, Consistency and indexes, but are not scalable and fault-tolerant. As you Continue Reading

Cassandra Database : The Next Big Thing

Reading Time: 3 minutes Apache Cassandra, a top level Apache project born at Facebook , is a distributed database for managing large amounts of structured data across many commodity servers, while providing highly available service and no single point of failure. BASIC FLOW OF DATA INTO CASSANDRA TABLES Installation In a terminal window: 1. Check which version of Java is installed by running the following command: $ java -version It is Continue Reading

Installing and Running Presto

Reading Time: 4 minutes Hi Folks ! In my previous blog, I had talked about Getting Introduced with Presto. In today’s blog, I shall be talking about setting up(installing) and running presto. The basic pre-requisites for setting up Presto are: Linux or Mac OS X Java 8, 64-bit Python 2.4+ Installation Download the Presto Tarball from here Unpack the Tarball After unpacking you will see a directory presto-server-0.175 which Continue Reading

presto server using JDBC

Connecting To Presto server using JDBC

Reading Time: 2 minutes Hi Guys, In this blog we’ll be discussing about how to make a connection to presto server using JDBC, but before we get started let’s discuss what Presto is. What is Presto ? So, Presto is an open source distributed SQL query engine for running interactive analytic queries against different data sources. The sizes may ranges from gigabytes to petabytes. It runs on a cluster Continue Reading

Introduction to database migrations using Flyway

Reading Time: 3 minutes Let us first understand why are database migrations necessary? Assume that we have a project called Shiny and it’s primary deliverable is a piece of software called Shiny Soft that connects to a database called Shiny DB. We not only have to deal with one copy of our environment, but with several. So the simplest view of our problem will translate to:

Hive-Metastore : A Basic Introduction

Reading Time: 3 minutes As we know database is the most important and powerful part for any organisation. It is the collection of Schema, Tables, Relationships, Queries and Views. It is an organized collection of data. But can you ever think about these question – How does database manage all the tables? How does database manage all the relationship? How do we perform all operations so easy? Is there Continue Reading

Neo4j with Scala : User Defined Procedure and APOC

Reading Time: 5 minutes In the last blog Getting Started Neo4j with Scala : An Introduction which got the overwhelming response from Neo4j and Dzone. We discussed about how to use Neo4j with Scala. For recap Blog and the Code. Now we are going to take one step ahead . As we know that in the Relational Database, Procedure provide advantages of better performance, scalability, productivity, ease of use Continue Reading

Getting Started Neo4j with Scala : An Introduction

Reading Time: 3 minutes Earlier we used Relational Database for storing the data but there we store data in predefined table and than we define foreign key for references between tables or rows. We are using this in present time also. Now when we talk about the graph database, we stored data in the nodes. Graph database provides us flexibility to arrange data in easy way. When we transform Continue Reading

Testability of Database Applications

Reading Time: 2 minutes Testability Testability is a non-functional requirement important to the testing team members and the users who are involved in user acceptance testing. Testability is mainly depends on the degree on which software team works like SRS (software requirement specification) FRD (Functional Design document) Software system, etc. Support testing for the software application under test. Minimum number of test cases that covers the entire testing scope Continue Reading

Couchbase : How to access and change the document of size more than 2.5Kb.

Reading Time: < 1 minute We faced a situation were we have to firstly see the data and then change it accordingly in couchbase, but the GUI of couchbase doesn’t allows us to see the data of size more than 2.5kb and forget about changing, So there is a quick hack of how you can actually change the data without using the GUI and just by making a curl request: Continue Reading