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.
306
questions
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 ...
