types of databases?

sathiyavathi · #1 (**permalink**) 07-30-12, 14:58

please specify the types of databases.................

papadi · #2 (**permalink**) 08-01-12, 00:11

You have most likely received no replies because your question is too broad.

You need to explain what you are looking for. It does not really matter that you know what you are looking for - the people who would help do not understand what you are looking for. Cite a couple of examples and we may be able to proceed from there.

riyaraj · #3 (**permalink**) 08-10-12, 03:58

There are two main types of database; flat-file and relational.

Flat file:The flat-file style of database are ideal for small amounts of data that needs to be human readable or edited by hand.

Relational database:the relational databases such as MySQL, Microsoft SQL Server and Oracle, have a much more logical structure in the way that it stores data. Tables can be used to represent real world objects, with each field acting like an attribute.

papadi · #4 (**permalink**) 08-10-12, 15:49

Quote:

There are two main types of database; flat-file and relational.

Completely not true . . .

Maybe TS will provide some clarification and we can then answer the "real" question.

sathiyavathi · #5 (**permalink**) 09-10-12, 05:23

Quote:

Originally Posted by riyaraj

There are two main types of database; flat-file and relational.

Flat file:The flat-file style of database are ideal for small amounts of data that needs to be human readable or edited by hand.

Relational database:the relational databases such as MySQL, Microsoft SQL Server and Oracle, have a much more logical structure in the way that it stores data. Tables can be used to represent real world objects, with each field acting like an attribute.

Thanks for your information

papadi · #6 (**permalink**) 09-10-12, 16:13

How do you intend to use the "information" you quoted?

Designers provide the logical structure - not the database product. There are many non-relational database systems (NOT flat-file style) that are quite properly "structured".

If you post what you really want to know/learn, someone will probably be able to clarify.

jrbbldr · #7 (**permalink**) 09-13-12, 09:59

A problem frequently encountered is the mis-use of the term DATABASE itself.

Too many times individuals use the term DATABASE, when they mean APPLICATION development language/tool which may or may not 'talk' to a DATABASE.

Also the term DATABASE is often used in-accurately to describe some file (often some form of a text or Excel file) containing Data - which is not a DATABASE.

And some older application development languages/tools used the term DATABASE to describe Data Tables which are not DATABASES.

Finally there are DATABASE SERVERS (such as MS SQL, MySQL, Oracle, Sybase, PostgreSQL, DB2, Informix, etc.) which are 'intelligent' servers, often with their own 'language', which can deliver data back to or receive data from an application (often developed in another language) when the appropriate commands are issued.

As was asked before, your helping us to understand what you are going to do with the information on this WAY TOO GENERAL question might enable us to answer your question in a manner more focused towards your needs.

Good Luck

sathiyavathi · #8 (**permalink**) 09-24-12, 07:50

Quote:

Originally Posted by jrbbldr

A problem frequently encountered is the mis-use of the term DATABASE itself.

Too many times individuals use the term DATABASE, when they mean APPLICATION development language/tool which may or may not 'talk' to a DATABASE.

Also the term DATABASE is often used in-accurately to describe some file (often some form of a text or Excel file) containing Data - which is not a DATABASE.

And some older application development languages/tools used the term DATABASE to describe Data Tables which are not DATABASES.

Finally there are DATABASE SERVERS (such as MS SQL, MySQL, Oracle, Sybase, PostgreSQL, DB2, Informix, etc.) which are 'intelligent' servers, often with their own 'language', which can deliver data back to or receive data from an application (often developed in another language) when the appropriate commands are issued.

As was asked before, your helping us to understand what you are going to do with the information on this WAY TOO GENERAL question might enable us to answer your question in a manner more focused towards your needs.

Good Luck

Thanks for your information with detailed manner...