Advertisements

Archive

Archive for the ‘NoSQL’ Category

Neo4j Date Functions

February 5, 2019 Leave a comment

BI BigData Readers,

Please accept my apologies for writing a new post after a long time. Lately busy with a lot of other technology-related and upgrades.

Lately working with Neo4j Graph DB to implement Customer Journey Analytics using event-based data. While implementing customer journey analytics, handled different scenarios with Neo4j dates and timestamps. This article I’ll be showcasing a couple of examples to play with dates.

By the way following Cypher code snippets from Neo4j 3.4.9. Neo4j APOC Library is really strong and most of the help available there itself. Below code samples are using some important functions from APOC. You can still play with Temporal dates

Listing some useful Cypher statements to play with date functions including date difference for your reference.


// get system timestamp in epoch format you can use following Cypher statement
RETURN timestamp();
RETURN apoc.date.currentTimestamp();

//get epoch value from date
RETURN datetime('2019-02-04').epochMillis;

//system datetime
RETURN apoc.date.format(timestamp());
RETURN apoc.date.format(timestamp(),'ms', 'yyyy-MM-dd hh-mm-ss');

//system datetime converted to Central timezone
RETURN apoc.date.format(timestamp(),'ms', 'yyyy-MM-dd hh-mm-ss','America/Chicago');

//only system date
RETURN date(apoc.date.format(timestamp(),'ms', 'yyyy-MM-dd'));

//convert Neo4j date to Central timezone
RETURN date(apoc.date.format(timestamp(),'ms', 'yyyy-MM-dd',’America/Chicago’));

//get date difference between two dates.
RETURN duration.inDays(date('2018-01-01'), date(apoc.date.format(timestamp(),'ms', 'yyyy-MM-dd',"America/Chicago"))).days;

Hope this helps.

Happy Graphing..!!!
Sandip Shinde

Advertisements

Streaming Twitter Data to MongoDB Real-time

December 16, 2013 7 comments

Lot of Developers/Applications which perform Analytics are pulling data from lot of Social Media Sources Like Facebook, Twitter, Blogs, News Channels like ReadIt.  99% of Social Media Data is not free but it’s mostly available for Developers to POC and Development purpose. This Article I will explain how you can we Stream Data from Twitters Real-time as Twitter offers only 1% of actual their activity stream data for free of cost. Read more…

NoSql vs Relational Database

February 11, 2013 1 comment

In my last article I tried to explain NoSQL Do’s and Don’ts. Now it’s time to summarize the criteria that would represent an endorsement for either NoSQL or relational databases. And these criteria are going to break down into a few different areas like financial, issues of demand or load on the system, and the type of work, the workload that the system needs to take on. Read more…

NoSQL Do’s and Don’ts

February 5, 2013 2 comments

In this article I’ll be explaining about Do’s and Don’ts about NoSQL. Essentially I will be talking about the set of circumstances, the scenarios where NoSQL Database makes the most sense and the scenarios where it really doesn’t make a lot of sense and where relational databases would in fact be more appropriate. By sketching out the different scenarios for the different types of databases, you’ll then be in a good position to understand, based on whether your requirement is exposed to one set of scenarios, the other set or both, whether NoSQL databases are appropriate for your organization and for your requirements. Read more…

Social Media and Sentiment Analysis

January 23, 2013 1 comment

Recently sentiment analysis has gained much attention and interest to huge proportions which is also being fuelled by the many social media platforms mushrooming each day. And sometimes we actually do not understand how this is going to help? But before this we need to understand what sentiment analysis is and how it really works? Read more…

What is Graph Databases?

January 14, 2013 Leave a comment

This is last item is NoSQL Categories Breakdown series, in this article I will explain about Graph Databases which is one of the subcategory in NoSQL databases. Specialty of Graph Databases is they work really great for tracking relationships and that’s why this category is great fit for social network applications or just about anything where relationships are playing really important roles. And relationships can be thought of in an expansive way because you know how relationships costs in RDBMS. In Graph Database one relationship is about ownership or control and with we can pretty much represent just any data from that database. Read more…

What is Wide Column Stores?

January 13, 2013 1 comment

As mentioned in my earlier article for Key-Value Stores, wide column stores have tables which contains columns. The small difference is that Wide Column Stores takes a hybrid approach mixing the declarative characteristics game of relational databases with the key-value pair based and totally variables schema of key-value stores. Wide Column databases stores data tables as sections of columns of data rather than as rows of data. Read more…

%d bloggers like this: