Hi All,
I am new bee to NOSQL database. I am an oracle core dba.
Somewhat difficult to understand KEY-VALUE concept in NOSQL.
In Rdbms,Table looks like below
CREATE TABLE Test.departments
( department_id number NOT NULL,
department_name varchar2(50) NOT NULL,
department_head varchar2(50) NOT NULL,
CONSTRAINT departments_pk PRIMARY KEY (department_id) );
Department is primary key of the table and unique. Test is schema or user. It is stored in data file physically.( Logically tablespace->segment -> extents - > Oracle blocks - > OS Blocks ).Index also created for department_id and stored in same tablespace / another tablespace.
In NOSQL, Schema less database and no relation between tables.
1,How the table( Departments )stores in physically.? ie Which one is Key and which one is value in department table?
2,The same department_id is used for unique key.?
3,How read happens and How Update/delete happens in NOSQL database?
4,Is there any index concept in NOSQL?
Please share your suggestions
Thanks,