|
What is the difference between graph-based databases ( http://neo4j.org/ ) and object-oriented databases ( http://www.db4o.com/ )?
Started by Gili on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
With graph databases, you have a slight semblance of a chance that it is based on mathematical....
Another important difference is that in a graphdb like was asked in the comments to this blogpost .
like shortest path or deep traversals.
|
|
Do you know of any websites, that have animations to explain topics and concepts like Databases, in a simple manner, especially for non-programmers? Something like this animated intro to Adobe Flex. Notice the clarity with which animations can explain...
Started by Jeremy Rudd on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
It isn't animated, but it's a graphic novel.
You could check out The Manga Guide to Databases .
Offering.
|
|
We would like to implement an application architecture in which we have large numbers of databases on the disk, one database file for each customer.
When a user request comes in the database is opened (if it isn't already).
After a certain period of time...
Started by Simon Wentley on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
Like this is a problem, as I don't think the modern databases really make the kind of distinctions that you're talking about internally....
It effectively uses itself to locate the information, specifically the data page caching subsystem .
|
Ask your Facebook Friends
|
I have a table ( A ) in a database that doesn't have PK's it has about 300 k records.
I have a subset copy ( B ) of that table in other database, this has only 50k and contains a backup for a given time range ( july data ).
I want to copy from the table...
Started by Oscar Reyes on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
If the overhead of a key/index would be to much to maintain, you could also query the database in your application to see whether it....
As long as no duplicate rows should exist in the table, you could apply a Unique or Primary key to all columns .
|
|
Folks,
For the n-th time in a row, i'm hitting the same old problem again. It's about "how do I map OOP structures to database tables in a painless way."
Here's a scenario: I have several types of "actors" in my system - workers, employers, contacts. ...
Started by Alex on
, 11 posts
by 11 people.
Answer Snippets (Read the full thread at stackoverflow):
I would set it up more like this:
People Table - (Just has recently regained popularity....
Would be a FK to the actorbase table to avoid 'hairy' queries and to emulate the inheritance-like looks like your data model is missing a level.
|
|
I am trying to find the best area to download SQL tables of common subjects like states, countries, zip codes. Maybe even public/government information like FDA or FCC information. Does such a resource exist and is it mature?
Started by Maximilian Morresi on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Geonames.org is a pretty good source of such data.
It's available directly from the ISO board in PDF, but can be found online elsewhere .
For states/provinces and countries, I'd recommend ISO 3166.
|
|
I have used many SQL abstraction libraries, such as ODBC, JDBC, and ActiveRecord. What are the abstraction options in the NoSQL / key-value store world?
I am mostly asking this so that if I choose a key-value store then I can use an abstraction library...
Started by Zubair on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Right now, NoSql databases are very disparate, therefore they cannot be wrapped under: some key-value stores can be iterated over easily, some can't Even if the NOSQL databases are very project aiming at defining abstractions on top....
|
|
Hey there everyone,
Sorry for the bad title, but I have no idea how to put this in short. The Problem is the following:
I have a generic item that represents a group, lets call it Car . Now this Car has attributes, that range within certain limits, lets...
Started by Tom on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
This way....
I'm not certain what can't be above 255).
Ooops, looks like somebody else already has done.
It looks like design" but we won't go there.
Validation of the attributes is typically done in the business logic of the application .
|
|
Apparently the reason for the BigTable architecture has to do with the difficulty scaling relational databases when you're dealing with the massive number of servers that Google has to deal with.
But technically speaking what exactly makes it difficult...
Started by pacman on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Relational databases put emphasis-relational databases such as Bigtable is the reverse: denormalize, to make reads much easier.
Are generally poorly suited to relational databases.
|
|
Hi Guys,
I want list of user created databases in sql server 2005. How can list all user created databases by T-SQL?
Thanks Rajesh
Started by Rajesh on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
I'm sure there is a 'better' way, but this works:
SELECT system databases are master....
The simplest way is
exec sp_databases
however that will include the system databases, so you'd need and some user databases on my server here.
|
