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.
315
questions
-1
votes
1answer
439 views
Design for membership of a group
I have two different databases. One of these is a Users table, and another is a Groups table.
A group can have multiple users, and a user can have multiple groups
What's the best way to associate a ...
0
votes
1answer
40 views
Searching for scalable storage solution
In one project I save statuses of processing in MySQL table:
`id` `name` `email` `has_apples` `has_bananas`
1 Bob a@b.c 1 0
2 Mike c@d.e 0 1
3 ...
11
votes
2answers
3k views
Database for efficient range aggregate queries?
As a simplified example, suppose I have a table like this:
seq | value
----+------
102 | 11954
211 | 43292
278 | 19222
499 | 3843
The table may contain hundreds of millions of records, and I need ...
1
vote
2answers
178 views
Creating a database for students [closed]
the institute I am working at wants to create a database for students. I have to find the best and easiest solution for this application and I need your opinions.
We would like to create a website/...
1
vote
0answers
775 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
2answers
477 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 ...
4
votes
3answers
579 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 ...
3
votes
1answer
148 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
vote
1answer
63 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
3k 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
46 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
633 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
836 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 ...
1
vote
2answers
364 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
57 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
14k 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
101 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
614 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
320 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
75 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/...
1
vote
1answer
86 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
194 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
1k 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
584 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
270 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
243 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
114 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
24 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
637 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
1k 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
418 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
244 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
103 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
144 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
802 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
632 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
2k 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 ...
2
votes
1answer
428 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
267 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
279 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
278 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
871 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
17k 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
116 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
49 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
78 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 "...