StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Database Systems and Open Sourcing - Research Paper Example

Cite this document
Summary
The tutorial videos mainly discusses on how to retrieve and manipulate date using ADO.NET, the use of sub-queries, creating and using stored procedures (sprocs), other T-SQL programming elements available for use in sproc, and Visual Basic and C# syntax required in employing sprocs in your applications…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER97.2% of users find it useful
Database Systems and Open Sourcing
Read Text Preview

Extract of sample "Database Systems and Open Sourcing"

The ial videos mainly discusses on how to retrieve and manipulate using ADO.NET, the use of sub-queries, creating and using stored procedures (sprocs), other T-SQL programming elements available for use in sproc, and Visual Basic and C# syntax required in employing sprocs in your applications. There are two basic methods of working with data from your applications: (1) using ADO.NET's objects in the retrieval, manipulation and navigation through tables' rows and columns, and (2) executing SQL statements from ADO.NET. SQL or Structured Query Language is a programming language designed for CRUD (Create, Read, Update, and Delete) operations on table data.

An Ad Hoc query enables interaction with a database without having to create an application. SQL Server Management Studio Express, a companion tool of the SQL Server 2005 Express Edition, should be installed for creating Ad Hoc queries. After installation, first step is to save all databases to be used in Microsoft SQL Server/MSSQL.1/MSSQL/Data in the Program Files. Then open the SQL Server Management Express and create or attach a database. In writing Ad Hoc queries, select "New Query" button and select which database you are querying from on the toolbar.

The SELECT statement is used to read/retrieve data from the database. Specific commands can be highlighted execute only certain commands. Also, results can be formatted to save into a CSV file or a Text file. To print a friendlier version of the results, column names can be given aliases. Number of results can be limited by including a WHERE clause. To aggregate values in specific columns, use SUM function, while the Count function calculates the number of records in a selected table. Mathematical and Conditional operations can also be executed via Ad Hoc query, as well as determining Minimum, Maximum and Average values.

Different Date functions are also available for use. To select a subset of entire field information, use Substring function with defined initial index and length. In selecting rightmost or leftmost characters, use Right and Left functions with defined lengths. Manipulate text using Upper (for uppercase), Lower (for lowercase) and Reverse (for reversing text) functions. To retrieve records that fit a particular pattern, use LIKE clause, while IN clause is used to return records that are in one of the specified lists.

Ordering records is done using Ascending or Descending functions. GROUP BY statements specify which group of fields to total, while JOIN statements retrieve fields from different tables and ORDER BY statements group results together in a given order. Sub-queries can be created by employing more than one SELECT statements in a query, where the results returned by one SELECT statement serves as an input to other SELECT statements. To insert values in a table, INSERT function is used and it should be noted to include all non-nullable fields.

UPDATE statements are the most potentially destructive among SQL commands, particularly when a WHERE clause is left off. Changes made by updating the data cannot be recovered; hence it will be helpful to secure a backup copy of your database before testing. Stored Procedures (sprocs) are reusable, named queries or T-SQL, analogous to VB or C# methods which are defined with a set of input/output data and return value parameters. They can include one or more statements combining SELECTs, INSERTs, DELETEs and UPDATEs, ultimately making your VB or C# code cleaner.

Sprocs can be created only once using the command CREATE, use ALTER for making changes. Sprocs enable variable declaration and assignment, looping and branching statements, code blocks and cursors. They can be used to manage access to your database and can be made as integration point for all applications that need access. Sprocs must only be used when it makes sense (i.e. multi-user client applications, high throughput applications, finer granularity of security requirements, etc.). Most parts of the videos are no longer forward.

I think they are more suitable to those with experience already. I find the different examples in using the SQL syntax very helpful in though. References: Microsoft. (2011). Manipulating Database Data 2006. Retrieved May 9, 2011, from http://www.asp.net/sql-server/videos/manipulating-database-data  Microsoft. (2011). More Structured Query Language. Retrieved May 9, 2011, from http://www.asp.net/sql-server/videos/more-structured-query-language  Microsoft. (2011). Creating and Using Stored Procedures 2006.

Retrieved May 9, 2011, from http://www.asp.net/sql-server/videos/creating-and-using-stored-procedures  Microsoft. (2011). Using SQL Server Management Studio 2006. Retrieved May 9, 2011, from http://www.asp.net/sql-server/videos/using-sql-server-management-studio

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Database Systems and Open Sourcing Research Paper - 1”, n.d.)
Retrieved from https://studentshare.org/other/1421125-database-systems-and-open-sourcing
(Database Systems and Open Sourcing Research Paper - 1)
https://studentshare.org/other/1421125-database-systems-and-open-sourcing.
“Database Systems and Open Sourcing Research Paper - 1”, n.d. https://studentshare.org/other/1421125-database-systems-and-open-sourcing.
  • Cited: 0 times

CHECK THESE SAMPLES OF Database Systems and Open Sourcing

Profile-Based Web-Searching

Personalized search is the fine-tuning of search results and advertising based on an individual's preferences, demographic information and other factors.... Presumably, the better a search engine understands a user's interests and preferences, the better able it is to target… [Johnson 2005] Background: Providing profile-based Web searching to users is an emerging concept and was first introduced by Eurekster in 2004....
12 Pages (3000 words) Essay

Case study - knowledge management strategy

Latest innovations in the knowledge management systems which uphold these values have been carefully selected.... The strategies proposed would help the company and its employees to have a participatory policy in ensuring the proper generation, processing mining, storage and… The strategy has been carefully formulated in proper alignment with the objectives and the vision of the company....
30 Pages (7500 words) Essay

Management of Information & Knowledge Strategically

It was found out that the airline has little knowledge management and hence it goes ahead to explore various options that can be adopted by Ryanair so as to… The options explored include use of simple social avenues such as Twitter, Facebook and YouTube through creation of Blog Spots and Further on, recommendations have been made such as having a knowledge management system that is comprehensive and accessed to everyone, including customers and one that has fully searchable and one that can be used to access a great deal of information by attaching multiple files....
14 Pages (3500 words) Essay

Web Based Library System Management with Business Intelligence

nbsp;The project is an open source system with two search engines for the books and journals.... Many open sources and Data Base Management Systems (DBMS) have already been designed and used to their effectiveness, still, their limitations are many.... The contemporary library systems are also using the facility to be available online and reach their target readers despite geographical distances.... For the performance of multiple tasks like maintaining the bibliographical database, catalogues and changes, a smart and intelligent system have become indispensable for academic libraries....
45 Pages (11250 words) Research Paper

Popular Forensic Tools

The introduction of open-source approach is to make processes and procedures of such system clearly defined and open for systematic analysis.... he following section compares to popular forensic tools- the commercially available FTK and its open-source counterpart, Autopsy.... For this reason such systems should be always available for systematic review and debate.... FTK analyzed all Microsoft Windows file systems including NTFS, NTFS compressed, and FAT 12/16/32....
10 Pages (2500 words) Essay

Eight Phases of Planning My Project

ystem design and analysisIn system design and analysis I had to do flow charts and look at varying designs and architecture of the similar systems from the more than twenty sources I collected and cited.... Since most databases on the internet are in MYSQL I read up on MY ODBC database drivers that allow JAVA code to interact with a MYSQL database and make downloaded the drivers ready to use for this part of coding when it came to coding....
9 Pages (2250 words) Assignment

Information Systems Theory - Foundations of Business Computing

Information technology, on the other hand, can be deemed to lie under information systems, since they focus on the technology involved in systems and example is an information system such as Facebook which consist of parts such as servers, written programs code together with client computers, each of this parts form information technologies it is basically the use of computers and software for information management.... Another important reason is gaining access to top-class capabilities due to the fact that out-sourcing institutions have staff more experienced and specializing in certain areas that would produce quality work as opposed to local staff that might have some general but limited knowledge in crucial areas....
6 Pages (1500 words) Assignment

Database Management Systems

The program enables multiple users to access several database systems.... This entails a multiuser, open-source, free, and multithread SQL database management systems used in various corporations.... It encompasses a subset of ANSI SQL 99, its extensions, stored procedures, cross-platform support, updatable view, cursors, and X/open XA distributed TPS and triggers.... … The paper “Database Management systems” is an excellent example of a case study on information technology....
12 Pages (3000 words) Case Study
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us