Can I use Cassandra to store objects?
My application works like this.
A database(Mysql) where there is a command. The command is an object(consists of fields many fields like ints and strings). There is a webservice which interacts with the database and get the command from the DB and performs some operation.
The way how I am storing the command into db is by stripping all the fields and inserting them in to the db.
Can I use cassandra in place of mysql and store the command object?
c# cassandra
edited Nov 15 '18 at 5:40
Mis94
1,14511025
asked May 4 '10 at 19:17
SandeepSandeep
3,91183753
add a comment |
My application works like this.
A database(Mysql) where there is a command. The command is an object(consists of fields many fields like ints and strings). There is a webservice which interacts with the database and get the command from the DB and performs some operation.
The way how I am storing the command into db is by stripping all the fields and inserting them in to the db.
Can I use cassandra in place of mysql and store the command object?
c# cassandra
edited Nov 15 '18 at 5:40
Mis94
1,14511025
asked May 4 '10 at 19:17
SandeepSandeep
3,91183753
add a comment |
My application works like this.
A database(Mysql) where there is a command. The command is an object(consists of fields many fields like ints and strings). There is a webservice which interacts with the database and get the command from the DB and performs some operation.
The way how I am storing the command into db is by stripping all the fields and inserting them in to the db.
Can I use cassandra in place of mysql and store the command object?
c# cassandra
edited Nov 15 '18 at 5:40
Mis94
1,14511025
asked May 4 '10 at 19:17
SandeepSandeep
3,91183753
My application works like this.
A database(Mysql) where there is a command. The command is an object(consists of fields many fields like ints and strings). There is a webservice which interacts with the database and get the command from the DB and performs some operation.
The way how I am storing the command into db is by stripping all the fields and inserting them in to the db.
Can I use cassandra in place of mysql and store the command object?
c# cassandra
c# cassandra
edited Nov 15 '18 at 5:40
Mis94
1,14511025
asked May 4 '10 at 19:17
SandeepSandeep
3,91183753
edited Nov 15 '18 at 5:40
Mis94
1,14511025
asked May 4 '10 at 19:17
SandeepSandeep
3,91183753
edited Nov 15 '18 at 5:40
Mis94
1,14511025
edited Nov 15 '18 at 5:40
Mis94
1,14511025
edited Nov 15 '18 at 5:40
Mis94
1,14511025
1,14511025
asked May 4 '10 at 19:17
SandeepSandeep
3,91183753
asked May 4 '10 at 19:17
SandeepSandeep
3,91183753
asked May 4 '10 at 19:17
SandeepSandeep
3,91183753
3,91183753
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Why do you want to move away from your current solution which involes a relational database? I wouldn't (believe it or not) recommend to change your datastore premature.
If your are experience problems and want to replace your relational database, then I would recommend to investigate Apache Cassandra.
If you find Cassandra interesting I would suggest a data model that looks something like this:
Commands = { // this is a ColumnFamily (CF)
commandObject1: { // this is the key to this Row inside the CF
// now we have an infinite # of columns in this row
field1: "value1",
field2: "value2",
field3: "value3"
}, // end row
commandObject2: { // this is the key to another row in the CF
// now we have another infinite # of columns in this row
field1: "value1",
field2: "value2",
field3: "value3"
field4: "value4",
field5: "value5"
},
}
(thanks Arin (and his excellent blog post) for the Cassandra data model notation)
answered May 4 '10 at 20:27
SchildmeijerSchildmeijer
17.3k85576
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f2768289%2fcan-i-use-cassandra-to-store-objects%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Why do you want to move away from your current solution which involes a relational database? I wouldn't (believe it or not) recommend to change your datastore premature.
If your are experience problems and want to replace your relational database, then I would recommend to investigate Apache Cassandra.
If you find Cassandra interesting I would suggest a data model that looks something like this:
Commands = { // this is a ColumnFamily (CF)
commandObject1: { // this is the key to this Row inside the CF
// now we have an infinite # of columns in this row
field1: "value1",
field2: "value2",
field3: "value3"
}, // end row
commandObject2: { // this is the key to another row in the CF
// now we have another infinite # of columns in this row
field1: "value1",
field2: "value2",
field3: "value3"
field4: "value4",
field5: "value5"
},
}
(thanks Arin (and his excellent blog post) for the Cassandra data model notation)
answered May 4 '10 at 20:27
SchildmeijerSchildmeijer
17.3k85576
add a comment |
Why do you want to move away from your current solution which involes a relational database? I wouldn't (believe it or not) recommend to change your datastore premature.
If your are experience problems and want to replace your relational database, then I would recommend to investigate Apache Cassandra.
If you find Cassandra interesting I would suggest a data model that looks something like this:
Commands = { // this is a ColumnFamily (CF)
commandObject1: { // this is the key to this Row inside the CF
// now we have an infinite # of columns in this row
field1: "value1",
field2: "value2",
field3: "value3"
}, // end row
commandObject2: { // this is the key to another row in the CF
// now we have another infinite # of columns in this row
field1: "value1",
field2: "value2",
field3: "value3"
field4: "value4",
field5: "value5"
},
}
(thanks Arin (and his excellent blog post) for the Cassandra data model notation)
answered May 4 '10 at 20:27
SchildmeijerSchildmeijer
17.3k85576
add a comment |
Why do you want to move away from your current solution which involes a relational database? I wouldn't (believe it or not) recommend to change your datastore premature.
If your are experience problems and want to replace your relational database, then I would recommend to investigate Apache Cassandra.
If you find Cassandra interesting I would suggest a data model that looks something like this:
Commands = { // this is a ColumnFamily (CF)
commandObject1: { // this is the key to this Row inside the CF
// now we have an infinite # of columns in this row
field1: "value1",
field2: "value2",
field3: "value3"
}, // end row
commandObject2: { // this is the key to another row in the CF
// now we have another infinite # of columns in this row
field1: "value1",
field2: "value2",
field3: "value3"
field4: "value4",
field5: "value5"
},
}
(thanks Arin (and his excellent blog post) for the Cassandra data model notation)
answered May 4 '10 at 20:27
SchildmeijerSchildmeijer
17.3k85576
Why do you want to move away from your current solution which involes a relational database? I wouldn't (believe it or not) recommend to change your datastore premature.
If your are experience problems and want to replace your relational database, then I would recommend to investigate Apache Cassandra.
If you find Cassandra interesting I would suggest a data model that looks something like this:
Commands = { // this is a ColumnFamily (CF)
commandObject1: { // this is the key to this Row inside the CF
// now we have an infinite # of columns in this row
field1: "value1",
field2: "value2",
field3: "value3"
}, // end row
commandObject2: { // this is the key to another row in the CF
// now we have another infinite # of columns in this row
field1: "value1",
field2: "value2",
field3: "value3"
field4: "value4",
field5: "value5"
},
}
(thanks Arin (and his excellent blog post) for the Cassandra data model notation)
answered May 4 '10 at 20:27
SchildmeijerSchildmeijer
17.3k85576
edited May 5 '10 at 15:34
answered May 4 '10 at 20:27
SchildmeijerSchildmeijer
17.3k85576
answered May 4 '10 at 20:27
SchildmeijerSchildmeijer
17.3k85576
answered May 4 '10 at 20:27
SchildmeijerSchildmeijer
17.3k85576
17.3k85576
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f2768289%2fcan-i-use-cassandra-to-store-objects%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
