« Avatars on Weblogs@UPEI | Main | Serving the Suits »
An intro to databases
Where the presentation layer governs the user's interaction with an ebusiness system and the application layer coordinates its behaviour, it's the data layer that brings an ebusiness system to life -- structured information defines entities and relationships representing the actual business and affairs the system exists to support.
Here, to introduce the topics of databases and business intelligence, we will review some key terms.
| What is data? | In a broad sense raw data are numbers, characters, images or other outputs from devices which convert ideas or physical objects into symbols. Raw data is a relative term; data processing commonly occurs by stages, and the "processed data" from one stage may be considered the "raw data" of the next |
| What is information? | Data on its own has no meaning, only when interpreted by some kind of data processing system does it take on meaning and become information. People or computers can find patterns in data to perceive information, and information can be used to enhance knowledge. Since knowledge is prerequisite to wisdom, we always want more data and information. But, as modern societies verge on information overload, we especially need better ways to find patterns. |
| What is an entity | An entity is something that must be distinctly represented in an eBusiness system. People, organizations, accounts, products and services, customers, orders, and suppliers, are all examples. |
| What is persistence? | For our purposes think of persistence as the characteristics of continuity, reliability, and connectedness. Persistence of data and business logic, over time, and throughout an ebusiness process, even as it spans multiple software components, or even as a system is stopped and restarted, is critical to creating a seamless and stable system. |
| What is a Database? | A database is an information set with a regular structure |
| What is a Relational Database Management System (RDMBS)? | A database management system (DBMS) is a computer program (or more typically, a suite of them) designed to manage a database, a large set of structured data, and run operations on the data requested by numerous users. See: relational databases. |
| What is the relational approach to managing data? | When managing data using the relational approach information is represented by data values arranged in mathematical relations. The data is operated upon by means of a relational calculus and algebra. The relational model permits the database designer to create a consistent logical model of information, to be refined through database normalization |
More terms:
http://hea-www.harvard.edu/MST/simul/software/docs/pkgs/pgsql/glossary/glossary.html
http://www.canberra.edu.au/~sam/whp/db-terms.html
See: Building Business Intelligence
Posted by Mark Hemphill on November 18, 2004 | Permalink
Comments
Are we going to look at database programs like MS Access, maybe a demo of how they search through the records using a criteria or something ?
Posted by: David Chapman | Nov 23, 2004 4:12:41 PM
chapter 8 gives some good info on databases and starts to get into structured query language which is "the standard language used to create, maintain,and retrieve data from relational databases" as well as other data management systems.
Posted by: Mike | Nov 24, 2004 1:38:26 PM
I studied database design and programming at college a few years back. Its pretty neat actually. You have to learn how to speak a different language almost, everything has to be 'logical' and make sense to a computer. I remember it being getting pretty complicated at the end of the course. When I studied SQL you had to have your language down to an exact science, it could get pretty difficult too, especially when dealing with mulitple fields and tables.
SQL is a widely used language out there today. I hear that Oracle administrators make a nice amount of money. I don't know if thats what I would want to do for a career but it is interesting nonetheless.
Posted by: Ryan Quinn | Nov 24, 2004 6:46:53 PM
?question? Ware would one go to find different kinds of data management systems and can they be customized for different applications,
Example 1 – for mortgage business
Example 2 - for international trade business
Example 3 - for immigration consulting
Posted by: Myron Wood | Nov 30, 2004 2:25:26 PM
I believe there are web businesses that provide customized Data Management systems to suit your needs. Search Google and perhaps you may find one.
Posted by: Jordan Mackinnon | Dec 2, 2004 12:23:56 AM
The comments to this entry are closed.