Free Essay

Database Model

In: Computers and Technology

Submitted By mido14
Words 1233
Pages 5
Learning Team A Week 6- Learning Team Reflexion
Jose Banks, Kirk Williams, Cadence Scott, Frank Carr, Marika Hughey, Elmehdi Ibnamar
DBM/502 Database Management
June 25th, 2012
Liz Musil

In the late 1960s and early 1970s, there were two mainstream approaches to constructing database Management System’s (DBMS’s). The first approach was based on the hierarchical data model typified by IMS (information Management System). The second approach was based on the network data model, which its main aim of creation was to create a standard database that would unify number of functionalities such as programming languages (queries) for data retrieval, and the inability of the existing database to represent complex relationships database management systems
(DBMS). However, these two models had some fundamental disadvantages:
• Complex programs had to be written to answer even simple queries
• There was minimal data independence
• There was no widely accepted theoretical foundation. In reference to DBMS and the ability of building complex relational system, many Relational database management system RDBMS has been developed (also referred as a second generation of
DBMSs). RDBMS was used extensively in the 80’s and 90’s, however due to its limitation to respond the more complex entity and, needs of companies and the increasing complexity of database applications. Two “new” data models have emerged; the Object-Relational Database Management
Systems (ORDBMS) and Object-Oriented Database Management Systems (OODBMS), which subscribes to the relational and object data models respectively. The OODBMS and ORDBMS have been combined to represent the third generation of Database Management Systems.
Current trends of database model: 1. Distributed databases: Distributed databases are the most common databases utilized over the companies and in professional environments. Distributed database means that Parts of the database are stored physically in one location, and other parts are stored and maintained in other locations. There are two main ways of distributing a database. The central database can be partitioned so that each remote processor has the necessary data to serve its local area. Changes in local files can be

justified with the central database on a batch basis, often at night.
Another strategy is to replicate the central database at all remote locations. This strategy also requires updating of the central database off hours. advantage and drawbacks of distributed processing and distributed databases Distributed systems reduce the vulnerability of a single, massive central site. They permit increases in systems’ power by purchasing smaller less expensive computers. Finally, they increase service and responsiveness to local users. Distributed systems, however, are dependent on high quality telecommunication lines, which themselves are vulnerable. Moreover, local databases can sometimes depart from central data standards and definitions, and they pose security problems by widely distributing access to sensitive data. The economies of distribution can be lost when remote sites buy more computing power than they need. Despite these drawbacks, distributed processing is growing rapidly.

2. Object Oriented and Hybrid Models Object oriented database management system (OODBMS) is a complex technology that necessitates a profound knowledge of the object, and class. The objective is to search and manipulate data about objects, which have complex inner data structures. A hybrid Models is a combination of OODBMS and RDBMS.
Traditional DBMS including RDBMS store only data without the procedure required to manipulate and retrieve data. However, the OODBMS store objects. An object contains data about an entity, and also the methods that process those data. An object may be anything to which a concept applies, e.g. a number, a document, a vector, a sound or an image.
The complexity of OODBMS resides in the facts that one object may have contain another object and that object may in his turn contain another object, and at the end we could have a tree of hierarchical objects. This enables the capture of highly complex data structures.
Unlike the relational data model, the object-oriented data model is not based on a formal

mathematical model, but is a collection of concepts such as data and behavior encapsulation, inheritance, reuse and message passing, which have proved to be of great use in developing applications. These and other concepts allow the OODBMS to capture more of the semantics of the real world. However, although OODBMS have significant strengths, they are not free of limitations, the foremost of which is the lack of a strong underlying theory. Further, for OODBMS there still exists the lack of a standardized easy-to-use query language.
Object oriented and hypermedia databases can store graphics and other types of data in addition to conventional text data to support multimedia applications. Hyper media databases allow data to be stored in nodes linked together in any pattern established by the user. Web sites use a hypermedia database approach to store information as interconnected pages containing text, sound, video and graphics. 3. Data warehouse Data warehouse is standardized and consolidated platform, so that it can be used across the enterprise for management analysis and decision-making. The data is available for anyone to access as needed but cannot be altered. A data warehouse system includes a range of ad hoc and standardized query tools, analytical tools, and graphical reporting facilities. These systems can perform high-level analysis of patterns or trends, but they can also drill into more details when needed. Database warehouses not only offer improved information, but also they make it easy for decision makers to obtain it. They even include the ability to model and remodel the data. These systems also enable decision makers to access data as often as they need without affecting the performance of the underlying operational systems. 4. Database cloud computing There are a number of advantages to using the Web to access an organization’s internal database. Web browser software is extremely easy to use, requiring much less training than even user-friendly database query tools. The web interface requires no changes to the legacy database.
Companies leverage their investments in older systems because it cost much less to add a Web

interface in front of a legacy system than to redesign and rebuild the system to improve user access. http://www.cpaireland.ie/UserFiles/File/students/Articles/DatabaseITarticle.pdf

Future database Models The desired evolution of DBMSs, therefore, could take the form of a Postrelational DBMS that decouples the storage mechanism from the access mechanism. One way to think of this is that there is an underlying DBMS that operates only in terms of very generic database concepts, analogous to an abstract class in object-oriented programming. A DBMS implementation could be derived from this base DBMS that applied the constraints and assumptions of a particular model to the data.
Additional DBMS implementations could also be placed on top of the base DBMS, all having native and natural access to the data. Another way to look at this is to think of a data model as a type of view - it is a user's perception of the data. The underlying storage mechanism does not need to necessarily conform to that view internally, but only to ensure that the view remains consistent for the consumers of that view. http://www.informationweek.com/news/development/database/229209559 References:
Database Resources, Subject: Information Technology for Managers, author’s name: Seamus Rispin, Retrieved from: http://www.cpaireland.ie/UserFiles/File/students/Articles/DatabaseITarticle.pdf

DBMS Past, Present, and Future, published date: October 01, 2008 12:00 AM, retrieved from: http://www.informationweek.com/news/development/database/229209559

Similar Documents

Free Essay

Database Models Assignment

...MGT321 Management Info Systems Database Models Assignment The organization I am using is for a database model is a Fortune 500 behavioral marketing company that focuses on grocery shopper’s behaviors and trends to create targeted brand media to the shopper at the point-of-sale (POS). This organization employs 800 people across the United States, with their corporate headquarters being in Florida, employees in remote offices, ones who work from home, as well as international employees in 4 countries; Germany, the United Kingdom, Japan and France. We will call this company “Mayani Marketing Inc.” The database model chosen for this company is Relational, based on the fact that most of the departmental data is already based in Oracle, Microsoft Access and SQL Server and MySQL. The type of data this company specializes in is shopping basket information. These transactions are captured in the millions per day over a 20,000+ network nationwide, and are encrypted to provide security to the shopper identities, which are never linked to their shopping basket data (the use of frequent shopper cards and loyalty programs help this data collection). There is a data warehouse that is comprised of multiple IBM Blade servers as well as two Netezza TwinFin servers that are the platform of the data warehouse structure. Mayani is also taking advantage of Netezza's partnership of i-class advanced analytics, which partners the data warehousing with SAS and Micro Strategy to harness all of...

Words: 742 - Pages: 3

Premium Essay

Business Rules & Database Models

...Entities, Attributes, Business Rules and Database Models CIS111 Deontae Gaskins Ali Rahat-Zafar Strayer University April 13, 2016 Entities, Attributes, Business Rules and Database Models A database is defined as a grouped and organized set of data held in a computer system. A college database, therefore, can be defined as a small repository for its operational data. A college can use a database to access, manage and update its functional data. Additionally, it can use the database to track the information regarding its instructors; students, courses taught, and students' grades. A college needs an effective data management system. Such a system should be a collection of software, data, hardware, and users that are necessary to help the college manage its operational data. The major function of any database management system is to provide reliable and efficient methods of retrieving data to users. Therefore, a college database management system needs to be designed in a way that will allow several users to access several data items simultaneously or a similar data item frequently. Entities and attributes STUDENTS STUDENTS GRADES GRADES INSTRUCTORS INSTRUCTORS COURSES COURSES Diagram 1: A simple entity-relationship model. The above entity-relationship model is essential in designing a college database. Such entity-relationship model must use the concepts of the entity, attribute and relationship intuitively. Entities are key objects in the college...

Words: 799 - Pages: 4

Premium Essay

Cis 111 Assignment 1

...Assignment 1: Business Rules and Data Models A database is an incorporated PC structure that stores end-user information and metadata (Leake, A.). Data is the raw format of information, which when structured properly, it can produce accurate, relevant, and timely information that is the key to making a good database management system. The true purpose of a database is to provide computer-based systems a way in which to store, manage, and retrieve data quickly. A local college has tasked me to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and courses, the client wants me to make the database keep track of the instructors teaching each of the courses. The local college database, will be to store the data of enrolled students, the courses offered and class schedule, and the information of the instructors. The database will provide course matches for each student based off previous courses taken and pre-requisites obtained, as well as keep track of the instructors that are teaching the class. The database will provide the data a student needs to insure they are taking the correct courses and provide the college and the faculty general student information, such as student ID. Entities (Tables) are defined as a person, place, thing, or event in which data is collected and stored. Each entity is a unique object that may be a physical or abstract object within real life (for example:...

Words: 780 - Pages: 4

Premium Essay

Database Application Systems Development

...Q2: How are database application systems developed? A database application system consists of a database, a DBMS, and one or more database applications. A database application consists of forms, reports, queries, and possibly application programs. A database application system encompasses one or more application programs and works at a more macro level; application programs, on the other hand, focus on smaller components and work on smaller pieces of data management. The major steps in developing an application system are to interview users and develop requirements for the new system; this includes analyzing existing forms, reports, queries, and other user activities, as well as determining the need for new forms, reports, and queries. They can then use this to create a data model (logical representation of the structure of the data), which is then transformed into a database design. After that, the design is implemented in a database, which is then filled with user data. Users are especially important in the first step of the process, where incorrect, insufficient, or inaccurate user input will result in a poorly designed database that will not fill the voids of current systems. Q5: What is the users’ role? The major role for users in the development state is in the first step; users are the final judges as to what data the database should contain and how the records in that database should be related to one another. During the data modeling stage, the structure...

Words: 371 - Pages: 2

Free Essay

Database Assigment

...SDLC do database development activities occur? 3. Are there procedures and processes that are common to the use of SDLC, prototyping, and agile methodologies? Explain any that you can identify and then indicate why the methodologies are considered to be different even though fundamental procedures and processes are still included. 4. Explain the differences between user views, a conceptual schema, and an internal schema as different perspectives of the same database. 5. In the three-schema architecture: a) The view of a manager or other type of user is called the schema. b) The view of the data architect or data administrator is called the schema. c) The view of the database administrator is called the schema. 6. Why might Pine Valley Furniture Company need a data warehouse? 7. As the ability to handle large amounts of data improves, describe three business areas where these very large databases are being used effectively. 8. In the section "Disadvantages of File Processing Systems," the statement is made that the disadvantages of file processing systems can also be limitations of databases, depending on how an organization manages its databases. First, why do organizations create multiple databases, not...

Words: 408 - Pages: 2

Free Essay

Mountain View Community Hospital

...Community Hospital 1. Mountain View Community Hospital (MVCH) wants to provide better services than their current deliverables. Therefore, databases can help MVCH reach their goal through making relational applications provide information about clients or patients without having a book or paperwork to search for every time. A centralized database application that is not a conjunction of separate applications makes information fluid and accessible without much of a hassle. For example, when a surgeon at MVCH would want information of a patient who has visited before, the surgeon could run an application on a handheld device that collects information from the database. At the same time, when the doctor is checking the file information on the patient, the nurse or other staff member can also access the information of the patient to know what is wrong with the patient exactly. This was, the efficiency of doctors and other members of the hospital can work in collaboration flawlessly. If the database is managed well, when government inspections are taken, the hospital can provide the required information as soon as possible, keeping the hospital’s integrity to the mark with the government. 2. Database technology can take various forms when it comes to complying with security standards of patients and their information. Firstly, the database can hold information of the patients that cannot be revealed to anyone in the hospital without certain security procedures (such as passwords/pins/usernames...

Words: 850 - Pages: 4

Premium Essay

Cis 111

...Database management system (DBMS) A database management system (DBMS) is a program, or a collection of programs, through which users interact with a database. The actual manipulation of the underlying database is handled by the DBMS. In some cases, users may interact with the DBMS directly. In other cases, users may interact with programs such as those created with Visual Basic, Java, Perl, PHP, or C++; these programs, in turn, interact with the DBMS, as shown in Figure 1-9. In either case, only the DBMS actually accesses the database. It typically supports query languages, which are in fact high-level programming languages, dedicated database languages that considerably simplify writing database application programs. Database languages also simplify the database organization as well as retrieving and presenting information from it. A DBMS provides facilities for controlling data access, enforcing data integrity, managing concurrency control, recovering the database after failures and restoring it from backup files, as well as maintaining database security. Entity An entity is a person, place, object, event, or idea for which you want to store and process data. The entities of interest to Premiere Products, for example, are sales reps, customers, orders, and parts. Attribute, Column, Field An attribute is a characteristic or property of an entity. The term is used in this text exactly as it is used in everyday English. An attribute is also called a field or column in...

Words: 858 - Pages: 4

Premium Essay

Database Modeling

...Database Modeling Tool INF322 Instructor June 27, 2011 Database Modeling Tool The company has grown exponentially over the past 6 months and needs to develop a new database to house its financial, inventory, and client data. It has been decided to build this new database in house rather than purchase a system from a third party vendor. As part of the development of this database it is in the company’s best interest to utilize a database modeling tool to help the design effort. Utilizing a database modeling tool will offer the following benefits: 1. Simple graphic representation of the data structure. 2. Visual work flow of how data will be entered, modified, and reported. 3. Bulk editor capabilities. 4. Database design generator. 5. Database reverse engineering. 6. Logical and physical data model reporting. The tool that looks to be the best fit for the company is CA Erwin Data Modeler r8. CA Erwin Data Modeler r8 was developed by Logic Works Inc. Logic Works Inc. has been in business as a database modeling solution since 1988 (Carreon, 1996) and continues to be one of the top data modeling providers. CA Erwin Data Modeler r8 is the most balanced data modeler tool when comparing functionality, simplicity, and cost when to its competitors. CA Erwin has very user friendly graphical representation of both the logical and physical data models. No other competing modeler has both of these capabilities within the same function. It has all of...

Words: 477 - Pages: 2

Premium Essay

Database

...Data Models Chapter 1: Introduction $  $  • Purpose of Database Systems • Data Definition Language • Data Manipulation Language • Transaction Management & ' & • Storage Management • Database Administrator • Database Users • Overall System Structure 1.1 Silberschatz, Korth and Sudarshan c 1997 Database Systems Concepts Database Management System (DBMS) • Collection of interrelated data • Set of programs to access the data • DBMS contains information about a particular enterprise • DBMS provides an environment that it both convenient and efficient to use Database Systems Concepts 1.2 Silberschatz, Korth and Sudarshan c 1997 ' & ' & Purpose of Database Systems $  $  Database management systems were developed to handle the following difficulties of typical file-processing systems supported by conventional operating systems. • Data redundancy and inconsistency • Difficulty in accessing data • Data isolation – multiple files and formats • Integrity problems • Atomicity of updates • Concurrent access by multiple users • Security problems Database Systems Concepts 1.3 Silberschatz, Korth and Sudarshan c 1997 View of Data An architecture for a database system view level view 1 view 2 … view n logical level physical level Database Systems Concepts 1.4 Silberschatz, Korth and Sudarshan c 1997 ' & ' & Levels of Abstraction $  $  • Physical level: describes how a record (e.g., customer) is stored. • Logical level: describes data stored in database, and...

Words: 1023 - Pages: 5

Premium Essay

Dbm 502 Week One

...Material Database Environment, Development Process, and Staffing Tables Part I Database Environment Table Describe each component of the database environment, and provide a common vendor-supplied example or an example of how this component relates to the rest of the database environment. |Components |Description |Example | |Database Management |The Computer Software application that |MySQL, MS-SQL, Oracle IBM DB2.. Etc | |System (DBMS) |interacts with the user and other applications | | |Repository |A storage location for safety of preservation |Dimensions, Maven, | |Metadata |Data the describes other data. |Card Catalogs in the old days, Digital | | | |Photos have metadata describing the photo| | | |location, apature size, etc. | |Case Tools |Computer aided software engineering tools. A |Umbrello, Visio (Kinda) etc. | | |domain of tools to design and implement | | | |software | | |Database ...

Words: 1500 - Pages: 6

Premium Essay

Review Questions: Chapter 1

...Questions: Chapter 1 1.1. Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application. • Data – known facts that can be recorded and that have implicit meaning. • Database – a collection of related data with an implicit meaning. • DBMS – a collection of programs that enables users to create and maintain a database • Database system – not only contains the database itself bit also a complete definition or description of the database structure and constrains. • Database catalog – the information about the database structure is stored in the Database Catalog which contains the structure of each file, the type and storage format of each data item, and various constrains of the data. • Program-Data Independence – DBMS access programs do not require changes in all programs due to the change in the structure of a file because the structure of data files is stored in the DBMS catalog separately from the access programs. • User View – a database typically has many users, and each of whom may require a different perspective or view of the database. A view may be a subset of the database or it may contain virtual data the is derived from the database files but is not explicitly stored. • DBA – a database administrator (short form DBA) is a person responsible for...

Words: 2493 - Pages: 10

Premium Essay

Is 380 Assignment 1

...380 Assignment 1 Chapter 1 1. A database stores: a. End-user data: raw facts of interest to end user b. Metadata: data about data, which the end-user data are integrated and managed) 2. A collection of programs that manages the database structure and controls access to the data stored in the database: Database management system (DBMS) 3. This is when you can change the file structure without affecting the application’s ability to access the data: structural independence 4. This occurs when not all of the required changes in the redundant data are made successfully: data anomaly 5. These are the functions of a DBMS: c. Intermediary between user and database d. Enables data to be shared e. Presents the end user with an integrated view of the data f. Receives & translates application requests into operations required to fulfill requests. g. Hides database’s internal complexity from the application programs and users 6. This is the de facto query language and data access standard supported by the majority of DBMS vendors: structured query language (SQL) 7. People naturally have an integrated view of the data in their environment. This leads to a new problem that has evolved with the use of spreadsheets and desktop databases. This problem is users lack proper data-modeling and database design skills. Chapter 2 8. This type of data model was developed in the 1960’s to manage...

Words: 738 - Pages: 3

Premium Essay

Management Information Systems: Managing the Digital Firm

...MBA635 – ELP ASSIGNMENT – WEEK 01 Avinash Shankar Coleman University Database Integration – A framework The Physical Database Design depicts the actual structure of a set of relational tables specific to the platform and Database Management Systems (DBMS) on which the database is implemented. It is used to transition a logical data design into a physical database design that can be used to generate Data Definition Language (DDL). It also takes the current Systems environment into consideration, as well as some non-functional requirements. Basically the Physical Database Design is the implementation of the logical data design with any changes needed for physical considerations, such as capacity and performance. A physical database design is performed in three stages (LePendu, P., & Dou, D., 2011, p. 217 to 244): 1. Logical database design, which includes gathering of business requirements, developing a logical data model, and designing how to load the data 2. Conversion of the logical data design into a Physical Database Design includes table definitions, primary and foreign key relationships, and basic indexing 3. Post deployment Physical Database Design (often performed by a database administrator) includes improving performance, reducing I/O, and streamlining administration tasks. Data Integration Layer The data integration layer should be modeled in 3rd normal form or near 3rd normal form and is considered to be similar to an operational data design...

Words: 582 - Pages: 3

Premium Essay

Database Lab

...Lab 1.3 (Group B) – Create a Statement of Work Step 1: Read the Grandfield College scenario on p. 18 of the textbook. Step 2: Identify the major topics for this database Step 3: Write a draft statement of work that includes the scope, objectives, and a preliminary timeline. You will need to turn in a Word document to the instructor by the end of class. Step 2: Major Topics for Database: a. Software b. Software Version c. Licensed Agreement d. Machine e. Machine Location f. Install Data g. Software Request h. Availability i. Software location j. Access level Step 3: Scope Grandfield College wants a database to track faculty and staff computers, what software is installed on each, who has access to each computer, and requests for new software. Being able to track install issues would also be of great benefit for easier troubleshooting. Objectives ● Track what software is installed and removed and the licensing and type of install (local vs. server) for the software on faculty and staff computers in one place. ● Track the location of the faculty and staff computers and who has access to each. ● Track requests for new software and when software is checked out to faculty with administrator privileges on their machines. Tasks and Timeline 1. Gathering Data: This task will consist of obtaining the spreadsheets that contain the lists of the listing of software, the type of licensing for the software...

Words: 459 - Pages: 2

Premium Essay

Information Technology

...CCIS2701 – Database Design and SQL Chapter 1 Review Questions Page 1 of 3 1. Discuss each of the following terms: a. data - Data are raw, unprocessed facts about a thing. They have little meaning unless organized. b. field – A field is a group of characters with a specific meaning, used to store data c. record – A connected set of fields. A record containes fields used to describe a specific person, place, thing or event. d. File – A collection of related records. A file may contain records for all students enrolled at a university, for example. 2. What is data redundancy and which characteristics of the file system can lead to it? Data redundancy occurs when the same data are store in multiple locations. It can lead to data inconsistency, where different and conflicting versions of the data appear in different places. It can also cause data anomalies, as a change event may require more than one change to the data. 3. It is said that some file systems lack data independence. Discuss. All programs that access a file system will need to be changed if any characteristics of the file system’s data changes. This is referred to as data dependence. 4. What is a DBMS, and what are its functions? A database management system is a collection of programs that manages the database structure and controls access to the information stored in a database. Consistent organization and controlled access allows the information in a database to be shared...

Words: 966 - Pages: 4