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

learn more… | top users | synonyms (4)

0
votes
0answers
9 views

Database design for user info

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
47 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
35 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
24 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
159 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
47 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
151 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
15 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
352 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
105 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
131 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
46 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
73 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
224 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
16 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
725 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
33 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 ...
1
vote
1answer
221 views

Best practice to create a database schema for Open Auth (Social logins)

I've done a database schema for user management alongs with their roles and permissions. The problem actually began, when I decide to integrate a multiple "Open Auths" such as Facebook Login, Google ...
-1
votes
0answers
19 views

some pattern that I can inner join from only one of many kind of tables

I have a very long data form which needs to be saved. additionally, my form data can be separated into 4 kind of form. if I get common columns between 4 types I'll have a table with 48 columns ,...
77
votes
7answers
20k views

Why shouldn't we allow NULLs?

I remember reading this one article about database design and I also remember it said you should have field properties of NOT NULL. I don't remember why this was the case though. All I can seem to ...
2
votes
1answer
212 views

best way to log large amounts of data

I'm building a new logging system for our company. I'm wondering about the best way to store about 50-100GB data each year. I'm looking at both MySQL and MongoDB. I'm considering MongoDB because it ...
2
votes
1answer
563 views

Database design for a table with both bulk insert and single row insert

I have to design a table where records will be inserted in two ways. Bulk insert from a batch process from a delimited text file between 2 - 3 million rows in a short burst. Later the same records ...
0
votes
1answer
17 views

Mysql database .frm and .ibd file read to understand

I want to read .frm and .ibd files in mysql to understand how mysql database engine store data in files. Which format those file does have, since when I open those files it show non-human readable ...
3
votes
2answers
2k views

Should I create a separate user table for different web products within the same platform?

We have a web product for young professional that gives them the possibility to create their page to show their professional identity. So a table users that has both information about the user (email, ...
3
votes
2answers
55 views

Does it make sense to store a couple of Boolean values as array?

I have a table with five Boolean columns. In 90% plus of the rows, all the columns are null. (False is equivalent to null for me.) Instead of having Boolean columns, I could have a single array ...
0
votes
1answer
30 views

Restrict Front Ended User access to Form entry only

I have a front end database that I want to restrict user access to only enter data into a form. I do not want them to be able to scroll through other entries via the form. How can I restrict this in ...
0
votes
0answers
22 views

Database design for Lending and Servicing

I am designing Database for Gas Cylinder Filling Firm. The firm collects filling fee from customers. The firm can also lend filled and unfilled gas cylinders to each customer. My drafted database look ...
1
vote
2answers
36 views

SQL Table Design Schema - To Normalize or Not?

I am considering a table schema design for a project. The design involves a Many-to-Many Relationship. The 2 related tables are: a) Class b) Subclass A Class can have many Subclasses, and a ...
1
vote
2answers
26 views

Schema design for metered billing depending on account usage

Sorry if this has been asked somewhere else, but so far I haven't found any questions like this, or can't find the words to search for. TL;DR: What's the best way to implement counters in the ...