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.
34
questions with no upvoted or accepted answers
3
votes
2
answers
2k
views
Choosing the right database for stock price history
The model is [(stock_id, period, ts), open, high, low, close, last, volume]
We write new prices for all stocks (120,000) each minute and delete old once when they go out of retention time. It doesn't ...
3
votes
0
answers
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 ...
3
votes
1
answer
57
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 ...
3
votes
0
answers
430
views
What are reasonable options for an in-memory multi-core database?
I'm going to preface this with pointing out that I only need somewhat persistent data. The purpose of this database platform would be to support statistical analysis in R. I usually build my tables ...
2
votes
0
answers
87
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 "...
2
votes
0
answers
2k
views
How to generate data for News Feed efficiently like facebook , googleplus , twitter e.t.c?
I have created table as
post (
post_id int(15) auto_increment primary key ,
user_id int(11) ,
post_text varchar(2000) ,
post_type int(1),
...
2
votes
0
answers
2k
views
which role-permission database design?
I want to manage roles and permissions. Most of designs on web look like this
tables:
Users
Roles
UserRoles
Permissions
RolePermissions
Here, what is permissions? I am thinking for such a design ...
2
votes
0
answers
230
views
Digital asset management
I'm working in a company that currently develops Media Asset Management system and now we want to improve our system for document files. I have to search nearly thousand .doc and .pdf files and index ...
2
votes
0
answers
683
views
SQL Server SSIS issue retrieve data when I enter into login of server side?
I am failing to retrieve data when I enter into login of server side.
Here is the error message
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for ...
2
votes
0
answers
2k
views
How to do automated archiving for a SQL Server database based on interpretation of database metadata?
I am looking for a solution giving me automated archiving of SQL Server databases based on a smart interpretation of table relationships that is able to archive records from related tables minimizing (...
1
vote
1
answer
968
views
Sql Server - Best Practices for Growing Large Database Files
I know this kind of question has been asked previously but I don't get the answer that I'm looking for.
I'm reconsidering setting up Autogrowth for DB Primary & Data files for Log(partitioned ...
1
vote
0
answers
94
views
Are there any databases that properly support sum types/tagged unions?
I want to model various different events. Every event happens at a specific time, but other than that, each event needs to have different associated data, depending on the type of event. In Rust, I ...
1
vote
2
answers
195
views
How do I resolve having a M:N relationship in my Crow's Foot Model? Am I on the right track?
I am very much a beginner and taking a class on databases. My assignment involves using Crow's Foot notation to represent the following tables:
This is my design for it so far. I am nowhere near done ...
1
vote
0
answers
17
views
Database/cloud solution for very wide time series data (i.e. spectra with up to 8196 columns)?
I'm dealing with data from a science project which comes from a multi-channel analyzer: once per minute I get 2048 integer values from one device and 8192 integer values from another device. Both ...
1
vote
0
answers
132
views
What data store should I use for storing and querying a billion small (~2kb) JSON documents?
I'm trying to figure out which database to use for storing and querying on ~1 billion JSON documents about the size of 2KB each. About 2 TB of data.
Nature of JSON documents:
3 types of documents (...
1
vote
0
answers
1k
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 ...
1
vote
0
answers
21
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 ...
1
vote
0
answers
63
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 ...
1
vote
0
answers
268
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
0
answers
792
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 ...
1
vote
0
answers
445
views
TPC-DS data generation
Is there a way to generate TPC-DS/TPC-H data using Normal Distribution, i.e., is there a way to specify the distribution type while generating TPC-DS/TPC-H?
EDIT : I believe there is an option for ...
1
vote
0
answers
829
views
How to handle many columns / variable schema?
I apologize in advance in case this question has been asked already.
I'm working on revamping a reporting application used within my company. The requirements are:
Support addition of new fields (...
1
vote
0
answers
683
views
Conceptual model vs Logical model vs Physical model
I'm doing a work about database, and now I need to show three different images, one image with the conceptual model, other with logical model and other with physical model of a database.
I'm looking ...
1
vote
0
answers
292
views
Best practices for ranking records in flexible way
Suppose we have 10000 records of any product.
User search on our website with his given criteria. so we output search results based on given criteria.
Now Admin want to rank products in search.
so ...
1
vote
0
answers
201
views
Real Time data collection - Help select Database
My Scenario:
I want to collect data from various sensors[for now I have 600 sensors sending data, but this may have to scale up to 3000 more data sensors, all sensors send real time data] Now I have ...
0
votes
3
answers
909
views
Overwriting MySQL database to only store 1 month of data
We are logging data on hardware with only small memory (short on disk storage) only 4GB.
We only require the data to be stored for 1 month and then be over written in a way that it overrides older ...
0
votes
2
answers
39
views
Structure database(s) dealing with different time points
I have few data sets that give a score for a specific account at a specific point in time. So, account A might have a different score each quarter going back 5 years so. There aren't a ton of data ...
0
votes
1
answer
88
views
Need help on a database model design
I am creating a small booking application with Laravel. It lists some centers. Each center has its own unique rooms. Each room may be booked several times (with dates). From my application, I post the ...
0
votes
0
answers
54
views
Platform to manage and analyze peer evaluations?
Our academic department (at a US university) collects mandatory paper-based peer evaluations at undergraduate level for a number of classes each semester. So in a typical class of 60 students, folks ...
0
votes
1
answer
23
views
Debate on which id to use as reference when quering a one to many table
I have a database that has a One to Many relationship. A few changes are in order and now when I query the output I need to provide just one ID field. The output contains all iterations of the one to ...
-1
votes
1
answer
31
views
Database recommendation storing a growing set of recordings
Suppose I have a large volume of recordings coming in from various sources. Encoded as JSON-lines, they might look like this:
{ "metric": "temperatureRange", "values": [ &...
-1
votes
1
answer
211
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. ...
-1
votes
1
answer
211
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?
...
-2
votes
1
answer
62
views
Is there any database uses lzma?
according to this article, lzma has a great performance on compression ratio. I think lzma database is a good choice if I don't care about compression speed, so is there any database that uses it?