I am working with Jsbs and want to select a DBMS for my application that require a native XML database. Can you people guide me? 1) how many DBMS are supported by Java (is it true almost all DBMS are supported by java?) 2) Which one will be the best selection for XML storage and retrieval? Thanks in advance. ...
I Understand Character sets but I don't understand Collation. I know you get a default collation with every Character set in Mysql or any RDBMS but I still don't get it! Can someone please explain in layman terms? Thank you in advance ;-) ...
What is Locking in MySQL (or any RDBMS) and when would you use it? A Layman explanation with a Example would be great! Thank you in advance;-) ...
Is there a database out there that gives you the benefit of referential integrity and being able to use a SQL type language for querying, but also lets entities be loosely defined with respect to their data attributes and also the relationships between them? E.g. take a RBAC type model where you have Permissions, Users, User Groups & Ro...
I've read some article say that RDBMS such as MySQL is not good at scalable,but NoSQL such as MongoDB can shard well. I want to know which feature that RDBMS provided make itself can not shard well. ...
Suppose I have a table with a column name varchar(20), and I store a row with name = "abcdef". INSERT INTO tab(id, name) values(12, 'abcdef'); How is the memory allocation for name done in this case? There are two ways I can think of: a) 20 bytes is allocated but only 6 used. In this case varchar2 does not have any significant adva...
I'm trying to use Pentaho Data Integration / Pan to make a type-2 (SCD) table. After I ran my data through a DimensionLookup step a first time, I got a type-2 table that looks like: PKID version date_from date_to MyPK Field1 Field2 ... 150 1 1900-01-01 00:00:00 2199-12-31 23:59:59 1 "X"...
Hi everybody, We are about to solve a customer's need of a web based application that holds a big amount of products and their data - including prices, weights, physical volyme, and much more. Everything but the prices are data that is data that will be stored once, and then probably not changed. The prices on the other hand will be u...
I need to know the factoring that needs to be taken into consideration when implementing a solution using CouchDB. I understand that CouchDB does not require normalization and that the standard techniques that I use in RDBMS development are mostly thrown away. But what exactly are the costs involved. I perfectly understand the benefits,...
We have BigTable from Google, Hadoop, actively contributed by Yahoo, Dynamo from Amazon all aiming towards one common goal - making data management as scalable as possible. By scalability what I understand is that the cost of the usage should not go up drastically when the size of data increases. RDBMS's are slow when the amount of...
Is it possible to retrieve information like: the tables the indexes with the columns they index the columns in each table along with their types constraints like unique keys, foreign keys, not null .. using sql from all (major) RDBMSs? I know it is possible for oracle and assume it is possible for most others. Are there any importa...
I'd like to compare if tables columns including datatypes and length/precision. indexes and their columns constraints in two database schemas are identical. Is there anything like this available? Maybe from one of the database migration managing tools? ...
I have a database of all countries and cities, I would like to use ajax to use it to give suggesstions in the country cities fields in forms, I have a lot of tables in my db related to the inner workings of the site. Is it ok if I put this in a different database (just this world map database)? I rather put it in a different db so it's m...
What kind of projects benefit from using a NoSQL database instead of rdbms wrapped by an ORM? Examples: Stackoverflow similiar sites? Social communities? forums? ...
I've looked at MongoDB/norm (but want a general document-oriented store answer). It seems really nice to work with and I'm interested in knowing when it should be used instead of RDBMS+ORM? What should i use for for instance: Stackoverflow similiar sites Social communities forums (I posted another more general question but it got a...
Couple of days ago I came across a website that offered (R)DBMS as a service. I did not find it useful at that moment. Now I might have changed my mind and I just can't find that website anywhere in the browser history. I recall that it only required an email address to send you the db/account info to. And there was the line "yes, that'...
I'm writing a strategy-kind of multi user game for the web. It has a playfield (X by Y squares) that I plan on serialize and store in a BLOB in a MySQL (innodb) database, one row for each ongoing game. I now try to figure out a good way of keeping the database updated with any changes to the playfield, and at the same time finding a c...
How do you design and manage the development of a web application that should be compatible with multiple database management system such as Oracle and MS SQL Server? If you can't use ORM like NHibernate or EF, how do you maintain database schemas during the development? My approach now is to have a development database on SQL Server...
There are so many products which are rdbms like oracle,mysql,SqlServer etc.... But what about dbms related products?Is foxpro dbms ? ...
I want to implement one-to-many concept in my application. This is the scenario, i have two tables (i). Person(ID, NAME, AGE, DEPT) (ii). Person Responsibilities(ID, RESP'S). One person may have more than one resp's. How shall i implement 1-n Relationship here. Actually, i cant able to understand the correct concept of this. Any s...