Stack Overflow
Stack Overflow

Questions tagged [data-modeling]

Data modeling questions refer to the techniques used to gather and analyze data requirements needed to support data operations in programs and systems.

Data modeling consist of gathering requirements and knowledge about the data needed to solve a given problem, and elaborating abstract data structures for the purpose of designing and implementing standardised data formats, databases and data processing systems.

Data-modeling is a specialized kind of modeling solely focused on passive data structures, and independent of the description of the processing of that data.

3039 questions
1
vote
3 answers

Modeling Data in Hadoop

Currently I am bringing into Hadoop around 10 tables from an EDW (Enterprise Data Warehouse), these tables are closely related to a Star Schema model. I'm usig Sqoop to bring all these tables across, resulting in 10 directories containing csv…
Chad Gorshing
  • 2,998
  • 32
  • 30
1
vote
6 answers

Database design software for a student?

I am taking a database class and have to draw a bunch of different kinds of diagrams. Specifically, I need to draw ERD and dependency diagrams. The instructor does not want any hand drawn diagrams but does not offer any clue as to what software to…
ProgrammingPope
  • 2,177
  • 4
  • 23
  • 36
1
vote
1 answer

Modelisation of a star schema DB for a pentaho project (mysql workbench or schema workbench)?

I'm working on a BI project where I'm gonna use pentaho. I'm currently deisgning the DB. I know that in pentaho I need schema workbench to create my cubes and "universe" for the final users. Can I first use mysql workbench to create and modelise my…
joris
  • 435
  • 1
  • 7
  • 18
1
vote
2 answers

Venue/Event Booking Database Design

I am task with designing a database for online bookings. I am not looking for a full design as we have had previous exp with online house rental. What i would like to know, is how do we design a db for booking of hotel, travel, events. We have some…
Adriaan Stander
  • 162,879
  • 31
  • 289
  • 284
1
vote
5 answers

Database design question regarding multiple one-to-many relationships and foreign keys

In my database there are four databases: Teachers, Students, Parents and Addresses. Teachers, students, parents can have any number of addresses (zero or more). I would like to use foreign keys to link between teachers and their addresses (and…
Sleepster
  • 1,150
  • 1
  • 17
  • 24
1
vote
1 answer

Modeling Complex Relationships in Django

Okay, here's a challenge, Djangonistas! My let's say my project has 3 types of data. Project Audio Video Projects can have references to an unlimited number of Video and Audio objects, as well as unlimited references to other Projects. What is the…
Rich Jones
  • 1,422
  • 1
  • 15
  • 17
1
vote
1 answer

Build a model with 2 Foreign Keys to the Same Table

Lets say I have a User model and now I want to add a Friend model. I want to name my FK fields RequestorID and ResponderID. What data annotations or fluent api mappings do I need to accomplish this and prevent EF from autogenerating its own…
Jed Grant
  • 1,305
  • 1
  • 17
  • 47
1
vote
2 answers

"Read-Only" Entity Framework? I'm trying to use RIA Services, EF, and Silverlight

I'm trying to present MySQL server data in a silverlight client and my current plan of attack is to use Entity Framework to MySQL with RIA Services providing the data access between the Silverlight Client and Entity Framework. However, I'm only…
Ben McCormack
  • 32,086
  • 48
  • 148
  • 223
1
vote
3 answers

In symfony/doctrine's schema.yml, where should I put onDelete: CASCADE for a many-to-many relationship?

I have a many-to-many relationship defined in my Symfony (using doctrine) project between Orders and Upgrades (an Order can be associated with zero or more Upgrades, and an Upgrade can apply to zero or more Orders). # schema.yml Order: columns: …
nselikoff
  • 467
  • 4
  • 11
1
vote
1 answer

Single tenant, multiple application database design?

Most questions about tenancy are centered around multi-tenancy database design issues. I want to know about single tenancy but multiple applications. The software I'm developing allows for a single user to create, from a single code base, multiple…
jisaij
1
vote
5 answers

What are some methods for persisting customer configurable data in a database?

I'm looking for some ideas on methods for persisting customer configurable data in a relational database (SQL Server 2000 in my case). For example let's say you have a standard order entry application where your customer enters a product they want…
Stimy
  • 1,491
  • 3
  • 15
  • 36
1
vote
7 answers

Help with db schema?

I am creating a simple blog app and so far I have 3 tables, Posts, Comments, and Authors. I will just list the primary key for each table as well as a foreign key. Posts will contain postid as a primary key. Comments will contain commentid as a…
Xaisoft
  • 45,655
  • 87
  • 279
  • 432
1
vote
0 answers

AppEngine position of row in result set

I'm working on an App with a leader board, the leader board is updated constantly. When I display the leader board, I do so by applying sort order over multiple columns. What I want to do though, is with the sorting in place, work out where a…
Chris
  • 2,739
  • 4
  • 29
  • 57
1
vote
2 answers

Can Erwin "guess" relationships during reverse engineering (there are no PK/FKs defined in db)

We are embarking upon a Legacy Data Migration project, and in the process of understanding our source database better, we are trying to build a db model out of it. We dont have any information about the Primary/foreign keys in the db. We are still…
Raghav
  • 2,128
  • 5
  • 27
  • 46
1
vote
1 answer

Entity Framework Model Multiple Table to Single Entity

I've two tables named Modules and Privileges which are related by a foreign key relationship as shown below: (source: baburajpb at sites.google.com) I'd like to model Module and Privilege by adding ModuleName to Privilege. Later I'd be interested…
Raj
  • 4,405
  • 13
  • 59
  • 74
1 2 3
…
99
100