background preloader

Databases

Facebook Twitter

Assorted resources on the subject.

Country Research - Databases by Subject - UCF Libraries. *Best Resources Search by word or country then go to the education section. By the Library of Congress. Access: Free Full text of news and legal sources, as well as company and industry data. Limited coverage of business and health administration news. Access: Proxy Vendor: LexisNexis Back to Top Other Resources Access: Free Vendor: Worldbank PAIS International database from CSA contains references to more than 553,300 journal articles, books, government documents, statistical directories, grey literature, research reports, conference reports, publications of international agencies, microfiche, Internet material, and more. Access: Proxy Vendor: Proquest Provides high quality national and international statistics to clients within and outside the Bank and to improve the capacity of member countries to produce and use statistical information. Vlad Mihalcea's Blog | A beginner’s guide to database locking and the lost update phenomena.

A database is highly concurrent system. There’s always a chance of update conflicts, like when two concurring transactions try to update the same record. If there would be only one database transaction at any time then all operations would be executed sequentially. The challenge comes when multiple transactions try to update the same database rows as we still have to ensure consistent data state transitions.

The SQL standard defines three consistency anomalies (phenomena): Dirty reads, prevented by Read Committed, Repeatable Read and Serializable isolation levelsNon-repeatable reads, prevented by Repeatable Read and Serializable isolation levelsPhantom reads, prevented by the Serializable isolation level A lesser-known phenomena is the lost updates anomaly and that’s what we are going to discuss in this current article. Most database systems use Read Committed as the default isolation level (MySQL using Repeatable Read instead). Hibernate includes all row columns in an UPDATE statement.

18 best online resources for learning sql and database concepts. Let’s take a look at some of the best online resources to help beginners get started with SQL. These tools focus on SQL syntax and basic SQL concepts. w3school The website w3schools provides various tutorials for SQL, HTML, CSS, JQUERY and others. What can you learn there? Their online tutorial guides you through SQL syntax and covers the most important SQL statements, keywords, and functions. Short but concrete descriptions and many examples make their tutorials easy and pleasant to read.

SQLZOO is a nice interactive SQL tutorial featuring live interpreters and interactive exercises for multiple types of databases, such as MySQL, PostgreSQL, Oracle, SQL Server, and DB2. Tutorialspoint: sql TutorialsPoint provides a nice guide from basic SQL and the most useful SQL functions to more advanced parts of SQL with many easy to understand examples.

SQL Problems and solutions tuts+: SQL for beginners SQL for beginners is more of an article than tutorial. SQLCourse Essential sql Learn SQL the hard way. Free Database Tools Freeware downloads and reviews from SnapFiles. Dcom Database Analyser - Rivit Technology Partners Rivit Technology Partners. Rivit's Dcom Database Analyzer gathers and presents important statistical information about your Domino applications. With the information collected, your organization can make important decisions about the future of each and every database application. The Dcom Database Analyzer provides an accurate list of all Domino applications and includes important information such as usage history and patterns, database size and document count, database ownership, purpose and complexity. By providing an accurate and detailed inventory of all Domino applications in the environment, important decisions with respect to the end target of each application database can be made.

Typically, those applications that provide zero value to an organization can be eliminated form the environment immediately. Applications that contain business relevant data can be maintained in Dcom for compliance or business continuity purposes. The Dcom Analyzer is provided at no cost with every Dcom proof of concept. UML Diagramming Tools | Diagramming.org. Data Visualization Training. Data visualization refers to the process of converting data into a graphical or visual representation. Because our brains process visual information so efficiently, visualizing data graphically greatly speeds up the process of data analysis. To quickly illustrate the difficulty of understanding data in numerical form, time yourself as you search for the outlier in the following data set: Now time yourself as you search for it in the same data set, but this time with the data presented visually: Much faster, isn't it?

This was a simplistic example, but illustrates nicely the time saved by using visualization as an analytic tool, rather than simply generating nice charts and graphs for presentations. The General Social Survey In this example, we'll be using Tableau's data visualization software to explore some data from the General Social Survey. Acceptance of premarital sex has been steadily increasing in the US. Connecting to Your Data Measures and Dimensions Editing Aliases and Data Labels. Find databases | McGill Library. Finding databases for a discipline/subject Databases are search engines that allow you to search across collections of journals and articles. Some databases, like Scopus and ProQuest Central, are multidisciplinary and include articles from a variety of academic disciplines. Others, like PubMed, are more specialized and focus on a single discipline. To find databases for a discipline or subject, visit our subject guides.

The subject guides maintained by McGill's librarians are an excellent way to discover the top databases to use in a given area of study. Tip: Each subject guide also has the contact information for the liaison librarian specialized in that subject area, so if you have any questions you can contact the librarian directly for help. Need help finding databases? Finding a specific database To find a specific database, search WorldCat. You can also use the Databases A-Z listing to search for a known database or browse for it by title. Using WorldCat to find a specific database. Devdata.worldbank. Best Lesson Plan Websites - Teachers, Free Lesson Plans.

Education World Lesson Planning Channel Theme lessons, printable worksheets, everyday edits, games and more. Standards Toolbox - free to teachers The Standards Toolbox provides one-click state standards alignment, curriculum mapping, materials storage and sharing, lesson planning, individualized instruction, teacher websites, and an educator community -- all from a single platform! Lesson Plan Central - Thousands of Free Lesson Plans, Worksheets, WebQuests Free Lesson Plans and clipart in Math, Social Studies, Art, Language, Arts, Music, PE, Reading, Writing, Geography, Science projects and Science lesson plans.

High Tech High - Project Based Learning 7 thoroughly documented PBL projects from High Tech High School in San Diego, CA. eGFI Engineering, Science & Math eGFI provides science and math lessons and activities to help students learn about engineering. The Jigsaw Classroom: A Cooperative Learning Technique Aesthetic Computing for Math Teachers Lesson Plans 4 Teachers: Lesson Plan Templates. Recommended Databases - Recommended Databases for Reference: Encyclopedias/Dictionaries - Browse Databases by Subject at Duke University. The 36 best tools for data visualization.

It's often said that data is the new world currency, and the web is the exchange bureau through which it's traded. As consumers, we're positively swimming in data; it's everywhere from labels on food packaging design to World Health Organisation reports. As a result, for the designer it's becoming increasingly difficult to present data in a way that stands out from the mass of competing data streams. Get Adobe Creative Cloud One of the best ways to get your message across is to use a visualization to quickly draw attention to the key messages, and by presenting data visually it's also possible to uncover surprising patterns and observations that wouldn't be apparent from looking at stats alone. As author, data journalist and information designer David McCandless said in his TED talk: "By visualizing information, we turn it into a landscape that you can explore with your eyes, a sort of information map.

There are many different ways of telling a story, but everything starts with an idea. Databases for literature searching. Literary Reference Center | Literary Research Database. This comprehensive, full-text database provides a broad spectrum of information on thousands of authors and their works across literary disciplines and timeframes—to give students, professors, and researchers a foundation of literary reference works to meet their research needs. Superior Content Combining information from major respected reference works, books, literary journals, and original content from EBSCO, Literary Reference Center features an expansive collection of author biographies, plot summaries and work overviews, full-text essays from leading publishers, literary reference books and monographs, cover-to-cover full text for literary magazines and journals, book reviews from the most prestigious publications, poems from hundreds of sources, short stories, classic texts, author interviews, and much more.

School Curriculum Support {quote} Literary Reference Center is a literature student's dream... List of academic databases and search engines. Wikipedia list article This page contains a representative list of notable databases and search engines useful in an academic setting for finding and accessing articles in academic journals, institutional repositories, archives, or other collections of scientific and other articles. Databases and search engines differ substantially in terms of coverage and retrieval qualities. Users need to account for qualities and limitations of databases and search engines, especially those searching systematically for records such as in systematic reviews or meta-analyses.[1] As the distinction between a database and a search engine is unclear for these complex document retrieval systems, see: the general list of search engines for all-purpose search engines that can be used for academic purposesthe article about bibliographic databases for information about databases giving bibliographic information about finding books and journal articles.

See also[edit] References[edit] Bentley Library. Use this tool to easily optimize regular gifs, animated gifs, jpgs, and pngs, so they load as fast as possible. Create alternating colored horizontal rules quickly with this new Web 2.0 tool. Gradient images are used everywhere in web page design, such as the background of form buttons, DIVs, to act as shadows etc.

This tool lets you easily generate a gradient image. ABI/INFORM Dateline delivers over 255 journals, with more than 200 available in full text. It includes hard-to-find local and regional business publications with news about local companies, analysis, information on local markets, and more. Content covers 1982-present and is updated daily. Contains abstracts, full-text HTML, full-text HTML with graphics, and PDF formats. ABI/INFORM Global is one of the most comprehensive business databases on the market. ABI/INFORM Trade & Industry is the perfect companion to the business and management content in ABI/INFORM. U.S. Full-text coverage of the Boston Globe from 1980-present. Databases by Subject | University Library. Home - Databases by Subject - Library guides at Monash University. Article Databases by Subject Area. UC Databases - Library - University of Canterbury.

Library databases provide access to a vast amount of material published in journals, newspapers, legal and other specialist collections. Many contain links to the full content, for example, full-text of articles, legal cases and citations, music and video files. Databases by Title Databases by Subject MultiSearch Help with Using Databases Access to most databases is available from anywhere that has an internet connection. For off-campus you need to login using your UC login and password. Licensing and Access Restrictions Important: Licensing and access restrictions apply to electronic databases. Databases may be searched only for the purpose of University teaching, study or research. Licensing and access restrictions apply to many electronic resources, including eBooks. Where restrictions apply, electronic resources may be searched and used only for the purpose of University teaching, study or research.

Browse Database A-Z Listing - Baker Library | Bloomberg Center. PCC Library - Databases by Subject. Donate Now beta Pasadena City College, Home of the PCC Lancers Research Browse Research Databases Periodical titles: alphabetical list Login required off-campus Access information Databases by Subject Quicklinks: General: EBSCOhost Search a wide variety of databases which cover thousands of journal, magazine, and newspaper articles covering all disciplines. National Newspapers Core (Proquest) Covers the Los Angeles Times, New York Times, Washington Post, Wall Street Journal, and Christian Science Monitor. SIRS Knowledge Source Articles about Arts and Humanities, articles from popular magazines, newspapers and U.S. government publications. Scholarly: Academic Search Premier (EBSCO) Multi-disciplinary database provides full text for academic journals covering a variety of subject areas. JSTOR Arts & Sciences is a full text database focused on the arts and humanities.

Project Muse Full text scholarly journal articles covering the humanities, and social sciences. Media: Films on Demand Intelecom Art & Music: Databases by Subject - Douglas College. Databases by Subject Area and A-Z - Subject A-Z | Databases by subject. The University of Edinburgh Schools & departments Search Site Information Services Contact Related links Databases by subject Subject A-Z The databases provided by the Library have been organised by subject to help you find the most relevant resources for your study and research. Accounting African Studies Agriculture Anthropology Archaeology Architecture & Landscape Architecture Art & Design Artificial Intelligence: see Informatics Arts and Humanities Astronomy: see Physics. Biblical Studies Biological Sciences Business and Management Canadian Studies Celtic & Scottish Studies Chemistry Chinese Studies: see East Asian Studies Classics Clinical Psychology Clinical trials Cognitive Science: see Informatics Computer Science: see Informatics Counselling Design: see Art & Design Development Studies Divinity Film Studies Forestry French Studies Full text GeoSciences German Studies Global Public Health Hispanic Studies History History of Art Newspapers Nursing Official Publications.

Services A-Z :: Library :: Search for :: Databases by subject. Databases for Subjects. University/College Library Databases by Subject. All Subjects - Databases by Subject - University of West Florida LibGuides at University of West Florida Libraries. A - Databases A-Z - Subjects at University of Manitoba. ABC-CLIO Solutions - Home. Map of the databases - Google Docs. Standards for the 21st-Century Learner Lesson Plan Database. Marion County - Warren Township Middle Schools - Databases. NoodleTools : MLA / APA / Chicago Bibliography Composer, Notecards, Outlining. CultureGrams: Concise, reliable, and up-to-date country reports on 200 cultures of the world. Children's subscriptions databases. Welcome to Yukon Department of Education.

Not eliminated because embedded links work.Best of the Best: Top 100 Web Resources for Educators. Best of the Best: Top 100 Web Resources for EducatorsAn Internet Hotlist on Educator Websites created by Deborah B. Ford, Director of Library OutreachJunior Library Guild Introduction | Content Resources | Collaboration | Global Education | Time and Money Savers | Digital Resources | Worth the Money Introduction Especially for teachers and librarians, award winning author, librarian, teacher and speaker, Deborah B.

Ford has gathered these 100+ (mostly free) web resources to help you make the most of your time, money, while keeping your sanity. The Internet ResourcesContent ResourcesA+ Click - Students grades K-12 can take online math practice tests at this site. ALA Youth Media Awards - Want to know more about the best books of the year? Danielson Group » The Framework. Eval_websites.pdf. BookSearch. Eval_websites.pdf. EBSCO - EBSCOhost Online Research Databases: Children's Room. Home - CRC Databases for Pre K-12 Educators and Students - Library Research Guides at University of Massachusetts Boston. New Jersey State Library - Connecting people with information through libraries.

Perspectives on Student Research Skills in K-12 and Academic Communities. Database wishlist.