Classical Chinese database

1. database with the content of 1. View through the "performance" of the system: Start->; Management tools-> Performance (or enter mmc in the operation), then add the common statistics of SQL by adding counters, and then select User Connection in the items listed below, and you can query the number of sql server database connections at any time.

2. Query by system table: select * from [master]. 【dbo】。 [sysprocesses] where [dbid] is in (select [dbid] from [master]). 【dbo】。 [sysdatabases] where name =' databasename'). DatabaseName is the database that needs to be viewed, and then the number of rows queried is the current number of sql server database connections. However, there are some other states that can be used for reference.

Or use the following query statement: select * from sysprocesses where dbid in (select dbid from sysdatabases where name =' my database').

2. Chinese dictionary database Where can I download Chinese dictionary software files? Software Name: Chinese Dictionary Software Language: Simplified Chinese Software Category: Domestic Software Application Platform: win9x/me/nt/2000/xp Download Address:.

3. Paradigm Hello, I'm glad to answer your question.

First normal form: Make sure that every column is atomic. First normal form is satisfied if every column (or every attribute) is the smallest unit of data (also called the smallest atomic unit) that cannot be subdivided.

For example, in the customer table (name, number, address, ...), the "address" column can also be subdivided into country, province, city, district, etc. The second paradigm: based on first normal form, the goal is to ensure that every column in the table is related to the primary key.

If a relationship satisfies the first normal form and all columns except the primary key depend on the primary key, then the second normal form is satisfied. For example, in the order table (order number, product number, order date, price, ...), the order number is the primary key, and the product number is not directly related to the primary key column, that is, the product number column does not depend on the primary key column and should be deleted.

The third paradigm: Going further than the second paradigm, the goal is to ensure that each column is directly related to the primary key column, not indirectly. If the relationship satisfies the second normal form and all columns except the primary key do not depend on the primary key column, then the third normal form is satisfied.

In order to understand the third paradigm, we need to define transitive dependence according to one of Armstrong kilometers. Suppose that A, B and C are three attributes of the relation R. If A-> B and B-> C, A-> C can be obtained from these functional dependencies. As mentioned above, dependency A-> C is a transitive dependency.

For example, the order form (order number, order date, customer number, customer name, ...) meets the second normal form at first glance. Each column is related to the primary key column "Order Number". If you look closely, you will find that "customer name" and "customer number" are related, and "customer number" and "order number" are related. Finally, through the transport dependency, "In order to satisfy the third paradigm, the' customer name' column should be removed and put into the customer table.

4. Database, what word can the system generally use instead of 1? Now oracle is widely used in general manufacturing industry.

2, commercial enterprises use sybase more, and oracle.

3.sql server is widely used in financial management (UFIDA, etc. ), but now there are also for oracle version;

4. Small and medium-sized enterprises use mysql and sql server more, and large online shopping malls use orcale more.

Oracle and sybase are both large databases, and the operating system of the server that generally uses such databases is linux. In terms of operating system security, sql server will choose oracle and sybase for enterprise-level operation. In addition, although mysql also runs on linux, it is rarely used at the enterprise level because it is a free version.

5. Ask God to help explain how the database of this article is designed. It must be designed by SQL Server, because first of all, there is a large amount of data, which is not supported by a stand-alone file database like access. Secondly, sql sever supports stored procedures, transactions, user-defined functions and so on. , also better than access; In terms of development efficiency and database security; Moreover, a remarkable feature of sql server is the concurrent connection of databases, and access can only realize a single connection, which is impossible for access to realize the normal operation of the system in a system with a certain number of users.

There are many reasons, the above is a brief talk.

In addition to sql sever, oracle is also the choice of background database for large programs (websites).

Each database has its own management tools, development and debugging environment, external interface protocols and so on.

6. Where can I download a complete idiom dictionary? The Chinese Dictionary includes four classical novels, 36 books, 2090 1 Chinese characters, 3 1000 idioms, 320,000 words, 1280 synonyms, 5,240 antonyms, 93,600 poems, 26,800 riddles and 5,270 pairs. There are 1.900 proverbs, 1.300 proverbs, hundreds of couplet stories, 1.000 children's literature, 1.000 classical Chinese explanations and many other contents. These functions are briefly described as follows:

1, full-text search function, which can realize fuzzy search according to any content, such as searching related poems according to words, phrases and famous sentences.

2. The classification tree is intuitive, and poems, proverbs, epigrams, couplets, riddles and articles are classified in detail, which can meet the needs of users for leisure reading.

3. Full Chinese computer reading, you can read any Chinese content and convert any text into a sound file;

4. The children's reading aid can mark and read any text with pinyin, and can also generate Word files with pinyin marks, and any typesetting will not affect the effect, making it more convenient for children to read articles; In particular, the pinyin we marked is the same as the typesetting format of the Children's Pinyin Reader published by the publishing house, which is more in line with children's reading habits and supports a large number of polyphonic characters, which is essentially different from some simple pinyin-adding Chinese characters.

5. An article manager that supports infinite classification and is easy to use. It contains thousands of children's literature works, more than 2,500 wonderful jokes and a large number of literary works, including classic books such as China, Four Classic Novels, Thirty-six Strategies, Complete Works of Aesop's Fables, Andersen's Fairy Tales, Hundreds of China Fairy Tales and Idiom Stories. The added articles can be dragged arbitrarily in the directory tree to change their classification.

6. A Chinese dictionary containing 2090 1 Chinese characters and their definitions can be searched according to Chinese characters, pinyin and radicals;

7. A universal dictionary containing 320,000 words and explanations;

8. An idiom dictionary containing 3 1850 idioms, pinyin, definitions, sources and example sentences, providing interesting idioms solitaire games;

9. A dictionary of classical Chinese, including thousands of definitions of classical Chinese words, full-text explanations of classical Chinese from junior high school to university and a large number of ancient Chinese learning skills, all of which are displayed intuitively in the form of a directory tree;

10, a synonym dictionary, containing more than 1280 synonyms;

12, antonym dictionary, containing more than 5240 antonyms;

13, a collection of poems, contains more than 93,600 poems from pre-Qin to modern times, including authors, appreciation and textual research. , according to the year and the author in the form of a directory tree;

14, complete works of famous aphorisms, 13000 famous aphorisms and their sources, which are displayed intuitively in the form of a directory tree;

15, a complete collection of folk proverbs, including14,000 two-part allegorical sayings, 1900 proverbs and a large number of tongue twisters, which are displayed intuitively in the form of a directory tree;

16, riddle encyclopedia, including more than 26,800 riddles and a large number of riddle stories, such as crossword puzzles, word games, poetry games, object games, etc., which are visually displayed in the form of a directory tree;

17, a collection of couplets, including 5,270 couplets and hundreds of couplets stories such as Spring Festival couplets, Shoulian couplets, Xilian couplets and Juelian couplets. , visually displayed in the form of a directory tree;

18, perpetual calendar, periodic table of elements, 24 solar terms, comparison table of Chinese historical dynasties, conversion of time around the world and other common tools;

19, the self-expansion function of the database, which can add the contents that are not in the database according to your own needs for daily use;

20, built-in background music support.

2 1, area code inquiry function, and you don't have to worry about area code inquiry for all kinds of supplementary cards.

22. You can provide free online upgrade service by logging in.