Alibabacloud.com offers a wide variety of articles about online shopping database design, easily find your online shopping database design information here online.
Yesterday, the main description of the site requirements and functional structure, today took a bit of time, summed up the site of the specific database design has also been used in the development environment and tools.If you are interested in the previous summary of friends can view my previous blog Ajax Online music website (1) Requirements and functional stru
II. operating environment and system structure
This application is widely available on the Internet, the Internet, and the internal LAN. Its operational requirements and logical structure are as follows:
Client: Windows95/98,internet Explorer (IE)
Server-side: Windows nt/windows2000,internet Information Server (IIS) 4.0 and above, ie, or windows98,personal Web server (PWS), ie, and so on.
DB: SQL Server, running on the server side.
The logical structure diagram of test questions
Database Technology-database Naming and Design Specifications database development history has been using a somewhat mysterious system naming database table and field. In the original database management system (DBMS), the results
My first python web development framework (4) -- database structure design and creation, and python Structure Design
After finishing the front-end html design, Tom immediately began to design the database structure.
Before he s
Part 2-Design tables and fields1. Check for various changesWhen designing a database, I will consider which data fields may change in the future. For example, the last name is like this (noteIt refers to the surname of a westerners, for example, the surname of a female after marriage ). Therefore, when establishing a system to store customer information, I tendStore the Last Name field in a separate data ta
the Flowing Data arrows ).
Data Storage: Indicates the Opening Rectangle or two parallel horizontal lines of the data to be stored ).
Top-level flowchart of the Order Processing System:
Layer-0 data flow diagram:
2.3 Database Design
2.3.1 Conceptual Structure Design
Abstract transactions and describe them in the form of a E-R Diagram
E-R graph entity co
As a data container, the database not onlyProgramPerformance has a great impact on application expansion. therefore, for applications, a well-designed database is very important. how can we design a database with good performance and support for expansion? This is a question that we all need to explore. there are many
Tags: Time table transaction post customer service sharing cannot SSI"The beginning of the database design classic", is now learning this book, although the previous read a similar book, may be due to previous experience, some of the book said something only digested part, now relive side understood more. So read the first time read do not understand it does not matter, after a a year to read again, or will
contain additional business logic.
(4) In the rule 4:mysql, ll_create, ll_modified use datetime types.
(5) Rule 5: Prohibit the use of complex data types (arrays, custom types, etc.).
(6) In rule 6:mysql, the satellite table ID is consistent with the primary table ID when the subordinate table is split. New primary key fields are not allowed in the satellite table.
(7) In the rule 7:mysql, the table with outdated concept must have the expiration mechanism at the beginning of its
cookie will take PHPSESSID, The server then finds the corresponding file to save the session based on the PHPSESSID.So the duration of the session is divided into the client and server side.ClientSession.cookie_lifetime=0, closing the browser session will expireServer-sideValidity of Session.gc_maxlifetime//sessionSession.gc_probabilitySession.gc_divisorSession.gc_divisor and session.gc_probability together define the probability of starting the GC (garbage collection garbage collection) proces
Design tables and fields1. Check for various changesWhen designing a database, I will consider which data fields may change in the future. For example, the last name is like this (noteIt refers to the surname of a westerners, for example, the surname of a female after marriage ). Therefore, when establishing a system to store customer information, I tendStore the Last Name field in a separate data table, an
attributes?Logic design:The logical modeling of the database is mainly through ER diagramsPhysical Design:Fully taking into account the characteristics of each database management system;Transform logical design into physical design according to the characteristics of the database
Label:Yesterday someone asked me database design principles, more than a year did not do service end this piece also basically forget clean, remember what two level, three level what (do not misunderstand this is not the result of the yellow film to see much), the university also learned the database, the university also from the requirements to the
to the multi-to-many relationship is much harder than the first one.
8) plan data retention and recovery
Consider data retention policies and include them in the design process to design your data recovery process in advance. The data dictionary that can be released to users/developers is used for convenient data identification and data source documentation. Write onli
and multi-site update functions, with location transparency and venue autonomy. It provides a global database name and supports remote process calls.
Development Tools
The Development kits provided by Oracle are developer/2000, designer/2000, discover/2000, and Oracle office. They cover all aspects from modeling, analysis, design to implementation.
Developer/2000 includes:
Oracle Forms is used to quickly g
customers and their related orders may have two tables: customerAnd order. The Order table is not a package.Contains any information about the customer associated with the order, but the table stores a key value that points to the customer table containing the customer information.There are also higher levels of standardization, but will higher standards be better? The answer is not necessarily. In fact, for some projectsEven 3nf can introduce too much complexity to the
relationship in the first place. Shifting from the existing many-to-many relationship to many-to-many relationships is much more difficult than a many-to-many relationship in the beginning.
Take a View
To provide another layer of abstraction between your database and your application code, you can create a special view of your application without having to access the data table directly from the application. Doing so would also give you more freedom
user sign in with the mobile phone number. The user provides the home address as the default shipping address. User key information is the phone number and address.2, product few but good. To have high-quality pictures and text introduction. Including the origin, nutrition, whether the season, suitable for the crowd, eating, how to choose and other information. Of course, information can be constantly perfected.3, the user orders, the background response to delivery, customer receipt confirmati
= Redis.sdiff ("Tag.ruby", "Tag:web")
A collection of Ruby and Web-owned books.
Inter_list = Redis.sunion ("Tag.ruby", "Tag:web")
It's not easy enough.
From the above 2 examples can be seen in some scenarios, relational database is not very appropriate, you may be able to design a system to meet the needs, but always feel strange, there is a kind of rote feeling.
In particular, login system This example,
: Represents the data flowing (indicated by an arrow line).data storage : Used to represent the data to be stored (open-door rectangles or two parallel horizontal lines).Order Processing System Top-level flowchart:0 Layer Streaming Chart:2.3 Database Design 2.3.1 Conceptual structure design
A transaction is abstracted in the form of a e-r diagram.
E
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.