Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with database-design
Search options not deleted
user 3106
The development of the conceptual schema and/or the logical model and/or the physical settings of a database.
6
votes
How to design a database for storing a sorted list?
I would think the thing to do is to store the property or properties that are used to calculate the rank and then build an index over them. Rather than trying to force the database to physically stor …
- 12.6k
6
votes
Scalable table structure for periodically updated stats that get aggregated over time
I'm frankly always nervous about throwing away details. For that reason I'd try to find a way to keep handy (or at least archive) the most granular data. That way, if your summarization requirements …
- 12.6k
5
votes
Accepted
Recommended model for application level event logging
Your basic model is fine. It gives you a standard, normalized intersection (many to many) of events of specific types associated with particular users. Without knowing more about your intentions or …
- 12.6k
5
votes
Accepted
database schema for a product with multiple categories and hierarchical categories
What you are proposing is a good solution for your requirement of M:N products to categories and hierarchical categories.
To avoid exposing yourself to numerous updates:
You need to do two things to …
- 12.6k
1
vote
One to one relationship or another approach?
Your "Idea 1" is the best approach as it most naturally and accurately enforces the cardinality between SITE and CLAN/GAME/TEAM.
Your other rule that SITE must be only one of CLAN, GAME or TEAM wou …
- 12.6k
3
votes
Database Modelling of Type, Subtype Relation
Important Caveat: You need to look at the link OP provided! It uses the words type and sub-type as jargon in a way which is similar to, but different than what programmers or even data modellers wou …
- 12.6k
0
votes
How to design a schema to store search keywords
Do you have a reason to store the searches as individual events or are you only interested in recording which terms were used how many times on any given day?
If you just need to record how many time …
- 12.6k
2
votes
Accepted
Where does a type specific field go?
What you are proposing is an entity subtyping approach. This would be one common solution to your design problem. Another would be Entity-Attribute-Value (EAV).
Type "subtype" or "EAV" into the sea …
- 12.6k
2
votes
Design question about student assessment data
The first thing you want to do to keep your thinking straight is to choose some clear terminology. You are using the word "assessment" in two different contexts: (i) a Test and (ii) the results for a …
- 12.6k
3
votes
Data Model: Parent, Child, Grandchild with Child Being Optional
Ask yourself what is the difference between a Department and a Section? Are they just organizational objects that may contain either employees or other, smaller organizational objects? Do they have …
- 12.6k
2
votes
Accepted
Additional fields or intersection table
Using an intersection table is a cleaner and more flexible design.
With extra columns you are limited to the number of instances you can include (one per foreign key column). Also, the types of in …
- 12.6k
3
votes
Accepted
Database design for threading messages
A very similar question was asked on StackOverflow. Have a look at my answer there. I recommend a data model and give specific advice about the SQL to list of all messages in a thread, with read sta …
- 12.6k
3
votes
Accepted
Choosing the correct database type for single type of entry
NoSQL databases are for unstructured data or unpredictably structured data that is often queried using full-text searching.
Capturing time-series statistics for graphing sounds like a pretty well-s …
- 12.6k
1
vote
Accepted
Sql schema design advice
The third option is to keep a transaction log of points transactions.
Use the schema from your first option to record the "going rate" for points. Whenever you have a transaction that either gives …
- 12.6k
2
votes
Accepted
creating a historical database, need help making a decision
Your first design is the way to go. Keep everything about a process on a single record. Your challenge isn't one of database design, it's one of restartability/disaster recovery.
Since your process …
- 12.6k