Database Analysis Essay Example
Database Analysis Essay Example

Database Analysis Essay Example

Available Only on StudyHippo
  • Pages: 5 (1135 words)
  • Published: December 16, 2017
  • Type: Article
View Entire Sample
Text preview

A Database Management System (DBMS) is a system that contains interconnected data and programs, allowing for data access. This system creates a database, which is a collection of related data with implicit meaning. The database, also referred to as the data collection, holds crucial information for an enterprise. The primary goal of a DBMS is to provide a convenient and efficient method for storing and retrieving database information. Database systems are specifically designed to handle substantial quantities of data.

The management of data involves two primary aspects: creating structures for information storage and providing mechanisms for information manipulation. Additionally, the database system must ensure the security of stored data, even in situations like system crashes or unauthorized access attempts. If data is meant to be shared among multiple users, the system must also prevent any potential abnorm

...

al results.

There are four main types of database management systems (DBMS) that vary in their approaches to managing database structures. One example is Hierarchical DBMS, which arranges data into a tree-like structure.

The information presentation structure permits the utilization of parent/child legislations, where a parent can have multiple children and each child only has one parent (known as I-to-many relationship). All attributes of a particular record are listed under an entity type, similar to a database table. Each individual record is shown as a row and each attribute as a column. The entity types are linked through 1: N mappings or one-to-many relationships. IBM introduced this model, referred to as the first database model, in the asses.

The two most commonly used hierarchical databases are AIMS, developed by IBM, and Windows Registry, created by Microsoft. Network DB'S

View entire sample
Join StudyHippo to see entire essay

are utilized in scenarios where the data in the database exhibits many-to-many relationships. These relationships create a network structure that adds complexity to the database. In a network database, one record can function as a key for the entire database. The structure of this type of database is depicted as a graph, which is a data structure comprising elements like records and sets to represent many-to-many relationships.

Mainly, high-level languages like Pascal, COBOL, and FORTRAN were utilized to implement records and set structures. Some well-known database systems using the network model include:
* Integrated Data Store (IDS)
* DIMS (Integrated Database Management System)
* 3RD Embedded
* 3RD server
* Turbocharger
* antic DMS-1100 c.

Relational DB'S pertains to when database relationships are represented in table form. There are three keys in relational DB'S:
1) relation
2) domain
3) attributes.

A network comprises fundamental constructs, sets, or records.

The use of sets and records in a database helps to manage one-to-many relationships and organize data in a static table format. Sets contain multiple elements, while records consist of fields that create rows and columns. This table functions as an array in computer memory, providing structure to the database. The relational model offers a declarative approach for specifying data and queries, enabling users to express their desired data storage and retrieval preferences. Ultimately, it is the responsibility of the database management system software to describe the structures for storing and retrieving data.

There are various Orders available, including popular ones such as Oracle, Sybase, Ingress, Inform, Microsoft SQL Server, and Microsoft Access. Object-oriented DB'S represents information using objects as used in object-oriented programming. Object databases differ from table-oriented relational databases. Object-relational databases combine elements of

both approaches. Object databases have been under consideration since the early asses.

Object-oriented databases offer superior capabilities compared to other database types as they can handle diverse data types such as graphics, photographs, audio, and video. On the other hand, hierarchical and network databases are designed specifically for structured data that can be organized into fields, rows, and columns. These databases are especially useful when managing smaller information components like names, addresses, zip codes, product numbers, statistics or numerical data.

An object-oriented database can store data from various media sources and generate multimedia output. Examples of databases used on different types of computers include A) Microcomputer - Myself, MASC., Postures, Oracle; B) Minicomputer - Oracle, Ingress; C) Mainframe - DIMS. Inform is a widely utilized database server in the industry, catering to users ranging from large corporations to start-ups worldwide.

The Inform software incorporates unique design concepts that set it apart from traditional relational platforms. This results in outstanding performance and availability, exceptional data replication and scalability capabilities, and minimal administrative workload. Furthermore, the most popular database in the Philippines is Myself, which is also widely used abroad alongside Oracle.

Microsoft SQL Server is the database used in Open Office. The terms related to databases are as follows:

* Database- a collection of related files that are usually integrated, linked or cross-referenced to one another.
* DIMS- (Integrated Database Management System) It was first developed at B. F. Goodrich and later marketed by Culminate Database Systems (renamed Cellulite in 1983).
* 3RD Embedded- Aroma Database Manager (or 3RD) is a high performance, ACID-compliant database management system divided into three environments; Mobile, Embedded and Desktop &

Server.

The text states that 3RD has been designed to utilize multi-core computers, networking, and storage options such as in-memory or on-disk storage. It mentions that 3RD Server is a database management system that supports both C/C++ and SQL Apish for programming flexibility, and it can handle disk or memory resident databases. The text also highlights Turbocharger-IMAGE as a reliable and fast database that played a significant role in the success of HAPPEN, which was later renamed Turbocharger/XSL after the PA-RISC migration. Lastly, it mentions that the SO 2200 database managers are all part of Univac DMS-1100.

The Universal Data System (LIDS) is a common control structure that supports multiple data models. Some influential programming languages include Pascal, known for its imperative and procedural style. COBOL is one of the oldest languages and is commonly used in business, finance, and administrative systems. FORTRAN, developed by IBM in south San Jose, California, is a general-purpose language used for numeric computation and scientific computing. The Relational database management system (READS) is based on the relational model developed by E. F. Cod of Vim's San Jose Research Laboratory. Many popular databases today follow this model. Oracle, produced by Oracle Corporation, is an object-relational database management system. Sybase, from SAP Company, offers enterprise software and services for managing, analyzing, and mobilizing information using relational databases, analytics, data warehousing solutions, and mobile application development platforms.

Ingress is an open-source SQL relational database management system that is commercially supported. It is designed to cater to large commercial and government applications. The Ingress Database has a global community of contributors and is fully open-source. Inform, a product family within Vim's Information Management division,

focuses on various relational database management system offerings. Microsoft SQL Server, developed by Microsoft, is a relational database management system that functions as software to store and retrieve data upon request from other software applications.

Get an explanation on any task
Get unstuck with the help of our AI assistant in seconds
New