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
3
votes
1answer
2k views

MySQL audit and general log

May ask for the difference of MySQL Audit log plugin and general log? I looking for any activities done in a MySQL server.
0
votes
1answer
157 views

Putting some calculations on a database entry from phpmyadmin

I am creating an online store website for sale/purchase. I have to put a specific percentage of an amount (User enters) in database. for example If user enters 100. I have to deduct 30% of it and I ...
4
votes
0answers
32 views

What DBMS to choose for my production environment? [closed]

This is my very first question on the StackExchange/StackOverflow community. I originally am an electrical engineer so I hope you bear with me. I need to set up a database whose purpose is to be ...
0
votes
2answers
67 views

Database which can be setup without admin user [closed]

I'm looking for a database (relational would be preferred, but NoSQL is also okay) which can be run without an admin user. I want to setup the database with an admin user, but then delete the admin ...
0
votes
1answer
451 views

I am using Amazon REDSHIIFT and want to make my table data case insensitive?

How can I change my Tables data stored in REDSHIFT case insensitive? For example: Bell, BELL, bell in a column should return all the rows when queried.
11
votes
5answers
6k views

Are there opensource hierarchical database management systems [closed]

I was looking for a hierarchical database management system and the only one i came across was IBM's ims.Are there opensource systems that one can use?.
0
votes
1answer
25 views

View images as query results [closed]

I've done lots of research on the topic but I'm drawing a blank. Are their any database engines that can return rendered images in the query response? For example: Select images from fruit where ...
1
vote
0answers
54 views

How to design a database for production volume and loses control? [closed]

I must develop a database for inputting information of the produced volume (hourly), quality and technical issues during this production. As the input of the production volume is made manually, the ...
-4
votes
1answer
49 views

which is the appropriate database for my use case [closed]

I have a set of n sentences (n >= 100k). I want to perform queries of the sort where given a set of n_i sentences i return a set of m_i words that is present in one subset of n_i sentences and not ...
2
votes
2answers
137 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 ...
4
votes
1answer
810 views

How do database operations (write, update, alter) on particular cell in a table are written to disk without overwriting entire file?

When I want to write to or alter particular cell of an excel file/table using python I'll use pandas read_csv then alter value in particular cell and write back to file with to_csv. But writing back ...
0
votes
1answer
443 views

Remote Access to database PostgresSql on NAS Synology DiskStation (DS216j)

I have a postgres database running on a NAS Synology DiskStation (DS216j). I set this up using ubuntu and modify the files pg_hba.conf and postgresql.conf through SSH. I would like to access to the ...
3
votes
2answers
133 views

Structured .TXT Data To A Proper DBMS [closed]

I'm presented with multiple .txt documents (each with its own set of columns) containing rows separated by some type of delimiter (which is different across the files). Each .txt file has different ...
0
votes
0answers
24 views

NoSQL big DB retrieve performance

A question about retrieving performance for simple but bug key-value DBs on python3. I am working on a pipeline to compare several entries based on key-values (genetic variants found in patients with ...
0
votes
1answer
98 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
2answers
182 views

Are there alternatives to Microsoft Access? [closed]

In my office, we often use MS Access for many applications (eg creating reports, data analysis and data processing) because it is convenient to use (easy data import, fast query building, easy ...
1
vote
1answer
32 views

Different categories of missings

Most database systems can represent missing values, typically as "Null" or something similar. But what if I want to represent different categories of missing data? For categorical data, this is ...
0
votes
1answer
310 views

SQL Import text files [closed]

I have a directory that will regularly have text files dumped in it that I'm trying to get imported into a single SQL table. Basic format of the text files is as such: [DATA] Test: 12345 Test type: ...
0
votes
2answers
328 views

global unique identifier for 2 tables in relational sql

There are 2 sub-systems[ suppliers and retailers ] in our online market chain management system . Entry in any of those[ suppliers or retailers ] should give a globally unique ID .There would be ...
47
votes
6answers
27k views

What problems will I get creating a database per customer?

I remember from the stackoverflow podcasts that Fog Creek use a database per customer for Fogbugz. I assume that means the Fogbugz On Demand servers have 10s of thousands of databases. We are just ...
3
votes
5answers
1k views

Are there any in-memory hybrid databases available?

I am looking for a database that is - Relational (Not NoSQL). Has an in-memory store. Has disk-based backing storage. I want to set up a system where entire contents of the disk are replicated in ...
6
votes
3answers
3k views

Relational vs Non-Relational Database for Events Database

I'm trying to find out whether an SQL or no-SQL solution would be better for creating an events database. I'm creating a ticketing system, similar to ticket master. I know that for either database-...
0
votes
1answer
112 views

database and table design for billions of rows of data

basically i got 2 tables: header, details tables. CREATE TABLE `header` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `RECORD_DATE` datetime DEFAULT NULL, `TICKER_ID` int(11) DEFAULT NULL, `...
0
votes
3answers
135 views

Zero Maintenance self-hosted off-line databases?

I'm looking for a "Zero Maintenance" database engine that can be installed on Windows. We have a lot of customers that want our software installed on their local computers. Although we have a cloud ...
13
votes
2answers
10k 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 ...
67
votes
5answers
68k views

Best database and table design for billions of rows of data [closed]

I am writing an application that needs to store and analyze large amounts of electrical and temperature data. Basically I need to store large amounts of hourly electricity usage measurements for the ...
3
votes
1answer
767 views

Design advice regarding a users/groups/tasks database scheme

Here are my requirements: one user can have many tasks one group can have many task one group can have many users only invited user by a user can be added into a group Does this db design appear to ...
1
vote
3answers
2k views

secure way to connect with remote Mysql database

I created my application using MySQL and it relies completely on the database I have around 190 tables, and I'm afraid of security breaches and another problem is for remote access I have to add the ...
2
votes
1answer
41 views

Storage solution to run IoT analytics [closed]

I have several hundred IoT devices pushing data to my server every minute. The data is structured and it has following columns: Site ID (String) Event Start time (Date Time) Event End Time (Date Time)...
3
votes
1answer
92 views

Which allows for faster queries in a graph database: a node with multiple properties, or a node that points to multiple nodes?

I just started using Neo4j and I don't know when it'd be best to add properties to a node vs when to create more nodes. I'd assume for simple things like x and y coordinate data, it's better to use ...
-1
votes
1answer
91 views

Data containing list of all the domain names. MongoDB or MySQL?

Data containing list of all the domain names (currently present in the Internet world), along with few attributes (5-6 or maybe 10, each attribute being a column) will be considered as Big Data? ...
0
votes
2answers
55 views

Extracting data from Excel files

How to extract data from spreadsheets or Excel to database using terminal in Ubuntu? I'm using MySQL in Ubuntu and now I have 3 different Excel files using which I need to create a database in SQL. ...
1
vote
0answers
226 views

Database Design for Multi-Level Ownership

I'm trying to figure out what sort of database and what sort of database structure would make sense for representing ownership of different assets by different constituencies. Say a group of 5 ...
18
votes
4answers
27k views

Is there a tool to check if my database is normalized to the third normal form?

I learned about normalization recently, and understand how important it is when implementing a new schema. How can I check if my database is 2NF or 3NF compliant ? Manual review is a sure option, ...
0
votes
1answer
465 views

create additional oracle 11g database in linux

I have already created a database XE on my linux desktop.Please find the below information about the database. ORACLE_SID=XE ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/...
-1
votes
1answer
91 views

Suggestions for type of DB to use (Elasticsearch vs MongoDB vs Hadoop)

I am hoping some of you highly skilled DBAs can provide some insight as to the best DB to use for this dataset. This is a relatively simple dataset with no relationship needed between the entries. ...
0
votes
1answer
66 views

Should I use MongoDB or a relational database management system for this scenario? [closed]

I have a different item types, each item has different number of attributes some attributes might contain an arbitrary number of values. For example, a building which has amenities attribute, this ...
4
votes
2answers
809 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
1answer
2k views

best local database (for PC) [closed]

I have a PC which runs a local desktop application that connects to a logic server with a database. additionally i need a small cache database in this PC so when the client goes offline for some ...
0
votes
2answers
31 views

Regex rules engine based on SQL

I have a table which I use to determine actions based on conditions provided. This is what it looks like right now. IPAddress, MACAddress, Hostname, ScriptName, Argument1, Argument2, Argument3 10.2.1....
2
votes
2answers
7k views

Single user mode while restoring database

Is it necessary to put the database into single user mode before restoring a database? If so which one is more preferable putting the sql server into single user mode or putting the database only into ...
1
vote
0answers
595 views

MySQL MyISAM corrupted table repair failure

My MyISAM tables got corrupted(I guess due to fs corruption) filesystem_cstor.MDS_DATA warning : Table is marked as crashed warning : Table is marked as crashed error : Key in wrong position at ...
0
votes
1answer
188 views

Which database is best for storing mouse movement data for analytic stuff? [closed]

Problem I want to track the user behavior on website. I am tracking the mouse movement and after tracking certain number of mouse movements, i am planning to send this data to my server, where i will ...
2
votes
3answers
5k views

How to build a table for a private messaging system that supports replies?

I'm writing a private messaging web application in PHP, the application allows replies such that when you view a message, you also get to see to what was that a reply to, and to what was that a reply ...
3
votes
1answer
9k views

Recommended SQL server service accounts [closed]

In my SQL environments most of the SQL server are running under '.\Local User' with Power user groups rights and some sql servers are running under virtual accounts 'NT Service\MSSQLSERVER'. I know ...
1
vote
1answer
59 views

Having two entities that are the same except for 1 distinct attribute

In an example scenario for a database design assignment, a company provides hotel rooms (split into two entities - Hotel and Room) and apartments. So the database will contain the following entities: ...
2
votes
3answers
2k views

What is the difference between views and materialized views

What is the difference between PostgreSQL's materialized views and MySQL's views?
7
votes
6answers
35k views

What is the easiest way to get started using databases with real data?

I have a project that could benefit from using a database, but I have no experience with databases, don't have access to a server, and have relatively little experience working with things living ...
3
votes
3answers
364 views

What databases can I use to represent ordered sets?

In a SQL database, the only way to represent an arbitrarily ordered set is to give every record an "Order" and every time you update or move an item around in this ordering you have to update or ...
0
votes
1answer
289 views

Best database system to store and compare date ranges

I'm working on a project which is dealing with a lot of date ranges. I'm starting completely from scratch; there is no existing code, infrastructure or database. Therefore, I'm searching for the best ...