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
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 "...

1
2
3 4 5
7