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.
-2
votes
0answers
37 views
I bought a membership in danish language - can i change to english? [on hold]
I bought an Adobe CS6 membership in danish language - can i change my membership to english language?
Mek Falk
0
votes
0answers
28 views
What should I consider when evaluating a database for integration into a third party software solution? [closed]
The Question
Previous experience aside, what should I consider when evaluating a database solution to choose for integration into a third party software package?
Background and additional ...
0
votes
1answer
32 views
How to model medium.com paragraph comment
If you have used medium.com, I am interested to know more about how to model readers' paragraph comments in database.
Specifically, how connections between these comments and paragraphs are modeled?
...
0
votes
2answers
35 views
DBMS recommandation for C# applications with provides triggers, procedures and if possible free [closed]
I'm here because I need somme advices about the best DBMS to use in my case. Indeed, I've only studied the theory about the databases. So I don't know a lot about the pratice.
I'm searching after a ...
1
vote
1answer
48 views
Use Database to Store Data Extracted From Internet
I'm mining 500 million users, and their "followers" from a social network using their API. The extraction of data itself is not a problem, since I can do it with my scripts. However having 500 million ...
1
vote
3answers
68 views
in-memory SQL database system [closed]
In an application, I am using mysql's TEMPORARY TABLE. Since this application does not need permanent tables, I wonder if I can find an alternative RDMS designed for memory tables. I hope to find an ...
1
vote
0answers
24 views
What database to use for easily handling join-like queries on multiple very large tables? [closed]
I'm currently looking for a database engine than can easily handle queries on multiple collections/tables (at least 5) with aprox 10M entries each.
Any advice on what to use?
0
votes
1answer
35 views
Two types of data, so two type of databases?
For a social network site, I need to propose a DB. The application is written in Java & will be hosted on VPS(s) initially.
Broadly classified there is two type of data to be stored at backend:
...
1
vote
1answer
50 views
Handling or preventing conflicts in a multi-user system
I have a web application that is accessed by multiple users from different locations worldwide. Let's say I have an "edit" form for a specific document and two (or more) users are editing the document ...
0
votes
1answer
52 views
Is PostgreSQL appropriate for processing this large but simple dataset? [closed]
I have a dataset I'm not sure how to store. The structure is simple: 30 numeric attributes identified by about 15 billion x, y, and t values. We're expecting ~17k t values and maybe 90k x/y ...
0
votes
1answer
41 views
Suitable database software for small business [closed]
First of all, I apologise if this is in the wrong area.
I'm looking for a suitable database program for a small engineering business, which needs to log various jobs. Currently, we're just using an ...
-4
votes
1answer
46 views
recommendations needed in order to become a junior DBA [closed]
I want to start off work being a junior DBA very soon. At the moment I have a Bsc in ICT 2:2 but my database marks was very strong including an 86 in my oracle assessment which is following a ...
1
vote
0answers
47 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 ...
0
votes
0answers
72 views
Choosing a database type for recording infrequent changes in a large number of variables
I am writing an application that monitors and archives the values of hundreds of thousands of variables. Since they change infrequently, only updates are recorded after the initial value.
Three ...
3
votes
0answers
78 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 ...
0
votes
1answer
57 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
147 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
342 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 ...
1
vote
1answer
86 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? ...
0
votes
0answers
59 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 ...
0
votes
2answers
83 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 ...
1
vote
1answer
126 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
votes
1answer
52 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 ...
1
vote
0answers
76 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 ...
-1
votes
1answer
123 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
83 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 ...
1
vote
1answer
76 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
...
0
votes
0answers
39 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 ...
2
votes
2answers
339 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, ...
4
votes
2answers
70 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 ...
0
votes
2answers
1k 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 ...
9
votes
1answer
135 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
101 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. ...
0
votes
1answer
74 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
2answers
113 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
114 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 ...
2
votes
1answer
146 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 ...
2
votes
1answer
213 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
127 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
3answers
247 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 ...
2
votes
2answers
137 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 ...
0
votes
1answer
259 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 ...
3
votes
2answers
289 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
167 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 ...
6
votes
4answers
2k 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, ...
3
votes
1answer
267 views
Curious Database building Problem (ER Diagram)
I am trying to build an EER Model for a Autostore that has 5 locations and offers a range of auto products. They offer car repairs and roadworthy tests as a service also.
I need to be able to make ...
11
votes
3answers
925 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 ...
1
vote
2answers
318 views
Database design experienced view
I want to make a database that stores countries, their respective states, and cities. I am confused how to normalize these. Can anyone help?
My ideas:
Table 1 Countries (id pk, name , code)
...
3
votes
3answers
136 views
Is this database fine for calculation?
I am doing an application called as Invoice Application.For that I have my database is like this.
Now my problem comes when I am taking the tax part in my database.As I have made tax as an option ...
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 ...
