NoSQL

CREATE KEYSPACE abd WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 3 };
---
USE abd;

CREATE TABLE student (      ID VARCHAR PRIMARY KEY,      name VARCHAR,      major VARCHAR,      birthdate TIMESTAMP,      email VARCHAR,      gender INT  );
---
INSERT INTO student (ID, name, major, birthdate, email, gender) VALUES ('ms108537', 'Carlos Ceja', 'ISC', '1987-02-28', 'ms108537@iteso.mx', 1); INSERT INTO student (ID, name, major, birthdate, email, gender) VALUES ('ms67482', 'Francisco Oblea', 'ISC', '1986-05-24', 'ms67482@iteso.mx', 1); INSERT INTO student (ID, gender) VALUES ('ms101010', 0); INSERT INTO student (ID) VALUES ('ms0000'); INSERT INTO student (ID, email) VALUES ('ms0000', 'ms0000@iteso.mx');
---
CREATE TABLE birthday (  empID text,  b_mon text,  b_day text,  b_yr text,   PRIMARY KEY (b_mon)  ); INSERT INTO birthday (empID, b_mon, b_day, b_yr) VALUES ('Emp1', 'JUN', '25', '2000'); INSERT INTO birthday (empID, b_mon, b_day, b_yr) VALUES ('Emp2', 'JUN', '28', '2000'); SELECT * FROM birthday;
---
CREATE TABLE studentset (  name TEXT,  courses SET<TEXT>,  PRIMARY KEY (name) );
 INSERT INTO studentset(name, courses) VALUES ('Vidal Ortiz', {'Sistemas Paralelos', 'Bases de Datos Avanzadas'}); SELECT * FROM studentset; UPDATE studentset(name, courses) SET courses = courses + {'Ciencia de datos'} WHERE name='Vidal Ortiz'; SELECT * FROM studentset; UPDATE studentset(name, courses) SET courses = courses - {'Ciencia de datos'} WHERE name='Vidal Ortiz'; SELECT * FROM studentset; Si repito un valor del conjunto no lo repite: SET courses = courses + {'Sistemas Paralelos'} WHERE name='Vidal Ortiz'; SELECT * FROM studentset;
---
CREATE COLUMNFAMILY studentlist (    name TEXT,    logins LIST<INT>,    PRIMARY KEY(name) );

INSERT INTO studentlist(name, logins) VALUES ('Vidal Ortiz', [2]); SELECT * FROM studentlist; UPDATE studentlist SET logins = [3] WHERE name = 'Vidal Ortiz'; SELECT * FROM studentlist; UPDATE studentlist SET logins = [2,3,4,6,7,2]) WHERE name = 'Vidal Ortiz'; SELECT * FROM studentlist; UPDATE studentlist SET logins = + [100] WHERE name = 'Vidal Ortiz';
        Cuaderno    de  Prácticas          Administración de  Base    de  Datos           45
SELECT * FROM studentlist;
---
CREATE COLUMNFAMILY studentmap (    name TEXT,    teachers MAP<TEXT, TEXT>,    PRIMARY KEY(name) );
 INSERT INTO studentmap (name, teachers) VALUES ('Vidal Ortiz', { 'Bases de Datos Avanzadas' : 'Alberto de Obeso', 'Sistemas Paralelos' : 'Jose Elvira'}); SELECT * FROM studentmap; INSERT INTO studentmap (name, teachers) VALUES ('Rene Salgado', { Gestión de Bases de Datos' : 'Rodolfo Luthe', 'Sistemas Paralelos' : 'Jose Elvira'}); select * from studentmap; UPDATE student SET teachers['Sistemas Paralelos'] = 'Jose Luis Elvira'; select * from studentmap where name='Vidal Ortiz';