Relational Database Design And The No Sql Model As The...

application. Specifically, this report investigates the use of relational database design versus the no-SQL model as the preferred basis of the new application. The requirements to consider are: 1. Intensive Usage – Facebook has millions of users worldwide and produce billions of transactions. 2. Growth of the application is expected to be 10% per annum. 3.2 Definitions It is important to look at the key characteristics of these two different models in order to understand the conclusions of this report. 3.2.1 Relational Database Management Systems These systems are characterised by: †¢ A highly structured design held together by a database schema that consists: o Data pairs are stored as tuples within separate relations that are unique within the relation. o Tuples are identified uniquely with a key. o Tuples of a relation are connected to another tuple(s). †¢ Retrieval of data is achieved by a declarative programming language – SQL. †¢ The database is managed by a DBMS that provides for data retrieval (above), storage management, and transaction management. †¢ Operations are organised into transactions that are atomic units that must complete in whole or not at all. (ref – db concepts and Database Design for Mere Mortals) 3.2.2 No-SQL It is easier to compare no-SQL systems to the characteristics of traditional relational databases because they have evolved from them. No-SQL models can be characterised by: †¢ There is no real schema because the design to theShow MoreRelatedData Base Management System13582 Words   |  55 Pages lFile Organization Terms amp; Conceptscomprises a record; A computer system organizes data in a hierarchy t A computer system organizes data in a hierarchy that starts with bits and bytes and progresses to fields, records, files, and databases. * A bit represents the smallest unit of data a computer can handle. * A group of bits, called a byte, represents a single character, which can be a letter, a number, or another symbol. * A grouping of characters into a word, a groupRead MoreReview Quesition20349 Words   |  82 PagesDATABASE SOLUTIONS (2nd Edition) THOMAS M CONNOLLY CAROLYN E BEGG SOLUTIONS TO REVIEW QUESTIONS Chapter 1 Introduction- Review questions 1.1 List four examples of database systems other than those listed in Section 1.1. Some examples could be: †¢ A system that maintains component part details for a car manufacturer; †¢ An advertising company keeping details of all clients and adverts placed with them; †¢ A training company keeping course information and participants’Read MoreMIS 563 COURSE PROJECT Essay2799 Words   |  12 PagesProject Schedule†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.. 4 Database Design†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.. 4 Data Modeling Data Marts†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦. 4 Database Selection†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦. 5 ETL Selection†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.. 5 Data Mining†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦ 6 Conclusions†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦ 8 References†¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦Ã¢â‚¬ ¦.. 10 Findings: ABC University has several departmental databases that perform specific functions for each department. Within these databases are several items that can be consideredRead MoreA Data Warehouse And Business Intelligence Application2208 Words   |  9 PagesAbstract A data warehouse and business intelligence application was created as part of the Orion Sword Group project providing business intelligence to order and supply chain management to users. I worked as part of a group of four students to implement a solution. This report reflects on the process undertaken to design and implement the solution as well as my experience and positive learning outcome. Table of Contents Abstract 1 1. Introduction 3 2. Process andRead MoreA Report On Design And Implementation Of Data Models9374 Words   |  38 PagesA Report on ‘Design and Implementation of Data Models’ At American Express India Pvt. Ltd. Submitted by Alok Deshpande PRN: 14030241140 MBA (IT Business Management) (2014-2016) Symbiosis Centre for Information Technology (A constituent member of Symbiosis International University (SIU), estd., under Section 3 of UGC Act, 1956 by Notification No. F.9-12/2001-U-3 of Govt. of India) Year of submission 2015 Symbiosis Centre for Information Technology A constituent member of SymbiosisRead MoreAmerican Express : A Global Service Company7002 Words   |  29 Pagessales volume. Enterprise Growth Enterprise Growth is dedicated to pursuing new forms of payments and digital commerce that open American Express to new consumer groups, new locations across the world and newer products and services. Particularly, this leads to setting up a digital services platform for American Express, increasing options for mobile and online payment services, forming new alliances and developing new revenue generating streams beyond the traditional Card and travel businessesRead MoreThe Summer Training Project At American Express India Pvt. Ltd.9408 Words   |  38 PagesExpress provides customers with incomparable access to products, experiences and insights that enrich lives and build business success. As a result it is evident that there are numerous business processes adopted by Amex carried out by various applications under multiple portfolios. Enterprise architecture defines the way business works. The architecture can be of various types of which Data Architecture plays a vital role. Amex has divided its business into multiple portfolios based on similarRead MoreRelational Database And Relational Databases3150 Words   |  13 Pages1.1 Graph Databases A graph database represents data and relationships between this data using concepts from graph data structures like nodes, edges and properties. Nodes represents the data entities, properties represent information about the nodes and edges which connect two nodes or a node and a property represent the relationship between the connected elements. [1] Figure 3.1 Property Graph Model [2] 3.1.2 Triple stores Triple store is a specific implementation of a graph database that is optimizedRead MoreRailway Route Optimizer10483 Words   |  42 Pages 1. Organization Profile 3. System Analysis 1. Existing system 2. Problem Definition 3. Proposed System 4. Requirement Analysis 5. Requirement Specifications 6. Feasibility study 4. System Design 1. Project Modules 2. Data Dictionary 3. Data Flow Diagrams 4. E-R Diagrams 5. Hardware And Software Requirements 5. System Testing 6. Software Tools Used 7 Technical Notes 1. IntroductionRead MoreComputerize Medical Insurance System10020 Words   |  41 Pagesusage to various areas of life. The enunciation of a new era in computing as regards to health care has emerged to play a prominent role in the delivery of healthcare. The application and use of machines and computer-based technologies in health care have undergone an evolutionary process. Advance in information, telecommunication, and network technologies have led to the emergence of a revolutionary new way of health care delivery leading to new experience and knowledge that cross traditional disciplinary