The logical model and/or physical design of a database.

learn more… | top users | synonyms (4)

2
votes
2answers
67 views

Using floats for PKs. Is it a good idea?

Let's say I have an entity PizzaStore which has a location as part of its attributes Now a PizzaStore can have N of other PizzaStore that are close by. So seems to be a self referencing relationship 1-...
0
votes
2answers
34 views

Question when designing a database

I have started to design a database for a company which I work for. I am curious how the professionals would design such a database and what advice you might carry. Information about the database: ...
0
votes
1answer
181 views

Database design for products with multiple units

I am designing a database for retail business. There are some products that can be sold in multiple units, for example, pencils can be sold in ea and dozen, paper can be sold in sheet, ream, and ...
0
votes
2answers
34 views

Storing multiple contact addresses for a person

Simplified diagram for reference. My database stores information about people in the following way. There is a Person table containing common personal information fields; name, date of birth, ...
0
votes
1answer
34 views

Review the Design of My RDBMS (MySQL 5.6)

I am developing a web application for conducting Phishing Awareness testing (Github Repo). I have been getting tons of feedback on CR.SE to this project. It can be referenced if you want to get a more ...
1
vote
2answers
27 views

Biggest possible double/float for a column in my MySQL database

I am developing a PHP application in which I am in need to store values bigger than 1 million, but with the flexibility of having floating points. I know the traditional float and double. I am looking ...
1
vote
1answer
11 views

Ternary Relationship or (n-ary)

I'm trying to find the difference in terms of modeling a ternary relationship v/s a binary relationship in the following case. Any piece of advise would help me a lot. Company has editors who are ...
0
votes
1answer
22 views

Make MongoDB close open files

I am currently trialing numerous database designs (to solve this problem: Large (>22 trillion items) geospatial dataset with rapid (<1s) read query performance), and my latest design in Mongo ...
0
votes
0answers
24 views

How to delete data which violates the DB design

I am searching for tool/utility or a way to clear database of parasite information. The database is of over 250 tables so manual fixing is not acceptable. The database was running over the years with ...
0
votes
1answer
17 views

MySQL. Relationships

Thanks in advance for your answer. I am trying to tune my db skills. I have 3 tables: Brand, Model and Item. All models belongs to a brand, but an item can have a brand but not a model. I have 2 ...
1
vote
1answer
18 views

MySQL. Default length for a field

Is there a list of already set standards for some common fields like: firstName, lastName, email, phone? I see most people just set varchar(300) to all fields, does it affect performance in any way?
0
votes
1answer
28 views

stored procedure logic,data flow visualization tool [on hold]

I have a very poorly written stored procedure with cursors, if else etc. Is there any toll available to visualise the logic and data flow? Thanks
0
votes
0answers
19 views

Database design for user info [on hold]

I am working on a django app and would love so help on a design issue I cant seem to wrap my head around. Basic Info The landing page of my app will show a table of all registered users which will ...
0
votes
3answers
57 views

Is GUID(uniqueidentifier) not suitable for a clustered index? [on hold]

When i use uniqueidentifier datatype for primary key column then it will automatically create clustered index... So, will it slow down my queries or not ? I am explaining some description of my ...
0
votes
2answers
38 views

Financial Statement table

I want to ask about database design for financial statement. I want to combine balance sheet, profit loss, cash flow,and ratio into one big table since each statement is dependent each other. Here ...
0
votes
0answers
15 views

Confusion of Time Stamping Protocol and Two Phase Locking Protocol in schedule

I'm wondering if someone helps me. Actually, I have a little confusion in Concurrency Control Time stamping protocol and Two-Phase locking protocol in a transaction schedule. I have found this ...
1
vote
1answer
26 views

Visual Studio Database Project

I work in a company that is deeply ingrained in .Net programming. I am responsible for managing a couple SQL Servers, with about a dozen databases in total. Our programming manager recently ...
1
vote
1answer
161 views

How to efficiently design MongoDB database for Uber-like application?

I'm designing a MongoDB database for an Uber-like application, but since I'm new to NoSQL concept, I have several doubts. I have three main collections - users, requests and messages. User can post a ...
0
votes
1answer
50 views

Database design considerations for unused columns with every table has same schema

I am a web developer so I don't know a lot about databases. The company I joined recently has a very mature Desktop ERP built in .NET and SQL Server, they are providing services to huge corporate ...
2
votes
1answer
153 views

Save different account types in a database

I have the following issue. In one application (imagine a messaging/e-mail app on your smartphone), the user enters its accounts and gets information from the server displayed. I need to store the ...
0
votes
1answer
17 views

Modeling Optional Column

I've got an optional column (residential) in one of my tables that is giving me trouble. If a Licensee intends to work w/ residential customers, they need to take an additional course (...
3
votes
1answer
353 views

PizzaShop - DB - Normalized Schema

I am trying to make a simple DB in Access for a theoretical pizza shop(the db is for an assignment). What I am trying to do is link one type of pizza to one or more types of toppings. I just wanted a ...
0
votes
1answer
22 views

Is a meta table useful

Lets say a lot of my tables will have the same few columns for example a name, description, created timestamp, last updated timestamp. When is it appropriate to put these common columns in a separate ...
1
vote
1answer
139 views

How to store likes to posts in Parse.com database?

In my parse database I have a classed called Post and Like. Should I create a field likes in Post class with Relation<Like> type or there is another better option of storing likes in Parse DB?
0
votes
2answers
24 views

Design: Multiple Values in One Column or Many Columns?

I am designing a database based on NBA stats. For a particular part, I have: Game: [ Id, HomeTeam, AwayTeam, Date, GameTime … ] GameScore: [ Id, GameId(FK), QuarterOne, QuarterTwo … ] For game ...
0
votes
0answers
13 views

Design: Available domain database

I'm building website and service that will allow user to check if given domain is available. Right now I'm thinking about good way to store result from whois, but i dont want to store whole response ...
5
votes
3answers
107 views

Normalize repeated indefinite ongoing dates for an event

I am designing a calendar database that has a lot of booking and billing information. The database itself consists of form records, which are editable, and only when an event is confirmed by staff it ...
5
votes
1answer
1k views

How to use a relational database to store all users who belong to a group, and all groups which a user belongs to?

This is a beginner question: A user can belong to many groups, and a group can contain many users. Let's say the two tables look something like this: user_id user_name user_email group_id ...
0
votes
0answers
16 views

English Dictionary Database Design

English words can have the same spelling but different meaning. If I design a database table for an English word what is the best way to different words that have the same spelling but different ...
0
votes
0answers
13 views

Access 2013 and VBA

Guys just joined and i have the problem and i hope you guys can help me. I have two tables one called File Cabinet Table and Request Table, and three forms In-Take Re-retrieve and request. Basically ...
1
vote
1answer
139 views

Slot Time Challenge - Doctor Appointment database schema

I am trying to make a doctor appointment system where patient online will have two options: First time visit (this visit should be 20 mins) Follow up visit (this visit should be 10 mins) ...
3
votes
2answers
50 views

Using Hashes as Unique ID

I am creating a database that will hold a number of transaction records. I was wondering if it is a good idea or good practice to use a hash function that can be replicated easily for verification as ...
1
vote
1answer
74 views

Primary Index VS Unique Index Performance

I have the following table: CREATE TABLE `actions` ( `user_id_from` int(11) unsigned NOT NULL, `user_id_to` int(11) unsigned NOT NULL, `action_type` int(11) NOT NULL, `counter` smallint(11) ...
0
votes
1answer
225 views

How to setup sync between MongoDB and C# .NET Application

What is the best practice to synchronize a MongoDB remote database with a C# .NET App that would allow queries to be responded to within the local file system and update itself when there is a change ...
0
votes
0answers
19 views

Database design for login statistic over few years on AWS

Actually on a project I'm working on we are using MongoDB for statistics but it's not working like we want. It's too slow and we have to make too many aggregate tasks to get fast results. Login ...
1
vote
1answer
37 views

Database planning… avoiding parallel fields

this is my first post here. I'm a programmer and lately I've had an interest in databases. I'm working on a side project and would like some tips as how to best construct my database. Here's the ...
12
votes
3answers
9k views

Best way to design tournament database

I'm creating a webpage for placing bets on all matches of the upcoming Euro 2012 football tournament. Need some help deciding what approach to take for the knockout phase. I have created a mockup ...
0
votes
0answers
18 views

visualize sqlite database schemas

Is there a way to genarate a visualisation of a large database? I want to visualize the database structure of matrix-synapse somehow, maybe there is a way to get an overview over the database somehow?...
0
votes
1answer
23 views

design a database which each invoice is made at the end of the month [closed]

Each customer has different item prices, so i've made 3 tables: CUSTOMER(*customerID, customerName) PRICE(*customerID, *itemID, price) ITEM(*itemID, itemName) But each customer will receive their ...
0
votes
0answers
37 views

pros and cons of partition or not-partition this sql server table that is highly hit?

I have a table that is highly hit on my database. this table has 370,370 records. when I run the following select: select [ImageSize] , the_num = count(*) from [dbo].[ProductImages] group by [...
0
votes
0answers
17 views

Contact database (like Facebooks friendlist) [closed]

I have to set up a platform with users for university and I'm currently thinking about how to design/set up a contact database like facebook? The trivial case would be a personal contact list (like a ...
0
votes
3answers
33 views

Person-Address = 1-1 or N-1 (In this context)?

I have 4 tables: Province (province_id, name) City (city_id, name, province_fk) Another Smaller subset under city say... City_sub (sub_id, name, city_fk) Address table (address_1, address_2, sub_fk, ...
0
votes
0answers
18 views

Super polymorphic event schema

I want to be able to track every action a user takes on my site. An action can originate from a visitor or a user (both of which are human). An action can affect a subject (visitor or a user) An ...
0
votes
1answer
727 views

“Entity Attribute code uniqueness” error in PowerDesigner

I am using PowerDesigner to do Conceptual Data modeling. If I use the same attribute name in more than one entities, I will get above error when I run "check model" or try to generate Logical Data ...
1
vote
1answer
17 views

Does Couchbase/CouchDB allow me to move / skip the CRUD middle man from the server?

So currently this is a common setup: Client -> Ajax -> Server CRUD -> Database Does Couchbase allow me to do this? Client -> Ajax -> Database This might be more technically correct: ...
1
vote
0answers
16 views

Modeling Multiaccounts + content interactions [closed]

I'm having trouble to model a scalable database schema with performance in mind. The requirements are wide, as such that I need a schema that supports; user can swith between multiple types of ...
3
votes
2answers
69 views

is “%LIKE%” faster than executing multiple queries?

for example, each user on my site has 2 phone numbers (i.e. let say 1234 and 6789) . but about performance , which is faster: to save the numbers in one column(separated by comma,like [1234,6789] ),...
3
votes
1answer
46 views

Online text based game design - Am I linking the databases correctly?

I'm trying to recreate an old game that I used to play that went offline quite some time ago. I'm doing this as a hobby project for myself with the hope that maybe a few hundred people might enjoy it ...
3
votes
1answer
27 views

How to decipher entity relationships in a Physical Data Model given the corresponding Logical Data Model

Can someone use the entity relationships in this Logical Data Model (LDM): to explain the entity relationships in this Physical Data Model (PDM): and how to specify the foreign keys in the PDM?
0
votes
2answers
34 views

General Database Optimizations - correct data types - why to avoid NULL? [closed]

Oracle recommends: Choose the correct data types and size to: – Avoid NULLs – Improve performance – Protect data – Use data compression where appropriate I don't understand why I need to avoid ...