rdbms

Though it is theoretical question but I am looking for a usecase - If we have a relational db for some aspects, and a graph db for some others, how will they integrate for the data modelling part. With some example if anyone can explain like if we wa

I am pretty new in SQL and I have the following problem trying to implement the following query on a MySql database. So I have this situation: Into my database have a table named TID023_INTERVENTO where each line of this table represent a project (fo

I feel that databases are playing the similar role as filesystems, while DBMSes play similar role as operating systems. Are databases and DBMSes implemented based on file systems and operating systems? Are databases implemented based on the data stru

I'm fetching some values from string and saving into oracle table. But at times certain values doesn't populate into the string. And, location of those values appears as empty space. So irrespective of empty space I've to add null into the table. Str

You have two tables, foo and bar, that have a M:N relationship. You want to maintain pretty extreme historical versions of both foo and bar, and also the relationship between them, such that: You insert a row into Foo, and then insert a row into Bar,

I recently found some interesting reports about graph databases where creators of it claim that these systems have much better performance, scalability and ease of use comparing to traditional RDBMS. It is said that comparing to traditional systems,

Im trying to understand the use of shared and exclusive locks. I have attempted two schedule diagrams demonstrating the use of locks on dirty and unrepeatable reads, and I just wanted verification to see if it is correct The reds represent the use of

I am using Oracle sql developer. I need to create a table: EXTPROG (ActId, ActName) ActId Varchar2(4), ActName Varchar2(10) are the two columns. ActId should always start with A How to do this while creating table?

I am new to Pentaho DI(formerly Kettle) and I am tasked with taking CSV data and populating tables in an RDBMS that are in a "One to Many" relationship. Here is an example of how the CSV data is structured: OrderID,CustomerName, Date,Total Cost,

Let's say there's this database which is flat-file, stores all information in JSON Format https://github.com/Codetana/IkarusDB I download it, But I dont know how to set it up.. Like I'm finding my way around on how to mess with different types of dat

I was trying to create a new storage plugin in apache-drill 1.4 ( we are using drill in a clustered mode ). But am getting an error in Web-UI itself while trying to create a storage plugin configuration: error ( Unable to create/ update storage) I ha

My requirement is to execute a system command like (ls) or C program when a trigger executes. Is there any way to create a trigger function to solve this problem. --------------Solutions------------- You can easily do what @a_horse_with_no_name sugge

Im new to mongo Database and reading its docs for its basic structure. Im familiar with sql database but want to learn more. refering to this link http://www.tutorialspoint.com/mongodb/mongodb_advantages.htm // here im stuck with these bolded concept

When designing a database relationship between a patient and address (hospital management) is the relationship a many to many relation ship as the input is only primary address. since if patients are relatives who live in same house wont they have sa

I am working on a project and I realized I am unsure about how to use multiple primary keys. I have a table named "User_Details" that has the details of Customer ID, email address and password. From my understanding, I can use both Customer ID a

I'm a beginner level RDBMS student. I need to manage and test SQL commands on one database on my laptop (localhost). I see 'Oracle Database Standard Edition 12c' (2.6 Gb) in the download section. So, is it free or does it need licensing? ------------

In this introductory tutorial on JDBC and Relational Databases, it is stated, Integrity Rules Relational tables follow certain integrity rules to ensure that the data they contain stay accurate and are always accessible. First, the rows in a relation