2
votes
1answer
122 views

MongoDB data modelling: any drawbacks in using lots of databases?

I have recently moved to MongoDB part of the back-end of a web app, the web app itself is a validation tool, and the workflow looks like: the user uploads a file (typically hundreds of thousands of ...
2
votes
1answer
136 views

2 Way Friendship between different models

Ruby on Rails App. I have two kinds of users, Company has_many :employees #sample Employee has_one :company I want to create friendships between these two models, keeping track of the requester ...
2
votes
1answer
116 views

Database model verification

I am trying to build an app where users will be able to transfer tokens for games between each other. Right now I have this design in mind database design link Each party will only have one ...
2
votes
1answer
199 views

What are some good, free data modeler programs available for Linux that work with SQLAlchemy?

I am looking for some good, free data modeler programs for Linux that are painless to install and work with SQLAlchemy. Any ideas?
0
votes
1answer
63 views

Triggers or T-SQL?

I am trying to make notification system for my website: This is the table structure notification ----------------- id (pk) userid notification_type (for complexity like notifications for pictures, ...
0
votes
1answer
80 views

What are the pros and cons of mixing data with metadata?

Let's say I have a table such as: CREATE TABLE t1 ( col1 int, col2 int ); and a "metadata table" classifying these attributes: CREATE TABLE t2 ( attribute varchar, description varchar ); ...
0
votes
1answer
113 views

Providing create table feature over GUI

I am developing a web application in which a user can Create a table in data base. I am thinking on taking the attribute names and table description from user and put them into SQL query and execute ...
3
votes
0answers
70 views

Database design to store and evaluate rules expression

I have a scenario where I need to assign some Items to a Guest. GuestTable has columns like 1. Guest ID 2. GuestType 3. Age 4. Height 5. Gender ItemTable has columns like 1. ItemID 2. Item Name ...
1
vote
0answers
251 views

ERWIN create and use database

Im trying to generate physical database from my logical model using ERWIN 7. All is well in the script that is generated automatically, there is only the problem that the model is created in the ...
1
vote
0answers
122 views

Model/Specification describing a key-value database

I am looking for a formal/semi-formal way to describe the model of a database using a key-value approach (e.g. Redis). I guess it all comes down to describing the naming scheme (what to expect for ...
0
votes
0answers
32 views

IBM Infosphere Data Architect or Data Modeler, possible to diff two logical- or physical models, or DDL:s?

We have one production SVN branch with our IBM DB2 physical and logical models, as well as their corresponding generated DDL scripts. This schema is in production. We then have another SVN branch ...
0
votes
0answers
86 views

How to design many to many complex relationships

I am designing a mysql database but I do not know exactly how to express some concepts. Basically, the key facts are: Each license_owner may allow different roles; Each corrispondence between role ...
0
votes
0answers
23 views

script-driven database modelling tool

I am looking for a database modelling tool (for PostgreSQL preferably) where the generation of the SQL DDL file can be accomplished in a headless / scripted way. That would allow me to place the ...
0
votes
0answers
89 views

Free or affordable er-modeller supporting domains

I've been using Powerdesigner at one of my previous employers and I'm looking for a cheaper alternative thats actually usable. Now I have to create some ER models. I have to option to update our ...
0
votes
0answers
44 views

SQL guidance on CancelledOn or Disabled?

I am recreating some SQL tables for a rewrite of an existing program. One of the current tables holds Company info including columns for StartedOn, CancelledOn and Disabled. I cannot find anything ...

1 2
15 30 50 per page