Preview

Specialized Database Presentation

Satisfactory Essays
Open Document
Open Document
656 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Specialized Database Presentation
Specialized Database Presentation

Specialized Database Presentation
Team B:
Chappell Grant,
John Hainline
Linda Hannigan
DBM/384 Special Purpose Databases
Brando Sumayao

Specialized Database Presentation











Executive Overview
Strategic Goal
Proposal
Comparison of different database and purposes
SQL concepts relative to spatial and temporal databases
Uses of databases in the business environment
Description of the information retrieval process in relations to the specialized databases
Differences between Online Transaction Processing (OLTP) and Online Analytical
Processing (OLAP)
Define knowledge management and how it’s used within our organization
Conclusion

Executive Overview
The IT Strategic Plan is a visionary approach which will assist with various measurable advances which will progress the company towards our key initiatives and strategic goals over a modest two-year time frame.

Strategic Goal
Return on Investment (ROI):
• Standardize processes to increase revenue by 5%.
• Reduce technology variance to eliminate 10% of IT spend.
• Improve business operations and standardization to reduce IT operating costs by 10%.

Proposal
The use and benefits of specialty databases within the organization can help streamline the business processes.
Accurate and relevant data is critical to the success the organizations sales and marketing efforts. To maximize return on investment, using and analyzing the organizations data will help reach the customers and prospects cost effectively and efficiently.

Comparison of different database and purposes






Data Warehouse
Spatial
Relational
Distributed
Specialty

SQL concepts relative to spatial and temporal databases • SQL defines several functions to get the current date and time.
• SQL allows comparison operations on all the types of data and it allows both arithmetic and comparison operations on the various numeric types.
• SQL also provides a data type called interval, and allows

You May Also Find These Documents Helpful

  • Good Essays

    References: Coronel, C., Morris, S., & Rob, P. (2013). Database systems: Design, implementation, and management (10th ed.). Independence, KY: Cengage.…

    • 906 Words
    • 3 Pages
    Good Essays
  • Better Essays

    In this paper the writer will seek to respond to the questions designated for both scenarios. This paper will list typical fields for each type of data. Provide an example of two relationships that you need to track. This paper will also answer the questions of: Do you need a database system? If not, can Excel® handle the data and the output? What are the advantages and disadvantages? Would you use a personal database or an enterprise database? Explain your answer. Would a decision support system (DSS) be helpful? Explain your answer.…

    • 1392 Words
    • 6 Pages
    Better Essays
  • Good Essays

    1.) There have been several versions of SQL created in the last 26 years. In 1986, SQL-86 (SQL-87) was first published. In 1989, SQL-89 was a minor revision made to the original SQL. In 1992, SQL-92 (SQL2) was a major revision to its previous version. In 1999, SQL-99 (SQL3) added regular expression matching, recursive queries, triggers, non scalar types and some object oriented features. In 2003, SQL-2003 introduced XML related features, standardized sequences, and columns with auto generated values. In 2006, SQL-2006 defined ways in which SQL can be used in conjunction with XML and it defined ways of importing and storing XML data in an SQL database, manipulating it within the database and publishing both XML and conventional SQL-data in XML form. It also enables applications to integrate into their SQL code the use of XQuery. In 2008, SQL-2008 Legalized ORDER BY outside cursor definitions, added INSTEAD OF triggers, and added the TRUNCATE statement. As of March 2012, the newest SQL was released its new features include AlwaysOn SQL Server Failover Cluster Instances and Availability Groups which provides a set of options to improve database availability, Contained Databases which simplify the moving of databases between instances, new and modified Dynamic Management Views and Functions, programmability enhancements including new Spatial features, Metadata discovery, Sequence objects and the THROW statement, performance enhancements such as ColumnStore Indexes as well as improvements to OnLine and Partition level operations and security enhancements including Provisioning During Setup, new permissions, improved role management and default schema assignment for groups…

    • 701 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Texas had an average income of $50,649 from 2010-2011. The average income for 2012-2013 was $52,854 , with a 4.4…

    • 414 Words
    • 4 Pages
    Satisfactory Essays
  • Better Essays

    Database Design

    • 1196 Words
    • 5 Pages

    “A database is a structured collection of records or data that is stored in a computer system. In order for a database to be truly functional, it must not only store large amounts of record, but also be able to access those records fast and efficiently. In addition, new information and changes should also be easy to input.” (tech-faq.com) To be useful over a long term the database should be able to store all the records necessary for the business to function as well as be able to get all of this information back in case of a system failure or a crash. If all the information is loss a business could go bankrupt so the database is a fail safe for all the information the company has.…

    • 1196 Words
    • 5 Pages
    Better Essays
  • Satisfactory Essays

    Easy Jets aims and objectives are to be Europe’s preferred short-haul airline, delivering market leading returns.…

    • 262 Words
    • 1 Page
    Satisfactory Essays
  • Powerful Essays

    As an accountant, it is critical to say that many of the possible complications that arise in this case are due to feeble project management and monitoring issues. After analyzing your transcript it became visible that an apparent organizational structure ceases to exist. Examining the relationship with your business partner and the staff reaction to this matter, it is recommended that authority should be centralized and responsibilities should be delegated with accountability. Furthermore, direct reporting approach should be taken to ensure decisive information is available in an orderly manner. To take it a step further, it is advisable that formal code of conduct and policy and procedure manual is present to explain proper business practices…

    • 1287 Words
    • 6 Pages
    Powerful Essays
  • Powerful Essays

    Database Environment

    • 1121 Words
    • 5 Pages

    A database defines a structure for storing information and it collects information that is organized in such a way that a computer program can quickly select desired pieces of data. A database can also be thought of as an electronic filing system. Data and information are extracted from a database by creating a query and then submitting it to the query database management system (DBMS) and it is posed in a language that only the DBMS can understand. The query can be in the form of a question or just a keyword and once these queries run against the database, it will find a matching record (Reynolds, 2004) .…

    • 1121 Words
    • 5 Pages
    Powerful Essays
  • Best Essays

    Historically, a manual file system was composed of a system of file folders and filing cabinets.…

    • 2439 Words
    • 17 Pages
    Best Essays
  • Good Essays

    McClave, J. T., Benson, P. G., & Sincich, T. (2011). Statistics for Business and Economics (11th ed.). Retrieved from The University of Phoenix eBook Collection database.…

    • 654 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Visual Data Display

    • 799 Words
    • 4 Pages

    The clinical data supports reports of declining health, but in some cases may not correlate with information reported. The conclusions of the study are favorable, as increased monitoring of patients with chronic heart failure may result in occasional interventions that are not neccessary. This study provides an improvement in the knowledge of the patient’s condition and reaction to…

    • 799 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Presentation Data

    • 639 Words
    • 3 Pages

    For the America and the World Presentation, our team has focused on dividing into sections to work individually. Each group member is responsible for providing APA formatted slides, efficient research, and credible sources to prepare their portion of the presentation. Jesse will be the team leader and format the presentation to ensure that we attain our goal of a powerful presentation that offers consistency throughout and a theme for which we all agreed to before beginning our independent work. Our personalities are sure to present the class with adequate information, readable content, and photographs to paint the picture to what our message will be. Additionally, team members are required to present Jesse with their finished product by the end of the day on Tuesday, June 17, 2011.…

    • 639 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Database Term Paper

    • 455 Words
    • 2 Pages

    -Audit the industry 's widest range of databases for security, configuration and operational vulnerabilities, exploit root level access to collect evidence for reporting and ensure you secure you most valuable assets.…

    • 455 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Databases are defined as: a usually large collection of data organized especially for rapid search and retrieval (as by a computer). Without databases the world of technology wouldn’t be as far along as it is. Databases are used in every organization, online websites, home computer systems, and other various ones. The contents of this paper will analyze the use of Modernized Integrated Database (MIDB) within L3 Communications, Titan’s, Product Support Team (PST) in reference to Global Command and Control Systems-Maritime (GGCS-M).…

    • 758 Words
    • 4 Pages
    Good Essays
  • Better Essays

    Database Design

    • 1126 Words
    • 5 Pages

    Currently a school uses a non-computerised database system to store the following information about its students: roll class, surname, first name, guardian 's name, address, student 's date of birth, gender, sport house, emergency-contact telephone number, mailing name, list of subjects offered, and subjects in which the student is enrolled. The system takes up a large amount of space, has many duplicated entries some of these with mistakes and it is time consuming to search. The school intends to introduce a relational-database management system to overcome these problems.…

    • 1126 Words
    • 5 Pages
    Better Essays