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 are the elements of a DBMS?
* The database schema * Schema objects * Indexes * Tables * Fields and columns * Records and rows * Keys * Relationships * Data types *
just follow this link
http://www.developer.com/db/article.php/719041
The accuracy of a computer's output depends on the accuracy of the input?
Quite true. This principle was immortalized by the phrase "garbage in, garbage out".
How important is database security?
List the importance of security
- To prevent unauthorized data observation.
- To prevent unauthorized data modification.
- To ensure the data confidential.
- To make sure the data integrity is preserved.
- To make sure only the authorized user have access to the data.
How many mega bytes are in 5 gigabytes?
There are 5120 MB in 5 GB. Refer to below : 1 bit = the value of 0 or 1 8 bits = 1 byte 1024 bytes = 1 kilobyte 1024 kilobytes = 1 megabyte 1024 megabytes = 1 gigabyte 1024 gigabytes = 1 terabyte 1024 terabytes = 1 petabyte So 1024 MB = 1 GB so i did 1024 * 5 and got 5150 MB in 5 GB.
How many applications come with a mac?
It varies on which one you buy but most come with iLife (iPhoto, iMovie, iDVD, iWeb and garageband) and lots of other basic software like DVD player, iTunes and Preview (image viewing program). See Apple's website for specific details.
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
