A good database modeling tool?
Could you guys recommend me a good db modeling tool? Mainly for SQL Server... thanks! ...
database-modeling
Database : best way to model a spreadsheet
I am trying to figure out the best way to model a spreadsheet (from the database point of view), taking into account : The spreadsheet can contain a variable number of rows. The spreadsheet can contain a variable number of columns. Each column can contain one single value, but its type is unknown (integer, date, string). It has to be e...
Visiomodeler/NORMA - Object Role Modeling (the other ORM) - who uses it?
For a number of years I've used Object Role Modeling to design and validate my database schema designs. (The appurtenant software products have been variously named Visiomodeler, Infomodeler, Visual Studio Enterprise Architect ORM Studio, etc.) It's the only truly conceptual database modeling tool I've ever found to be at all useful; in...
database modeling mac app for ruby on rails development
Hello, I am building web applications using Ruby on Rails and I would like to know what's the best tool for OS X to mock a new application from a functionality perspective and not graphic design. I would like to be able to get an idea of what the application will require in terms of resources before starting to write the code. Thanks, ...
Where is the line between DAL and ORM?
The terms are often thrown around interchangeably, and there's clearly considerable overlap, but just as often it seems implied that people see something strongly implied by saying that a system is an ORM that isn't implied by it being a DAL. What is that? What, if any, are the key points that differentiate these types of system? For ...
Dynamic Types within a Relational Model using Object-Role-Modeling (ORM)
In Object Role Modeling (ORM), given an entity of thing that had a relationship to an entity of type and where the type entity can be specified to live and the thing entity could have a value for date of birth, how would I specify a constraint that would exclude instances of thing from having a value for date of birth if the instance of ...
Who is the Fielding of Temporal Database modeling?
It doesn't take very much reading on REST before you run across Fielding and his dissertation IF you've had some wins with temporal modeling within the confines of a relational store Who are the big names in the field that you referenced? ...
How would you model this database relationship?
I'm modeling a database relationship in django, and I'd like to have other opinions. The relationship is kind of a two-to-many relationship. For example, a patient can have two physicians: an attending and a primary. A physician obviously has many patients. The application does need to know which one is which; further, there are cases w...
How can I show relationships between views in Visio database diagrams?
I'm using a set of views for the data access layer of our primary web application, and need to document these views. Logically the views mirror the underlying tables, meaning they have similar relationships to the tables. (It's a bit more complex, since the views are pulling data from 3 databases...) So I opened up Visio and reverse e...
Non-relational database modeling tool?
Hey guys, please recommend some tools you have used succesfully on DW, DataMart, BI an non-relational modeling. Example for automatic creation of snow-flake Schemas, dimensions and facts tables. Wich tools makes you sense familiarity with the diagrams and surrogates keys and it will have the option for export or connect to SQL Server 200...
Whats the difference between Object Role Modeling and Object-relational mapping?
I have learn about Object role modeling but not about Object-relational mapping and I want to know if they are two ways of doing the same thing and what are the pros and cons? To me Object role modeling makes a lot more sense. Could you make a brief but easy to understand comparison if they can be compared. Cheers ...
What are best database-modeling tools available in general and specifically for MySQL ?
Hi, I have tried searching other SO Questions but not found the answer am looking for and so am posting question here. My question is regarding what are the best database modeling tools available in general and what database modeling tools are available specifically for MySQL Database. Thanks. ...
What are the general guidelines and best practices to keep in mind while designing database for an application ?
Hi, My questions is regarding Database Modeling. I tried to look for this question amongst other Database Designing questions on SO but haven't found it and so here am asking about: What are the general guidelines and best practices to keep in mind while designing database for an application ? What are the best resources/books/Univer...
MySQL Column Unification, any performance improvements?
I'm designing a MySQL table for an authentication system for a high-traffic personal website. Every time a user comment, article, etc is displayed the following fields will be needed: login User Display User Bio ( A little signature ) Website Account YouTube Account Twitter Account Facebook Account Lastfm Account So everything is in ...
Should I model with an association table for future flexibility?
This is a database modeling question. I normally model one-to-many with a standard parent-child table setup, and I normally model many-to-many with an association table between the 2 tables. In this one case, the current requirement calls for a one-to-many relationship. But the client was talking about some potential future requiremen...
Which project type / item in VSTS 2008 helps me model a database?
Hello. As per the thread: http://www.experts-exchange.com/Microsoft/Applications/Microsoft%5FVisio/Q%5F24660513.html I should be able to model a database (like I do in Visio 2007) in Visual Studio Team System 2008. I am unable to find how to achieve this. In no project type am I able to find an item that helps me create a Database Model....
How do I best combine and optimize these two queries?
Here is my main query which pulls in thread information as one row, it lacks the # of votes and currently I'm pulling that in with a second query. SELECT Group_concat(t.tag_name) AS `tags`, `p`.`thread_id`, `p`.`thread_name`, `p`.`thread_description`, `p`.`thread_owner_id`, `p`.`thread_view...
PostgreSQL 8.3 data types: xml vs varchar
There's xml data type in Postgres, I never used it before so I'd like to hear opinions. Downsides and upsides vs using regular varchar (or Text) column to store xml. The text I'm going to store is xml, well-formed, UTF-8. No need to search by it (I've read searching by xml is slow). This XML actually is data prepared for PDF generation...
Best mySql management tool?
I am looking for a complete integrated mySQL management / admin tool (hopefully that can run in Linux). I need the ability to graphically model my tables and relationships (reverse/forward engineering would be great). I also need a tool with good data management options (i.e. basic crud). I have tried MySql workbench and it is great f...
Creating a db driven primary navigation in django?
I find that it's pretty common most people hardcode the navigation into their templates, but I'm dealing with a pretty dynamic news site which might be better off if the primary nav was db driven. So I was thinking of having a Navigation model where each row would be a link. link_id INT primary key link_name varchar(255) url varchar(2...