All geek questions in one place

The best database for computing tasks

I am trying to decide which database system to use to store information that is relatively static, but it needs to be calculated in several different (timed) ways. The main data circuits are the votes in the US Congress:

Score:

  • has many call forwarding calls.
  • has a name and other short metadata
  • has text and other potentially long metadata
  • has status (passed, failed, in process)

Recall:

  • has a date
  • has a lot of votes.
  • has status (passed, failed)

Voting:

  • owned by a member of Congress
  • has the form (yes, no, present, did not vote)

Member of Congress:

  • has a name (and other short metadata)
  • has many periods

Period:

  • has a start and end date
  • (, , )
  • ( , , ..).

, :

  • X, Y Z, "" "" . , , .
  • X, , . , .
  • X , , , .

, , , , ..

, ?

+3
5

. (MySQL, SqlServer, postgres ..).

, ?

+4

, :

... ...

MySQL . Postgres, Oracle SQL Server (Oracle 9i +, SQL Server 2005+). .

+3

? . .

+2

, . :

  • , , - - , sql, parallelism, , ...
  • , ( ), . , .
  • , postgresql .
+1

, , CouchDB - NOSQL . , , . , , a la mapreduce.

, , ( :)), , CouchDB. , , , () .

(json CouchDB), rollcalls/vote/congress -/ .. "bill". "", . , , .

/, mapreduce . , , rdbms. , .

0

Source: https://habr.com/ru/post/1727191/

More articles:


All Articles