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.
0
votes
1answer
46 views
Should database files be on different disk(s) than OS?
My very short overview
SQL Server databases are installed as virtual machines on VMWare, there are plugged a few disk areas with the same (or very similair) parameters
versions are SQL Server ...
1
vote
1answer
270 views
How to prevent high memory, CPU and time consumption by MySQL restore?
I have a local test machine with 2 GB RAM and a dual core processor.
I imported a dump on that using
mysql -uuser -psecret < script.sql
script.sql is a 700 MB file which contains a single ...
-1
votes
0answers
18 views
Network Databases - 2 [migrated]
I fail to see why my previous question was closed. I merely asked whether or not there were any free/open source network (IDMS-type) databases, with the implication that, if there were, an indication ...
0
votes
0answers
31 views
Database with history journaling [closed]
In the database I need to store a data about vehicles (about 240 objects), their locations, working job, etc. In my table this info stored in one table. User should not input everyday this info. It ...
-1
votes
0answers
37 views
Network Databases [closed]
I am doing some research on network database e.g. IDMS-type databases. Are there any free/open source network databases available?
TIA
1
vote
1answer
105 views
Switching to NoSQL for native JSON use?
I am rather comfortable writing concrete schemas with explicit primary keys, foreign keys, indexes, views and stored procedures. For queuing I use a NoSQL solution called: Redis.
Recently I heard a ...
1
vote
3answers
135 views
Relational vs Non-Relational Database for Events Database
I'm trying to find out whether an SQL or no-SQL solution would be better for creating an events database. I'm creating a ticketing system, similar to ticket master. I know that for either ...
0
votes
0answers
52 views
Which dbms will suit my requirements best?
In my app I get data from two sources, from source 1 I get around 125000 records per seconds, say record type A, and from source 2 I get around 10000 records, per seconds ,say record type B.
Now I ...
1
vote
1answer
81 views
Approach for a 2,000 table migration
What might be the best approach when converting or migrating a database containing over 2,000 tables? Where would you begin to tackle such an issue? Steps to take in the first weeks of designing? ...
6
votes
4answers
1k views
Is there a tool to check if my database is normalized to the third normal form?
I learned about normalization recently, and understand how important it is when implementing a new schema.
How can I check if my database is 2NF or 3NF compliant ?
Manual review is a sure option, ...
0
votes
0answers
41 views
How to identify computer specifications [closed]
We need to assemble a system that can store streaming data from a dozen sensors, including several cameras, averaging >5 Gb / minute. The desired data storage system is a single machine running a DBMS ...
0
votes
0answers
38 views
mySQL- large database
I need guideline to setup DBMS(MYSQL or SQL Server 2008). The database size is expected upto 80-100GB in next few months. One main table will contain textual content like essays. Can MySQL handle such ...
0
votes
1answer
63 views
good practices of creating tables in mysql [closed]
Hi I was thinking of developing an web apllication using php and mysql.
Application will give a professor the required data about the student.
i want to design application considering Engineering ...
1
vote
0answers
54 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
0answers
32 views
Suggested Database and Web Application Framework for Enterprise, “Big-Data” App? [closed]
I have a web application that I have been developing for a small group within my company over the past few years, using Pipeline Pilot (plus jQuery and Python scripting) for web development and ...
-1
votes
1answer
46 views
Database theories possible topics to research through [closed]
I need to conduct a research on database theories. I want to know what possible questions should I research on which is believed to be suitable when researching database topics for a online assessment ...
7
votes
2answers
734 views
100 TeraBytes Capacity Database - Resources and Time Estimates
I am working on a 'back of the envelope' calculation for a 100TB reporting database setup. I am seeking out thoughts from the experts here. Proposed environment:
Storage Capacity ~ 100TB
Tables ~ ...
-1
votes
1answer
77 views
How can I move 5 GB data from one database to another faster?
I'm using MySQL as database with Windows server. I'm having 5 GB of data in database. Now I need to change my server and the question is that how can I transfer complete 5 GB data to one mysql ...
2
votes
0answers
63 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 ...
3
votes
2answers
145 views
Could someone recommend a db management tool that supports SQLite, MySQL, PostgreSQL, and is web-based?
Could someone recommend a db management tool that supports SQLite, MySQL, PostgreSQL, and is web-based? By 'web-based' I just mean it can be run in a browser locally or remotely.
23
votes
5answers
2k views
When is the right time to use MariaDB instead of MySQL, and Why?
What we earn and what we lost with this migration?
What should I expect as drawbacks after the migration?
Is it really unnecessary to change the applications in any situation?
3
votes
2answers
57 views
Which database type to use
I want to implement database for following application:-
User creates task and assigns to other user who can furthur split it into subtasks and assign it to other users.creaking a tree like ...
1
vote
1answer
68 views
Which database is designed for storing and incrementing values?
We're trying to build a stats server that stores visits for each document on a section for a specific date, so we need a table that has the following parameters:
documentID
sectionID
date
visits
...
3
votes
1answer
350 views
NuoDB with Amazon S3
I think about developing my new mobile and web app against NuoDB. I believe in their technology. The thing that I care the most is backup and restore in case of data corruption and read / write speed ...
1
vote
3answers
199 views
Which RDBMS has the most advanced “table-valued” functions?
Every Database Management System focuses on specific features and applications. I am using mysql, probably as it is popular and satisfies common needs. However, I came across a problem, which needs ...
0
votes
0answers
29 views
“Related search” trick in huge Hypertable database?
Several years ago, I've created search engine using PHP with MySQL (MyISAM)
The "Related search" pick 5 most similar search title.
The data has growing bigger in matter of days.
Each submission has ...
11
votes
3answers
657 views
Is there any benefit to defragmenting SQL indexes in a SAN environment?
Our SQL server lives on a SAN. It contains dozens of OLTP databases, some with several tables containing over 1m records.
We have been running Ola Hallengren's index maintenance scripts weekly, and ...
2
votes
2answers
163 views
Should I create a separate user table for different web products within the same platform?
We have a web product for young professional that gives them the possibility to create their page to show their professional identity.
So a table users that has both information about the user (email, ...
0
votes
2answers
705 views
NoSQL, CouchDB vs. CouchBase, What should i do?
I started to encounter some issues on my production site, when having a web page that needs to load a very big ResultSet (currently coming from relational database, MySQL) it takes forever, and ...
13
votes
6answers
2k views
What problems will I get creating a database per customer?
I remember from the stackoverflow podcasts that Fog Creek use a database per customer for Fogbugz. I assume that means the Fogbugz On Demand servers have 10s of thousands of databases.
We are just ...
9
votes
1answer
126 views
What platform for a large record based mathematical database?
Hi I am a civil engineer with some experience of programming but I am not familiar with the vast range of options available today. Hope you could give me any pointers the best way to proceed.
I want ...
0
votes
1answer
85 views
Database suitable for data mining
What would be an appropriate / suitable database sans Oracle that would be suitable for the following conditions?
data mining
includes but does not limit to the following:
a. clicking on links
b. ...
2
votes
2answers
3k views
Local database vs Amazon RDS
I am doing large INSERT into a local MySQL database
I am at 2,000,000 rows and am really starting to notice the slowdown now. I always heard that MySQL wasn't very scalable
I expect this database to ...
0
votes
1answer
70 views
Looking for a scalable relational database [closed]
I'm looking for a database that achieves the following:
fully ACID.
relational with joins.
has transactions.
allows the administrator to specify sharding rules (for example: users from Europe should ...
2
votes
1answer
140 views
Which database to use? [closed]
Hey there. I am looking for a free to use for commercial website database that should have these design features, in the given order:
Auto-Sharding (getting more free space by adding more server ...
1
vote
1answer
104 views
is it reasonable to use NoSQL for my project
Imagine you want to write a webapp for selling your car online.
A car has a lot of attributes. Like how many doors, color, aircondition, etc. Some of them are simple boolean values, others might need ...
11
votes
6answers
1k views
Is polling the only way for updating app's data from a database?
An application needs to have data as more freshly updated from a database as possible. In such a case, is there any other way for getting the data, besides of a timer based requesting (polling) the ...
4
votes
5answers
1k views
What is the easiest way to get started using databases with real data?
I have a project that could benefit from using a database, but I have no experience with databases, don't have access to a server, and have relatively little experience working with things living ...
0
votes
1answer
186 views
Keep total transaction in invoice application
I want to make an application called as Invoice Application with MySQL database. Now I have designed this database. Now I want to know is this database good for Invoice Application. I will use MySQL ...
2
votes
2answers
104 views
Small Cloud Database
I'm researching the best way to do the following but haven't been able to come up with anything. I'm trying to build a small (probably 3 or so tables with at most 200 records each) relational ...
1
vote
1answer
195 views
which database engine is best for full text search on a 10M rows table?
I'm creating a search engine and needs to search keywords in a text field (about 300 words in each text field, unstructured).
I'm thinking about noSQL\MySQL+Sphinx, the performance impact here is ...
2
votes
1answer
182 views
SQLite or CouchDB for Locational Data Mining Project?
I am currently designing a Data Mining Project where I am going to harvest rather large volumes of Twitter data in order to analyse locational data (geocoded tweets) and do some machine learning with ...
-4
votes
1answer
79 views
Simple online collaborative database for many users to add and query… does it exist? [closed]
:) I'm looking to create a VERY simple database that people can subscribe to for a nominal monthly fee... no relational/pivot tables, no complicated expressions, etc... just an easy form of a couple ...
1
vote
2answers
259 views
Determining sizes for Separated Partitions of programs, data and logs in SQL Server
As per the recommendations of the CIS benchmarks for SQL Server, I want to create separate partitions for the data, the programs and the logs on my SQL Server dedicated server.
Question is, what is ...
2
votes
0answers
149 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
0answers
344 views
Which database technology for big structured data? [closed]
Scenario: Think you have got
100TB of text in 200 tables. This is structured related data. compareable to dbpedia only more data. Any really relational and distributed and performant database would do ...
2
votes
1answer
159 views
Which database?
We have to launch a new service in my company with a big database.
And I currently don't have that much knowledge.
We did a small preview of the service and our biggest table had more than 2 100 000 ...
2
votes
2answers
116 views
Database structure for a system with multisite
The system I'm working is structured as below. Given that I'm planning to use Joomla as the base.
a(www.a.com),b(www.b.com),c(www.c.com) are search portals which allows user to to search for ...
3
votes
2answers
213 views
Save history editable data RDBMS
I want to make application like testing system. Every question has one or many variant of answers (and one or many can be right). I apologize that tutors and students use my testing system. It means ...
4
votes
3answers
148 views
Storing date increments in tables
I'm working on a ASP/MS SQL project that performs a lot of calculations based on dates and time. In one case, the system will lookup a value based on the nearest half hour increment throughout the ...
