Re:Neo4j nabs $80M Series E as graph database tech flourishes
by weavie on Thursday November 01, 2018 @07:58AM
(#18353083)
Out of curiosity, how would a graph database help when booking a room? I would have thought a simple table:
and some simple sql to check if any rows exist within the required date range would have covered it? What other aspects am I not considering?
[ Parent
| on HN ]
Re:Neo4j nabs $80M Series E as graph database tech flourishes
by emileifrem on Thursday November 01, 2018 @08:15AM
(#18353194)
Oh, there's a bunch of stuff in addition to that. I could give it a shot, but would probably mess it up. :) Way better if you hear it from the horse's mouth. Here's Scott Grimes from Marriott at GraphConnect 2016:
https://www.youtube.com/watch?v=wdFYEuWWpzo
Pretty amazing stats in there!
Re:Neo4j nabs $80M Series E as graph database tech flourishes
by weavie on Thursday November 01, 2018 @10:12AM
(#18354020)
Thanks, I'll have a watch when I get the time.
Re:Neo4j nabs $80M Series E as graph database tech flourishes
by jeletonskelly on Thursday November 01, 2018 @08:15AM
(#18353195)
I used to work at an OTA (online travel agency, ie Booking.com, Hotels.com). There's all kinds of complications to what seems to be a pretty simple thing: a building with rooms that are either occupied or not. There's multiple rates per room for a single night, then there's something called room rate plans which I won't get into. In other words: it's more complicated that we think (or than it needs to be).
Re:Neo4j nabs $80M Series E as graph database tech flourishes
by segmondy on Thursday November 01, 2018 @09:49AM
(#18353829)
This type of things is based solved with Prolog. The issue is that folks are trying to solve declarative problems using procedural/object oriented/functional programming. Because we store data in databases, we have twisted it into a database problem but it's not.
book(Room, Rate):-
availableBuildings(Buildings),
availableRooms(Buildings, Rooms),
rate_less_than(Rate, Rooms)
cheapest(Rooms, Room).
However complex you think this problem is, it's pretty simple. It's a very old problem, scheduling, well understood and solved. Using the wrong tool makes it a nightmare. Using the right tool makes it ridiculously easy. The solution is not the database, but the language.
Re:Neo4j nabs $80M Series E as graph database tech flourishes
by mfrager on Thursday November 01, 2018 @11:14AM
(#18354686)
Very interesting... my inclination is that you’re probably right. Any tips on how to learn to use Prolog with pulling data from external sources?
Re:Neo4j nabs $80M Series E as graph database tech flourishes
by segmondy on Thursday November 01, 2018 @12:07PM
(#18355375)
Prolog's DB is just a text file. You can construct a DB file by using SQL to select into a text file.
You can use ODBC http://www.swi-prolog.org/pldoc/doc_for?object=section(%27pa...
You can use CSV http://www.swi-prolog.org/pldoc/man?section=csv
I've used the above methods.
For RDF, you can load with various methods even over http http://www.swi-prolog.org/pldoc/man?section=rdflib
Re:Neo4j nabs $80M Series E as graph database tech flourishes
by e12e on Saturday November 03, 2018 @07:48AM
(#18369767)
I too would like to hear about getting facts from an sql db, and writing back results from prolog - it's hard to see how a prolog text file can/could be used as a source for transactional problems like booking (making sure the answer you find can be committed while still valid).
I suppose one could have a prolog service that came up with suggestions, ordered by preference, and then attempt committing them in order to the actual transactional storage layer. But I don't see how you could avoid re-implementing transactions.
With an rdms you could look for options, and attempt a booking in a transaction, and have a fairly established way to resolve conflicts.