What is a hierarchical database?
Hierarchical database management system is closely followed by network database. Many things in the real world are organized hierarchically. The hierarchical data model is proposed first to simulate this hierarchically organized thing. Hierarchical databases also access data by record. The most basic data relationship in a hierarchical data model is the basic hierarchical relationship, which represents a one-to-many relationship between two records, also known as a parent-child relationship (PCR). The database has and only one record type without parents, called the root node. Other record types have and have only one parent. The mapping from one node to the parent in the hierarchy model is unique, so the overall structure of the hierarchical model can be represented by just pointing out the parent of each record type (outside of the root node). The hierarchical model is tree-like. The most famous and typical hierarchical database system is IBM's IMS (Information Management System), the oldest large database system program product developed by IBM. Since the end of the 60, has now developed to IMSV6, providing clustering, n-channel data sharing, message queue sharing and other advanced features of support. This 30-year-old database product plays a new role in today's WWW application connection and business intelligence applications.
What is a genome sequence database?
Gsdb is a genome sequence database (genome Sequence Data Base), created by the National Genome Resource Center of Santa Fe, New Mexico, USA. Gsdb collects, manages and publishes complete DNA sequences and related information to meet the needs of genome sequencing centers. The database uses the server-client relational database model, the large-scale sequencing organization can submit the data to the server through the computer network, and checks the data before sending to ensure the quality of the data. The format of entries in the GSDB database is basically consistent with the GenBank, the main difference being that the gsdbid identifier is added to the GSDB database. The GSDB database can be queried through the World Wide Web, or by using the server-client relational database. In either case, familiarity with database Structured Query Language SQL is helpful for better use of the GSDB database.
What is a relational database?
A relational database stores data in rows and columns so that it can be understood by the user. This series of rows and columns is called a table, and a set of tables makes up the database. Users use Queries (query) to retrieve data from the database. A query is a SELECT statement that specifies the rows and columns of a database. A relational database typically contains the following components:
Client applications (clients)
database servers (server)
Databases (database)
Structured Query Language (SQL) client-side and server-side bridges, the client uses SQL to send requests as server-side, and server returns the results of client-side requirements. Large relational databases that are now popular are IBM DB2, IBM UDB, Oracle, SQL Server, SyBase, Informix, and so on.