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)

0
votes
0answers
3 views

ER: matches between 2 teams modellation is too difficult to implement

I'm modelling a database to manage computer games matches. Two teams fight on one or more maps. In each one they get some points, and the winner is who won more maps. I modelled it in this way (and ...
0
votes
0answers
6 views

Doctrine 2 : Multiple relations between two tables

I have a problem more concerning database relations than Doctrine itself. I have a table "project" and a table "project_data". My table "project_data" is ALWAYS linked to a project entry. However, in ...
-1
votes
0answers
11 views

Dynamic CSS changeable from website`s CMS

The situation: I have a website with a single template (css,images,HTML,js). Also have and a CMS connected to the website. My customer wants to dynamically change everything from the website's ...
0
votes
1answer
25 views

Is a search engine for a specific website a hadoop use-case?

I am formalizing a plan to write a search engine for reddit, partly for learning and partly for personal usage. I want to be able to search through comments, users and subreddits. On the data side of ...
0
votes
0answers
9 views

Connecting two data repositories on two different sites

I have two websites, say website A and website B. I have n data repositories on website A and m data repositories sitting on website B. How do i connect data repositories of A to data repositories of ...
0
votes
1answer
35 views

ASP Entity Framework - Code FIrst - Data Design - Keys

I am attempting to structure my database appropriately for my web application. I am unsure the correct way to proceed with the keys and relationships. Basically.. My project contains a Product Which ...
0
votes
1answer
19 views

Friendly Names in linking database, add database column or use converter in application?

I have a WPF application using the MVVM pattern and MVVM Light Tookkit that is accesing a MSSQL server. Below would be a sample database (the database I have is more complex): Employee Table: |Name ...
0
votes
0answers
11 views

Cassandra Data Model Options, Lots of columns of all potential Reading Types, or Map Collection?

We are planning to store time series sensor data in Cassandra. Each sensor can have multiple data points per sample time point. I'd like to store all the data points per device together. One ...
1
vote
0answers
58 views

Database design recommendation

I am trying to populate a workout from a list in a database. For example, the Bicep Curl machine has these sets and reps: bicep curl machine sets 1 reps 50 bicep curl machine sets 2 reps 25 ...
0
votes
0answers
5 views

using enums in the table designer

I'm designing a data base using the table designer in VS 2010 pro, then generating code with sqlmetal. I want to use a enum as a type in one of the columns. Is this possible? how?
0
votes
0answers
16 views

Rails 3 Two application using same database (Pointing to one) [on hold]

I have two rails application running in rails 3. One is running in ipad and other is traditional web appliapplication. Both application is using the same database.Both are pointing to the one database ...
0
votes
1answer
33 views

Most efficient way to pull items from database based on their x,y location in a grid

I'm working on an iOS game where players villages are displayed on a large kingdom map. Each village has a x,y location on that map, and each village is stored as an object in a database on a server ...
0
votes
1answer
38 views

sql database design - select & check boxes [on hold]

I am designing a database for a form which contains many select boxes and check boxes lists. I am unsure whether to populate these lists from a table in the database or from the select html text. ...
-1
votes
1answer
47 views

what is the best approach to store keywords inside database, language agnostic

My question title is self explanatory. I'm aware that there is no exact answer on this subject cause it depends on many subjects but if you have time to share ideas and thought on how would you ...
-3
votes
0answers
26 views

How to design DB for statistics service? [on hold]

I'm going to create statistics on RoR. I have 3 models: User, Project, Channel, ChannelItem. User owns Projects, whereas Projects have many Channels. Now I'm designing all these models using MySQL. ...

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