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.
0
votes
0answers
8 views
Best Seller System Database Design
I am doing a online store. However, I have some problem when designing the database diagram.
Sorry for the inconvenient as I do not have enough reputation to post image.
Product: product ...
2
votes
2answers
152 views
multivalued weak key in ER database modeling
I was wondering since i didnt find out any clarification for this.
I want to store movies that exist in different formats (dvd, bluray etc) and the price for each format differs from each other as ...
1
vote
1answer
33 views
Database design: Two 1 to many relationships to the same table
I have to model a situation where I have a table Chequing_Account (which contains budget, iban number and other details of the account) which has to be related to two different tables Person and ...
0
votes
1answer
19 views
3nf but waste more storage space
I have a table which has three columns: account, idNumber, and position. The account and idNumber are unique.
Here is my thought to analyze and I don't know whether it is right or not.
account is ...
1
vote
1answer
153 views
Payment methods conceptual and logical model
I need to create a conceptual and logical (normalized) models of parking house according to the requirements below. It looks to me as a very simple concept that doesn't need all tables to have ...
0
votes
0answers
37 views
When to split a large table
I run the SQL Anywhere DBMS, and we have a table of about 10 columns(normal text, timestamps etc).
However, in my use-case, every single day, the table gets 2160000 new rows.
It's also crucial that ...
0
votes
2answers
36 views
Time series data for ad platform
I am trying to figure out how to store time series data for an ad platform I am working on.
Basically I want to know some strategies/solutions for storing billions of rows of data so that I can ...
2
votes
2answers
47 views
Recommendation for mySQL table structure (no code)
I need some advice on how to layout the tables for a mySQL database.
I will first describe what I am trying to do:
I have a table for users. (This covers basic info for now)
A user will select a ...
0
votes
1answer
13 views
Table Design for user-specific and user-agnostic criteria
I want to design a table that is general enough to accommodate an increasing number of achievements as I come up with new accomplishments to reward. Initially, I thought to design the table as ...
5
votes
1answer
211 views
effective mysql table/index design for 35 million rows+ table, with 200+ corresponding columns (double), any combination of which may be queried
I am looking for advice on table/index design for the following situation:
i have a large table (stock price history data, InnoDB, 35 million rows and growing) with a compound primary key (assetid ...
0
votes
1answer
46 views
MySQL database schema design help needed
I am developing a PHP application expecting millions of records both parent and children. My goal is to design an optimized database design to achieve high speed and performance.
This application ...
3
votes
0answers
69 views
Database table design question
Firstly, database novice here. I'm trying to create a system for processing Sales Orders into Purchase Orders and then split the Purchase Order into Shipping Containers. The systems needs to be able ...
0
votes
1answer
51 views
When is it worth it to use Triggers and stored procedures/functions? [closed]
As an example, lets say I have a forum application and for every topic that is created, I have a trigger that fires a database function creating a post.(lets assume we have a topics table and a post ...
2
votes
0answers
85 views
Where and how to store my weird datamart
I could really use some help here.
Here's my situation.
I'm building a datamart in SQL Server 2005, which will furnish a single report (for now). We have 26 clients (medical organizations) that ...
4
votes
1answer
92 views
Designing Simple Schema for Disaggregation of Demand Forecast
I am doing a simple database design task as a training exercise where I have to come up with a basic schema design for the following case:
I have a parent-child hierarchy of products (example, Raw ...
0
votes
4answers
31 views
Are all matching indexes (indices) searched for a query?
If I have multiple indexes that include a common attribute - will each index be searched upon a query involving this attribute? Or is only one index searched?
3
votes
1answer
46 views
How to share resources among accounts?
Using google doc, I am able to share my documents with others. I wonder how they implement it underlying in terms of DB design?
The simplest way I imagine is to use a joining table which keeps a ...
0
votes
1answer
188 views
Connecting to a SQL Server database from a Flash program
I currently have the ability to utilize Microsoft SQL Server 2012. I am developing a project with Adobe Flash Builder 4.7.
If I link my database with Adobe Flash Builder is there any additional ...
0
votes
2answers
37 views
Using a keywords table with multiple other tables
Using MySQL
I need help determining how to model a Keywords table to three different tables (Products, Certifications, and Exams) - I have included my model which is using what I refer to as ...
1
vote
0answers
52 views
Database Design: separating reusable & instance data
I'm developing an app which is basically a collection of checklists that have to be processed. I obviously need a database in which the information has to be stored. I just can't wrap my head around ...
-1
votes
1answer
47 views
DB Design - Which of the two is best-Normalized or Not [closed]
Please see the analysis below and let me know the best db design (InnoDB) out of the two.
Requirement- Faster Write and Read for users not having to wait when many concurrent DB connections exists, ...
2
votes
1answer
32 views
One database or multiple referencing one?
Database design: one database or multiple databases, which is best?
We have a database which has about a 100 or so tables, accessed by about five different applications. Five different applications ...
1
vote
1answer
34 views
Multi-variance products
My current system houses different variants of Products in different tables;
Productgroups
Productcolors
Productsizes
Productmodels
Products can reside under 1 Productgroup and can have ...
2
votes
3answers
178 views
Empty LONGTEXT or NULL?
In my MySQL DB I have one field called html_contents that contains all the html to be shown in a webpage. Obviously the html could be huge, and certaintly bigger than 64KB, therefore I decided to use ...
1
vote
2answers
86 views
Multiple SQL Server data files on same SAN disk
I'm currently in the process of creating a new database, and have previously only ever used a single data file and a single log file. I've done some research online regarding the benefits of multiple ...
0
votes
1answer
92 views
Efficient way to move rows across the tables?
This is somewhat long question as I would like to explain all details of the problem.
System Description
We have a queue of incoming messages from external system(s).
Messages are immediately stored ...
1
vote
2answers
84 views
Use single table with foreign key or two twin tables for text entries?
I have a table answers that has several columns including the content iself such as
ID | q_id | list_id | user_module_id | content |Â updated_timestamp
The content column is a varchar since we want ...
0
votes
1answer
25 views
How to “swap” out production tables in MySql
I have a MySQL table that holds a few thousand records which go out of date very quickly. A few times a day we run a slow process which needs to pull data from multiple sources and re-populate the ...
0
votes
1answer
41 views
MySQL DB Design
I am designing a db for a Social Network type website where users enter lot of information varying from family member details, education, employment, personal favorite such as TV, movie, music, food, ...
0
votes
2answers
48 views
Can a surrogate key and a primary key be in the same table?
For example we have:
Surrogate key: ABC123
Primary key: 1
Name: James
Is this legit in a Data Warehouse table?
0
votes
2answers
41 views
Column partially determining accepted values of another column, should be somehow normalized?
I have a table that describes a set of properties (yes it's metadata, in this case there's a valid reason to have it in the database); among other things I tell the type of the data that can be ...
0
votes
1answer
193 views
What is the difference between int(8) and int(5) in mysql?
I found out, that if you have a field defined as INT(8) without ZEROFILL it will behave exactly as INT(5)
in both cases the maximum value is
−2,147,483,648 to 2,147,483,647, from −(2^31) to 2^31 − 1
...
2
votes
2answers
43 views
notes / description string in another table in a relational database
I'm primarily a non-database developer, however I am familiar with normalization techniques.
A coworker was suggesting that it is correct for a table to store 'description' and 'notes' as a foreign ...
1
vote
1answer
72 views
Database Designing for a Ecomerce website
I am new to database designing. I am designing a database for an eCommerce website, there is a lot of products to be updated, but while designing for product specification table I do not understand ...
3
votes
2answers
44 views
Table design when one data is dependant of another and the second one has repeated values
I have a products, and subproducts.
Like:
Product Identifier - Product Name - Subproduct Identifier - SubProduct Name
1 ProA 1 SubProA1
...
0
votes
0answers
7 views
Fine grained (milliseconds) temporal indexes in neo4j
What are the best practices for modeling fine grained timelines in neo4j? If I were to use milliseconds as the grain in the pattern described here and here would it prove somehow problematic and ...
-2
votes
0answers
32 views
Database Design [closed]
I have a requirement like creation of database design for examination of school student.
There we have different types of exams like quarterly exam, half yearly exam and the final exam. For each class ...
3
votes
1answer
162 views
Applying user-defined fields to arbitrary entities in a SQL Server database
Currently we have an old (rather crude) system that has user defined fields, which are mapped against rows in arbitrary tables. This was an after-the-fact modification based on a customer request, and ...
34
votes
9answers
3k views
Files - in the database or not?
What is the best place for storing binary files that are related to data in your database? Should you:
Store in the database with a blob
Store on the filesystem with a link in the database
Store in ...
1
vote
1answer
61 views
What is the meaning of this anomaly warning message?
I have run an analysis with SchemaSpy.
The tool gave me a warning message for two tables. The warning message is:
Tables with incrementing column names, potentially indicating denormalization
...
0
votes
1answer
61 views
mysql - index optimization
I'm building a 'tag' system for my blog posts. Currently my tags table has columns tagid - MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY and tag VARCHAR(30) NOT NULL UNIQUE.
And I have another table ...
1
vote
1answer
100 views
Deriving formulas for input/output
I'm currently enrolled in a DBS class and am having problem with an assignment. I've searched around and have been unable to understand what it is I'm meant to be doing with this derivation formula.
...
1
vote
0answers
25 views
Need help to design model with multiple rights
For a website, I have multiple elements that need to be moderated by many different users.
Until now, I have always used Role-Based Access Control (RBAC) model but I want a more flexible model. I ...
8
votes
2answers
175 views
How to design this database to avoid cyclic dependency?
There are two tables:
User
Address
User contains a reference to Address.
Address contains the columns CreatedBy and ModifiedBy, which is reference to User.
How do I design this database to avoid ...
0
votes
1answer
31 views
How to link several tables in MySql?
I'm a newbie at Database Designing. What I want to do is perform several actions at once.
I have a main users table which holds all the data for a user at a website. Then I have a primary key as the ...
3
votes
3answers
67 views
pros/cons of different ways to store whether a record is one of two options?
I am trying to store whether an address is a Work address or a Home address. There will never be another type of address.
I'm wondering what the pros/cons are of the different ways to store this, ...
-1
votes
0answers
28 views
Do you know any data model archive website like this one? [closed]
I found this website with many data models... It's not bad actually, but just for curiosity, do you know any others site like this?
http://www.databaseanswers.org/data_models/index.htm
Thanks
3
votes
1answer
27 views
How should permissions for anonymous users be modelled?
I'm designing a web application. There will be users who log into the site, but also anonymous, non-authenticated users, i.e. any member of the public who accesses the site. Users will be assigned to ...
0
votes
2answers
83 views
Database design - do I need another table?
I am trying to make a database that follows a form that the company uses.
When a client walks in the membes of staff have to fill in a form and the data is recorded. The form on paper is 10 pages ...
2
votes
2answers
94 views
How can I improve my table design for different types of an entity?
Consider an accounting system as an example. I have an Entity called Client. Client can be of different types, with different fields applicable to different types. I consider creating separate tables ...
