I am designing the database of a website and I have noticed that stackoverflow adopts openID which is very impressive. But what if some users use email address which doesn't support openID. What do you think of this issue? ...
Maybe the solution is obvious, but I cant seem to find a good one. In my upcoming project, there will be one main table, its data will be read frequently. Update / Insert / Delete speed is not an issue. The items in that main table are associated to 4 or more categories. An item can have 50 - 100 or more relations within one category...
Hi, all I want to use an example to explain what I want. Assume I've following DB design: Item (id, name, categoryID); Category (id, name); When user wants to create an Item (fill in form), I'll give a list of categories in a dropdownlist, and when user chooses one of the categories ASP.NET MVC will automatically bind categoryID, to...
I am trying to implement a Faceted search or tagging with multiple-tag filtering. In the faceted navigation, only not-empty categories are displayed and the number of items in the category that are also matching already applied criteria is presented in parenthesis. I can get all items having assigned categories using INNER JOINs and ge...
Are there any examples of a before/after of what a database looks like when going from a traditional db to simpledb? ...
I'm working on creating a membership-based web application. In order to become a member, you must fill out a lengthy membership application that qualifies your business. Once the application is complete, it goes to the admin of the site for approval. The application contains about 60 or so questions to be answered. Perhaps 25% of those q...
I've been reading a lot about Relational Databases using many JOIN statements on every SELECT. However, I've been wondering if there's any performance problem on the long run when abusing this method. For example, lets say we have a users table. I would usually add the "most used" data, instead of doing any extra JOINs. When I say the "...
Hey, I was wondering if there is a general database structure for the following situation. In my web app, there are users and projects. Now, whenever a project is created or modified, all users who have not seen that new / modified project yet have to be notified in some way (e.g. an icon in front of the project title or something) ...
Hi, sorry if this question has been asked before, I searched but wasn't sure on the proper name for what I'm looking for. I'm pretty much a newcomer to rails and development in general, I've done some hacky programming but I wouldn't say I know what I'm doing. I've always been at a loss on how to define "types" in my Rails models and in...
Hi everyone, I have made few projects (CMS and EC system) that required to have some data versioned. Usually I come with that kind of schema +--------------+ + foobar + +--------------+ + foobar_id + + version + +--------------+ it worked great but I am wondering if there is a better to way do it. The main problem wi...
I am trying to see what is the best way to handle the following scenario I have a table called, lets say User, and i have a table called items. Each user can have multiple items added to his account. I have another table , lets say AssociateItem, which maintains the association between user and the items. (links UserID to ItemID). A us...
We're looking for a visual modeling tool for SQL Server that allows for forward-engineering from the model to DDL. Erwin works great but is unavailable on this project, so we're looking for alternatives, an open source program would be ideal. We also have VSTS Database Edition, but it does not appear to allow for this type of functiona...
Exactly how far do you normalize the example below, and exactly which level of normalization does this example meet? CREATE TABLE "public"."contact_info" ( "id" SERIAL, "home_phone" TEXT, "mobile_phone" TEXT, "work_phone" TEXT, "fax_phone" TEXT, "email" TEXT, "line1" TEXT, "line2" TEXT, "city" TEXT, "state_i...
I have an Table USER (USER_ID, PASSWORD, NAME, ...) and an Table ACCESS_ROLES for the Users, every user can have one ACCESS_ROLE (ONE-TO-ONE). Wich table has the Foreign Key? I would put the USER_ID into ACCESS_ROLES table. Is there any best practice approach? ...
Imaging the following 3 relationships in a data model Entity > Path > Link Both relationships are 1 to many. So Entity has multiple paths and a path has multiple links. Should I do this as 3 tables with relationships between the tables Or create a table that stores that path information as XML. This table (lets call it Paths), will...
First, my table layout: tblEquippedItems: <-(table name) slotid (FK), itemid (FK), charid (FK) <-(attributes) So I have this table that describes the items a character has equipped. Slot id refers to the item slot where the item, denoted by itemid resides. Charid describes the character that has these items equipped. What I'd like to ...
I'm brainstorming an application to handle various data integrity checks. Each individual check could query a number of production tables, evaluate the results and report an error providing data relevant to the check. For example, one check would look for customers with a scheduled payment but no remaining balance; a different check mi...
I'm having trouble deciding on how exactly to represent location data in a project I'm starting. The data is essentially a floor plan, with things existing at points. My first approach was to create a Point class which things will ForeignKey to. However, I quickly realized several problems. The first is that I need a way to represent...
User table contains the following attributes (dateOfBirth, race, gender, ...). We would like to generate a report in the following format. Year Race All Male Female 2000 Asian 2000 1000 1000 2000 Hispanic 1000 500 500 2001 Asian 1500 700 800 2001 Hispanic 1300 400 900 ... Total 5800 2600 3200 Ideally I would like to...
I recently ran across a very interesting problem involving database design. I have changed the table names to simplify the problem, so let me describe it as such: I have 2 tables, fruit and vegetable each stores whether or not a fruit or vegetable is tasty. Now lets say that someone keeps changing the IsTasty setting through the UI of m...