I was on a phone interview today and he mentioned something about a "dynamic database" and I have NO idea what this is, I tried googling it and finding a wiki and found nothing, can you guys help me out?
I got one link that might be what they're talking about here. The sense I get from it is that a dynamic database refers to a system that alters the database schema (adding/altering fields/tables as needed) in order to accommodate the needs of the system as those needs change.
That is very interesting actually, makes me wonder how they do it...
they will probably have a special table with table setup which they use to know how to treat each data table
__________________________________________
I study Information Systems at Karlstad University when I'm not on CodeCall
One of the keys to working with databases is the concept of Meta-Data. For example, in most databases (Access being an obvious exception), you can get a list of tables/fields with a simple SQL query. You can actually write a program that will query an Oracle database to determine the tables, fields, etc in it and then recreate that table structure in MS SQL Server. It's a pretty short program!
Usually when I work with databases I have used 1 to 1 tables, 1 to many, and many to many, lots of joins etc.
With this, a table describing how to modify a table dynamically, and running into things like that.
How much more advanced is this? Will it take a while to grasp? I do believe I will even be able to get into the concept of it until I start working... well I could make a few tables and try to dynamically change them here and there... I dunno just depends.
A lot of it would simply depend on what you're trying to do.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Bookmarks