Columns used as a record
If we place name value pairs under the column key that contain different attributes then we can consider the columns as classic database record. So if we are wanting to store the details of a user then the columns might be:
Name (key)
- Email: user@example.com
- Twiter: TwitterUser
- Phone: 01 000 345678
In this schema the order of the columns is not important because the names are not related. However unlike a relational database, there is no definition of the “fields” in the record, we define them at runtime in the application. This does give us the flexibility to add new fields providing our application can handle missing “fields”.
Columns used as a List
If each of the name value pairs are the same attributes then we can consider this as an ordered list . In this use case the ordering of the columns is important and the ordering type needs to be carefully thought out. For example if we want to store messages from a user, and we want to be able to get the most recent, then we will store them as:
Author (key)
- Timeuuid: Message
- Timeuuid: Message
- Timeuuid: Message
This ordered list can be thought of as an index of records. The records would be stored in another column family.
Supercolumns as a list of records
Even better, we can use supercolumns to create a combination of lists and records. Normally we would make the supercolumns the ordered list and the columns the record. In our messaging system, we want to get the latest messages from a user:
Author (Key)
- Timeuuid: (Supercolumn name)
- Message: Message Text
- Time: Time of message
- Picture: Binary picture data
- Timeuuid: (Supercolumn name)
- Message: Message Text
- Time: Time of message
- Picture: Binary picture data
The supercolumns are ordered by time, the columns under it are not ordered.
As ever I look forward to comments about this post.
Website design is a very important aspect of setting up and managing a website, especially if you want to attract visitors to your website.
ReplyDeletereshma
I love your articles. Nicely presented information in this post, I prefer to read this kind of stuff. The quality of content is fine and the conclusion is good. Thanks for the post.
ReplyDeleteJoomla developer
Thanks for sharing your info. I really appreciate your efforts and I will be waiting for your further write ups thanks once again.
ReplyDeleteVee Eee Technologies
This comment has been removed by the author.
ReplyDeleteThis is the Very Nice Article.. Thank you very much for sharing..
ReplyDeletegreat information.java application development
Free Direct Mail Sample Kit - Its great article post, really I read and like this such types of blog post.
ReplyDeleteFree Sample Kits
Snap Packs
Direct Mail Blank Postcard
This comment has been removed by the author.
ReplyDeleteThis comment has been removed by the author.
ReplyDelete
ReplyDeleteNice blog..!!
Dentist in Vasant Vihar
Nice Blog Post
ReplyDeleteBest Regards
appssage
"Nice blog..! I really loved reading through this article. Thanks for sharing such a amazing post with us and keep blogging... web designing and development company in india
ReplyDeleteecommerce website designing company in india
digital marketing service providers in india
best app development companies in india"
In todays every developer started adopting the rich features of Bootstrap framework. The points you have shared regarding the benefits bootstrap compels most of the business people to make use of this technology.
ReplyDeleteMobile App Development India
Hire Opencart Developer
Hire Php Developer
Hire Php Programmer
Hire Wordpress Programmer
Appreciation for the incredible blog! Keep it up.Web Development Company in India
ReplyDeleteThe blog you have shared is incredibly helpful. The tips you have shared related to web development is really informative. Thanks for sharing this blog!
ReplyDeleteHire Dedicated Wordpress Developer
Dedicated Magento Developer
Dedicated Wordpress Developer
Hire Cake Php Programmer
Hire Phonegap Developer