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.

Filter by
Sorted by
Tagged with
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 ...
newUser's user avatar
  • 31
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. ...
geek2coder's user avatar
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 ...
Irfan Ali Memon's user avatar
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 ...
Neel's user avatar
  • 113
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 ...
user avatar
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 ...
CallMePhilip's user avatar
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 ...
sravan kumar's user avatar
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 "...
charnley's user avatar
  • 101
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 ...
Blu Towers's user avatar
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 ...
Tuxie's user avatar
  • 182
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 ...
Mallow's user avatar
  • 123
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 ...
Sneaksta's user avatar
  • 123
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 ...
Algirdyz's user avatar
  • 113
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 ...
sfactor's user avatar
  • 111
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 ...
LowlyDBA - John M's user avatar
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 ...
Sienna's user avatar
  • 111
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 (...
Heidern's user avatar
  • 11
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 ...
Surabhil Sergy's user avatar
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 ...
Xavier13's user avatar
  • 101
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 ...
UserX's user avatar
  • 111
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 ...
cbmeeks's user avatar
  • 249
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). ...
Pablo Olmos de Aguilera C.'s user avatar
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 ...
NinjaDeveloper's user avatar
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 ...
ReynierPM's user avatar
  • 1,764
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 ...
Surabhil Sergy's user avatar
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 ...
washaq's user avatar
  • 37
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 ...
Hitesh Chouhan's user avatar
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 ...
Adrian Viegas's user avatar
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 ...
Alex's user avatar
  • 103
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 ...
user1285928's user avatar
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 ...
ellockie's user avatar
  • 143
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 ...
Lukis's user avatar
  • 101
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), ...
user3610792's user avatar
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 ...
user3610792's user avatar
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 , ...
user3610792's user avatar
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 ...
webmajic's user avatar
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 ...
VBOG's user avatar
  • 55
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 ...
VBOG's user avatar
  • 55
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. ...
user2578013's user avatar
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 ...
Jose_Sunstrider's user avatar
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 ...
ParoX's user avatar
  • 163
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 ...
Rodney's user avatar
  • 3
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 ...
Noé Malzieu's user avatar
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 ...
Kolyunya's user avatar
  • 111
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 ...
joshua-anderson's user avatar
-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 ...
Jason's user avatar
  • 19
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 ...
dendini's user avatar
  • 395
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 ...
raygo's user avatar
  • 151
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 ...
Otis Wright's user avatar
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?
hiFI's user avatar
  • 179

1 2 3
4
5
7