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
How does Microsoft sql server work?
SQL Server is a database server. It is used to store data which is accessed using any number of methods. Generally, the data will sit on a server (or several server) machine while users access it from remote terminals.
What do you think the advantages of storing data as a code may be?
The advantage of storing data as a code is that if you had to write it there would be more spelling mistakes and errors.
What are three dimensions of management information system?
Most of us think of only hardware and software when we think of an Information System. There is another component of the triangle that should be considered, and that's the people side, or "persware."
-patrick73
What does the term record mean in relation to databases?
Record is more a term related to databases than to spreadsheets. However, as you can do some database work using a spreadsheet, then it can be a term used in a spreadsheet. A record in a database is a row of related data, such as the name, age, address and phone number of a person. If it is done in a spreadsheet, with each set of data on a separate row, it can be regarded as being a record.
How do you find clipboard on PC?
To find the clipboard on PC, the user should go to the Microsoft Word, Click EDIT on top of the page, and then Click OFFICE CLIPBOARD. The clipboard will show up on the right side of the page.
How do you retrieve the data from database?
To retrieve data rfrom a mysql database you first need to connect to the database using the mysql connection string(mysql_connect) after that, it's just a matter of executing a query of "SELECT `field1`, `field2` FROM `tablename`" Obviously replacing field 1 and 2 with the fields you want to replace and tablename with the table the data is stored
Sequential data is when things are stored and accessed in order, starting from the beginning (or end) of the file. So to access a given record, you would have to access everything before that point. Sometimes this is the only way to access things, such as items stored on tape.
Is Microsoft access a database or a spreadsheet?
No it is not. However, there are a lot of things that both a database and a spreadsheet can do, so Access does have some capabilities to do what a spreadsheet can. Spreadsheets focus on numeric analysis and manpulation, so mostly concentrate on numbers. Databases deal with processing lists of data, some of which would be numeric, but it works with a lot of other kinds of data. Microsoft Access is a database and that is what it is designed to be, so it is not a spreadsheet.
Databases tend to get split up into a variety of diffrent catagoies based on their application and requirements. All of these diffrent catagories naturally get nifty buzz words to help classify them and make distinctions in features more apparent. The most popular buzz work (well, acronymn anyway) is OLTP or Online Transaction Proccessing. Other classifications include Descision Support Systems (DSS), Data Warehouses, Data Marts, etc.
OLTP databases, as the name implies, handle real time transactions which inherently have some special requirements. If your running a store, for instance, you need to ensure that as people order products they are properly and effiently updating the inventory tables while they are updating the purchases tables, while their updating the customer tables, so on and so forth. OLTP databases must be atomic in nature (an entire transaction either succeeds or fails, there is no middle ground), be consistant (each transaction leaves the affected data in a consistant and correct state), be isolated (no transaction affects the states of other transactions), and be durable (changes resulting from commited transactions are persistant). All of this can be a fairly tall order but is essential to running a successful OLTP database.
Because OLTP databases tend to be the real front line warriors, as far as databases go, they need to be extremely robust and scalable to meet needs as they grow. Whereas an undersized DSS database might force you to go to lunch early an undersized OLTP database will cost you customers. No body is going to order books from an online book store if the OLTP database can't update their shopping cart in less than 15 seconds.
The OLTP feature you tend to hear most often is "row level locking", in which a given record in a table can be locked from updates by any other proccess until the transaction on that record is complete. This is akin to mutex locks in POSIX threading. In fact OLTP shares a number of the same problems programmers do in concurrent programming. Just as you'll find anywhere, when you've got a bunch of diffrent persons or proccesses all grabbing for the same thing at the same time (or at least the potential for that to occur) your going to run into problems and raw performance (getting your hands in and out as quick as possible) is generally one of the solutions.
Several other factors come into place with OLTP databases, and the Oracle10g documentation library even has a whole section dedicated just to OLTP. Find more information in the Oracle10g docs:
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications, be it those on the same computer or those running on another computer across a network (including the Internet). There are at least a dozen different editions of Microsoft SQL Server aimed at different audiences and for different workloads (ranging from small applications that store and retrieve data on the same computer, to millions of users and computers that access huge amounts of data from the Internet at the same time). Its primary query languages are T-SQL and ANSI SQL.
What is difference between MySQL server MsSQL?
MSSQL is the abbreviation for the Server system Microsoft has.
Compared to MySQL, which is the SQL server system that is open source, maintained by the MySQL company (Now owned by Sun).
A database record is a row of data in a database table consisting of a single value from each column of data in the table. The data in the columns in a table are all of the same type of data, whereas the rows represent a given instance. Example Table: ========================================================== Column Names: ID FirstName LastName BirthDate ========================================================== 1 George Gray 1/6/1960 2 Thomas Green 2/29/2000 3 Cynthia Black 5/30/1976 ========================================================== For the given table above, an example of a column of data would be FirstName. All the values in that column are first names. An example record (or row) would be the record with ID = 2 which represents the record for Thomas Green and contains each field from that row. Properly designed relational databases use "primary keys" to uniquely identify records in a database. The value (or values) that compose the key must uniquely identify the entire row and only that entire row in that table. That primary key can then appear in another table to represent a relationship between that table and another table. In the example above, the ID column would serve as the primary key for the table.
What is a collection of data that is stored electronically as a series of records in a table?
A database.
What are the disadvantages and advantages of dynamic system development method?
Advantages of system development life cycle in terms of waterfall model it only requires minimal resources in implementing this method. But it is hard to go back and change.
What is the purpose of a database?
A database allows developers and designers to communicate with a medium which stores related information. For example, Jeff might create a database which will allow users to register. Once they register, their usernames, password and email will be inserted into a database. We then can use this database later to say "Welcome $user" and uniquely identify them.
What three advantages of an electronic database over a manual database?
Name three benefits to electronic data storage by incorporating a data mining service
The Database Approach has four common characteristics. These are: Self-describing nature, support multiple user view of data, share the data and multiple user transaction processing and insulation between data and data abstraction.
A spreadsheet, such as Microsoft Excel, Lotus 123, Quattro Express, Open Office Calc etc.
What are the disadvantages of data projectors?
The only real disadvantage of LCD projectors is a visual effect that has been known as "Screen Door". This is when you can see noticeable pixels in the projected image...sort of like looking through a screen door.
The effect is caused by the tiny distances between the individual LCD imaging units.
The effect is not as noticeable in models produced recently.
That is a database that can allow simultaneous record entry by more than one person.
Can a folder only contain files?
You can have both files and folders in other folders. Sometimes they are referred to as sub-folders to indicate that they are inside another one.
Can you file bankruptcy 3 times?
Currently, there are no limits to the amount of times you can file for bankruptcy or the time frame between each filing. However, if you file too soon you are less likely to be eligible for "discharge." It is suggested by most to wait at least seven years between each filing in order to qualify for discharge.
For more information on bankruptcy you find it on our site: http://www.kohlawfirm.com/bankruptcy
These materials do not, and are not intended to, constitute as legal advice.
