Database: It is nothing but some set of records. Records are nothing but some set of items or fields.
Data Base Management Systems(DBMS): To maintain the data, we require some systematic procedures and commands. This is called DBMS.
Data Models: Data model is nothing but a Structural information of data to be described in data base management system. There are different types of data models. Some of the data models are described below.
1. Hierarchical model: In hierarchical model, the data is represented in hierarchical form called relations. If the database complexity is more, it is not possible to retrieve the information in faster way.
Because of this drawback we go for network model.
2. Network model: In this model by establishing some relations we can retrieve the all the information which is existing in different locations at a time but the drawback is until the first person job is over second person must be waiting.
3. Relational model: In this model, the data is represented in two-dimensional(Rows and columns) tables called relations. In relational model, rows are called ‘tuples’ and columns are called ‘attributes’.
Examples for relational database management systems(RDBMS) are Oracle, Sybase, Informix, Ingress and DB2.
Out of this Oracle become so popular because it has it’s own built-in front end tool i.e, D2K. Also we can convert one platform into another platform by using IDL (Interface Definition Language).
Abbreviation of Oracle is O for Oak, R for Ridge, A for Automatic, C for Computer, L for Logical and E for Engine.
SQL: By using this, we can perform any transactions.
SQL *plus: By using this, we can set the displaying environment temporarily.
SQL *Forms: By using this, we can develop customize window basic operations.
SQL *Reports: By using this, we can take the outputs.
SQL *Graphics: By using this, we represent the information in charts like bar charts, pie charts etc.
SQL *Loader: By using this, we can insert the number of records into table at a time.
SQL *Net: It is for communication from client to server and server to client.