Sunday, July 6, 2008

int survey #4...

**IDENTIFY AT LEAST 10 DBMS SOFTWARES WITH THEIR CORRESPONDING DEVELOPER. THEN CHOOSE 1 AND BRIEFLY TELL HOW DOES DBMS HANDLE OR ACCOMMODATE DATA INPUT.


Oracle Database
Developed by Oracle Corporation

IBM DB2
Developed by IBM

FileMaker
Developed by FileMaker Inc. Latest release

Firebird (database server)
Developed by Firebird Project

Ingres
Developed by Ingres Corporation

Microsoft Access

Developed by Microsoft

Microsoft SQL Server

Developed by Microsoft

MySQL
Developed by Sun Microsystems

PostgreSQL
Developed by PostgreSQL Global Development Group

OpenEdge Advanced Business Language
Developed by Progress Software Corporation

__________________________________________________


Microsoft SQL Server


The data in the database are stored in primary data files with an extension .mdf. Secondary data files, identified with an .ndf extension, are used to store optional metadata. Log files are identified with the .ldf extension.

The main unit of data storage is a database, which is a collection of tables with typed columns. SQL Server supports different data types, including primary types such as Integer, Float, Decimal, Char (including character strings), Varchar (variable length character strings), binary (for unstructured blobs of data), Text (for textual data) among others.SQL Server also makes server statistics available as virtual tables and views (called Dynamic Management Views or DMVs). A database can also contain other objects including views, stored procedures, indexes and constraints, in addition to tables, along with a transaction log. An SQL Server database can contain a maximum of 231 objects, and can span multiple OS-level files with a maximum file size of 220 TB.

Storage space allocated to a database is divided into sequentially numbered pages, each 8 KB in size. Page type defines the data contained in the page - data stored in the database, index, allocation map which holds information about how pages are allocated to tables and indexes.

The main mode of retrieving data from an SQL Server database is querying for it. The query is expressed using a variant of SQL called T-SQL, a dialect Microsoft SQL Server shares with Sybase SQL Server due to its legacy. The query declaratively specifies what is to be retrieved. It is processed by the query processor, which figures out the sequence of steps that will be necessary to retrieve the requested data. The sequence of actions necessary to execute a query is called a query plan.

END

Sunday, June 29, 2008

int survey #3..

**INTERRELATE

sir, since i interrelated my answers in the 2nd survey, i need not interrelate it again?? hehehe.. plz answer. ;))


**QUESTION: for what??? ;))
**Answer:

The things that we input in the computer are data or what we call as unprocessed information. These data will undergo different processes. First, it will be stored in the storage devices of the computer. Then, it will be made as information. But why do we have to process these data? FOR WHAT??? It is processed so that it will be of better use. Everything needs improvement and so thus the data that we use. Another reason is because it becomes a source of the students, etc. And lastly, since change is constant, later on, these 'information' will be used as data again. It's a cycle.

**NEW ANSWER
We process data for it will then be our guide or basis for decision making. ;))

END

Sunday, June 22, 2008

int survey #2

**DISCUSS AND INTERRELATE THE FOLLOWING:

**DATA
-It is what the user inputs. It is the raw information that may consists of words, numbers, images and symbols.

**DATA TYPE
-A data type classifies the data into its kind. It may be integers, floating-point numbers, and alphanumeric strings.

**DATA STRUCTURE
-Data structure is a way of storing data in a computer. It organizes related pieces of information. Examples are, files, lists, arrays, records, trees, etc.

**DBMS
-A database management system (DBMS) is computer software designed for managing databases. It is also a collection of programs that enables you to store, modify, and extract information from a database.



______________________________________________________


A DATA TYPE tells the computer what kind of DATA is being "input" by the user. These DATA have a way of storage and that is called DATA STRUCTURE. A DBMS is categorized according to their DATA STRUCTURES.


______________________________________________________

Saturday, June 21, 2008

int survey #1


**QUESTION: What is the importance of an operating system?
**Answer: It manages all the functions of the softwares. Without it the computer will not work.

[new answer]

** 1. Operating system is just a designated word. Before, there was a system but it was being operated manually. Then, through the development of technology, computers has been miniaturized. Softwares also evolved and so, it need not be operated manually, thus, it is now called, operating system or OS. ;))

__________________________________________________



**QUESTION: Differentiate Operating system from an application software.
**Answer: Operating system manages all the functions done by all the software while an application software manages only one software.

[new answer]

** 1. Operating system is a software which basically operates the system. It is just a designated word. On the other hand, an application software, are those softwares which help the users. It works under the OS.
** 2. OS manages all the hardwares such that it could be able to provide services to application softwares. Ex.When a word processor (application software) wants to print something, the OS, "tells" the printer to print.

__________________________________________________


**QUESTION: What do you intend to do in life? Why did you enroll in this course?
**Amswer: Today, competition is very tight. I noticed that almost all the jobs requires computer literacy. I decided to be an information technology student because i know that if I will be an IT graduate, i will have an edge over other grads since I know how to operate computers. Therefore, my plans in life would be, to have my own business that deals with computers. ;))


__________________________________________________


**QUESTION: Describe yourself.
**Answer: Im a God-fearing person and I believe that everything happens upon His will. I temporarily reside at Orchids, Daro. I have a home of Amlan, Negros Oriental. I surf the net a lot and I'm also a text addict. I also love to write for I could express my feelings through it. I work for The NORSUnian, the official weekly publication of NORSU. Iam a business manager and at the same time a senior writer there. Lastly, I believe that "An intelligent man knows when to listen." By the way sir, I'm Maria Margarita Narvasa but you can call me marga, mary or bewii. ;))