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
1
vote
1answer
60 views

DB choice for a geodata application

I'm writing a client-server application where geotagged photos are main content. Backend is based on ASP.NET Core tech stack. Backend should be able to search photo in area (by radius), search photo ...
2
votes
1answer
2k views

Storing large files (~1GB) in MySQL

We are considering a solution that will store large files in MySQL with InnoDB. The size of the files can range from 250MB - 1GB (might grow up to 50GB in future). Here is what the plan is. Create ...
1
vote
0answers
19 views

Database for querying a probabilistic automaton

I've got a probabilistic automaton of 4000 states, with 20 attributes attached to them, and 60 000 transitions between the states. I would like to, given a defined sequence of states, find all valid ...
3
votes
1answer
45 views

Login using database user accounts

I want to know is it advisable to directly use the database user and passwaord as the user of web application generally i have seen everywhere they use a separate table inside database for managing (...
0
votes
1answer
575 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/...
3
votes
1answer
646 views

Optimal database for large number of columns or rows

Problem 1: I have one file with 567 rows and 16,382 columns, most of which are floating point numbers. I have another file with 117,493 rows but only 3 columns. The contents deal with biology and ...
0
votes
2answers
258 views

Best option for a database used by a translation app [closed]

I'm about to start working on an app which will include words and their translations in various languages. What is my best option for a database? Queries will be made instantly. So if someone ...
1
vote
0answers
56 views

How to Implement Multiple Options for the Same ID?

I'm working on a personal project, and run across the following situation, and am not sure how to proceed. I am attempting to handle some cards from a board game (Gloomhaven, if you're familiar with ...
3
votes
1answer
13k 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 ...
-2
votes
1answer
89 views

Best database suited to aviation data? [closed]

I need to store aircraft data such as latitude, longitude, altitude, flight-level, speed, etc. I will have another database (Postgres), which will contain geo-spacial data that I will need to cross-...
1
vote
1answer
588 views

Best practice for storing large files (+1GB each) [closed]

I am looking to build a big data platform for weather forecasting. I will be using a numerical model known as WRF which takes in GFS files and produces files which can be over 1GB each. I will be ...
0
votes
1answer
297 views

can I set a MAX Limit to a BIGINT cassandra's data type?

can I set a MAX Limit to a BIGINT cassandra data type? this is my first step in cassandra db. for example: bigint(10) just like in mysql?
0
votes
1answer
73 views

database normalisation on object that is attached to another object that can change

I am building an inventory management application for equipment attached to machines. The app is to allow scheduling and reporting on maintenance and service of the equipment. The machines have make/...
0
votes
1answer
70 views

Restrict executeQuery in Java from data manipulation in an Oracle database

I am developing a query browser in Java where I want to restrict users from manipulating data. So I am using executeQuery as I searched many questions and all are answered as executeQuery is used to ...
0
votes
3answers
193 views

Database architecture for big data store? [closed]

My team has developed service software with a PHP framework, so we are flexible to change database engine: MySQL, PostgreSQL etc. We have already more than 30 customers who wait to start using this ...
0
votes
1answer
826 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.
0
votes
1answer
513 views

Oracle RAC Maintenance [closed]

Is it possible to keep one node running in 2 node cluster while keeping one node down for Maintenance?.I want to do this as we are planning some hardware upgrades.
1
vote
1answer
237 views

Can I use the attach/detach database option to shut down Azure sql database until i need it

I need to use Azure SQL Database once a week for a BI solution. O load the data in on Monday, perform ETL, and then load the data into a PowerBI model. After that I don't need the database anymore ...
-1
votes
1answer
240 views

Upload Adventure Works Database 2014 into SQL Server 2012 [duplicate]

Can I upload Adventure Works 2014 DB mdf file into my sql server 2012?
2
votes
1answer
2k views

Database design for students and families/parents

I'm designing a database to hold our students and their parents/guardians. Heres what I have so far: Conditions I need to identify student siblings (ie; brothers/sisters that are part of the same ...
2
votes
2answers
96 views

Elevation data in a database (tens of billions of information)

I have a need of a service which gives me the elevation for a coordinate (latitude, longitude). There is a dataset called SRTM3 where you have this information in a list of files. Each file contains a ...
-3
votes
1answer
23 views

References and notes [closed]

Please someone suggest me the books, sites for studying Oracle as well as MySQL which is easy to understand , analyze and explained with the examples.
0
votes
1answer
596 views

database to use for Automated Teller Machine [closed]

I have been working on an Automated Teller Machine project using Visual Studio and C# for my Bachelors Degree project. Which database platform should I use for this? I'm considering MySQL, but am ...
1
vote
2answers
982 views

Store billions of rows with no relation [closed]

I'm going to receive a large group of CSV files daily. Additionally I have 1 billion records of data (from those CSV files) but it's not a fixed number (1b records daily). They're going to be growing ...
0
votes
1answer
386 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 ...
1
vote
0answers
236 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 ...
1
vote
1answer
102 views

Database Design help

I am building an application for comparing two or more songs. We have millions of songs. Currently we have access to raw data files (form a company like soundcloud) consisting of 1) Daily Users.csv ...
1
vote
1answer
140 views

Is it necessary to create primary and foreign keys in order to use tpc-h benchmark?

I'm doing some tests with tpc-h benchmark. The tpch-h benchmark simulates a data warehouse environment. The most important things here are the queries against the data warehouse. Therefore, does it ...
3
votes
0answers
3k views

MySQL along with Firebase for data sync

I'm currently working on a mobile app powered by a web platform, and the mobile app will have some offline capabilities. The application has a small amount of DB entities, and only about 3 of them ...
1
vote
1answer
688 views

Data structure design for supporting arbitrary number of columns in table or database [closed]

I am currently working on a sort-of a meta-modeler to build a free web service so that people can input data and run several models on that data. The task I am currently struggling is: user needs to ...
3
votes
5answers
1k views

Database: One table or many

I am working on a project of classified ads site. I have 12 main categories, and their items are 142, Like vehicles have cars, scooters, bikes, etc. Mobiles Phones have mobiles, tablets, accessories. ...
1
vote
0answers
590 views

Alternative to EAV to store data with an unknown structure

For my bachelor thesis I have to build a reseach database which has to meet the requirement of provenance. In the present case it means that among other things I have to store the results of my ...
0
votes
2answers
1k views

Database design for millions of posts

I have this issue. I have three types of posts a user can generate (some users can generate all some can only generate one type). I have the following types: main, employee and admin posts. I ...
0
votes
1answer
95 views

Machine learning database Big data [closed]

Which databases can I use for storing object features for machine learning use case, in case of Big data? To explain a bit more - object features basically represent an object in a form of an array ...
2
votes
1answer
393 views

Which AWS database services are designed for storing logging records like log4j or log4perl?

I have been using the file system for log4j and log4perl records and want to start using a database to store the information, especially to lookup records organized by pid. We are using MySQL RDS for ...
0
votes
0answers
259 views

Sql or NoSql design for nested data

In our data model we have classes with one to many relations to eachother TestRun (HasMany) => TestData (HasMany) => AnalyzeRun (HasMany) => Output parameters. We have to query this data in multiple ...
4
votes
1answer
275 views

Re-designing a Database cost and advice [closed]

The web application I am working with has a huge Database that is a real mess, no foreign keys, no constraints, no indexes, no optimization, no normalization, nothing. Until now, the logic has been: ...
4
votes
2answers
256 views

How to design SQL schema that treats historical data as first-class citizen?

I'm currently designing a SQL Server database schema for an application that consists of highly structured "tree" data. So, a table might look like this: id parentId (references id in same table) ...
5
votes
1answer
806 views

Best database design for website ranking

I am working on a project in which I need to rank websites in two way - Global rank and their rank in a particular country. There are various factors based on which both are calculated. There are ~200 ...
6
votes
6answers
16k views

Best database to store and retrieve Word and Excel documents

My current project is to create a barcode system (for lack of a better word) that is linked to a database (was not given more information or directions). My task is to have a barcode scanner ...
1
vote
1answer
110 views

What kind of database should I use?

I'm designing a new system and I'm wondering what kind of DB should I use for my needs. I have a tree structure of nodes, where each node has historic values. For each historic value it should hold 2 ...
3
votes
1answer
48 views

Confused about what to use to create the data

I want to create a database for myself. The data has complex grouping. I don't know which system to use to create my database. The data is in groups and sub-group forms, it almost has 5-6 layers of ...
2
votes
0answers
77 views

How to implement search for world-wide Wikipedia/OSM places with alternative-names

I would like to implement a search-backend which returns a location-aware search results of all Wikipedia / OSM place names, while recognising place names in all languages. Thus, if you search for "...
4
votes
1answer
3k views

Database design for a car dealers website

I am creating a new website for all the car dealers in my region to show their cars on and i need your opinion on the database I have created because I have some doubts. For instance, is it best to ...
2
votes
2answers
60 views

How to set-up a distributed data storage system for The Real Junkfood Project

Context The Real Junkfood Project consists of a network of pay as you feel (PAYF) cafes. We need to log the data from each of ~100 cafes, generating perhaps 50 rows each par day. I estimate that this ...
6
votes
1answer
2k views

Managing and speeding up queries on PostgreSQL table with over 3 trillion rows

I have time series data which spans over 10 years and has over 3 trillion rows and 10 columns. At the moment I use a PCIe SSD with 128GB of RAM and I am finding that querying takes a significant ...
2
votes
1answer
506 views

What is a suitable,stable, high performing database for Large Financial Time Series Data? [closed]

I realise this question may have be answered in some form but I would like to gather the thoughts and opinions of actual users with experience in this field of Database design and development. I have ...
-1
votes
2answers
111 views

DBA responsibilities: should they include suggesting a database engine for a new project? [closed]

I need your opinion on a subject. I have been working as DBA for a short time and I have been asked by the Project Manager which database engine I recommend for a new critical project. The options ...
2
votes
1answer
2k views

Easiest method to retrieve the content of BLOBs from a Sybase databse

I would like know the easiest way (no coding) to extract the content of the blobs of a database. For example, I have a table which contains a column whose format is BLOB. The result I would like to ...
1
vote
1answer
134 views

Computed Columns Or Views - Database Table Design

I want to store values in certain units along with their corresponding conversions. So for example, there would be following columns DateTime Millimetres Centimetres Metres For a ...

1
2
3 4 5
7