# Data Modeling **URL:** https://discuss.aerospike.com/c/how-developers-are-using-aerospike/data-modeling/143.md [Latest](https://discuss.aerospike.com/latest.md) · [Categories](https://discuss.aerospike.com/categories.md) · [Tags](https://discuss.aerospike.com/tags.md) --- ## [About the Data Modeling category](https://discuss.aerospike.com/t/about-the-data-modeling-category/1810)
**Author:** [@Mnemaudsyne](https://discuss.aerospike.com/u/Mnemaudsyne)\ **Replies:** 0
Questions about data modeling in Aerospike --- ## [Realtime aggregation of click data](https://discuss.aerospike.com/t/realtime-aggregation-of-click-data/2463)
**Author:** [@Media](https://discuss.aerospike.com/u/Media)\ **Replies:** 2\ **Last updated:** [April 19, 2016, 10:26am UTC](https://discuss.aerospike.com/t/realtime-aggregation-of-click-data/2463 "2016-04-19T10:26:31Z")
We’re planning to use Aerospike for storing our clickstream data. As we operate similar fashion to ad tech companies, we must scale our data quite fast with low latency. Suppose, think our clickstream set has the follow… --- ## [Migrate Data Model from Scylla to Aerospike](https://discuss.aerospike.com/t/migrate-data-model-from-scylla-to-aerospike/9406)
**Author:** [@JonasLevin](https://discuss.aerospike.com/u/JonasLevin)\ **Replies:** 1\ **Last updated:** [June 9, 2022, 10:11pm UTC](https://discuss.aerospike.com/t/migrate-data-model-from-scylla-to-aerospike/9406 "2022-06-09T22:11:10Z")
Hello, I’m working on the backend of a Mobile Application that let’s users create Parties and upload Video Stories related to a specific Party. I have previously used Scylla to store Parties and Story Metadata. But I d… --- ## [Feedback on Denormalized Model vs Normalized Model](https://discuss.aerospike.com/t/feedback-on-denormalized-model-vs-normalized-model/9409)
**Author:** [@JonasLevin](https://discuss.aerospike.com/u/JonasLevin)\ **Replies:** 5\ **Last updated:** [May 13, 2022, 11:33pm UTC](https://discuss.aerospike.com/t/feedback-on-denormalized-model-vs-normalized-model/9409 "2022-05-13T23:33:17Z")
I’m working on the backend of a Mobile Application that allows users to create public or private Parties and upload Video Stories for specific Parties. I have previously used Scylla but I hit some roadblocks, like ttl e… --- ## [Concurrent read with multiple services](https://discuss.aerospike.com/t/concurrent-read-with-multiple-services/7729)
**Author:** [@Warox](https://discuss.aerospike.com/u/Warox)\ **Replies:** 1\ **Last updated:** [September 25, 2020, 3:07am UTC](https://discuss.aerospike.com/t/concurrent-read-with-multiple-services/7729 "2020-09-25T03:07:48Z")
Hello, I want to read records from aerospike with multiple instances without double-reading. My plan is: Add time field. Read records which are older that 1 sec. Update time field (prevent reading for next 1 sec) I c… --- ## [What is the significance of a bin](https://discuss.aerospike.com/t/what-is-the-significance-of-a-bin/6818)
**Author:** [@vnagineni](https://discuss.aerospike.com/u/vnagineni)\ **Replies:** 1\ **Last updated:** [November 13, 2019, 6:11pm UTC](https://discuss.aerospike.com/t/what-is-the-significance-of-a-bin/6818 "2019-11-13T18:11:24Z")
while storing data what is the difference between storing all fields in one bin as a map vs storing each field in a different bin. What are the benefits/drawbacks of each approach? --- ## [Integration with Oracle and Handling JSON](https://discuss.aerospike.com/t/integration-with-oracle-and-handling-json/5891)
**Author:** [@Maanas\_Krishna\_Ravin](https://discuss.aerospike.com/u/Maanas_Krishna_Ravin)\ **Replies:** 4\ **Last updated:** [July 6, 2019, 9:09pm UTC](https://discuss.aerospike.com/t/integration-with-oracle-and-handling-json/5891 "2019-07-06T21:09:47Z")
I am trying to use Aerospike as a Cache on top of Oracle Database: Is there a way to auto synchronize Aerospike and Oracle ? In case we need to write the synchronization logic what would be the best approach to perfo… --- ## [Data Model for a highspeed write](https://discuss.aerospike.com/t/data-model-for-a-highspeed-write/6064)
**Author:** [@modithak](https://discuss.aerospike.com/u/modithak)\ **Replies:** 1\ **Last updated:** [March 26, 2019, 11:38pm UTC](https://discuss.aerospike.com/t/data-model-for-a-highspeed-write/6064 "2019-03-26T23:38:16Z")
Main use case require us to be able to write about 100,000 records within a 5-15 mins time span which seems to be quite a small task for Aerospike. However, I am going in rounds trying to model the data structure. I will… --- ## [Data Modeling for Special Ecommerce Website and App](https://discuss.aerospike.com/t/data-modeling-for-special-ecommerce-website-and-app/4660)
**Author:** [@Piyush\_Aggarwal](https://discuss.aerospike.com/u/Piyush_Aggarwal)\ **Replies:** 2\ **Last updated:** [September 29, 2017, 10:44am UTC](https://discuss.aerospike.com/t/data-modeling-for-special-ecommerce-website-and-app/4660 "2017-09-29T10:44:35Z")
Hello I have just started using Aerospike so I need some details what will be the good data model for my e-commerce platform. Here are some basic requirements for my e-commerce platform: User Set(For login & registe… --- ## [Feedback/Help on Designing Database Schema](https://discuss.aerospike.com/t/feedback-help-on-designing-database-schema/3487)
**Author:** [@bhagyashree](https://discuss.aerospike.com/u/bhagyashree)\ **Replies:** 1\ **Last updated:** [September 28, 2017, 10:26pm UTC](https://discuss.aerospike.com/t/feedback-help-on-designing-database-schema/3487 "2017-09-28T22:26:51Z")
Hello everyone, We are planning to use Aerospike. We have design database schema for our use case. We would like some feedback or help from you guys on designed schema. Because of some reason, we can not put designed sc… --- ## [Storing \>10billion small keys](https://discuss.aerospike.com/t/storing-10billion-small-keys/3286)
**Author:** [@aduranel](https://discuss.aerospike.com/u/aduranel)\ **Replies:** 1\ **Last updated:** [August 25, 2016, 5:30pm UTC](https://discuss.aerospike.com/t/storing-10billion-small-keys/3286 "2016-08-25T17:30:30Z")
Hi, I am testing Aerospike to see if it could be a good Cassandra replacement. Here is my use case: Being able to store around 17 billion keys on a cluster. The structure of the values is a JSON converted into a bin … --- ## [Modelling large data structures](https://discuss.aerospike.com/t/modelling-large-data-structures/3195)
**Author:** [@mlove-au](https://discuss.aerospike.com/u/mlove-au)\ **Replies:** 1\ **Last updated:** [July 23, 2016, 7:57am UTC](https://discuss.aerospike.com/t/modelling-large-data-structures/3195 "2016-07-23T07:57:18Z")
Hi, We are trying to use aerospike with the following use-case, and are looking for feed-back/recommendations as to how we are thinking of modelling the data. In our use-case, we have a large number of “entities” (init… --- ## [How well suited is Aerospike for this niche use case](https://discuss.aerospike.com/t/how-well-suited-is-aerospike-for-this-niche-use-case/3093)
**Author:** [@the\_beest](https://discuss.aerospike.com/u/the_beest)\ **Replies:** 6\ **Last updated:** [June 30, 2016, 3:20pm UTC](https://discuss.aerospike.com/t/how-well-suited-is-aerospike-for-this-niche-use-case/3093 "2016-06-30T15:20:11Z")
I’m looking for a data store that would be optimal for storing, incrementing, and retrieving only integers, and I’m wondering if Aerospike would be a fair solution. The logical structure of my data would be akin to a Map\<… --- ## [Multidimensional php array](https://discuss.aerospike.com/t/multidimensional-php-array/2754)
**Author:** [@Eran\_Hazout](https://discuss.aerospike.com/u/Eran_Hazout)\ **Replies:** 1\ **Last updated:** [March 31, 2016, 7:14pm UTC](https://discuss.aerospike.com/t/multidimensional-php-array/2754 "2016-03-31T19:14:06Z")
Hey all. We are considering moving parts of our data to erospike servers for storing multidimensional php arrays and I have few basic questions that I didn’t find a complete answer on the web. Is it possible to store mu… --- ## [Using RAM and SSD namespaces in a common scenario](https://discuss.aerospike.com/t/using-ram-and-ssd-namespaces-in-a-common-scenario/2434)
**Author:** [@angelo.difino](https://discuss.aerospike.com/u/angelo.difino)\ **Replies:** 4\ **Last updated:** [January 29, 2016, 8:30pm UTC](https://discuss.aerospike.com/t/using-ram-and-ssd-namespaces-in-a-common-scenario/2434 "2016-01-29T20:30:55Z")
Hi all aerospikers ; - ) I’m in the process to choose a nosql db for a new project and I’m looking for some suggestions/ideas to best modelling my problem with aerospike, that so far seems the best solution. I mainly ha… --- ## [Storing queryable tags against a user profile](https://discuss.aerospike.com/t/storing-queryable-tags-against-a-user-profile/2387)
**Author:** [@yannispsarras](https://discuss.aerospike.com/u/yannispsarras)\ **Replies:** 8\ **Last updated:** [January 14, 2016, 12:31pm UTC](https://discuss.aerospike.com/t/storing-queryable-tags-against-a-user-profile/2387 "2016-01-14T12:31:41Z")
Hi all, I trying to evaluate aerospike for the following scenario (which I think is pretty common in the adtech world). I have a large number of user profiles (several hundred million) and one of those profiles has tags… --- ## [Use of Scan to fetch Critical data](https://discuss.aerospike.com/t/use-of-scan-to-fetch-critical-data/2259)
**Author:** [@Guy\_Sela](https://discuss.aerospike.com/u/Guy_Sela)\ **Replies:** 7\ **Last updated:** [December 14, 2015, 1:06pm UTC](https://discuss.aerospike.com/t/use-of-scan-to-fetch-critical-data/2259 "2015-12-14T13:06:14Z")
Hi, I have a set that holds critical data, that cannot be fetched partially. Because new records can be added to this set dynamically, I am using a scan to retrieve all the data. Lately I realized that scans do not retur… --- ## [Complex big data modeling for low latency queries (huge throughput - over 20K read/write per second)](https://discuss.aerospike.com/t/complex-big-data-modeling-for-low-latency-queries-huge-throughput-over-20k-read-write-per-second/2014)
**Author:** [@wedi\_dev](https://discuss.aerospike.com/u/wedi_dev)\ **Replies:** 1\ **Last updated:** [October 20, 2015, 12:52am UTC](https://discuss.aerospike.com/t/complex-big-data-modeling-for-low-latency-queries-huge-throughput-over-20k-read-write-per-second/2014 "2015-10-20T00:52:53Z")
In one set I’ve got over 1b items (key = uuid) which have some attributes (e.g. color, size, cost…). On the other set I’ve got milions of orders (key = orderId) with some meta data (e.g. date, client…) And on the final… --- ## [Storing tabular/PSV data in Aerospike](https://discuss.aerospike.com/t/storing-tabular-psv-data-in-aerospike/1913)
**Author:** [@Edmon\_Begoli](https://discuss.aerospike.com/u/Edmon_Begoli)\ **Replies:** 2\ **Last updated:** [September 30, 2015, 12:47am UTC](https://discuss.aerospike.com/t/storing-tabular-psv-data-in-aerospike/1913 "2015-09-30T00:47:56Z")
We are generating medical statistics that show number of medical visits per practice and location. These are psv (pipe separated) files that have: location, practice,physician,num\_visits, charges, date\_of\_service Each … --- ## [How to sort all records in a SET based on one BIN in Aerospike](https://discuss.aerospike.com/t/how-to-sort-all-records-in-a-set-based-on-one-bin-in-aerospike/1876)
**Author:** [@Hafsa](https://discuss.aerospike.com/u/Hafsa)\ **Replies:** 4\ **Last updated:** [September 24, 2015, 10:30pm UTC](https://discuss.aerospike.com/t/how-to-sort-all-records-in-a-set-based-on-one-bin-in-aerospike/1876 "2015-09-24T22:30:41Z")
I have studied that aggregate functions can only be applied through UDFs in Aerospike. When you need to sort any bin value, so you need to apply UDF on that and it will return sorted bin values. Limitation is that it ret… --- ## [Ideas for mapping any $searchterms to given set of $results (stemming, spelling correction, etc.) with AS?](https://discuss.aerospike.com/t/ideas-for-mapping-any-searchterms-to-given-set-of-results-stemming-spelling-correction-etc-with-as/1844)
**Author:** [@ManuelSchmidt](https://discuss.aerospike.com/u/ManuelSchmidt)\ **Replies:** 0\ **Last updated:** [September 13, 2015, 12:24pm UTC](https://discuss.aerospike.com/t/ideas-for-mapping-any-searchterms-to-given-set-of-results-stemming-spelling-correction-etc-with-as/1844 "2015-09-13T12:24:06Z")
We have an application that is dealing with user input on a somewhat broader base. Analysis showed that we loose quite some folks because their input does not match what we have prepared in our dataset. Users would type … --- ## [Best way to store bins with multiple values for one key in Aerospike](https://discuss.aerospike.com/t/best-way-to-store-bins-with-multiple-values-for-one-key-in-aerospike/1823)
**Author:** [@Hafsa](https://discuss.aerospike.com/u/Hafsa)\ **Replies:** 1\ **Last updated:** [September 10, 2015, 9:18pm UTC](https://discuss.aerospike.com/t/best-way-to-store-bins-with-multiple-values-for-one-key-in-aerospike/1823 "2015-09-10T21:18:09Z")
I need to save the following format in Aerospike: {"name": "interest", "datamap" : \[ {"sports":"soccer"}, {"color":"green"}\], "clientId":"100", "eventTagId": 78932 } Here clientId is a key. I can save name: interes… --- ## [How to filter records on the basis of customized datetime stamp format in Aerospike](https://discuss.aerospike.com/t/how-to-filter-records-on-the-basis-of-customized-datetime-stamp-format-in-aerospike/1824)
**Author:** [@Hafsa](https://discuss.aerospike.com/u/Hafsa)\ **Replies:** 1\ **Last updated:** [September 10, 2015, 9:14pm UTC](https://discuss.aerospike.com/t/how-to-filter-records-on-the-basis-of-customized-datetime-stamp-format-in-aerospike/1824 "2015-09-10T21:14:06Z")
I am saving records with datetime stamp in aerospike in the format : YYYY-MM-DDTHH:mm:ssZ e.g: 2015-03-31T11:24:22Z. I want to filter records based on requests like 4h, 1d etc. If I receive request for last 4h and suppos… --- ## [Does Aerospike do in-place updates?](https://discuss.aerospike.com/t/does-aerospike-do-in-place-updates/174)
**Author:** [@jene](https://discuss.aerospike.com/u/jene)\ **Replies:** 0\ **Last updated:** [August 16, 2014, 12:13am UTC](https://discuss.aerospike.com/t/does-aerospike-do-in-place-updates/174 "2014-08-16T00:13:00Z")
One of the optimizations that databases with a schema and rotation disk use is to update a piece of data for a row. What this means is that no matter how large the object is, if the only update is a small piece, only tha… --- ## [Timeseries Data structure question](https://discuss.aerospike.com/t/timeseries-data-structure-question/1748)
**Author:** [@Oxy](https://discuss.aerospike.com/u/Oxy)\ **Replies:** 4\ **Last updated:** [September 5, 2015, 11:44pm UTC](https://discuss.aerospike.com/t/timeseries-data-structure-question/1748 "2015-09-05T23:44:59Z")
Hello, I have a question about the best way to organize my dataset. Currently I have a set of timeseries data with a key like this: 2015:8:15:appid - with 3 bins with ints that are counters. The way I query is: cre… --- ## [Help on last Inserted record + max value](https://discuss.aerospike.com/t/help-on-last-inserted-record-max-value/1450)
**Author:** [@Dennis](https://discuss.aerospike.com/u/Dennis)\ **Replies:** 2\ **Last updated:** [July 8, 2015, 5:43pm UTC](https://discuss.aerospike.com/t/help-on-last-inserted-record-max-value/1450 "2015-07-08T17:43:46Z")
Hi, Trying to implement autoincrement field(bin) for users set, i.e. every new user should have “Id” bin incremented +1. Please advise on the best practice! In particular: how to get the last inserted record? how to … --- ## [Data modeling for expiration](https://discuss.aerospike.com/t/data-modeling-for-expiration/1297)
**Author:** [@maticz](https://discuss.aerospike.com/u/maticz)\ **Replies:** 1\ **Last updated:** [May 22, 2015, 4:51am UTC](https://discuss.aerospike.com/t/data-modeling-for-expiration/1297 "2015-05-22T04:51:02Z")
Hi everyone, we’re experimenting with Aerospike – more specifically, we’re trying to move our user data from Cassandra to Aerospike. This data is specific in a way that there are categories associated with users that ha… --- ## [How is Aerospike primary key organized to iterate Set effectively?](https://discuss.aerospike.com/t/how-is-aerospike-primary-key-organized-to-iterate-set-effectively/806)
**Author:** [@deepnighttwo](https://discuss.aerospike.com/u/deepnighttwo)\ **Replies:** 13\ **Last updated:** [January 12, 2015, 11:27pm UTC](https://discuss.aerospike.com/t/how-is-aerospike-primary-key-organized-to-iterate-set-effectively/806 "2015-01-12T23:27:47Z")
I went though the online documents of Aerospike official website. One thing I didn’t figure out is how the primary key organized to support Set iteration? As the document mentioned, a Namespace(NS) is created with 4096 … --- ## [Data Modeling with records bigger than 128 KB](https://discuss.aerospike.com/t/data-modeling-with-records-bigger-than-128-kb/763)
**Author:** [@architect](https://discuss.aerospike.com/u/architect)\ **Replies:** 1\ **Last updated:** [December 17, 2014, 11:13pm UTC](https://discuss.aerospike.com/t/data-modeling-with-records-bigger-than-128-kb/763 "2014-12-17T23:13:40Z")
The default MAX record size is 128 KB. We need to store user events per user ordered by time and sometime we exceeds the 128KB. For serving the user we need to retrieve his n latest event within an time interval. e.g. … --- ## [Performance Woes: is there documentation on data modeling in correlation to querying methods?](https://discuss.aerospike.com/t/performance-woes-is-there-documentation-on-data-modeling-in-correlation-to-querying-methods/698)
**Author:** [@jrdn](https://discuss.aerospike.com/u/jrdn)\ **Replies:** 1\ **Last updated:** [December 16, 2014, 8:23am UTC](https://discuss.aerospike.com/t/performance-woes-is-there-documentation-on-data-modeling-in-correlation-to-querying-methods/698 "2014-12-16T08:23:06Z")
Okay, so looking into a lot of benchmarks online about the performance of Aerospike are great. One thing I’m seeing is that all of the ones I’ve seen thus far are simple key/value benchmarks. Are there any known write-… [Next page](https://discuss.aerospike.com/c/how-developers-are-using-aerospike/data-modeling/143.md?page=1)