Microsoft Column Store Database?
Using Microsoft technologies/products is it possible to create a column store database with column family sets? That is each row being able to have a different number and type of columns.
Colmun Store Database
nosql columnstore
edited 4 hours ago
jadarnel27
4,2771331
asked 5 hours ago
EdmundEdmund
286211
add a comment |
Using Microsoft technologies/products is it possible to create a column store database with column family sets? That is each row being able to have a different number and type of columns.
Colmun Store Database
nosql columnstore
edited 4 hours ago
jadarnel27
4,2771331
asked 5 hours ago
EdmundEdmund
286211
add a comment |
Using Microsoft technologies/products is it possible to create a column store database with column family sets? That is each row being able to have a different number and type of columns.
Colmun Store Database
nosql columnstore
edited 4 hours ago
jadarnel27
4,2771331
asked 5 hours ago
EdmundEdmund
286211
Using Microsoft technologies/products is it possible to create a column store database with column family sets? That is each row being able to have a different number and type of columns.
Colmun Store Database
nosql columnstore
nosql columnstore
edited 4 hours ago
jadarnel27
4,2771331
asked 5 hours ago
EdmundEdmund
286211
edited 4 hours ago
jadarnel27
4,2771331
asked 5 hours ago
EdmundEdmund
286211
edited 4 hours ago
jadarnel27
4,2771331
edited 4 hours ago
jadarnel27
4,2771331
edited 4 hours ago
jadarnel27
4,2771331
4,2771331
asked 5 hours ago
EdmundEdmund
286211
asked 5 hours ago
EdmundEdmund
286211
asked 5 hours ago
EdmundEdmund
286211
286211
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
It sounds like what you're looking for is a "non-relational database," often called a document or NoSQL database. Amazon defines that here:
What is a document database
A document database is a type of nonrelational database that is designed to store semistructured data as documents.
Microsoft has a cloud based product called Azure Cosmos DB, which you can read about here:
Introduction to Azure Cosmos DB
Keeping database schema and indexes in-sync with an application’s schema is especially painful for globally distributed apps. However, with Cosmos DB, you do not need to deal with schemas or indexes. The database engine is fully schema-agnostic.
Microsoft doesn't offer an on-premises version of this product.
SQL Server also has json and XML data types. You could serialize objects with this loosely structured format and store it in a column of this type, but the preferred approach would be to use Cosmos DB or another document database like mongodb or ravendb.
answered 4 hours ago
jadarnel27jadarnel27
4,2771331
1
And Cosmos DB does have a Cassandra API for columnstore type model though behind the scenes everything is stored the same so it presumably doesn't have some of the benefits of a true columnstore
– Martin Smith
4 hours ago
@Martin Thanks, I didn't realize that! I'm actually pretty confused by the interchangeable way they seem to talk about "column store" and NoSQL in that article the OP linked. Mostly because I'm thinking of the (very different) SQL Server Columnstore feature.
– jadarnel27
10 mins ago
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fdba.stackexchange.com%2fquestions%2f227582%2fmicrosoft-column-store-database%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
It sounds like what you're looking for is a "non-relational database," often called a document or NoSQL database. Amazon defines that here:
What is a document database
A document database is a type of nonrelational database that is designed to store semistructured data as documents.
Microsoft has a cloud based product called Azure Cosmos DB, which you can read about here:
Introduction to Azure Cosmos DB
Keeping database schema and indexes in-sync with an application’s schema is especially painful for globally distributed apps. However, with Cosmos DB, you do not need to deal with schemas or indexes. The database engine is fully schema-agnostic.
Microsoft doesn't offer an on-premises version of this product.
SQL Server also has json and XML data types. You could serialize objects with this loosely structured format and store it in a column of this type, but the preferred approach would be to use Cosmos DB or another document database like mongodb or ravendb.
answered 4 hours ago
jadarnel27jadarnel27
4,2771331
1
And Cosmos DB does have a Cassandra API for columnstore type model though behind the scenes everything is stored the same so it presumably doesn't have some of the benefits of a true columnstore
– Martin Smith
4 hours ago
@Martin Thanks, I didn't realize that! I'm actually pretty confused by the interchangeable way they seem to talk about "column store" and NoSQL in that article the OP linked. Mostly because I'm thinking of the (very different) SQL Server Columnstore feature.
– jadarnel27
10 mins ago
add a comment |
It sounds like what you're looking for is a "non-relational database," often called a document or NoSQL database. Amazon defines that here:
What is a document database
A document database is a type of nonrelational database that is designed to store semistructured data as documents.
Microsoft has a cloud based product called Azure Cosmos DB, which you can read about here:
Introduction to Azure Cosmos DB
Keeping database schema and indexes in-sync with an application’s schema is especially painful for globally distributed apps. However, with Cosmos DB, you do not need to deal with schemas or indexes. The database engine is fully schema-agnostic.
Microsoft doesn't offer an on-premises version of this product.
SQL Server also has json and XML data types. You could serialize objects with this loosely structured format and store it in a column of this type, but the preferred approach would be to use Cosmos DB or another document database like mongodb or ravendb.
answered 4 hours ago
jadarnel27jadarnel27
4,2771331
1
And Cosmos DB does have a Cassandra API for columnstore type model though behind the scenes everything is stored the same so it presumably doesn't have some of the benefits of a true columnstore
– Martin Smith
4 hours ago
@Martin Thanks, I didn't realize that! I'm actually pretty confused by the interchangeable way they seem to talk about "column store" and NoSQL in that article the OP linked. Mostly because I'm thinking of the (very different) SQL Server Columnstore feature.
– jadarnel27
10 mins ago
add a comment |
It sounds like what you're looking for is a "non-relational database," often called a document or NoSQL database. Amazon defines that here:
What is a document database
A document database is a type of nonrelational database that is designed to store semistructured data as documents.
Microsoft has a cloud based product called Azure Cosmos DB, which you can read about here:
Introduction to Azure Cosmos DB
Keeping database schema and indexes in-sync with an application’s schema is especially painful for globally distributed apps. However, with Cosmos DB, you do not need to deal with schemas or indexes. The database engine is fully schema-agnostic.
Microsoft doesn't offer an on-premises version of this product.
SQL Server also has json and XML data types. You could serialize objects with this loosely structured format and store it in a column of this type, but the preferred approach would be to use Cosmos DB or another document database like mongodb or ravendb.
answered 4 hours ago
jadarnel27jadarnel27
4,2771331
It sounds like what you're looking for is a "non-relational database," often called a document or NoSQL database. Amazon defines that here:
What is a document database
A document database is a type of nonrelational database that is designed to store semistructured data as documents.
Microsoft has a cloud based product called Azure Cosmos DB, which you can read about here:
Introduction to Azure Cosmos DB
Keeping database schema and indexes in-sync with an application’s schema is especially painful for globally distributed apps. However, with Cosmos DB, you do not need to deal with schemas or indexes. The database engine is fully schema-agnostic.
Microsoft doesn't offer an on-premises version of this product.
SQL Server also has json and XML data types. You could serialize objects with this loosely structured format and store it in a column of this type, but the preferred approach would be to use Cosmos DB or another document database like mongodb or ravendb.
answered 4 hours ago
jadarnel27jadarnel27
4,2771331
edited 4 hours ago
answered 4 hours ago
jadarnel27jadarnel27
4,2771331
answered 4 hours ago
jadarnel27jadarnel27
4,2771331
answered 4 hours ago
jadarnel27jadarnel27
4,2771331
4,2771331
1
And Cosmos DB does have a Cassandra API for columnstore type model though behind the scenes everything is stored the same so it presumably doesn't have some of the benefits of a true columnstore
– Martin Smith
4 hours ago
@Martin Thanks, I didn't realize that! I'm actually pretty confused by the interchangeable way they seem to talk about "column store" and NoSQL in that article the OP linked. Mostly because I'm thinking of the (very different) SQL Server Columnstore feature.
– jadarnel27
10 mins ago
add a comment |
1
And Cosmos DB does have a Cassandra API for columnstore type model though behind the scenes everything is stored the same so it presumably doesn't have some of the benefits of a true columnstore
– Martin Smith
4 hours ago
@Martin Thanks, I didn't realize that! I'm actually pretty confused by the interchangeable way they seem to talk about "column store" and NoSQL in that article the OP linked. Mostly because I'm thinking of the (very different) SQL Server Columnstore feature.
– jadarnel27
10 mins ago
1
1
And Cosmos DB does have a Cassandra API for columnstore type model though behind the scenes everything is stored the same so it presumably doesn't have some of the benefits of a true columnstore
– Martin Smith
4 hours ago
And Cosmos DB does have a Cassandra API for columnstore type model though behind the scenes everything is stored the same so it presumably doesn't have some of the benefits of a true columnstore
– Martin Smith
4 hours ago
@Martin Thanks, I didn't realize that! I'm actually pretty confused by the interchangeable way they seem to talk about "column store" and NoSQL in that article the OP linked. Mostly because I'm thinking of the (very different) SQL Server Columnstore feature.
– jadarnel27
10 mins ago
@Martin Thanks, I didn't realize that! I'm actually pretty confused by the interchangeable way they seem to talk about "column store" and NoSQL in that article the OP linked. Mostly because I'm thinking of the (very different) SQL Server Columnstore feature.
– jadarnel27
10 mins ago
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- 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%2fdba.stackexchange.com%2fquestions%2f227582%2fmicrosoft-column-store-database%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
