Tagged Questions

Database design is the process of specifying the logical and/or physical parts of a database. The goal of database design is to make a representation of some "universe of discourse" - the types of facts, business rules and other requirements that the database is intended to model.

learn more… | top users | synonyms (3)

2
votes
0answers
13 views

Database solution for static time-series data

We have a large and growing dataset of experimental data taken from around 30,000 subjects. For each subject, there are several recordings of data. Within each recording, there is a collection several ...
2
votes
0answers
142 views

Nested Sets with rational numbers on Redis

I'm tried to implement a nested set DB model on Redis with rational number how is described in this paper http://arxiv.org/abs/0806.3115 But, after two weeks of study, I'm stuck with design... here ...
2
votes
0answers
123 views

How to handle this hierarchy in Entity Framework

I have a particular sort of data model that has to use a closure table due to the fact that nearly every material_composite is the root of its own tree, but can also be in the hierarchy of any other ...
2
votes
0answers
109 views

Should I create a separate user table for different web products within the same platform?

We have a web product for young professional that gives them the possibility to create their page to show their professional identity. So a table users that has both information about the user (email, ...
2
votes
0answers
92 views

what is the logic behind facebook group notification?

i want to know what is the logic of facebook group notification and how it works? if one user turn off the notification than what kind of process under goes so that user will not get the notification ...
2
votes
0answers
118 views

Enterprise Architect: Hide only some Foreign Key Labels to all connectors at once

I am using Enterprise Architect 9 and I want do hide some Foreign Key Labels in all connectors, but not all. I'm using Associate connector often, and when I set foreign keys, it shows some labels I ...
2
votes
0answers
368 views

Some database design ideas for Activity Stream/Log per page

I'm building an activity log of users actions. But the main objective is to get all activities not per user, but per page (scope) its inside. I will explain more after. The main thing I'm concern ...
2
votes
0answers
533 views

WP7: EntitySet loading. One to many relation - composite primary key case

I'm creating application for Windows Phone and faced with a problem related to database handling. A part of designed database (approximately) looks like: two tables USER { ID } - ID is a primary key ...
2
votes
0answers
253 views

designing schema for huge tables in oracle

I have a user table, transaction table and user_transaction table. the number of users is around 75,000 number of unique transactions possible in the application is about (rows in transaction table is ...
2
votes
0answers
380 views

A better database plugin for Netbeans, other than the standard one

Netbeans has a database plugin, which you can add columns or tables, but it doesn't have options for mysql, such as autoincrement or foreign key management for innodb. Is there any alternatives to ...
2
votes
0answers
133 views

How to define empty polygon for spatial column in MySQL?

I'm trying to create spatial index over table column (bbox polygon default NULL) but get error: All parts of a SPATIAL index must be NOT NULL. Problem is that I supposed some rows would contain ...
2
votes
0answers
284 views

How can I do complex entity associations queries in doctrine 2? (virtual entity)

Let's say I have a blog application. The author can add multiple images to a post either by giving a link to a url of an existing image on the web, or upload a new image. I want to be able to back ...
1
vote
0answers
17 views

Rails complex association: has_and_belongs_to_many from two classes to one

In my application, I have a User model and Artist model. Both users and artists should be able to "follow" multiple artists. I'm not really sure how to describe this relationship, and I'm completely ...
1
vote
0answers
18 views

One Form with Fields from two Tables

I am very new to Access 2007 and am trying to create one form which has multiple tabs on it. Four of the tabs represent information from one table and two of the tabs represent information from a ...
1
vote
0answers
70 views

Database Schema for Pricing Products (packages, promotions, qty based, limited time offer…)

I'm working on a new point of sale for a company that products for different prices depending on the product mix. All products have a base price. To explain my problem, I will use the following ...

1 2 3 4 5 … 72
15 30 50 per page