Questions tagged [database-recommendation]
Determining what database product best fits the requirements and limitations in a specific situation. This is advice that generally requires much more insight into requirements than can easily be gleaned on a Q&A forum such as StackExchange.
327
questions
0
votes
2
answers
2k
views
Creating tables with inheritance
I'm fairly new to SQL. I just wanted to create a database from scratch to learn.
So I have a table called Addresses and I want to create two tables dependent on it that are Country and State, Im not ...
3
votes
1
answer
10k
views
Can I copy a collection in mongoDB from one database to another by copying the db files directly?
I tried using cloneCollection http://docs.mongodb.org/manual/reference/command/cloneCollection/ , but clonecollection takes a lot of time in case of big collection because it starts indexing the data.
...
0
votes
3
answers
396
views
Database Design for Paper Submission System
I am learner of Database design, I want to design a database for a journal paper submission system in which one paper can be submitted by one or more author. I have initially two tables Author and ...
1
vote
1
answer
541
views
Does InnoDB Log Files take RAM space or Disk Space
When I set InnoDB Log File size to 512M, does it take the space (512M * 2) from RAM or the SSD Disk space?
When I explored, I can see that the log files are located inside /var/lib/mysql folder. So ...
9
votes
1
answer
45k
views
What are the advantages and disadvantages of Firebase for a database?
I am currently developing a site to track credits gained from exams, and how these stack up against the user's goal credits.
I am looking for a database system that will store all the possible exams ...
0
votes
3
answers
1k
views
Confused about Primary Keys, and Foreign Keys
Im brand new to database design and, I'm slightly confused about Primary Keys, and Foreign Keys and my database design.
Context:
I'm working on a database of museums and Categories will be one way ...
0
votes
1
answer
531
views
Copy database from one mysql sever to another mysql server
Following are the details of the database and server:
Server1:
Host Name: abc
Port Num: 01
database: test
Server2:
Host Name: xyz
Port Num 02
database: spareparts
userid: spts
password: abcdefgh@123
...
0
votes
3
answers
2k
views
Converting huge ASCII file to flat and convert
I am not a db administrator but I thought to ask this question here.
I have several very large ASCII files (3-5GB each) that I need to extract the data and then sort it. The instructions say to "...
1
vote
1
answer
1k
views
Saas MySQL Multiple Databases or One Database [closed]
I am using MYSQL so Database is the Schema, sorry if not using right terminology.
I currently have a Saas product which has multiple databases one for each client with a main databases which we ...
2
votes
2
answers
431
views
Database setup for datalogging [closed]
We're currently starting to build a version 2 of our system and one of the things we've noticed with version 1 is that we'll have quite a bit of data so we started to rethink our approach to how to ...
0
votes
1
answer
23
views
Debate on which id to use as reference when quering a one to many table
I have a database that has a One to Many relationship. A few changes are in order and now when I query the output I need to provide just one ID field. The output contains all iterations of the one to ...
2
votes
1
answer
4k
views
Small startup: Cassandra + Hadoop or ElasticSearch
To give some context, I am from a small start up (4 team members) and we work in the education space.
We've developed an e-learning platform that several schools are already using. We currently have ...
1
vote
2
answers
104
views
DB for storing simple time-stamped values
I don't have that much experience in databases but I need to accomplish this as best as I can. It is rather specific.
Database will contain only data structured like this:
dataID-timestamp-value
...
1
vote
2
answers
774
views
How to architect an analytical BI platform? [closed]
I am working on a new BI project for a medium sized corporation. Right now there is no Analytical infrastructure in place and the reporting is done manually in Excel. There are a few different data ...
19
votes
3
answers
16k
views
PostGIS vs. SQL Server for GIS data
So I'm recently starting at a new company and have a lot of ArcGIS users who seem really keen on going forwards with a PostGIS instance to serve some data to our customers. While I don't have an issue ...
0
votes
2
answers
110
views
What database should I use? [closed]
I am writing a log analysis program in bash. As part of it, I am compiling a list of known errors, so that I can search and reference those errors as part of the known list. I originally was going to ...
1
vote
0
answers
829
views
How to handle many columns / variable schema?
I apologize in advance in case this question has been asked already.
I'm working on revamping a reporting application used within my company. The requirements are:
Support addition of new fields (...
1
vote
2
answers
310
views
Database design suggestions for a data scraping/warehouse application?
I'm looking into the database design for a data warehouse kind of project which involves a large number of inserts daily. The data archives will be further used to generate reports. I will have a ...
0
votes
1
answer
131
views
Optional oneToOne relations and criteria field
Introduction:
Visitors can fill reports on my website.
Those report can either be filled by a legalPerson or a naturalPerson.
Constraint: I don't like empty fields and I would like to normalize as ...
1
vote
0
answers
681
views
Conceptual model vs Logical model vs Physical model
I'm doing a work about database, and now I need to show three different images, one image with the conceptual model, other with logical model and other with physical model of a database.
I'm looking ...
5
votes
4
answers
322
views
Are we a good fit for SQL Server Enterprise and table partitioning?
We currently have a production database that contains millions of records (14 million in the largest table).
One function of the database is to provide time sheet information so a single table could ...
0
votes
1
answer
491
views
SQL or NoSQL for structured clinical data [closed]
I'm designing a database for a primary health center, the idea
We basically have a Patient with many Encounters, also the Encounters have to be entered from different Users (Health Professionals). ...
1
vote
1
answer
1k
views
CRM Address table and it relation
Hi I want to ask about I have this DBD for my CRM I am trying to have the addresss in one table(customer and Employee Address) and both customerID and Employee ID are guid I have in address table FK ...
1
vote
1
answer
74
views
Understanding how relationship sides works
So, I have this relations on my tables (see image) and I need to understand some things. I'll enumerate what I understand and what I need from yours is to say if I'm right or not and in case I'm not ...
2
votes
4
answers
770
views
Database/Storage engine suggestion for a project involving heavy inserts?
I am looking into a project which involves large number of inserts daily.I will have a list of user's (for example a user set of 500k ) , for which I need to monitor daily certain activities ...
0
votes
1
answer
229
views
Creating and designing Air Trafic Control System [closed]
I'm having a class about Database management system, and the prof. gave us a project regarding Air traffic controller system, exact question is "Design and create a system which can manage ...
1
vote
1
answer
7k
views
Way to run SQLCMD without storing password in text format
Is there a way to run sqlcmd from a batch file where I don't want to store the password in plain text format. I have done some research and found the system variables method(store password in system ...
1
vote
2
answers
920
views
Train Fare Database Normalisation
I have a database to normalize. The database has details of train ticket fares.
The trains have different fares depending on the distance and I have to store these fares in the database
It is not an ...
0
votes
1
answer
128
views
What table should I host data linking two objects from separate tables?
I've tried searching around, but I'm not too sure how to correctly formulate this question, and found nothing. Could be a duplicate.
What is the best way (most efficient way) to host data that will ...
1
vote
0
answers
130
views
Get data from Berkeley DB with Java [closed]
I have a basic Java program which can list data from Berkeley DB database. The question is how I can list the database scheme to see what object are available? Unfortunately I don't have information ...
4
votes
1
answer
2k
views
Optimum design / structure for product data database?
What would be the optimum design/structure for product data database, where each product have many variations and many attributes? Attribute sets vary between products, and some attributes have values ...
0
votes
1
answer
2k
views
Database design for mobile app
At first I would like to say hello to all of you, since it is my first post here on DB Administrators.
I am writing an app which store drinks and their data. At the beginning it was storing all in ...
2
votes
0
answers
2k
views
How to generate data for News Feed efficiently like facebook , googleplus , twitter e.t.c?
I have created table as
post (
post_id int(15) auto_increment primary key ,
user_id int(11) ,
post_text varchar(2000) ,
post_type int(1),
...
1
vote
1
answer
1k
views
What is the advantages of using auto_increment in database as primary key over set of attributes?
I have table as
CREATE TABLE circle
(
circle_id int(11) auto_increment primary key not null,
user_id int (11) not null,
title varchar(255) collate utf8_general_ci not null
);
CREATE ...
0
votes
1
answer
193
views
What is the strategy of query evaluation in DBMS when Limit is used in query?
I have following tables in database
post(post_id , user_id , post_text , parsed_text) ;
Comment(comment_id , post_id , user_id , comment_text) ;
friend(id , user_id , friend_id ) ;
group (id , ...
1
vote
3
answers
2k
views
Mass data upload from Excel - technology
I am a Developer seeking help in terms of DB technology for a specific requirement. I have done some research but can not conclude with list.
Requirement:
There will be a web application which will ...
2
votes
1
answer
102
views
Is there a simple, safe and low cost way to implement a (limited) database to be outside (close) IT control? [closed]
This question is a spin off of the discussion here (What are the risks of building a database outside IT control?).
Background: I'm a risk guy that builds little betas, mostly in Excel-VBA. I have a ...
2
votes
4
answers
959
views
What are the risks of building a database outside IT control?
I've been looking for the best StackExchange community to ask this. I hope it fits well here.
As a risk analyst in a trading business, I'm often confronted with large volumes of data, way beyond the ...
2
votes
3
answers
74k
views
MySQL vs. Microsoft Access [closed]
I'm trying to aggregate about 500-1000 MS Excel files that deal with various small business issues (inventory, purchase orders, etc) and I'm currently trying to decide what kind of RDMS I should use. ...
0
votes
1
answer
2k
views
Does redundancy exists in this table?
I'm studying a DB course and I found this table:
In this exercise, the objective is to determine whether the table has redundancy or not.
According to the definition of redundancy
Data redundancy ...
5
votes
2
answers
1k
views
Searching 500 million records of binary data
I will inserting into a database the signatures of 500,000,000 pictures. The signatures will be generated using libpuzzle. Each signature is 338 bytes. (so 160 GB) plus a table for searching (read ...
0
votes
2
answers
4k
views
Help understanding database design logic for a secondhand bookstore project in MySQL
I am currently working on a small eCommerce based project that allows users to buy/sell second hand books to/from other users. I am having a hard time making design decisions on how to model the ...
2
votes
1
answer
287
views
Elasticsearch and product characteristics
I have a small question about elasticsearch. Let's say I have a database with products to sell, like an ecommerce.
I know that elasticsearch can help me to find the best product with, for instance a ...
1
vote
1
answer
109
views
Will a specific denormalization increase performance in a specific scenario?
Suppose I have a table with fields | a | b | c | d | ... | z | which contains millions of records and which will serve millions of queries a day. And the field z holds the id of some parameter which ...
2
votes
1
answer
7k
views
Best Approach to storing chat history?
I'm building a chat application (Yes, another one :P) and am really curious about the best way to store a chat's history(String username, String Message, Time, and possibly string channel depending on ...
-1
votes
1
answer
78
views
Database software advice [closed]
I have this strange question. I'm building a service that stores information into one table. That table has 20 columns. My database will have many billion rows. Right now I'm using Cassandra, but it ...
3
votes
3
answers
642
views
Database throughful design vs Quick and dirty design comparison
Take the representation of an Address, here below is a complete and very detailed implementation:
here instead is a quick implementation (which more or less contains the same fields, imagine all ...
5
votes
2
answers
1k
views
Data Modeling for different roles
This is my first post here, so I hope its clear enough. I want to make an application for people who sell, buy, rent and fix a certain product.
I need to create a database that would keep the data of ...
1
vote
2
answers
562
views
Automobile database logic [closed]
I am building a web based quoting system for a local automobile dealership.
I think I have figured out the logic for the databases but I want to get a second opinion before I start just to make sure ...
5
votes
1
answer
2k
views
Does creating View cause an overhead to DB?
As my subject suggests, I would like to know does creating views cause an overhead to DB in terms of space, storage, performance?