The history of data models had three generations of DBMS −Hierarchical System was the first generation of DBMS. The first generation also came with the CODASYL system. Both of them introduced in 1960s.The second generation includes the Relational Model. Dr. E.F.Codd introduced it in 1970.The third generation includes Object-Relational DBMS and Object-Oriented DBMS.The history timeline of databases is shown below −File based systemsFile based systems came in 1960s and was widely used. It stores information and organize it into storage devices like a hard disk, a CD-ROM, USB, SSD, floppy disk, etc.Relational ModelRelational Model introduced by E.F.Codd in 1969. The ... Read More

Smart Data Access under Provisioning tab allows you to access and analyze the data stored in other database systems without replicating the data into HANA database. Data replication process is always time consuming and requires memory storage. Smart Data Access allows you to create virtual tables which are linked to remote system tables and data can be directly accessed in SAP HANA system with these virtual tables.You can manipulate these virtual tables and run SQL statements- SELECT, INSERT and UPDATE and even Join is permissible between virtual and local tables. When a JOIN is applied on virtual tables, SAP HANA ... Read More