data-modeling
Super column vs serialization vs 2 lookups in Cassandra
We have: users, each of which has events, each of which has several properties (time, type etc.). Our basic use case is to fetch all events of a given user in a given time-span.[详细]
2023-04-07 18:32 分类:问答What are some strategies for updating volatile data in Solr?
What are some strategies for updating volatile data in Solr? Imagine if you needed to model YouTube video data in a Solr index: how would you keep the \"views\" data fresh without swamping Solr in 开发[详细]
2023-04-07 09:39 分类:问答Modeling Items and Options for shopping cart
I am working on a shopping cart application, and I am pretty much stumped on how to model Items and Options according to the following requirements:[详细]
2023-04-06 10:56 分类:问答modeling global indentification for different objects in Rails 3.1
I have a system where I want 开发者_如何学Ca global identifier for objects in rails. The global identification is a number (or alpha-numeric) that is shared across a bunch of objects. When you save an[详细]
2023-04-06 00:22 分类:问答How do I model "relative" time in a database?
Clarification: I am not trying to calculate friendly times (e.g., \"8 seconds ago\") by using a timestamp and the current time.[详细]
2023-04-03 22:01 分类:问答What ways are there to store information about an anonymous/guest user in a database?
Our application has an online shop among other features, and users are normally requested to register before completing a sale, creating a unique customer_ID in the process. When they return, they can[详细]
2023-04-03 19:49 分类:问答mysql table problem
If I wanna provide a free guestbook service via php+mysql,I have two choices, store all message in one database[详细]
2023-04-02 09:37 分类:问答How to setup data model for customizable application
I have an ASP.NET data entry application that is used by multiple clients.The application consists of multiple data entry modules that are common to all clients.[详细]
2023-04-01 20:19 分类:问答Best way to design a table in which a cell has mutiple references?
My question regards how to design a database. I have one table, called posts, with columns: ID, subject, keywords, (and a few other columns)[详细]
2023-04-01 11:24 分类:问答subtyping relationships in OO paradigm
Let us consider a class \'Human\' -->(1..*) \'Human\' , where Human is a supertype. Say it has subclasses like \'Male\', \'Female\', \'SociallyPathologicalMale\' etc. The basic association b/w 2 entit[详细]
2023-03-31 03:30 分类:问答