NoSQL web development with Apache Cassandra

Cover......Page 1
Contents......Page 5
Introduction......Page 11
PART I: JAVA CLIENTS......Page 16
 Chapter 1 Using Cassandra with Hector......Page 18
  Cassandra Storage Model......Page 19
  Overview of Hector Java Client......Page 21
  Setting the Environment......Page 29
  Creating a Java Project......Page 30
  Creating a Cassandra Cluster Object......Page 36
  Creating a Schema......Page 37
  Adding Table Data......Page 40
  Adding a Single Column of Data in a Table......Page 41
  Adding Multiple Columns of Data in a Table......Page 43
  Retrieving Table Data......Page 44
  Updating Data......Page 56
  Deleting Table Data......Page 59
  The HectorClient Class......Page 62
  Summary......Page 69
  Overview of CQL......Page 70
  Setting the Environment......Page 72
  Creating a Java Project......Page 73
  Creating a Keyspace......Page 79
  Creating a Column Family......Page 80
  Using the INSERT Statement......Page 84
  Using the SELECT Statement......Page 85
  Creating a Secondary Index......Page 88
  Using the SELECT Statement with the WHERE Clause......Page 89
  Using the UPDATE Statement......Page 91
  Using the BATCH Statement......Page 92
  Using the DELETE Statement......Page 94
  Using the ALTER COLUMNFAMILY Statement......Page 95
  Dropping the Column Family......Page 96
  The CQLClient Application......Page 97
  New Features in CQL 3......Page 103
  Summary......Page 105
  Overview of DataStax Java Driver......Page 106
  Setting the Environment......Page 107
  Creating a Java Project......Page 108
  Creating a Connection......Page 113
  Overview of the Session Class......Page 117
  Creating a Table......Page 118
  Running the INSERT Statement......Page 119
  Running a SELECT Statement......Page 120
  Creating an Index......Page 123
  Selecting with SELECT and a WHERE Filter......Page 124
  Running an Async Query......Page 129
  Running a PreparedStatement Query......Page 133
  Running the UPDATE Statement......Page 135
  Running the DELETE Statement......Page 137
  Running the BATCH Statement......Page 139
  Dropping a Keyspace......Page 141
  The CQLClient Application......Page 142
  Summary......Page 151
PART II: SCRIPTING LANGUAGES......Page 152
  An Overview of Phpcassa......Page 154
  Setting the Environment......Page 159
  Creating a Keyspace......Page 161
  Creating a Column Family and Connection Pool......Page 163
  Adding Data......Page 168
  Adding Data in a Batch......Page 170
  Retrieving Data......Page 173
  Getting Selected Columns......Page 176
  Getting Columns from Multiple Rows......Page 178
  Getting Column Slices......Page 180
  Getting a Range of Rows and Columns......Page 184
  Updating Data......Page 187
  Deleting Data......Page 189
  Dropping the Keyspace and Column Family......Page 190
  Summary......Page 192
  Setting the Environment......Page 194
  Installing a Ruby Client with Cassandra......Page 198
  Creating a Connection......Page 199
  Creating a Keyspace......Page 201
  Creating a Column Family......Page 203
  Adding Data to a Table......Page 204
  Adding Rows in Batch......Page 207
  Retrieving Data from a Table......Page 210
  Selecting a Single Row......Page 211
  Selecting Multiple Rows......Page 213
  Selecting a Range of Rows......Page 214
  Using a Random Partitioner......Page 216
  Using an Order-Preserving Partitioner......Page 219
  Getting a Slice of Columns......Page 221
  Updating Data in a Table......Page 222
  Deleting Data in a Table......Page 223
  Updating a Column Family......Page 224
  Summary......Page 225
  Overview of Node.js Driver for Cassandra CQL......Page 226
  Mapping Data Types......Page 230
  Setting the Environment......Page 231
  Creating a Connection with Cassandra......Page 235
  Adding Data to a Table......Page 237
  Retrieving Data from a Table......Page 239
  Filtering the Query......Page 240
  Querying with a Prepared Statement......Page 241
  Streaming Query Rows......Page 243
  Streaming a Field......Page 245
  Streaming the Result......Page 248
  Updating Data in Table......Page 251
  Deleting a Column......Page 252
  Deleting a Row......Page 254
  Summary......Page 255
PART III: MIGRATION......Page 256
  Setting the Environment......Page 258
  Creating a Java Project......Page 260
  Creating a BSON Document in MongoDB......Page 264
  Migrating the MongoDB Document to Cassandra......Page 270
  Summary......Page 277
  Setting the Environment......Page 278
  Creating a Java Project......Page 279
  Creating a JSON Document in Couchbase......Page 288
  Migrating the Couchbase Document to Cassandra......Page 296
  Summary......Page 305
PART IV: JAVA EE......Page 306
  Setting the Environment......Page 308
  Creating a JPA Project in Eclipse......Page 310
  Creating a JPA Entity Class......Page 318
  Configuring JPA in Persistence.xml......Page 324
  Creating a JPA Client Class......Page 329
  Running JPA CRUD Operations......Page 332
  Summary......Page 343
  Overview of the Spring Data Cassandra Project......Page 344
  Setting the Environment......Page 348
  Creating a Maven Project......Page 350
  Configuring the Maven Project......Page 353
  Configuring JavaConfig......Page 355
  Creating a Model......Page 357
  Using Spring Data with Cassandra with Template......Page 360
  Finding Out About the Cassandra Cluster......Page 361
  Running Cassandra CRUD Operations......Page 363
  Summary......Page 382