Exploring Programing Language

In: Computers and Technology

Submitted By thinkerwell9
Words 480
Pages 2
1. Look up the history of SQL. How many revisions of the standard have there been? What was added in the most recent one? The language structure English Query (SEQUEL) was developed by IBM corporation, Inc. In 1979 Relational Software, Inc. introduced the first commercially available implementation of SQL. Today SQL is accepted as the standard RBDMS language. The latest SQL standard was adopted in July 1999 and is often called SQL:99 The formal names of this standards are: * ANSI X3.135-1999, “Database Language SQL”, Parts 1 (“Framework”), 2(“Foundation”), and 5(“Bindings”) * ISO/IEC9075:1999, “Database Language SQL”, Parts 1 (“Framework”), 2(“Foundation”), and 5(“Bindings”) 2. A recent trend for major commercial database developers is to offer free “Express” versions of their databases. Microsoft has SQL Express; Oracle has Oracle Express, and DB2 Express. Go to the company websites, and look up these Express editions. What features does each one have? What limits do they have? How do they compare to each other?
New in SQL Server Express 2012: SQL Server Express LocalDB
SQL Server Express LocalDB
LocalDB is a new lightweight deployment option for SQL Server Express Edition with fewer prerequisites that installs very quickly. This makes it ideal for developers who need an embedded SQL Server database for desktop applications or tools. LocalDB has all of the same programmability features as SQL Server Express, but runs in-process with applications and not as a service.
Integrated LocalDB is designed to be bundled with and function as an integrated part of tools or desktop applications that need a lightweight local database runtime. This includes tools like SQL Server Data Tools, or custom developed desktop applications, or tools that need a lightweight single-user database runtime that supports full Transact-SQL functionality. Simple Apps that use…...

Similar Documents

Exploring Programming Languages

...Exploring Programming Languages 1970s * Pascal * Developed 1970 * originally developed by Niklaus Wirth, a member of the International Federation of Information Processing (IFIP) * principle objectives, allow for the development of well structured and well organized programs, and to serve as a vehicle for the teaching of the important concepts of computer programming * named after the mathematician Blaise Pascal * C * Developed 1972 * C was created by Dennis Ritchie at Bell Labs initially as a systems programming language for implementing UNIX * C++ was created by Bjarne Stroustrup at Bell Labs in the 1980s adding object orientation to C * Influenced ANSI C, Java * C/C++ has become the world’s most widely used systems programming language * ML * Developed1973 * Created by Robin Milner at University of Edinburgh * Initial focus: meta-language for program verification * One of the most widely used functional programming languages * Influenced Standard ML, Miranda, Haskell * SQL * Completed 1978 * First defined in 1970 by Dr. E.F. Codd, researcher for IBM, in a his Paper titled “A Relational Model of Data for Large Shared Data Banks “ * SQL would allow computer users to retrieve data from a variety of sources * Smalltalk * Released 1972 * first commercially-successful object-oriented language * Written and......

Words: 790 - Pages: 4

Pt2520-Unit 1 Research-Exploring Programming Language

...Unit 1 Research Assignment 1: Exploring Programming Language Structured Query Language (SQL) is a specialized language for updating, deleting, and requesting information from databases. SQL is an ANSI and ISO standard, and is the de facto database query language. A variety of established database products support SQL, including products from Oracle and Microsoft SQL Server. It is widely used in both industry and academia, often for enormous, complex datbases. (Base, 2013). SQL was developed in the 1970’s by IBM to initially manipulate and retrieve data in IBM system R. The SQL language was standardized in 1986 by the American National Standards Institute (ANSI); however, later releases were released as International Organization Standardization (ISO) standards. (Inc., 2013) Although IBM authored SQL, the first SQL implementation was provided by Oracle Corporation (then called Relational Software Inc.). Early commercial implementations were concentrated on midsized UNIX-based DBMSs, such as Oracle, Ingres, and Informix. IBM followed in 1981 with SQL/DS, the forerunner to DB2, which debuted in 1983. (Unknown, 2010) ANSI published the first SQL standard (SQL-86) in 1986. An international version of the standard issued by ISO appeared in 1987. A significant update to SQL-86 was released in 1989 (SQL-89). Virtually, all relational DBMSs that you encounter today support most of the 1986 standard. (Unknown, 2010) In 1992, the standard was revised again (SQL-92), adding more...

Words: 802 - Pages: 4

Exploring Programming Languages

...Exploring Programming Languages 1970’s Pascal was created by Niklaus With. It was named after a mathematician, physicist and philosopher Blaise Pascal. It was designed as a small and efficient language intended to encourage good programming practices using structured programming and data structuring. 1980’s C++ was developed by Bjarne Stroustrup. C++ is one of the most popular programming languages and is implemented on a wide variety of hardware and operating system platforms. As an efficient compiler to native code, its application domains include systems software, application software, device drivers, embedded software, high-performance server and client applications, and entertainment software such as video games. It was also used for hardware design. The idea of creating a new language originated from Stroustrup's experience in programming for his Ph.D. thesis. Stroustrup found that Simula had features that were very helpful for large software development, but the language was too slow for practical use, while BCPL was fast but too low-level to be suitable for large software development. 1990’s Java was created by James Gosling at Sun Microsystems. Java was originally designed for interactive television, but it was too advanced for the digital cable television industry at the time. James Gosling aimed to implement a virtual machine and a language that had a familiar C/C++ style of notation. JavaScript is not related to Java. It was originally developed......

Words: 455 - Pages: 2

Language Acquisition Through Multimedia Programing

...Language Education Through Multimedia Programming Learning a new language is not an overnight process; it requires time and effort on both the learner’s end as well as the educator’s end. Language acquisition is far more common than the typical American might believe. There are estimations stating as high as sixty percent of the world’s population is multilingual, meaning language education is far from a new topic (Richards 3). Although the multilingualism rates are not as high in the United States, globally multilingualism is the norm rather than the exception, both historically and presently. There are four different modes in which language is learned: listening, reading, writing, and speaking; all of which have been used since language education came to be in the early twentieth century (Richards 10). As language education has evolved alongside technology, the two have combined and resulted in a recent teaching method using multimedia programming. Many studies have been performed examining the effectiveness of language education through multimedia programs, looking specifically at the methods used amongst the variety of multimedia programs available. The ultimate goal of language education is oral proficiency, followed by reading and writing proficiency. Research on language acquisition has revealed this can most successfully be accomplished by associating unknown words with actual objects or imagery techniques; resulting in the creation of multimedia language......

Words: 1702 - Pages: 7

Pt1420T Unit 1: Exploring Programming Languages

...1970 by Niklaus Wirth as a small and efficient language intended to encourage good programming practices using structured programming and data structuring. C- Created between 1969-1973 by Dennis Ritchie, Its design provides constructs that map efficiently to typical machine instructions, and therefore it has found lasting use in applications that had formerly been coded in assembly language, most notably system software like the UNIX computer operating system. COMAL- 1973 by Benedict Lofstedt and Borge R. Christensen, The "COMAL 80 PROGRAMMING LANGUAGE REPORT" contains the formal definition of the language. POP-2- 1970 by Robin Popplestone and Rod Burstall. It used an incrementak compiler, which gave it some of the flexibility of an interpreted language, including allowing new function definitions at run time and modification of function definitions while a program was running without the overhead of an interpreted language. INTERCAL- 1972 by Don Woods and James M. Lyon. It satirizes aspects of the various programming languages at the time, as well as the proliferation of proposed language constructs and notations in the 1960s. 1980s ADA 80- Created by Jean Ichbiah from 1977-1983. It is a structured, statically typed, imperative, wide-spectrum, and object-oriented, high-level computer programming language, extended from Pascal and other languages. C++- A programming language that is general purpose, statically typed,......

Words: 827 - Pages: 4

Exploring Programming Languages

...Kemeny and Thomas Kurtz on May 1, 1964. Basic stands for Beginners All-purpose Symbolic Instruction Code . The aims of the BASIC system were: to develop a system and language that was friendly, easy to learn and use, to introduce computing as an adjunct to other courses, to operate an open access policy (i-programmer.info, 2010). Pascal- was created by Niklaus Wirth in 1972. He wanted a language suitable for teaching but for teaching computer science. It is best described as a simplified version of Algol. It was simplified both to make it easier to learn and to make it easier to compile (i-programmer.info, 2010). C- Was created by Ken Thompson iin the form of B and tweaked by Dennis Ritchie and renamed C in the 1970’s. It was the original code Unix was written in. Its function was for ease of use (i-programmer.info, 2010). Forth- was created by Charles H Moore in the 1970’s. The motivation behind this language was for both interactive execution of commands and the ability to compile sequences of commands for later execution (i-programmer.info, 2010). PLEX (Programming Language for EXchanges)- was created by Goran Hemdahl at Ericsson in the 1970’s. It is a special-purpose, pseudo-parallel and event-driven real-time programming language dedicated for AXE telephone exchanges, It is a propriatary language (i-programmer.info, 2010). 1980’s Atari ST BASIC – Atari commissioned MetaComCo to write a version of BASIC that would take advantage of the GEM......

Words: 1789 - Pages: 8

Pt2520 Unit 1 Exploring Programming Languages

...Exploring Programming Languages “SQL is a tool for organizing, managing, and retrieving data stored by a computer database.”¹ This tool has been around for many decades and has evolved over time much like any of today’s technology has. Below is a chart found in Chapter 3 of SQL: The Complete Reference, Third Edition showing the milestones in the development of SQL: Milestones in SQL Development | Year | Event | 1970 | Codd defines relational database model | 1974 | IBM begins System/R project | 1974 | First article describing the SEQUEL language is published | 1978 | System/R customer tests are conducted | 1979 | Oracle introduces first commercial RDBMS | 1981 | Relational Technology introduces Ingres | 1981 | IBM announces SQL/DS | 1982 | ANSI forms SQL standards committee | 1983 | IBM announces DB2 | 1986 | ANSI SQL1 standard is ratified | 1986 | Sybase introduces RDBMS for transaction processing | 1987 | ISO SQL1 standard is ratified | 1988 | Ashton-Tate and Microsoft announce SQL Server for OS/2 | 1989 | First TPC benchmark (TPC-A) is published | 1990 | TPC-B benchmark is published | 1991 | SQL Access Group database access specification is published | 1992 | Microsoft publishes ODBC specification | 1992 | ANSI SQL2 standard (SQL-92) is ratified | 1992 | TPC-C (OLTP) benchmark is published | 1993 | Specialized SQL data warehousing systems are shipped for the first time | 1993 | ODBC products are shipped for the first time | ......

Words: 1281 - Pages: 6

Unit 1 Research Assignment 1: Exploring Programming Languages

...Unit 1 Research Assignment 1: Exploring Programming Languages NT1420 In the late 1960’s Simula was invented by Nygaard and Dahl as a superset of Algol 60, this was the first language designed to support object-oriented programming. Then between 1969 and 1973 C was developed by Dennis Ritchie and Ken Thompson at Bell Labs. Smalltalk was created in the mid 1970’s that provided a complete ground-up design of an object-oriented language, and about the same time Prolog was designed in 1972 by Colmerauer, Roussel, and Kowalski, this was the first logic programming language. In 1973 Robin Milner built two polymorphic type systems (ML and Lisp) which were used in pioneering statically typed functional programming languages. Now going to the 80’s, Ada was created in 1983 by a team ran by Jean Ichbiah which was designed for built-in language support for explicit concurrency, offering tasks, synchronous message passing, protected objects, and non-determinism. Erlang was developed by Joe Armstrong in 1986 that supports hot swapping, so that code can be changed without stopping a system. In 1985 Eiffel was created as an ISO-standardized, object-oriented programming language designed by Bertrand Meyer. The program emphasizes declarative statements over procedural code and attempts to eliminate the need for bookkeeping instructions. TCL is a scripting language created by John Ousterhout in 1988 which is used for rapid prototyping, scripted applications, GUIs and testing. Perl was......

Words: 583 - Pages: 3

Exploring Programing Languages

...Exploring Programing Languages 1970's BASIC - designed by John Kemeny and Thomas Kurtz at Dartmouth College. At first BASIC was modeled on the batch languages of the time in that all of the data that the program would process had to be included in a DATA statement before the program could be run. Pascal - after BASIC was developed, Niklaus Wirth produced a language suitable for teaching computer science C - Dennis Ritchie reworked some of Thompson's ideas to produce the language C in the early seventies at Bell Labs. FORTRAN - added structured statements borrowed from Algol to produce Fortran 77. COBOL- more static and only submitted to slight revision in 74. 1980's C++ - a general purpose programming language. It has imperative, object-oriented and generic programming features, while also providing the facilities for low level memory manipulation. Perl - a family of high-level, general-purpose, interpreted, dynamic programming languages. The languages in this family include Perl 5 and Perl 6. Ada - originally designed by a team led by Jean Ichbiah of CII Honeywell Bull under contract to the United States Department of Defense (DoD) from 1977 to 1983 to supersede the hundreds of programming languages then used by the DoD. Objective-C - a general-purpose, object-oriented programming language originally developed in the early 1980s. It is the main programming language used by Apple. Caml ( Categorical Abstract Machine Language) is a dialect of the ML programming...

Words: 561 - Pages: 3

U1Ra1 - Exploring Programming Languages

...2014 PT1420 Unit 1, Research Assignment 1: Exploring Programming Languages 1970’s: 1. C- created by Dennis Ritchie in 1972. It was designed to be compiled using a relatively straightforward compiler, to provide low-level access to memory, to provide language constructs that map efficiently to machine instructions, and to require minimal run-time support 2. SQL- Designed by Donald D. Chamberlin and Raymond F. Boyce in 1974. It 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. 3. Scheme- Developed by Guy L. Steele and Gerald Jay Sussman in 1975. Scheme started as an attempt to understand Carl Hewitt's Actor model, for which purpose Steele and Sussman wrote a "tiny Lisp interpreter" using Maclisp and then "added mechanisms for creating actors and sending messages. 4. Smalltalk- Designed by Alan Kay, Dan Ingalls, and Adelle Goldberg in 1972. The first version, known as Smalltalk-71, was created by Ingalls in a few mornings on a bet that a programming language based on the idea of message passing inspired by Simula could be implemented in "a page of code." 5. Prolog- Designed by Alain Colmerauer in 1972. Its intended field of use was natural language processing. 1980’s: 1. C++- Designed by Bjarne Stroustrup in 1983. The motivation for creating a new language originated from Stroustrup's experience......

Words: 747 - Pages: 3

Exploring Programming Languages

...popular programing languages: • 1970: o 1970 - Pascal o 1972 - C o 1972 - Smalltalk o 1972 - Prolog o 1973 - ML • 1980: o 1983 - Ada o 1983 - C++ o 1985 - Eiffel o 1987 - Perl o 1989 - FL (Backus) • 1990: o 1990 - Haskell o 1990 - Python o 1991 - Java o 1993 - Ruby o 1994 - PHP o • 2000: o ATS o Boo o C Sharp o Clojure o Cobra Who created this language? • 1970: o Niklaus Wirth o Dennis Ritchie o Alan Kay, Dan Ingalls, Adele Goldberg o Alain Colmerauer o Robin Milner • 1980: o Jean Ichbiah o Bjarne Stroustrup o Bertrand Meyer o Larry Wall o John Backus, John Williams, Edward Wimmers • 1990: o Simon Peyton Jones, Lennart Augustsson, Dave Barton, Brian Boutel, Warren Burton, Joseph Fasel, Kevin Hammond, Ralf Hinze, Paul Hudak, John Hughes, Thomas Johnsson, Mark Jones, John Launchbury, Erik Meijer, John Peterson, Alastair Reid, Colin Runciman, Philip Wadler o Guido van Rossum o James Gosling and Sun Microsystems o Yukihiro Matsumoto o Rasmus Lerdorf • 2000: o Hongwei Xi o Rodrigo B. De Oliveira o Microsoft o Rich Hickey o Charles Esterbrook When was each of these languages created? Was there a specific motivation behind the creation of these languages? If so, what was it? • 1970: o 1970 – Yes, intended to teach students structured programming o 1972 – Yes, designed to be compiled using a relatively straightforward compiler, to provide low-level access to memory, to provide language......

Words: 423 - Pages: 2

Exploring Programming Languages

...Unit 1 Research Assignment 1 Exploring Programming Languages Chris Wade Introduction to Programming Dr. Bass Programming Languages have become very much improved in the last few decades. When computers were first created, languages were very focused on getting the most effective response from the computers while being limited by the hardware designs. As hardware has gotten better and faster, programming languages have developed right alongside of them. In 1972 a programming language called C was developed by Dennis Ritchie of Bell Labs. The reason for developing this was to improve upon other languages such as B and Pascal. C uses a lot of the same forms and functions as Pascal and was developed to be faster and more powerful. The only issue was that it was hard to read. C was also developed to work well with Unix. (Ferguson, 2000). In 1983 Bjarne Stroustroup developed C++ which was also known as “C with classes”. This improved C and moved toward object oriented programming. C++ has been considered the most popular programming language ever and is currently used in programs such as Adobe PDF Reader, Mozilla Firefox (web browser), and MS Office. (Anthony, 2001). The 1990’s saw the development of several languages such as Python, PHP, and Java. Developer Guido Van Rossum developed Python (named for Monty Python) to fix problems in the ABC language and it is used by YouTube, Google Search, and NASA (Anthony, 2001). PHP (which stands for Personal Home Page)......

Words: 473 - Pages: 2

Pt1420 Exploring Computer Languages.

...Exploring programming languages. 1970 Forth: Forth was created by Charles H Moores. This was created around 1973 when the company known as fourth came into play. This was made because do to the job Charles have, he couldn’t help but wonder if he could take his work wherever he goes. This also lead to the popularity of the microchips as the time. C: C was created by Dennis Ritchie. Created at around 1972, this program was originaly gonna be called B. But do to it taken avantage of the PDP, it became C. Prolong: Created by Alian Colmerauer, Prolong was made within 1972 and became the most popular during that time. It is well known for expression terms of relationships within the coding of the language. ML: ML was design and created by Robin Miler and other people he work closely within the university of Edinburgh. Around 1973, this was created to help analyze but mostly applied in language design and manipulation (compilers, analyzers, theorem provers), but it is a general-purpose language also used in bioinformatics, financial systems, and applications including a genealogical database SQL: Created by Donald D. Chamberlim and Rayman F. Boyce around 1974, this was Originally based upon relational algebra and tuple relational calculus, SQL consists of a data definition language and a data manipulation language. The two saw the potential of the concepts described by Codd, Chamberlin, and Boyce, and developed their own SQL-based RDBMS with aspirations of......

Words: 1226 - Pages: 5

Unit 1 Research Paper: Exploring Programming Languages

...Exploring Programming Languages Popular programming languages of the 1970’s: * B – Was a forerunner to “C” * Created by Dennis Ritchie and Ken Thompson at Bell Labs in 1969. * Designed for recursive, non-numeric, machine independent applications, such as system and language software. * C – A general purpose, imperative computer programming language, supporting structured programming. * Was designed by Dennis Ritchie at Bell Labs in 1972. * Used to re-implement the Unix operating system. * Smalltalk – An object oriented, dynamic typed, reflective programming language. * Designed and created in 1972 at the Learning Research Group by Alan Kay, Dan Ingalls, and Adelle Goldberg. * Created as the language to underpin the “new world” of computing exemplified by “human-computer symbiosis.” * Prolog – The first logic programming language. * Designed in 1972 by a group around Alan Colmerauer. * Intended use was for natural language processing. * ML – A statically typed functional programming language. * Designed by Robin Milner in 1973. * Purpose was to develop proof tactics in the LCF theorem prover. Popular programming languages of the 1980’s: * C++ - General-purpose programming language. Imperative, object-oriented and generic programming features. * Designed by Bjarne Stroustrup at Ben Labs in 1980. * Designed with a bias toward system programming and...

Words: 902 - Pages: 4

Organization of Programing Languages

...or CMP 401 ASSIGNMENT | ORGANIZATION OF PROGRAMMING LANGUAGES | | ANZOTSA JOHN ALAKU | BHU/12/04/05/0042 COMPUTER SCIENCE 400 LEVEL | | | ABRSTRACT My objective for these research was to find out about different programming languages and paradigm in which they belong, the most important use in this research are text and journal by other researchers. After all studies where carried out, I came to a conclusion that one programing language can belong to more than one paradigm C++ C++ is a statically typed, free-form, multi-paradigm, compiled, general-purpose programming language. Some people say that C++ is a middle language because it has the features of high level and low-level language. As one of the most popular programming languages in the world, C++ is widely used in the software industry. C++ is also used for hardware design to analyze structure. Some of its application domains include systems software, application software, device drivers, embedded software, high-performance server and client applications, and entertainment software such as video games. AspectJ AspectJ is a general-purpose Aspect-Oriented extension to java programming language. It was created at Palo Alto Research Center Incorporated (PARC), now it is an open source project and part of the Eclipse Foundation. AspectJ has everything that Java has and more......

Words: 3773 - Pages: 16

Dietland | Xiaolin Showdown | neokiller