National Research UniversitySchool of EconomicsBranchBusiness InformaticsInformation Technologies in Business
Research Proposala Data Mart for an Online E-Book Store
Student Linar_R._IbragimovBi - 10-2
Perm 2013
1. Introduction
Forum - class of applications for communication site visitors. Forum offers a set of topics for discussion. his job is to create users in those sections and the subsequent discussion within these themes. Individual subject, in fact, is a thematic guestbook. A common hierarchy Forum is Sections? topics? posts. Typically, messages carry information «author - Topic - the content - the date / time.» Message and all replies to it forms a «branch» or «topic» aim of this work was to design an example of such a database. All information about user, such as name, surname, address, post address, number of messages and their content, as well as information about the user and his friends.
2. Description of the subject area
2.1 A summary of the forum
database web forum
This database stores information about users of the forum. It will be used for viewing all user actions from the time of its registration. Also, you can add a user.database contains the basic elements of the Forum such as users, themes, messages, and other. A full list is shown in Table of objects
of objects
№ ObjectDescription1UserBecause forums are designed for communication between people, «user» is the key object database. He has a connection with almost all the other objects. Table «user» contains profile information about the users of the Forum, from the name, ending with the current status.2User s friendsObject «Friend» is closely connected to the «user» .. 3Violations of userSometimes users may not comply with the rules of the forum so there is a system of penalties. This object is created so that the administrator could know the «history of violations of the user» 4User s online history Allows you to view user s online history5TopicsUsers create «Theme» for what to discuss any particular topic or news, in a specially prepared virtual space.6MessagesMessage this text that contains certain meaning that the user would like to pass other forum users.
2.2 Description directories
necessary directories:
1) Countries: Information about the countries where users live ..
2) Status: Information of the current status of the user.
3. Planning of database
database should include the following sections:
· Information about user
· Information about topics
· Information about messages
· Information about violations
· Information about user s online history
· Information about User s friends
The database will have the following attribute...
