strenght of relational model

2600 Words6 Pages
bulb-icon

Recommended: Brief history of database

Introduction

The first database systems were based on the network and hierarchical models. A database can be defined as a collection of non-redundant data which can be shared by different application systems. A database implies separation of physical storage from use of the data by an application program to achieve program/data independence. Using a database system, the user or programmer or application specialist need not know the details of how the data are stored and such details are usually "transparent" to the user. .

These are covered briefly in appendices in the text. The relational model was first proposed by E.F. Codd in 1970 and the first such systems were developed in 1970s. The relational model is now the dominant model for commercial data processing applications. The relational model can be used in both conceptual and logical database design. The basic structure in the model is a table .Tables consists of rows and columns. Relationships in the relational model are represented implicitly through common attributes between different relations.

The relational model consist of a relational structure, a set of integrity rules, and data manipulation operations. The relational structure is based on the representation of data in the form of tables. A table contains rows and columns, with each row representing an individual record, and each column representing a field for each record. Tables are related via indirect indexes of primary and foreign keys. The operations that are performed on these tables in order to store, manipulate and access this data include union, intersection, join, division, restriction, projection, assignment, difference, and product.
How do you know if the relational model best fits your intended application? An application that requires on-line transaction processing (OLTP) where multiple files are updated simultaneously could benefit from the table structure of the relational model. The relational model provides the ability to quickly insert data into tables. However, when it comes to querying--getting data out of the database--the relational model can be slower because it doesn’t support direct access in multiple joins that are possible with the network model. An RDBMS-based application requires the traversal of indexes to get at related data in other files and this requires additional disk accesses and CPU cycles. The more tables involved and the greater the volume of records in these tables the more time is spent in accessing disk storage to get a result set. But while the relational model has the power to meet heavy-duty OLTP needs--get data into the database--it is also an excellent choice for simple databases and for an inexperienced database designer.

Show More
Related

  • Mark Knapp Relational Model

    1980 Words  | 4 Pages

    Researcher Mark Knapp is best-known for describing and developing a 10 step model of relational stages, it explains how relationships come together and how they come apart (Alder, pg 287). I decided to take one of my past relationships with an ex-boyfriend of mine through Mark Knapp's relational stages model. I will be referring to my ex-boyfriend as Johnny throughout this paper.

    Read More

  • Turner and the Glorification of Westward Expansion

    1629 Words  | 4 Pages

    ...ed on Westward expansion, then it is none too appealing to realize that Westward expansion meant the brutal conquest of the native population. To come to grips with this reality, Native Americans were pushed out the conscious of Americans. Westward expansion is much more palpable if the West is viewed as free, open land that was ripe for the taking – as described in Turner’s thesis. When Americans were finally confronted with the fact that Native Americans had occupied the land, the Natives were depicted as brutes that were not capable of correctly taking care of the land. Overtime, however, historians have been able to modify Turner’s thesis into a more balanced argument. Turner’s thesis, however, remains important due to the fact that it is such a clear representation of American attitudes about the frontier and Westward expansion at the turn of the century.

    Read More

  • Negative Relational Maintenance

    1681 Words  | 4 Pages

    The purpose of this study was to investigate if there is a correlation between adult’s attachment styles and the use of negative relational maintenance behaviors in romantic relationships. Studies suggest, depending on an individual’s perception of self as well as others in correspondence to their attachment style determines the social behaviors practiced in maintaining a relationship either by positive or negative practices. As Goodboy and Bolkan hypothesize in “Attachment and the Use of Negative Relational Maintenance Behaviors in Romantic Relationships” one’s adult attachment style may explain the antisocial behaviors in a negative maintenance of a romantic relationship. Furthermore, the study looks to observe a link between adult attachment

    Read More

  • Relational Practice

    927 Words  | 2 Pages

    Being a nurse and belonging to nursing society is not easy and it requires a lot of hard work and also for individuals to have some outstanding characters in order to be successful. As for me, the thing I find in common with me and nursing is that I’m compassionate, Honest, and have self-confidence; To me those are some key elements one need to have in order to fit in the nursing society and in this essay I will be explaining how those key elements relate me to the nursing society.

    Read More

  • Oracle Databases

    1555 Words  | 4 Pages

    A database is a structured collection of data. Data refers to the characteristics of people, things, and events. Oracle stores each data item in its own field. For example, a person's first name, date of birth, and their postal code are each stored in separate fields. The name of a field usually reflects...

    Read More

  • American Progress John Gast

    526 Words  | 2 Pages

    John Gast’s painting titled American Progress perfectly portrays the idea of manifest destiny that was engulfing the minds of Americans. In the right side of the painting you see western influence with the boats, a bridge in the distance, and trains with little or no track in front of them allowing the mind to think they are pushing west. In the middle of the landscape are horses, buggies, covered wagons, showing a slight increase in modernity compared to what is to the far left of the painting, the Indians, savages. Gast also places that of western influence in the light and the old primitive way on the dark. This is not coincidence, the idea that primitive behavior is improper and in the dark of what it could be is precisely what Gast wanted to present. You also see in bottom left corner an animal showing its teeth, another signal of the danger that the move west is. What is probably noticed first is the woman in the center of the painting. The angel is the guiding light of manifest destiny, the one who is bringing the light that you see so prominently in the right side of the pa...

    Read More

  • Financial Analysis of Oracle Corp

    2599 Words  | 6 Pages

    In 1977, Larry Ellison, Bob Miner, and Ed Oates founded System Development Laboratories. After being inspired by a research paper written in 1970 by an IBM researcher titled “A Relational Model of Data for Large Shared Data Banks” they decided to build a new type of database called a relational database system. The original project on the relational database system was for the government (Central Intelligence Agency) and was dubbed ‘Oracle.’ They thought this would be appropriate because the meaning of Oracle is source of wisdom.

    Read More

  • Essay On The Relationship Between Americans And Land

    451 Words  | 1 Pages

    In his chapter, “Reporting to the President, September 23-December 31, 1806,” Ambrose tells how disappointed Thomas Jefferson was when he discovered the Northwest Passage did not exist. Jefferson sent men to search for lucrative, new lands to be inhabited. This shows how Jefferson was eager for land to make profit off of the passage. The chapter also gives insight to the relationship between Americans and the land by telling the readers how interested in trade and profit settlers were settlers were in trade and profit. Ambrose's chapter clearly depicts the desire for

    Read More

  • The Power of Relationships

    1336 Words  | 3 Pages

    Relationships between two people can have a strong bond and through poetry can have an everlasting life. The relationship can be between a mother and a child, a man and a woman, or of one person reaching out to their love. No matter what kind of relationship there is, the bond between the two people is shown through literary devices to enhance the romantic impression upon the reader. Through Dudley Randall’s “Ballad of Birmingham,” Ben Jonson’s “To Celia,” and William Shakespeare’s “Shall I Compare Thee to a Summer’s Day?” relationships are viewed as a powerful bond, an everlasting love, and even a romantic hymn.

    Read More

  • Relational Power

    680 Words  | 2 Pages

    Honest to goodness Power Additionally called "positional power," this is the power people have from their part and status inside an association. True blue power for the most part includes formal specialist appointed to the holder of the position. Referent Power Referent power originates from the capacity of people to pull in others and construct their dependability. It depends on the identity and relational abilities of the power holder. A man might be appreciated due to a particular individual characteristic, for example, charm or affability, and these constructive sentiments turn into the reason for relational impact.

    Read More

  • Privacy and Security Issues in Data Mining

    1885 Words  | 4 Pages

    [7] Elmasri & Navathe. Fundamentals of database systems, 4th edition. Addison-Wesley, Redwood City, CA. 2004.

    Read More

  • Normalization and Integrity

    1055 Words  | 3 Pages

    Inconsistently storing organization data creates a lot of issues, a poor database design can cause security, integrity and normalization related issues. Majority of these issues are due to redundancy and weak data integrity and irregular storage, it is an ongoing challenge for every organization and it is important for organization and DBA to build logical, conceptual and efficient design for database. In today’s complex database systems Normalization, Data Integrity and security plays a key role. Normalization as design approach helps to minimize data redundancy and optimizes data structure by systematically and properly placing data in to appropriate groupings, a successful normalize designed follows “First Normalization Flow”, “Second Normalization Flow” and “Third Normalization flow”. Data integrity helps to increase accuracy and consistency of data over its entire life cycle, it also help keep track of database objects and ensure that each object is created, formatted and maintained properly. It is critical aspect of database design which involves “Database Structure Integrity” and “Semantic data Integrity”. Database Security is another high priority and critical issue for every organization, data breaches continue to dominate business and IT, building a secure system is as much important like Normalization and Data Integrity. Secure system helps to protect data from unauthorized users, data masking and data encryption are preferred technology used by DBA to protect data.

    Read More

  • Domain Relational Calculus: A Form Of Relational Calculus

    799 Words  | 2 Pages

    where x1, x2, … , xn represents domain variables. P represents a formula composed of atoms.

    Read More

  • Database Management System and Retrieval Information System

    1788 Words  | 4 Pages

    A database-management system (DBMS) is a group of organized data and a set of programs have access to some data. This is a collection of related data without any doubt meaning and thus is a database. The collection data usually referred to as the database, have something information directly connected to an enterprise. The main goal of a DBMS is to provide a way to store up and save some of database information that is both well-located and useful. From data, the user known facts that can be recorded and that have trusted the meaning. For example, consider the names, telephone numbers, and addresses of the people may we know.

    Read More

  • Database

    761 Words  | 2 Pages

    Databases are becoming as common in the workplace as the stapler. Businesses use databases to keep track of payroll, vacations, inventory, and a multitude of other taske of which are to vast to mention here. Basically businesses use databases anytime a large amount of data must be stored in such a manor that it can easily be searched, categorized and recalled in different means that can be easily read and understood by the end user. Databases are used extensively where I work. In fact, since Hyperion Solutions is a database and financial intelligence software developing company we produce one. To keep the material within scope I shall narrow the use of databases down to what we use just in the Orlando office of Hyperion Solutions alone.

    Read More

More about strenght of relational model

Open Document