0
Database Programming
Databases are collections of tables that maintain and display information, often collaboratively; this information can be used for interaction with an application or gaining general knowledge. Questions about database engines and modifying or using them belong in this category.
8,803 Questions
What is the difference between Management Information Systems and Information Systems Management?
The basic differenc between MIS and CIS is the source of the information. Management of Information Systemshandles information from all sources whether they are internal to an organization or external. Computer Information Systems is a bit more technical and strictly relate to computers and how the current organization uses the internal computer system.
What is master file table and what does contain?
The Master File Table contains a listing for each file on an NTFS file system volume. All information regarding the files is stored either in the master file table itself or in a space outside the table which is identified within the table.
Compare Database Systems and File Systems?
File system has data stored in flat files, which stores only processed data. Database system has data stored in table and they may or may not be related to each other. Database system is more efficient and also reduce redundant information which file system can not do.
What are some disadvantages of using Microsoft SQL Server 2000?
Some disadvantages of using Microsoft SQL Server 2000 include its blocking issues as well as its ability overall to perform as it should. Its ability to be integrated into other systems can be difficult as well.
What are the characteristics of relational database management system?
characteristic of relational data base system
There are a number of characteristics that distinguish the database approach with the file-based approach. In this section, we describe in detail some of those important characteristics.
Self-Describing Nature of a Database System : Database System contains not only the database itself but also the descriptions of data structure and constraints (meta-data). These information is used by the DBMS software or database users if needed. This separation makes database system totally different from traditional file-based sytem in which data definition is a part of application programs
Insulation between Program and Data : In the filed base sytem, the structure of the data files is defined in the application programs so if user want to change the structure of a file, all the programs access to that files might need to be changed. On the other hand, in database approach, data structure is stored in the system catalog not in the programs so such changes might not occurs.
Support multiple views of data: A view is a subset of the database which is defined and dedicated for particular users of the system. Multiple users in the system might have different views of the system. Each view might contains only the interested data of an user or a group of user.
Sharing of data and Multiuser system: A multiuser database system must allow multiple users access the database at the same time. As the result, the multiuser DBMS must have concurrency control strategies to ensure that several user try to access the same data item at a time do so in the manner so that the data always be correct.
List Five storage management responsibilities of a typical OS?
Storage management responsibility of a typical OS
Ø Process isolation
This is the prevention of data and instruction from interfering with each other process isolation helps this happen.
Ø Automatic allocation and management
This is the process whereby allocation should be transported to the programmer.
Ø Support of modular programming
Supports the program to be able to define programs modules and to create, destroy and alter the size of modules dynamically
.
Ø Protection and access control
This is the process of sharing memory this is desirable when sharing is needed by a particular application it also threatens the integrity of programs.
Ø Long term storage
Is a process whereby memory is stored for a long period of time even when the computer is switch off it is stored in the RAM.
You may be unable to link to the site.
It depends on the web site. If it's well equipped to handle a large number of visitors, then the load will be distributed evenly among all of the servers and there won't be a problem.
However, if the amount of traffic is too far above the website's server capacity, the effect is like too many people trying to go through the same revolving door. Due to bandwidth, CPU, or RAM limitations the servers won't be able to handle all of the connections, and those visitors might experience very long page load times, or a complete inability to access the site.
What are the characteristics of file based systems?
The characteristics of file-base system are as follows:
- Storage
- Organization
- Collections of data
- Readable
- Manipulating options
- Coding
It is a data structure composed of rows and fields/columns. Each row is one entry of data and the fields define what the data is. For example, in a table named People, there could be fields for FirstName, LastName, ID, PhoneNumber. Each row on that table would have information for one person.
1. To manage record of information in a desired manner.
2. Provide easy access to user.
3. minimum redundancy.
4. provide easy way to upgrade data.
Difference between a super key and a candidate key?
Different set of attributes which are able to identify any row in the database is known as super key. And minimal super key is termed as candidate key i.e. among set of super keys one with minimum number of attributes. Primary key could be any key which is able to identify a specific row in database in a unique manner.
Role of Database Technologies?
The main goal is to discuss the role of database technology and research in the new area of workflow management systems. There are several hundred workflow products in the market and the database community has so far had very little impact in this area. Yet, the problems faced by workflow systems have a lot in common with problems which have already been solved for databases. The paper aims to identify which database technology is relevant in the workflow area and research directions that are most likely to have a significant impact on the evolution of workflow systems. As the basis for discussion, this proposal outlines the current state of the art and points out possible areas in which database technology could be applied in workflow contexts. Thanks & Regards, Hajee nizam mohamed
What is the advantage of teleworking?
The advantages of teleworking are that it allows the individual to be at home tending to family, and saves on transportation costs. The disadvantage is that the individual might be cut off from employee contact.
What are the MSAccess database objects?
MS Access Database objects are: Tables, Queries, Forms, Reports, Modules, Macros etc..
What is a row in a database called?
A database is said to be a collection of records and the data is stored in the table. A table consist of number of rows and columns. Row in the database table is known as a record .
What is the meaning of g in oracle 10g?
G signifies "Grid Computing"... With the release of Oracle 10g in 2003, Oracle changed the suffix in their previous release version; from 9i to 10g... 'I' stands for Internet...this was done as a marketing effort in order to show Oracle's move towards Grid Computing... Purely a marketing strategy...
What is the difference between file processing system compare to database system?
2. Saves in temporary locations where as DBMS in well arranged and permanent data base locations
3. In File Sys., transactions are not possible where as various transactions like insert,delete,view,updating etc r possible in DBMS
4. Data will be accessed through single or various files where as in DBMS, tables (schema)
is used to access data
5. A "File manager" is used to store all relationships in directories in File Systems where as a data base manager (administrator) stores the relationship in form of structural tables
6. Last.... but not the least.... Data in data bases are more secure compared to data in files!!
Hope this thing is use ful to one and all!! :) :) ;)
file system is the method for storing and organizing computer files and the data they contain to make it easy to find and access them whereas data base system is a computer software that manages databases.
source: wikipedia
i also want to know about filebased management system and databasemanagement system pls tell me pls
A computerized database is stored in a computer and is very fast at organizing information, and grouping related data.
A manual database is like a filing cabinet, slow and clumsy, and you can lose records down the back.
Data can only be found quickly on one bit of data, for example 'Name' as that will be the only bit visible in the filing cabinet - to find anything else you need to manual go through each and every file in the cabinet.
File system is a system , that collecting a data or files and stored in physical location like hard disk or cd-rom.
And datadase system is an integrated logically-realted-data or records in a common pool from where , multiple users could fetch the data.
File systems are containers of collections. Collections are commonly called directories, and they contains a set of data units commonly called files.
All database architectures provide structures and methods to organise data (called rows) into collections (called Tables) that can be updated. Databases have the ability to commit a set of data changes as one logical unit, and have many users doing this concurrently.
The main difference is that filesystems are the layer underneath a database. The database system is an application and a set of database files. The database files are part of the file system container.
"http://wiki.answers.com/Q/What_is_the_difference_between_a_file_manager_and_a_database-management_system"
1, A database is an integrated collection of logically related records or files consolidated into a common pool that provides data for one or multiple uses.
A file is a package of information with a name attached to it.
2, Databases are basically meant to fragment data into relations store then so that conditioned retrieval is fast and easy.
A file is just for mas storage for future use. Here the conditioned retrieval is not a significant factor.
3, To handle small data sets, file is more efficient than database; that is, consider the stats below,
Test done in a machine (single PC)
Test without condition! Test with condition where names start with 'A'!
File operation was faster Database operation was faster
(I am not including the actual time measured )
For simple operations, read, wright, file operations are faster and simple. But the area where database is of real use is when there is a conditional retrieval of data.
4, Database is real gift in area's where we need to have bulk data (including multimedia) and which includes conditional retrieval. For file operations there are very very tedious operations which involves large processing time.
What is meant by aggregation according to dbms?
Aggregation is an important concept in database design where composite objects can be modelled during the design of database applications. Therefore, preserving the aggregation concept in database implementation is essential. In this paper, we propose models for implementation of aggregation in an Object-Relational Database Management System (ORDBMS) through the use of index clusters and nested tables. ORDBMS is a commercial Relational Database Management Systems (RDBMS), like Oracle, which support some object-oriented concepts. We will also show how queries can be performed on index clusters and nested tables.
- speed
- client server architecture support
- easy maintenance
and Database Management System DBMS is used to store information in the form of tables columns and rows, interconnected by keys and accessible throughout an interface.
Examples: SQL, MYSQL, ORACLE, etc ...
Read more: What_is_need_of_dbms
What is an example of a database system?
There are many of them. Here are just 10:
Microsoft Access
Oracle
MySQL
Dbase
Progress
Base (Open Office)
Ingres
Filemaker
Informix
Lotus Approach
Which are the four major data processing functions of a computer?
The four major ways of data processing is 1.accepting inputs 2.processing which involve the sorting and manipulation of data. 3.storage,data is been stored into the hard disk or any memory available and 4.output.data is been sent out as INFORMATION in a format that is readable and useable.
In Access, you use data type. In Word and Excel, you use data validation.
How many bytes does oracle 9i use to store number datatype?
from <http://docs.oracle.com/cd/B19306_01/server.102/b14220/datatype.htm#i1847>
Overview of DATE Datatype
The DATE datatype stores point-in-time values (dates and times) in a table. The DATE datatype stores the year (including the century), the month, the day, the hours, the minutes, and the seconds (after midnight).
Oracle can store dates in the Julian era, ranging from January 1, 4712 BCE through December 31, 4712 CE (Common Era, or 'AD'). Unless BCE ('BC' in the format mask) is specifically used, CE date entries are the default.
Oracle uses its own internal format to store dates. Date data is stored in fixed-length fields of seven bytes each, corresponding to century, year, month, day, hour, minute, and second.
The correct answer is 7 bytes for a date column.
What are the disadvantages of cce?
The most basic point is that CCE can prove to be dangerous because students will take studies casually. If there won't be any competition all students won't study sincerely. Our education system needed improvement but such a random change would never help instead it will do the opposite. If the same system would have been introduced gradually it would have been better. But now most of the students have come to think that acting smartly in front of the teacher is the key to success. Studies are taken as secondary. As a result scores are dropping in all schools. Also teachers are getting more powers which they can always use unfairly and to some extent "partially".
