Previous in Forum: VAL 2 or any other Robot programming language   Next in Forum: How to configure web,app server with data base
Close
Close
Close
4 comments
Rate Comments: Nested
Participant

Join Date: Jul 2007
Posts: 3

database management

08/12/2007 7:24 AM

1)what are the advantages of having database management system?

2)what are the database models and resons behind the the popularity of the relational model?

3)what are the imerging technologies and concepts of database management system?

4)what are the commercial off the shelf database management systems along with compatible operating systems?

Register to Reply
Pathfinder Tags: dbms
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.
Anonymous Poster
#1

Re: database management

08/13/2007 12:02 AM
Register to Reply
Guru

Join Date: May 2007
Location: Budapest, Hungary, HA5YAR
Posts: 617
Good Answers: 14
#2

Re: database management

08/13/2007 1:45 AM

1) You don't have to deal with the number of files, the fields, the physical location

2) Two models: hierarchical and relational. Hierarchicals are the good old IBM DBOMP and DL1, relationals are for example DB2, ABADAS, SQL-variants

3) Try to read this: Rob - Coronel: Database systems, ISBN 0-7600-1090-0

4) It depends on the category of your system. SQL-variants almost cover the whole spectrum.

__________________
Aged man is not old man...
Register to Reply
Power-User
United States - US - Statue of Liberty - Technical Fields - Education -

Join Date: Mar 2006
Location: In the middle of the USA
Posts: 334
Good Answers: 14
#3

Re: database management

08/13/2007 10:44 AM

Wow. these questions are almost like, "I want to buy a car, what's the best one?"

There are many different relational databases to chose from. As a rule, relational db are much easier to work with than hierarchical since you can easily make changes on the fly.

The biggest considerations are how many users you will have, where they will be located, where the db will be located, and how big/many records you will be tracking.

For example, my small group (15 folks) uses a Microsoft Access database to track time, effort and progress spent on projects (currently about 200). It works for us in that we can tailor reporting easily. FoxPro would probably work as well, but our company had already bought Access. Our db is on a shared drive and we can all access it easily from our LAN.

There are other db designed for larger deployments, such as Oracle and SQL Server. In this case, you would need to consider the machine that will hold the db. These would also work better if users will access the db via the Internet.

Just a few thoughts. If you ask our friend, Mr. Google, he will be able to give you bunches of products, but you'll have to sit down an g through these recommendations to find the best fit for your organization.

__________________
"Reality is merely an illusion, albeit a very persistent one." -- Albert Einstein
Register to Reply
Anonymous Poster
#4

Re: database management

08/14/2007 2:24 PM

1) It take 5 min to search through filing cabinet and 5 sec in a database.

2) Same as above

3) There are software to build database software according to the database structure and interface user specified.

4) Too many to name.


What is the 6 number for next lottery?

Pineapple

Register to Reply
Register to Reply 4 comments
Copy to Clipboard

Users who posted comments:

Anonymous Poster (2); bp01 (1); Qqberci (1)

Previous in Forum: VAL 2 or any other Robot programming language   Next in Forum: How to configure web,app server with data base

Advertisement