In this section, the steps and considerations for selecting a suitable database are outlined and explained. These considerations have been developed by professionals through decades of research, implementation and first-hand experience. While they are not a fully set list of considerations, they are widely accepted as relevant and crucial to the developmental process. There are a number of important decisions that are needed when deciding on a suitable database.
1. Choosing the Database Model – Relational or Object etc.
2. Choosing the Database Genre/Size – E.g. Departmental, Personal, Organisational, Mobile etc.
3. Choosing the most suitable DBMS Software within that Genre
An example of this would be as follows.
1. The developer decides, using the information provided in the project requirements that the best Model suited to work with their proposed system is a Relational Database System
2. The developer decides, using the requirements specification that the database is to be Organization wide and thus represents a large database directed at this target group.
3. The developer then evaluates current technologies using a number of considerations and decides which software in the chosen Genre will be used. E.g. the developer may decide between Microsoft SQL server, Oracle or SQLite for an organisational wide relational database.
Each of these tasks present their own challenges, difficulties and sets of considerations that must be evaluated in depth in order to determine the best course of action for the current project. These challenges and decisions are explained as follows.
Choosing the Database Model
There are four main types of databases used today.
Hierarchical Model: These databases are one of the ol...
... middle of paper ...
...oss.pdf
(Last accessed 25 February 2014)
3. Bob Cravens “The Repository Pattern with Linq to Fluent NHibernate and MySQL” Available From: http://bobcravens.com/2010/06/the-repository-pattern-with-linq-to-fluent-nhibernate-and-mysql/ (Last Accessed 02 March 2014)
4. Robert Malone – Forbes “Structuring Unstructured Data” Available From http://www.forbes.com/2007/04/04/teradata-solution-software-biz-logistics-cx_rm_0405data.html (Last Accessed 26th February 2014)
5. Denish Patel- Software Development Times. “Choosing the right database: Understanding your options” Available From: http://sdt.bz/content/article.aspx?ArticleID=66407&page=1 (Last Accessed 02 March 2014)
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. .
Databases always used to fascinate me from my under graduation with great curiosity to know how large data is managed and queried. This led me to do Masters in computer science concentrating in the field of Data Management. In the course of my study, I understood the concepts of DBMS which provides a robust and efficient way of managing and mining data. Through the courses like Database Systems (ITCS 6160), Knowledge Discovery in Databases(ITCS 6162) and Knowledge Based Systems(ITCS 6155) I gained enough theoretical and practical knowledge about the importance of proper organization of data, good techniques to build an efficient database management system and how well the data can be managed.
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.
This paper was written to show the similarities and differences in five different databases. It compared Access, MySQL, SQL Server, DB2, and Oracle in six different areas. It found many similarities in functionality, but large diversity in pricing.
This database will serve a diverse range users, each with different needs. Prior to constructing this database, I created a list of questions that I suspected may have been of interest to a given stakeholder, and then ensured that my database could answer them. I have listed a sample of these questions in Appendix I and have provided relevant queries to demonstrate the usefulness of the database.
For this coursework two kinds of data models can be used. The object oriented data model, Object Oriented Database Management System(OODBMS), or the relational data model, Relational Database Management System(RDBMS). The differences between these two models and the data model to be used are described in this chapter.
The Revolution in Database Architecture, by Jim Gray, describes the path that Gray thought that the evolution of the Database Architecture would take after 2004. He considers that databases had been stagnated for several years and that, beginning in 2004, the development of several technologies would pave the way into a revolution in the database world.
My interest in Information System Development is increased, when I excelled in requirements analysis on Information Systems Development. I gained database technique in the courses ‘Database for Business’ and ‘Database Architecture and Administration’ and researched theoretical basis for Information System Development Methodolo...
The reason for the selection of this topic is because it falls under the computer science category. We have been studying databases for four years and so the this topic area will be of great use when venturing into the cooperate world.
Oracle's relational databases represent a new and exciting database technology and philosophy on campus. As the Oracle development projects continue to impact on University applications, more and more users will realize the power and capabilities of relational database technology.
As a prelude to normalization, the database modeler researches the company and current database uses to determine the requirements for the new database. Table elements and relationships are determined, and candidate keys reviewed and established for the tables. The process of database normalization then begins.
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.
DBA deals with all of this by finding user needs, set the database, and test the system. DBA should enable editing any system he or she created. At the same time DBA should ensure the security of the data and guarantee data integrity and backup. Moreover, DBAs should know the database management systems (DBMS) that include the knowledge of Oracle, IBM DB2, and Microsoft SQL server (“Database Administrator,” 2010). Oracle is one of the most important platforms that DBA must know and have experience with. According to Kanaracus “The database experience we look for most of the time is Oracle”, says Tom Hart, executive vice president of the operations and technology group at Veritude. “SQL Server is more of a nice-to-have"
A software system that enable user to define, create, maintain, and control access to the database.
In our world, people rely heavily on the power of technology every day. Kids are learning how to operate an iPad before they can even say their first word. School assignments have become virtual, making it possible to do anywhere in the world. We can receive information from across the world in less than a second with the touch of a button. Technology is a big part of our lives, and without it life just becomes a lot harder. Just like our phones have such an importance to us in our daily lives, database management systems are the same for businesses. Without this important software, it would be almost impossible for companies to complete simple daily tasks with such ease.