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

learn more… | top users | synonyms (4)

0
votes
2answers
35 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: ...
2
votes
2answers
72 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

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
36 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
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 ...
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 ...
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
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
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
58 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
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 ...
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
1answer
18 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 (...
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 ...
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 ...
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 ...
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 ...
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
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 ...
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
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 ...
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
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
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 ...
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
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 ...
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
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
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 ...
-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 ,...
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] ),...
0
votes
1answer
18 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 ...
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 ...
3
votes
2answers
56 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
0answers
33 views

Help on Database Table Design

I am trying to create a website with multiple Q&A. The main features I need to support are as below There will be multiple types of questions. (a. Single option Answers, b.MultiOption, c. True ...
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: ...
2
votes
1answer
33 views

How can I implement a viewed system for my website's posts?

Here is my current structure: // posts +----+--------+----------+-----------+------------+ | id | title | content | author_id | date_time | +----+--------+----------+-----------+------------+ | 1 ...
1
vote
0answers
19 views

Incremental load of full database

Please anyone suggest best approach for incremental load of all the tables in a database to a data warehouse , I have already developed SSIS package to do that using CDC, but enabling CDC for 100 ...
1
vote
2answers
27 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 ...
16
votes
3answers
282 views

Large (>22 trillion items) geospatial dataset with rapid (<1s) read query performance

I'm in the process of designing a new system for a large geospatial data set that will require rapid read query performance. Therefore I want to see if anyone thinks it is possible or has experience/...
0
votes
0answers
6 views

Database design in ElasticSearch for non-periodically updated stats that get aggregated over time

We receive statistical data of eshops (e.g. statistics of eshops' products) from various sources over time. These statistical data are usually collected periodically every day, sometimes they could be ...
1
vote
1answer
30 views

Database design. And get last modified time with each column in PostgreSQL

My database/table each endpoint/scope have multiple table, e.g user: user, user_information, user_role ... I was wondering should I separate table like below, or not? This is my first time to ...
0
votes
1answer
37 views

Data Modeling constraint issue

Can someone help me with this school question? I have this data model shown below: here is the question: You are modeling an emergency communication system used to contact teachers in case ...