...Database Concepts Unit 1 Research Assignment 1 Exploring Programming Languages SQL, in a simplest form, is a data sublanguage purposely invented to provide an interface to a relational database such as Oracle Database, and all SQL statements are instructions to the database. SQL provide benefits for all types of users, including application programmers, database administrators, managers, and end users. Some of its features include processing sets of data as groups rather than as individual units, as well as provide automatic navigation to the data. Since SQL was first created there have been three major changes to the program and eleven minor changes. The latest major change addressed the requirement for objects and "object identifiers" in SQL and also specifies supporting features such as encapsulation, subtypes, inheritance, and polymorphism. Microsoft SQL Express is a free edition of SQL Server that is ideal for learning, developing, powering desktop, web & small server applications, and for redistribution by ISVs. It includes the full version of SQL Server 2014 Management Studio and provides LocalDB; a lightweight version of Express that has all its programmability features, yet runs in user mode and has a fast, zero-configuration installation and short list of pre-requisites. Use this if you need a simple way to create and work with databases from code. Microsoft SQL Express even has the options of adding tools or advanced services to the express package. Like...
Words: 375 - Pages: 2
...Friday class 6-10 pm Unit 1 research paper 1 Computers are an amazing tool that we as a people have developed. Computers help people in so many ways it almost seems like life would be impossible without them. Computers are used in pretty much every aspect of life in today’s world. The technology of computers is amazing and it just continues to get more powerful every day. Computers have had an impact in just about every industry in the world. Computers made medical procedures so much easier. Now doctors can do surgery using cameras and computers. This makes it easier for the doctor and results in less mistakes and better recovery. The patients receive smaller openings when receiving computer integrated surgery. The doctor can move a lot more accurately and cut more accurately with this technology. Another way that computers have impacted the world is by harnessing the power of the internet. The internet is a great tool for everybody. It makes studying and researching a lot easier for students. It also helps people communicate. Communication has never been easier. People in the United States can talk to somebody across the world with a click of a button. This also means people are more aware of what goes on throughout the world. Computers are also in cars. Google has developed a car that can drive itself. This is huge because the computer can actually drive your car for you. According to Technology review.com “Google’s cars have successfully driven more than 700,000 miles...
Words: 402 - Pages: 2
...Unit 1 Research Paper 1: Paradigm Shift Introduction In the past, virtual reality technology was thought of by many as a gimmick, and the hope for it to become a mainstream technology was discarded as products did not work as how the public envisioned. However, the proper technology is now available to make virtual reality just that: a reality. The entertainment industry is on the verge of a monumental paradigm shift that will completely transform the way these entertainment mediums are experienced. The typical experience of video games is one with a controller with joysticks that are used to control where the playable character is looking along with a monitor or television screen in front of the player. Today, this scenario is so typical that the detachment between the player and what is happening on the screen is something considered to be normal in the experience. In the next couple years however, this detachment will be largely erased as working virtual reality headsets become available to consumers across the world. Summary of Key Findings One notable product in the field of virtual reality technology is the Oculus Rift. What makes this product and others like it different from the virtual reality fad that permeated the entertainment industry a few decades ago? The Rift uses 360 degree low latency head tracking, an integral part of the complete virtual experience. In previous VR headsets, the latency, or delay, between a player’s head movement and the visual representation...
Words: 658 - Pages: 3
...| Exploring Programming Language | Unit 1 Research Assignment 1 | | | 5/3/2014 | PT1420 | The five most popular programming languages in the 1970’s were: 1970: Pascal 1972: C 1972: Smalltalk 1972: Prolog 1973: SQL Pascal The Pascal programming language was developed by Niklaus Wirth. It was created in 1968 but it wasn’t published until 1970. It was developed to provide the features other programming languages didn’t offer at that time. His main reason for developing Pascal was efficiently implement and run, to allow for the development of structured and well organized programs, and to serve as a tool to teach the important concepts of computer programming. The program was named after a mathematician named Blaise Pascal. It was used as the primary language in the Apple Lisa and for the Mac in the early years of the computer. SQL SQL, which is short for, Structured Query Language, was designed by an IBM research center in 1974-1975. The Oracle Corporation introduced it as a commercial database system in 1979, the first time it was introduced. It has been a favorite query language for the use of database management systems for the microcomputer and mainframes, but is being supported by the PC database. C C was created at the Bell Laboratory in 1972 by Dennis Ritchie. It was created for the purpose in designing UNIX. Prolog Was created from 1971-1973 and was distributed in 1974-1975. It was created not as a programming language on purpose but...
Words: 988 - Pages: 4
...Michael Malate June 23, 2013 SP2520 Unit 1 Research Assignment 1: Exploring Programming Languages From the looks of it there seems to be 14 different revisions of the SQL standard. * SQL Server version 1.0: SQL Server version 1.0 is a 16 bit server modeled in the year 1989 for supporting OS/2. * SQL Server version 1.1: SQL Server version 1.1 is also a 16 bit server designed in the year 1991 to support OS/2. * SQL Server version 4.2: SQL Server version 4.2 was released in the year 1992. SQL 4.2 is bundled with IBM OS/2 1.3 version. * SQL Server version 4.21: In the year 1993, Microsoft server 4.21 came into existence. SQL 4.21 was the first version of SQL Server that supports Windows NT. * SQL Server version 6.0: In 1995, SQL Server version 6.0 was introduced. After Windows NT, Sybase and Microsoft parted and worked on their individual design. SQL Server version 6.0 was the chief version aimed in provision of Windows NT by Microsoft. * SQL Server version 6.5: SQL Server version 6.5 got released in the year 1996. * SQL Server version 7.0: SQL Server version 7.0 was the rewritten version from Sybase legal code. The code name of SQL Server version 7.0 is Sphinx. SQL Server version 7.0 was introduced in 1998. In 1999, SQL Server version 7.0 with OLAP tools came into site. * SQL Server version 8.0 / SQL Server version 2000: SQL Server version 2000 was the first one made of IA-64 architecture. Several advancements have been made in SQL Server version...
Words: 1606 - Pages: 7
...3D Printing: Impacting Our Future 3D Printing, also known as additive manufacturing, is a technology that has been around for a while already, but in recent years technological advances have made it significantly cheaper and more attainable for many people. You can print 3D images designed on a computer with a 3D modeling program, or you can scan an object with a 3D scanner to be replicated. To print the model of the digital file the program hypothetically slices the image into a bunch of different horizontal layers. There are a few technologies used for 3D printing, the most widespread technologies are Selective Laser Sintering (SLS), and Fused Deposition Modeling (FDM). In the SLS method a high powered laser melts and fuses tiny particles of metal, plastic, ceramic, or glass powder until the desired shape is achieved. In the FDM process a continuous feed of metal or plastic wire is fed through a heated nozzle melting the material briefly while it forms the object. One major impact that 3D printing could impact the future is bio-printing, or the replication of human bodily tissue through 3D printing. If you’re in need of a new kidney, instead of waiting for a compatible donor, the doctor, in theory, would be able to go to his computer load up kidney.obj press ctrl + p and within minutes begin the operation. There are many more ways the technology could help the medical fields of study, such as reproducing human bones or blood vessels. Artificial limbs could...
Words: 680 - Pages: 3
...There are many technological advancements that has changed the way we live today. One of these technologies is laser eye surgery. Laser eye surgery is eye surgery using lasers that reshapes the cornea (the front clear part of the eye), shifting its focusing power to improve vision. Laser eye surgery is being used every day to correct vision for those who are farsighted and near sighted, and few other vision problems. There are different types of laser eye surgery but the most commonly used type is Lasik. In the near future, laser eye surgery can positively impact our lives, and here are three reasons. Laser eye surgery improves poor vision overall. The results are instantaneous, surgery usually last from 10-15 minutes per eye. Depending on the type of surgery, once the surgery is successfully performed, a person can see and feel the drastic improvements within few days. As technology grows, using this enhancement will reduce the amount of people who having problems seeing whether far or near. There would be more people in the world with 20/20 vision. Perhaps as we continue to advance in technological growth, correction to vision might exceed 20/20 and our eye sight might be sharper than 10 times better than what we see right now. Another benefit with the use of laser eye surgery is individuals will no longer need glasses or contact lens. Following the surgery, patients can discontinue the use of any of those items. So for those who find themselves using bifocals, or reading...
Words: 338 - Pages: 2
...Christopher Hernandez GS 1145 Introduction: Mobile Technology has evolved rapidly over the past few years. A standard mobile device has gone from mobile phone to a hand held gaming system, web browser and GPS navigation device. Not to mention the ever so popular tablet computers. Summary of key findings: Mobile Technology has led to anyone being reachable at anytime, day or night. It has literally shrunken the world to the palm of your hand. Although convenient I believe it has led to a people becoming Anti- social. Due to the lack of personality it has become common for people not to know how to react to real world problems. The environmental impacts of mobile technology are overwhelming. It is estimated that 61 percent of the world population owns some type of mobile device. It leaves us with 140 million phones being dumped in landfills. Not to mention the cardboard packaging and foam going to waste increasing the amount of trash. Keeping a mobile device on person makes it easier than ever to contact 911 in case of an emergency immediately. With no need to waste time trying to locate a phone to use. It is estimated that 70 percent of 911 calls are made from a mobile device. Even in non emergencies, for example a car emergency mobile devices make requesting help much easier. Conclusion: We are already seeing a slow down in the advancement of mobile technology. Not because a lack of technology, But a lack...
Words: 331 - Pages: 2
...Christopher Hernandez GS 1145 Introduction: Mobile Technology has evolved rapidly over the past few years. A standard mobile device has gone from mobile phone to a hand held gaming system, web browser and GPS navigation device. Not to mention the ever so popular tablet computers. Summary of key findings: Mobile Technology has led to anyone being reachable at anytime, day or night. It has literally shrunken the world to the palm of your hand. Although convenient I believe it has led to a people becoming Anti- social. Due to the lack of personality it has become common for people not to know how to react to real world problems. The environmental impacts of mobile technology are overwhelming. It is estimated that 61 percent of the world population owns some type of mobile device. It leaves us with 140 million phones being dumped in landfills. Not to mention the cardboard packaging and foam going to waste increasing the amount of trash. Keeping a mobile device on person makes it easier than ever to contact 911 in case of an emergency immediately. With no need to waste time trying to locate a phone to use. It is estimated that 70 percent of 911 calls are made from a mobile device. Even in non emergencies, for example a car emergency mobile devices make requesting help much easier. Conclusion: We are already seeing a slow down in the advancement of mobile technology. Not because a lack of technology, But a lack...
Words: 331 - Pages: 2
...Unit 2: Research Paper 1 GS1140 The speed limit is 65 mph and I’m at a stand-still! Why must this happen every morning and afternoon? Traffic will always be an ongoing problem. The more the population grows, the more congested our roads get with more vehicles. Besides leaving hours before traffic starts to avoid traffic jams there has to be another solution. Some solutions include: employee parking cash-out, tolls for single use carpool lanes, and tolls during high peak hours on freeways. An employee cash-out can reduce the amount of vehicles on the road by giving an incentive not to drive (Bullokk, 2011). Companies would give a certain amount each month to the employee who participates in the program. Through data mining, the decrease in the demand of parking can be obtained. The information needed to gather this would be: the number off employees in the program, the financial incentive amount, and the amount of time the incentives were given at separate but equal intervals (Bullock, 2011). A decrease in cars on the road would limit the amount of traffic on the road and also free up precious parking space. Tolls for single use carpool lanes will also benefit in decreasing traffic. The carpool lane is mostly always free of traffic during rush hours which is good for carpoolers, but also counter intuitive. The carpool lane turns into a wasted lane if people are not taking advantage of carpooling. Sensors can be placed in cars to automatically charge the fare for...
Words: 373 - Pages: 2
...PT2520 Database Concepts Unit 6 Research Assignment 1: Explore the latest ANSI and ISO Standard True/False 23-Jul-2016 Tim Church Daigre ANSI- The American National Standards Institute (ANSI) oversees the creation, promulgation and use of thousands of norms and guidelines that directly impact businesses in nearly every sector: from acoustical devices to construction equipment, from dairy and livestock production to energy distribution, and many more. ANSI is also actively engaged in accreditation - assessing the competence of organizations determining conformance to standards. To enhance both the global competitiveness of U.S. business and the U.S. quality of life by promoting and facilitating voluntary consensus standards and conformity assessment systems, and safeguarding their integrity. ISO- International Organization for Standardization (ISO) is an independent, non-governmental international organization with a membership of 163 national standards bodies. Through its members, it brings together experts to share knowledge and develop voluntary, consensus-based, market relevant International Standards that support innovation and provide solutions to global challenges. Part II- The latest SQL standard was adopted in July 2003 and is often called SQL:2003. One part of the SQL standard, Part 14, SQL/XML (ISO/IEC 9075-14) was revised in 2006 and is often referenced as "SQL/XML:2006". ANSI/ISO/IEC 9075:2003, "Database Language SQL", Parts 1 ("SQL/Framework"), 2 ("SQL/Foundation")...
Words: 278 - Pages: 2
...Unit 3 Research Assignment 1 Exploring Reverse Engineering Reverse engineering can be viewed as the process of analyzing a system to: 1. Identify the system's components and their interrelationships 2. Create representations of the system in another form or a higher level of abstraction 3. Create the physical representation of that system. Reverse engineering is very common in such diverse fields as software engineering, entertainment, automotive, consumer products, microchips, chemicals, electronics, and mechanical designs. For example, when a new machine comes to market, competing manufacturers may buy one machine and disassemble it to learn how it was built and how it works. A chemical company may use reverse engineering to defeat a patent on a competitor's manufacturing process. In civil engineering, bridge and building designs are copied from past successes so there will be less chance of catastrophic failure. In software engineering, good source code is often a variation of other good source code. Reverse engineering enables the duplication of an existing part by capturing the component's physical dimensions, features, and material properties. Before attempting reverse engineering, a well-planned life-cycle analysis and cost/benefit analysis should be conducted to justify the reverse engineering projects. Reverse engineering is typically cost effective only if the items to be reverse engineered reflect a high investment or will be reproduced in large quantities...
Words: 342 - Pages: 2
...Erick Pertell Unit 2 Research Paper 1: Experiment Problem Solving Theory My SOLUTIONS to STOP and PREVENT bullying 1.) STOP bullying... Parents should change the way they parent their children at home If you see someone that is being bullied, tell an authority figure Be confident Ignore the bully and walk away Do not engage in fights When in an uncomfortable situation, have friends to back you up. Your strength is in numbers. Find friends that share your interests or have also been bullied. A great way to make new friends is by sharing something in common with others. You can make new friends by getting involved in school and extracurricular activities. 2.)To PREVENT bullying from starting... Start a friendship club Compliment Week (Make people feel good about themselves) Have a "Sit with Someone you Don't Know Day" and meet new people and make new friends Take pledge to stop bullying Hold school assemblies informing students of what bullying is Counselors (Talk to counselors about what can be done to prevent people from bullying) Donate to Anti-Bullying Organizations --------------------------------------------------------------------------------------------------------------------------------- 3. What Schools Can Do To Stop Bullying: Hold assemblies showing students how to deal with bullying. Also show the consequences. Hire professional therapists to help students cope with bullying. Have a "bully hotline" where students can share their problems...
Words: 684 - Pages: 3
...Cindy Vargas GS 1140 Unit 2 Research Paper 1 The issue that I want to bring to the table is that our prisons in the United States are filling quickly with repeat offenders. If there was a way to rehabilitate the prisoners why not take it? It would appear from the research that I’ve done that our prison system is geared more towards punishment than rehabilitation. Throughout this paper I will discuss the program I think we need to help reduce the overcrowding of prisons and the return of previous criminals. The Department of Justice data shows that around 730 in every 100, 000 people are incarcerated in the U.S. We currently have 2.2 million people behind bars equal to the size of Houston, Tx. (Natasha Lennard, 2012). My proposition is to adopt the Israeli rehabilitation program into our justice system. Israel is a small country of a population at about 8 million people. This small country has 32 prisons and only estimated 18, 000 people incarcerated. Their recidivism of repeat offender rates are amongst the lowest in the word (Matt Lebovic, 2012). At Hermon prison in Galilee still has the same security measures that you expect from a prison. The way that they treat the inmates and the way the inmates interact with each other is what makes this program so special. The inmates aren’t called inmates they are called “residents”, they walk around the prison as if were a college campus. The unrestricted access to each other is what helps them integrate back into society. They...
Words: 750 - Pages: 3
...John Medina PT2520T Database Concepts Mr. Collier Unit 1 Research Assignment 1: Exploring Programming Languages History of the SQL – SQL was initially developed at IBM by Donald D. Chamberlain, Donald C. Messerly, and Raymond F. Boyce in the early 1970s. This version, initially called SEQUEL (Structured English Query Language) was designed to manipulate and retrieve data stored in IBM’s original quasi-relational database management system, System R, which a group at IBM San Jose Research Laboratory had developed during the 1970s. The acronym SEQUEL was later changed to SQL because “SEQUEL” was a trademark of the UK-based Hawker Siddely aircraft company. In the late 1970s, Relational Software Inc. (now Oracle Corporation) saw the potential of the concepts described by Codd, Chamberlain, and Boyce and developed their own SQL-based RDBMS with aspirations of selling it to the U.S. Navy, Central Intelligence Agency, and other U.S. government agencies. In June 1979, Relational Software Inc. introduced the first commercially available implementation of SQL, Oracle V2(Version 2) for VAX computers. After testing SQL at customer test sites to determine the usefulness and practicality of the system. IBM began developing commercial products based on their System R prototype including System/38, SQL/DS, and DB2, which were commercially available in 1979, 1981, and 1983 respectively. According to the paragraph above, there had to have been 4 revisions to the SQL. The most recent version...
Words: 565 - Pages: 3
