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 sybase and rdbms?
Sybase is a specific product and company that provides relational database management systems (RDBMS). RDBMS is a general term for a type of database management system that stores data in a structured format using tables. Sybase is one of the many vendors that offer RDBMS solutions.
Disadvantages of information systems?
The primary disadvantage is the vulnerability of data in today's world. It is very easy for a business to be a victim of espionage or robbery if they keep their data online, which most businesses do now a days.
What is the difference between sql and an sql server?
SQL is an abbreviation for Structured Query Language. SQL is a means to request data from a database. SQL is a standards based langage that has many versions approved by the American National Standards Institute (ANSI). There are many versions of ANSI-SQL and most databases support specific versions of ANSI-SQL. SQL Server is a database management system that was originally created by Sybase. Microsoft bought the rights from Sybase to market their own version of SQL Server on the Microsoft Windows operating system. Sybase still has versions of SQL Server on other operating systems. When people refer to SQL Server, they typically mean "Microsoft SQL Server." Microsoft SQL Server is a database management system (DBMS) that utilizes SQL (or more specifically Transact-SQL, or T-SQL) as a means to extract data from it's database tables.
What is the difference between XML and SQL data storage?
In XML data storage, the data is stored in a file which represents an XML Schema of the data. To read the data, you have to pull and open the entire file in memory and use technics like xpath to get the data element you want. In SQL data storage, the data is stored in a database ( usually relational database). To read the data, you simple sent an SQL query to the database. The database management engine analysis the query and get the required data elements you ask for in your query which is finally sent to you as a reply.
What is the difference between information technology and electronic data processing?
Information technology (IT) refers to the broader field that encompasses the use of computers and software to manage and process information. Electronic data processing (EDP) specifically focuses on the automated processing of data using computers. Essentially, EDP is a subset of IT that deals specifically with the processing of electronic data.
What is an organically based communication disorder?
An organically based communication disorder is a disorder that is caused by physical or neurological factors, rather than psychological or emotional ones. This means that the communication difficulties arise from problems in the structure or functioning of the brain or other organs involved in communication, such as the vocal cords or hearing organs.
When inserting character values into a table is case sensitivity important?
It depends on the database's collation settings. For case-insensitive databases, the case of the inserted values may not matter. In case-sensitive databases, the values are considered distinct based on their case, so 'John' and 'john' would be treated as different entries. It's best to know the collation settings of your database to handle character casing appropriately.
Values information refers to data or knowledge about the principles and beliefs that guide an individual's or organization's behavior and decision-making process. This information helps understand what is important to someone or an organization and can be used to assess alignment with goals and priorities.
Is there a way of having online survey results automatically fed into a database on submission?
== == It is called "real time results" - When you click on "see results" and call up a chart, the application displays the results based on the last respondent. This could have been seconds ago.
What are the differences between a data administrator and a database administrator?
Depending on the company, they could be the same. But, if they are different, here is the difference:
A data administrator is one who oversees the data integrity of the database. They do not create objects and they may not have privileges to do anything other than "view" the data and report any data discrepencies to the database administrator(one who administers the entire database). The data administrator can check data in the tables to make sure there are no errors, can check to see if tables that need an index have one, are all programs valid--stuff like that. The database administrator is usually busy with fixing problems, creating tablespaces, tables, looking at error messages.
What are the differences between centralized and distributed DBMS?
Sudipto Chattopadhyay
Discuss the distinction between centralized and decentralized conceptual database design:.
Centralized and decentralized design constitute variations on the bottom‑up and top‑down approaches we discussed in the third question presented in the discussion focus. Basically, the centralized approach is best suited to relatively small and simple databases that lend themselves well to a bird's‑eye view of the entire database. Such databases may be designed by a single person or by a small and informally constituted design team. The company operations and the scope of its problems are sufficiently limited to enable the designer(s) to perform all of the necessary database design tasks:
1. Define the problem(s).
2. Create the conceptual design.
3. Verify the conceptual design with all user views.
4. Define all system processes and data constraints.
5. Assure that the database design will comply with all achievable end user requirements.
The centralized design procedure thus yields the design summary shown in Figure Q6.6A.
Figure Q6.6A The Centralized Design Procedure
Note that the centralized design approach requires the completion and validation of a single conceptual design.
Note: Figures 6.15 and 6.16 contrast the two design approaches, Figure 6.6 shows the procedure flows; demonstrate that such procedure flows are independent of the degree of centralization.
In contrast, when company operations are spread across multiple operational sites or when the database has multiple entities that are subject to complex relations, the best approach is often based on the decentralized design.
Typically, a decentralized design requires that the design task be divided into multiple modules, each one of which is assigned to a design team. The design team activities are coordinated by the lead designer, who must aggregate the design teams' efforts.
Since each team focuses on modeling a subset of the system, the definition of boundaries and the interrelation between data subsets must be very precise. Each team creates a conceptual data model corresponding to the subset being modeled. Each conceptual model is then verified individually against the user views, processes, and constraints for each of the modules. After the verification process has been completed, all modules are integrated in one conceptual model.
Since the data dictionary describes the characteristics of all the objects within the conceptual data model, it plays a vital role in the integration process. Naturally, after the subsets have been aggregated into a larger conceptual model, the lead designer must verify that the combined conceptual model is still able to support all the required transactions. Thus the decentralized design activities may be summarized as shown in Figure Q6.6B.
Figure Q6.6B The Decentralized Design Procedure
Keep in mind that the aggregation process requires the lead designer to assemble a single model in which various aggregation problems must be addressed:
¨ synonyms and homonyms. Different departments may know the same object by differentnames (synonyms), or they may use the samename to address differentobjects(homonyms.) The object may be an entity, an attribute, or a relationship.
¨ entity and entity subclasses. An entity subset may be viewed as a separate entity by one or more departments. The designer must integrate such subclasses into a higher‑level entity.
¨ Conflicting object definitions. Attributes may be recorded as different types (character, numeric), or different domains may be defined for the same attribute. Constraint definitions, too, may vary. The designer must remove such conflicts from the model.
Information directly collected by the researcher specifically for the research are primary data
* Mean temperature of the earth in the year 2007
* Population of USA in 2005
* How many pages in Wikipedia by the 1st of January 2008
Compare and contrast rdbms with oodbms?
Relational database management systems (RDBMS) store data in tables with rows and columns, and use structured query language (SQL) for querying data. Object-oriented database management systems (OODBMS) store data as objects with attributes and methods, allowing for complex data structures and relationships. RDBMS are widely used for structured data while OODBMS are suited for applications with complex data structures and operations.
A database is used for storing your work and is a easy way to store information
A database is crucial for storing information, providing information to multiple users, easy access to data, fast information recall, and increased efficiency particularly for business owners.
Storing Information
A database is a type of file system that stores information. This is its most basic function. Instead of relying on traditional methods of storing information in physical file folders and cabinets, a database provides digital storage of information.
Providing Information To Multiple Users
Big advances in database technology allows multiple users to access and update information. This information will then be instantly viewable by all users. Not only does this enhance communication within a company, but it also ensures an informed and positive approach to customer service.
Easy Access To Data
A database manager provides easy access to information. Because the information is centralized, the user has no need to look to other applications or sources. All is provided through a singular database system, and the information in the database can be repurposed and fed into a company Web site or blog.
Fast Information Recall
Due in part to a series of complex algebraic algorithms that work together to recall information easily, querying a database should produce a quick result. When compared to locating the information manually, users find this quick recall an attractive feature of databases.
databases are used to store information from medical to personal.
you can use a database for
- recording results of a survey
- teaching
- bookings
A database is useful for storing information in it.
database are used to organise data into a more formal and understandable structure
Databases are used to reduce the redundancy and manage the data base of the employees more effectively and in a better way..
integrity of data can be provided , security of imp. data and easy retrieval of the desired information can be done
So database must be maintained to keep our data safe and secure....
Three ways in which information technology helps to make work easier?
One way that information technology helps to make work easier is through the use of email. Messages can be sent quickly and efficiently. The fax machine is another example, for instances in which a paper document needs to be sent immediately. A third way in which information technology helps to make work easier is through the use of internet search engines. These allow workers to access many different types of information instantly.
What is sampling which is related to information system?
Sampling in information systems refers to the process of selecting a subset of data or transactions from a larger dataset for analysis or testing. It allows organizations to efficiently analyze information without having to process entire datasets, which can be time-consuming and resource-intensive. Sampling helps in making inferences about the larger dataset based on the characteristics of the sampled data.
What is Resource-Intensive SQL?
Resource-intensive SQL refers to SQL queries that consume a significant amount of system resources such as CPU, memory, or disk storage. These queries can slow down performance and impact the overall efficiency of the system. It is important to optimize resource-intensive SQL queries to improve system performance.
A data base is where it allows you to Store information about something and it also includes fields.
What are the advantages and disadvantages of using database?
Advantages It means all of the information is together. The information can be portable if on a laptop. The information is easy to access at any time. It's more easily retrievable. Many people can access the same database at the same time. Improved data security. Reduced data entry, storage, and retrieval costs.
Disadvantages Database systems are complex, difficult, and time-consuming to design. Initial training required for all programmers and users. Suitable hardware and software start-up costs. A longer running time for individual applications.
Rational individual decision-making models assume individuals make decisions that maximize outcomes. Implications for information system analysts include designing systems that provide relevant information for decision-making, ensuring data accuracy and availability, and incorporating decision support tools to aid in the decision-making process. It is crucial for analysts to understand these models to develop effective and user-friendly systems that align with rational decision-making processes.
What are the techniques of data mining?
Data mining is one part of the process of Knowledge Discovery in Databases. There are many techniques within data mining that aim to accomplish different tasks. Generally tasks fall into one of two categories, predictive or descriptive. Predictive tasks look at historical data to predict what will happen in the future. Descriptive tasks will look at some given data and find patterns in it. Since data mining is a growing area, the techniques are constantly changing, as new improved methods are discovered. At present, some of the most well known predictive algorithms, known as classification algorithms include Naive Bayes, SVM, Decision Trees (such as C4.5), Artificial Neural Networks, k-Nearest Neighbour and more. Some predictive algorithms are able to perform regression, a form of prediction for non-categorical data. Some of the most well known descriptive algorithms include the Apriori and FP-tree algorithms (for finding association rules), K-Means and Hierarchical clustering algorithms, GSP and PrefixSpan for Sequential Pattern Mining and various algorithms for Outlier Detection. In 2006, at the International Conference on Data Mining (ICDM), the top algorithms were discussed (see http://www.cs.uvm.edu/~icdm/algorithms/index.shtml). This is a very limited list and many more algorithms have been and are being developed, as this area continues to grow and expand to encompass new problems and applications.
A DBMS (Database Management System) is a software application that allows users to interact with a database. An RDBMS (Relational Database Management System) is a type of DBMS that organizes data into tables with rows and columns, and uses structured query language (SQL) for querying and managing data. RDBMSs are a subset of DBMSs, designed specifically for relational databases.
What is symbol table and in which part of the memory it is stored?
Symbol table is a file that Compilers / Assemblers use to store symbols and their equivalent relative memory locations, values, data types for the following steps. It's an intermediate file, so the compiler chooses where to store it. Some compilers delete the file after processing
What is difference between primary key and foreign key?
A primary key is an attribute (or combination of attributes) that uniquely identifies each row in a relation. A primary key is designated by underlining the attribute name. The primary key of an entity set allows us to distinguish among the various entities of the set. A foreign key is an attribute in a relation of database that serves as the primary key of another relation in the same database.
What is the difference between sequel and SQL?
The definition of the word Sequel is "that which follows in consequence of what has previously happened" Ie. The Godfather 2 was the sequel to The Godfather.
SQL on the other hand, was originally an acronym for Structured Query Language. SQL is a standard interactive and programming language for getting information from and updating a database.
SQL (correctly pronounced "ess cue ell,") is in slang referred to as "Sequel" as a method of pronouncing the 3 letter acronym. The 'sequel' pronunciation is a carryover from when there was actually a SEQUEL language.
