Questions tagged [rdbms]

Relational Database Management System, a widely used type of database management system characterised by its extensive use of joining as a core operational principle.

Filter by
Sorted by
Tagged with
1
vote
1answer
338 views

Database Design Concept - Are Multiple Relationships A Bad Thing?

I have a question about Relational Database design. I'm just learning the basics of databases, so bare with me, in that I'm not sure of the technical terms for some of the concepts I'm trying to ...
0
votes
1answer
395 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: ...
7
votes
1answer
3k views

Full text search through many tables in MySQL

We have high traffic NEWS websites, I want to add a feature that every user can search through over all content of site, such as news, polls, comments, galleries,etc . Each of contents type has its ...
3
votes
1answer
84 views

Plan for managing financial transactions in an easily and retrievable manner, indefinitely

I've got a large (many columns) MySQL database table (InnoDB) that has a fairly high number of INSERTs (~500/day). Think of the rows as financial transactions. Clients need to be able to view these ...
0
votes
1answer
199 views

Database design in MySQL

I am designing a database for an web application, in this system there are multiple users. Consider, Public (Buyer). Merchant. Tele Marketing Executive(TME). Marketing Executive(ME). Lead Generator......
1
vote
1answer
2k views

How does Postgres know which logs have been archived?

I'm asking this because Postgres was hard-stopped yesterday, and I fear that there could be partial / corrupt data in one of my archived log segments. I'd like to simply delete the logs from my slave ...
0
votes
1answer
421 views

SQL Server automatic transaction log truncation

Have looked through msdn but cant find answers to these: Any help much appreciated: In simple recovery mode: Is there any TSQL or alternative functionality that will provide a notification either ...
32
votes
6answers
9k views

Why don't databases create their own indexes automatically?

I would have thought that databases would know enough about what they encounter often and be able to respond to the demands they're placed under that they could decide to add indexes to highly ...
0
votes
2answers
416 views

Partitioning MySQL for “expired” transactions to improve performance

I am dealing with an existing application that uses the database as a sort of transaction log in several cases, for example orders or payments. These tables are large (20 - 60 million rows) and poorly ...
2
votes
2answers
1k views

How to perform ETL from RDBMS to Neo4j

I have a mature 50+ tables web application based on mySQL. In order to do some advanced data mining I want to use Neo4j and the goodnes of cypher. However I'm having a hard time migrating my data from ...
0
votes
2answers
487 views

Storing data in PostgreSQL: One table or two?

I've just started using PostgreSQL 9.2 and my data consists of product prices at various points in time, usually a different price every month. Question: Because every product can have different ...
0
votes
2answers
109 views

Accessing Database without using SQL

This might be some ambiguous but I have not much info about this so I need some start point; As a general idea; in conventional RDBMS', there are a DB engine and storage of data. We use the language '...
-1
votes
1answer
91 views

best database for a real estate system [closed]

Which is the best database suits for a real estate system. Considering the storage space, security, crash recoveries, speed etc. There will be around 1000 fields and trillions of rows!!!
75
votes
5answers
35k views

Which database could handle storage of billions/trillions of records?

We are looking at developing a tool to capture and analyze netflow data, of which we gather tremendous amounts of. Each day we capture about ~1.4 billion flow records which would look like this in ...
23
votes
1answer
13k views

Using MongoDB and PostgreSQL together

My current project is essentially a run of the mill document management system. That said, there are some wrinkles (surprise, surprise). While some of the wrinkles are fairly specific to the project,...
1
vote
1answer
479 views

join the two tables which possess one to many relationship

In drupal,the content type table and my own table is used to do some operations. Im having two tables namely Table1:'content_field_mem_id' & Table2:'Ex' description of ...
6
votes
2answers
6k views

A database in MySQL is a schema in Oracle : I do not understand this statement

Please help me understand this statement: A database in MySQL is a schema in Oracle. I have just started to use Oracle and I find it different from other RDBMS softwares I have used like MSSQL, ...
9
votes
5answers
21k views

Why is optimistic locking faster than pessimistic locking?

Both forms of locking cause a process to wait for a correct copy of the record if its currently in use by another process. With pessimistic locking, the lock mechanism comes from the DB itself (a ...
1
vote
2answers
231 views

How does optimistic locking actually enforce re-read/update?

My understanding of optimistic locking is that it uses a timestamp on each record in a table to determine the "version" of the record, so that when the record is access by multiple processes at the ...
4
votes
3answers
2k views

STARTUP command fails : Why is that?

I just installed Oracle Database Express Edition 11g Release 2.This is the first time I am using Oracle. Earlier I have used MySql and MSSql and I bet this one is a lot different ! These are the ...
7
votes
3answers
27k views

Detecting SQL Server Utilization with a query

My current project will send queries to an sql server constantly and It may use 100% of the memory or CPU. How can I check if the server is nearing full utilization in a stored procedure so that I ...
31
votes
5answers
3k views

Is it OK to keep a value which updates in a table?

We are developing a platform for prepaid cards, which basically holds data about cards and their balance, payments, etc. Up until now we had a Card entity which has a collection of Account entity, ...
1
vote
1answer
1k views

Connecting to a SQL Server database from a Flash program [closed]

I currently have the ability to utilize Microsoft SQL Server 2012. I am developing a project with Adobe Flash Builder 4.7. If I link my database with Adobe Flash Builder is there any additional ...
4
votes
1answer
563 views

Big Data vs Relational Database on making structure of Data-ware house for telecom data analysis [closed]

I'm currently doing my final year project on telecommunication mining. On starting project I got confuse on choosing database. As data on mobile communication is going on increasing so I think Big ...
3
votes
2answers
923 views

SQL Server 2008 R2 Database Diagram Error Code

I have sysadmin privileges on a SQL Server 2008 R2 server. I'm working with the development database and want to save a database diagram I created. When I try to save I get the following error message:...
5
votes
1answer
401 views

Optimised Schema for City-to-City Distance Table

This is my first question, forgive me if this question is simple. I'm stuck here, trying to implement the relationships for the data represented below. I want to scale it vertically (new rows), ...
6
votes
1answer
592 views

Determining which isolation level is appropriate

This is a homework question. For the following transactions state the isolation level that will maximize throughput without lowering the integrity of the database. Explain the answer. ...
2
votes
1answer
323 views

Is there a major RDBMS that DOESN'T allow column name quoting/escaping?

The title basically says it: Are there any major DBs that don't handle column name quoting/escaping? For instance, suppose I want to have a column called FROM (and let's assume I have a really good ...
3
votes
1answer
987 views

Restriction on self referencing on insert in MYSQL?

How to restrict insert on adding self-referencing rows in a recursive relation table (a table contains foreign key points itself)? mysql> SELECT * FROM Employee; +-----+------+-------------+-----...
4
votes
1answer
1k views

How to Update same table on deletion in MYSQL?

In my Database I have a table: Employee with recursive association, an employee can be boss of other employee. Following is query I used to create table: CREATE TABLE IF NOT EXISTS `Employee` (...
0
votes
1answer
132 views

How are transactions logs inserted?

I have an ms-access database at work that has a table that's a transaction log. The table contains the following fields: Date - The date the transaction took place. Table_Name - Name of the ...
12
votes
1answer
4k views

Commit vs Fast Commit vs Commit Cleanout in Oracle Database

I was wondering whether someone could verify my understanding regarding the differences between those 3 terms as pertaining to Oracle Databases. Many sources confuse these terms and do not explain ...
8
votes
2answers
381 views

How to modify an update in Oracle so it performs faster?

I have this query: UPDATE ( SELECT h.valid_through_dt, h.LAST_UPDATE_TMSTMP FROM ETL_FEE_SCH_TMP d, FEE_SCHEDULE_HISTORICAL h WHERE h.FUND_ID = d.FUND_ID AND h....
3
votes
1answer
565 views

Surrogate key / Primary key: Better to use an existing unique data field or create a key field?

I am not sure if this question has been asked or not. At least I couldn't find it. I am curious about a primary key in terms of efficiency with data searching and retrieval. This is a hypothetical ...
11
votes
3answers
3k views

Use MySQL to regularly do multi-way joins on 100+ GB tables?

Background: I’ve created a web application that I would like to be able to scale reasonably well. I know I'm not Google or Twitter, but my app uses a fairly large amount of data for each user and thus ...
1
vote
1answer
453 views

Which RDBMS best fits my need? [closed]

I realise this may be come a subjective mess, but I'm hoping for some objective information on the subject. I also don't want to go shopping, I just want to know 'what to shop for'. I'm very new to ...
1
vote
1answer
111 views

Storing many small - and a few large - strings in an RDBMS

Let's say I have a table, and (among other things) it needs to store a large number of strings. Most will be small (20-100 characters), but a few will be quite large. Reads will be frequent, writes ...
3
votes
1answer
63 views

Why isn't there a way to label a column as “keyword”

In a typical star schema, you end up with a bunch of columns that are an ID into some lookup table, where the lookup table is pretty much just this: create table hostnames ( id primary key, ...
1
vote
1answer
788 views

file not found - how to remove its configuration?

I run oracle 10.2.0.5. I have the following: SQL> select file#, status, error, recover, tablespace_name, name 2 from v$datafile_header 3 where recover='YES' 4 or (RECOVER IS NULL AND ...
2
votes
3answers
1k views

Which database is best for deeply embedded database or through C DLL?

I want a deeply embedded database. Deeply embedded means that the server is started by an application and closed by the application with no tcp/ip or 0 port. The main features of consideration are: ...
0
votes
1answer
503 views

which DBMS should i go for? [closed]

I am interested in learning a DBMS. As a beginner which DBMS should i go for ? I know few DBMS by name like Oracle,Sql Server,My Sql . How are these DBMS different from each other ? As a beginner ...
1
vote
1answer
446 views

Is there an Oracle rdbms monitoring API?

We have about a thousand customers with our application installed out of which 500 have an oracle database. Monitoring the database is only one of the requirements. Installing Oracle Enterprise ...
4
votes
1answer
282 views

how much overhead an error in RDBMS has?

I have a class in my project. On the class I need to do two inner select, to know is there any duplication or not, but I think if I get duplication error and then manage that is better than to select. ...
3
votes
6answers
1k views

Is normalization process needed?

Well after learning DBMS as a subject i got so many questions in mind. Normalization is one of them. As i learnt it there was a lot more confusion and i found that whatever we do in normalization ...
13
votes
2answers
1k views

NoSQL and RDBMS together?

I was wondering if there are any good solutions for recording data in a NoSQL database and then converting them over to an RDBMS? For example, if you wanted to capture some data quickly, like ...
1
vote
4answers
16k views

What's a good client tool to access Oracle RDBMS? [closed]

I'm looking for a good client tool to replace "Oracle SQL Developer" (the tool I currently use) which supports: Oracle DB 10g, 10gR2, 11g Running SQL code Debugging SQL code (with walk-through... ...
7
votes
2answers
2k views

Single Drive vs Multiple Drives

Generally bottleneck of RDBMS (I am a MySQL user) performance is disk access. SSD provides great performance compared with conventional spindle drives. Question : Is it possible to improve ...
3
votes
3answers
3k views

How does an OLAP cube database differ from an RDBMS?

Is a cube database, simply an RDBMS—such as PostgreSQL or MySQL—configured for OLAP via a star or snowflake schema? Or is a cube database different from an RDBMS, and if so how?
19
votes
5answers
6k views

Is ROLLBACK a fast operation?

Is it true that RDBMS systems are optimized for COMMIT operations? How much slower/faster are ROLLBACK operations and why?
4
votes
1answer
2k views

How mature is the Firebird database when compared with PostgreSQL and MySQL?

I have used PostgreSQL with small projects and MySQL is running in production environment. No issues with them. I have been hearing of Firebird which is again a solid RDBMS in the open-source area. ...