Tagged Questions
0
votes
0answers
39 views
Database model for keeping track of likes/shares/comments on blog posts over time
My goal is to keep track of the popular posts on different blog sites based on social network activity at any given time. The goal is not to simply get the most popular now, but instead find posts ...
0
votes
0answers
7 views
How to manage primary key while updating [closed]
In the following table primaryKeyColumn is primary key.
To maintain the data history I always uses the values with WHERE condition(WHERE StatusColumn=1) And will set the StatusColumn to 0 if the data ...
1
vote
1answer
58 views
Store data for multiple User Type
I am developing an app where four types of user share same module. So is it a good idea to create:
one table and user_type and user_id (something like that)
table prefixes basically 4 diff tables of ...
9
votes
7answers
60 views
Nested Entities and calculation on leaf entity property - SQL or NoSQL approach
I am working on a hobby project called Menu/Recipe Management.
This is how my entities and their relations look like.
A Nutrient has properties Code and Value
An Ingredient has a collection of ...
15
votes
4answers
1k views
Why many designs ignore normalization in RDBMS?
I got to see many designs that normalization wasn't the first consideration in decision making phase.
In many cases those designs included more than 30 columns, and the main approach was "to put ...
2
votes
1answer
156 views
Status update & news feed database design / architecture
Imagine a application similar to Facebook, where you have status updates and a news feed. The names and profile pictures can be changed. There are also several different types of updates requiring a ...
1
vote
1answer
52 views
SQL Table Design Modification based on data roles or implementation convenience?
I've got an existing SQL table structure that looks like this:
Orders
- order_id
- organisation_id
- [all the rest of the order data]
Organisations
- organisation_id
- [all the rest of the ...
2
votes
4answers
221 views
How to genericize foreign key references in table?
I am trying to design a table to store references to multiple tables as a "target" of the item in each row.
An example should clarify what I am trying to do:
Imagine you have 4 tables (images, ...
2
votes
3answers
137 views
Referencing countries via Foreign Key Constraint
To make things simple to explain: I've got two tables: Table1 and Countries.
The Countries table contains a nice flag and some information, such as DisplayName, the ISO3166 ALPHA3 code and the phone ...
0
votes
4answers
199 views
Create a database for database tables
I'm working on a project where I have to give users the ability to build their own tables,
each user can create more than one table.
(the type of all data is string).
The user can create a table and ...
0
votes
3answers
172 views
How to maintain user relationship when user unfollows another user
I have a table of user relationship which stores who follows whom, the table structure is as follows
-id
-follower
-following
when someone follows any other user, I add a record with follower user ...
2
votes
2answers
394 views
Why OTServs have an item cloning problem if the server crashes? [closed]
OTServs are open source MMORPGs with a huge community. Mostly all of them have a serious problem: if the server crashes, people can clone items. This is a dirty trick that can be executed because the ...
8
votes
2answers
2k views
self referencing tables, good or bad?
Representing geographical locations within an application, the design of the underlying data model suggests two clear options (or maybe more?).
One table with a self referencing parent_id column
uk - ...
1
vote
3answers
1k views
Storing Attendance Data in database
So i have to store daily attendance of employees of my organisation from my application . The part where I need some help is, the efficient way to store attendance data. After some research and brain ...
4
votes
2answers
266 views
Proper Data Structure for Commentable Comments
Been struggling with this on an architectural level.
I have an object which can be commented on, let's call it a Post. Every post has a unique ID.
Now I want to comment on that Post, and I can use ...
1
vote
2answers
103 views
Cataloging events, projects and tasks: Is SQL appropriate?
I have this idea for a database: it would hold everything I "need to remember", and allow future coding projects to access the information. These future projects include a day-planner and historical ...
5
votes
5answers
1k views
Two database fields for date and time - should they be merged?
In the following question, field and table names have been changed to protect their identities.
If I have two database columns:
MONKEY_DATE DATETIME NULL (with data e.g. 2012-05-14 00:00:00.000)
...
3
votes
2answers
236 views
two approaches to database modeling - which one to use when
recently I have noticed a new approach to data modeling vs what I have used so far. This seems to be a way to address modeling of an entity that has a very large set of fields and quite often many of ...
1
vote
5answers
576 views
Worst practices in developing database applications [closed]
In constrast to
http://programmers.stackexchange.com/questions/123591/database-design-good-practices
I wanted to ask:
What are the top worst practises you encountered when having to work with other ...
6
votes
2answers
327 views
What are some useful resources for learning tuple calculus?
I've been trying to go over my tuple calculus over and over again. What's worse is that my professor and tutors are not much help during their hours.
Does anyone know a good place to learn about ...
2
votes
2answers
167 views
Are there standard strategies for defining job flow and dependencies?
I'm working on a project that involves the chaining of separate jobs into a single master job, though there may be parallel paths in the chain leading up to the final output. Job and chain details ...
5
votes
2answers
162 views
Storing stop/start points in a database
Let's say I am storing start and stop points per user into a database table.
For example... let's say in a chat system, a user only needs to see lines 24-293, and 500-512. (Let's say he logged off ...
4
votes
2answers
3k views
Why NoSQL over SQL? [duplicate]
Possible Duplicate:
When would someone use MongoDB (or similar) over traditional RDMS?
How well the SQL and NoSQL go head-to-head. I read somewhere that SQL databases are not well for data ...
2
votes
2answers
497 views
Database for storing books by grouping, their pages, and the table of contents
I'm looking for a better way to deal with the design I have here, I'm not confident it's really suitable.
To give this some context, lets say we have a bunch of groups, one group could be "SQL", and ...
4
votes
6answers
126 views
Arguments for storing binary asociations in a single field vs. in a mapping table?
When do you draw the line between relational tables, and fields holding multiple values of a particular type. Let me illustrate in an example below where a PokeMaster can be associated to multiple ...
6
votes
3answers
422 views
Types of databases
I read that there exists three main types of databases
* Transactional (Client-Server database// OLTP database)
* Decision support system (DSS) (Data warehouse database // Data mart // Reporting ...
20
votes
6answers
930 views
Does the advent of the SSD have any implication for database optimization?
Today I was browsing through a book on SQL Server optimization and it seemed that a certain amount of the ideas were based on a linear model of storage. As SSDs have a completely different storage ...
8
votes
3answers
1k views
Storing n-gram data
(hopefully I landed on the right stack exchange site)
I was hoping to brainstorm a little bit on the subject of storing n-gram data.
In my project, I am trying to solve linguistic problems where I ...
6
votes
6answers
694 views
Is the “One Description Table to rule them all” approch good?
Long ago, I worked (as a client) with a software which use a centralized table for it's codified element.
Here, as far as I remember, how the table look like :
Table_Name (PK)
Field_Name (PK)
Code ...
1
vote
1answer
434 views
DB Schema for ACL involving 3 subdomains
I am trying to design a database schema for a web app which has 3 subdomains: a) internal employees b) clients c) contractors. The users will be able to communicate with each other to some degree, ...
